Advertisement
sdee3

PVA - Insert u MySQL tabelu

Dec 7th, 2016
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.77 KB | None | 0 0
  1. <?php
  2.  
  3.     $serverName = "localhost";
  4.     $user = "root";
  5.     $pass = "";
  6.     $dbName = "baza2";
  7.  
  8.     $conn = mysqli_connect($serverName,$user,$pass,$dbName);
  9.  
  10.     if(!$conn){
  11.         die("Neuspesna konekcija.");
  12.     }
  13.  
  14.     $ime = mysqli_real_escape_string($conn, $_POST["ime"]);
  15.     $prezime = mysqli_real_escape_string($conn, $_POST["prezime"]);
  16.     $fakultet = mysqli_real_escape_string($conn, $_POST["fakultet"]);
  17.     $indeks = mysqli_real_escape_string($conn, $_POST["indeks"]);
  18.  
  19.  
  20.     $sql = "INSERT INTO student(ime,prezime,fakultet,indeks) VALUES ('$ime','$prezime','$fakultet',$indeks)";
  21.  
  22.     if(mysqli_query($conn, $sql)){
  23.         echo "Uspesno dodavanje!";
  24.     }else{
  25.         echo "Error: ".$sql."<br>".mysqli_error($conn);
  26.     }
  27.  
  28.     mysqli_close($conn);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement