PHP链接插入数据

来源：互联网发布：已经备案域名购买编辑：程序博客网时间：2024/05/21 09:11

<?php     $servername = "localhost:3305"; //数据库地址    $username = "root";    //数据库name    $password ="";     //密码    $dbname      ="myDB";  //要链接的数据库    $conn = new mysqli($servername,$username,$password,$dbname);    // 面向对象的链接数据方法    if($conn ->connect_error)    {        die('链接失败:' . $conn ->connect_error);    }    // 插入数据    $sql = "INSERT INTO MyGuests (firstname, lastname, email)    VALUES ('John', 'Doe', 'john@example.com');";    $sql .= "INSERT INTO MyGuests (firstname, lastname, email)    VALUES ('Mary', 'Moe', 'mary@example.com');";    $sql .= "INSERT INTO MyGuests (firstname, lastname, email)    VALUES ('Julie', 'Dooley', 'julie@example.com')";    if($conn ->multi_query($sql) === TRUE)    {        //判断 为true时 新纪录插入成功        echo "新纪录插入成功";    }else    {        echo "ERROR" . $sql . "<br>".$conn ->error;    } ?>

0 0