Is there a way to hide the int in my echo

PHP
1

Is there a way to hide the int in my echo .
I only want to see the date of my from , to function.
But my function needs to use time in order to work properly.

Sample picture

1142×568 34.6 KB

Please help.
Thank you guys.

This is my code

<head>
<script>
  $(function() {
    $( "#tabs" ).tabs();
  $('a[rel*=facebox]').facebox();
  $( ".datepicker" ).datepicker();
  });
  
  $(document).ready(function(){
  // Write on keyup event of keyword input element
  $("#searchme").keyup(function(){
    // When value of the input is not blank
    if( $(this).val() != "")
    {
      // Show only matching TR, hide rest of them
      $("#searchTbl tbody>tr").hide();
      $("#searchTbl td:contains-ci('" + $(this).val() + "')").parent("tr").show();
    }
    else
    {
      // When there is no input or clean again, show everything back
      $("#searchTbl tbody>tr").show();
    }
  });
});
// jQuery expression for case-insensitive filter
$.extend($.expr[":"], 
{
    "contains-ci": function(elem, i, match, array) 
  {
    return (elem.textContent || elem.innerText || $(elem).text() || "").toLowerCase().indexOf((match[3] || "").toLowerCase()) >= 0;
  }
});
</script>
<script>
function goBack() {
    window.history.back();
}
</script>


<?php include('session.php'); ?>
<?php include('header.php'); ?>
<?php include('navbar.php'); ?>
<style>
.footer1 {
    position: absolute;
    right: 45%;
    font-family: ""Lucida Console", Monaco, monospace";
    top: 0%;
    width: 80%;
    background-color:#F8F8FF;
    color: black;
    text-align: left;
}

h3{
  font-size:20px;
    font-family: "Arial";

}

table {
    width:60%;
}
table, th, td {
    border: 1px solid black;
    border-collapse: collapse;
}
th, td {
    padding: 5px;
    text-align: center;
}
@media print {
  @page { margin: 0; }
  body { margin: 1cm; }

  #printPageButton {
    display: none;
  }
  #e{
    display:none;
  }
  .footer {
    position: fixed;
    left: 0;
    font-family: ""Lucida Console", Monaco, monospace";
    bottom: 0;
    width: 100%;
    background-color:#F8F8FF;
    color: black;
    text-align: center;
}
}
</style>


<div style="height:30px;"></div>
<div id="page-wrapper">

  <div class="row">
        <div class="col-lg-0">


<br><img src="../upload/logo.jpg"  align="center" class="footer1" style="height:50px; width:50px;"><br>

<br>



<?php
if(isset($_POST['salesbtn'])) {
$from = date('Y-m-d', strtotime($_POST['dayfrom']))." 00:00:01";
$to = date('Y-m-d', strtotime($_POST['dayto']))." 23:59:59";
?>
<center><h1> Product Sales Report </h1><h3>From (<?php echo $from; ?>) To (<?php echo $to; ?>)</h3>

  <button id="printPageButton"  onClick="window.print();" class="btn btn-primary" button type="submit">Print</button>

<button id="e" class="btn btn-primary" onclick="goBack()">Back</button> 
<br><br>
<table width="100%" cellspacing="0" cellpadding="0" style="font-family:Arial Narrow, Arial,sans-serif; font-size:15px;" border="1">
      <tr>
	  	<td width="30%"><div align="center"><strong>Purchase Date</strong></div></td>
        <td width="30%"><div align="center"><strong>Customer</strong></div></td>
		<td width="40%"><div align="center"><strong> Purchase Name</strong></div></td>
        <td width="40%"><div align="center"><strong>Quantity</strong></div></td>
        <td width="40%"><div align="center"><strong>Sales Total</strong></div></td>
      </tr>
	 <?php

	
try {
require ("conn.php");


$stmt1 = $conn->prepare("select * from sales_detail left join product on product.productid=sales_detail.productid left join sales on sales.salesid=sales_detail.salesid left join customer on sales.userid=customer.userid where product.supplierid='".$_SESSION['id'] ."' AND sales_date BETWEEN '$from' AND '$to' order by sales.sales_date desc");
$stmt1->execute();

while($row=$stmt1->fetch(PDO::FETCH_ASSOC)) {
$sales_date = $row['sales_date'];
$customer_name = $row['customer_name'];
$product_name = $row['product_name'];
$sales_qty = $row['sales_qty'];
$sales_total=$row['sales_total'];
?>



<tr align="center">
	<td><?php echo $sales_date; ?></td>
		<td><?php echo $customer_name; ?></td>
	<td><?php echo $product_name; ?></td>
 <td><?php echo $sales_qty; ?></td>
   <td><?php echo $sales_total; ?></td>
</tr>



</center>
<?php
}
}
catch(PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
}
}

?> 
<tr>
<td></td>
<td></td>
<td></td>
<td></td> 
<td style="color:red;" align="center"> Total:<?php 
try {
require ("conn.php");
$stmt = $conn->prepare("SELECT SUM(sales_total) as 'test' FROM sales WHERE sales_date BETWEEN '$from' AND '$to'");
$stmt->execute();
$row=$stmt->fetch(PDO::FETCH_ASSOC);
echo $row['test'];
}
catch(PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
}
?> </td>
</tr>
	 </table> </br> </br>
	 

	  

</div>  
</div>
</div>
<?php include('script.php'); ?>
<?php include('modal.php'); ?>
<?php include('add_modal.php'); ?>
<script src="custom.js"></script>
2

Well this is a PHP question, not a Javascript one. If you dont want the ints… why are you appending them to your date?
$from = date(‘Y-m-d’, strtotime($_POST[‘dayfrom’]))." 00:00:01";

Leave the ." 00:00:01" off, and it wont appear.

3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.