query('SET NAMES utf8'); //导入活动信息 $sql = "SELECT * FROM activity WHERE a_id = '$activity_id'"; $rs = $pdo-&g"/> query('SET NAMES utf8'); //导入活动信息 $sql = "SELECT * FROM activity WHERE a_id = '$activity_id'"; $rs = $pdo-&g">
Home > Database > Mysql Tutorial > 服务器-每次查询都得连接一次数据库,否则不继续执行的问题。

服务器-每次查询都得连接一次数据库,否则不继续执行的问题。

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-06 09:40:34
Original
2152 people have browsed it

服务器mysqlphp数据库linux

<code>//连接数据库$pdo = new PDO("mysql:host=$db_host; dbname=$db_name", $db_username, $db_password); $pdo->query('SET NAMES utf8');//导入活动信息$sql = "SELECT * FROM activity WHERE a_id = '$activity_id'";$rs = $pdo->query($sql);while($row = $rs->fetch()){    $activity_uno=$row['u_no'];    $activity_name=$row['a_name'];}//导入用户信息$sql = "SELECT * FROM user WHERE No = '$activity_uno'";$rs = $pdo->query($sql);while($row = $rs->fetch()){    $activity_usernick=$row['Nickname'];    $activity_uservtype=$row['vtype'];    $activity_userverify=$row['verify'];}</code>
Copy after login

在本机上(WAMP环境)这样写的代码,运行结果是正常的,一次连接就可以多次查询。但是传到服务器上(LAMP),每次查询前都要连接一次数据库,否则就不会继续查询。
在服务器上改成这样才能正常:

<code> //连接数据库$pdo = new PDO("mysql:host=$db_host; dbname=$db_name", $db_username, $db_password); $pdo->query('SET NAMES utf8');//导入活动信息$sql = "SELECT * FROM activity WHERE a_id = '$activity_id'";$rs = $pdo->query($sql);while($row = $rs->fetch()){    $activity_uno=$row['u_no'];    $activity_name=$row['a_name'];}//连接数据库$pdo = new PDO("mysql:host=$db_host; dbname=$db_name", $db_username, $db_password); $pdo->query('SET NAMES utf8');//导入用户信息$sql = "SELECT * FROM user WHERE No = '$activity_uno'";$rs = $pdo->query($sql);while($row = $rs->fetch()){    $activity_usernick=$row['Nickname'];    $activity_uservtype=$row['vtype'];    $activity_userverify=$row['verify'];}</code>
Copy after login

请问问题出在哪里?如何才能像本机上测试那样一次连接多次查询?

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template