ThinkPHP有时候也用下原生查询，链接数据库，sql语句查询表，条件判断

3778 阅读 0 评论 2 点赞

PHP原生查询，链接数据库，sql语句查询表，条件判断。

//链接数据库

$cons = mysqli_connect("localhost","username","password","dbname");

if (!$cons) {

exit('error('.mysqli_connect_errno().'):'.mysqli_connect_error());

}

$query = 'select uid from tp_user where url="'.$domain.'" limit 0,1';

$data = mysqli_query($cons, $query);

if ($data) {

$data = mysqli_fetch_array($data);

}

//释放资源、关闭连接

mysqli_free_result($data );

mysqli_close($cons);

点赞(2) 打赏

ThinkPHP有时候也用下原生查询，链接数据库，sql语句 查询表，条件判断