PHP and iUI

jarv · July 24, 2010

hi,

I have recently got into iUI from watching the Joe Hewitt video here: http://uk.video.yahoo.com/watch/853528/3491272

so far, I have managed to, from a normal login page go to a list of pubs taken from my database.

My problem is when you touch/click on View More at the bottom of the list, this should show 20 more results, which it does but they are the same results, I need to build a query string of the next 20 results then the next 20 and so on...

here is my current code:

<?php
include_once("config.php");
include_once("functions.php");
// Check user logged in already:
checkLoggedIn("yes");
//doCSS(); ?>
<!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=iso-8859-1" />
<title>gopub</title>
<link rel="stylesheet" type="text/css" href="stylesheets/style1.css" title="default" />
<meta name="viewport" content="width=device-width; initial-scale=1.0; minimum-scale=1.0; maximum-scale=1.0; user-scalable=0;"/>
	<link rel="apple-touch-icon" href="../iui/iui/iui-logo-touch-icon.png" />
	<style type="text/css" media="screen">@import "../iui/iui/iui.css";</style>
		<script type="application/x-javascript" src="../iui/iui/iui.js"></script>
	<meta name="apple-touch-fullscreen" content="YES" />
<script type="text/javascript" src="js/jva.js"></script>
<style type="text/css">

body > ul > li {
    font-size: 14px;
}

body > ul > li > a {
    padding-left: 54px;
    padding-right: 40px;
    min-height: 34px;
}

li .digg-count {
    display: block;
    position: absolute;
    margin: 0;
    left: 6px;
    top: 7px;
    text-align: center;
    font-size: 110%;
    letter-spacing: -0.07em;
    color: #93883F;
    font-weight: bold;
    text-decoration: none;
    width: 36px;
    height: 30px;
    padding: 7px 0 0 0;
    background: url(shade-compact.gif) no-repeat;
}

h2 {
    margin: 10px;
    color: slateblue;
}

p {
    margin: 10px;
}
</style>
</head>

<body>

<?
// how many rows to show per page
$rowsPerPage = 20;

// by default we show first page
$pageNum = 1;

// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}

$offset = ($pageNum - 1) * $rowsPerPage;
$query  = "SELECT * FROM pubs LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die(mysql_error().'<br>SQL: ' . $query);  

//looping counties
$query1  = "SELECT rsCounty, COUNT(PubID) AS County_Count FROM pubs GROUP BY rsCounty";
$result1 = mysql_query($query1) or die(mysql_error().'<br>SQL: ' . $query1);  

$county_select_options = '<option value="">Search county</option>';
while ($row = mysql_fetch_assoc($result1))
{
    $counties[$row['rsCounty']] = $row['County_Count'];
    // $county_select_options .= '<option value="pubs.php?PubID='.$row['id'].'">'.$row['rsCounty'].' (x'.$row['County_Count'].')</option>'."\n";
}
        // make this arrays not strings:
    $values = array();
    $labels = array();
        // compute the sum:
        $total = array_sum($counties);
    foreach($counties as $rsCounty=>$count){
                // compute percent and add to values list:
        $values[] = ($count*100/$total);
        $labels[] = $rsCounty;
    }
        // convert array $values to a string comma separated
    $values = implode(',',$values);
        // same conversion for $labels but '|' separated
    $labels = implode('|', $labels);
    $url = 'http://chart.apis.google.com/chart?cht=p3&chd=t:'.$values.'&chs=480x200&chl='.$labels.'&chco=b0d584';
    
 ?>
 <div class="toolbar">
        <h1 id="pageTitle"></h1>
        <a id="backButton" class="button" href="#"></a>
        <a class="button" href="#searchForm">Search</a>
    </div>
 <ul title="pubs" selected="true">
 <?
// start main page
while($row = mysql_fetch_array($result)){
$PUBID = $row['PUBID'];
$RSPUBNAME = $row['RSPUBNAME'];
$RSADDRESS = $row['RSADDRESS']; 
$RSPOSTCODE = $row['RSPOSTCODE'];
$RSTEL = $row['RSTEL'];
$RSTOWN = $row['RSTOWN'];
$RSCOUNTY = $row['RSCOUNTY'];
// how many rows we have in database
// print the link to access each page
$self = $_SERVER['PHP_SELF'];
$next = "<li><a href=\"all.php\" target=\"_replace\">View More</a></li>";
//div container of header and information
echo <<<EOF
  <li><a href="#">$RSPUBNAME</a></li>
EOF;
if	($_SESSION["RSUSER"] == "admin") 
{
echo "<a href=\"edit.php?PUBID=$PUBID\" class=\"small\">edit this pub</a>";
}
}
echo $next;
echo "</ul>";
?>
</body>
</html>

Sign In

PHP and iUI

Recommended Posts

jarv

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information