I basically need to run a count query on three separate databases with four queries then display the information, this is what I have, but it clearly doesn't work. Can somebody help me?
<?php
error_reporting(-1);
ini_set('display_errors', true);
$con = mysqli_connect(
'192.168.20.10',
'root2',
'password',
'contaque'
);
$con2 = mysqli_connect(
'192.168.20.222',
'root2',
'password',
'contaque'
);
$con3 = mysqli_connect(
'192.168.20.8',
'root2',
'password',
'contaque'
);
$res = mysqli_query(
$con,
"SELECT COUNT(*) AS 'total1' FROM contaque_hopper WHERE campaign_id = 'CLOSERUK';"
);
$res = mysqli_query(
$con2,
"SELECT COUNT(*) AS 'total2' FROM contaque_hopper WHERE campaign_id = 'CLOSERTC';"
);
$res = mysqli_query(
$con2,
"SELECT COUNT(*) AS 'total3' FROM contaque_hopper WHERE campaign_id = 'CLOSERST';"
);
$res = mysqli_query(
$con3,
"SELECT COUNT(*) AS 'total4' FROM contaque_hopper WHERE campaign_id = 'CLOSER3C';"
);
echo 'Buffer Status 2H: ', (int)$row['total1'], ' records.';
echo 'Buffer Status TC: ', (int)$row['total2'], ' records.';
echo 'Buffer Status ST: ', (int)$row['total3'], ' records.';
echo 'Buffer Status 3C: ', (int)$row['total4'], ' records.';
?>
Question
CPressland
Hey Guys wassup?
I basically need to run a count query on three separate databases with four queries then display the information, this is what I have, but it clearly doesn't work. Can somebody help me?
<?php error_reporting(-1); ini_set('display_errors', true); $con = mysqli_connect( '192.168.20.10', 'root2', 'password', 'contaque' ); $con2 = mysqli_connect( '192.168.20.222', 'root2', 'password', 'contaque' ); $con3 = mysqli_connect( '192.168.20.8', 'root2', 'password', 'contaque' ); $res = mysqli_query( $con, "SELECT COUNT(*) AS 'total1' FROM contaque_hopper WHERE campaign_id = 'CLOSERUK';" ); $res = mysqli_query( $con2, "SELECT COUNT(*) AS 'total2' FROM contaque_hopper WHERE campaign_id = 'CLOSERTC';" ); $res = mysqli_query( $con2, "SELECT COUNT(*) AS 'total3' FROM contaque_hopper WHERE campaign_id = 'CLOSERST';" ); $res = mysqli_query( $con3, "SELECT COUNT(*) AS 'total4' FROM contaque_hopper WHERE campaign_id = 'CLOSER3C';" ); echo 'Buffer Status 2H: ', (int)$row['total1'], ' records.'; echo 'Buffer Status TC: ', (int)$row['total2'], ' records.'; echo 'Buffer Status ST: ', (int)$row['total3'], ' records.'; echo 'Buffer Status 3C: ', (int)$row['total4'], ' records.'; ?>Any ideas people?
Link to comment
Share on other sites
22 answers to this question
Recommended Posts