Invalid syntax. Replace '->' with '=>'. Also building arrays and using
implode() is an alternative method to building the string..
foreach($_POST as $key => $val)
{
$fields[] = $key;
$values[] = $val;
}
$fields = implode(', ', $fields); // collapse to string
$values = implode(', ', $values); // collapse to string
- Kevin
----- Original Message -----
From: "st" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 04, 2003 12:19 PM
Subject: [PHP] Re: Scroll through values sent from a form
> thanks for your reply but it doesn't work, i get the following output:
>
> INSERT INTO Table (Object, Object, Object, Object, ) Values (, , , , )
>
> any ideas?
>
>
> "Bobby Patel" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > $fields='';
> > $values='';
> >
> > foreach ($_POST as $field -> $value) {
> > $fields .= $field.", ";
> > $values .=$value.", ";
> > }
> > $fields = substr ($fields, -2); // strip off last comma and space
> > $values = substr ($values , -2); // strip off last comma and space
> >
> > $query = "INSERT INTO $_GET[table_name] (".$fields.") Values
> (".$values.")";
> >
> >
> > "St" <[EMAIL PROTECTED]> wrote in message
> > news:[EMAIL PROTECTED]
> > > Hi,
> > >
> > > Is it possible to scroll through values posted from a form using PHP?
> Here
> > > is my problem: I have a form on a page which is created dynamically
from
> > the
> > > number of fields in a particular table, so when I POST the data how do
I
> > > create the INSERT statement? I feel this will be awkward due to the
> > > construction of the INSERT statement and I would be very grateful for
> > > anyone's input. The form names are the same as the field alues in the
> > > table...
> > >
> > > It will need to be something like
> > >
> > > $query = "
> > >
> > > while (more Form Fields){
> > > $query = $query + "'form fieldname'";
> > > }
> > >
> > > $query = $query + ") VALUES (";
> > >
> > > while (more POST Values){
> > > $query = $query + "POST Value";
> > > }
> > >
> > > $query = $query + ")";
> > >
> > > I hope this makes sense to the reader!
> > >
> > > Thanks
> > >
> > >
> > >
> > >
> >
> >
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
