PHP 使用PDO連線mysql

php pdo function

• connect
  

  $dsn = "mysql:host=localhost;dbname=$dbname";
  $pdo = new PDO($dsn, "root", $passwd);
  $pdo->query('set names utf8;');
  

• sql
  • select
    

    $rs = $pdo -> prepare($sql); //編譯,最佳化sql但不執行 避免sql injection
    $rs -> execute(); //執行sql
    //讀取所有資料
    while($row=$rs->fetchAll()){ 
       print_r($row);
    }
    $num=$rs->rowCount(); //讀取資料筆數
    

  • insert, update, delete
    

    $rs = $pdo -> prepare("insert into test(col1,col2) values(?,?)"); //編譯,最佳化sql但不執行 避免sql injection
    $rs -> execute(array($val1,$val2)); //執行sql
    

• debug
  

  if ($rs->errorCode()!=00000)
         print_r($rs->errorInfo());

• 
  
• prepare
  http://blog.yam.com/csylvia/article/72659816
  http://tw2.php.net/manual/en/pdo.prepare.php
• mysql,mysqli,pdo
  http://blog.roga.tw/2010/06/%E6%B7%BA%E8%AB%87-php-mysql-php-mysqli-pdo-%E7%9A%84%E5%B7%AE%E7%95%B0/
• pdo
  http://blog.xuite.net/janet.jaja/1/103663034-PDO+(PHP+Data+Object)+%E7%B0%A1%E6%98%93%E6%95%99%E5%AD%B8
  http://fanli7.net/a/shujuku/Mysql/20130124/296530.html
• rowcount
  http://php.net/manual/en/pdostatement.rowcount.php
• errorInfo
  http://php.net/manual/en/pdo.errorinfo.php
• session
  http://www.webtech.tw/info.php?tid=33