示例#1
0
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;
    }
}
示例#2
0
        case 'white':
            $rgb['r'] = $rgb['g'] = $rgb['b'] = 0xff;
            return $rgb;
        case 'yellow':
            $rgb['r'] = $rgb['g'] = 0xff;
            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.