开发者

How to write in pdo method

开发者 https://www.devze.com 2022-12-23 01:30 出处:网络
How to rewrite this in pdo: $con = mysql_connect(\"localhost:\".$LOCAL_DB_PORT, $LOCAL_DB_USER, $LOCAL_DB_PASS);

How to rewrite this in pdo:

 $con = mysql_connect("localhost:".$LOCAL_DB_PORT, $LOCAL_DB_USER, $LOCAL_DB_PASS);
 mysql_select_db("x开发者_JS百科news", $con);
 mysql_query("set names utf8", $con);


What about something like this :

$db = new PDO('mysql:dbname=xnews;host=localhost;port=' . $LOCAL_DB_PORT, $LOCAL_DB_USER, $LOCAL_DB_PASS);
$db->query('set names utf8');


To open a connection, you have to instanciate PDO, using its constructor, which receives a DSN as first parameter.

And, then, to send queries, you can use the PDO::query method.


Or, for the UTF-8 part, maybe you could use the fourth parameter to PDO::__construct, like this :

$db = new PDO('mysql:dbname=xnews;host=localhost;port=' . $LOCAL_DB_PORT, 
          $LOCAL_DB_USER, 
          $LOCAL_DB_PASS, 
          array(PDO::MYSQL_ATTR_INIT_COMMAND =>  "SET NAMES 'UTF8'")
      );

See the list of specific stuff for the MySQL Driver, amongst which there is this one :

PDO::MYSQL_ATTR_INIT_COMMAND

Command to execute when connecting to the MySQL server. Will automatically be re-executed when reconnecting.

0

精彩评论

暂无评论...
验证码 换一张
取 消