php查询、插入、删除、修改记录

最新推荐文章于 2021-04-13 16:08:14 发布

找到快乐的根源

最新推荐文章于 2021-04-13 16:08:14 发布

阅读量5k

点赞数 1

分类专栏： php+mysql系列文摘文章标签： php mysql query insert delete user

本文链接：https://blog.csdn.net/k8080880/article/details/5921634

版权

php+mysql系列文摘专栏收录该内容

143 篇文章 1 订阅

订阅专栏

插入记录

<?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 左边的那个点 ` ` 包起来，否则插入不进去！

删除记录

<?php $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 "删除记录"; ?>

查询记录

<?php $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 "<br />"; } mysql_close($con); echo "查询记录"; ?>

php修改记录

<?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 语句中给字段赋值的变量要写成这样 '{变量}'