PHP - All Ipad (safari) Number Entries Faulty

Hello,

I have a real estate website, a rss feed and I use feedburner for email subscriptions etc.

Since last week, feedburner is not working anymore cause it says that my feed is larger than 512 KB.

Well, i would like to change the code of the feed in order to display only the last 200 items (now we have 300), but i tried many ways and didnt have any luck

Another solution would be setting a minimum date for publishing the items, for example to set the feed to publish items only if their publication date was after a particular month or day.

here is my code, can you help me to limit number of items, please?

Thanks in advance



<?php
defined('_JEXEC') or die( 'Restricted access' );

jimport( 'joomla.application.component.view');

class PropertiesViewProperties extends JView
{

function display($tpl = null)

{

global $mainframe;

$db

=& JFactory::getDBO();

$document

=& JFactory::getDocument();

$params =& $mainframe->getParams();

$document->link = JRoute::_('index.php?option=com_properties&view=properties');



$document->setMetaData('description',JURI::base());

// Get some data from the model

JRequest::setVar('limit', $mainframe->getCfg('feed_limit'));


$query = ' SELECT p.*,c.name as name_category,t.name as name_type,cy.name as name_country,s.name as name_state,l.name as name_locality,pf.name as name_profile,pf.logo_image as logo_image_profile, '
. ' CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as Pslug,'
. ' CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as Cslug,'
. ' CASE WHEN CHAR_LENGTH(cy.alias) THEN CONCAT_WS(":", cy.id, cy.alias) ELSE cy.id END as CYslug,'
. ' CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END as Sslug,'
. ' CASE WHEN CHAR_LENGTH(l.alias) THEN CONCAT_WS(":", l.id, l.alias) ELSE l.id END as Lslug, '
. ' CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(":", t.id, t.alias) ELSE t.id END as Tslug '
. ' FROM #__properties_products AS p '
. ' LEFT JOIN #__properties_country AS cy ON cy.id = p.cyid '
. ' LEFT JOIN #__properties_state AS s ON s.id = p.sid '
. ' LEFT JOIN #__properties_locality AS l ON l.id = p.lid '
. ' LEFT JOIN #__properties_profiles AS pf ON pf.mid = p.agent_id '
. ' LEFT JOIN #__properties_category AS c ON c.id = p.cid '
. ' LEFT JOIN #__properties_type AS t ON t.id = p.type '
. ' WHERE p.published = 1 '
.' ORDER BY p.id DESC'
;

$db->setQuery( $query );

$prod = $db->loadObjectList();

foreach ( $prod as $row )

{

// strip html from feed item title

$title = $this->escape( $row->name );

$title = html_entity_decode( $title );

// url link to article

$link = LinkHelper::getLink('properties','showproperty','',$row->CYslug,$row->Sslug,$row->Lslug,$row->Cslug,$row->Tslug,$row->Pslug);

// strip html from feed item description text

$image_name=$this->Images($row->id);

//print_r($image_name);

//require('a');

$image = '<img width="200" align="left" alt="'.$item->title.'" src="'.JURI::base().'images/properties/images/thumbs/'.$row->id.'/'.$image_name.'"/>';

$category = '&nbsp;'.JText::_('Category').': <b>'.$row->name_category.'. </b>';

$desc = '<br>'.'<br>'.'<div align="center" style="border: 1px solid red; margin: 10px; padding: 20px;">'.$row->text.'</div>';

$description = $image.$category.$type.$ref.$desc;

$description = $this->escape( $description );

$description = html_entity_decode( $description );

$listdate = $row->listdate;

// load individual item creator class

$item = new JFeedItem();

$item->title 

= $title;

$item->link 

= $link;

$item->description 

= $description;

$item->date

= $listdate;

$item->category   

= $row->name_category;

$item->type   

= $row->name_type;

// loads item info into rss array

$document->addItem( $item );

}

}

function Images($id)

{

$db 

=& JFactory::getDBO();

$query = ' SELECT i.name '

. ' FROM #__properties_images as i '

. ' WHERE i.published = 1 AND i.parent = '.$id

. ' order by i.ordering LIMIT 1';

        $db->setQuery($query);   

$Images = $db->loadResult();

return $Images;

}

}
?>

Hello,

I am using the following code to display images managed by a MySQL database.  Basically another program manages a bunch of images, but this script displays certain ones (ones with INCLUDE = 1 in the database) on my main page.  My question is, is there an easy way to limit the number of images it displays, say to 5?  I'm not too concerned which images actually display (ascending or descending)... or better yet, random!  Most importantly, I only want five to display.  Each image will be linked to the full page, which displays all the images.

