Jump to content

Archived

This topic is now archived and is closed to further replies.

Tatara

Please Help!!

Recommended Posts

ok im still having trouble its connecting to the database and pulling the data but instead of looking like this
[IMG]http://i80.photobucket.com/albums/j183/wmbandgeek88/test2.png[/img] it looks like this [IMG]http://i80.photobucket.com/albums/j183/wmbandgeek88/bar.png[/img]

heres the code again
[code]<?php
$con = mysql_connect("localhost","myusername","mypassword");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

if(!mysql_select_db("mydatabase", $con)) {
die('Could not connect: ' . mysql_error());
}

//used to find which user to query for in the database
$user = mysql_real_escape_string(trim($HTTP_GET_VARS['user']));

// Query
$sql = "SELECT item, have, need FROM questbar WHERE user = '$user'";

// Run Query
$result = mysql_query($sql) or die("Error retrieving user info: ".mysql_error());

// Grab the user results
while( $row = mysql_fetch_array($result) ){
  $item = $row['item'];
  $have = $row['have'];
  $need = $row['need'];
}

// You can get rid of these
//change these to get the value from the results of the query
//$item = $HTTP_GET_VARS['item'];
//$have = $HTTP_GET_VARS['have'];
//$need = $HTTP_GET_VARS['need'];

$height = 25;
$width = 200;
$fontsize = 6;
$frac = $have/$need;
$pct = 100 * $frac;

$img = imagecreate($width,$height);
$red = imagecolorallocate($img,255,0,0);
$black = imagecolorallocate($img,0,0,0);
$white = imagecolorallocate($img,255,255,255);
$bg = imageCreateFromPNG ('bg.png');
$bar =imageCreateFromPNG ('fill.png');
imageSetTile ($img, $bg);
imageFilledRectangle ($img, 0, 0, 116, 40, IMG_COLOR_TILED);
imageSetTile ($img, $bar);
ImageFilledRectangle($img, 7, 22, (114 * $frac), 34, IMG_COLOR_TILED);

$font = 'arial.ttf';
$text1 = "Questing For";
$text2 = $item;
$text3 = $have . "/" . $need;
$textwidth1 = floor(imagefontwidth($font) * strlen($text1));
$textleft1 = (($width - $textwidth1) / 2) + 12;
$textwidth2 = floor(imagefontwidth($font) * strlen($text2));
$textleft2 = (($width - $textwidth2) / 2) + 12;
imagettftext($img, $fontsize, 0, $textleft1, 8, $white, $font, $text1);
imagettftext($img, $fontsize, 0, $textleft2, 19, $white, $font, $text2);
imagettftext($img, 6, 0, 46, 32, $black, $font, $text3);

header('content-type: image/png');
imagepng($img);
   
?>[/code]

Share this post


Link to post
Share on other sites
[quote author=Tatara link=topic=104223.msg415565#msg415565 date=1155573159]
I ran my script and it gave me this error "Error retrieving user info: No database selected"

heres the code:
[code]<?php
$con = mysql_connect("localhost","tatara","102188");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

if(!mysql_select_db("YOURDBNAMEHERE", $con)) {
die('Could not connect: ' . mysql_error());
}

//used to find which user to query for in the database
$user = mysql_real_escape_string(trim($HTTP_GET_VARS['user']));

// Query
$sql = "SELECT item, have, need FROM questbar WHERE user = '$user'";

// Run Query
$result = mysql_query($sql) or die("Error retrieving user info: ".mysql_error());

// Grab the user results
while( $row = mysql_fetch_array($result) ){
  $item = $row['item'];
  $have = $row['have'];
  $need = $row['need'];
}

// You can get rid of these
//change these to get the value from the results of the query
//$item = $HTTP_GET_VARS['item'];
//$have = $HTTP_GET_VARS['have'];
//$need = $HTTP_GET_VARS['need'];

$height = 40;
$width = 116;
$fontsize = 6;
$frac = $have/$need;
$pct = 100 * $frac;

$img = imagecreate($width,$height);
$red = imagecolorallocate($img,255,0,0);
$black = imagecolorallocate($img,0,0,0);
$white = imagecolorallocate($img,255,255,255);
$bg = imageCreateFromPNG ('bg.png');
$bar =imageCreateFromPNG ('fill.png');
imageSetTile ($img, $bg);
imageFilledRectangle ($img, 0, 0, 116, 40, IMG_COLOR_TILED);
imageSetTile ($img, $bar);
ImageFilledRectangle($img, 7, 22, (114 * $frac), 34, IMG_COLOR_TILED);

$font = '04B_09__.ttf';
$text1 = "Questing For";
$text2 = $item;
$text3 = $have . "/" . $need;
$textwidth1 = floor(imagefontwidth($font) * strlen($text1));
$textleft1 = (($width - $textwidth1) / 2) + 12;
$textwidth2 = floor(imagefontwidth($font) * strlen($text2));
$textleft2 = (($width - $textwidth2) / 2) + 12;
imagettftext($img, $fontsize, 0, $textleft1, 8, $white, $font, $text1);
imagettftext($img, $fontsize, 0, $textleft2, 19, $white, $font, $text2);
imagettftext($img, 6, 0, 46, 32, $black, $font, $text3);

header('content-type: image/png');
imagepng($img);
   
?>[/code]
[/quote]

You forgot mysql_select_db

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.