php向Mysql数据库保存数据代码示例_PHP教程

mysql_connect("localhost","root","");//连接MySQL
mysql_select_db("mythroad");//选择数据库
?>

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 "成功录入数据";
?>

$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();
}
?>