$prepared = $pdo->prepare('select nickname from user where id = :id'); $prepared->execute(array(':id' => $_GET['id'])); while ($results = $prepared->fetch(PDO::FETCH_ASSOC)) { print_r($results['nickname'] . '<br/>'); } $pdo=null; ?> 1. 2. 3. 4. 5. 6. 7. 8...
$result=mysql_query($sql); print_r('rows:' .mysql_num_rows($result) . '<br/>');while($row =mysql_fetch_array($result)) { print_r($row['nickname'] . '<br/>'); }mysql_close($con);?> 上面,注意几个细节: 1. mysql连接要关的,使用mysql_close,之前因为没关,始终有连接存在 2. ...
$pdo=newPDO("mysql:host=10.117.146.21:8306;dbname=springdemo", 'root', '[password]');$prepared = $pdo->prepare('select nickname from user where id = :id'); $prepared->execute(array(':id' => $_GET['id'])); while ($results = $prepared->fetch(PDO::FETCH_ASSOC)) {print_r($r...