Insert data into multiple table using PHP

Question

I am trying to add data into 2 tables using PHP

My PHP code: insert.php

<?php session_start(); $db['host'] = "dbhost"; $db['user'] = "user"; $db['pass'] = "pass"; $db['name'] = "dbname"; //making an array with the data recieved $data = array('f_name' => $_POST['txt_f_name'], 'l_name' => $_POST['txt_l_name'], 'VNum' => $_POST['txtVisaNo']); try { // preparing database handle $dbh $dbh = new PDO("mysql:host=".$db['host']."; dbname=".$db['name']."", $db['user'], $db['pass']); // set the PDO error mode to exception $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $insertall = "BEGIN; " . "INSERT INTO students (f_name, l_name) " . "VALUES (:f_name, :l_name); " . "INSERT INTO visa (students_id, VNum) " . "VALUES (:LAST_INSERT_ID(), :VNum); " . "$addStdInf->execute($data); " . "COMMIT;"; $addStdInf = $dbh->prepare($insertall); echo 'Success!'; } catch(PDOException $e){ echo $sql,'<br />', $e->getMessage(); } $dbh = null; ?>

Notice is "Success!" but it inserted nothing into database, please guide me the ERROR.Thank you.

You prepare the statement but never execute the query. php.net/manual/en/pdostatement.execute.php — user3849602
– user3849602, Commented May 7, 2015 at 11:08

vakata · Accepted Answer · 2015-05-07 11:06:16Z

4

You are only preparing the statement - you never execute it. After the prepare call you receive a ready to execute statement, if you execute it with some parameters, it will be inserted in the database: http://php.net/manual/en/pdostatement.execute.php

answered May 7, 2015 at 11:06

vakata

3,8961 gold badge19 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

symcbean Over a year ago

You also need to check the return value from execute() before declaring success - and be aware that there are some problems with issuing multiple SQL statements in a single API call - see also stackoverflow.com/questions/6346674/…

Jagadeesh · Accepted Answer · 2015-05-07 12:33:55Z

You are forget to execute your pdo statements

<?php session_start(); $db['host'] = "dbhost"; $db['user'] = "user"; $db['pass'] = "pass"; $db['name'] = "dbname"; //making an array with the data recieved $data = array('f_name' => $_POST['txt_f_name'], 'l_name' => $_POST['txt_l_name'], 'VNum' => $_POST['txtVisaNo']); try { // preparing database handle $dbh $dbh = new PDO("mysql:host=".$db['host']."; dbname=".$db['name']."", $db['user'], $db['pass']); // set the PDO error mode to exception $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $insertall = "BEGIN; " . "INSERT INTO students (f_name, l_name) " . "VALUES (:f_name, :l_name); " . "INSERT INTO visa (students_id, VNum) " . "VALUES (:LAST_INSERT_ID(), :VNum); " . "$addStdInf->execute($data); " . "COMMIT;"; $addStdInf = $dbh->prepare($insertall); $result = $addStdInf->execute(); if ($result) { echo 'Success!'; } else { echo 'please check'; } } catch(PDOException $e){ echo $sql,'<br />', $e->getMessage(); } $dbh = null; ?>

Collectives™ on Stack Overflow

Insert data into multiple table using PHP

2 Answers 2

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Linked

Related