I am having problems with getting my fopen to work in the following code. You will see the fopen statement. The idea is too try to pull an image from two locations...if the image is unavailable than display a default image. All I am getting is text output on the screen....meaning I actually see
if( = @fopen(http://www.xx.com/listing_img/ . 855891 . 1.jpg, r)) {
I cant see where I am going wrong....can you help?
<?php
session_start(data);
$this_document = $_SERVER['newcode.php'];
$db_addr = 'xxx'; // address of MySQL server.
$db_user = 'xxx'; // Username to access server.
$db_pass = 'xxx'; // Password access server.
$db_name = 'xxx'; // Name of database to connect to.
$connect = @mysql_connect("$db_addr", "$db_user", "$db_pass");
$page = $_GET['page'];
$limit = $_GET['limit'];
if (!($connect)) // If no connect, error and exit().
{
echo("<p>Unable to connect to the database server.</p>");
exit();
}
if (!(@mysql_select_db($db_name))) // If can't connect to database, error and exit().
{
echo("<p>Unable to locate the $db_name database.</p>");
exit();
}
if (!($limit)){
$limit = 10;} // Default results per-page.
if ( !$page or $page < 0 ) { $page = 0; } // Default page value.
var_dump($_SESSION);
$numresults = mysql_query("SELECT town, list_price, bedrooms, baths, rooms, Id ,IF (lister_office_name like 'xxx', 1, 0)
AS featured
FROM residential
WHERE town = '$selecttown'"); // the query.
$numrows = mysql_num_rows($numresults); // Number of rows returned from above query.
if ($numrows == 0){
echo("No results found matching your query"); // modify the "Not Found" error for your needs.
exit();}
$pages = intval($numrows/$limit); // Number of results pages.
// $pages now contains int of pages, unless there is a remainder from division.
if ($numrows % $limit) {
$pages++;} // has remainder so add one page
$current = intval($page/$limit) + 1; // Current page number.
if (($pages < 1)) {
$total = 1;} // If $pages is less than one, total pages is 1.
else {
$total = $pages;} // Else total pages is $pages value.
$first = $page + 1; // The first result.
if (!((($page + $limit) / $limit) >= $pages) && $pages != 1) {
$last = $page + $limit;} //If not last results page, last result equals $page plus $limit.
else{
$last = $numrows;} // If last results page, last result equals total number of results.
//escape from PHP mode.
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
include("head.html");
?>
Click here for another search
<table width="100%" border="0" cellpadding="2">
<!--DWLayoutTable-->
<tr>
<td width="323" align="left"><font size="1" face="Arial, Helvetica, sans-serif">Results
per-page: <a href="<?=$this_document?>?query=<?=$query?>&page=<?=$page?>&limit=5">5</a>
| <a href="<?=$this_document?>?query=<?=$query?>&page=<?=$page?>&limit=10">10</a>
| <a href="<?=$this_document?>?query=<?=$query?>&page=<?=$page?>&limit=20">20</a>
| <a href="<?=$this_document?>?query=<?=$query?>&page=<?=$page?>&limit=50">50</a></font><font face="Arial, Helvetica, sans-serif">
</font>
<br>
</td>
<td colspan="2" align="left"><font size="2" face="Arial, Helvetica, sans-serif"> </font></td>
</tr>
<tr>
<td align="left"><font size="2" face="Arial, Helvetica, sans-serif">Showing
listings <b>
<?=$first?>
</b> - <b>
<?=$last?>
</b> of <b>
<?=$numrows?>
</b></font><br>
You are currently viewing results for <?php print $selecttown?>
</td>
<td width="324" align="left"><font size="2" face="Arial, Helvetica, sans-serif">Page
<b>
<?=$current?>
</b> of <b>
<?=$total?>
</b></font></td>
<td width="324" align="left"><font size="2" face="Arial, Helvetica, sans-serif"> </font></td>
</tr>
<tr>
<td colspan="3" align="left" valign="top"><font size="2" face="Arial, Helvetica, sans-serif"> </font>
<div align="left"><font size="2" face="Arial, Helvetica, sans-serif"></font></div>
<font size="2" face="Arial, Helvetica, sans-serif">
<?
//$limitnum = 15;
if ($page != 0) { // Don't show back link if current page is first page.
$back_page = $page - $limit;
echo("<a href=\"$this_document?query=$query&page=$back_page&limit=$limit\">back</a>\n");}
for ($i=1; $i <= $pages; $i++) // loop through each page and give link to it.
{
$ppage = $limit*($i - 1);
if ($ppage == $page){
echo("<b>$i</b>\n");} // If current page don't give link, just text.
//elseif ($ppage < $page - $limitnum || $ppage > $page + $limitnum){}
else{
echo("<a href=\"$this_document?query=$query&page=$ppage&limit=$limit\">$i</a>\n");}
}
if (!((($page+$limit) / $limit) >= $pages) && $pages != 1) { // If last page don't give next link.
$next_page = $page + $limit;
echo(" <a href=\"$this_document?query=$query&page=$next_page&limit=$limit\">next</a>");}
?>
</font></td>
</tr>
<tr>
<td colspan="3" align="left"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td colspan="3" align="left">
<?
//Go back into PHP mode.
// Now we can display results
$results = mysql_query("SELECT * ,IF (lister_office_name like 'xxx', 1, 0)
AS featured
FROM residential
WHERE town = '$selecttown'
ORDER BY featured DESC, list_price DESC
LIMIT $page, $limit");
for($i = 0; $i < $limit; $i++){
for ($count = 1; $row = mysql_fetch_assoc ($results);++$count)
{
if ($count & 1) {
$color = "#FFFFFF";
$font = "white";
}
else {
$color = "#FFFFCC";
$font = "black";
}
$printthis = "
<table border=0 width=100% cellspacing=0 cellpadding=0>
<tr>
<td bgcolor=$color align=center>
<table border=0 cellspacing=0 cellpadding=0>
<tr>
<td>
<p align=center>
if($fp = @fopen([url]http://www.xxx.com/listing_img/[/url] . $row[Id] . 1.jpg, r))
{
<img border=0 src=http://www.xxx.com/listing_img/$row[Id]1.jpg width=100 height=65>
}
else if ($fp = @fopen([url]http://www.xxx.com/propImgs/[/url] . $row[Id] . 1.jpg, r))
{
<img border=0 src=http://www.xxx.com/propImgs/$row[Id]1.jpg width=100 height=65>
}
else
{
<img border=0 src=http://www.xxx.com/un-small.gif width=100 height=65>
}
</p>
</td>
</tr>
</table>
</td>
<td bgcolor=$color align=center>
<table border=0 cellspacing=0 cellpadding=0>
<tr>
<td width=100%><b>Bedrooms: </b>$row[bedrooms]</td>
</tr>
<tr>
<td width=100%><b>Bathrooms: </b>$row[baths]</td>
</tr>
</table>
</td>
<td bgcolor=$color>
<div align=center>
<center>
<table border=0 cellspacing=0 cellpadding=0>
<tr>
<td width=100%>$row[town]</td>
</tr>
<tr>
<td width=100%><b>MLS #</b>$row[Id]</td>
</tr>
</table>
</center>
</div>
</td>
<td bgcolor=$color>
<div align=center>
<center>
<table border=0 cellspacing=0 cellpadding=0>
<tr>
<td width=100%>Click Here for more info</td>
</tr>
<tr>
<td width=100%><b>$ $row[list_price].00</b></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
<hr color=#D7DC0C noshade>
";
print $printthis;
}
}
?>
</td>
</tr>
</table>
</body>
</html>
