Select in php display

Question

$sqlQuery = "SELECT username as display_name, fullname as full_name, email as email, role as administrators, status as be_on FROM admin";

record role:0,1,...

I want the role of the administrators will display 1 is admin and if equal to 0 , then show the user.

Who can help me?

I want to select to retrieve the value in record roles as administrators . But when displayed on the web if it role = 0 is admin and role = 1 is user. — Trần Anh Tuấn, Nov 17 '15 at 12:39

score 0 · Accepted Answer · answered Nov 17 '15 at 12:37

0

I think your look for the IF statement

SELECT IF(`admin`.`role`= 1,TRUE,FALSE) FROM ...

http://www.mysqltutorial.org/mysql-if-function.aspx

answered Nov 17 '15 at 12:37

CiaranSynnott

908
5
9

score 0 · Answer 2 · edited May 23 '17 at 11:52

0

My suggestion would be to use mysqli functionality as such:

<?php
$mysqliClass = mysqli_init();
$mysqliClass->real_connect("hostname or IP", "dbUsername", "dbPassword", "databasename");

$query = "SELECT `username` AS display_name, `fullname` AS full_name, `email`, `role` as administrators, `status` as be_on FROM `admin`";
$rs = $mysqliClass->query($query); # Preform your query
$showUser = false; # Start negative
$row = []; # Set a variable for the row to go into
while ($result = mysqli_fetch_assoc($rs)) # Fetch each result one at a time
{
    if ($result['administrators'] == 1) # Check the role
    {
        $showUser = true; # Set the show to true if it equals 1
        $row = $result; # Set the row to equal the result given
    }
    break; # You only need the first result
}
if ($showUser)
{
    /* Do your work with $row! */
}
?>

I have also removed email AS email for just email as it will already have this name so it is unrequired mess.

I would also recommend adding a WHERE clause in your query to reduce (filter) the results

If you are using an image from your DB, you could do something such as this:

<img src="<?=$row['image_column_name'];?>" height="120" width="120" />

And this should show the image as you want it to :)

Source of example code

Fuller example like the original answer:

<?php

$mysqliClass = mysqli_init();
$mysqliClass->real_connect("hostname or IP", "dbUsername", "dbPassword", "databasename");

$query = "SELECT `name`, `logo` AS describe , IF(`status` = 0, 'Online', 'Offline') as be_on FROM `domain`";
$rs = $mysqliClass->query($query);

$rows = []; # This will have more than one in it this time!
while ($result = mysqli_fetch_assoc($rs))
{
    $rows[] = $result;
}

foreach ($rows as $r)
{
    foreach ($r as $rowKey => $rowValue) # Double loop because you have an array in an array this way
    {
        if ($rowKey == "describe")
        {
            print '<img src="' . $rowValue . '" height="120" width="120" />';
        }
    }
}

?>

edited May 23 '17 at 11:52

Community

1
1

answered Nov 17 '15 at 12:41

Can O' Spam

2,718
4
19
45

If it fixes your issue, please consider marking as correct and upvoting :) – Can O' Spam Nov 17 '15 at 12:47
@TrầnAnhTuấn, certainly, if you can add an edit to your question with some code you've tried I can see what I can do :) – Can O' Spam Nov 17 '15 at 12:53
I have 1 record logo in database. I want select it to display in my web. – Trần Anh Tuấn Nov 17 '15 at 12:55
I shall add an amend to my question :) – Can O' Spam Nov 17 '15 at 12:56
My code: SELECT name as name, logo as describe ,IF(status = 0, 'Online', 'Offline') as be_on FROM domain"; – Trần Anh Tuấn Nov 17 '15 at 12:56
@TrầnAnhTuấn, I have added the dit so you can adjust how you need or would you like a fuller version like the original? :) – Can O' Spam Nov 17 '15 at 12:59
Ok i will try it. Tks so much again :) – Trần Anh Tuấn Nov 17 '15 at 13:02
@TrầnAnhTuấn, as the SO community says: "**#SOReadyToHelp**", also please see I have added a further exploded version that *theoretically* should give what you are looking for :) – Can O' Spam Nov 17 '15 at 13:06
@TrầnAnhTuấn, any news on the progress of this? :) – Can O' Spam Nov 17 '15 at 13:25

Select in php display

2 Answers2

Linked