Get single row using mysqli from mysql db

Question

I am trying to display a single row data using mysqli. The query is

$getfield = mysqli_query($con,"select name from as_users where user_id=34");
if (mysqli_num_rows($getfield) > 0) 
{
     while($rowpwd = mysqli_fetch_array($getfield))
        {
           echo $rowpwd['name'];
        }
}

if I print then i get

echo '<pre>';
print_r(mysqli_fetch_array($getfield));
echo '</pre>';

Array
(
    [0] => abc
    [name] => abc
)

But getting the name inside the while loop doesn't work.

Any help is highly appreciated.

Why you use WHILE loop for that but you want only a single row result. — Adhan Timothy Younes
– Adhan Timothy Younes, Commented Jun 1, 2017 at 7:35
@AdhanTimothyYounes Exactly. That's what I am looking for. It will always return a single row. — Prithviraj Mitra
– Prithviraj Mitra, Commented Jun 1, 2017 at 7:37

Adhan Timothy Younes · Accepted Answer · 2017-06-01 07:47:22Z

1

Just try this:

$getfield = mysqli_query($con,"select name from as_users where user_id=34");
if (mysqli_num_rows($getfield) > 0) 
{
     $rowpwd = mysqli_fetch_array($getfield)['name'];
     echo $rowpwd;
}

OR

$getfield = mysqli_query($con,"select name from as_users where user_id=34");
if (mysqli_num_rows($getfield) > 0) 
{
   $rowpwd = mysqli_fetch_array($getfield);
   echo $rowpwd['name'];
}

answered Jun 1, 2017 at 7:47

Adhan Timothy Younes

5803 silver badges12 bronze badges

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

1 Comment

Prithviraj Mitra Over a year ago

Brilliant. Thanks a lot mate. This is exactly what I was looking for.

Josiah · Accepted Answer · 2017-06-01 07:30:33Z

1

Try this:

$getfield = mysqli_query($con,"select name from as_users where user_id=34");
if (mysqli_num_rows($getfield) > 0) 
$whatYouWant = array();
{
     while($rowpwd = mysqli_fetch_array($getfield))
        {
           //echo $rowpwd['name'];
           $whatYouWant[] = $rowpwd['name'];
        }
}



echo '<pre>';
print_r($whatYouWant);
echo '</pre>';

answered Jun 1, 2017 at 7:30

Josiah

1481 silver badge12 bronze badges

11 Comments

Prithviraj Mitra Over a year ago

Let me try with this.

Prithviraj Mitra Over a year ago

I did var_dump($whatYouWant); but it says NULL. I am sure the value is there.

Josiah Over a year ago

Thanks @VK321. Help me out

VK321 Over a year ago

try echo mysqli_num_rows($getfield); and tell me what you get?

Prithviraj Mitra Over a year ago

@VK321 It prints 1.

|

VK321 · Accepted Answer · 2017-06-01 07:30:44Z

0

Change:

mysqli_fetch_array

To: If you want key of row

mysqli_fetch_assoc

To:If you want index of row

mysqli_fetch_row

edited Jun 1, 2017 at 7:30

answered Jun 1, 2017 at 7:28

VK321

6,0135 gold badges48 silver badges53 bronze badges

3 Comments

u_mulder Over a year ago

How does this help?

Prithviraj Mitra Over a year ago

No error but it's not printing the value inside the loop.

VK321 Over a year ago

inside loop what you get when you do print_r($rowpwd);

Collectives™ on Stack Overflow

Get single row using mysqli from mysql db

3 Answers 3

1 Comment

11 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

11 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related