自動成長IDmysqli関数の取得

2681 ワード

php
    $mysqli=@new mysqli("localhost", "root", "123456", "xsphpdb");
    
    if(mysqli_connect_errno()){
        echo "       :".mysqli_connect_error();
        $mysqli=null;
        exit;
    }


    //select  (   ),  select  ,     

    $sql="insert into shops(name,price,num,desn) values('hello','34.56','22','good123')";
    //$sql="delete from shops where id > '80'";

    $result=$mysqli->query($sql);
    
    if(!$result){
        echo "SQL    
"; echo "ERROR:".$mysqli->errno."|".$mysqli->error; exit; } if($mysqli->affected_rows > 0){ echo "
"; } echo " ID:".$mysqli->insert_id; $mysqli->close();