Question 41522 in PHP Question posted in
Official manual can be found here.

How to check multiple chekbox from database value – PHP

I have this code to showing value from database as well as checking the checkbox that have the value :

<?php
    $result = mysqli_query($kon,"SELECT jenis FROM pasien WHERE nopemeriksaan = $nopemeriksaan"); 
    while($row = mysqli_fetch_array($result)) {
        $jenis = explode(",", $row['jenis']);
        print_r($jenis);
?>    
    <input type="checkbox" id="checkup" name="jenis[]" value="checkup" <?php if(in_array("checkup",$jenis)) echo 'checked="checked"'; ?>>
    <label> Check-Up</label><br>
    <input type="checkbox" id="vaksinasi" name="jenis[]" value="vaksinasi" <?php if(in_array("vaksinasi",$jenis)) echo 'checked="checked"'; ?>>
    <label> Vaksinasi</label><br>
    <input type="checkbox" id="usg" name="jenis[]" value="usg" <?php if(in_array("usg",$jenis)) echo 'checked="checked"'; ?>>
    <label"> USG </label><br>
    <input type="checkbox" id="xray" name="jenis[]" value="xray" <?php if(in_array("xray",$jenis)) echo 'checked="checked"'; ?>>
    <label> X-Ray </label><br>
    <input type="checkbox" id="sterilisasi" name="jenis[]" value="sterilisasi" <?php if(in_array("sterilisasi",$jenis)) echo 'checked="checked"'; ?>>
    <label> Sterilisasi</label><br>
    <input type="checkbox" id="operasi" name="jenis[]" value="operasi" <?php if(in_array("operasi",$jenis)) echo 'checked="checked"'; ?>>
    <label> Tindakan Operasi</label><br>
    <input type="checkbox" id="cekdarah" name="jenis[]" value="cekdarah" <?php if(in_array("cekdarah",$jenis)) echo 'checked="checked"'; ?>>
    <label> Cek Darah</label><br>
    <input type="checkbox" id="lainnya" name="jenis[]" value="lainnya" <?php if(in_array("lainnya",$jenis)) echo 'checked="checked"'; ?>>
    <label> Lainnya</label><br>
    
<?php
    }
?>

But however, it always just checking one value even when the array itself has 2 value. Is there anything I write wrong or anything I miss? Thank You very much for your help.

Tags:

2

Answers


  1. 0

    I think there is a problem where you are using the mysqli_fetch_array() function.

    The mysqli_fetch_array() function accepts a result object as a parameter, retrieves the contents of the current row in the given result object, and returns them as an associative or, numeric array.

    Syntax:
    mysqli_fetch_array ("database_name", "mode")

    Parameters:

    1. database_name: The database on which operations are performed. It is a mandatory parameter.

    2. mode: This is an integer value specifying the type of the returned array. The value of this can be one of the following −

    a. MYSQLI_ASSOC

    b. MYSQLI_NUM

    c. MYSQLI_BOTH

    That’ll be all.

    Login or Signup to reply.
  2. 0

    First I’ll check if the result returned from the DB is correct by executing the query into the DB (basically validating the SQL)
    I have doubts that you may need to put $nopemeriksaan in quotes. If everything is looking fine you can check if this part of your code is returning what you expect

    while($row = mysqli_fetch_array($result)) {
        $jenis = explode(",", $row['jenis']);

    I used to write PHP and if I remember correctly mysqli_fetch_array is returning an array so in this case instead of using $row[‘jenis’] you have to use $row[0]
    If you still want to use the response as a dictionary you can use mysqli_fetch_assoc

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search