How to make a list from sql with php while loops

Question

So I have a database table, named todolist, and I want to display the whole to do list in a box. What I have right now is this:

$db = (INFO HERE :));    
$sql = "SELECT * FROM todolist";
$result = mysqli_query($db, $sql);
if (mysqli_num_rows($result) == 0) {
  echo "There is nothing else to do! :)";
} else {
}

What do I put in the else, for it to display everything on a list? Thanks

what list? what you want as expected outcome? Please show. A sample:-else { while($row = mysqli_ftech_assoc($result)){echo "<pre/>";print_r($row);} } — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Feb 14, 2017 at 6:30

Francisco F. · Accepted Answer · 2017-02-16 06:11:59Z

1

try something like below:

 <?php
    $db = (INFO HERE :));    
    $sql = "SELECT * FROM todolist";
    $result = mysqli_query($db, $sql);
    if(mysqli_num_rows($result) == 0) {
        echo "There is nothing else to do! :)";
    } 
    else{
        ?>
        <ul>
            <?php
            while($row = mysqli_fetch_assoc($result)){
                ?>
                  <li><?php echo $row["yourColumnName"] ?></li><?php                
            }?>
            </ul><?php
        }

?>

edited Feb 16, 2017 at 6:11

Francisco F.

1211 gold badge4 silver badges14 bronze badges

answered Feb 14, 2017 at 6:37

lazyCoder

2,5513 gold badges25 silver badges44 bronze badges

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

Comments

Naincy · Accepted Answer · 2017-02-14 06:36:44Z

1

$sql = "SELECT * FROM todolist";
$result = mysqli_query($db, $sql);
if (mysqli_num_rows($result) == 0) {
   echo "There is nothing else to do! :)";
   exit;
}

while ($row = mysql_fetch_assoc($result)) {
  // To see all data
       // print_r($row);
  //  to print single column value 
      //echo $row['id];
}

answered Feb 14, 2017 at 6:36

Naincy

2,9431 gold badge15 silver badges21 bronze badges

Comments

Alexey Shatrov · Accepted Answer · 2017-02-14 06:41:28Z

1

while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
    //Do something here  with $row array , for example print_r
print_r($row);
}

answered Feb 14, 2017 at 6:41

Alexey Shatrov

4705 silver badges12 bronze badges

Collectives™ on Stack Overflow

How to make a list from sql with php while loops

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related