Please enable JavaScript.
Coggle requires JavaScript to display documents.
BD (connection, manpulation) - Coggle Diagram
BD
connection
try{]
$con=new PDO('mysql:host=$host,dbname=$dbnmae",username,password
[PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION, //erreur mode exeption
-
-
-
manpulation
include(message) /include_once // require // require_once'nom du fichier'; #
CRUD
try{}
create
$query=$pdo->prepare(INSER INTO TABLE (nom,prenom) values (:nom,:prenom);
$query->execute(['nom'=>"aziz",'prenom'=>'temimi'])
-
$query->bindvalue(':nom','aziz')
-
$query=$pdo->prepare(INSER INTO TABLE (nom,prenom) values (?,?);
$nom='aziz'
$query->bindparam(1,nom);
-
-
update
$query=$pdo->prepare(update table SET nom=:nom ,prenom=:prenom where fff)
$query->excute(['nom'=>'dos','prenom'=>'ff']);
-