<?php
mysql_connect("localhost","root","");//連接MySQL
mysql_select_db("mythroad");//選擇數據庫
?>

<?php
require_once("conn.php");//引用數據庫鏈接文件
$uname = $_GET['n'];//GET方法為URL參數傳遞
$pwd = $_GET['p'];
$pwd =md5($pwd );//直接使用MD5加密
$sql = "insert into mythroad(username,password) values ('$uname','$pwd')";
mysql_query($sql);//借SQL語句插入數據
mysql_close();//關閉MySQL連接
echo "成功錄入數據";
?>

<?php
$conn = @mysql_connect("localhost","root","root123");
if (!$conn){
die("連接數據庫失敗：" . mysql_error());
}

mysql_select_db("test", $conn);
mysql_query("set names 'gbk'");

$sql = "UPDATE user SET email = 'xiaoming@163.com' WHERE username = '小明'";
if(mysql_query($sql,$conn)){
echo "更新數據成功！";
} else {
echo "更新數據失敗：".mysql_error();
}
?>