Using PDO to extract specific values from mysql database using php

Question

This is the PHP code am using. I want to extract only details of userProfession = "Teacher" from the database how do I achieve that?

$stmt = $DB_con->prepare('SELECT userID, userName, userProfession, userPic FROM tbl_users ORDER BY userID DESC');
$stmt->execute();

if($stmt->rowCount() > 0)
{
    while($row=$stmt->fetch(PDO::FETCH_ASSOC))
    {
        extract($row);
        ?>
        <div class="col-xs-3">
            <p class="page-header"><?php echo $userName."&nbsp;/&nbsp;".$userProfession; ?></p>
            <img src="user_images/<?php echo $row['userPic']; ?>" class="img-rounded" width="250px" height="250px" />
            <p class="page-header">
            <span>
            <a class="btn btn-info" href="editform.php?edit_id=<?php echo $row['userID']; ?>" title="click for edit" onclick="return confirm('sure to edit ?')"><span class="glyphicon glyphicon-edit"></span> Edit</a> 
            <a class="btn btn-danger" href="?delete_id=<?php echo $row['userID']; ?>" title="click for delete" onclick="return confirm('sure to delete ?')"><span class="glyphicon glyphicon-remove-circle"></span> Delete</a>
            </span>
            </p>
        </div>

Add a WHERE clause to your statement.

Condorcho
– Condorcho

2017-02-23 16:58:25 +00:00
Commented Feb 23, 2017 at 16:58 — Condorcho
– Condorcho, Commented Feb 23, 2017 at 16:58
mysqltutorial.org/basic-mysql-tutorial.aspx

CD001
– CD001

2017-02-23 16:59:34 +00:00
Commented Feb 23, 2017 at 16:59 — CD001
– CD001, Commented Feb 23, 2017 at 16:59

user4965214 · Accepted Answer · 2017-02-23 17:00:06Z

1

SELECT userID, userName, userProfession, userPic FROM tbl_users WHERE userProfession = "Teacher" ORDER BY userID DESC

Collectives™ on Stack Overflow

Using PDO to extract specific values from mysql database using php

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related