Form with checkbox value populate from database and insert into database

Question

I tried to search google for it,yet i cant really find the condition really apply on mine. what i need is the checkboxes data is from table1 so i can add more area when needed.meanwhile,how could i do to analysis the user had selected which boxes because i need to store into table2.

<label>Area:</label>
 <input type="checkbox" name="area"> Ayer Keroh
 <input type="checkbox" name="area" >Bukit Beruang
 <input type="checkbox" name="area"> MITC
 <input type="checkbox" name="area">Malim Jaya
 <input type="checkbox" name="area">Kota Laksamana<br>
Others:
 <textarea rows="2" cols="50" name="comment" placeholder="Enter if area            is not listed" ></textarea>

I need those "ayer keroh,bukit beruang,mitc..." is from table area whereas when submit my form and i need to record which the user had selected and store into database. — Dlayz, Dec 18 '17 at 11:16
so you want to populate your check boxes with data from database and then then insert user selection to the database? — Cezary, Dec 18 '17 at 11:28
https://stackoverflow.com/questions/3921573/populate-checkbox-from-database this might help — Cezary, Dec 18 '17 at 11:31
i saw that too but it doesnt fit to my problem.what i need is the checkboxes data is from table1 so i can add more area when needed.meanwhile,how could i do to analysis the user had selected which boxes because i need to store into table2. — Dlayz, Dec 18 '17 at 11:39

Umar Majeed · Accepted Answer · 2017-12-19T09:54:45.777

1

    <form action="test.php" method="post">
        <input type="checkbox" name="area[]" value="value 1">value 1
        <input type="checkbox" name="area[]" value="value 2">value 2
        <input type="checkbox" name="area[]" value="value 3">value 3
        <input type="checkbox" name="area[]" value="value 4">value 4
        <input type="checkbox" name="area[]" value="value 5">value 5
        <input type="checkbox" value="Other" name="area[]">Other<br>
        <textarea rows="2" cols="50" name="comment">write here
      </textarea>
        <input type="submit" />
        </form>
        <?php
        if(!empty($_POST['area'])) {
            foreach($_POST['area'] as $check) {
                    echo $check; //echoes the value set in the HTML form for each checked checkbox.
                                 //so, if I were to check 1, 3, and 5 it would echo value 1, value 3, value 5.
                                 //in your case, it would echo whatever $row['Report ID'] is equivalent to.
        if($check=='other'){//if the user selected other checkbox
           echo$comment=$_REQUEST['comment'];
        }
            }
        }
        ?>

for more you can reffer to this Get $_POST from multiple checkboxes

how to retrive data from the sql

<?php
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT AreaName FROM Areas";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "<input type='checkbox' name='area[]' value='".$row['AreaName']."'>".$row['AreaName'];
    }
} else {
    echo "0 results";
}

$conn->close();

?>

edited Dec 19 '17 at 09:54

answered Dec 18 '17 at 11:57

Umar Majeed

313
3
15

thanks for the reply but actually my largest problem is how could i show the value that store in table1 in checkbox method. – Dlayz Dec 18 '17 at 12:13
something like this $databasearray=array('value1','value2','value3','value 5'); name="area[]" value="value 5"> – Umar Majeed Dec 18 '17 at 12:25
let me know if you still confused – Umar Majeed Dec 18 '17 at 12:35
Hmmm....i still don't get it....maybe i try to explain what i need in another way,i need echo the value stored in table 1 ex:"london,paris and etc" into checkbox – Dlayz Dec 18 '17 at 13:09
i have update it how to retrieve from DB and print as loop – Umar Majeed Dec 18 '17 at 14:04
my multiple checkbox value doesnt insert into my database.do u know why>i will update my code – Dlayz Dec 19 '17 at 10:06
share your code – Umar Majeed Dec 19 '17 at 10:09
may i update my code at my question?people will confused when they are new to here or maybe i can add in comment? – Dlayz Dec 19 '17 at 10:11
now you want to add the selected checkbox into the table right? – Umar Majeed Dec 19 '17 at 10:12
my first part of the answer get the all the selected checkbox now you can put a query of the insert in for each loop which will insert all the selected values in the tables – Umar Majeed Dec 19 '17 at 10:13
yeah,but my code doesn't work – Dlayz Dec 19 '17 at 10:14
oh i knew what's the problem already thanks – Dlayz Dec 19 '17 at 10:17

Form with checkbox value populate from database and insert into database

1 Answers1