PHP echo result from MySQL SELECT

Question

I have this PHP (testing):

<?php
if (isset($_POST['submit'])) {

  $link = mysqli_connect("localhost","php","","A");

  $query = "SELECT passport FROM users WHERE mail = '$_POST[mail]';";

  $result = $link->query($query);

}
?>

A manual SELECT using the same $query shows:

mysql> SELECT passport FROM users WHERE mail = '[email protected]';
+----------------------+
| passport             |
+----------------------+
| 8KQSWCZPJAUV1M9D4TFG |
+----------------------+
1 row in set (0.00 sec)

I am trying to echo the $result in PHP which should show 8KQSWCZPJAUV1M9D4TFG but it is null. What am I doing wrong here?

Update:

<?php
if (isset($_POST['submit'])) {

  $link = mysqli_connect("localhost","php","","A");

  $query = "SELECT passport FROM users WHERE mail = '$_POST[mail]';";

  $result = mysqli_query($query);

  $row    = mysqli_fetch_assoc($result);

  echo $row["passport"];

}
?>

This also is still null.

you can remove ; from the end of query string if you want, and on the next line echo $query, to make sure what query exactly is generated. — Adil Abbasi
– Adil Abbasi, Commented Jan 14, 2014 at 10:17

hsz · Accepted Answer · 2014-01-14 10:09:19Z

1

Just try with:

$result = mysqli_query($query);
$row    = mysqli_fetch_assoc($result);

answered Jan 14, 2014 at 10:09

hsz

153k63 gold badges268 silver badges320 bronze badges

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

2 Comments

akirk Over a year ago

And output it echo $row["passport"];

user2656114 Over a year ago

Thanks! I gave that a go and updated this question with what I'm using, but it's still not giving me the result that the manual SELECT does?

Joran Den Houting · Accepted Answer · 2014-01-14 10:11:53Z

1

$link = new mysqli("localhost", "php", "", "A");

$query = "SELECT passport FROM users WHERE mail = '$_POST[mail]';";
$result = $link->query($query);

while($row = $result->fetch_array())
{
  echo $row['passport'];
}

You need to use object based MySQLi in order to use $link->query()

answered Jan 14, 2014 at 10:11

Joran Den Houting

3,1634 gold badges24 silver badges51 bronze badges

Comments

Muneer · Accepted Answer · 2014-01-14 10:18:30Z

0

Check this one.

It should work for you.

$mysqli = new mysqli('localhost', 'root', 'pass123', 'test');
$query = "SELECT passport FROM users WHERE mail = '$_POST[mail]'";

$result = $mysqli->query($query);

// PRINT
if($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo stripslashes($row['passport']);    
    }
}

answered Jan 14, 2014 at 10:18

Muneer

7,5708 gold badges41 silver badges65 bronze badges

Comments

Awlad Liton · Accepted Answer · 2014-01-14 10:18:49Z

0

You need to fecth in loop and fix query(remove ;) like this:

<?php
if (isset($_POST['submit'])) {

  $link = mysqli_connect("localhost","php","","A");

  $query = "SELECT passport FROM users WHERE mail = '$_POST[mail]'";

  $result = mysqli_query($query);

  while( $row = mysqli_fetch_assoc($result)){

     echo $row["passport"];
    }

}
?>

answered Jan 14, 2014 at 10:18

Awlad Liton

9,3513 gold badges30 silver badges53 bronze badges

1 Comment

Awlad Liton Over a year ago

@user2656114 : did you try this?

Collectives™ on Stack Overflow

PHP echo result from MySQL SELECT

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related