pastebin - Miscellany - post number 83833

Miscellany
Sunday, July 9th, 2006 at 9:47:25pm MDT

mysql_select_db("tdd1984") or die("Problem selecting database");
$type = mysql_real_escape_string ($_GET['type']);
//pagination strts
$limit = 25;
 
$sql = "SELECT itemId, userId, description, date, city, county, idNum, name, price, type COUNT FROM (items JOIN user ON items.userId=user.ID) LEFT JOIN images ON items.itemId=images.idNum";
if (isset($_GET['type'])) { $sql .= " WHERE type='". mysql_real_escape_string($_GET['type'])."'"; }
$sql .="GROUP BY itemId";
$result_count = mysql_query($sql) or die ("MySQL Error: ".mysql_error());
$numofrows = mysql_num_rows ($result_count);
 
//pagination total number of rows
if(empty($page)){    // Checks if the $page variable is empty (not set)
        $page = 1;      // If it is empty, we're on page 1
    }
 
     $limitvalue = $page * $limit - ($limit);
    // Ex: (2 * 25) - 25 = 25 <- data starts at 25
 
//pagination query2
$sql1 = "SELECT itemId, userId, description, date, city, county, idNum, name, price, type FROM (items JOIN user ON items.userId=user.ID) LEFT JOIN images ON items.itemId=images.idNum LIMIT $limitvalue, $limit";
if (isset($_GET['type'])) { $sql .= " WHERE type='". mysql_real_escape_string($_GET['type'])."'"; }
$sql .="GROUP BY itemId";
$result = mysql_query($sql1) or die("Error: " . mysql_error());
 
//pagination if statement if nothing is to be returned :)
if(mysql_num_rows($result) == 0){
        echo("Nothing to Display!");
    }
 
 
 
echo "<TABLE width=\"25px\">\n";
echo "<TR><TD colspan=\"2\"><img src=\"http://indianaclassifiedads.com/description.jpg\"></TD><TD><img src=\"http://indianaclassifiedads.com/price.jpg\"></TD><TD><img src=\"http://indianaclassifiedads.com/datesubmitted.jpg\"><td><img src=\"http://indianaclassifiedads.com/city.jpg\"></td><TD><img src=\"http://indianaclassifiedads.com/county.jpg\"></td></TD></TR>\n";
 
//pagination while loop
while($row = mysql_fetch_array($result)){
for($i = 0; $i < $numofrows; $i++) {
 //get a row from our result set
if($i % 2) { //this means if there is a remainder
echo "<TR bgcolor=\"#FFFFCC\">\n";
} else {
echo "<TR bgcolor=\"white\">\n";
}
 
 
 
 
 
 if($row['idNum'] == null)
{
echo "<td class=\"result-cell-border\">&nbsp</td>";
}
else
{
echo "<td><img src=\"http://indianaclassifiedads.com/pic.gif\"></td>";
}
echo "</td>";
echo "<td align=\"left\" class=\"result-cell-border\">
<span class=\"result-title\">
<a href=\"contact.php?type-id=".$row['itemId']."&userid=".$row['userId']."\ class=\"result-title\"\">".$row['name']."</a>
</span>
<br />".$row['description']."</a>
</td>
<td align=\"center\" class=\"result-cell-border\">$".$row['price']."</TD>
<TD align=\"center\" class=\"result-cell-border\">".$row['date']."</td>
<td align=\"center\" class=\"result-cell-border\">".$row['city']."</td>
<td align=\"center\" class=\"result-cell-border\">".$row['county']."</TD>\n";
echo "</TR>\n";
}
}
echo "</TABLE>\n";
 
 
//pagination next button
if($page != 1){
        $pageprev = $page--;
        // Fancy way of subtracting 1 from $page
 
        echo("<a href=\"$PHP_SELF&page=$pageprev\">PREV".$limit."</a> ");
        /* Tip: It is a good idea NOT to use $PHP_SELF in this link. It may work,
but to be 99.9% sure that it will, be sure to use the actual name of the file
this script will be running on. Also, the   adds a space to the end of
PREV, and gives some room between the numbers. */
    }else
        echo("PREV".$limit." ");
        // If we're on page 1, PREV is not a link
 
         $numofpages = $$numofrows / $limit;
    /* We divide our total amount of rows (for example 102) by the limit (25). This
 
will yield 4.08, which we can round down to 4. In the next few lines, we'll
create 4 pages, and then check to see if we have extra rows remaining for a 5th
page. */
 
    for($i = 1; $i <= $numofpages; $i++){
    /* This for loop will add 1 to $i at the end of each pass until $i is greater
than $numofpages (4.08). */
 
        if($i == $page){
            echo($i." ");
        }else{
            echo("<a href=\"$PHP_SELF&page=$i\">$i</a> ");
        }
 
        /* This if statement will not make the current page number available in
link form. It will, however, make all other pages available in link form. */
    }   // This ends the for loop
 
