PHP RSS PHP RSS

how to share primary key?

Reply

•
•
Join Date: Nov 2007
Posts: 227
Reputation: k2k is an unknown quantity at this point 
Solved Threads: 0
k2k k2k is offline Offline
Posting Whiz in Training

how to share primary key?

 
0
  #1
Nov 8th, 2008
hi,
if i have a db:
person> pID (not null, auto_increment), lastname, firstname
phone>pID (not null), phoneNum, pID(foreign key points to "person")

assume connection is established and pointing to the right database already//////

//assume $ln and $fn have value for user input
sql Syntax (Toggle Plain Text) 
  1. mysql_query("INSERT INTO person( '  ', '$_POST[$ln]', '$_POST[$fn]' )");

/*

if the form page has to be filled with both person and phone table information
then how do i insert for "phone" wit the pID in the person table ?????
pID is auto-increment so it is not needed to be entered by the form filler.. how do i get that particular pID from the same person the form filler is trying enter data into?

sorry, so confusing */
Last edited by peter_budo; Nov 8th, 2008 at 7:09 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.
Reply With Quote Quick reply to this message  
•
•
Join Date: Sep 2008
Posts: 50
Reputation: jackakos is an unknown quantity at this point 
Solved Threads: 0
jackakos's Avatar
jackakos jackakos is offline Offline
Junior Poster in Training

Re: how to share primary key?

 
0
  #2
Nov 8th, 2008
From my understanding you have a form that needs to be filled but this form has both details of PERSON table and also the PHONE table.

Now, you want to know how to insert these details into the respective tables?

If the above scenarios are true, then, since you designed the form - you obviously have variables to accept the user inputs say $fn for First_Name something like that??

From your post these will be your tables:
person> pID (not null, auto_increment), lastname, firstname
phone>pID (not null), phoneNum, pID(foreign key points to "person")

PHP Syntax (Toggle Plain Text) 
  1. sql='insert into person (pid, lastname, firstname) values ("NULL", "$ln","$fn")';

you can use a variable to accept the last pid from MySQL and use that variable as input to the second table ie. supposing you use $ppid

PHP Syntax (Toggle Plain Text) 
  1. $sql2='insert into phone (pid, phoneNum) values ("$ppid", "$phno")';
Last edited by peter_budo; Nov 8th, 2008 at 7:09 pm. Reason: Keep it Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.
It is NO SHAME to ask when you want to LEARN, but FOOLISH to behave knowledgeable when YOU DON'T.
Keep PEACE alive!
Reply With Quote Quick reply to this message  
•
•
Join Date: Nov 2007
Posts: 227
Reputation: k2k is an unknown quantity at this point 
Solved Threads: 0
k2k k2k is offline Offline
Posting Whiz in Training

Re: how to share primary key?

 
0
  #3
Nov 8th, 2008
•
•
•
•
Originally Posted by jackakos View Post
From my understanding you have a form that needs to be filled but this form has both details of PERSON table and also the PHONE table.

Now, you want to know how to insert these details into the respective tables?

If the above scenarios are true, then, since you designed the form - you obviously have variables to accept the user inputs say $fn for First_Name something like that??

From your post these will be your tables:
person> pID (not null, auto_increment), lastname, firstname
phone>pID (not null), phoneNum, pID(foreign key points to "person")

PHP Syntax (Toggle Plain Text) 
  1. sql='insert into person (pid, lastname, firstname) values ("NULL", "$ln","$fn")';

you can use a variable to accept the last pid from MySQL and use that variable as input to the second table ie. supposing you use $ppid

PHP Syntax (Toggle Plain Text) 
  1. $sql2='insert into phone (pid, phoneNum) values ("$ppid", "$phno")';

jackakos,
your scenario is absolutely what I am working on. However, since pid is auto_increment, i don't need the user to input the pid but pid will automatically be inserted. That is where the problem starts. My try was:

PHP Syntax (Toggle Plain Text) 
  1. $pid = mysql_query("SELECT pID FROM person WHERE firstName= '$_POST(firstName)', '$_POST(middleName)', '$_POST(lastName)'");
// so basically i try to select the pID from the person table where the person's firstName, middleName and lastName match the user input. Well, of course it gave me errors. And i think since all the new data (fn, mn, ln and phone) will insert together, then how it will search the firstName middle... last.... while the data are not even there yet?... so i guess it is not the way... any suggestion?
Reply With Quote Quick reply to this message  
•
•
Join Date: Sep 2008
Posts: 50
Reputation: jackakos is an unknown quantity at this point 
Solved Threads: 0
jackakos's Avatar
jackakos jackakos is offline Offline
Junior Poster in Training

Re: how to share primary key?

 
0
  #4
Nov 9th, 2008
K2K, sorry for not being clear enough but the procedure I meant was last_insert_id()

Try This
php Syntax (Toggle Plain Text) 
  1. sql='insert into person (pid, lastname, firstname) values ("NULL", "$ln","$fn")';   // generate ID by inserting NULL

And this is for the second table
php Syntax (Toggle Plain Text) 
  1. $sql2='insert into phone (pid, phoneNum) values (LAST_INSERT_ID(), "$phno")';

Hope this works or you can read much about it yourself
http://dev.mysql.com/doc/refman/4.1/...unique-id.html
Last edited by jackakos; Nov 9th, 2008 at 11:36 am. Reason: provide a link
It is NO SHAME to ask when you want to LEARN, but FOOLISH to behave knowledgeable when YOU DON'T.
Keep PEACE alive!
Reply With Quote Quick reply to this message  
•
•
Join Date: Sep 2008
Posts: 50
Reputation: jackakos is an unknown quantity at this point 
Solved Threads: 0
jackakos's Avatar
jackakos jackakos is offline Offline
Junior Poster in Training

Re: how to share primary key?

 
0
  #5
Nov 12th, 2008
K2K,

can you close this by clicking on solved if your problem has indeed been solved?
It is NO SHAME to ask when you want to LEARN, but FOOLISH to behave knowledgeable when YOU DON'T.
Keep PEACE alive!
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the PHP Forum
Thread Tools Search this Thread



advanced ajax apache api array basics beginner binary broken cakephp check checkbox class cms code combobox cookies cron curl database date datepart display dynamic echo email error file files folder form forms function functions google head href htaccess html image include includingmysecondfileinthechain insert integration ip java javascript job joomla js limit link login mail menu mlm multiple mysql oop parse password paypal pdf php problem procedure query radio random recursion regex remote script search server sessions smarty smash sms soap source space sql stored syntax system table traffic tutorial unicode up-to-date update upload url validator variable video web xml youtube
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC