1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| <?php
session_start();
class login extends PDO {
public $id_login;
public $login;
public $pwd;
public $connecte;
public $mail;
public $notif;
static public $DB_NAME = "---";
static public $HOST = "---";
static public $USER = "---";
static public $PASS = "---";
// le constructeur de login appelle le constructeur de PDO en lui passant ses paramètres
function __construct() {
parent::__construct('mysql:host=' .login::$HOST . ';dbname=' . login::$DB_NAME, login::$USER, login::$PASS);
}
public function test_connexion() {
$sql="CREATE TABLE espion (id_espion MEDIUMINT UNSIGNED AUTO_INCREMENT, espion VARCHAR(30) NOT NULL,PRIMARY KEY(id_espion));";
try{
$this->query($sql, PDO::FETCH_OBJ);
echo "envoi requete<br>";
}catch(PDOException $e){
echo "argggggggggggggg".$e->getMessage();
}
} |
Partager