Advertisement
Guest User

Untitled

a guest
Oct 18th, 2018
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. <?php header('Access-Control-Allow-Origin: *');
  2. session_start();
  3. $host="dikke-onzin.nl.mysql"; // Host name
  4. $username="dikke_onzin_nl_janlinders_fil078"; // Mysql username
  5. $password="13706jl"; // Mysql password
  6. $db_name="dikke_onzin_nl_janlinders_fil078"; // Database name
  7. $tbl_name="namen_personeel"; // Table name
  8.  
  9.  
  10. $con=mysqli_connect("$host","$username","$password","$db_name");
  11.  
  12. $username = $_GET['filiaal'];
  13. //$password = $_GET['fpass'];
  14.  
  15. // Check connection
  16. if (mysqli_connect_errno())
  17. {
  18. echo "Failed to connect to MySQL: " . mysqli_connect_error();
  19. }
  20. $qz = "SELECT naam FROM $tbl_name" ;
  21. $qz = str_replace("\'","",$qz);
  22. $result = mysqli_query($con,$qz);
  23. while($row = mysqli_fetch_array($result))
  24. {
  25. //echo $row['id'];
  26. echo $row['naam'] . "|";
  27. }
  28. mysqli_close($con);
  29. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement