这是我的PHP文件,但是我正在fatal error : undefined function mysql_connect
,我已经搜索了它,看起来我必须在PHP 7上使用PDO而不是mysql_connect,我不知道如何,所以我需要帮助,我希望这段代码作为PDO,感谢您的时间
<?php
// connection , which gives fatal exception : undefined function..
$con = mysql_connect("localhost",'root','');
//error handling
if (!$con)
{
die("Could not connected".mysql_error()); else
{
//select the DB name in PhpMyAdmin
mysql_select_db("tm-mobile",$con);
//Vlidation
if (!empty($_POST['owner_name']) && !empty($_POST['owner_email']))
{
$owner_id=$_POST['owner_id'];
$owner_name=$_POST['owner_name'];
$owner_email=$_POST['owner_email'];
$owner_password=$_POST['owner_password'];
$market_name=$_POST['market_name'];
//SQL statement
$sql = "UPDATE owner_table SET owner_id = '$owner_id',owner_name =
'$owner_name' , owner_email = '$owner_email', owner_password =
'$owner_password' , market_name = '$market_name' ";
$re = mysql_query ($sql,$con);
//Close the Connection
mysql_close();
}
}
?>
<?php
try {
$pdo = new PDO('mysql:host=localhost;dbname=testdb', 'root', 'password');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->exec('SET CHARACTER SET utf8');
if (!empty($_POST['owner_name']) && !empty($_POST['owner_email'])) {
$owner_id = $_POST['owner_id'];
$owner_name = $_POST['owner_name'];
$owner_email = $_POST['owner_email'];
$owner_password = $_POST['owner_password'];
$market_name = $_POST['market_name'];
$statement = $pdo->prepare('UPDATE `owner_table` SET `owner_id` = :owner_id, `owner_name` = :owner_name,
`owner_email` = :owner_email, `owner_password` = :owner_password, market_name = :market_name;');
$statement->bindParam(':owner_id', $owner_id, PDO::PARAM_INT);
$statement->bindParam(':owner_name', $owner_name, PDO::PARAM_STR);
$statement->bindParam(':owner_email', $owner_email, PDO::PARAM_STR);
$statement->bindParam(':owner_password', $owner_password, PDO::PARAM_STR);
$statement->bindParam(':market_name', $market_name, PDO::PARAM_STR);
$statement->execute();
echo $statement->rowCount();
}
} catch (PDOException $e) {
die('Cannot connect: ' . $e->getMessage());
}
在这里,看看一些教程,例如 http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers,并在INSERT/REPLACE/UPDATE/DELETE
查询中使用where
,因为它可能很危险