Server IP : 162.214.80.37 / Your IP : 216.73.216.1 Web Server : Apache System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : imyrqtmy ( 2189) PHP Version : 8.2.18 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/imyrqtmy/public_html/skyispatudyog/sym/Users/0-imyrqtmy/shivam/Admin/Includes/ |
[ Home ] | [ C0mmand ] | [ Upload File ] |
---|
<?php // include("Includes/db.php"); date_default_timezone_set('Asia/Kolkata'); $cudate = date("Y-m-d") ; $count = 1; $sql = "select * from tbl_invoice where itype='Estimate' ORDER BY id DESC"; $sql_res = mysqli_query($con, $sql) or die(mysqli_error($con)); while ($sql_row = mysqli_fetch_assoc($sql_res)){ $add_date = $sql_row['add_date']; $inid = $sql_row['id'] ; if ($cudate > $add_date) { // echo 'paid by student'; // $SQL = "UPDATE tbl_invoice set status='1' where id='$inid'"; // $sql_res1 = mysqli_query($con, $SQL) or die(mysqli_error($con)); } else { // echo 0; } } ?>