Paging using PHP and MySQL

I have coded a class for paging, you may find it here.

### Code for Paging Starts ###
//index no of the page
$pageIndex = ((int)$_REQUEST['pageIndex'] == 0) ? 1 : (int)$_REQUEST['pageIndex'];
 
//number of rows
$rowPerPage = 10;
 
//counting total number of rows
$sql = 'SELECT COUNT(*)
        FROM {your_table_name}
        WHERE {IF ANY CONDITION}';
 
$query = mysql_query($sql, $link_identifier);
$row = mysql_fetch_row($query);
 
// total records
$totalRecords = $row[0];
 
// number of pages
$totalPages = ceil($totalRecords/$rowPerPage);
 
if($pageIndex > $totalPages)
{
    $pageIndex = $totalPages;
}
 
$startIndex = ($pageIndex - 1) * $rowPerPage;
 
if($totalRecords > $rowPerPage)
{
    $endIndex = $startIndex + $rowPerPage;
}
else
{
    $endIndex = $totalRecords;
}
 
if($pageIndex == $totalPages)
{
    if($totalRecords > $totalPages * $rowPerPage)
    {
        $endIndex = $totalRecords;
    }
}
 
if($totalRecords > 0)
{
    $rangeStart = $startIndex+1;
 
    if(($totalRecords > $rowPerPage) || ($pageIndex == $totalPages))
    {
        $rangeEnd = $totalRecords;
    }
    else
    {
        $rangeEnd = $endIndex;
    }
 
    $range = 'Showing '  . $rangeStart.' - '.$rangeEnd.' of '.$totalRecords;
}
 
// link for next page
$nextLink = 'page_name.php?pageIndex='.($pageIndex + 1);
 
// link for previous page
$previousLink = 'page_name.php?pageIndex='.($pageIndex - 1);
 
// fetching data using pagination
$sql = "SELECT *
            FROM {your_table_name}
            WHERE {IF ANY CONDITION}
            LIMIT $startIndex, $rowPerPage";
 
$query = mysql_query($sql, $link_identifier);
 
### Code for Paging Ends ###

Now use the resource ‘$query’ and do what you want to do.

Enabling cURL in XAMPP

By default cURL is disable in XAMPP installation. If you want to enable cURL of your XAMPP environment then uncomment the following line:

;extension=php_curl.dll

to

extension=php_curl.dll

in the C:\Program Files\xampp\apache\bin\php.ini file (assuming you have installed XAMPP in “C:\Program Files” folder).

If you plan to switch version of PHP in XAMPP you may made the change in following files (assuming you have installed XAMPP in “C:\Program Files” folder):

• C:\Program Files\xampp\php\php5.ini
• C:\Program Files\xampp\php\php.ini
• C:\Program Files\xampp\php\php4\php.ini
• C:\Program Files\xampp\php\php4\php4.ini

XAMPP – Sending test mails with MercuryMail

XAMPP comes with MercuryMail. To use it for sending test mails, you can do the followings:

1. Start Mercury Mail from XAMPP control panel.
2. Navigate to Mercury Mail folder in XAMPP installation (Most probably C:\Program Files\xampp\MercuryMail)
3. Double click on mercury.exe and Mercury window will be opened.
4. Go to Configuration -> Local Users
5. Add a user with password (Suppose sajjad)
6. Close this window.

That’s it.

Now you can send mail to sajjad@localhost or sajjad@localhost.com (Mecury Mail should be started).

To receive mail configure outlook express with localhost as pop3 and SMTP server.

Hope these information will be helpful.

XAMPP – My favorite PHP environment

When I started coding in PHP, the main hassle was preparing the development environment. Installing Apache, PHP, MySQL was not so easy. Then I came across PHPTried and after that WAMPP. But finally I got what I wanted – XAMPP. To me XAMPP is a total PHP development environment.

XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl. XAMPP is really very easy to install and to use – just download, extract and start.

To get a copy of XAMPP, visit http://www.apachefriends.org/.