preparevspdo

<?php

    $host='localhost';
    $dbname='test';
    $username='root';
    $password='';

    $db = new PDO('mysql:host='.$host.';dbname='.$dbname,$username,$password);
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);

    function edit($db,$sql,$data = null)
    {
        $req = $db->prepare($sql);
        $req->execute($data);
        $req->closeCursor();
    }

    function read($db,$sql,$data = null)
    {
        $req = $db->prepare($sql);
        $req->execute($data);
        $data = $req->fetchAll(PDO::FETCH_ASSOC);
        $req->closeCursor();
        return $data;
    }


    $sql = "CREATE TABLE IF NOT EXISTS `jeux_video` (
    `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `nom` varchar(255) NOT NULL,
    `possesseur` varchar(255) NOT NULL,
    `console` varchar(255) NOT NULL,
    `prix` double NOT NULL DEFAULT '0',
    `nbre_joueurs_max` int(11) NOT NULL DEFAULT '0',
    `commentaires` text NOT NULL,
    KEY `ID` (`ID`)
    )";

    edit($db,$sql);

    $sql = 'select * from jeux_video';
    $games = read($db,$sql);

    if(empty($games)){

        for ($i=0; $i < 1000; $i++) {

            $sql = 'INSERT INTO jeux_video
            (nom,possesseur,console)
            VALUES (:nom,:possesseur,:console)';
            $data_ex =  array(
            ':nom' => 'jeux '.$i,
            ':possesseur' => 'possesseur '.$i,
            ':console' => 'console'.$i
            );

            edit($db,$sql,$data_ex);

        }
    }


    /* -------------- Methode 1 Prepare --------------------*/

    microtime(true);
    $t0_methode1 = microtime();
    $sql = 'select * from jeux_video';
    $results = read($db,$sql);

    foreach ($results as $result) {
        echo $result['nom'].'-';
        echo $result['possesseur'].'-';
        echo $result['console'].'|>';
    }

    $t1_methode1 = microtime();

    $temps_methode_1 = $t1_methode1 - $t0_methode1;

    $temps_methode_1 = number_format($temps_methode_1, 6);

    echo '<h2> Temps 1ere methode  : '.$temps_methode_1.'</h2>';



    /* --------------- Methode 2 Query -------------------------*/


        microtime(true);
    $t0_methode2 = microtime();
    $sql = 'select * from jeux_video';

    $results = $db->query($sql)->fetchAll(PDO::FETCH_ASSOC);

    foreach ($results as $result) {
        echo $result['nom'].'-';
        echo $result['possesseur'].'-';
        echo $result['console'].'|>';
    }

    $t1_methode2 = microtime();

    $temps_methode_2 = $t1_methode2 - $t0_methode2;

    $temps_methode_2 = number_format($temps_methode_2, 6);

    echo '<h2> Temps 2eme methode  : '.$temps_methode_2.'</h2>';




?>