「PHP接入SQL」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
Root​(留言 | 貢獻)
新頁面: ==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...
 
Root​(留言 | 貢獻)
第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>