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

php链接mysql原生写法

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

abe29b6644c67db0f07dfa847096fba4.png

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

$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

947a5603f328766f86583e030d5f6a89.png

66.html

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

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


版权声明:本文为weixin_42644249原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。