insert multiple items from textarea into database

[hellyna]

I have problem with inserting multiple items from textarea into database.
The problem is when i choose multiple items from textarea and click submit button, it only store 1 item only. Suppose it must insert multiple items. My codes for the form is :

recordform.php

<form name="addsummonrecord" method="post" action="recordprocess.php" id="signup" onSubmit="return checkform(this);">

              <table width="452" border="1" align="right" cellpadding="4" cellspacing="3" bordercolor="#003093" id="table">
               <tr> 
                  <td width="210" class="labelfield">Record Code:</td>
                  <td width="211" nowrap class="field">
                 <input name="recordno" type="text" size="10" maxlength="4"    
                   class="fieldcellinput"></td>
                </tr>

    <tr> 
      <td class="labelfield">Types/Records: <br/>
      <font size="1">(ctrl+click to select multiple records)</font></td>
         <td nowrap>
       <select name="types" size="3"multiple 
                      class="textarea" id="summons" style="width:190px" >

<?php

$sql = "SELECT summonid, types FROM summon_types ORDER BY types";
$result = mysql_query($sql) or die ("<font color=\"#FF0000\"Query Error</font>".
mysql_error());
while ($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['types'] . '">' .
$row ['types'] . '</option>' . "\r\n"; }

?>
</select>
</td>
</tr>
</table>

<input name="submit_rec" type="submit" class="button" id="submit_rec" value="Add New Record" >
</form>

And this is my recordprocess.php form:

<?php

extract($_POST);

include "connection.inc";

$recordno = $POST['recordno'];
$types = $POST['types'];

if(isset($_POST['submit_rec'])) {

$sql = "INSERT INTO records VALUES('$recordno', '$types')";
$results = mysql_query($sql);
if (!$results) {
echo "Unable to store data"; }

}

mysql_close();

?>

Can anyone help me???? 😕

[BobLennon]

hellyna wrote:

I have problem with inserting multiple items from textarea into database.
The problem is when i choose multiple items from textarea and click submit button, it only store 1 item only.....

I guess I don't understand the problem. I can't seem to find a textarea tag within your form. The reference to textarea in the select tag looks like a css reference.

[khendar]

Firstly - you are using a <select> not a <textarea>. You have the right idea - just the wrong terminology.

With multiple selects - the field will return an array of the selected options. This means that $_POST["types"] will be an array of the select items.

You need to change the name of the select element so that the php knows to accept multiple values:

Try:
<select name="types[]" size="3" multiple class="textarea" id="summons" style="width:190px" >

In addition - you cannot store an array directly into a database. You will need to do some processing on it - such as converting it to a string or serialising it in order to be able to store it.

[hellyna]

Khendar,
Can you please explain in details about some processing that i need to do ? Is the problem is when inserting the data into database? If u don't mind show me some coding please...I really need help..

[rincewind456]

This will change your $POST['types'] array into a comma seperated string named $type, which can be inserted to your Database:

$types = $_POST['types'];
	$type = '';

foreach ($types as $key => $value){
	$type .= $value.", ";
}
print($type);

[hellyna]

rincewind, does this code i have to put in recordform.php or recordprocess.php?

[rincewind456]

Like this in recordprocess.php, BTW you don't need to extract $_post as well as assigning them.

<?php
include "connection.inc";

if(isset($_POST['submit_rec'])) {
$recordno = $_POST['recordno'];
$types = $_POST['types'];

$type = '';

foreach ($types as $key => $value){
	$type .= $value.", ";
}


$sql = "INSERT INTO records VALUES('$recordno', '$type')";
$results = mysql_query($sql);
if (!$results) {
	echo "Unable to store data"; }

}
mysql_close();

?>

[NourB]

I have a similiar problem, except that the code includes some javascript.

I have two lists, with multiple selection, say one is employees and the other is called members, when names are moved from employees into the other list box they become members of a team.
the names of these members are to be inserted into the database, my problem is that the members are supposed to be stored in a javascript array and read by the php script to be saved in the database,
Inorder to move the names between the two lists i use a javascript function, after that i want to save the content of the second list in the db, but since its more than one item i would need to put them into an array....
here is a snippet of the code
Code: ( text )

1.
<select size=8 name=employees style='width: 250;' dir=rtl multiple='yes'>
2.
<option value=0></option>
3.
</select>
4.
</td>
5.
<td bgcolor=$color4 align=center>
6.
<input type=button value='>' name=1 style='width: 70;' onclick='return nameXchange(document.meetings_frm.employees,docume nt.meetings_frm.members[]);' ><br>
7.
<input type=button value='<' name=1 style='width: 70;' onclick='return nameXchange(document.meetings_frm.members[],document.meetings_frm.employees);'><br>
8.
</td>
9.
<td bgcolor=$color4 align=right>
10.
<select size=8 name=members[] style='width: 250;' dir=rtl multiple='yes'>
11.
</select>

How can i deal with this?