PHP 存取 MySQL 数据库的一个例子
[作者]:菩提树下的杨过 [来源]:互联网 [收录时间]:2007-8-1 20:10:37
<SPAN class=unnamed3><body> <br /><center> <br /><h2>PHP+MySQL 例子</h2> <br /><h3><u><font color=brown>请在文本区域输入数据并且确定 </font></u></h3> <br /><table border="0" align="left" class=ppc_download_ad_frame cellspacing=0 cellpadding=0 width="1%" style="margin-top:10px;margin-right:7px;margin-bottom:3px;margin-left:0px"> <tr> <td id=a><img height=9 width=9></td> <td id=b width="100%"><img height=1 width=1></td> <td id=c><img height=9 width=9></td> </tr> <tr> <td id=d><img height=1 width=1></td> <td id=e valign=top height="100%"><!-- frame contents --> <table cellspacing=0 cellpadding=0 border=0> <tr> <td><div id="w_hzh"></div></td> </tr> </table> <!-- /frame contents --></td> <td id=f><img height=1 width=1></td> </tr> <tr> <td id=g><img height=9 width=9></td> <td id=h><img height=1 width=1></td> <td id=i><img height=9 width=9></td> </tr> </table><form action="<? echo $PHP_SELF?>" method=POST> <br /><textarea cols=40 rows=5 name=txt></textarea> <br /><br> <br /><input type="submit" value="确定"> <br /></form> <br /><? <br /> $connect_id=mysql_connect("localhost","username","password"); <br /> if(isset($txt)) { <br /> $dbtime=date("Y-m-d H:i:s"); <br /> mysql_db_query("usernamedb","insert into test values (0,&#39;$dbtime&#39;,&#39;$txt&#39;)"); <br /> } <br />?> <br /><p> <br /></center> <br /><div align=center><center> <br /><table border=1 cellpadding=0 cellspacing=2 width=80%&gt; <br /><tr><td> <br /><? <br /> $result=mysql_db_query("usernamedb","select * from test"); <br /> while($userdb=mysql_fetch_row($result)) <br /> { <br /> echo "<".$userdb[0].">: <font color=purple>".$userdb[1]."</font> <font color=red>".$userdb[2]."</font><br>n"; <br /> } <br /> mysql_close($connect_id); <br />?> <br /></td></tr> <br /></table> <br /><p> <br /></body> <br /></html> <br /></SPAN> </div> </div>