Please enable JavaScript.

Coggle requires JavaScript to display documents.

BD (connection, manpulation) - Coggle Diagram

- - - - [PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION, //erreur mode exeption
        
        PDO::ATTR_DEFAULT_FETCH_MODE=>PDO::FETCH_ASSOC]);
        
        message
- - - - create
        
        $query=$pdo->prepare(INSER INTO TABLE (nom,prenom) values (:nom,:prenom);
        
        $query->execute(['nom'=>"aziz",'prenom'=>'temimi'])
        
        catch
        
        $query->bindvalue(':nom','aziz')
        
        $query->execute()
        
        $query=$pdo->prepare(INSER INTO TABLE (nom,prenom) values (?,?);
        
        $nom='aziz'
        
        $query->bindparam(1,nom);
        
        $query->execute()
      - read
        
        $query=$pdo->prepare(SELECT * FROM table );
        
        $query->execute();
        
        $result=$query->fetchall();
        
        catch
        
        foreach($result as $row){echo 'row[nom] ' '.' row[prenom]' }
      - update
        
        $query=$pdo->prepare(update table SET nom=:nom ,prenom=:prenom where fff)
        
        $query->excute(['nom'=>'dos','prenom'=>'ff']);
      - delate
        
        $query=$pdo->prepare( DELATE FROM table where nom=:nom)
        
        $query->excute(['nom'=>'aziz' ])
        
        test // echo $query-rowCount()
        
        catch