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 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
|
$query="SELECT `Age` AS 'Age', CASE `Tranche surface`
WHEN '1000-1999 ' THEN 'Surface 1000-4999'
WHEN '2000-4999 ' THEN 'Surface 1000-4999'
ELSE `Tranche surface`
END AS 'Tranche surface Group'
, SUM(`Nbr 2011`) AS 'Nbr 2011' FROM basepays GROUP BY `Age`, `Tranche surface Group` LIMIT 10";
$DB_NAME = 'xxx';
$DB_HOST = 'localhost';
$DB_USER = 'xxx';
$DB_PASS = 'xxx';
$db = mysql_connect($DB_HOST, $DB_USER,$DB_PASS);
mysql_select_db("$DB_NAME",$db);
$result = mysql_query($query,$db);
while ($myrow = mysql_fetch_row($result)) {
var_dump($myrow);
}
$mysqli = new mysqli($DB_HOST, $DB_USER, $DB_PASS, $DB_NAME);
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
// A QUICK QUERY ON A FAKE USER TABLE
$result = $mysqli->query($query) or die($mysqli->error.__LINE__);
// GOING THROUGH THE DATA
if($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
var_dump($row);
}
}
else {
echo 'NO RESULTS';
}
// CLOSE CONNECTION
mysqli_close($mysqli);
$db = new PDO("mysql:host=$DB_HOST;dbname=$DB_NAME;charset=utf8", $DB_USER, $DB_PASS);
try {
//connect as appropriate as above
$stmt=$db->query($query); //invalid query!
var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
} catch(PDOException $ex) {
echo "An Error occured!"; //user friendly message
some_logging_function($ex->getMessage());
} |
Partager