php中修改记录的语句,php查询、插入、删除、修改记录

插入记录

$my_con = mysql_connect("127.0.0.1","userName","pwd");

mysql_select_db("yuding_renshu",$my_conn);

$xianlu_name=$_POST[xianlu_name];

$xianlu_id=$_POST[xianlu_id];

$yuding_renshu_riqi=$_POST[day];

$yuding_renshu_num=$_POST[yuding_renshu_num];

$sql ="INSERT INTO    yuding_renshu(`xianlu_id`,`xianlu_name`,`yuding_renshu_riqi`,`yuding_renshu_num`) VALUES('$xianlu_id','$xianlu_name','$yuding_renshu_riqi','$yuding_renshu_num')";

mysql_query($sql);     mysql_close($my_con);

备注：values 里面的数据如果是变量，则用引文单引号    '    '     包起来，如果是字符串，则用引文双引号    "     "    包起来；

数据表里面的字段则要用数字键1 左边的那个点    `    ` 包起来，否则插入不进去！

删除记录

$con = mysql_connect("127.0.0.1","userName","pwd");

mysql_select_db("db_cencencen", $con);

$result = mysql_query("DELETE FROM lvcha_user WHERE id=1");

mysql_close($con);

echo "删除记录";

?>

查询记录

$con = mysql_connect("127.0.0.1","userName","pwd");

mysql_select_db("db_cencencen", $con);

$result = mysql_query("SELECT * FROM lvcha_user");

while($row = mysql_fetch_array($result))

{

echo $row['id'] . " " . $row['userName'];

echo "
";

}

mysql_close($con);

echo "查询记录";

?>

php修改记录

$jiesuan=$_POST[jiesuan]; $dd_day2=$_POST[day2];$dd_crrs=$_POST[crrs];

$con = mysql_connect("127.0.0.1","userName","pwd");mysql_select_db("db_cencencen", $con);

mysql_query("UPDATE dingdan    SET    jiesuan='{$jiesuan}',dd_day2='{$dd_day2}',dd_crrs='{$dd_crrs}'    WHERE    dd_id='{$_POST[dd_id]}' ") ;

mysql_close($con);?>

update 语句中 给字段赋值的变量要写成这样        '{变量}'