Friday, January 22, 2010

How To Create A Pagination In PHP

Use Pagination to display results of your MySQL query over multiple pages in PHP.

Note : Remove "\" with a href tag

pagination.php

 ////// Connection with mysql Database////////

$connect = mysql_connect("yourhostname", "username", "password", "true") or die(mysql_error());
mysql_select_db("databaseName", $connect) or die(mysql_error());

////// pagination limit 10 records in a page //////

$limit =10;
if(!isset($_GET['page']))
{
     $page=1;
}
else
{
    $page=$_GET['page'];
}
$limitstart = ($page-1)*$limit;
$strgry = "select * from tableName";
$num =mysql_num_rows(mysql_query($strgry));
$pages = ceil($num/$limit);
$strgry = "select * from tableName Limit $limitstart, $limit";
$query = mysql_query($strgry) or die (mysql_error());
while($row=mysql_fetch_array($query))
{
    echo $row[0];
    echo $row[1];
    echo "\n";
}
if($page!=1)
{
    $pr=$page-1;
    echo "<\a href='pagination.php?page=$pr'>Prev<\/a>";
    echo " ";
}
for($i;$i<=$pages;$i++)
{
    if($i!=$page)
   {
        echo "<\a href='pagination.php?page=$i'>";
        echo $i;
        echo "<\/a>";
   }
   else
  {
        echo $i;
        echo " ";
   }
}
if($page!=$pages)
{
    $nxt=$page+1;
    echo "<\a href='pagination.php?page=$nxt'>Next<\/a>";
    echo " ";
}

Tuesday, January 19, 2010

How to store multiple values in a session variable with in a form submit in php

Note : Save this page session.php
Note : Remove "\" from all HTML tag and php start tag

<\?php
session_start();

$sessValue = "";
    if(isset($_REQUEST['submit']))
    {
        $sessValue = $_REQUEST['sessValue'];
        if(!isset($_SESSION['sessValue1']))
        {
            echo $_SESSION['sessValue1']=$sessValue;
        }
        else
        {
            echo $_SESSION['sessValue1']=$_SESSION['sessValue1'].$sessValue;
        }
    }
?>
<\html>
<\body>
<\form name="frm" action="session.php" method="post">
    <\input type="text" name="sessValue">
    <\input type="submit" name="submit" value="submit">
<\/form>
<\/body>
<\/html>

How to upload file in php

Step 1 - Save Bellow code name "upload.php"
Step 2 - Create a folder name upload for file upload
Note : Remove "\" from all HTML tag and php start tag

<\?php
        if(isset($_REQUEST['submit']))
        {
            $tmp_file = $_FILES['upload']['tmp_name'];
            $filename = $_FILES['upload']['name'];
           
            if(move_uploaded_file("$tmp_file", "upload/$filename"))
            {
                echo "File Success Fully Uploaded";
            }
            else
            {
                echo "File Upload Failed";
            }
        }
?>
<\html>
<\body>
<\form name="frm" method="post" action="upload.php" enctype="multipart/form-data">
    <\input type="file" name="upload">
    <\input type="submit" name="submit" value="Upload">
<\/form>
<\/body>
<\/html>