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 32
| try
{
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$bdd = new PDO('mysql:host=localhost;dbname=osf', 'root', '', $pdo_options); // Connexion PDO
$sql=" SELECT SUM(ITSTOTALCALLS) AS APPELS24H
FROM ACT_LGOC_STATS_H_
WHERE (SITE = '0acb2447-m4n2y75sk-185'
OR SITE = '0plf2447-yun2y75sk-18b'
OR SITE = '0tiu2447-m4poi75sk-266')
AND UP_SITE = '0acb2447-4bsbs9xotk-3f'
AND (ACVECTOR_ID = ACT_LGOC_STATS_H_.VECTOR_ID)
AND INTERVALSTART >= TO_DATE(TO_CHAR(SYSDATE-1, 'DD-MM-YYYY HH24:MI:SS'))
AND INTERVALEND <= TO_DATE(TO_CHAR(SYSDATE, 'DD-MM-YYYY HH24:MI:SS'))";
$test= ociparse($odbc,$sql);
oci_define_by_name($test, 'APPELS24H', $appels24h);
ociexecute($test,OCI_DEFAULT);
$delete = $bdd->prepare('TRUNCATE appel'); // Vidage de la table
$delete->execute();
while (ocifetch($test))
{
$result[]=Array($datecreation,$provider,$consumer,$severity,$message);
$req = $bdd->prepare('INSERT INTO appel(appels24h) VALUES(:appels24h)'); // Insertion des nouvelles valeurs
$req->execute(array(
'appels24h' => $appels24h
));
} |
Partager