Guest User

Untitled

a guest
Jul 11th, 2018
40
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.03 KB | None | 0 0
  1. <?php
  2.     $nume = $_POST["nume"];
  3.     $medie = $_POST["medie"];
  4.     $bac = $_POST["bac"];
  5.     $materie = $_POST["materie"];
  6.     $data = $_POST["data"];
  7.     $alese = $_POST["alese"];
  8.        
  9.    
  10.  
  11.     echo $nume;
  12.     echo $medie;
  13.     echo $bac;
  14.     echo $materie;
  15.     echo $data;
  16.     echo $alese;
  17.    
  18.     $servername = "localhost";
  19.     $username = "root";
  20.     $password = "";
  21.     $dbname = "user";
  22.     $connection  = new mysqli($servername, $username, $password, $dbname);
  23.     if ($connection->connect_error) {
  24.         die("Connection failed: " . $connection->connect_error);
  25.     }
  26.  
  27.     // preluarea și securizarea parametrilor
  28.  
  29.     $sql = "INSERT INTO aplicatie  "
  30.                 . "VALUES (1, '$nume', $medie, $bac, '$materie', $data, '$alese')";
  31.                
  32.     echo $sql;
  33.  
  34.     $stmt = $connection->prepare($sql);
  35.     if($stmt === false) {
  36.         trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $connection->errno . ' ' . $connection->error, E_USER_ERROR);
  37.      
  38.     }
  39.  
  40.     $stmt->execute();
  41.  
  42. ?>
Add Comment
Please, Sign In to add comment