Tatara Posted August 14, 2006 Share Posted August 14, 2006 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 resultswhile( $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] Quote Link to comment Share on other sites More sharing options...
rab Posted August 14, 2006 Share Posted August 14, 2006 [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 resultswhile( $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 Quote Link to comment Share on other sites More sharing options...
Tatara Posted August 14, 2006 Author Share Posted August 14, 2006 Thanks Im a noob at php scripting Quote Link to comment Share on other sites More sharing options...
hackerkts Posted August 14, 2006 Share Posted August 14, 2006 Don't call yourself noob, everyone makes a mistake. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.