|
Server IP : 103.53.40.154 / Your IP : 3.140.196.5 Web Server : Apache System : Linux md-in-35.webhostbox.net 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : ppcad7no ( 715) PHP Version : 8.2.25 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/ppcad7no/indiatourbus.com/../theservicemen.co.in/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'config.php';
if(isset($_POST['date_submit'])){
$from_date=$_POST['from_date'];
$to_date=$_POST['to_date'];
$sql="SELECT datetime FROM tb7_user_issue where id=12";
$result=mysqli_query($db,$sql) or die("query failed");
if(mysqli_num_rows($result)>0){
while($row=mysqli_fetch_assoc($result)){
$date_explode=reset(explode(" ",$row['datetime']));
//$time_explode=end(explode(" ",$row['datetime']));
echo $date_explode;
}
}
}
// $post_at = "";
// $post_at_to_date = "";
// $queryCondition = "";
// if(!empty($_POST["search"]["post_at"])) {
// $post_at = $_POST["search"]["post_at"];
// list($fid,$fim,$fiy) = explode("-",$post_at);
// $post_at_todate = date('Y-m-d');
// if(!empty($_POST["search"]["post_at_to_date"])) {
// $post_at_to_date = $_POST["search"]["post_at_to_date"];
// list($tid,$tim,$tiy) = explode("-",$_POST["search"]["post_at_to_date"]);
// $post_at_todate = "$tiy-$tim-$tid";
// }
// $queryCondition .= "WHERE post_at BETWEEN '$fiy-$fim-$fid' AND '" . $post_at_todate . "'";
// }
// $sql = "SELECT * from tb9_contact_qeury " . $queryCondition . " ORDER BY post_at desc";
// $result = mysqli_query($conn,$sql);
?>