Tatara Posted August 17, 2006 Share Posted August 17, 2006 I want to make it where the http get var from the file name so i can call it form [i]user[/i].pngcode already worked out:[code]<?php$con = mysql_connect("host","user","pass");if (!$con) { die('Could not connect: ' . mysql_error()); } if(!mysql_select_db("db", $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 row 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'];}$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 = '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 Link to comment Share on other sites More sharing options...
ryanlwh Posted August 17, 2006 Share Posted August 17, 2006 try $_GET instead of $HTTP_GET_VARS Quote Link to comment Share on other sites More sharing options...
Tatara Posted August 17, 2006 Author Share Posted August 17, 2006 Whats the difference?What i want is to be able to call the image from http://www.mysite.com/user.png wher it takes the name of the ping and queries the database for that user and return the info. Quote Link to comment Share on other sites More sharing options...
Gobiggi Posted August 17, 2006 Share Posted August 17, 2006 $_GET is the same but has replaced $_HTTP_GET_VARS in newer php versionps. this is supposed to be a help forum so why are you people replying once and then never answering any more questions!? you did that to me before! and as a help forum i rate you 2/10 Quote Link to comment Share on other sites More sharing options...
Tatara Posted August 17, 2006 Author Share Posted August 17, 2006 youngcoders.com is a good help site but i never got the activation emailany ways thanks for answering Quote Link to comment Share on other sites More sharing options...
Gobiggi Posted August 17, 2006 Share Posted August 17, 2006 you are most welcome Quote Link to comment Share on other sites More sharing options...
Barand Posted August 18, 2006 Share Posted August 18, 2006 [quote author=Gobiggi link=topic=104635.msg417693#msg417693 date=1155851809]ps. this is supposed to be a help forum so why are you people replying once and then never answering any more questions!? you did that to me before! and as a help forum i rate you 2/10[/quote]Because when, after less than an hour had passed, you demanded that I hurry with a solution I decided to walk away. You aren't paying and I'm not on your time. I volunteer my time here and decided I'd rather spend it helping someone else after your outburst. A little more patience and you would have had a solution. 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.