Tatara Posted August 14, 2006 Share Posted August 14, 2006 I want to create a script that creates an image on the fly based on one $HTTP_GET_VARS and two or three sql commandsthis is the base for what i want but instead of using the http_get_vars function i want to call the data from a database the only HTTP_GET_VARS i want is a 'user' [code]<?php$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]Can anybody help Quote Link to comment Share on other sites More sharing options...
AndyB Posted August 14, 2006 Share Posted August 14, 2006 ... then include a connection to the database and execute whatever query you need to retrieve whatever information you want in the same script. Quote Link to comment Share on other sites More sharing options...
Tatara Posted August 14, 2006 Author Share Posted August 14, 2006 Ok ill comment what i want in the coding. I know how to code the connection and the query but i do not know how to add it to the variable[code]<?php//add $user = $HTTP_GET_VARS['user'];//used to find which user to query for in the database//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 Link to comment Share on other sites More sharing options...
Tatara Posted August 14, 2006 Author Share Posted August 14, 2006 bump Quote Link to comment Share on other sites More sharing options...
HeyRay2 Posted August 14, 2006 Share Posted August 14, 2006 [code=php:0]<?php//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 your_db_table 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'];?>[/code] 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.