RE: [PHP-DB] INSERT Question
| From: | John W. Holmes | Date: | Sun, 30 Mar 2003 02:21:37 +0000 |
| Subject: | RE: [PHP-DB] INSERT Question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26710@lists.php.net to get a copy of this message | ||
The only addition I have is to adapt the code to create a single INSERT
query in the format I gave earlier. It will run quicker overall.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
> -----Original Message-----
> From: Charles Kline [mailto:ckline@rightcode.net]
> Sent: Saturday, March 29, 2003 9:11 PM
> To: Peter Lovatt
> Cc: php-db@lists.php.net
> Subject: Re: [PHP-DB] INSERT Question
>
> Big help! Thanks much.
>
> Now... to figure out how to create that kind of form in HTML_QuickForm
> (hehehe). If I can't then I just make it by hand, but now I know the
> method! Phew... always more to learn.
>
> - Charles
>
>
> On Saturday, March 29, 2003, at 08:51 PM, Peter Lovatt wrote:
>
> > Hi
> >
> > you need to create 5 selects, all named investigator[] with index
1-5
> > (or
> > 0-4), with the option set to empty for no selection.
> >
> > this will return an array
> > investigator[1] => '1064618047'
> > investigator_yesno[1] => 'Y'
> >
> > investigator[2] => '1649815377'
> > investigator_yesno[2] => 'N'
> >
> > for example
> >
> >
> > <form>
> > <table>
> > <tr>
> > <td>
> > <select name="investigator[1]">
> > <option value="">Choose person</option>
> > <option value="1064618047">Paul A</option>
> > <option value="1655387822">Katrina A</option>
> > <option value="1649815377">David A</option>
> > </select>
> > is a primary investigator?
> > <input name="investigator_yesno[1]" value="Y"
> > type="radio"
> > checked="checked" />Yes
> > <input name="investigator_yesno[1]" value="N"
> > type="radio" />No
> > </td>
> > </tr>
> > <tr>
> > <td>
> > <select name="investigator[2]">
> > <option value="">Choose person</option>
> > <option value="1064618047">Paul A</option>
> > <option value="1655387822">Katrina A</option>
> > <option value="1649815377">David A</option>
> > </select>
> > is a primary investigator?
> > <input name="investigator_yesno[2]" value="Y"
> > type="radio"
> > checked="checked" />Yes
> > <input name="investigator_yesno[2]" value="N"
> > type="radio" />No
> > </td>
> > </tr>
> > ...more here ....
> > </table>
> > </form>
> >
> >
> >
> > on the script receiving the data you then need a for loop to insert
> > the
> > records, one for each person
> >
> >
> > for ($i = 1; $i <= 4; $i++)
> > {
> > //only do it if there is a value for $investigator[$i], ie there is
a
> > selection
> > if($investigator[$i]) {
> > $query = 'INSERT INTO tbl_report_people
> > (record_id
> > , person_id
> > , investigator_yesno
> > )
> > VALUES
> > ("'.$record_id[$i].'"
> > , "'.$investigator[$i].'"
> > , "'.$investigator_yesno[$i].'"
> > )
> > ';
> > $mysql_result = mysql_query($query, $mysql_link);
> >
> > }//end if
> >
> > }//end for
> >
> >
> >
> > hope this helps
> >
> > Peter
> >
> >
> >
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php