insert data and get last id

 $sql = "INSERT INTO MyGuests (firstname, lastname, email)

VALUES ('John', 'Doe', 'john@example.com')";

$last_id = mysqli_insert_id($conn);

Comments

Post a Comment

Popular posts from this blog

jQuery check for file extension before uploading

ใช้ jQuery ตรวจสอบประเภทไฟล์ก่อน Upload  HTML < input type = "file" id= "FilUploader" /> jQuery $( "#FilUploader" ).change( function ( ) { var fileExtension = [ 'jpeg' , 'jpg' , 'png' , 'gif' , 'bmp' ]; if ($.inArray($( this ).val().split( '.' ).pop().toLowerCase(), fileExtension) == -1 ) { alert( "Only formats are allowed : " +fileExtension.join( ', ' )); } });
Read more