「PHP接入SQL」:修訂間差異
跳至導覽
跳至搜尋
新頁面: ==PDO== <php> $dbh = new PDO(DB_TYPE.':host='.DB_HOST.';dbname='.DB_NAME, DB_USER, DB_PASSWD); $sth = $dbh->prepare('update db set zh_CN= :str where SN=:SN'); $sth->bindParam(':str',$s... |
|||
| 第1行: | 第1行: | ||
==PDO== | ==PDO== | ||
<php> | <php> | ||
define('DB_NAME','test'); | |||
define('DB_USER','test'); | |||
define('DB_PASSWD','test'); | |||
define('DB_HOST','localhost'); | |||
define('DB_TYPE','mysql'); | |||
$dbh = new PDO(DB_TYPE.':host='.DB_HOST.';dbname='.DB_NAME, DB_USER, DB_PASSWD); | $dbh = new PDO(DB_TYPE.':host='.DB_HOST.';dbname='.DB_NAME, DB_USER, DB_PASSWD); | ||
$sth = $dbh->prepare('update db set zh_CN= :str where SN=:SN'); | $sth = $dbh->prepare('update db set zh_CN= :str where SN=:SN'); | ||
於 2016年2月8日 (一) 19:46 的修訂
PDO
<php> define('DB_NAME','test'); define('DB_USER','test'); define('DB_PASSWD','test'); define('DB_HOST','localhost'); define('DB_TYPE','mysql'); $dbh = new PDO(DB_TYPE.':host='.DB_HOST.';dbname='.DB_NAME, DB_USER, DB_PASSWD); $sth = $dbh->prepare('update db set zh_CN= :str where SN=:SN'); $sth->bindParam(':str',$str,PDO::PARAM_STR,12); $sth->bindParam(':SN',$SN); $sth->execute(); </php> <php> $sth = $dbh->prepare('select * from db where SN = :SN'); $sth->bindParam(':SN',$value[SN]); $sth->execute(); while($meta = $sth->fetch(PDO::FETCH_ASSOC)) { echo $meta["name"]; } </php>