我是mysql的新手,我写了这个php脚本,它在mysql数据库表中创建了一个新行,它工作得很好,但它添加了这行,不管它的存在。我需要的是我的脚本检查"用户名"列在表中,如果我们没有这样的用户名添加整个行到表中,如果我们有这样的用户名只是更新"分钟"列。谢谢。
<?PHP
$user_name = "root";
$password = "12345i";
$server = "localhost";
$database = "maz_database";
$db_handle = mysql_connect($server, $user_name, $password);
$db_found = mysql_select_db($database, $db_handle);
if ($db_found) {
$SQL = "INSERT INTO maz_table (Username,Password,Email_address,Address,Minutes,Tags) VALUES('maz','pass','maz@yahoo.com','london',2000,'')";
$result = mysql_query($SQL);
mysql_close($db_handle);
print "Records added to the database";
}
else {
print "Database NOT Found ";
mysql_close($db_handle);
}
?>
您需要添加ON DUPLICATE KEY UPDATE
来指定当记录已经存在时该如何处理。
的例子:
INSERT INTO maz_table (Username,Password,Email_address,Address,Minutes,Tags)
VALUES ('maz','pass','maz@yahoo.com','london',2000,'')
ON DUPLICATE KEY UPDATE Minutes = $minutesvariable