Conectare la mijlocul paginii la mySql pe alt server.How?

[evolution]

Am facut un site2 si vreau sa afisez niste informatii aflate pe siteul1.
Siteul2 este pe alt server decat siteul1.

Acum am pe siteul2 asta:

<?php include ("db2.php");?>

<html>
<head>
metataguri
</head>
<body>
<?
$sql = "select * from articole where (idunic='$idunic' and titlu='$titlu')";
$result = mysql_query ($sql);
while($row = mysql_fetch_array($result)){
$idunic=$row["idunic"];
$titlu=$row["titlu"];

echo"
$titlu
"; ?>

</body>
</html>

unde db2.php contine

<?php
$dbhost = "localhost";
$dbname = "numebazadedate2";
$dbuser = "username2";
$dbpasswd = "parola2";
$prefix = "";
if(!$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd"))
die('Check $dbhost, $dbuser, and $dbpasswd in config.php.');

if(!@mysql_select_db("$dbname",$db))
die("Unable to find the database <b>$dbname</b> on your MySQL server.");
?>

Acum am pus la inceput 2 includeuri ,ca sa accesez ambele baze de date,apoi sa afisez informatiile,dar imi da eroare la conectarea db1.php
<?php include ("db1.php");?>
<?php include ("db2.php");?>

db1.php contine

<?php
$dbhost = "siteul1.com";
$dbname = "numebazadedate1";
$dbuser = "username1";
$dbpasswd = "parola1";
$prefix = "";
if(!$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd"))
die('Check $dbhost, $dbuser, and $dbpasswd in config.php.');

if(!@mysql_select_db("$dbname",$db))
die("Unable to find the database <b>$dbname</b> on your MySQL server.");
?>

eroarea este: An Error OccurredUnable to connect to the database.Check $dbhost, $dbuser, and $dbpasswd in config.php. La $dbhost = "siteul1.com"; am inlocuit siteul1.com cu ip-ul siteului sau cu ip:port si tot nu merge.

[forapathy]

<?php include ("db1.php");?>
<?php include ("db2.php");?>

Daca scrii aia tu defapt o sa iti rezulte asta:

// site 1
$dbhost = "siteul1.com";
$dbname = "numebazadedate1";
$dbuser = "username1";
$dbpasswd = "parola1";
$prefix = "";
if(!$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd"))
die('Check $dbhost, $dbuser, and $dbpasswd in config.php.');

// site 2
$dbhost = "localhost";
$dbname = "numebazadedate2";
$dbuser = "username2";
$dbpasswd = "parola2";
$prefix = "";
if(!$db = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd"))
die('Check $dbhost, $dbuser, and $dbpasswd in config.php.');

... adica ai de 2 ori aceleasi variabile si primele sunt inlocuite cu continutul celor din site-ul 2.

Cel mai bine e sa faci o functie ceva de genu:

function conectareDB ($dbhost, $dbuser, $dbpasswd, $dbname ) {
$db = mysqli_connect($dbhost, $dbuser, $dbpasswd, $dbname);
if(!db)
{return false;}
else
{ return $db; }
}

asa.. si acum ai o functie mai generala si poti sa faci asa:

$con1 = conectareDB ("hostu_tau", "user", "parola", "numele_db" );
if($con1 == false) die("Nu a mers conexiunea");

$con2 = conectareDB ("hostu_tau2", "user2", "parola2", "numele_db2" );
if($con2 == false) die("Nu a mers conexiunea");


si acum ai 2 conexiiuni care le poti folosi.. in contiunuare:

// aici folosesti conexiunea 1
$sql = "select * from articole where (idunic='$idunic' and titlu='$titlu')";
$result = mysqli_query ($sql, $con1);
while($row = mysql_fetch_array($result)){
$idunic=$row["idunic"];
$titlu=$row["titlu"];

// aici folosesti conexiunea 2
$sql = "select * from articole where (idunic='$idunic' and titlu='$titlu')";
$result = mysqli_query ($sql, $con2);
while($row = mysql_fetch_array($result)){
$idunic=$row["idunic"];
$titlu=$row["titlu"];


NU am testat codul dar teoretic ar trebui sa functioneze
Invata sa folosesti mySQLImproved (mysqli) ca merge muult mai repede.
Si ar trebui sa inveti si cum sa folosesti functiile. Iti zic sigur daca citesti un manual de php macar pana la OOP o sa te descurci si muult mai usor.

Sper sa te ajute codu asta cu ceva .

Ahh si mai e si posibilitatea sa aibe portul 3306 blocat