mysql php查询mysql数据库prepare语句用法
php查询mysql数据库prepare语句用法 ```{php}$mysql = new mysqli(#39;localhost#39;, #39;root#39;, #39;root#39;, #39;databaseName#39;) or die(#39;There was a problem connecting to the database#39;);$stmt = $mysql-gt;prepare(#39;SELECT i
$mysql = new mysqli('localhost', 'root', 'root', 'databaseName') or die('There was a problem connecting to the database');
$stmt = $mysql->prepare('SELECT id, title, content FROM tableName');
$stmt->execute();
$stmt->bind_result($id, $title, $content);
while($row = $stmt->fetch()) : ?>
<h2> <?php echo $title; ?> </h2>
<p> <?php echo $content; ?> </p>
<?php endwhile; ?>
- 上一篇：php数组使用示例
- 下一篇：PHP 以 Post 方式请求网页数据
精彩图集
精彩文章