Skip to content
Advertisement

Error getting Query Data from MySQL with PHP [closed]

Having an issue getting the MySQL Data in my Database. I don’t know if the code is fine or I have missed something, please give me an idea of how to get the data from my database.

This is the Data I want to Edit

This is the Edit Form when editing the Data

This is my Query in Time Data

<?php
    $query = "SELECT * from timetable";
    $result = mysqli_query($db, $query);
    if($result){
        while($row=mysqli_fetch_array($result)){
            $t_id=$row["t_id"];
            $time=$row["t_time"];
            $t_time=date("h:i A", strtotime($row["t_time"])); ?>
            <option <?php echo $update && $up_time == $time ? 'selected' : ''; ?> value='<?= $time ?>'><?= $t_time ?><br></option>
    <?php   }
    }
?>  

This is my Query in my Employee Data

<?php
    $query = "SELECT * from employee";
    $result = mysqli_query($db, $query);
    if($result){
        while($row=mysqli_fetch_array($result)){
            $e_id=$row["id"];
            $name=$row["e_name"]; ?>
            <option <?php echo $update && $up_employee == $e_id ? 'selected' : ''; ?> value="<?= $e_name ?>"><?= $name ?><br></option>
            <?php 
        }
    }
?>

Advertisement

Answer

Did you connect and selected the database: $db = mysqli_connect(...);

(I am not sure if the <br> is ok inside the <option>.)

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement