Databases
StackOverflow2013
Postsdbo
POinsert into 3 different table using pdo and mysql
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POinsert into 3 different table using pdo and mysql
    primarykey
    data
    text
    <p>I am using php mysql , I am trying to insert into 3 different tables but the third table do not receive values and this is the last table .The Idea is I want to get the user_id inserted in all tables at the point of creating a new account of the user so that when I want to update other fields I will just refer to that user_id which is a foreign key in those other tables . Bellow is my code :</p> <pre><code>&lt;?php #connect to the db require_once('db.inc.php'); ?&gt; &lt;?php $date_created = date('y-m-d h:i:s a'); $username = (isset($_POST['username'])) ? trim($_POST['username']): ''; $Previllage =(isset($_POST['Previllage']))? trim($_POST['Previllage']): ''; #second tanble values $title=(isset($_POST['title']))? trim($_POST['title']): ''; $firstname=(isset($_POST['firstname']))? trim($_POST['firstname']): ''; $lastname=(isset($_POST['lastname']))? trim($_POST['lastname']): ''; $client_code=(isset($_POST['client_code']))? trim($_POST['client_code']): ''; $job_approval=(isset($_POST['job_approval']))? trim($_POST['job_approval']): ''; $address=(isset($_POST['address']))? trim($_POST['address']): ''; $cell=(isset($_POST['cell']))? trim($_POST['cell']): ''; $tel=(isset($_POST['tel']))? trim($_POST['tel']): ''; $email=(isset($_POST['email']))? trim($_POST['email']): ''; $company=(isset($_POST['company']))? trim($_POST['company']): ''; $province=(isset($_POST['province']))? trim($_POST['province']): ''; $ip_address=$SERVER['REMOTE_ADDR']; if(empty($_POST['firstname'])){ exit(); } #check box if(isset($_POST['department_type'])) { $value = implode(",", $_POST['department_type']); } else { $value = ""; } #check box #Image code $target ='../t/images/'; $target = $target.basename($_FILES['imagename']['name']); $pic = ($_FILES['imagename']['name']); ######################################################## #end try { $query="INSERT INTO tish_user(username,Previllage,date_created) VALUES(:username,:Previllage,:date_created)"; $insert = $con-&gt;prepare($query); $insert-&gt;execute(array( ':username'=&gt;$username, ':Previllage'=&gt;$Previllage, ':date_created'=&gt;$date_created) ); # insert into another table $query="INSERT INTO tish_clientinfor( user_id,title,firstname,lastname, client_code,department_type,job_approval,province, company,address,cell,tel,email,date_registered) VALUES( LAST_INSERT_ID(), :title,:firstname,:lastname, :client_code,:department_type,:job_approval,:province,:company,:address, :cell,:tel,:email, :date_registered)"; $insert = $con-&gt;prepare($query); $insert-&gt;execute(array( ':title'=&gt;$title, ':firstname'=&gt;$firstname, ':lastname'=&gt;$lastname, ':client_code'=&gt;$client_code, ':department_type'=&gt;$value, ':job_approval'=&gt;$job_approval, ':province'=&gt;$province, ':company'=&gt;$company, ':address'=&gt;$address, ':cell'=&gt;$cell, ':tel'=&gt;$tel, ':email'=&gt;$email, ':date_registered'=&gt;$date_created) ); #intert into the security table $query = "INSERT INTO tish_security(ip_address,user_id,date_registered) VALUES( :ip_address, LAST_INSERT_ID(), :date_registered)"; $insert = $con-&gt;prepare($query); $insert-&gt;execute(array( ':ip_address'=&gt;$ip_address, ':date_registered'=&gt;$date_created) ); # insert into another table } catch(PDOException $e) { echo $e-&gt;getMessage(); } ?&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPeon
    1. USHumphrey
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POinsert into 3 different table using pdo and mysql
      1. This table or related slice is empty.
      1. VTDownMod
    1. COCould you indent your code a bit? It's unreadable ...
      singulars
      1. POinsert into 3 different table using pdo and mysql
      1. USj0k
    2. COthe order of the 2nd and 3rd insert statements is relevant? how about using mysql insert trigger on tish_user table?
      singulars
      1. POinsert into 3 different table using pdo and mysql
      1. USAnda Iancu
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload