Web programming Tutorial: php

Showing posts with label php. Show all posts

Get the client IP address using PHP

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; border: 0px; clear: both; color: #222222; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 19.5px; margin-bottom: 1em; padding: 0px;">
The simplest way to get the visitor’s/client’s <a href="http://en.wikipedia.org/wiki/IP_address" style="border: 0px; color: #0c65a5; cursor: pointer; margin: 0px; padding: 0px; text-decoration: none;">IP address</a> is using the <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">$_SERVER['REMOTE_ADDR']</code> or <code style="background-color: #eeeeee; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; margin: 0px; padding: 1px 5px; white-space: pre-wrap;">$_SERVER['REMOTE_HOST']</code> variables.</div>
<div style="background-color: white; border: 0px; clear: both; color: #222222; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 19.5px; margin-bottom: 1em; padding: 0px;">
However, sometimes this does not return the correct IP address of the visitor, so we can use some other server variables to get the IP address.</div>
<div style="background-color: white; border: 0px; clear: both; color: #222222; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 19.5px; margin-bottom: 1em; padding: 0px;">
The below both functions are equivalent with the difference only in how and from where the values are retrieved.</div>
<div style="background-color: white; border: 0px; clear: both; color: #222222; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 19.5px; margin-bottom: 1em; padding: 0px;">
getenv() is used to get the value of an environment variable in PHP.</div>
<pre class="lang-php prettyprint prettyprinted" style="background-color: #eeeeee; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; margin: 0px; padding: 0px; white-space: inherit;">// Function to get the client IP address
function get_client_ip() {
 $ipaddress = '';
 if (getenv('HTTP_CLIENT_IP'))
 $ipaddress = getenv('HTTP_CLIENT_IP');
 else if(getenv('HTTP_X_FORWARDED_FOR'))
 $ipaddress = getenv('HTTP_X_FORWARDED_FOR');
 else if(getenv('HTTP_X_FORWARDED'))
 $ipaddress = getenv('HTTP_X_FORWARDED');
 else if(getenv('HTTP_FORWARDED_FOR'))
 $ipaddress = getenv('HTTP_FORWARDED_FOR');
 else if(getenv('HTTP_FORWARDED'))
 $ipaddress = getenv('HTTP_FORWARDED');
 else if(getenv('REMOTE_ADDR'))
 $ipaddress = getenv('REMOTE_ADDR');
 else
 $ipaddress = 'UNKNOWN';
 return $ipaddress;
}</code></pre>
<div style="background-color: white; border: 0px; clear: both; color: #222222; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 19.5px; margin-bottom: 1em; padding: 0px;">
$_SERVER is an array that contains server variables created by the web server.</div>
<pre class="lang-php prettyprint prettyprinted" style="background-color: #eeeeee; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 13px; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; margin: 0px; padding: 0px; white-space: inherit;">// Function to get the client IP address
function get_client_ip() {
 $ipaddress = '';
 if ($_SERVER['HTTP_CLIENT_IP'])
 $ipaddress = $_SERVER['HTTP_CLIENT_IP'];
 else if($_SERVER['HTTP_X_FORWARDED_FOR'])
 $ipaddress = $_SERVER['HTTP_X_FORWARDED_FOR'];
 else if($_SERVER['HTTP_X_FORWARDED'])
 $ipaddress = $_SERVER['HTTP_X_FORWARDED'];
 else if($_SERVER['HTTP_FORWARDED_FOR'])
 $ipaddress = $_SERVER['HTTP_FORWARDED_FOR'];
 else if($_SERVER['HTTP_FORWARDED'])
 $ipaddress = $_SERVER['HTTP_FORWARDED'];
 else if($_SERVER['REMOTE_ADDR'])
 $ipaddress = $_SERVER['REMOTE_ADDR'];
 else
 $ipaddress = 'UNKNOWN';
 return $ipaddress;
}</code></pre>
</div>

Get the client IP address using PHP

