Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require("phpsqlinfo_dbinfo.php");
- // Gets data from URL parameters
- $name = $_GET['name'];
- $address = $_GET['address'];
- $lat = $_GET['lat'];
- $lng = $_GET['lng'];
- $type = $_GET['type'];
- $username=" infodb-34e262";
- $password="EdsonMelo123";
- $database="infodb-34e262"
- // Opens a connection to a MySQL server
- $connection=mysqli_connect ("shareddb1a.hosting.stackcp.net", $username, $password, $database);
- if (!$connection) {
- die('Not connected : ' . mysqli_error());
- }
- // Set the active MySQL database
- //$db_selected = mysqli_select_db($database, $connection);
- //if (!$db_selected) {
- // die ('Can\'t use db : ' . mysqli_error());
- //}
- // Insert new row with user data
- $query = sprintf("INSERT INTO markers" .
- " (id, name, address, lat, lng, type ) " .
- " VALUES (NULL, '$name', '$address', '$lat', '$lng', '$type');",
- mysqli_real_escape_string($name),
- mysqli_real_escape_string($address),
- mysqli_real_escape_string($lat),
- mysqli_real_escape_string($lng),
- mysqli_real_escape_string($type));
- $result = mysqli_query($query);
- if (!$result) {
- die('Invalid query: ' . mysqli_error());
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement