mysql增删改查基本语句(精).doc

精品文档，仅供学****与交流，如有侵权请联系网站删除
【精品文档】第 2 页
mysql 增、删、改、查 基本语句
数据库的链接和选择及编码
$link=mysql_connect("localhost","root","123456" or die("数据库连接失败".mysql_error(;
$sel=mysql_select_db("login",$link or die("数据库选择失败".mysql_error(;
mysql_query("set names 'utf8'";
添加数据
$link=mysql_connect("localhost","root","123456" or die("数据库连接失败".mysql_error(;
$sel=mysql_select_db("login",$link or die("数据库选择失败".mysql_error(;
mysql_query("set names 'utf8'",$sel;
$add="insert into title(title,content,username,time values('$title','$content','$username',$time";
$query=mysql_query($add;
if($query{
echo "add sucess";
echo " ";
}
else echo "add false";
精品文档，仅供学****与交流，如有侵权请联系网站删除
【精品文档】第 3 页
删除数据
$link=mysql_connect("localhost","root","123456" or die("数据库连接失败".mysql_error(;
$sel=mysql_select_db("login",$link or die("数据库选择失败".mysql_error(;
mysql_query("set names 'utf8'";
$id=$_GET['id'];
$delete="delete from title where id='$id'";
$query=mysql_query($delete;
if($query{
echo "delete sucess!";
echo " ";
}
else echo "delete false";
改数据
$link=mysql_connect("localhost","root","123456" or die("数据库连接失败".mysql_error(;
$sel=mysql_select_db("login",$link or die("数据库选择失败".mysql_error(;
mysql_query("set names 'utf8'",$sel;
$update="update title set title='".$title."',content='".$content."