searchbox

<form action="searched.php" method="post">

<input type="search" name="search">

<input type="submit" name="submit" value="search">

</form>



<?php
$con=mysqli_connect("localhost","root","","oops");
//$id=$_GET['id'];
$search=$_POST['search'];
$query="select * from oop where lname='$search'";
$sql=mysqli_query($con,$query);
while ($row = mysqli_fetch_assoc($sql)) {
        echo $row['fname'];
        echo $row['lname'];
        echo $row['salary'];
    }
//header("Location: view.php");
?>

DB Creation using PHP mysqli

<?php
$con=mysqli_connect("localhost","root","");
if(!$con){
    die("connection failed".mysqli_connect_error());
   
}
$sql="create database lidiya";
if(mysqli_query($con,$sql)){
    echo "db created";
    }
   
    else{
       
        echo"db not created";
    }

mysqli_close($con);
?>

 // Creating table using php mysqli:

<?php
$con=mysqli_connect("localhost","root","","lidiya");
if(!$con){
    die("db connection failed".mysqli_connect_error());
    }
    $sql="CREATE TABLE MyGuests (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP
)";
    if(mysqli_query($con,$sql)){
        echo "table created";
    }
    else{
        echo "table not created";
    }
    mysqli_close($con);
?>

to clear : ( ! ) Notice: Trying to get property of non-object error

 Code:

 function getClientName($clientId){   
        $sql_client = sprintf("SELECT `clientname` FROM `client` WHERE `id`='%s'",$clientId);
        $res_client = mysql_query($sql_client)or die("Query failed ".mysql_error());       
 $clientName = mysql_fetch_object($res_client);
        return $clientName->clientname;
            }

 Error Code:
( ! ) Notice: Trying to get property of non-object in   return $clientName->clientname;

Solved Code :

function getClientName($clientId){  
        $sql_client = sprintf("SELECT `clientname` FROM `client` WHERE `id`='%s'",$clientId);
        $res_client = mysql_query($sql_client)or die("Query failed ".mysql_error());      
 $clientName = mysql_fetch_object($res_client);
             
  if($clientName){
            return $clientName->clientname;
                    }
                    else{
                        return null;
                    }
    }

mail function

<?php
if(isset($_POST['submit'])){
    $to = "web@companyname.com";
    $from = $_POST['email'];
    $name = $_POST['name'];
   
$address=$_POST['address'];
$city=$_POST['city'];
$country=$POST['country'];
$mobile=$_POST['mobile'];

$event=$_POST['event'];
$venu=$_POST['venu'];
$fromdate=$_POST['fromdate'];
$todate=$_POST['todate'];
$comment=$_POST['comment'];
   
   
   
   
    $subject = "Form submission";
    $subject2 = "Copy of your form submission";
    $message = $name ."  wrote the following:\n". "" . $address ."\n".$city."".$country. "\n" .$mobile. "\n" .$event. "\n" .$venu. "\n" .$fromdate. "\n".$todate. "\n" .$comment. "\n" . "\n\n" . $_POST['message'];
    $message2 = "Here is a copy of your message " . $name . "" . $_POST['message'];

    $headers = "From:" . $from;
    $headers2 = "From:" . $to;
    mail($to,$subject,$message,$headers);
    mail($from,$subject2,$message2,$headers2);
    echo "Mail Sent. Thank you " . $name . ", we will contact you shortly.";
   
    }
?>

 $sqlsel=sprintf("SELECT * FROM `clientreport` ");
          $sqlcount=sprintf("select count(*) as noofrecords FROM `clientreport` ");
          $sqlsel .= sprintf("where `createddate` BETWEEN  '%s' AND '%s'  ",$frmdate,$todate) ;
          $sqlcount .=sprintf("where `createddate` BETWEEN '%s' AND '%s' ",$frmdate,$todate) ;

    }
    else
    {
          $sqlsel=sprintf("SELECT * FROM `clientreport` ");
          $sqlcount=sprintf("select count(*) as noofrecords FROM `clientreport` ");
    }
  }
 if($_REQUEST['selData']!="Translation" || $_REQUEST['selData']!="allwork" || $_REQUEST['selData']!="POReport")
 {
  if(!empty($_REQUEST['FrmDate']) && !empty($_REQUEST['ToDate']))
  {
            $frmdt=explode("-",$_REQUEST['FrmDate']);
            $todt=explode("-",$_REQUEST['ToDate']);
            $frmdate=$frmdt[2]."-".$frmdt[1]."-".$frmdt[0];
            $todate=$todt[2]."-".$todt[1]."-".$todt[0];
            if(isset($_REQUEST['selUser'])!='' || isset($_REQUEST['selClient'])!='' || isset($_REQUEST['selCoordintaor'])!='' || isset($_REQUEST['selJobStatus'])!='')
            {
             $sqlsel .= sprintf("  AND `createddate` BETWEEN  '%s' AND '%s'  ",$frmdate,$todate) ;
             $sqlcount .=sprintf("  AND `createddate` BETWEEN '%s' AND '%s' ",$frmdate,$todate) ;
            }
            else
            {
              $sqlsel=sprintf("SELECT * FROM `clientreport` ");
              $sqlcount=sprintf("select count(*) as noofrecords FROM `clientreport` ");
              $sqlsel .= sprintf("where `createddate` BETWEEN  '%s' AND '%s'  ",$frmdate,$todate) ;
              $sqlcount .=sprintf("where `createddate` BETWEEN '%s' AND '%s' ",$frmdate,$todate) ;
            }
  }
 }
  $sqlsel .= sprintf(" ORDER BY `clientreport`.`id` DESC " );
  $sqlcount .= sprintf(" ORDER BY `clientreport`.`id` DESC " );

inset query

<?php
$con=mysqli_connect("localhost","root","","ses");
if($_POST['submit']){
$user=mysqli_real_escape_string($_SESSION["valid_user"]);
$sno=mysqli_real_escape_string($_POST["sno"]);
$date=mysqli_escape_string($_POST["date"]);
$title=mysqli_escape_string($_POST["title"]);
$report=mysqli_escape_string($_POST["report"]);
$url=mysqli_escape_string($_POST["url"]);
$sql="insert into lidiya(date,title,report,url) VALUE('".$date."','".$title."','".$report."','".$url."')";
$result=mysqli_query($con,$sql);
if($result){
    echo"<script>alert('saved');
location.href='home.php'</script>";
}
else{
    echo"<script>
    alert('not saved');
    location.href='add.php'
    </script>";
}
}
?>