Re: [PHP-DB] REVISED; need INSERT help
What about using a form identifier? In each form, use and so on. Then, use:
switch ($formident) {
case "form1":
your action for this form
break;
case "form2":
and so on.
Edwin
Mark wrote:
I haven't been following any other threads relating to this, but you
might try the following. It's not a recommended way to do things, as
you can't verify the fields being posted, but it should work.
I am assuming there is no correlation between the various forms being
submitted.
$val) {
$ins_fields.="$key,";
$ins_vals.="'$val',";
}
// strip off the last comma
$ins_fields=substr($ins_fields,0,-1)
$ins_vals=substr($ins_vals,0,-1)
$query="insert into ads ($ins_fields) VALUES ($ins_vals)";
$result=mysql_query($query) or die("Could not insert values");
?>
--- Addison Ellis <[EMAIL PROTECTED]> wrote:
hello again and i am sorry i was not more specififc in my last
post.
here is where i am confused:
else
{
$today = date("Y-m-d h:m:s");
$sql = "INSERT INTO ads ("") VALUES
('$first_name','$last_name','$email','$phone','$univ_status',
'$password','$today')";
mysql_query($sql);
$auth="yes";
$logname = $email;
for the actual insert, what do i put in order to avoid having to do
a
separate .php for each form and list the fields/values from each
form? thanks and sorry again. addison
previous post:
hello,
can someone help me with this? i have tried all i know and i
am very new at this... my apologies.
i am trying to have multiple forms, all with different
fields/values, point to one .php that will foreach($HTTP_POST_VARS
as
$key => $VALUE)
1) check for if ($value == "")
2) ereg function
3) $$key = strip_tags(trim($value));
4) $today = date("-m-d");
5) $sql = "INSERT INTO tablename ("$HTTP_POST_VARS)
VALUES ('$$HTTP_POST_VARS values')";
mysql_query($sql);
the problem i am having is i have so many different form
fields/values. i am almost resigning to having one .php for each
form
but i know there is a better way. and... anyway... thanks for
looking
at this. best regards, addison
--
Addison Ellis
small independent publishing co.
114 B 29th Avenue North
Nashville, TN 37203
(615) 321-1791
[EMAIL PROTECTED]
[EMAIL PROTECTED]
subsidiaries of small independent publishing co.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
=
Mark Weinstock
[EMAIL PROTECTED]
***
You can't demand something as a "right" unless you are willing to fight to death to defend everyone else's right to the same thing.
-Stolen from the now-defunct Randy's Random mailing list.
***
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] REVISED; need INSERT help
I haven't been following any other threads relating to this, but you
might try the following. It's not a recommended way to do things, as
you can't verify the fields being posted, but it should work.
I am assuming there is no correlation between the various forms being
submitted.
$val) {
$ins_fields.="$key,";
$ins_vals.="'$val',";
}
// strip off the last comma
$ins_fields=substr($ins_fields,0,-1)
$ins_vals=substr($ins_vals,0,-1)
$query="insert into ads ($ins_fields) VALUES ($ins_vals)";
$result=mysql_query($query) or die("Could not insert values");
?>
--- Addison Ellis <[EMAIL PROTECTED]> wrote:
> hello again and i am sorry i was not more specififc in my last
> post.
> here is where i am confused:
> else
>{
>
> $today = date("Y-m-d h:m:s");
> $sql = "INSERT INTO ads ("") VALUES
>
> ('$first_name','$last_name','$email','$phone','$univ_status',
> '$password','$today')";
> mysql_query($sql);
> $auth="yes";
> $logname = $email;
>
>
> for the actual insert, what do i put in order to avoid having to do
> a
> separate .php for each form and list the fields/values from each
> form? thanks and sorry again. addison
>
>
> previous post:
>
>
> hello,
> can someone help me with this? i have tried all i know and i
> am very new at this... my apologies.
> i am trying to have multiple forms, all with different
> fields/values, point to one .php that will foreach($HTTP_POST_VARS
> as
> $key => $VALUE)
> 1) check for if ($value == "")
> 2) ereg function
> 3) $$key = strip_tags(trim($value));
> 4) $today = date("-m-d");
> 5) $sql = "INSERT INTO tablename ("$HTTP_POST_VARS)
> VALUES ('$$HTTP_POST_VARS values')";
> mysql_query($sql);
>
> the problem i am having is i have so many different form
> fields/values. i am almost resigning to having one .php for each
> form
> but i know there is a better way. and... anyway... thanks for
> looking
> at this. best regards, addison
> --
> Addison Ellis
> small independent publishing co.
> 114 B 29th Avenue North
> Nashville, TN 37203
> (615) 321-1791
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> subsidiaries of small independent publishing co.
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
=
Mark Weinstock
[EMAIL PROTECTED]
***
You can't demand something as a "right" unless you are willing to fight to death to
defend everyone else's right to the same thing.
-Stolen from the now-defunct Randy's Random mailing list.
***
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] REVISED; need INSERT help
hello again and i am sorry i was not more specififc in my last post.
here is where i am confused:
else
{
$today = date("Y-m-d h:m:s");
$sql = "INSERT INTO ads ("") VALUES
('$first_name','$last_name','$email','$phone','$univ_status',
'$password','$today')";
mysql_query($sql);
$auth="yes";
$logname = $email;
for the actual insert, what do i put in order to avoid having to do a
separate .php for each form and list the fields/values from each
form? thanks and sorry again. addison
previous post:
hello,
can someone help me with this? i have tried all i know and i
am very new at this... my apologies.
i am trying to have multiple forms, all with different
fields/values, point to one .php that will foreach($HTTP_POST_VARS as
$key => $VALUE)
1) check for if ($value == "")
2) ereg function
3) $$key = strip_tags(trim($value));
4) $today = date("-m-d");
5) $sql = "INSERT INTO tablename ("$HTTP_POST_VARS)
VALUES ('$$HTTP_POST_VARS values')";
mysql_query($sql);
the problem i am having is i have so many different form
fields/values. i am almost resigning to having one .php for each form
but i know there is a better way. and... anyway... thanks for looking
at this. best regards, addison
--
Addison Ellis
small independent publishing co.
114 B 29th Avenue North
Nashville, TN 37203
(615) 321-1791
[EMAIL PROTECTED]
[EMAIL PROTECTED]
subsidiaries of small independent publishing co.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
