PHP 存取 MySQL 数据库的一个例子

 1<body>
 2<center>
 3<h2>PHP+MySQL 例子</h2>
 4<h3><u><font color="brown">请在文本区域输入数据并且确定 </font></u></h3>
 5<form action="&lt;? echo $PHP_SELF?&gt;" method="POST">
 6<textarea cols="40" name="txt" rows="5"></textarea>
 7<br/>
 8<input type="submit" value="确定"/>
 9</form>
10<?   
11$connect_id=mysql_connect("localhost","username","password");   
12if(isset($txt)) {   
13$dbtime=date("Y-m-d H:i:s");   
14mysql_db_query("usernamedb","insert into test values (0,'$dbtime','$txt')");   
15}   
16?>
17<p>
18</p></center>
19<div align="center"><center>
20<table border="1" cellpadding="0" cellspacing="2" width="80%">
21<tr><td>
22<?   
23$result=mysql_db_query("usernamedb","select * from test");   
24while($userdb=mysql_fetch_row($result))   
25{   
26echo "<".$userdb[0].">: <font color="purple">".$userdb[1]."</font> <font color="red">".$userdb[2]."</font><br/>n";   
27}   
28mysql_close($connect_id);   
29?&gt;   
30</td></tr>
31</table>
32<p>
33</p></center></div></body>

【本文版权归作者与奥索网共同拥有，如需转载，请注明作者及出处】