php连接sql语句怎么写( 二 ) _语句

*/
$a = '';
$b = '';
$c = '';
$d = '';
$sql = "SELECT * from `table`";
if(!empty($a)) $sql = $sql."WHER `name` like '%1%'";
if(!empty($a))
{
if(!empty($b)) $sql = $sql."AND `id`='2'";
}else
{
if(!empty($b)) $sql = $sql."WHERE `id`='2'";
}
if(!empty($a))
{
if(!empty($c)) $sql = $sql."AND `content` like '%3%'";
}else
{
if(!empty($c)) $sql = $sql."WHERE `content` like '%3%'";
}
?>
5.帮忙写一个PHP,连接mysql数据库的一个类,实现连接,执行sql语句<?phpclass mysql{public $mysql;
function mysql($sql1='',$sql2='',$sql3='',$sql4=""){
$conn = @mysql_connect($sql1,$sql2,$sql3) or die（"错误：".mysql_error());mysql_select_db($sql4,$conn);mysql_query("set names 'GBK'");
}function query($sqlsql=''){$sqlsql=$sqlsql;$jg=mysql_query($sqlsql);
}
}
?>
以上连接数据库
<?php include('conn.php');if($_POST[ss]){$qsql=new mysql();$qsql->mysql('localhost','root','','mdb');$sqll="SELECT * FROM `jyc` WHERE `用户名` LIKE '%$_POST[ss]%'";$qsql->query($sqll);while($aa==mysql_fetch_array($jg)){
echo '<br>ID:'.$aa[id].'<br>';echo '用户：'.$aa['用户名']；}
}
?>
以上查询操作
6.php 连接oracle数据库语句怎么写php教程连接oracle数据库教程代码
$conn = OCILogon("scott","tiger"，"你的oracle数据库名字")；
$stmt = OCIParse($conn,"select empno, ename from emp");
OCIDefineByName($stmt,"EMPNO",&$empno);
OCIDefineByName($stmt,"ENAME",&$ename);
OCIExecute($stmt);
while (OCIFetch($stmt)) {
echo "empno:".$empno."n";
echo "ename:".$ename."n";
}
OCIFreeStatement($stmt);
OCILogoff($conn);
【php连接sql语句怎么写】

文章插图