Any ideas?

Thanks!


Code: [Select]
<?php
$username="XXXXXXX";
$password="XXXXXXX";
$database="XXXXXXX";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM ft_form_12 WHERE col_24='1'";
// $query="SELECT * FROM ft_form_12";
// SELECT * FROM ft_form_12 WHERE col_24='1'
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>

<?php
$i=0;
while ($i < $num) {

$f20=mysql_result($result,$i,"col_23"); //Photo file name
$f21=mysql_result($result,$i,"col_24"); //INCLUDE
?>

<a href="http://www.domain.com/display_whole_page.shtml"><img src="http://www.domain.com/the_file/pictures/<?php echo $f20; ?>" height="50" border="0"></a>&nbsp;&nbsp;&nbsp;
               
<?php
$i++;
}
?>

I'm getting the dreaded " Invalid parameter number: number of bound variables does not match number of tokens" error and I've looked at this for days.  Here is what my table looks like:

|  id          | int(4)       | NO   | PRI | NULL    | auto_increment |
| user_id     | int(4)       | NO   |     | NULL    |                |
| recipient   | varchar(30)  | NO   |     | NULL    |                |
| subject     | varchar(25)  | YES  |     | NULL    |                |
| cc_email    | varchar(30)  | YES  |     | NULL    |                |
| reply       | varchar(20)  | YES  |     | NULL    |                |
| location    | varchar(50)  | YES  |     | NULL    |                |
| stationery  | varchar(40)  | YES  |     | NULL    |                |
| ink_color   | varchar(12)  | YES  |     | NULL    |                |
| fontchosen  | varchar(30)  | YES  |     | NULL    |                |
| message     | varchar(500) | NO   |     | NULL    |                |
| attachment  | varchar(40)  | YES  |     | NULL    |                |
| messageDate | datetime     | YES  |     | NULL    |        

Here are my params:

            $params = array(                 
               ':user_id' => $userid,                 
               ':recipient' => $this->message_vars['recipient'],                 
               ':subject' => $this->message_vars['subject'],                 
               ':cc_email' => $this->message_vars['cc_email'],                 
               ':reply' => $this->message_vars['reply'],                 
               ':location' => $this->message_vars['location'],                 
               ':stationery' => $this->message_vars['stationery'],                 
               ':ink_color' => $this->message_vars['ink_color'],                 
               ':fontchosen' => $this->message_vars['fontchosen'],                 
               ':message' => $messageInput,                 
               ':attachment' => $this->message_vars['attachment'],                 
               ':messageDate' => $date             );

Here is my sql:

$sql = "INSERT INTO messages (user_id,recipient, subject, cc_email, reply, location,stationery, ink_color, fontchosen, message,attachment) VALUES( $userid, :recipient, :subject, :cc_email, :reply, :location, :stationery, :ink_color, :fontchosen, $messageInput, :attachment, $date);";

And lastly, here is how I am calling it:
            $dbh = parent::$dbh;             
           $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);              
           if (empty($dbh))    return false;             
                  $stmt = $dbh->prepare($sql);             
                 $stmt->execute($params) or die(print_r($stmt->errorInfo(), true));              
           if (!$stmt) {    print_r($dbh->errorInfo());              }

