Advertisement
Guest User

rudy69

a guest
Dec 7th, 2016
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. <?php
  2. $serwername="localhost";
  3. $username="root";
  4. $password="";
  5. $dbname="video";
  6.  
  7. $conn=mysqli_connect($serwername,$username,$password,$dbname );
  8. if($conn){
  9. echo "poloczona z paza <br>";
  10.  
  11. $wiersze=file('klienci.txt');
  12. $n=count($wiersze);
  13. for($i=0; $i<$n; $i++){
  14.  
  15.  
  16. $tab=explode("\t",$wiersze[$i]);
  17.  
  18. for($j=0; $j<3; $j++){
  19. $tab[$j]=trim($tab[$j]);
  20. }
  21.  
  22. $sql = "INSERT INTO klienci (`Id`,`Pesel`,`Imie`,`Nazwisko`) VALUES (NULL,'".$tab[0]."', '".$tab[1]."', '".$tab[2]."');";
  23. mysqli_query($conn, $sql);
  24.  
  25. }
  26.  
  27.  
  28.  
  29.  
  30.  
  31.  
  32. }
  33. else {
  34. die ("brak poloczenia".mysqli_connect_error());
  35. }
  36.  
  37.  
  38. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement