整理下日前学习 php 连接数据库并输出数据的代码:
php7 版本:
<?php @header('Content-type: text/html;charset=UTF-8'); $mysqli=new mysqli("localhost","root","","tb"); mysqli_query($mysqli,'SET NAMES utf8'); /* check connection */ if ( mysqli_connect_errno ()) { printf ( "Connect failed: %s\n" , mysqli_connect_error ()); exit(); } $limit = 50; $list=''; $query = "SELECT * FROM items LIMIT ".$limit ; $result = $mysqli -> query ( $query ); while($row = $result -> fetch_array ( MYSQLI_ASSOC )){ $name = $row["itemtitle"]; //将数据从数组取出 $price = $row["itemprice"]; $url = $row["itemurl"]; $img = $row["itemimg"]; $list .='<article class="excerpt excerpt-c5"><a class="thumbnail" href="'.$url.'" target="_blank"><a data-fancybox="gallery" href="'.$img.'"title="PHP 连接并输出数据库数据实例代码" ><img class="aligncenter size-full wp-image" src="'.$img.'" alt="PHP 连接并输出数据库数据实例代码" /></a><div class="zdy">'.$price.'</div></a><h2>'.$name.'</h2></article>'; } /* free result set */ $result -> free (); /* close connection */ $mysqli -> close (); ?>
php5 版本
<?php $link=mysql_connect("localhost","",""); MySQL_query("SET NAMES 'gbk'"); $my_db = mysql_select_db(test,$link); $sql = "select * from books"; $result = mysql_query($sql, $link); // 执行查询语句 while ($bookInfo = mysql_fetch_array($result)){ //返回查询结果到数组 $name = $bookInfo["name"]; //将数据从数组取出 $price = $bookInfo["price"]; $isbn = $bookInfo["ISBN"]; echo "<li>《".$name."》</br>价格:".$price."</br>ISBN:".$isbn."</li>"; //输出数据 } mysql_free_result($result); mysql_close($link); ?>