Home › Forums › Computer Programming › Web Development

Query in Php/ Mysql Code!!

No replies
Sat, 06/13/2009 - 05:03
programmer
User offline. Last seen 1 year 10 weeks ago. Offline
Joined: 04/14/2009
bOt Points: 86

Hello
can someone please help me, I am trying to add information to a database with checkbox. I have every thing working expect for the checkbox. I am fairly new to the php/sql side of web coding. Anyway I want to add information to the one field of a database, in this case fruit. When I click submit it show the information as array, but I want it to be displayed as the value, eg banana, apple not as Array.

 

FORM CODE

<form action="script/test.php" method="post">
<table>
<TD><input type="checkbox" name="fruit[]" id='fruit[]' value='banana'>
banana</TD>
<TD><input type="checkbox" name="fruit[]" id='fruit[]' value='apple'>
Apple</TD>
</tr>
<tr>
<TD></TD>
<TD><input type="checkbox" name="fruit[]" id='fruit[]' value='pine'>
Pineapple</TD>
<TD><input type="checkbox" name="fruit[]" id='fruit[]' value='other'> Other</TD>
<tr></tr>
<tr>
</TABLE></form>

 

Php code

 

 
<?php

  2. $con = mysql_connect("localhost","root","");
  3. if (!$con)
  4.   {
  5.   die('Could not connect: ' . mysql_error());
  6.   }
  7.  
  8. mysql_select_db("test", $con);
  9.  
  10. $sql="INSERT INTO food (Fruit)
  11. VALUES
  12. ('$_POST[fruit]')";
  13.  
  14. if (!mysql_query($sql,$con))
  15.   {
  16.   die('Error: ' . mysql_error());
  17.   }
  18. echo "information has been added";
  19.  
  20. mysql_close($con)
  21. ?>
‹ web hosting and server Detection of Web Browser ›
Top