Ad:

PHP Discussion Thread
Marked Solved
Views: 727

Jun 12th, 2009

Help php+mysql+checkbox=Massive Headache

Expand Post »

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.

PHP Syntax (Toggle Plain Text)
<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
<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 Syntax (Toggle Plain Text)
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("test", $con);
 
$sql="INSERT INTO food (Fruit)
VALUES
('$_POST[fruit]')";
 
if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "information has been added";
 
mysql_close($con)
?>
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("test", $con);

$sql="INSERT INTO food (Fruit)
VALUES
('$_POST[fruit]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "information has been added";

mysql_close($con)
?>

mccs

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jun 2009

Permalink

Jun 12th, 2009

Re: Help php+mysql+checkbox=Massive Headache

hi

you need to use implode() php function for convert string
for e.g

PHP Syntax (Toggle Plain Text)
$fruits=$_POST[fruit];
$fruits_str=implode(',',$fruits);//it seprates value by comma
$fruits_str=implode(' ',$fruits);//it seprates value by space
$fruits=$_POST[fruit];
$fruits_str=implode(',',$fruits);//it seprates value by comma
$fruits_str=implode(' ',$fruits);//it seprates value by space

I hope this function help you to solve problem
Thanks

Tulsa

Reputation Points: 13

Solved Threads: 15

Junior Poster in Training

Offline

77 posts
since May 2009

Permalink

Jun 12th, 2009

Re: Help php+mysql+checkbox=Massive Headache

Welcome mccs.

This is your first post and it is very impressive.

You missed Submit Button and also "fruits" is an array and its elements should be written into a table.

PHP Syntax (Toggle Plain Text)
<?php
       $cmd=$_REQUEST["cmd"];
      // If submit button is pressed 
      if(isset($cmd)) {
       $con = mysql_connect("localhost","root","");
           if (!$con) {
                  die('Could not connect: ' . mysql_error());
            }
 
        mysql_select_db("test", $con);
        $fruit=$_REQUEST["fruit"];   // array of checked box values
 
        foreach($fruit as $i)  {
             $sql="INSERT INTO food (Fruit)  VALUES ('$i')";
                 if (!mysql_query($sql,$con)) {
                           die('Error: ' . mysql_error());
                   }
               }
               echo "information has been added";
           mysql_close($con);
     }
?> 
 
<form action="script/test.php" method="post">
<table>
 <tr>
  <td>
     <input type="checkbox" name="fruit[]" id='fruit[]'  value='banana'> 
  banana
 </td>
 <tr>
 <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>
 <tr>
    <td>
       <input type="submit" name="cmd" value="Submit"/>
   </td>
 </tr>
</table>
</form>
<?php
       $cmd=$_REQUEST["cmd"];
      // If submit button is pressed 
      if(isset($cmd)) {
       $con = mysql_connect("localhost","root","");
           if (!$con) {
                  die('Could not connect: ' . mysql_error());
            }

        mysql_select_db("test", $con);
        $fruit=$_REQUEST["fruit"];   // array of checked box values

        foreach($fruit as $i)  {
             $sql="INSERT INTO food (Fruit)  VALUES ('$i')";
                 if (!mysql_query($sql,$con)) {
                           die('Error: ' . mysql_error());
                   }
               }
               echo "information has been added";
           mysql_close($con);
     }
?> 

<form action="script/test.php" method="post">
<table>
 <tr>
  <td>
     <input type="checkbox" name="fruit[]" id='fruit[]'  value='banana'> 
  banana
 </td>
 <tr>
 <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>
 <tr>
    <td>
       <input type="submit" name="cmd" value="Submit"/>
   </td>
 </tr>
</table>
</form>

adatapost

Moderator

Reputation Points: 2134

Solved Threads: 1226

Posting Genius

Offline

6,523 posts
since Oct 2008

Permalink

Jun 12th, 2009

Re: Help php+mysql+checkbox=Massive Headache

Thanks for your help guys really appreciate the help and fast reply.

sorry for the messy post, it was driving me crazy, and I need to get away from the computer, I accidentally left out the submit button, due to having the checkbox half way in my code.

but thanks again for the help.

mccs

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jun 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Joomla basics?

Next Thread in PHP Forum Timeline: Working with an IDX feed

DaniWeb Message

Cancel Changes

User Name
Password