<?php$timestart=microtime(true);require_once("../../inc/confNetisse.php");ini_set('memory_limit','-1');$queryA="SELECT id_agence FROM ca_agences";$resultA=excuteQuery($queryA);while($agence=$resultA->fetchObject()){$query="SELECT *, TIMEDIFF(date_priseencharge,date_arrivee) as DA, TIMEDIFF(date_cloture,date_priseencharge) as DR FROM ca_clients WHERE id_agence=".intval($agence->id_agence);$result=excuteQuery($queryA);$dataArray=array();while($row=$result['stmt']->fetch(PDO::FETCH_ASSOC)){$dataArray[]=$row;}$serialized=serialize($dataArray);$stmt=excuteQuery($GLOBALS['cnx'],"INSERT INTO ca_historique_stats VALUES('',".intval($agence->id_agence).",'','".$serialized."')");if(!$stmt['status'])wts_die(var_dump($stmt['stmt']->errorInfo()));}$timeend=microtime(true);$time=$timeend-$timestart;$page_load_time=number_format($time,3);echo"Debut du script: ".date("H:i:s",$timestart);echo"<br>Fin du script: ".date("H:i:s",$timeend);echo"<br>Script execute en ".$page_load_time." sec";?>