Strafi
Erfahrenes Mitglied
Wo liegt der fehler******** Dreh bald ab mit dem PDO!
So muss die ausgabe bzw. der array() sein:
erzeugt mit:
So und so sieht das mit PDO aus und ich weiss nicht warum.
der array()
und so mit PDO erzeugt:
Wie ihr seht sind die arrays unterschiedlich. Ausgeführt wird das alles in einer for schleife.
Doch der Array muss aussehen wie oben.
Grüße
So muss die ausgabe bzw. der array() sein:
PHP:
array(12) { [0]=> array(3) { ["error"]=> string(1) "0" ["timeout"]=> string(1) "0" ["delivered"]=> string(1) "1" } [1]=> array(3) { ["error"]=> string(1) "0" ["timeout"]=> string(1) "0" ["delivered"]=> string(1) "1" } [2]=> array(3) { ["error"]=> string(1) "1" ["timeout"]=> string(1) "0" ["delivered"]=> string(1) "1" } [3]=> array(3) { ["error"]=> string(1) "0" ["timeout"]=> string(1) "0" ["delivered"]=> string(1) "0" } [4]=> array(3) { ["error"]=> string(1) "0" ["timeout"]=> string(1) "0" ["delivered"]=> string(1) "0" } [5]=> array(3) { ["error"]=> string(1) "0" ["timeout"]=> string(1) "1" ["delivered"]=> string(1) "0" } [6]=> array(3) { ["error"]=> string(1) "0" ["timeout"]=> string(1) "0" ["delivered"]=> string(1) "0" } [7]=> array(3) { ["error"]=> string(1) "0" ["timeout"]=> string(1) "0" ["delivered"]=> string(1) "0" } [8]=> array(3) { ["error"]=> string(1) "0" ["timeout"]=> string(1) "0" ["delivered"]=> string(1) "0" } [9]=> array(3) { ["error"]=> string(1) "0" ["timeout"]=> string(1) "0" ["delivered"]=> string(1) "0" } [10]=> array(3) { ["error"]=> string(1) "0" ["timeout"]=> string(1) "0" ["delivered"]=> string(1) "0" } [11]=> array(3) { ["error"]=> string(1) "0" ["timeout"]=> NULL ["delivered"]=> string(1) "0" } } array(2) { [0]=> array(3) { ["error"]=> string(1) "0" ["timeout"]=> string(1) "0" ["delivered"]=> string(1) "1" } [1]=> array(3) { ["error"]=> string(1) "0" ["timeout"]=> string(1) "0" ["delivered"]=> string(1) "1" } }
erzeugt mit:
PHP:
while($row = mysql_fetch_assoc($this->result))
{
$return[] = $row;
}
So und so sieht das mit PDO aus und ich weiss nicht warum.
der array()
PHP:
array(12) { [0]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "1" [2]=> string(1) "1" } [1]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "1" [2]=> string(1) "1" } [2]=> array(6) { ["error"]=> string(1) "1" [0]=> string(1) "1" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "1" [2]=> string(1) "1" } [3]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [4]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [5]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "1" [1]=> string(1) "1" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [6]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [7]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [8]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [9]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [10]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [11]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> NULL [1]=> NULL ["delivered"]=> string(1) "0" [2]=> string(1) "0" } } array(14) { [0]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "1" [2]=> string(1) "1" } [1]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "1" [2]=> string(1) "1" } [2]=> array(6) { ["error"]=> string(1) "1" [0]=> string(1) "1" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "1" [2]=> string(1) "1" } [3]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [4]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [5]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "1" [1]=> string(1) "1" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [6]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [7]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [8]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [9]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [10]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [11]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> NULL [1]=> NULL ["delivered"]=> string(1) "0" [2]=> string(1) "0" } [12]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "1" [2]=> string(1) "1" } [13]=> array(6) { ["error"]=> string(1) "0" [0]=> string(1) "0" ["timeout"]=> string(1) "0" [1]=> string(1) "0" ["delivered"]=> string(1) "1" [2]=> string(1) "1" } }
und so mit PDO erzeugt:
PHP:
// die gleiche $sql
$stmt = $db->prepare($sql);
$stmt->execute();
while($rows = $stmt->fetch(PDO::FETCH_ASSOC)){
$requests[] = $rows;
}
Wie ihr seht sind die arrays unterschiedlich. Ausgeführt wird das alles in einer for schleife.
Doch der Array muss aussehen wie oben.
Grüße