自動成長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();