THANKS
this article is great and easy t0 learn
-- -------------------------------------------------------- -- -- Table structure for table `tbl_registration` -- CREATE TABLE `tbl_registration` ( `tbl_registration_id` INT(11) NOT NULL, `first_name` VARCHAR(100) NOT NULL, `middle_name` VARCHAR(100) NOT NULL, `last_name` VARCHAR(100) NOT NULL, `email` VARCHAR(100) NOT NULL, `contact_number` VARCHAR(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
<?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "add_query_pdo"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { } $first_name=$_POST['first_name']; $middle_name=$_POST['middle_name']; $last_name=$_POST['last_name']; $email=$_POST['email']; $contact_number=$_POST['contact_number']; $sql = "INSERT INTO tbl_registration (first_name, middle_name, last_name, email, contact_number) VALUES ('$first_name', '$middle_name', '$last_name', '$email', '$contact_number')"; if ($conn->query($sql) === TRUE) { $last_id = $conn->insert_id; echo "New record created successfully. Last inserted ID is: " . $last_id; } else { echo "Error: " . $sql . "<br>" . $conn->error; } $conn->close(); ?>
<?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "add_query_pdo"; // Create connection // Check connection if (!$conn) { } $first_name=$_POST['first_name']; $middle_name=$_POST['middle_name']; $last_name=$_POST['last_name']; $email=$_POST['email']; $contact_number=$_POST['contact_number']; $sql = "INSERT INTO tbl_registration (first_name, middle_name, last_name, email, contact_number) VALUES ('$first_name', '$middle_name', '$last_name', '$email', '$contact_number')"; echo "New record created successfully. Last inserted ID is: " . $last_id; } else { } ?>
<?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "add_query_pdo"; try { $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $first_name=$_POST['first_name']; $middle_name=$_POST['middle_name']; $last_name=$_POST['last_name']; $email=$_POST['email']; $contact_number=$_POST['contact_number']; $sql = "INSERT INTO tbl_registration (first_name, middle_name, last_name, email, contact_number) VALUES ('$first_name', '$middle_name', '$last_name', '$email', '$contact_number')"; // use exec() because no results are returned $last_id = $conn->lastInsertId(); echo "New record created successfully. Last inserted ID is: " . $last_id; } catch(PDOException $e) { echo $sql . "<br>" . $e->getMessage(); } $conn = null; ?>