I know my userid is valid and and the date is set above (I've echo'd these out to make sure).  Since the id is auto_increment, I do not put that in my sql (though I've tried that too), nor in my params (tried that too).  What am I missing?  I feel certain it is something small, but I have spent days checking commas, semi-colons and spelling.  Can anyone see what I'm doing wrong?

I have been using some CSS written by Matthew Taylor (www.http://matthewjamestaylor.com), for displaying my web page on iPad orsimilar device.  It works in most cases but for some reason it gives strange results when I try to output a table in the main screen area. It puts the title heading in the right place, but the table for some reason underneath the footer and the page menu disappears completely. It is usually caused by unclosed div tags, but I have checked them and they appear to be correct. There is a good explaination of how the CSS works on his web site. Here is the code for the PHP/HTML:

<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta name="generator" content="CoffeeCup HTML Editor (www.coffeecup.com)">
    <meta name="dcterms.created" content="Sat, 02 Mar 2013 20:21:23 GMT">
    <meta name="description" content="">
    <meta name="keywords" content="">
    <meta name="viewport" content="width=768px, minium-scale=1.0, maximum-scale=1.0" />
    <title></title>
    <link rel="stylesheet" href="stylesheets/ipad.css" />
    <!--[if IE]>
    <script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
    <![endif]-->
  </head>
  <body>
  <div id="fb-root"> 
<script>(function(d, s, id) {
  var js, fjs = d.getElementsByTagName(s)[0];
  if (d.getElementById(id)) return;
  js = d.createElement(s); js.id = id;
  js.src = "//connect.facebook.net/en_GB/all.js#xfbml=1";
  fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script></div><!--end fb-root-->
<div id="wrap"> <!--Start wrap-->
   <div id="header"> <!--Start header-->
   		
		<img src="images/Head!.png" width="100%" height="150px" alt="" title="" border="0" />
		<h1>1066 cards4U</h1>
   </div><!-- end header -->	
   <div id="content"> <!--Start content-->
      <div id="main"> <!--Start main-->
	  <h3>Statistics for <? echo $Country; ?> in 2014</h3>
<h4>If only the header is shown, there is no data for this country</h4>
<?php
include('connect_visits.php');
doDB7();
$limitStart = $_POST['QUARTER'] - 13;
$Visit_data="SELECT WeekNo.WNo, WeekNo.WCom, Countries.Country, ctryvisits.CVisits
        FROM ctryvisits 
        LEFT JOIN Countries
            ON ctryvisits.country = Countries.CID
        LEFT JOIN WeekNo
            ON ctryvisits.WNo=WeekNo.WNo
        WHERE Countries.CID = '{$_POST['country']}'
        ORDER BY ctryvisits.WNo
	 LIMIT {$limitStart}, 13";
$Visit_data_res = mysqli_query($mysqli, $Visit_data) or die(mysqli_error($mysqli));
$display_block = "
<table width=\"20%\" cellpadding=\"3\" cellspacing=\"1\" border=\"1\" BGCOLOR=\"white\" >
	<tr>
	<th>Week No</th>
	<th>Week Commencing</th>
	<th>Visits</th>
		</tr>";	
while ($C_info = mysqli_fetch_array($Visit_data_res)) {
		$Cid = $C_info['WNo'];
		$Visits = ($C_info['CVisits']);
		$WeekNo = ($C_info['WCom']);
//add to display
$display_block .= "
<tr>
<td width=\"1%\" valign=\"top\">".$Cid."<br/></td>
<td width=\"8%\" valign=\"top\">".$WeekNo."<br/></td>
<td width=\"5%\" valign=\"top\">".$Visits."<br/></td>
</td></tr>";
}
mysqli_free_result($Visit_data_res);

$CNo2Cty ="SELECT CID, Country FROM Countries WHERE CID='{$_POST['country']}'";
$CNo2Cty_res =mysqli_query($mysqli, $CNo2Cty) or die(mysqli_error($mysqli));
if (mysqli_num_rows($CNo2Cty_res)<1){
$display_block="<p><em>Invalid Country, Please try again</em></p>";
}
while ($C_name = mysqli_fetch_array($CNo2Cty_res)) {
}
mysqli_free_result($CNo2Cty_res);
//mysqli_close(mysqli);
?>
<?php echo $display_block; ?>

		<div class="fb-comments" data-href="http://www.1066cards4u.co.uk" data-width="470"></div><br />	
		<div class="fb-like" data-href="http://www.1066cards4u.co.uk" data-send="true" data-layout="box_count" data-width="300" data-show-faces="true" data-font="arial"></div> <!-- end fb-like -->
</div> <!--end main--> 		
<div id="side"> <!--Start side-->
<div id="sidea"> <!--Start sidea-->
		 <h3>Main Menu</h3>
         <p><ul>
         <li><a href="index1.html">Home</a></li>
         <li><a href="iLinks.html">Links</a></li>
         <li><a href="iTechniques.html">Techniques</a></li>
 	 <li><a href="iVerse_Menu.html">Verse's</a></li>
         <li><a href="icontact.html">Contact Us</a></li>
	 <li><a href="iblog.php">Blog</a></li>
	 <li><a href="iAboutUs.html">About Us</a></li>
	 <li><a href="iGallery.html">Gallery</a></li>
	 <li><a href="iStats_Menu.html">Stats</a></li>
	 <li><a href="iRelHol_Menu.html">Religious Holiday's</a></li>
	 <li><a href="iSub_form.html">Subscribe to Newsletter</a></li>
         </ul></p>
</br>
</div> <!--end sidea-->
<div id="sideb"> <!--Start sideb-->

</div> <!--end sideb-->
<div id="sidec"> <!--Start sidec-->
</div> <!--end sidec-->
</div> <!--end side-->
</div> <!--end content-->
<div id="footer"> <!--Start footer-->
    <p>&copy; 2012 Content:1066 Cards 4U. All rights reserved. &nbsp;&nbsp;<br />
	With thanks to Matt Taylor - matthewjamestaylor.com</p>
		
</div> <!--end footer-->
</div> <!--end wrap-->
</body>
</html>

Here is the CSS:

* {
	margin:0;
	padding:0;
}
h2 {
	padding:1em 0 0 0;
}
p {
	line-height:1.4em;
}
p + p {
	text-indent:2em;
}
body {
	font-size:100%;
	text-align:center;
	background:#ddd;
}
pre {
	display:block;
	margin:1em 0 0 0;
	width:488px;
}
pre code {
	background:#eee;
	display:block;
	padding:10px;
}
.r {
	float:right;
	padding:0 0 10px 20px;
}

/* Landscape mode (default) */
#wrap {
	margin:0 auto;
	width:1024px;
	position:relative;
	overflow:hidden;
	text-align:left;
	background:#fff;
}
#header {
	float:left;
	width:1024px;
	padding:10px 0 20px 0;
	background:#fff;
	border-bottom:1px solid #000;
}
#header h1 {
	padding:10px 30px 0 30px;
}
#header p {
	padding:0 30px;
	line-height:1.4em;
}
#content {
	float:left;
	width:1024px;
	background:#eee;
	position:relative;
	left:768px;
}
#main {
	float:left;
	width:708px;
	position:relative;
	right:738px;
	padding:20px 0;
}
#side {
	float:right;
	width:216px;
	position:relative;
	right:788px;
	padding-bottom:20px;
}
#sidea,
#sideb,
#sidec {
	clear:left;
	float:left;
	width:216px;
}
#footer {
	clear:both;
	float:left;
	width:1024px;
	border-top:1px solid #000;
	background:#ddd;
}
#footer p {
	padding:20px 30px;
}

