Advertisement
Guest User

phpsqlinfo_addrow.php

a guest
Jun 2nd, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.20 KB | None | 0 0
  1. <?php
  2. require("phpsqlinfo_dbinfo.php");
  3.  
  4. // Gets data from URL parameters
  5. $name = $_GET['name'];
  6. $address = $_GET['address'];
  7. $lat = $_GET['lat'];
  8. $lng = $_GET['lng'];
  9. $type = $_GET['type'];
  10.  
  11. $username=" infodb-34e262";
  12. $password="EdsonMelo123";
  13. $database="infodb-34e262"
  14.    
  15. // Opens a connection to a MySQL server
  16. $connection=mysqli_connect ("shareddb1a.hosting.stackcp.net", $username, $password, $database);
  17.                              
  18. if (!$connection) {
  19.   die('Not connected : ' . mysqli_error());
  20. }
  21.  
  22. // Set the active MySQL database
  23. //$db_selected = mysqli_select_db($database, $connection);
  24. //if (!$db_selected) {
  25. //  die ('Can\'t use db : ' . mysqli_error());
  26. //}
  27.  
  28. // Insert new row with user data
  29. $query = sprintf("INSERT INTO markers" .
  30.          " (id, name, address, lat, lng, type ) " .
  31.          " VALUES (NULL, '$name', '$address', '$lat', '$lng', '$type');",
  32.          mysqli_real_escape_string($name),
  33.          mysqli_real_escape_string($address),
  34.          mysqli_real_escape_string($lat),
  35.          mysqli_real_escape_string($lng),
  36.          mysqli_real_escape_string($type));
  37.  
  38. $result = mysqli_query($query);
  39.  
  40. if (!$result) {
  41.   die('Invalid query: ' . mysqli_error());
  42. }
  43.  
  44. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement