| Server IP : 180.180.241.3 / Your IP : 216.73.216.194 Web Server : Microsoft-IIS/7.5 System : Windows NT NETWORK-NHRC 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/AppServ/www/ |
Upload File : |
<!DOCTYPE html>
<html lang="en-us">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
</head>
<body>
<?php
$db1 = mysql_connect( 'localhost', 'root', '1234', true );
mysql_select_db( 'human_rights_reports', $db1 );
$db2 = mysql_connect( 'localhost', 'root', '1234', true );
mysql_select_db( 'hrr', $db2 );
mysql_query( 'SET NAMES utf8;', $db1 );
mysql_query( 'SET NAMES utf8;', $db2 );
$provinces = [];
$rs = mysql_query( 'SELECT * FROM provinces', $db1 );
while( $row = mysql_fetch_assoc( $rs) ) {
$provinces[$row['name']] = array( $row['id'], $row['region_id'] );
}
mysql_free_result( $rs );
// echo '<pre>'; var_dump( $provinces ); echo '</pre>';
$sql = 'SELECT * FROM provinces WHERE name = \'จ.%s\'';
$update = 'UPDATE provinces SET region_id = %d WHERE id = %s';
foreach( $provinces as $kProvince => $vProvince ) {
$rs = mysql_query( sprintf( $sql, $kProvince ), $db2 );
if ( mysql_num_rows( $rs ) == 0 ) {
echo "$kProvince NOT found";
} else {
echo sprintf( "%s: " . $update, $kProvince, $vProvince[1], $vProvince[0] );
// $row = mysql_fetch_assoc( $rs );
// echo "$kProvince: ";
// mysql_query( sprintf( $update, $vProvince[1], $vProvince[0] ), $db2 );
}
echo '<br />';
// break;
}