<?php
function LoadPNG($imgname)
{
    /* Attempt to open */
    $im = @imagecreatefrompng($imgname);

    /* See if it failed */
    if(!$im)
    {
        /* Create a blank image */
        $im  = imagecreatetruecolor(150, 30);
        $bgc = imagecolorallocate($im, 255, 255, 255);
        $tc  = imagecolorallocate($im, 0, 0, 0);

        imagefilledrectangle($im, 0, 0, 150, 30, $bgc);

        /* Output an error message */
        imagestring($im, 1, 5, 5, 'Error loading ' . $imgname, $tc);
    }

    return $im;
}


$username = "nawa";
$password = "*********";
$hostname = "localhost";

//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");

//select a database to work with
$selected = mysql_select_db("nawa",$dbhandle)
or die("Could not select database ".$database);

//haal getal uit database
$sql = "SELECT nm, kills
        FROM   killlist
        WHERE  nm = ".mysql_real_escape_string($_REQUEST['nm']);

$result = mysql_query($sql);

if (!$result) {
    die("Could not successfully run query ($sql) from DB: " . mysql_error());
}

if (mysql_num_rows($result) == 0) {
    die("No such nm found.");
}

// Er hoort maar 1 row te zijn:
if (mysql_num_rows($result) > 1) {
    die("Error more then one row found.");
}

$row = mysql_fetch_assoc($result);

$number = $row["kills"]

//close the connection
mysql_close($dbhandle);



$im = LoadPNG('test.png');
$black = imagecolorallocate($im, 0, 0, 0);
$text = "Kills: $number";

imagestring($im, 5, 5, 85, $text, $black);

header('Content-type: image/png');
imagepng($im);
imagedestroy($im);
?>