if(($numofrows % $limit) != 0){
    /* The above statement is the key to knowing if there are remainders, and it's
all because of the %. In PHP, C++, and other languages, the % is known as a
Modulus. It returns the remainder after dividing two numbers. If there is no
remainder, it returns zero. In our example, it will return 0.8 */
 
        if($i == $page){
            echo($i." ");
        }else{
            echo("<a href=\"$PHP_SELF&page=$i\">$i</a> ");
        }
        /* This is the exact statement that turns pages into link form that is used
 
above */
    }   // Ends the if statement
 
 
    if(($numofrows - ($limit * $page)) > 0){
    /* This statement checks to see if there are more rows remaining, meaning there
are pages in front of the current one. */
 
        $pagenext   = $page++;
        // Fancy way of adding 1 to page
 
        echo("<a href=\"$PHP_SELF?page=$pagenext\">NEXT".$limit."</a>");
        /* Since there are pages remaining, this outputs NEXT in link form. */
    }else{
        echo("NEXT".$limit);
        /* If we're on the last page possible, NEXT will NOT be displayed in link
form. */
    }
 
 
 
 
?>
 
</body>
</html>

advertising

Update the Post

Either update this post and resubmit it with changes, or make a new post.

You may also comment on this post.

update paste below

mysql_select_db("tdd1984") or die("Problem selecting database");
$type = mysql_real_escape_string ($_GET['type']);
//pagination strts
$limit = 25;

$sql = "SELECT itemId, userId, description, date, city, county, idNum, name, price, type COUNT FROM (items JOIN user ON items.userId=user.ID) LEFT JOIN images ON items.itemId=images.idNum";
if (isset($_GET['type'])) { $sql .= " WHERE type='". mysql_real_escape_string($_GET['type'])."'"; }
$sql .="GROUP BY itemId";
$result_count = mysql_query($sql) or die ("MySQL Error: ".mysql_error());
$numofrows = mysql_num_rows ($result_count);

//pagination total number of rows
if(empty($page)){    // Checks if the $page variable is empty (not set)
        $page = 1;      // If it is empty, we're on page 1
    }

$limitvalue = $page * $limit - ($limit);
    // Ex: (2 * 25) - 25 = 25 <- data starts at 25

//pagination query2
$sql1 = "SELECT itemId, userId, description, date, city, county, idNum, name, price, type FROM (items JOIN user ON items.userId=user.ID) LEFT JOIN images ON items.itemId=images.idNum LIMIT $limitvalue, $limit";
if (isset($_GET['type'])) { $sql .= " WHERE type='". mysql_real_escape_string($_GET['type'])."'"; }
$sql .="GROUP BY itemId";
$result = mysql_query($sql1) or die("Error: " . mysql_error());

//pagination if statement if nothing is to be returned :)
if(mysql_num_rows($result) == 0){
        echo("Nothing to Display!");
    }

echo "<TABLE width=\"25px\">\n";
echo "<TR><TD colspan=\"2\"><img src=\"http://indianaclassifiedads.com/description.jpg\"></TD><TD><img src=\"http://indianaclassifiedads.com/price.jpg\"></TD><TD><img src=\"http://indianaclassifiedads.com/datesubmitted.jpg\"><td><img src=\"http://indianaclassifiedads.com/city.jpg\"></td><TD><img src=\"http://indianaclassifiedads.com/county.jpg\"></td></TD></TR>\n";

