| Server IP : 51.89.169.208 / Your IP : 3.148.107.92 Web Server : Apache System : Linux ns3209505.ip-198-244-202.eu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Tue Nov 5 04:50:16 EST 2024 x86_64 User : yellowleaf ( 1019) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/yellowleaf/public_html/all_scripts/ |
Upload File : |
<?php
header('Content-Type: text/html; charset=utf-8');
ini_set('max_execution_time', 300);
$path = $_SERVER['DOCUMENT_ROOT'];
include_once $path.'/connect_db.php';
/** update ads 'county_name' */
$connect->query("UPDATE `ads` SET `county_name`='County Antrim' WHERE county_name = 'Antrim'") || die('Update error: '.$connect->error);
$connect->query("UPDATE `ads` SET `county_name`='Blaenau Gwent' WHERE county_name = 'Gwent'") || die('Update error: '.$connect->error);
$connect->query("UPDATE `ads` SET `county_name`='Greater London' WHERE county_name = 'London'") || die('Update error: '.$connect->error);
/** update "towns_new" table's "r_county_name" column */
$connect->query("UPDATE `towns_new` SET `r_county_name`='Lanarkshire' WHERE `r_county_name` LIKE '%Lanarkshire%'") || die('Update error: '.$connect->error);