Hi Walt, Jon and Daniel,
Sorry to be slow on that. I had to attend to some other things, and I also
have cleaned up the examples that I'm sending here. It's php 4.3.3. Global
vars in the ini are set to off as recommended in the ini file itself, but
does not the $_GET function allow access to variables? - Ah I've just seen
your new post re globals. I'll have to re-read the manual.
Ok, here's the main file, which does display the original images. I've left
that functionality in to show that it works. I used dreamweaver to create
it in the first place, but the trial period's run out and I haven't decided
wherther or not to buy it yet.
<?php require_once('Connections/connProperty.php'); ?>
<?php
# Constants
//define(IMAGE_BASE, '/var/www/html/mbailey/images');
define(MAX_WIDTH, 150);
define(MAX_HEIGHT, 150);
$maxRows_PrpSummary = 9;
$pageNum_PrpSummary = 0;
if (isset($_GET['pageNum_PrpSummary'])) {
$pageNum_PrpSummary = $_GET['pageNum_PrpSummary'];
}
$startRow_PrpSummary = $pageNum_PrpSummary * $maxRows_PrpSummary;
mysql_select_db($database_connProperty, $connProperty);
$query_PrpSummary = "SELECT Prp.PreStreet House, Str.Name Street, sCi.Name
Borough, Cit.Name City,
ssC.Name District, sCy.Name County, Cry.Name
Country, PcX.Pic PcXPic,
Pic.Id PicId, Pic.FileName FileName,
Pic.FileLocation Location
FROM Property AS Prp
Left Outer Join Country Cry On Cry.Id = Prp.Cry
Left Outer Join sCountry sCy On sCy.Id = Prp.sCy
Left Outer Join ssCountry ssC On ssC.Id = Prp.ssC
Left Outer Join City Cit On Cit.Id = Prp.Cit
Left Outer Join sCity sCi On sCi.Id = Prp.sCi
Left Outer Join Street Str On Str.Id = Prp.Str
Left Outer Join PicToX PcX On PcX.TargetId =
Prp.Id And PcX.TargetType = 21
And PcX.Priority = 1
Left outer join Picture Pic On Pic.Id = PcX.Pic
";
$query_limit_PrpSummary = sprintf("%s LIMIT %d, %d", $query_PrpSummary,
$startRow_PrpSummary, $maxRows_PrpSummary);
$PrpSummary = mysql_query($query_limit_PrpSummary, $connProperty) or
die(mysql_error());
$row_PrpSummary = mysql_fetch_assoc($PrpSummary);
if (isset($_GET['totalRows_PrpSummary'])) {
$totalRows_PrpSummary = $_GET['totalRows_PrpSummary'];
} else {
$all_PrpSummary = mysql_query($query_PrpSummary);
$totalRows_PrpSummary = mysql_num_rows($all_PrpSummary);
}
$totalPages_PrpSummary = ceil($totalRows_PrpSummary/$maxRows_PrpSummary)-1;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="Content-Type" content="image/jpeg; charset=iso-8859-1">
</head>
<body>
<table width="487" border="2" align="left" bgcolor="#99FFCC" frame="below">
<tr><td width="291">Address</td></tr>
<?php do { ?>
<tr>
<td height="107">
<?php echo $row_PrpSummary['House']; ?><br>
<?php echo $row_PrpSummary['Street']; ?><br>
<?php echo $row_PrpSummary['Borough']; ?><br>
<?php echo $row_PrpSummary['City']; ?><br>
<?php echo $row_PrpSummary['District']; ?><br>
<?php echo $row_PrpSummary['County']; ?> <?php echo
$row_PrpSummary['Country']; ?>
</td>
<td> <! Orig image.
<img src="<?php echo 'e:\\property\\data\\images\\' .
$row_PrpSummary['FileName'];?>">
</td>
<td> <! Try to call mkimg.php.
<img src="mkimg.php?ImageName=<?php echo 'e:\\property\\data\\images\\'
.. $row_PrpSummary['FileName'];?>" >
</td>
<td>
<?php echo 'e:\\property\\data\\images\\' .
$row_PrpSummary['FileName'];?> <! testing that data's ok.
</td>
</tr>
<?php } while ($row_PrpSummary = mysql_fetch_assoc($PrpSummary)); ?>
</table>
</body>
</html>
<?php
mysql_free_result($PrpSummary);
?>
And here is the script to make a smaller image. Again, this worked in it's
original form. I tested it with a single known image and it worked, but I
haven't tested it since messing around with it. I don't think that it's
actually being called, as it won't even die().
<?php
define(MAX_WIDTH, 150);
define(MAX_HEIGHT, 150);
die('here I am');
echo $image_path = 'e:\\property\\data\\images\\' . $_GET['ImageName'];
$img = null;
$ext = strtolower(end(explode('.', $image_path)));
if ($ext == 'jpg' || $ext == 'jpeg') {
$img = @imagecreatefromjpeg($image_path);
} else if ($ext == 'png') {
$img = @imagecreatefrompng($image_path);
# Only if your version of GD includes GIF support
} else if ($ext == 'gif') {
$img = @imagecreatefrompng($image_path);
}
# If an image was successfully loaded, test the image for size
if ($img) {
# Get image size and scale ratio
$width = imagesx($img);
$height = imagesy($img);
$scale = min(MAX_WIDTH/$width, MAX_HEIGHT/$height);
# If the image is larger than the max shrink it
if ($scale < 1) {
$new_width = floor($scale*$width);
$new_height = floor($scale*$height);
# Create a new temporary image
$tmp_img = imagecreatetruecolor($new_width, $new_height);
# Copy and resize old image into new image
imagecopyresized($tmp_img, $img, 0, 0, 0, 0,
$new_width, $new_height, $width, $height);
imagedestroy($img);
$img = $tmp_img;
}
}
# Create error image if necessary
if (!$img) {
$img = imagecreate(MAX_WIDTH, MAX_HEIGHT);
imagecolorallocate($img,0,0,0);
$c = imagecolorallocate($img,70,70,70);
imageline($img,0,0,MAX_WIDTH,MAX_HEIGHT,$c2);
imageline($img,MAX_WIDTH,0,0,MAX_HEIGHT,$c2);
}
header("Content-type: image/jpeg");
imagejpeg($img);
?>
Thanks,
Gregory.
<PenguinsAnonymous> wrote in message news:3f********@corp.newsgroups.com...
VVVVVVVVVVVVVVVVV
Key question has been asked several times WHAT VERSION of
php are you running? Your question is pivotal on 4.2!
-Walt
Gregory <php at neutrino-soft @@@ ware.co.uk> wrote: I don't think that the script is even being called.
I've tried
<td width="150"><img src="mkimg.php?ImageName=<?php echo
urlencode($FilNam); ?>" ></td>
and
<td width="150"><img src="c:\InetPub\wwwroot\property\test.php" ></td>
and put a die statement as the first command, but it lives. Perhaps my
set up is wrong.
Thanks,
Gregory
Which version of PHP are you running? If less than 4.2.x try using:
$HTTP_GET_VARS['ImageName'];
JOn
--
Reply to innkeepATcapitalDOTnet to email questions.
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
