mysql php链接,PHP链接MySQL数据库

1.链接数据库：

$conn = @mysql_connect("localhost", "-u", "-p") or die("数据库链接错误");

mysql_select_db("数据库名", $conn);

mysql_query("set names 'UTF8'");

?>

2.查询：

include("connection.php");

$username=$_COOKIE['username'];

$sql="select * from message where user='$username'";

$query=mysql_query($sql);

while($row=mysql_fetch_array($query)){}

?>

3.增加：

include("connection.php");

if(isset($_POST['submit']))

{

$sql="insert into message(id,user,title,content,lastdate) values('','$_COOKIE[username]','$_POST[title]','$_POST[content]',now())";

mysql_query($sql);

if(mysql_affected_rows($conn))

echo "";

else

echo "";

}

?>

4.删除：

include("connection.php");

if(isset($_POST['tid']))

{

$delete_sql = "delete from message where id =$_POST[tid]";

mysql_query($delete_sql);

if(mysql_affected_rows($conn))

echo "";

else

echo "";

}

?>

5.更新：

include("connection.php");

if(isset($_POST['submit']))

{

$sql="update message set title='$_POST[title]',content='$_POST[content]',lastdate=now() where id =$_POST[tid]";

mysql_query($sql);

if(mysql_affected_rows($conn))

echo "";

else

echo "";

}

?>