✔ PDO vs MySQLi

Strafi

Strafi

Erfahrenes Mitglied
Wo liegt der fehler******** Dreh bald ab mit dem PDO!

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
 
hat sich erledigt... alle labern von wihle oder foreach, doch PDO bringt da fetchAll() mit....

tschau
 
Um antworten zu können musst du eingeloggt sein.

Neue Beiträge

Zurück