用PHP向数据库中实现简单的增删改查（纯代码，待完善）

php
    $con = mysql_connect("localhost:3306","root","");

    if (!$con) {
        die('Could not connect: ' . mysql_error());
    }

    mysql_select_db("test", $con);

    $result = mysql_query("SELECT * FROM user");

    echo "";

    while($row = mysql_fetch_array($result)) {
        echo "";
        echo "";
        echo "";
        echo "";
    }
    echo "

    

    
Username
    
Password
    
" . $row['username'] . "
" . $row['password'] . "
";

    mysql_close($con);

?>

php
    $con = mysql_connect("localhost","root","");
    if (!$con) {
        die('Could not connect: ' . mysql_error());
    }

    mysql_select_db("test", $con);

    mysql_query("DELETE FROM user WHERE username = '$_POST[username]'");

    mysql_close($con);
?>

php
    $con = mysql_connect("localhost:3306","root","");

    if (!$con) {
        die('Could not connect: ' . mysql_error());
    }

    mysql_select_db("test", $con);

    $sql = "INSERT INTO user (username,password)
    VALUES
    ('$_POST[username]','$_POST[password]')";

    if (!mysql_query($sql,$con)) {
        die('Error: ' . mysql_error());
    }

    echo "1 record added";

    mysql_close($con);

?>

php

    $con = mysql_connect("localhost","root","");
    if (!$con) {
        die('Could not connect: ' . mysql_error());
    }

    mysql_select_db("test", $con);

    mysql_query("UPDATE user SET password = '$_POST[password]' WHERE username = '$_POST[username]'");

    mysql_close($con);
?>

    
        
    
    
        

        
Insert:
        
        


        
Delete
        
        


        
Update
        
        


    

以上就介绍了用PHP向数据库中实现简单的增删改查（纯代码，待完善），包括了方面的内容，希望对PHP教程有兴趣的朋友有所帮助。