MySQL Select data from a row

Question

i got this code

if($_GET['action'] == 'test')
        {

            $query = "SELECT * FROM users WHERE user_id = {$_GET['id']}";
            $result = @mysqli_query($dbc, $query) or die('Query failed: ' . mysqli_error($dbc));


        }

And now i want to output a text like Username: Martijn (That's the user_name from ID 1) Reg date: 01/01/2015

But i can't get that working. I checked many stackoverflow questions but couldnt find it. Here you can see the website: http://admincontrol.martijnmelchers.nl/show_profile.php?action=test&id=1

Step 1, remove the error suppressing @ in @mysqli_query. — j08691
– j08691, Commented Jan 1, 2015 at 18:32
So $result = mysqli_query($dbc, $query) or die('Query failed: ' . mysqli_error($dbc)); — martijnmelchers
– martijnmelchers, Commented Jan 1, 2015 at 18:33
Your page says undefined variable row. Where is your while() code? — Ohgodwhy
– Ohgodwhy, Commented Jan 1, 2015 at 18:36

Rubén Rincón · Accepted Answer · 2015-01-01 18:48:21Z

2

You don't need that error suppressiong there

This is usually in the third page in PHP-MySQL tutorials.

You have to add to your code, after the $result... line:

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

 echo "<p> Username" . $row['user_name'] . " - Reg Date" . $row['reg_date'] . " .</p>";

}

edited Jan 1, 2015 at 18:48

answered Jan 1, 2015 at 18:38

Rubén Rincón

708 bronze badges

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

1 Comment

martijnmelchers Over a year ago

Thank you very munch! I'll make it the answer when i can :)

Lucy Brockleworth · Accepted Answer · 2015-01-01 18:43:31Z

1

You can use the mysqli_fetch_array function for this.

if($_GET['action'] == 'test')
{
        $query = "SELECT * FROM users WHERE user_id = {$_GET['id']}";
        $result = @mysqli_query($dbc, $query) or die('Query failed: ' . mysqli_error($dbc));
        $row = mysqli_fetch_array($result, MYSQLI_ASSOC); 
}
echo $row["Username"];

You'd have to replace Username with whatever your field name is in the database.

answered Jan 1, 2015 at 18:43

Lucy Brockleworth

211 silver badge8 bronze badges

Collectives™ on Stack Overflow

MySQL Select data from a row

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related