Fetching data from database in php file

Question

I am trying to fetch data from table. Table contains the data and query is true. Even why following query says $u and $t are not define. While condition becoming false.

I manually checked in database, it was showing results.

$url = "http://paulgraham.com/";
$user_id = "123";
$con = mysqli_connect('127.0.0.1', 'root', '', 'mysql');
if (mysqli_connect_errno())
{
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    return;
}
$result = mysqli_query($con,"SELECT * FROM post_data WHERE userid =".$url." and url=".$user_id."");
while ($row = @mysqli_fetch_array($result))
{
    echo "hi";
    $t = $row['title'];
    $u = $row['url'];

}

echo "title is : $t";
echo "url is : $u";

"SELECT * FROM post_data WHERE userid =".$url." and url=".$user_id."" You still really don't see where the problem is ? — Brewal
– Brewal, Commented Oct 31, 2013 at 16:34

Brewal · Accepted Answer · 2013-10-31 16:36:27Z

1

Giving your SQL query :

"SELECT * FROM post_data WHERE userid =".$url." and url=".$user_id.""

You can see you are mixing url and userid... Change to :

"SELECT * FROM post_data WHERE userid =".$user_id." and url=".$url.""

Also define your $t and $u variables before your loop in case you have no record. Next time, try to var_dump your generated query to test it.

answered Oct 31, 2013 at 16:36

Brewal

8,1942 gold badges28 silver badges38 bronze badges

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

Comments

symcbean · Accepted Answer · 2013-10-31 16:44:04Z

1

If you were able to see the errors the DBMS is reporting back to PHP then you'd probably be able to work out what's wrong with the code.

Before the 'while' loop try...

print mysql_error();

(the obvious reason it's failing is that strings mut be quoted in SQL, and you've got the parameters the wrong way around)

answered Oct 31, 2013 at 16:44

symcbean

48.4k6 gold badges63 silver badges99 bronze badges

Collectives™ on Stack Overflow

Fetching data from database in php file

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related