The simplest way to get the visitor’s/client’s IP address is using the $_SERVER['REMOTE_ADDR'] or $_SERVER['REMOTE_HOST...

7:23 AM

How to use PHP & Multiple Input Text Field/Textbox

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; color: #676767; font-family: Georgia, 'Lucida Grande'; font-size: 12px; padding: 5px 0px;">
Example 1</div>
<div style="background-color: white; color: #676767; font-family: Georgia, 'Lucida Grande'; font-size: 12px; padding: 5px 0px;">
php_multiple_textbox1.php</div>
<div style="background-color: white; padding: 5px 0px;">
<html></div>
<div style="background-color: white; padding: 5px 0px;">
<head></div>
<div style="background-color: white; padding: 5px 0px;">
<title>ShotDev.Com Tutorial</title></div>
<div style="background-color: white; padding: 5px 0px;">
</head></div>
<div style="background-color: white; padding: 5px 0px;">
<body></div>
<div style="background-color: white; padding: 5px 0px;">
<form action="php_multiple_textbox2.php" method="post" name="form1"></div>
<div style="background-color: white; padding: 5px 0px;">
<input type="text" name="txtSiteName[]"> </div>
<div style="background-color: white; padding: 5px 0px;">
<input type="text" name="txtSiteName[]"> </div>
<div style="background-color: white; padding: 5px 0px;">
<input type="text" name="txtSiteName[]"> </div>
<div style="background-color: white; padding: 5px 0px;">
<input name="btnSubmit" type="submit" value="Submit"></div>
<div style="background-color: white; padding: 5px 0px;">
</form></div>
<div style="background-color: white; padding: 5px 0px;">
</body></div>
<div style="background-color: white; padding: 5px 0px;">
</div>
<div style="background-color: white; padding: 5px 0px;">
</html></div>
<div style="background-color: white; padding: 5px 0px;">
php_multiple_textbox2.php</div>
<div style="background-color: white; padding: 5px 0px;">
<html></div>
<div style="background-color: white; padding: 5px 0px;">
<head></div>
<div style="background-color: white; padding: 5px 0px;">
<title>ShotDev.Com Tutorial</title></div>
<div style="background-color: white; padding: 5px 0px;">
</head></div>
<div style="background-color: white; padding: 5px 0px;">
<body></div>
<div style="background-color: white; padding: 5px 0px;">
<?</div>
<div style="background-color: white; padding: 5px 0px;">
for($i=0;$i<count($_POST["txtSiteName"]);$i++)</div>
<div style="background-color: white; padding: 5px 0px;">
{</div>
<div style="background-color: white; padding: 5px 0px;">
echo "txtSiteName $i = ".$_POST["txtSiteName"][$i]." ";</div>
<div style="background-color: white; padding: 5px 0px;">
}</div>
<div style="background-color: white; padding: 5px 0px;">
?></div>
<div style="background-color: white; padding: 5px 0px;">
</body></div>
<div style="background-color: white; padding: 5px 0px;">
</div>
<div style="background-color: white; padding: 5px 0px;">
</html></div>
<div>
<div style="background-color: white; color: #676767; font-family: Georgia, 'Lucida Grande'; font-size: 12px; padding: 5px 0px;">
Create a php file and save to path root-path/myphp/</div>
<div style="background-color: white; color: #676767; font-family: Georgia, 'Lucida Grande'; font-size: 12px; padding: 5px 0px;">
Run <a href="http://localhost/myphp/php_multiple_textbox1.php" style="color: #70a529; margin: 0px; padding: 0px; text-decoration: none;">http://localhost/myphp/php_multiple_textbox1.php</a></div>
<div style="background-color: white; color: #676767; font-family: Georgia, 'Lucida Grande'; font-size: 12px; padding: 5px 0px;">
Screenshot</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.shotdev.com/wp-content/uploads/2010/01/php-multiple-textbox1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="177" src="http://www.shotdev.com/wp-content/uploads/2010/01/php-multiple-textbox1.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
 </div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.shotdev.com/wp-content/uploads/2010/01/php-multiple-textbox2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="165" src="http://www.shotdev.com/wp-content/uploads/2010/01/php-multiple-textbox2.jpg" width="320" /></a></div>
<div style="font-weight: normal; padding: 5px 0px;">
Example 2 (Create Element)</div>
 
<div style="background-color: white; color: #676767; font-family: Georgia, 'Lucida Grande'; font-size: 12px; padding: 5px 0px;">
php_multiple_textbox3.php</div>
<div style="background-color: white; padding: 5px 0px;">
<html></div>
<div style="background-color: white; padding: 5px 0px;">
<head></div>
<div style="background-color: white; padding: 5px 0px;">
<title>ShotDev.Com Tutorial</title></div>
<div style="background-color: white; padding: 5px 0px;">
<script language="javascript"></div>
<div style="background-color: white; padding: 5px 0px;">
function fncCreateElement(){</div>
<div style="background-color: white; padding: 5px 0px;">
 </div>
<div style="background-color: white; padding: 5px 0px;">
var mySpan = document.getElementById('mySpan');</div>
<div style="background-color: white; padding: 5px 0px;">
 </div>
<div style="background-color: white; padding: 5px 0px;">
var myElement1 = document.createElement('input');</div>
<div style="background-color: white; padding: 5px 0px;">
myElement1.setAttribute('type',"text");</div>
<div style="background-color: white; padding: 5px 0px;">
myElement1.setAttribute('name',"txtSiteName[]");</div>
<div style="background-color: white; padding: 5px 0px;">
mySpan.appendChild(myElement1);</div>
<div style="background-color: white; padding: 5px 0px;">
 </div>
<div style="background-color: white; padding: 5px 0px;">
var myElement2 = document.createElement(' ');</div>
<div style="background-color: white; padding: 5px 0px;">
mySpan.appendChild(myElement2);</div>
<div style="background-color: white; padding: 5px 0px;">
}</div>
<div style="background-color: white; padding: 5px 0px;">
</script></div>
<div style="background-color: white; padding: 5px 0px;">
</head></div>
<div style="background-color: white; padding: 5px 0px;">
<body></div>
<div style="background-color: white; padding: 5px 0px;">
<form action="php_multiple_textbox4.php" method="post" name="form1"></div>
<div style="background-color: white; padding: 5px 0px;">
<input type="text" name="txtSiteName[]"></div>
<div style="background-color: white; padding: 5px 0px;">
<input name="btnButton" type="button" value="+" onClick="JavaScript:fncCreateElement();"> </div>
<div style="background-color: white; padding: 5px 0px;">
</div>
<div style="background-color: white; padding: 5px 0px;">
<input name="btnSubmit" type="submit" value="Submit"></div>
<div style="background-color: white; padding: 5px 0px;">
</form></div>
<div style="background-color: white; padding: 5px 0px;">
</body></div>
<div style="background-color: white; padding: 5px 0px;">
</div>
<div style="background-color: white; padding: 5px 0px;">
</html></div>
<div>
 </div>
<div>
<div style="background-color: white; color: #676767; font-family: Georgia, 'Lucida Grande'; font-size: 12px; padding: 5px 0px;">
php_multiple_textbox4.php</div>
<div style="background-color: white; color: #676767; font-family: Georgia, 'Lucida Grande'; font-size: 12px; padding: 5px 0px;">
 </div>
<div style="background-color: white; padding: 5px 0px;">
<html></div>
<div style="background-color: white; padding: 5px 0px;">
<head></div>
<div style="background-color: white; padding: 5px 0px;">
<title>ShotDev.Com Tutorial</title></div>
<div style="background-color: white; padding: 5px 0px;">
</head></div>
<div style="background-color: white; padding: 5px 0px;">
<body></div>
<div style="background-color: white; padding: 5px 0px;">
<?</div>
<div style="background-color: white; padding: 5px 0px;">
for($i=0;$i<count($_POST["txtSiteName"]);$i++)</div>
<div style="background-color: white; padding: 5px 0px;">
{</div>
<div style="background-color: white; padding: 5px 0px;">
echo "txtSiteName $i = ".$_POST["txtSiteName"][$i]." ";</div>
<div style="background-color: white; padding: 5px 0px;">
}</div>
<div style="background-color: white; padding: 5px 0px;">
?></div>
<div style="background-color: white; padding: 5px 0px;">
</body></div>
<div style="background-color: white; padding: 5px 0px;">
</div>
<div style="background-color: white; padding: 5px 0px;">
</html></div>
</div>
</div>
<div>
<div style="background-color: white; color: #676767; font-family: Georgia, 'Lucida Grande'; font-size: 12px; padding: 5px 0px;">
Create a php file and save to path root-path/myphp/</div>
<div style="background-color: white; color: #676767; font-family: Georgia, 'Lucida Grande'; font-size: 12px; padding: 5px 0px;">
Run <a href="http://localhost/myphp/php_multiple_textbox4.php" style="color: #70a529; margin: 0px; padding: 0px; text-decoration: none;">http://localhost/myphp/php_multiple_textbox4.php</a></div>
<div style="background-color: white; color: #676767; font-family: Georgia, 'Lucida Grande'; font-size: 12px; padding: 5px 0px;">
Screenshot</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.shotdev.com/wp-content/uploads/2010/01/php-multiple-textbox3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="252" src="http://www.shotdev.com/wp-content/uploads/2010/01/php-multiple-textbox3.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.shotdev.com/wp-content/uploads/2010/01/php-multiple-textbox4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="181" src="http://www.shotdev.com/wp-content/uploads/2010/01/php-multiple-textbox4.jpg" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
 </div>
<div class="separator" style="clear: both; text-align: center;">
 </div>
<div class="separator" style="clear: both; text-align: center;">
 </div>
<div style="background-color: white; color: #676767; font-family: Georgia, 'Lucida Grande'; font-size: 12px; padding: 5px 0px;">
 </div>
</div>
</div>

How to use PHP & Multiple Input Text Field/Textbox

Example 1 php_multiple_textbox1.php <html> <head> <title>ShotDev.Com Tutorial</title> </head> ...

6:14 AM

string to url slug convert in php

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigsutiedcvL5Ve8jDelSLTF6dGFV2HFF4rATBpMEXb14CD4FpIa4FVkQAkd7gOHb6LzYzXBQ67iAureuFHpF0kzdHUFYmYgleSZqt5zn87Jku4CDA04rA7kVE0DESM44qC8auOAepOyMJb/s1600/Simple-php-function-to-create-SEO-friendly-URL-slugs-from-String-574x250.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="139" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigsutiedcvL5Ve8jDelSLTF6dGFV2HFF4rATBpMEXb14CD4FpIa4FVkQAkd7gOHb6LzYzXBQ67iAureuFHpF0kzdHUFYmYgleSZqt5zn87Jku4CDA04rA7kVE0DESM44qC8auOAepOyMJb/s320/Simple-php-function-to-create-SEO-friendly-URL-slugs-from-String-574x250.jpg" width="320" /></a></div>
 
Function: 
<?php 
 
function create_slug($string, $ext='.html'){ 
    $replace = '-';   
    $string = strtolower($string); 
 
    //remove query string 
    if(preg_match("#^http(s)?://[a-z0-9-_.]+\.[a-z]{2,4}#i",$string)){ 
        $parsed_url = parse_url($string); 
        $string = $parsed_url['host'].' '.$parsed_url['path']; 
 
        //if want to add scheme eg. http, https than uncomment next line 
        //$string = $parsed_url['scheme'].' '.$string; 
    } 
 
    //replace / and . with white space 
    $string = preg_replace("/[\/\.]/", " ", $string); 
 
    $string = preg_replace("/[^a-z0-9_\s-]/", "", $string); 
 
    //remove multiple dashes or whitespaces 
    $string = preg_replace("/[\s-]+/", " ", $string); 
 
    //convert whitespaces and underscore to $replace 
    $string = preg_replace("/[\s_]/", $replace, $string); 
 
    //limit the slug size 
    $string = substr($string, 0, 100); 
 
    //slug is generated 
    return ($ext) ? $string : $string; 
}   
?> 
 
Use It: 
$string = "how to become a php expert?"; 
$slug = create_slug($string); 
 
//it will return 
//how-to-become-a-php-expert</div>

string to url slug convert in php

Function: <?php function create_slug($string, $ext='.html'){ $replace = '-'; $string = strtolower($str...

9:02 PM

php Pagination with mysql

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlodsowYjCViFNqzmSOXoGBwLBmIGBXh1ELpRAIQlAJJS6V-e-I0bTDYl1U78BneNeV0_kTsBN9PUxgD8wr9cU1LMfO8M-5zo9FDrpHNWbTTKi99P6vX12MZ2DvDXTLPj77Qh44k4GFqhT/s1600/pag.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="57" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlodsowYjCViFNqzmSOXoGBwLBmIGBXh1ELpRAIQlAJJS6V-e-I0bTDYl1U78BneNeV0_kTsBN9PUxgD8wr9cU1LMfO8M-5zo9FDrpHNWbTTKi99P6vX12MZ2DvDXTLPj77Qh44k4GFqhT/s320/pag.png" width="320" /></a></div>
To start with you’ll see that we have our database connection file which we’re including into the page. Next you’ll see we’re setting three variables. ‘$tableName’, this refers to the table in your database that you want to get the data from, in our case it’s ‘countries_list’, ‘$targetpage’ refers to whatever you’ve saved the file as, in the case of the demo we’re saving the file as ‘index.php’. ‘$limit’ is the number of rows per page that we want to display from the database in the case of the demo you’ll see that we’re displaying just 10 rows. 
 
<div style="background-color: white; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 23px; outline: 0px; padding: 10px 0px; vertical-align: baseline;">
Here are the main bullet points of what this file does in the simplest form.</div>
<ul style="background-color: white; border: 0px; list-style: none; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<li style="background-color: transparent; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 23px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Set the three variables at the top of the page declaring our database table, document filename, and number of results to display per page</li>
<li style="background-color: transparent; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 23px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Next we connect to the database and count the number of rows, so we know exactly how much data we’re dealing with</li>
<li style="background-color: transparent; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 23px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">As the current page number is passed as a GET variable we check to see if a page number has been passed if there isn’t one then we set it to the first page</li>
<li style="background-color: transparent; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 23px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Then we have the query for the page content</li>
<li style="background-color: transparent; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 23px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Now we work out the next and previous page number as well as the last page number</li>
<li style="background-color: transparent; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 23px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Now we have a set of if statements, to determine which page the user is currently on relative to the total pages, so we can work out whether we need to display the first two page numbers with dots etc</li>
<li style="background-color: transparent; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 23px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Finally we echo ‘$paginate’ which will display our page numbers</li>
<li style="background-color: transparent; border: 0px; color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 23px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Then we have our while loop which you can modify to suit your contents</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><?php</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    include('connect.php');</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    $tableName="countries_list";     </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    $targetpage = "index.php";   </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    $limit = 10;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">     </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    $query = "SELECT COUNT(*) as num FROM $tableName";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    $total_pages = mysql_fetch_array(mysql_query($query));</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    $total_pages = $total_pages[num];</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">     </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    $stages = 3;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    $page = mysql_escape_string($_GET['page']);</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    if($page){</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        $start = ($page - 1) * $limit;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    }else{</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        $start = 0;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        }  </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">     </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    // Get page data</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    $query1 = "SELECT * FROM $tableName LIMIT $start, $limit";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    $result = mysql_query($query1);</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">     </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    // Initial page num setup</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    if ($page == 0){$page = 1;}</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    $prev = $page - 1; </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    $next = $page + 1;                         </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    $lastpage = ceil($total_pages/$limit);     </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    $LastPagem1 = $lastpage - 1;                   </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">     </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">     </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    $paginate = '';</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    if($lastpage /> 1)</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    {  </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">     </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        $paginate .= "<div class='paginate'/>";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        // Previous</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        if ($page /> 1){</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            $paginate.= "<a href='$targetpage?page=$prev'/>previous</a/>";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        }else{</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            $paginate.= "previous"; }</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">             </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">         </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        // Pages   </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        if ($lastpage < 7 + ($stages * 2))   // Not enough pages to breaking it up</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        {  </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            for ($counter = 1; $counter <= $lastpage; $counter++)</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            {</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                if ($counter == $page){</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                    $paginate.= "$counter";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                }else{</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                    $paginate.= "<a href='$targetpage?page=$counter'/>$counter</a/>";}                 </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            }</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        }</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        elseif($lastpage /> 5 + ($stages * 2))    // Enough pages to hide a few?</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        {</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            // Beginning only hide later pages</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            if($page < 1 + ($stages * 2))       </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            {</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                {</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                    if ($counter == $page){</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                        $paginate.= "$counter";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                    }else{</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                        $paginate.= "<a href='$targetpage?page=$counter'/>$counter</a/>";}                 </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                }</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                $paginate.= "...";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                $paginate.= "<a href='$targetpage?page=$LastPagem1'/>$LastPagem1</a/>";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                $paginate.= "<a href='$targetpage?page=$lastpage'/>$lastpage</a/>";    </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            }</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            // Middle hide some front and some back</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            elseif($lastpage - ($stages * 2) /> $page /amp;/amp; $page /> ($stages * 2))</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            {</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                $paginate.= "<a href='$targetpage?page=1'/>1</a/>";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                $paginate.= "<a href='$targetpage?page=2'/>2</a/>";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                $paginate.= "...";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                {</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                    if ($counter == $page){</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                        $paginate.= "$counter";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                    }else{</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                        $paginate.= "<a href='$targetpage?page=$counter'/>$counter</a/>";}                 </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                }</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                $paginate.= "...";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                $paginate.= "<a href='$targetpage?page=$LastPagem1'/>$LastPagem1</a/>";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                $paginate.= "<a href='$targetpage?page=$lastpage'/>$lastpage</a/>";    </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            }</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            // End only hide early pages</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            else</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            {</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                $paginate.= "<a href='$targetpage?page=1'/>1</a/>";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                $paginate.= "<a href='$targetpage?page=2'/>2</a/>";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                $paginate.= "...";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                {</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                    if ($counter == $page){</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                        $paginate.= "$counter";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                    }else{</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                        $paginate.= "<a href='$targetpage?page=$counter'/>$counter</a/>";}                 </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                }</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            }</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        }</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                    </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                // Next</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        if ($page < $counter - 1){</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            $paginate.= "<a href='$targetpage?page=$next'/>next</a/>";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        }else{</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            $paginate.= "next";</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">            }</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                   $paginate.= "</div/>";      </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">         </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> echo $total_pages.' Results';</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> // pagination</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> echo $paginate;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">?/></li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><ul/></li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><?php</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">          while($row = mysql_fetch_array($result))</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        {</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">             echo '<li/>'.$row['country'].'</li/>';</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">                 }</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">     </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    ?></li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </li>
</ul>
<h2>
<ul style="background-color: white; border: 0px; list-style: none; margin: 0px; outline: 0px; padding: 0px; text-align: left; vertical-align: baseline;">
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Here’s the css to style you pagination</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.paginate {</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">font-family:Arial, Helvetica, sans-serif;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    padding: 3px;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    margin: 3px;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.paginate a {</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    padding:2px 5px 2px 5px;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    margin:2px;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    border:1px solid #999;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    text-decoration:none;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    color: #666;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.paginate a:hover, .paginate a:active {</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    border: 1px solid #999;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    color: #000;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">}</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">.paginate span.current {</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    margin: 2px;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    padding: 2px 5px 2px 5px;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        border: 1px solid #999;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">         </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        font-weight: bold;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        background-color: #999;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        color: #FFF;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    }</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    .paginate span.disabled {</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        padding:2px 5px 2px 5px;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        margin:2px;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        border:1px solid #eee;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        color:#DDD;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    }</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">     </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    li{</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        padding:4px;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        margin-bottom:3px;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        background-color:#FCC;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">        list-style:none;}</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">         </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    ul{margin:6px;</li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">    padding:0px;}  </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> </li>
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><a href="https://drive.google.com/file/d/0Bxz59-QG6FyEQ050NGQ1R2lMckk/edit?usp=sharing" target="_blank">Download Lonk</a></li>
<li style="font-size: 14px; line-height: 23px;"></li>
</ul>
</h2>
<ul style="background-color: white; border: 0px; list-style: none; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<li style="background-color: transparent; border: 0px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></li>
<li style="color: #666666; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 23px;"></li>
</ul>
</div>

php Pagination with mysql

To start with you’ll see that we have our database connection file which we’re including into the page. Next you’ll see we’re setting thr...

8:40 PM