1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
|
try
{
$bdd1 = new PDO('mysql:host=db2121.1and1.fr;dbname=db3441xxxxx', 'dbo3441xxxxx', 'passxxx');
$bdd2 = new PDO('mysql:host=db4545.1and1.fr;dbname=db3201yyyyy', 'dbo3201yyyyy', 'passxxx');
}
catch (Exception $e)
{
die('Erreur : ' . $e->getMessage());
}
$reponse1 = $bdd1->query('
SELECT date_commande, email, id, prixtotal, statut
FROM db3441xxxxx.commandes
UNION
SELECT date_commande, email, id, prixtotal, statut
FROM db3201yyyyy.bouille_commandes
ORDER BY id DESC
LIMIT ' . $premierMessageAafficher . ', ' . $nombreDeMessagesParPage
);
$reponse1->setFetchMode(PDO::FETCH_ASSOC); |
Partager