PHP -Anfrage nicht dasselbe mit SQL und PDO [geschlossen] ⇐ Php

[Anonymous]

In meinem PHP ist die Rückgabe des SQL nicht gleich, wenn ich die Anforderung direkt in mein SQL einfügt.

Code: Select all

$query = "SELECT DISTINCT rub_tag, qst_annee
FROM ProjetExcellence.Reponse r
INNER JOIN ProjetExcellence.Rubrique ru ON ru.rub_id = r.rep_rubriqueId
INNER JOIN ProjetExcellence.Questionnaire q ON q.qst_id = r.rep_questionnaireId
WHERE ru.rub_tag  = 'FORM_QUOTA'
ORDER BY qst_annee DESC";

$stmt = $pdo->prepare($query);
$stmt->execute();

var_dump($stmt);
var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
< /code>
Ergebnis: < /p>
object(PDOStatement)#28 (1) {
["queryString"]=>
string(337) "SELECT DISTINCT rub_tag, qst_annee
FROM ProjetExcellence.Reponse r
INNER JOIN ProjetExcellence.Rubrique ru ON ru.rub_id = r.rep_rubriqueId
INNER JOIN ProjetExcellence.Questionnaire q ON q.qst_id = r.rep_questionnaireId
WHERE ru.rub_tag  = 'FORM_QUOTA'
ORDER BY qst_annee DESC"
}
// 11 reuslts
array(11) {
[0]=>
array(2) {
["rub_tag"]=>
string(10) "FORM_QUOTA"
["qst_annee"]=>
string(4) "2024"
}
[............]
[10]=>
array(2) {
["rub_tag"]=>
string(10) "FORM_QUOTA"
["qst_annee"]=>
string(4) "2013"
}
}

Aber Wenn ich in meinem SQL vorbei kopiere:

Code: Select all

SELECT DISTINCT rub_tag, qst_annee
FROM ProjetExcellence.Reponse r
INNER JOIN ProjetExcellence.Rubrique ru ON ru.rub_id = r.rep_rubriqueId
INNER JOIN ProjetExcellence.Questionnaire q ON q.qst_id = r.rep_questionnaireId
WHERE ru.rub_tag  = 'FORM_QUOTA'
ORDER BY qst_annee DESC
< /code>
return 12 Ergebnisse (es fügt 2025 hinzu): < /p>
FORM_QUOTA
2025
FORM_QUOTA
2024
[...]
FORM_QUOTA
2013
< /code>
 Frage: < /strong> < /p>
Warum fehlt in meinem PHP "2025"? that.// 1 string, no var. Exactly the same in script and project.
$test = new PDO('mysql:host=XXXX;dbname=XXXX;charset=utf8', 'XXXX', 'XXXX');

$query = "SELECT DISTINCT rub_tag, qst_annee
FROM ProjetExcellence.Reponse r
INNER JOIN ProjetExcellence.Rubrique ru ON ru.rub_id = r.rep_rubriqueId
INNER JOIN ProjetExcellence.Questionnaire q ON q.qst_id = r.rep_questionnaireId
WHERE ru.rub_tag  = 'FORM_QUOTA'
ORDER BY qst_annee DESC";

$stmt = $test->prepare($query);
$stmt->execute();

echo $stmt->rowCount();
var_dump($stmt);
var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));