How do I display a table

[Proximity]

How can I grab the contents of a database table and display it on the page?

Like SELECT look FROM users WHERE username = '" . filter( $_GET['username'] ) . "'" ) or die( mysql_error() and than display the look

 

[Joel]

like the actual avatar's look?

 

[Proximity]

Yes
 
But I want it like url.com/avatar.php?user=WCKD

or url.com/avatar.php?user=Joel and it will show their look you know what I mean?

 

[TesoMayn]

I assume you want this done in PHP, like a pleb?

 

[Joel]

Try doing something like this:

<img src="{INSERT HABBO IMAGING LINK}
<?php

mysql_query('SELECT look FROM users WHERE username = '" . filter( $_GET['username'] ) . "'" ') or die( mysql_error()

?>
.png">

make sure the habbo imaging link is like:

You must be registered for see links

without the brackets.

 

[Proximity]

I assume you want this done in PHP, like a pleb?

Yes

Try doing something like this:

<img src="{INSERT HABBO IMAGING LINK}
<?php

mysql_query('SELECT look FROM users WHERE username = '" . filter( $_GET['username'] ) . "'" ') or die( mysql_error()

?>
.png">

make sure the habbo imaging link is like:

You must be registered for see links

without the brackets.

?

 

[Joel]

Yes


?

using that PHP code would make it work with whatever username you desire in the "username =", you can also use that link if you like.

 

[TesoMayn]

$data = new mysqli('localhost', 'username', 'password', 'database');
if ($data->connect_error) { die("Connection failed: " . $data->connect_error); }
$username = $data->real_escape_string($_GET['username']);
$exe = $data->query("SELECT look FROM users WHERE username = '$username'");
if ($exe->num_rows > 0) {
  while($row = $exe->fetch_assoc()) {
    print "<img src=\"http://example.com/avatar.php?user={$username}\">";
  }
} else {
  echo 'Username not found';
}
$data->close();

You're welcome

 

[Proximity]

[26-Nov-2015 03:09:00 Europe/Belgrade] PHP Parse error: syntax error, unexpected '"' in C:\inetpub\wwwroot\avatarimage.php on line 11
 

[26-Nov-2015 03:09:00 Europe/Belgrade] PHP Parse error: syntax error, unexpected '"' in C:\inetpub\wwwroot\avatarimage.php on line 11

@Joel
 
@TesoMayn

You must be registered for see links

it deosn't show the avatar...

 

[TesoMayn]

What is it putting as the image URL?

Sorry, I normally test code before posting it but this time I did not.

 

[Proximity]

<img src="

You must be registered for see links

"> It put that

 

[TesoMayn]

And what's the URL to the avatar?
IE:

You must be registered for see links

 

[Proximity]

I don't have the image locally I think @Joel got what I was trying to do I wanted to grab the look from the db and place it in like

You must be registered for see links

 

[TesoMayn]

My code should work, you just need to replace the URL with the proper URL.

 

[Proximity]

what do you mean

 

[Weasel]

Replace

print "<img src=\"http://example.com/avatar.php?user={$username}\">";

with

print "<img src=\"http://habbo.nl/habbo-imaging/avatarimage?figure={$row['look']}\">";

 

[Proximity]

OMG thank you @Exalted Close thread please.@Mods
 

$data = new mysqli('localhost', 'username', 'password', 'database');
if ($data->connect_error) { die("Connection failed: " . $data->connect_error); }
$username = $data->real_escape_string($_GET['username']);
$exe = $data->query("SELECT look FROM users WHERE username = '$username'");
if ($exe->num_rows > 0) {
  while($row = $exe->fetch_assoc()) {
    print "<img src=\"http://example.com/avatar.php?user={$username}\">";
  }
} else {
  echo 'Username not found';
}
$data->close();

You're welcome

Replace

print "<img src=\"http://example.com/avatar.php?user={$username}\">";

with

print "<img src=\"http://habbo.nl/habbo-imaging/avatarimage?figure={$row['look']}\">";

Thank you. You two are the best.

 

[BIOS]

If you're using MySQLi, why not make use of prepared statements rather than throwing raw variables into the query? You're throwing away possibly one of the best features of it...

 

[Proximity]

If you're using MySQLi, why not make use of prepared statements rather than throwing raw variables into the query? You're throwing away possibly one of the best features of it...

You mind remaking the script than?

 

[Weasel]

You mind remaking the script than?

Stop trying to get spoonfed.