<?php

include 'class_connexion.php';



$add = new add();



/*** The DSN ***/

$add->dsn = "mysql:dbname=ordre;host=localhost";

    

/*** MySQL username and password ***/

$add->username = 'mot de passe';

$add->password = 'XXXXXXXX';





/*** array of values to insert ***/

$values = array(

array('name'=>'chien', 'type'=>'dog'),

array('name'=>'chien', 'type'=>'berger'),

);



/*** insert the array of values ***/

$add->dbInsert('animals', $values);



/*** select all records from table ***/

$records = $add->rawSelect('SELECT * FROM animals');



/*** fetch only associative array of values ***/

$rows = $records->fetchAll(PDO::FETCH_ASSOC);



/*** display the records ***/

foreach($rows as $row)

{

foreach($row as $fieldname=>$value)

{

echo $fieldname.' = '.$value.'<br />';

}

echo '<hr />';

}

?>

<?php

 public function dbInsert($table, $values)

        {

            $this->conn();

            /*** snarg the field names from the first array member ***/

            $fieldnames = array_keys($values[0]);

            /*** now build the query ***/

            $size = sizeof($fieldnames);

            $i = 1;

            $sql = "INSERT INTO $table";

            /*** set the field names ***/

            $fields = '( ' . implode(' ,', $fieldnames) . ' )';

            /*** set the placeholders ***/

            $bound = '(:' . implode(', :', $fieldnames) . ' )';

            /*** put the query together ***/

            $sql .= $fields.' VALUES '.$bound;



            /*** prepare and execute ***/

            $stmt = $this->db->prepare($sql);

            foreach($values as $vals)

            {

                $stmt->execute($vals);

            }

        }

?>

<?php

$values = array(array("animal_name"=>"".$_POST['animal_name']."", "animal_type"=>"".$_POST['animal_type'].""));

?>