连接数据库并显示前五条记录代码,PHP代码库,德仔网

代码语言
代码分类
【PHP】连接数据库并显示前五条记录
作者:Dezai.CN / 发布于2011/6/11/ 870
<div><span style="color: rgb(0,0,0); font-weight: bold"><?php</span>

<span style="color: rgb(0,0,255)">$username</span> = <span style="color: rgb(255,0,0)">"your_username"</span>;
<span style="color: rgb(0,0,255)">$password</span> = <span style="color: rgb(255,0,0)">"your_password"</span>;
<span style="color: rgb(0,0,255)">$db</span> = <span style="color: rgb(255,0,0)">"database_name"</span>;

<span style="font-style: italic; color: rgb(128,128,128)">//for anyone with a local server the $host can be set to "localhost" or "127.0.0.1"</span>
<span style="color: rgb(0,0,255)">$host</span> = <span style="color: rgb(255,0,0)">"host_address"</span>;

<span style="color: rgb(0,0,255)">$db_connection</span> = <a href="http://www.php.net/mysql_connect" target="_blank"><span style="color: rgb(0,0,102)">mysql_connect</span></a><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$host</span>, <span style="color: rgb(0,0,255)">$username</span>, <span style="color: rgb(0,0,255)">$password</span><span style="color: rgb(102,204,102)">)</span> or <a href="http://www.php.net/die" target="_blank"><span style="color: rgb(0,0,102)">die</span></a><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(255,0,0)">"Could not connect"</span><span style="color: rgb(102,204,102)">)</span>;

<span style="color: rgb(0,0,255)">$MySQLSelectedDB</span> = <a href="http://www.php.net/mysql_select_db" target="_blank"><span style="color: rgb(0,0,102)">mysql_select_db</span></a><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$db</span>, <span style="color: rgb(0,0,255)">$db_connection</span><span style="color: rgb(102,204,102)">)</span> or <a href="http://www.php.net/die" target="_blank"><span style="color: rgb(0,0,102)">die</span></a><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(255,0,0)">"Could not set the Database"</span><span style="color: rgb(102,204,102)">)</span>;

<span style="color: rgb(0,0,255)">$res</span>=<a href="http://www.php.net/mysql_query" target="_blank"><span style="color: rgb(0,0,102)">mysql_query</span></a><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(255,0,0)">"SELECT * FROM table_name LIMIT 5"</span><span style="color: rgb(102,204,102)">)</span>;

<span style="font-style: italic; color: rgb(128,128,128)">//check that there is something in the table to display</span>
<span style="color: rgb(177,177,0)">if</span> <span style="color: rgb(102,204,102)">(</span><a href="http://www.php.net/mysql_num_rows" target="_blank"><span style="color: rgb(0,0,102)">mysql_num_rows</span></a><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$res</span><span style="color: rgb(102,204,102)">)</span>==<span style="color: rgb(204,102,204)">0</span><span style="color: rgb(102,204,102)">)</span> <span style="color: rgb(102,204,102)">{</span>
<a href="http://www.php.net/echo" target="_blank"><span style="color: rgb(0,0,102)">echo</span></a> <span style="color: rgb(255,0,0)">"There is no data in the table"</span>;

<span style="color: rgb(102,204,102)">}</span> <span style="color: rgb(177,177,0)">else</span> <span style="color: rgb(102,204,102)">{</span>

<span style="font-style: italic; color: rgb(128,128,128)">//extract the data and print it out with a simple echo for each field</span>
<span style="color: rgb(177,177,0)">for</span><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$i</span>=<span style="color: rgb(204,102,204)">0</span>; <span style="color: rgb(0,0,255)">$i</span><mysql_num_rows<span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$res</span><span style="color: rgb(102,204,102)">)</span>; <span style="color: rgb(0,0,255)">$i</span>++<span style="color: rgb(102,204,102)">)</span> <span style="color: rgb(102,204,102)">{</span>

<span style="color: rgb(0,0,255)">$row</span>=<a href="http://www.php.net/mysql_fetch_assoc" target="_blank"><span style="color: rgb(0,0,102)">mysql_fetch_assoc</span></a><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$res</span><span style="color: rgb(102,204,102)">)</span>;

<a href="http://www.php.net/echo" target="_blank"><span style="color: rgb(0,0,102)">echo</span></a> <span style="color: rgb(255,0,0)">"Field 1 : $row[field_1] Field 2 : $row[field_2] Field 3 : $row[field_3] </BR>"</span>;

<span style="color: rgb(102,204,102)">}</span>
<span style="color: rgb(102,204,102)">}</span>

<span style="font-style: italic; color: rgb(128,128,128)">//close connection</span>
<a href="http://www.php.net/mysql_close" target="_blank"><span style="color: rgb(0,0,102)">mysql_close</span></a><span style="color: rgb(102,204,102)">(</span><span style="color: rgb(0,0,255)">$db_connection</span><span style="color: rgb(102,204,102)">)</span>;

<span style="color: rgb(0,0,0); font-weight: bold">?></span>
</div>
评论列表
本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。
试试其它关键字
　连接数据库　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)