//pagination while loop
while($row = mysql_fetch_array($result)){
for($i = 0; $i < $numofrows; $i++) {
 //get a row from our result set
if($i % 2) { //this means if there is a remainder
echo "<TR bgcolor=\"#FFFFCC\">\n";
} else {
echo "<TR bgcolor=\"white\">\n";
}

if($row['idNum'] == null)
{
echo "<td class=\"result-cell-border\">&nbsp</td>";
}
else
{
echo "<td><img src=\"http://indianaclassifiedads.com/pic.gif\"></td>";
}
echo "</td>";
echo "<td align=\"left\" class=\"result-cell-border\">
<span class=\"result-title\">
<a href=\"contact.php?type-id=".$row['itemId']."&userid=".$row['userId']."\ class=\"result-title\"\">".$row['name']."</a>
</span>
<br />".$row['description']."</a>
</td>
<td align=\"center\" class=\"result-cell-border\">$".$row['price']."</TD>
<TD align=\"center\" class=\"result-cell-border\">".$row['date']."</td>
<td align=\"center\" class=\"result-cell-border\">".$row['city']."</td>
<td align=\"center\" class=\"result-cell-border\">".$row['county']."</TD>\n";
echo "</TR>\n";
}
}
echo "</TABLE>\n";

//pagination next button
if($page != 1){
        $pageprev = $page--;
        // Fancy way of subtracting 1 from $page

echo("<a href=\"$PHP_SELF&page=$pageprev\">PREV".$limit."</a> ");
        /* Tip: It is a good idea NOT to use $PHP_SELF in this link. It may work,
but to be 99.9% sure that it will, be sure to use the actual name of the file
this script will be running on. Also, the   adds a space to the end of
PREV, and gives some room between the numbers. */
    }else
        echo("PREV".$limit." ");
        // If we're on page 1, PREV is not a link

$numofpages = $$numofrows / $limit;
    /* We divide our total amount of rows (for example 102) by the limit (25). This

will yield 4.08, which we can round down to 4. In the next few lines, we'll
create 4 pages, and then check to see if we have extra rows remaining for a 5th
page. */

for($i = 1; $i <= $numofpages; $i++){
    /* This for loop will add 1 to $i at the end of each pass until $i is greater
than $numofpages (4.08). */

if($i == $page){
            echo($i." ");
        }else{
            echo("<a href=\"$PHP_SELF&page=$i\">$i</a> ");
        }

/* This if statement will not make the current page number available in
link form. It will, however, make all other pages available in link form. */
    }   // This ends the for loop

if(($numofrows % $limit) != 0){
    /* The above statement is the key to knowing if there are remainders, and it's
all because of the %. In PHP, C++, and other languages, the % is known as a
Modulus. It returns the remainder after dividing two numbers. If there is no
remainder, it returns zero. In our example, it will return 0.8 */

if($i == $page){
            echo($i." ");
        }else{
            echo("<a href=\"$PHP_SELF&page=$i\">$i</a> ");
        }
        /* This is the exact statement that turns pages into link form that is used

above */
    }   // Ends the if statement

if(($numofrows - ($limit * $page)) > 0){
    /* This statement checks to see if there are more rows remaining, meaning there
are pages in front of the current one. */

$pagenext   = $page++;
        // Fancy way of adding 1 to page

echo("<a href=\"$PHP_SELF?page=$pagenext\">NEXT".$limit."</a>");
        /* Since there are pages remaining, this outputs NEXT in link form. */
    }else{
        echo("NEXT".$limit);
        /* If we're on the last page possible, NEXT will NOT be displayed in link
form. */
    }

</body>
</html>

details of the post (optional)

Note: Only the paste content is required, though the following information can be useful to others.

Name / Title: Save name / title?
Description / Question:
Tags: (space separated, optional)
Content Type:
Expire this post in:
Encrypt this paste. Password:

Please note that information posted here will expire by default in one month. If you do not want it to expire, please set the expiry time above. If it is set to expire, web search engines will not be allowed to index it prior to it expiring. Items that are not marked to expire will be indexable by search engines. Be careful with your passwords. All illegal activities will be reported and any information will be handed over to the authorities, so be good.

worth-right

fantasy-obligation

pastebin - Miscellany - post number 83833

Stuff to Do

Paste Actions

Information

Paste Details

Quick Search

Recent Posts

Miscellany
Sunday, July 9th, 2006 at 9:47:25pm MDT

advertising

Update the Post

pastebin - Miscellany - post number 83833

Stuff to Do

Paste Actions

Information

Paste Details

Quick Search

Recent Posts

MiscellanySunday, July 9th, 2006 at 9:47:25pm MDT

advertising

Update the Post

Miscellany
Sunday, July 9th, 2006 at 9:47:25pm MDT