djo

Inscris le 14/08/2007 à 22:56
  • Nombre de sujets
    2
  • Nombre de messages
    11
  • Nombre de commentaires
    Aucun
  • Nombre de news
    Aucune
  • Niveau en PHP
    Débutant

Ses dernières news

Aucune news

Ses derniers sujets sur les forums

forum
djo
le 30/08/2007 à 15:50
Probléme pour generer un cvs
Bonjour,

Je doit generer un cvs avec le script ci dessous.
  1. <?php
  2. header("Content-type: application/vnd.ms-excel");
  3. header("Content-disposition: attachment; filename=Historique_" . date("Ymd").".cvs");
  4. $csv_output = "Month,DeviceName,InterfaceName,InterfaceDesc,Minor,Major,Critical";
  5. $csv_output .= "\n";
  6.   include("../include/connection.php");
  7. //Lecture de la data base
  8.                              $query = ("
  9.                select
  10. 	YEAR(FROM_UNIXTIME(History.eventdate)) as Year,
  11. 	MONTH(FROM_UNIXTIME(History.eventdate)) as Month,
  12. 	Devices.name as DeviceName,
  13. 	Interfaces.name as InterfaceName,
  14. 	Devices.name2 as devicesName2,
  15. 	Interfaces.description as InterfaceDesc,
  16. 	SUM(case StatusTypes.name when 'Normal' then 1 else 0 end) as Normal,
  17. 	SUM(case StatusTypes.name when 'Minor' then 1 else 0 end) as Minor,
  18. 	SUM(case StatusTypes.name when 'Major' then 1 else 0 end) as Major,
  19. 	SUM(case StatusTypes.name when 'Critical' then 1 else 0 end) as Critical

  21. from
  22. 	History
  23. 	inner join StatusTypes on History.statusid = StatusTypes.id
  24. 	inner join Cells on History.cellid = Cells.id
  25. 	inner join Interfaces on Cells.interfaceid = Interfaces.id
  26. 	inner join ServiceTypes on Cells.serviceid = ServiceTypes.id
  27. 	inner join Devices on Interfaces.deviceid = Devices.id

  29. where
  30. 	ServiceTypes.name = 'FEC'

  32. group by
  33. 	YEAR(FROM_UNIXTIME(History.eventdate)),
  34. 	MONTH(FROM_UNIXTIME(History.eventdate)),
  35. 	Devices.name,
  36. 	Interfaces.name,
  37. 	Interfaces.description


  40.     
  41. $result = mysql_query($query)
  42. ");
  43. while($row = mysql_fetch_array($result)) {

  45. $cvs_output = "$row[Month],$row[DeviceName],$row[InterfaceName],$row[devicesName2],$row[InterfaceDesc],$row[Ninor],$row[Major],$row[Critical]\n";
  46. }
  47. print $csv_output;
  48. exit;
  49. ?>

Mais il me genere une erreur dans le cvs :
  1. <b>Warning</b>:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/var/www/monitoring/historique/cvs.php</b> on line <b>43</b><br />

Si quelqu'un pouvais me dire ou ce trouve l'erreur car perso je ne la trouve pas merci d'avance pour l'aide.
djo
le 16/08/2007 à 10:52
Probléme avec la fonction switch
hello tous

Voila je dev un petit soft en php qui doit recuperer des instructions dans une db et part rapport a cetaines données il doit mettre une couleur de fond sous le text a afficher mais pour le moment il m'affiche une page blanche:

Voici mon code si quelqu'un avai l'amabilitée de m'aider a comprendre ou ce trouve mon erreur ca serai super:

  1. <?php
  2. include "connection.php";
  3. $req = mysql_query("select id, mfrom, subject, priority  from incoming order by id desc limit 0,1") or die( 'Erreur '.$req.'<br>'.mysql_error() );

  5.  while ( $row = mysql_fetch_row( $req ) )

  7.   
  8.   
  9. switch ($row['priority']) {
  10.  case 1 :
  11.     $couleur = '#4fce1c';
  12.     break;
  13.  case 2 :
  14.     $couleur = '#f2e910';
  15.      break;
  16.  case 3 :
  17.     $couleur = '#f89909';
  18.     break;
  19.  case 4 :
  20.     $couleur = '#e22112';
  21.     break;
  22. }

  24. {
  25.     echo '<table style="background-color:'.$couleur.';">';
  26.    // echo '<tr style="background-color:'.$couleur.';">';  
  27.     echo '<td>'. $row[0] .'</td>'.'<br>'.'<br>';
  28.       echo '<td>'. $row[1].'</td>' ;
  29.        echo '<td>'.'<h1>'. $row[2].'</h1>'.'</td>';
  30.       echo '</tr>';
  31.     echo '</table>';
  32.     
  33. };




  38. ?>


Merci d'avance

Ses derniers messages sur les forums

forum
djo
le 03/09/2007 à 08:59
Probléme pour generer un cvs
La requette SQL fonctionne parfaitement sur ce script:
  1. <? /*
  2. Nom:
  3. Creation: 
  4. Date:26.07.2007
  5. Desc: Stats des alarmes SNR
  6. */?>
  7. <html xmlns="http://www.w3.org/1999/xhtml">
  8. 	<head>
  9. 		<title>|Statistique| Alerts SNR</title>
  10. 		<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  11. <style type="text/css">
  12. <!--
  13. 	.mon_th_title {
  14. 		background:#90929C;
  15. 		color:#ffffff;
  16. 		font-weight: bolder;
  17. 	}

  19. 	tr {
  20. 		min-height: 5px;
  21. 		font-family: Verdana, Arial, Helvetica, sans-serif;
  22. 		font-size: 8pt;
  23. 	}
  24. 	h1 {
  25. 		min-height: 6px;
  26. 		font-family: Verdana, Arial, Helvetica, sans-serif;
  27. 		font-size: 10pt;
  28. 	}
  29. -->
  30. </style>
  31. </head>
  32. <body>
  33.     <table>

  35.         <tr class="mon_th_title">
  36. 					<? //Construction URL
  37. 					$url = 'index.php?';

  39. 					if (!empty($_GET['limit_by']))
  40. 						$url.= 'limit_by='.$_GET['limit_by'].'&';

  42. 					if (!empty($_GET['limit']))
  43. 						$url.= 'limit='.$_GET['limit'].'&';

  45. 					if (!empty($_GET['desc'])) {

  47. 						if ($_GET['desc']=='yes')
  48. 							$url.= 'desc=no&';

  50. 						if ($_GET['desc']=='no')
  51. 							$url.= 'desc=yes&';
  52. 					}
  53. 					else {
  54. 						$url.= 'desc=no&';
  55. 					}

  57. 					$url.= 'order='


  60. 					?>
  61.                     <th><a href="<?=$url.'Month'?>">Mois</a></th>
  62.                     <th><a href="<?=$url.'Month'?>">Années</a></th>
  63. 			        <th><a href="<?=$url.'devices'?>">Devices</a></th>
  64. 			        <th><a href="<?=$url.'interface'?>">Interface</a></th>
  65.                     <th><a href="<?=$url.'descinterface'?>">Desc Interface</a></th>
  66. 			        <th><a href="<?=$url.'minor'?>">Minor</a></th>
  67.                     <th><a href="<?=$url.'major'?>">Major</a></th>
  68.                     <th><a href="<?=$url.'critical'?>">Critical</a></th>
  69.         </tr>
  70. 		<?

  72. 		$limit = "";
  73. 		$where = "";
  74. 		$order = "";
  75. 		$desc = "";

  77. 		if (!empty($_GET['limit_by'])) {

  79. 			switch ($_GET['limit_by']) {
  80. 				case 'rows' :
  81. 					$limit = 'LIMIT 0,'.$_GET['limit'];
  82. 				break;

  84. 				case 'month' :
  85. 					$where = 'AND MONTH >'.(limit()-$_GET['limit']);
  86. 				break;

  88.                 case 'devices' :
  89. 					$where = 'AND Devices.name >'.(limit()-$_GET['limit']);
  90. 				break;

  92. 				default :

  94. 				break;
  95. 			}

  97. 		}
  98. 		else {
  99. 			$limit = 'LIMIT 0,1000';
  100. 		}

  102. 		if (!empty($_GET['order'])) {

  104. 			switch ($_GET['order']) {
  105. 				case 'month' :
  106. 					$order = 'ORDER BY MONTH';
  107. 				break;

  109.                 		case 'year' :
  110. 					$order = 'ORDER BY YEAR';
  111. 				break;

  113.                		case 'devices' :
  114. 					$order = 'ORDER BY Devices.name';
  115. 				break;

  117. 				case 'interface' :
  118. 					$order = 'ORDER BY Interfaces.name';
  119. 				break;

  121.                 case 'descinterface':
  122.                     $order = 'ORDER BY InterfaceDesc';
  123.                 break;

  125. 				case 'service' :
  126. 					$order = 'ORDER BY ServiceTypes.name';
  127. 				break;

  129. 				case 'minor' :
  130. 					$order = 'ORDER BY Minor';
  131. 				break;

  133.                 case 'major' :
  134. 					$order = 'ORDER BY Major';
  135. 				break;

  137.                 case 'critical' :
  138. 					$order = 'ORDER BY Critical';
  139. 				break;
  140. 			}

  142. 		}
  143. 		else {
  144. 			$order = 'ORDER BY History.eventdate DESC';
  145. 		}

  147. 		if (!empty($_GET['desc'])) {
  148. 			if ($_GET['limit_by']=="devices") {

  150. 				switch ($_GET['desc']) {
  151. 					case 'no' :
  152. 						$desc = '';
  153. 					break;

  155. 					case 'yes' :
  156. 						$desc = 'DESC';
  157. 					break;

  159. 					default :
  160. 						$desc = '';
  161. 					break;
  162. 				}
  163. 			}

  165. 		}
  166. 		else {
  167. 			$desc = '';
  168. 		}





  174. include("../include/connection.php");
  175. //Lecture de la data base
  176.                              $sql_history = mysql_query("
  177.                select
  178. 	YEAR(FROM_UNIXTIME(History.eventdate)) as Year,
  179. 	MONTH(FROM_UNIXTIME(History.eventdate)) as Month,
  180. 	Devices.name as DeviceName,
  181. 	Interfaces.name as InterfaceName,
  182. 	Devices.name2 as devicesName2,
  183. 	Interfaces.description as InterfaceDesc,
  184. 	SUM(case StatusTypes.name when 'Normal' then 1 else 0 end) as Normal,
  185. 	SUM(case StatusTypes.name when 'Minor' then 1 else 0 end) as Minor,
  186. 	SUM(case StatusTypes.name when 'Major' then 1 else 0 end) as Major,
  187. 	SUM(case StatusTypes.name when 'Critical' then 1 else 0 end) as Critical

  189. from
  190. 	History
  191. 	inner join StatusTypes on History.statusid = StatusTypes.id
  192. 	inner join Cells on History.cellid = Cells.id
  193. 	inner join Interfaces on Cells.interfaceid = Interfaces.id
  194. 	inner join ServiceTypes on Cells.serviceid = ServiceTypes.id
  195. 	inner join Devices on Interfaces.deviceid = Devices.id

  197. where
  198. 	ServiceTypes.name = 'SNR'

  200. group by
  201. 	YEAR(FROM_UNIXTIME(History.eventdate)),
  202. 	MONTH(FROM_UNIXTIME(History.eventdate)),
  203. 	Devices.name,
  204. 	Interfaces.name,
  205. 	Interfaces.description


  208.     ".$where."
  209. 	".$order."
  210. 	".$limit.$desc."
  211. ;");
  212. while($data_history = mysql_fetch_array($sql_history)) {


  215. //Tableau d'affichage



  219.   {
  220.   echo "<tr>";
  221.  //echo '<tr class="mon_tr_ok" style="background-color:'.$couleur.';">';
  222.   echo '<td bgcolor="#CCCCCC">' . $data_history['Month']."<br>"."</td>";
  223.   echo '<td bgcolor="#CCCCCC">' . $data_history['Year']. "</td>";
  224.   echo '<td bgcolor="#CCCCCC">' . $data_history['DeviceName'] .  "</td>";
  225.   echo '<td bgcolor="#CCCCCC">' . $data_history['InterfaceName'] .  "</td>";
  226.   echo '<td bgcolor="#CCCCCC">' . $data_history['InterfaceDesc']. "</td>";
  227.   echo '<td bgcolor="#FFFF33">' . $data_history['Minor'] . "</td>";
  228.   echo '<td bgcolor="#FF9900">' . $data_history['Major'] . "</td>";
  229.   echo '<td bgcolor="#CC0000">' . $data_history['Critical']. "</td>";
  230. //  echo "<td>" . $data_history['interfacesSnr'] . "</td>";
  231. //  echo"<td>" . $image = imagecreatefromgif ("image_test.GIF"); ."</td>";
  232.   echo "</tr>";
  233.   }


  236.     }
  237. ?>
  238.      </table>
  239. </body>
  240. </html>


donc elle devrais fonctionner aussi sur ce script. Non ?
djo
le 02/09/2007 à 15:30
Probléme pour generer un cvs
et c'est le faite de mettre des parenthèse sur la chaine sql qui fait l'erreur sur le while?
djo
le 02/09/2007 à 13:54
Probléme pour generer un cvs
Hello,

Alors j'ai changer le script qui ressemble a ceci maintenent:
  1. <?php
  2. header("Content-type: text/x-csv");
  3. header("Content-disposition: attachment; filename=Historique_SNR_" . date("Ymd").".csv");

  5.   include("../include/connection.php");
  6. //Lecture de la data base
  7.                              $sql = ("
  8.                select
  9. 	YEAR(FROM_UNIXTIME(History.eventdate)) as Year,
  10. 	MONTH(FROM_UNIXTIME(History.eventdate)) as Month,
  11. 	Devices.name as DeviceName,
  12. 	Interfaces.name as InterfaceName,
  13. 	Devices.name2 as devicesName2,
  14. 	Interfaces.description as InterfaceDesc,
  15. 	SUM(case StatusTypes.name when 'Normal' then 1 else 0 end) as Normal,
  16. 	SUM(case StatusTypes.name when 'Minor' then 1 else 0 end) as Minor,
  17. 	SUM(case StatusTypes.name when 'Major' then 1 else 0 end) as Major,
  18. 	SUM(case StatusTypes.name when 'Critical' then 1 else 0 end) as Critical

  20. from
  21. 	History
  22. 	inner join StatusTypes on History.statusid = StatusTypes.id
  23. 	inner join Cells on History.cellid = Cells.id
  24. 	inner join Interfaces on Cells.interfaceid = Interfaces.id
  25. 	inner join ServiceTypes on Cells.serviceid = ServiceTypes.id
  26. 	inner join Devices on Interfaces.deviceid = Devices.id

  28. where
  29. 	ServiceTypes.name = 'SNR'

  31. group by
  32. 	YEAR(F0ROM_UNIXTIME(History.eventdate)),
  33. 	MONTH(FROM_UNIXTIME(History.eventdate)),
  34. 	Devices.name,
  35. 	Interfaces.name,
  36. 	Interfaces.description


  39.  ;");   
  40. $resultat = mysql_query ($sql);
  41. $list = "";
  42. while ($snr = mysql_fetch_array ($resultat))
  43. {
  44. 	$month = $snr ['Month'];
  45. 	$device = $snr ['DeviceName'];
  46.        $interface = $snr ['InterfaceName'];
  47.        $device2 = $snr ['InterfaceDesc'];
  48.        $minor = $snr ['Minor'];
  49.        $major = $snr ['Major'];
  50.        $critical = $snr ['Critical'];
  51. 	$list .= "\"$month\",\"$device\",\"$interface\",\"$device2\",\"$minor\",\"$major\",\"$critical\"\r\n";
  52. }
  53. echo $list;
  54. ?>

mais j'ai une erreur a la ligne 42 sur le while
mysql_fetch_array(): supplied argument is not a valid MySQL result resource

la je sèche completement comment résoudre cette erreur une idée ?

Ses derniers commentaires de news

Aucun commentaire de news

Ses derniers commentaires de sites

Aucun commentaire de sites

Ses derniers commentaires de wall

Aucun commentaire wall
LoadingChargement en cours