Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
Next revision Both sides next revision
u4_databaser [2011-03-30 10:12]
Joakim Forsgren 		u4_databaser [2011-03-30 10:47]
Joakim Forsgren
Line 10: Line 10:
 for($i=0; $i<100000; $i++) { for($i=0; $i<100000; $i++) {
     $sql =  "INSERT INTO `Dates` (`DateTime` ,`Temp`) VALUES (...resten ska ni göra själva...";     $sql =  "INSERT INTO `Dates` (`DateTime` ,`Temp`) VALUES (...resten ska ni göra själva...";
-    $sql = "INSERT INTO `Dates` (`DateTime` ,`Temp`)  
-    VALUES (DATE_ADD('1970-01-01 00:00:00',INTERVAL " .($i*5). " HOUR),ROUND(RAND()*20)"; 
- 
     mysql_query($sql);     mysql_query($sql);
 } }
 ?> ?>
 </code> </code>
 +<php>
 +//    $sql = "INSERT INTO `Dates` (`DateTime` ,`Temp`) VALUES (DATE_ADD('1970-01-01 00:00:00',INTERVAL " .($i*5). " HOUR),ROUND(RAND()*20))";
 +</php>
 +
  
 Tips! DATE_ADD, RAND, ROUND Tips! DATE_ADD, RAND, ROUND
Line 48: Line 49:
 | 2005 | 9.8808790016154 |  1752 |  | 2005 | 9.8808790016154 |  1752 | 
 +------+-----------------+-------+ +------+-----------------+-------+
 +</code>
 +
 <php> <php>
-<? 
 /* /*
 SELECT YEAR(DateTime) AS Year, AVG(Temp) AS avg_TEMP, COUNT(ID) AS Antal FROM Dates  SELECT YEAR(DateTime) AS Year, AVG(Temp) AS avg_TEMP, COUNT(ID) AS Antal FROM Dates 
Line 55: Line 57:
 */ */
 </php> </php>
-</code> 
  
 3. Plocka fram de år som har temperaturer registrerade 366 dagar... 3. Plocka fram de år som har temperaturer registrerade 366 dagar...
Line 77: Line 78:
 | 2024 |  366 | | 2024 |  366 |
 +------+------+ +------+------+
 +</code>
 <php> <php>
 /* /*
Line 84: Line 86:
 </php> </php>
  
-</code>+