Please enable JavaScript.

Coggle requires JavaScript to display documents.

PHP, try{.................................................................…

- - - - Try exiption
      - Other rows
        
        // insert another row
        $matricule = 11009;
        $nomprenom = "SALAMI Ihssane";
        $dt = mktime(0, 0, 0, 11, 15, 2000);
        $daten = date("y-m-d", $dt);
        $stmt->execute();
      - Other rows
        
        // insert another row
        $matricule = 11110;
        $nomprenom = "ZIYADI Israe";
        $dt = date_create("1990-7-8");
        $daten = date_format($dt, "y-m-d");
        $stmt->execute();
      - Insert rows
        
        // insert a row
        // insert a row
        $nomprenom = "SKOURI Salim";
        $dt = new DateTime("1980-4-5");
        $daten = date_format($dt, "y-m-d") $stmt->execute();
      - extracting
        
        //extracting
        $stmt = $conn->prepare("SELECT * FROM employe where left(nomComplet,1) = ? and year(daten) > ?");
        $stmt->execute(["Z", 2000]);
        $emps = $stmt->fetchAll();
        echo "emps whose names starts with 'Z' and year of birth greater than 2000 : \n";
        foreach ($emps as $e) {
        echo "matricule : " . $e['matricule'] . ", nom complet : " . $e['nomComplet'] . ", date de naissance : " . $e['daten']; }
      - Insert-repare sql and bind parameters
        
        repare
        
        // prepare sql and bind parameters
        
        $stmt->bindParam(':mat', $matricule);
        
        $stmt->bindParam(':nom', $nomprenom);
        
        $stmt->bindParam(':dtn', $daten);
        
        $stmt = $conn->prepare("INSERT INTO employe (matricule, nomComplet, daten) VALUES (:mat, :nom, :dtn)");
  - - - $servername = "localhost"; $username = "root"; $password = ""; $conn = new PDO("mysql:host=$servername;dbname=mysql", $username,$password);
    - - $stmt = $conn->prepare("SELECT * FROM MyGuests"); $stmt->execute();
    - - FIRST → 1ère ligne
        
        $guest = $stmt->fetch(PDO::FETCH_ORI_FIRST); echo "first : \n";
      - NEXT → ligne suivante
        
        $guest = $stmt->fetch(PDO::FETCH_ORI_NEXT); echo "second : \n";
      - PRIOR → ligne précédente
        
        $guest = $stmt->fetch(PDO::FETCH_ORI_PRIOR); echo "previous : \n";
      - LAST → dernière ligne
        
        $guest = $stmt->fetch(PDO::FETCH_ORI_LAST); echo "last : \n";
    - - echo "id : " . $guest['id'] . ", first name : " . $guest['firstname'] . ", last name : " . $guest['lastname'] . "\n";
  - - - Connexion a la base de donnees
        
        Utilisation de PDO pour la connexion
        serveur: localhost
        utilisateur: root
        mot de passe : 111
        Base de données : bd_employes**
      - Exécution de requète SQL
        
        Exécuter une requéte pour selectionner tous les employés
      - Affichage des résultats
        
        Afficher la liste des employés
      - Gestion des erreurs
        
        PDO::ERRMODE_EXCEPTIO
        pour capturer les erreurs vla les excéptions.
        Si une erreur su produit pendant la connexion ou l'exécution, une exception sera lancée et le message d'erreur sera affichhé
  - - - Create table
        
        Inser des donners
        
        extraire tous les enregistrements
        
        update des donners
        
        $id_to_update = 11; $sql = "UPDATE MyGuests SET email='newEmail@gmail.com' WHERE id = " .$id_to_update; $conn->exec($sql);
        
        Supprimer des donners
        
        $id_to_delete = 10; $sql = "DELETE FROM MyGuests WHERE id = " . $id_to_delete; $conn->exec($sql);
        
        $stmt = $conn->prepare("SELECT * FROM MyGuests"); $stmt->execute(); $guests = $stmt->fetchAll(); echo "all records : \n"; foreach ($guests as $guest) { echo "id : " $guest['id'] . ", first name : " . $guest['firstname'] . ", last name : " . $guest['lastname'] . "\n";}
        
        $sql = "INSERT INTO MyGuests (firstname, lastname, email) VALUES ('farid', 'SADIKI', 'farid.sadiki@gmail.com')"; $conn->exec($sql);
        
        $sql = "CREATE TABLE if not exists MyGuests (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, email VARCHAR(50))"; $conn->exec($sql);
      - $sql = "CREATE DATABASE if not exists siteDB"; $conn->exec($sql); $sql = "use siteDB;"; $conn->exec($sql);