PHP常用连接MYSQL方式

点击(此处)折叠或打开

1. <?php
   
2. header("Content-Type:text/html;charset=utf8");
   
3. // PDO
   
4. //1:
   
5. try{
   
6.     $pdo=@new PDO('mysql:host=localhost;dbname=sakura','root','root');
   
7. }catch(PDOException $e){
   
8.     echo $e->getMessage();
   
9. }
   
10. // PDO判断SQL执行结果
    
11. $sql="delete from songs where id=9";
    
12. $res=$pdo->exec($sql);
    
13. if($res===false){
    
14. // echo $pdo->errorCode();
    
15.     $errInfo=$pdo->errorInfo();
    
16.     print_r($errInfo);
    
17. }
    
18. 
    
19. // ---------------------------------------分割线------------------------------------------------
    
20. // mysqli
    
21. $mysqli=@new mysqli('localhost','root','root','sakura',3306);
    
22. if($mysqli->connect_errno){
    
23.     die('Connect Error:'.$mysqli->connect_error);
    
24. }
    
25. $sql="delete from songs where id=9";
    
26. if(!($mysqli->query($sql))){
    
27.     echo $mysqli->error;
    
28. }