| Server IP : 93.86.61.54 / Your IP : 216.73.216.60 Web Server : Apache/2.4.62 (Ubuntu) System : Linux rasin.ddns.net 6.8.0-124-generic #124~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 21:05:19 UTC x86_64 User : www-data ( 33) PHP Version : 8.4.22 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/projects/radvre/admin/ |
Upload File : |
<?php
//
// http://net-nas/www/logdogplan/merge_db.php
//
//Connect To remote Database (net-tim)
$hostname='192.168.213.15:3306';
$username='Misko';
$password='skomi32';
$dbname='logdogplan';
$usertable='mk_klase';
$yourfield = 'imklas';
echo "<h3>NET-TIM ".$hostname."</h3>";
mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
mysql_select_db($dbname);
// Nasa slova
//$query = "SET NAMES 'utf8' COLLATE 'utf8_unicode_ci'";
//$result = mysql_query($query);
//
$query = 'SELECT * FROM ' . $usertable;
$result = mysql_query($query);
if($result) {
while($row = mysql_fetch_array($result)){
$id = $row[id];
$name = $row[$yourfield];
echo $id." - ".$name.'<br>';
}
}
else {
print "Database NOT Found ";
mysql_close($db_handle);
}
//
//
//Connect To remote Database (net-nas)
$hostname='192.168.213.25:3306';
$username='Misko';
$password='skomi32';
$dbname='logdogplan';
$usertable='mk_klase';
$yourfield = 'imklas';
echo "<h3>NET-NAS ".$hostname."</h3>";
mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
mysql_select_db($dbname);
// Nasa slova
//$query = "SET NAMES 'utf8' COLLATE 'utf8_unicode_ci'";
//$result = mysql_query($query);
//
$query = 'SELECT * FROM ' . $usertable;
$result = mysql_query($query);
if($result) {
while($row = mysql_fetch_array($result)){
$id = $row[id];
$name = $row[$yourfield];
echo $id." - ".$name.'<br>';
}
}
else {
print "Database NOT Found ";
mysql_close($db_handle);
}
?>