function executeQuery($query) { $mysql_handler = new MySQlConnector("root", "chotu", "imagedb"); $mysql_handler->connect(); $result = $mysql_handler->execute($query); $mysql_handler->close(); $i = 1; while ($row = mysql_fetch_array($result)) { echo '<img src="addImage.php?imageID=' . $row['imageID'] . '">'; echo ' '; if ($i % 5 == 0) { echo '<br />'; } $i += 1; } }
return $rgb; default: case 'orange': $rgb['r'] = 255; $rgb['g'] = 127; $rgb['b'] = 127; return $rgb; //case 'magenta': } } $mysql_handler = new MySQlConnector("root", "chotu", "imagedb"); $mysql_handler->connect(); $id = $_GET['imageID']; $query = "select * from image where imageID={$id};"; //echo $query; //Never Use echo and draw something. $result = $mysql_handler->execute($query); $row = mysql_fetch_array($result); //$img = new Image((int)$row['width'], (int)$row['height'], $row['back_color'], $row['fore_color']); //$img->drawImage('png'); $my_img = imagecreate((int) $row['width'], (int) $row['height']); $bcolor = getColorCodes($row['back_color']); $background = imagecolorallocate($my_img, $bcolor['r'], $bcolor['g'], $bcolor['b']); $bcolor = getColorCodes($row['fore_color']); $foreground = imagecolorallocate($my_img, $bcolor['r'], $bcolor['g'], $bcolor['b']); /* *Display all the text related to this image. */ $query = "select * from text where imageId={$id};"; $result = $mysql_handler->execute($query); while ($row = mysql_fetch_array($result)) { imagestring($my_img, $row['font'], $row['x'], $row['y'], $row['text'], $foreground);