Simple PHP / MySQL data results

Question

I grabbed this piece of code off the Internet and modified it slightly to fit my needs but it doesn't work and I don't know why. I'm sure I've overlooked something but I don't know enough about PHP to know what I'm doing wrong. The uid is showing up, but nothing else. I'm just trying to get information from the MySQL data based on the user's session id. I checked the database to make sure that the uid that shows matches the data -- it does.

<?php

include("connect.php");
session_start();

$uid = $_SESSION['user_id'];

$result = mysql_query("SELECT * FROM users WHERE id = ' . $uid . '");

if ($result) {
   echo "Connect"; } else
   { die('Invalid query: '.mysql_error()); }

$info = mysql_fetch_array($result);

echo "<br>ID: ", $uid;
echo "<br>Full Name: " .$info['full_name'] ;
echo "<br>User Name: " .$info['user_name'] ;
echo "<br>";

?>

p.s. - Yes, I know that mysql_query (and other syntax like it) has been deprecated.

nanobash · Accepted Answer · 2014-03-07 13:44:57Z

6

$result = mysql_query("SELECT * FROM users WHERE id = '" . $uid . "'"); // not ' . $uid . '

NOTE: You were searching for . ID . not actual ID

edited Mar 7, 2014 at 13:44

answered Mar 7, 2014 at 13:33

nanobash

5,4967 gold badges41 silver badges56 bronze badges

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

Comments

Abhik Chakraborty · Accepted Answer · 2014-03-07 13:42:50Z

2

Query should be as

$result = mysql_query("SELECT * FROM users WHERE id = $uid ");

Assuming id is int in the table

You had

$result = mysql_query("SELECT * FROM users WHERE id = ' . $uid . '");
                                                        ^....   ^.... was the issue.

edited Mar 7, 2014 at 13:42

answered Mar 7, 2014 at 13:33

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

1 Comment

Abhik Chakraborty Over a year ago

Yeah I know but getting little older so cant forget the old school way of writing query i.e. quotes for string date etc and no quotes for integer :)

Collectives™ on Stack Overflow

Simple PHP / MySQL data results

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related