the following code supposed take incoming todo task database , divide them state of being done, such todo, working, , finished, reason after first foreach loop fires fine, other foreach loops don't seem anything?
<?php require_once 'app/init.php'; $itemquery = $db->prepare("select id, name, state items user = :user"); $itemquery->execute(['user'=>$_session['user_id']]); $items = $itemquery->rowcount() ? $itemquery : []; ?> <!doctype html> <html> <head> <title>todo</title> <link rel="stylesheet" type="text/css" href="css/bootstrap.min.css"> <link rel="stylesheet" type="text/css" href="css/style.css"> </head> <body> <div class="container_fluid"> <div class="row"> <h1 class="col-md-12 text-center">todo</h1> </div> <div class="row list_container"> <div class="todo_column col-md-4"> <ul> <?php foreach($items $item): ?> <?php if($item['state'] == 1): ?> <li> <span><?php echo $item['name']; ?></span><br /> <button type="button" class="btn btn-danger">delete</button> <button type="button" class="btn btn-warning">-></button> </li> <?php endif; ?> <?php endforeach; ?> </ul> </div> <div class="working_column col-md-4"> <ul> <?php foreach($items $item): ?> <?php if($item['state'] == 2): ?> <li> <span><?php echo $item['name']; ?></span><br /> <button type="button" class="btn btn-danger">delete</button> <button type="button" class="btn btn-warning">-></button> </li> <?php endif; ?> <?php endforeach; ?> </ul> </div> <div class="finished_column col-md-4"> <ul> <?php foreach($items $item): ?> <?php if($item['state'] == 3): ?> <li> <span><?php echo $item['name']; ?></span><br /> <button type="button" class="btn btn-danger">delete</button> <button type="button" class="btn btn-warning">-></button> </li> <?php endif; ?> <?php endforeach; ?> </ul> </div> </div><!-- end of list_container--> <div class="row"> <form action="add.php" method="post" class="col-md-12 item_add"> <input type="text" name="name" placeholder="write task" class="input col-md-8 col-md-offset-2" required> <button type="submit" value="add" class="btn btn-success col-md-4 col-md-offset-4">add task</button> </form> </div> </div> <!-- end of container --> </body> </html>
i assumed using pdo. try this:
require_once 'app/init.php'; $query = "select id, name, state items user = :user"; $itemquery = $db->prepare($query); $itemquery->execute(['user'=>$_session['user_id']]); $items = $itemquery->fetchall(pdo::fetch_assoc); 
Comments
Post a Comment