如何将此PHP代码转换为PDO形式,因为我在PHP 7(使用XAMPP)中获得了未定义的函数


how to translate this PHP code to PDO form , because i am getting undefined function in PHP 7 (using XAMPP)?

这是我的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,因为它可能很危险