Re: php-db Digest: Sending multiple values from a form having samefield names.

Your line :




Should probably be:




So that each field's name isn't the string "field_id", but rather is
each field's unique ID.

>
> Hi,
>
> How can I send multiple values from a form to be stored in a database, as
> name of the fields is the same?
>
> For example:
>
> > foreach ($field_data as $field) {
>
> $field_name=$field["field_name"];
> $field_id=$field["field_id"];
> $datatype=$field["datatype_name"];
>
> ?>
>
>
>
> > if ($datatype=="text" || $datatype=="integer") {
> echo "";
> }
> elseif ($datatype=="textarea") {
> echo "> name=\"field_data\">
";
> }
> echo "";
> }
> ?>
>
> This creates a form with field names and text box or textarea box next to
> each field name depending on the datatype. After the user enters the
> values in the text or textarea and clicks submit, the values should get
> stored in a database. But what is happening is that only the value entered
> in the last field of the form is getting entered into the database.
> This code is embedded in an application which is having an inbuilt
> structure of taking the values from a form in a hash. Since key is the
> same (i.e. field_id) everytime, the value gets overwritten and only the
> last value gets stored in db. But I am not able to work out a solution for
> this.
> I hope I am able to make my problem clear enough.
>
> Thanks,
> Suamya.
>
>
> ------------------------------------------------------------ -----------------
> DISCLAIMER:-
> "The information in this e-mail is confidential, and is intended
> solely for the addressee or addressees. If you are not the intended recipient,
> please delete the mail and kindly notify the sender of misdelivery. Any
> unauthorised use or disclosure of the contents of the mail is not permitted
> and may be unlawful."
> ------------------------------------------------------------ -----------------
>
> "Scanned By MailScanner"
>
>
>
> ------------------------------------------------------------ ------------
>
> Subject:
> Re: [PHP] Fastest way to get table records' number
> From:
> "Daniel Brown"
> Date:
> Wed, 19 Mar 2008 09:42:07 -0400
> To:
> Shelley
>
> To:
> Shelley
> CC:
> php-general@lists.php.net, "PHP DB"
>
>
> On Tue, Mar 18, 2008 at 11:43 PM, Shelley wrote:
>
>> Hi all,
>>
>> What do you think is the FASTEST sql to get the total number of a table
>> with millions of records?
>>
>
> That question would be better on the PHP-DB list, so for archive's
> sake, I'm CC'ing that list.
>
> $sql = "SELECT COUNT(*) FROM your_table";
>
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php