PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table student ( id int primary key auto_increment, student_name varchar(255), email varchar(255) unique key ); create table bill ( id int primary key auto_increment, student_id int, total_balance int, foreign key (student_id) references student(id) );
Copy Clear
Copy Format Clear
<?php $sql = "INSERT INTO MyGuests (firstname, lastname, email) VALUES ('John', 'Doe', 'john@example.com')"; if (mysqli_query($conn, $sql)) { $last_id = mysqli_insert_id($conn); echo "New record created successfully. Last inserted ID is: " . $last_id; } else { echo "Error: " . $sql . "<br>" . mysqli_error($conn); } mysqli_close($conn); ?>
Show:  
Copy Clear