PHP对数据库的增删改

最新推荐文章于 2023-05-30 00:47:04 发布

原创最新推荐文章于 2023-05-30 00:47:04 发布 · 231 阅读

CC 4.0 BY-SA版权

<?php
$host = "127.0.0.1";
$userName = "root";
$password = "*******";
$dbName = "usersdb";
$connID = mysqli_connect($host,$userName,$password);
if(mysqli_select_db($connID,$dbName)){
    echo "数据库连接成功！";
}else{
    echo "数据库连接失败！";
}
if(mysqli_select_db($connID,$dbName)){
    echo "数据库选择成功！";
}else{
    echo"数据库选择成功！";
}
$result=mysqli_query($connID,"insert into usersdb_register values('zhansa','123','737515@qq.com','1')");
$result=mysqli_query($connID,"update usersdb_register set tel='17213724377',password='456' where id='zhansan'");
$result=mysqli_query($connID,"delete from usersdb_login where id='zhansan'");