php开发中sql语句拼接示例
666
1.插入语句 $sql="insert into Ad(AdClassID,AdType) values('".$AdClassID."','".$AdType."')"; 2.从数据库中选出数据 $sql = "select * from AdClass order by ID desc";
$sql = "select * from admin where AdminID='".$_SESSION['AdminID']."'"; 3.更新数据库中记录数据 $sql="update Ad set AdClassID='".$AdClassID."' where ID='".$ID."'";
//查询 $sql = "select * from comment where comment_id = ".$comment_fid; 或: $sql = "select * from comment where comment_id = '".$comment_fid."'"; //需要注意 这些引号问题
|
666