php連接mysql數(shù)據(jù)庫(kù)代碼
書山有路勤為徑，學(xué)海無(wú)涯苦作舟。學(xué)習(xí)PHP就要勤奮。下面是php連接mysql數(shù)據(jù)庫(kù)代碼，歡迎閱讀參考！
<?php
$mysql_server_name="localhost"; /pic/pic/pic/pic/pic/pic/div>
/pic/div>
$result=mysql_db_query($mysql_database, $strsql, $conn);/pic/div>
echo '<table border="1" cellpadding="1" cellspacing="2">';/pic/div>
mysql_field_name($result, $i);
echo "</b></td>\n";
}
echo "</tr>\n";
/pic/div>
mysql_data_seek($result, 0);
/pic/div>
while ($row=mysql_fetch_row($result))
{
echo "<tr>\n";
for ($i=0; $i<mysql_num_fields($result); $i++ ){echo '<td bgcolor="#00FF00">';echo "$row[$i]";
echo '</td>';
}
echo "</tr>\n";
}
echo "</table>\n";
echo "</font>";
/pic/div>
mysql_free_result($result);
/pic/div>
mysql_close();
?>
-------------------------------------------------------------------------------------
<?php$link = mysql_connect("mysql_host", "mysql_user", "mysql_password") or die("Could not connect");print "Connected successfully";mysql_select_db("my_database") or die("Could not select database");$query = "SELECT * FROM my_table";$result = mysql_query($query) or die("Query failed");print "<table>\n";while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print "\t<tr>\n"; foreach ($line as $col_value) { print "\t\t<td>$col_value</td>\n"; } print "\t</tr>\n"; } print "</table>\n";mysql_free_result($result);mysql_close($link);?>
-------------------------------------------------------------------------------------
代碼單獨(dú)存為一個(gè)文件conn.php,在以后要用到這些代碼時(shí)只要include這個(gè)頁(yè)面就可以了.如add.php這個(gè)頁(yè)面要要添加數(shù)據(jù)入數(shù)據(jù)庫(kù),那么在add.php里include "conn.php";
【php連接mysql數(shù)據(jù)庫(kù)代碼】相關(guān)文章：
用PHP連接MySQL代碼的參數(shù)說(shuō)明07-10
php入門之連接mysql數(shù)據(jù)庫(kù)11-16
PHP對(duì)數(shù)據(jù)庫(kù)MySQL的連接操作12-02
PHP腳本測(cè)試連接MySQL數(shù)據(jù)庫(kù)12-07
PHP向MySQL數(shù)據(jù)庫(kù)保存數(shù)據(jù)代碼03-21
php向Mysql數(shù)據(jù)庫(kù)保存數(shù)據(jù)的代碼08-26
如何在PHP中連接MySQL數(shù)據(jù)庫(kù)07-11
PHP與MYSql連接與查詢11-30