[phorm] [Phorm:] how to apply mysql_insert_id()
- From: webbbs@xxxxxxxxx
- To: support@xxxxxxxxx
- Date: 14 Jun 2004 19:49:24 -0000
The following new message has been posted on Phorm Support Forum at
<http://www.phorm.com/support/>.
***************************************************************************
MESSAGE: (#4127) how to apply mysql_insert_id()
<http://www.phorm.com/support/?rev=4127>
AUTHOR: Dale
DATE: June 14, 2004 at 3:49 p.m. EST
Hi and thanks in advance for any help.
I am no programmer, but I am self teaching and coming along a little at a
time. It's fun. Initially, I am using Phorm to handle a registration form for
a single event. In the future, I will need it to handle information for
different events that could have the same user in one or more events. So, I
have been developing a relational database to handle the information. When
someone submits the registration form, I understand how Phorm can pass the
entries as variables to a MySQL database. I think I have that set up now.
(untested, though). I need a little help in using the mysql_insert_id()
function with Phorm. I know that it will take the last value created for a
primary key. I want to associate all my user identification parameters with
that primary key value and want to pass that value along in each subsequent
table as a user_id value so searching and retrieving data will be possible.
Let's say that I wanted to use mysql_insert_id()this way:
mysql_query("
INSERT INTO
users
(
user_fname,
user_lname,
user_email
)
VALUES (
'joe',
'mamma',
'joemamma@xxxxxxxxxx'
)
");
$insert_id = mysql_insert_id();
mysql_query("
INSERT INTO
activities
(
user_id,
cant_do
)
VALUES (
'$insert_id',
'tennis'
)
");
My question is, where do I apply this? Do I alter the existing Phorm files, do
I create a specific config file for this form, and if so, do I disable any
particular function in Phorm so the form-specific config file does the
database entries and not Phorm itself?
I appologize if this was explained in the Documentation. I really have read it
about a dozen times. I am learning, but still not a coder...and I did not see
any explanation that I could latch onto and understand. Again, any help would
be greatly appreciated.
Dale
***************************************************************************
This is an automatically-generated notice. If you'd like to be removed from
the mailing list, please visit Phorm Support Forum at
<http://www.phorm.com/support/>, or send your request to webbbs@xxxxxxxxxx If
you wish to respond to this message, please post your response directly to the
board. Thank you!
-------------------------------------------------
You are receiving this message because you are subscribed to the Phorm mailing
list. To send messages to the mailing list, simply send email to
phorm@xxxxxxxxxxxxx from the address you have subscribed. You may unsubscribe
from the list by sending email to phorm-request@xxxxxxxxxxxxx with
'unsubscribe' in the SUBJECT field.
Other related posts:
- » [phorm] [Phorm:] how to apply mysql_insert_id()
