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>";
}
}
?>

session creation

<?php
session_start();
$_SESSION["user"]=$ses;

?>

storing image in database

<form action="<?php htmlentities($_SERVER['PHP_SELF']);?>" method="post" enctype="multipart/form-data">
<input type="file" name="images">
<input type="submit" value="upload"name="upload">

</form>
<?php
$con=mysqli_connect("localhost","root","","sample");

if(isset($_POST['upload']) && $_FILES['images'])
{
$fileName = $_FILES['images']['name'];
$tmpName  = $_FILES['images']['tmp_name'];

//$fileSize = $_FILES['images']['size'];
//$fileType = $_FILES['images']['type'];
$save="images/".$fileName;
move_uploaded_file($tmpName,$save);
$query = "INSERT INTO img (img) VALUES ('$save')";
$result=mysqli_query($con,$query);
echo "<img src='$save'>";
}

?>

session destroy

<?php
    @session_start();
   
    unset($_SESSION['userid']);
   
    session_destroy();
    header( 'Location: ../index.php' ) ;
?>

Pagination Using PHP

<?php
$conn=mysqli_connect("localhost","root","","pipo");


$perpage = 5;

if(isset($_GET["page"])){
    $page = intval($_GET["page"]);
}
else {
$page = 1;
}
$calc = $perpage * $page;
$start = $calc - $perpage;
$result = mysqli_query($conn, "select * from dept where city='hosur' Limit $start, $perpage ");

//$rows = mysqli_num_rows($result);

//if($rows){
    //$i = 0;
    while($row = mysqli_fetch_assoc($result)) {
?>
<table style="border: 1px #000000 solid;" width="400" cellspacing="2" cellpadding="2" align="center">

<tbody>
<tr style="background-color: #cccccc;">

<td style="font-weight: bold;font-family: arial;"><?php echo $row["Name"]; ?></td>

</tr>

<tr>

<td style="font-family: arial;padding-left: 20px;"><?php echo $row["job"]; ?></td>

</tr>
<?php
}
//}
?>

</tbody>
</table>

<table width="400" cellspacing="2" cellpadding="2" align="center">
<tbody>
<tr>
<td align="center">

<?php

if(isset($page)){
$result = mysqli_query($conn,"select count(*) As Total from dept where city='hosur' ");
//$rows = mysqli_num_rows($result);
//if($rows){
$rs = mysqli_fetch_assoc($result);
$total = $rs["Total"];

//}
$totalPages = ceil($total / $perpage);
if($page <=1 ){
echo "<span id='page_links' style='font-weight: bold;'>Prev</span>";
}
else{
$j = $page - 1;
echo "<span><a id='page_a_link' href='pagination.php?page=$j'>< Prev</a></span>";
}
for($i=1; $i <= $totalPages; $i++){
if($i<>$page){
echo "<span><a id='page_a_link' href='pagination.php?page=$i'>$i</a></span>";
}
else{
echo "<span id='page_links' style='font-weight: bold;'>$i</span>";
}
}
if($page == $totalPages ){
echo "<span id='page_links' style='font-weight: bold;'>Next ></span>";
}
else{
$j = $page + 1;
echo "<span><a id='page_a_link' href='pagination.php?page=$j'>Next</a></span>";
}
}
?></td>
<td></td>
</tr>
</tbody>
</table>


</body>
</html>

number of word counting in textbox using php get method

<form action="<?php htmlentities($_SERVER['PHP_SELF']);?>" method="get">
<input type="text" name="word" placeholder="enter text here">
<input type="submit" value="submit" name="submit">
</form>

<?php
if(isset($_GET['submit'])){
    $word=$_GET['word'];
    $word1=explode(' ',$word);
    $result=array_combine($word1,array_fill(0,count($word1),0));
    foreach($word1 as $words){
        $result[$words]++;
    }
    foreach($result as $result1 => $count){
   
        //echo "count"."$result1 "." .$count.";
        echo"<table border='5px' width='10%'><tr><th>$result1</th><td>$count</td></tr>";
    }
}
?>