Monday, June 29, 2020

using Htaccess file URL remove links php

OLD :: page.php?page_id=taurus
NEW: page/taurus



RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^/?page/(.*?)/?$ /page.php?page_id=$1 [L]

RewriteCond %{THE_REQUEST} ^[A-Z]{3,9}\ /page\.php\?page_id=([^\&\ ]+)
RewriteRule ^/?page\.php$ /page/%1? [L,R=301]

Thursday, June 25, 2020

Time Difference script using PHP

<?php

$date1 = strtotime("2016-06-01 22:45:00"); 
$date2 = strtotime("2018-09-21 10:44:01"); 
  
$diff = abs($date2 - $date1); 

$years = floor($diff / (365*60*60*24)); 

$months = floor(($diff - $years * 365*60*60*24)
                               / (30*60*60*24)); 

$days = floor(($diff - $years * 365*60*60*24 - 
             $months*30*60*60*24)/ (60*60*24));
  

$hours = floor(($diff - $years * 365*60*60*24 
       - $months*30*60*60*24 - $days*60*60*24)
                                   / (60*60)); 
$minutes = floor(($diff - $years * 365*60*60*24 
         - $months*30*60*60*24 - $days*60*60*24 
                          - $hours*60*60)/ 60); 
  

$seconds = floor(($diff - $years * 365*60*60*24 
         - $months*30*60*60*24 - $days*60*60*24
                - $hours*60*60 - $minutes*60)); 
  
// Print the result
printf("%d years, %d months, %d days, %d hours, "
     . "%d minutes, %d seconds", $years, $months,
             $days, $hours, $minutes, $seconds); 
?>

Thursday, June 18, 2020

Phone Number type only NUmber

<input type="text" name="phone" value="<?php echo $phone; ?>"  class="form-control us_phone" id="exampleInputEmail1" placeholder="Driver Phone"onkeypress="return event.charCode >= 48 &amp;&amp; event.charCode <= 57" maxlength="10" required>

Update Images and content uysimh PHP mysqli

<?php
    include ('config.php');
$categoryid = $_REQUEST['Id'];
if(isset($_POST["user_submit"]))
{
    $name = $_REQUEST['name'];
   $email = $_REQUEST['email'];
   $phone = $_REQUEST['phone'];
   $visa_upload = $_REQUEST['visa_upload'];
   $visa_expiry = $_REQUEST['visa_expiry'];
   $license_upload = $_REQUEST['license_upload'];
   $licence_expiry = $_REQUEST['licence_expiry'];
   $passport_upload = $_REQUEST['passport_upload'];
   $passwport_expiry = $_REQUEST['passwport_expiry'];
 
    $rand = rand(0000,9999);
$filename = $_FILES['visa_upload']['name'];
$filetmpname = $_FILES['visa_upload']['tmp_name'];
$folder ='imagesuploadedf/';
move_uploaded_file($filetmpname, $folder.$filename);
  $timestamp = date("Y-m-d");
 


$filename1 =$_FILES['license_upload']['name'];
$filetmpname = $_FILES['license_upload']['tmp_name'];
$folder ='imagesuploadedf/';
move_uploaded_file($filetmpname, $folder.$filename1);


$filename2 = $_FILES['passport_upload']['name'];
$filetmpname = $_FILES['passport_upload']['tmp_name'];
$folder ='imagesuploadedf/';
move_uploaded_file($filetmpname, $folder.$filename2);

 $sql = "UPDATE driver_register SET name='$name',email='$email',phone='$phone',visa_expiry='$visa_expiry',licence_expiry='$licence_expiry',passwport_expiry='$passwport_expiry' WHERE Id = $categoryid";

  if ($conn->query($sql) === TRUE) {
   

 
   if($filename!='')
   {
      move_uploaded_file($filetmpname, $folder.$filename);
            $ww1 = mysqli_query($conn,"update driver_register set visa_upload='$filename' where Id ='$categoryid'");
   }
      if($filename1!='')
   {
      move_uploaded_file($filetmpname, $folder.$filename1);
            $ww2 = mysqli_query($conn,"update driver_register set license_upload='$filename1' where Id ='$categoryid'");
   }
      if($filename2!='')
   {
     move_uploaded_file($filetmpname, $folder.$filename2);
            $ww3 = mysqli_query($conn,"update driver_register set passport_upload='$filename2' where Id ='$categoryid'");
   }
   
   
    echo '<script>alert("Update Successfully.");window.location.assign("all_driver.php");</script>';
  }
  else{
      echo '<script>alert("please Update Again....");window.location.assign("all_driver.php?Id='.$categoryid.'");</script>';
  }
}


$query=mysqli_query($conn,"select * from driver_register where Id = '$categoryid' ") ;                   
  if(mysqli_num_rows($query)>0)
  {
   $res=mysqli_fetch_assoc($query);
   $name = $res['name'];
   $email = $res['email'];
   $phone = $res['phone'];
   $visa_upload = $res['visa_upload'];
   $visa_expiry = $res['visa_expiry'];
   $license_upload = $res['license_upload'];
   $licence_expiry = $res['licence_expiry'];
   $passport_upload = $res['passport_upload'];
   $passwport_expiry = $res['passwport_expiry'];
   
    $image= $res['image'];
  }
?>