@@ -36,7 +36,7 @@ discard block |
||
| 36 | 36 | |
| 37 | 37 | //1ere methode: Utilisation de MYSQL |
| 38 | 38 | // marche mais n'est peu souple |
| 39 | - /* |
|
| 39 | + /* |
|
| 40 | 40 | * $results = DB::select(' |
| 41 | 41 | SELECT ROUND(AVG(TIMESTAMPDIFF(YEAR,dob, NOW()))) as age |
| 42 | 42 | FROM actors |
@@ -59,7 +59,7 @@ discard block |
||
| 59 | 59 | |
| 60 | 60 | // MAITRISE |
| 61 | 61 | |
| 62 | - $results = DB::table('actors') |
|
| 62 | + $results = DB::table('actors') |
|
| 63 | 63 | ->select(DB::raw('ROUND(AVG(TIMESTAMPDIFF(YEAR,dob, NOW()))) as age')) |
| 64 | 64 | ->first(); |
| 65 | 65 | |