How to compare html checkbox values in php?

Question

I have three check box and three input field something like this,

        <input type="checkbox" name="fruit" value="orange" >
        <input type="text" name="orange" >Orange
        <input type="checkbox" name="fruit" value="apple" >
        <input type="text" name="n" >Apple<br/>
        <input type="checkbox" name="fruit" value="mango" >
        <input type="text" name="mango" >Mango

I have a mysql table named fruits with four column named id, apple, orange, mango. I want to do something like if user select orange , apple , mango (checkboxes) I want to insert data into orange , apple , mango in the table from the three input field , or if user select two user check box it will just insert data into two columns from the input field's value, or if just one check box is selected then insert into one column! what is the standard procedure to do that? Thanks in advance

Use conditional statements. php.net/manual/en/control-structures.if.php — Funk Forty Niner
– Funk Forty Niner, Commented Feb 21, 2015 at 16:42
That's the general idea. Checkboxes, well you can use a foreach and implode. — Funk Forty Niner
– Funk Forty Niner, Commented Feb 21, 2015 at 16:49

pavel · Accepted Answer · 2015-02-21 18:16:33Z

2

Only checked checkboxes are sent, so use isset:

if (isset($_POST['mango']) || isset($_POST['apple']) || isset($_POST['orange'])) {
    $query = 'INSERT INTO table VALUES (orange, apple, mango) VALUES (';
    $query .= (isset($_POST['orange']) ? 1 : '') . ',';
    $query .= (isset($_POST['apple'])  ? 1 : '') . ',';
    $query .= (isset($_POST['mango'])  ? 1 : ''); 
    $query .= ')';
}

edited Feb 21, 2015 at 18:16

answered Feb 21, 2015 at 16:50

pavel

27.3k11 gold badges47 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Funk Forty Niner Over a year ago

Hm... After the way I got grilled by the OP, I wish you all the best Panther ;-)

monirz Over a year ago

there are some errors in your code , I fixed it but not working the way it supposed to!

pavel Over a year ago

@monir009: what errors you mean? What my code do and what should it do?

monirz Over a year ago

well its basic syntax error though : syntax error, unexpected ')' you haven't close parenthesis properly in few lines like so isset($_POST['orange']) ? 1 : '' . ',';

monirz Over a year ago

and wrote values twice :)

|

Akilsree1 · Accepted Answer · 2015-02-21 18:04:57Z

0

It worked for me.

My Code:

HTML

 <form  action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>" method="POST">
<input type="checkbox" name="fruit[]" value="orange" >Orange
<input type="checkbox" name="fruit[]" value="apple" >Apple
<input type="checkbox" name="fruit[]" value="mango" >Mango
<input type="submit" value="Insert into Database">
</form>

PHP

 <?php 

// define variables and set to empty values
 $fruits = array();
if ($_SERVER["REQUEST_METHOD"] == "POST") 
{
  $fruits = test_input($_POST);
}
function test_input($data) 
 {
    $servername = "";// localhost, server name
    $username = "";// username
    $password = "";//password
    $dbname = "";//database name

   // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);

    for($i =0; $i < sizeof($data["fruit"]);  $i++)
    {
        //select query where count > 0 and fruitname = $data["fruit"]
        //If its first time, Select query returns false
        // write Insert into db table values(fruitname = $data["fruit"] , count =1)

    // if its exist value, select query returns count value,
    // update query set value = value+ 1 where   fruitname = $data["fruit"]
   }
}

?>

answered Feb 21, 2015 at 18:04

Akilsree1

4621 gold badge4 silver badges26 bronze badges

1 Comment

Akilsree1 Over a year ago

Try this code, give your database query and execute the query, If you using any other database and want how to write query Follow this links, Select last id

Collectives™ on Stack Overflow

How to compare html checkbox values in php?

2 Answers 2

6 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related