Friday, December 9, 2011

How to check session setting

<?php
    error_reporting (E_ALL ^ E_NOTICE); // just an error finder.. no need to use it
    include("config.php");
    session_start();
    if (!isset($_SESSION['user']))
        {
            header("Location:index.php");
        }
?>

Basic Login Page

  <form name="form" method="post" action="" >
  <input type="text" name="username" />
  <input type="password" name="password" />
  <input type="submit" name="Submit" value="LOGIN" />
          <?php
                if($message !="")
               {   
                echo $message;
                }
            ?>
  </form>

<?php   
    include("config.php");
    session_start();
   
//     if(isset($_POST["username"])){
//         $username1 = $_POST["username"];
//         $_SESSION["username"] = $username1;


if ($_SERVER['REQUEST_METHOD'] == "POST") {
   
    $username = $_POST["username"];
    $password = $_POST["password"];
   
    $querySelect = "select * from login where name = '$username' and password = '$password' and status ='1'";
    $resultSelect = mysql_query($querySelect);
    //echo $querySelect;
    $count = mysql_num_rows($resultSelect);
    //echo $count;
    //IF COUNT >0 RETRIEVE DATA FROM QUERY .ELSE GO BACK TO LOGIN
   
    if($count>0){
        $row=mysql_fetch_row($resultSelect);
        $loginid = $row[0];
        $role = $row[3];
        $username = $row[1];
        $_SESSION['id'] = $loginid;
        $_SESSION['user'] = $username;
       
    header("Location:home.php");
    }
     else
   
    //echo("Please Enter Correct Username and Password ...");
    header("Location:index.php?flagReg=1");
       
    }
    $message = "";
    if(isset($_GET["flagReg"])){
        $flagReg = $_GET["flagReg"];
        if($flagReg == '1'){
            $message = "Please Enter Correct Username and Password";
       
        }
    }
   
?>

Delete a Field From DataBase

  <a href="delete.php?delid=<?php echo $id; ?>">delete</a>

<?php
         if($_GET["delid"]!="")
        {
            $delid=$_GET["delid"];
            $querySelect="delete from project where id=$delid";
            $resultSelect=mysql_query($querySelect);
            require  "projectlist.php";
   
        }
?>

view a value from DB

 <?php
                  $querySelect="select * from project ";
                $resultSelect=mysql_query($querySelect);
                $countSelect=mysql_num_rows($resultSelect);
                for($i=0;$i<$countSelect;$i++)
                {
                $row=mysql_fetch_row($resultSelect);
                $id=$row[0];
                $name=$row[1];
                $lname=$row[2];
                $image=$row[4];           



                echo $name;
                echo $lname;
                }
?>

Simple Database insertion

<form action="" method="post" enctype="multipart/form-data">
<input type="text" name="name" value="" />
<input type="text" name="lname" value="" />
<input type="file" name="imageupload" value="" />
 </form>

<?php
if($_SERVER['REQUEST_METHOD']=="POST")
        {
            $name=$_POST["name"];
            $name=$_POST["lname"];
            if($_FILES['imageupload']['name'])
                        {
                         $filename = $_FILES["imageupload"]["name"];
                         $fileType = $_FILES["imageupload"]["type"];
                         $fileSize = $_FILES["imageupload"]["size"];
                         $fileTemp = $_FILES["imageupload"]["tmp_name"];
                         $error = $_FILES["imageupload"]["error"];
                         $image = time().$filename;
                         }
              $queryInsert = "insert into  projects(id,name,lname,image)values('','$name','$lname','$image')";
                    $resultSelect = mysql_query($queryInsert);
                    if($_FILES['imageupload']['name'])
                        {
                            move_uploaded_file($fileTemp,'uploads/'.$image);
                            chmod('uploads/'.$image,0777);
                        }
               header("Location:view.php");
}

Config

$db_host="localhost";      //HOST
$db_name="arun";           // DB-NAME
$db_user="arun-user";     // USER-NAME
$db_password="pass";   // PASSWORD

$link=mysql_connect($db_host,$db_user,$db_password) or die(mysql_error());
@mysql_select_db($db_name,$link);