@media only screen and (orientation:portrait){
	/* portrait mode */
	#header,
	#wrap,
	#footer {
		
	}
	#content {
		left:0;
		background:#fff;
	}
	#main {
		float:left;
		width:708px;
		position:relative;
		right:0;
		left:30px;
		padding:20px 0;
	}
	#side {
		clear:left;
		float:left;
		width:768px;
		right:0;
		padding-bottom:20px;
		background:#eee;
	}
	#sidea {
		clear:none;
		width:216px;
		float:left;
		position:relative;
		left:30px;
		padding-top:20px;
	}
	#sideb {
		clear:none;
		width:216px;
		float:left;
		position:relative;
		left:60px;
		padding-top:20px;
	}
	#sidec {
		clear:none;
		width:216px;
		float:right;
		position:relative;
		right:30px;
		padding-top:20px;
	}

#footer {
   position:absolute;
   bottom:0;
   width:100%;
   height:60px;   /* Height of the footer */
   background:#6cf;
   width:768px;
}
}

I have spent hours trying different things, but I can't find a solution. I believe its a CSS problem, but if you think it is HTML can the moderator move it? Your help would be appreciated.

http://buildmyweb.org/testing/starter/   at the link above, you can see a test-page.  the problem im having is that the content in the footer gets cutoff on the right side of the footer when viewed in an ipad.  id love to hear it if anyone can figure out why   here is the html:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
    <meta http-equiv="content-type" content="text/html; charset=utf-8" />
    <meta name="keywords" content = "Under Construction" />
    <meta name="description" content="is currently Under Construction." />
    <title>Under Construction</title>

<link rel="stylesheet" type="text/css" href="bmw_footer_abs.css" />
</head>

<body id="page_home">
<div id="wrapper">
    <div id="banner">
    </div> <!-- close banner -->

<div id="main">
<p>
Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
</p>

<p>
Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
</p>

</div> <!-- close main -->
</div> <!-- close wrapper -->

<div id="footer">
    <div id="footer_content">
Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
</div> <!-- close footer_content -->
</div> <!-- close footer -->

</body>
</html>

and the css:

html {

    position: relative;

    min-height: 100%;

}

body {

    margin: 0 0 100px; /* bottom = footer height */

}

#footer {

    position: absolute;

    left: 0;

    bottom: 0;

    height: 100px;

    width: 100%;

    min-width:1000px;

    background:gray;

}



#wrapper    { position:relative; top:0px; margin:0 auto; width:1000px; text-align:left; background:pink; padding:0px; }





/* **************** BANNER *************** */

#banner        { float:left; background:green; width:100%; height:10px; }





/* **************** MAIN *************** */

#main         { float:left; width:100%; background-color:#f0f3f8; }





/* **************** FOOTER *************** */

#footer             { font-size:85%; line-height:1.3; }

#footer_content        { width:1000px; margin:0px auto; background:orange; }