<?php
$host="localhost";
$base="TEST_DAILYSECURITYDB";
$login="root";
$passe="";

$pdo= new PDO("mysql: $host; port=3306; dbname=$base",$login,$passe);
$pdo->setattribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

/* INSERTION DANS LA BDD
$stmt=$pdo->prepare("INSERT INTO TEST_DAILYSECURITY VALUES (default,:login, :password)");

$stmt->bindParam(':login', $nom);
$stmt->bindParam(':password', $pass);

$nom="admin                                               x";
$pass="testpdo";

$stmt->execute();
echo "done";
*/


// SELECT

$query = $pdo->prepare("select login FROM test_dailysecurity");
$query->execute();

for($i=0; $row = $query->fetch(); $i++){
  echo $i." --".$row['login']."--<br/>";
}