Dynamic Sigs

[ProtoJazz]

Im trying to make a dynamic signiture system that will display a users charecter data from my ADR Rpg program, How can I make a good SQL Qurie that will display about 5-10 peices of data....so far my image looks like this

<?php
header ("Content-type: image/png");
$text = "Weeeeee";
$im = imagecreatefrompng ("halo.png");
$white = imagecolorallocate ($im,255,255,255);
$blue = imagecolorallocate ($im,0,0,255);
$black = imagecolorallocate ($im,0,0,0);
imagestring ($im, 5, 0, 0, "$text", $blue);
imagepng($im);
?>

How can I get a sql result instead of my $text?

[kkobashi]

I am assuming you are trying to create a PNG from the username text taken from a mysql database. If so...

Assume the following:

MySql user is ProtoJazz
Password is secretpassword
Table name is users
Database is stored on the localhost
Database name is thedatabase

The mysql definition schema:

create table users {
id unsigned int auto_increment primary key,
username varchar(50) not null,
password varchar(10) not null
} type=myisam;

To retrieve the username from the database:

mysql_connect("localhost","ProtoJazz","secretpassword");
mysql_select_db("thedatabase");

$query = "SELECT * from users where username='" . $username . "'" . " and " . password='" . $password . "'";

$result = mysql_query($query);

if (mysql_num_rows($result) > 0) {
header ("Content-type: image/png");
$row = mysql_fetch_array($result);
$text = $row['username'];
$im = imagecreatefrompng ("halo.png");
$white = imagecolorallocate ($im,255,255,255);
$blue = imagecolorallocate ($im,0,0,255);
$black = imagecolorallocate ($im,0,0,0);
imagestring ($im, 5, 0, 0, "$text", $blue);
imagepng($im);

}

[ProtoJazz]

I think I did it right but I still get an error

Parse error: syntax error, unexpected T_VARIABLE in /home/protojaz/public_html/adrBoard/test.php on line 20

This is the Code I used

<?php
header ("Content-type: image/png");
$uid = 2;
$im = imagecreatefrompng ("halo.png");
mysql_connect("localhost","***","***");
mysql_select_db("***");

$query = "SELECT * FROM phpbb_adr_characters WHERE character_id= $uid;

$result = mysql_query($query);

if (mysql_num_rows($result) > 0) {

$row = mysql_fetch_array($result);
$text = $row ['character_name'];

$white = imagecolorallocate ($im,255,255,255);
$blue = imagecolorallocate ($im,0,0,255);
$black = imagecolorallocate ($im,0,0,0);
imagestring ($im, 5, 0, 0, "$text", $blue);
imagepng($im);

}
?>

[NogDog]

All the red text in the php code block above should give you a hint: you have omitted the closing quote at the end of your query string.

[ProtoJazz]

Cool thanks, one last thing, It works as a php file....but when I save it as a PNG it says

The image “http://wingedforest.info/adrBoard/test.png” cannot be displayed, because it contains errors.

WHY? It worked before I converted it....

[bpat1434]

Do you have the ".png" extension to be parsed as php?

[ProtoJazz]

I have no idea what you mean....I figured it out though...I can just add a file.php/file.png and it works...Have a look at a few I made

[bpat1434]

I mean in Apache httpd.conf, did you have this line:

AddType application/x-httpd-php .png .php .php3 .php4 .phtml

Glad to hear you got it working. Don't forget to makr it as resolved.