数据库操作

最新推荐文章于 2023-06-23 11:10:59 发布

csdy08

最新推荐文章于 2023-06-23 11:10:59 发布

阅读量155

点赞数

本文链接：https://blog.csdn.net/csdy08/article/details/82889783

版权

$xuesheng2 = mysql_query("SELECT * FROM yks_dajuanjilu WHERE kaoShendID='$banjimingdanID[$a]' AND SJID='$SJID' ORDER BY kaishishijian ASC   ");

多条件数据查询并排序

sprintf（指的是字符串格式化命令）写数据库操作语句。

//sprintf 操作数据库的条件
 if ($_SERVER['REQUEST_METHOD'] == 'POST') { 
 $banji = $_POST["ban"];
 $SJID = $_POST["SJID"];
 
 echo "<br />---".$SJID."<br />";
 echo "<br />".$banji."<br />";
 $banji_limit =" WHERE  banji='$banji' " ;
  $SJID_limit =" AND  SJID='$SJID' " ;
 }//if ($_SERVER['REQUEST_METHOD'] == 'POST') { 

else{    

  $banji_limit =" " ; 
  $SJID ="" ;
 
  }//if ($_SERVER['REQUEST_METHOD'] == 'POST') {} else
//$banji="初二（17）";

$sql = sprintf("SELECT * FROM users  %s  " ,$banji_limit);


$xuesheng = mysql_query($sql );

<?php mysql_connect("mysql153.secureserver.net","root","password"); mysql_select_db("manongjc"); $rowID = "0001"; $name = "Kate"; $price = "12"; $query = "UPDATE Employee SET name='$name', price='$price' WHERE ID='$rowID'"; $result = mysql_query($query); if ($result) echo "<p>更新成功！</p>"; else echo "<p>更新失败。</p>"; ?>

$info=mysql_query("select * from yks_shijuan inner join yks_lanmu on yks_shijuan.SJFenLei=yks_lanmu.CID ORDER BY yks_shijuan.ChuangJianSheJian DESC limit $offset,$num "); //limit 要放在ORDER BY 后面