php+mysql实现简单的增删改查功能
列表代码
<?php $con=mysql_connect("localhost:3306","root",""); if(!$con){ die('Couldnotconnect:'.mysql_error()); } mysql_select_db("test",$con); $result=mysql_query("SELECT*FROMuser"); echo"<tableborder='1'> <tr> <th>Username</th> <th>Password</th> </tr>"; while($row=mysql_fetch_array($result)){ echo"<tr>"; echo"<td>".$row['username']."</td>"; echo"<td>".$row['password']."</td>"; echo"</tr>"; } echo"</table>"; mysql_close($con); ?>
删除
<?php $con=mysql_connect("localhost","root",""); if(!$con){ die('Couldnotconnect:'.mysql_error()); } mysql_select_db("test",$con); mysql_query("DELETEFROMuserWHEREusername='$_POST[username]'"); mysql_close($con); ?>
添加
<?php $con=mysql_connect("localhost:3306","root",""); if(!$con){ die('Couldnotconnect:'.mysql_error()); } mysql_select_db("test",$con); $sql="INSERTINTOuser(username,password) VALUES ('$_POST[username]','$_POST[password]')"; if(!mysql_query($sql,$con)){ die('Error:'.mysql_error()); } echo"1recordadded"; mysql_close($con); ?>
修改
<?php $con=mysql_connect("localhost","root",""); if(!$con){ die('Couldnotconnect:'.mysql_error()); } mysql_select_db("test",$con); mysql_query("UPDATEuserSETpassword='$_POST[password]'WHEREusername='$_POST[username]'"); mysql_close($con); ?>
<html> <head> <title>用PHP向数据库中实现简单的增删改查</title> </head> <body> <br/> <h1>Insert:</h1> <formaction="insert.php"method="post"> username:<inputtype="name"name="username"/> <br/> password:<inputtype="password"name="password"/> <inputtype="submit"value="submit"/> </form> <br/><hr/><br/> <h1>Delete</h1> <formaction="delete.php"method="post"> username:<inputtype="name"name="username"/> <br/> Areyousure?<inputtype="submit"value="sure"/> </form> <br/><hr/><br/> <h1>Update</h1> <formaction="update.php"method="post"> username:<inputtype="name"name="username"/> <br/> Youwanttochangeyourpasswordinto:<inputtype="password"name="password"/> <inputtype="submit"value="submit"/> </form> <br/><hr/><br/> </body> </html>
以上所述就是本文的全部内容了,希望大家能够喜欢。