MySQL如何实现更新查询？(2)-木庄网络博客

2022-02-21 20:49:02 PHP中文网数据库百度已收录

使用面向对象的方法更新查询：

<?php
$mysqli = new mysqli("localhost", "root", "", "Mydb"); 
   
if($mysqli === false){ 
    die("ERROR: Could not connect. "
            . $mysqli->connect_error); 
} 
   
$sql = "UPDATE data SET Age='28' WHERE id=201"; 
if($mysqli->query($sql) === true){ 
    echo "Records was updated successfully."; 
} else{ 
    echo "ERROR: Could not able to execute $sql. " 
                                        . $mysqli->error; 
} 
$mysqli->close(); 
?>

使用PDO方法更新查询：

<?php
try{ 
    $pdo = new PDO("mysql:host=localhost; 
                    dbname=Mydb", "root", ""); 
    $pdo->setAttribute(PDO::ATTR_ERRMODE,  
                        PDO::ERRMODE_EXCEPTION); 
} catch(PDOException $e){ 
    die("ERROR: Could not connect. " 
                    . $e->getMessage()); 
} 
   
try{ 
    $sql = "UPDATE data SET Age='28' WHERE id=201"; 
    $pdo->exec($sql); 
    echo "Records was updated successfully."; 
} catch(PDOException $e){ 
    die("ERROR: Could not able to execute $sql. "
                                . $e->getMessage()); 
} 
unset($pdo); 
?>