原声链接mysql_php链接mysql原生写法

php链接mysql原生写法

龙行    MySql    2018-11-9    2294    0评论

好久没用都忘了,网上找了个不用框架的原生写法,做个记录水水更健康

$mysql_conf = array(

'host' => '127.0.0.1:3306',

'db' => 'txcms',

'db_user' => 'root',

'db_pwd' => 'root',

);

$mysqli = @new mysqli($mysql_conf['host'], $mysql_conf['db_user'], $mysql_conf['db_pwd']);

if ($mysqli->connect_errno) {

die("could not connect to the database:\n" . $mysqli->connect_error);//诊断连接错误

}

$mysqli->query("set names 'utf8';");//编码转化

$select_db = $mysqli->select_db($mysql_conf['db']);

if (!$select_db) {

die("could not connect to the db:\n" . $mysqli->error);

}

$sql = "select id,username from user where nickname='张飞';"; //查询user表

$res = $mysqli->query($sql);

if (!$res) {

die("sql error:\n" . $mysqli->error);

}

while($row = $res->fetch_assoc()){

echo '

';

var_dump($row);

}

$res->free();

$mysqli->close();

都被框架洗脑了,最基本的还是要弄好

评论一下

赞助站长

赞助站长X

版权申明：此文如未标注转载均为本站原创，自由转载请表明出处《龙行博客》。

本文网址：https://www.liaotaoo.cn/66.html