Here's a sample PHP code that will allow a user to enter latitude and longitude in a form
Sure, here's a sample PHP code that will allow a user to enter latitude and longitude in a form, and save it to a database table named "efh54j_service_locations". This code assumes that you have already set up a MySQL database and table with appropriate fields.
<?php
// Connect to MySQL database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
// Check if form is submitted
if (isset($_POST['submit'])) {
// Get latitude and longitude values
$location = $_POST['location'];
// Separate latitude and longitude values
list($latitude, $longitude) = explode(',', $location);
// Prepare SQL query
$sql = "INSERT INTO efh54j_service_locations (latitude, longitude) VALUES ('$latitude', '$longitude')";
// Execute query
if (mysqli_query($conn, $sql)) {
echo "Location saved successfully!";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}
// Close MySQL connection
mysqli_close($conn);
?>
<!-- HTML form to enter location data -->
<form method="post">
<label for="location">Enter location (latitude, longitude):</label><br>
<input type="text" name="location" required><br>
<input type="submit" name="submit" value="Save location">
</form>
Note that this code is only a sample and may require modifications to suit your specific needs. Additionally, make sure to validate user input to prevent SQL injection attacks.
Sure, here's an example SQL code to create a MySQL database table named "e7u3qf_service_locations" with columns for latitude and longitude:
CREATE TABLE efh54j_service_locations (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
latitude DECIMAL(10, 8) NOT NULL,
longitude DECIMAL(11, 8) NOT NULL
);
This will create a table with three columns: "id" (an auto-incremented primary key), "latitude" (a decimal number with 10 digits, including 8 digits after the decimal point), and "longitude" (a decimal number with 11 digits, including 8 digits after the decimal point).
To insert values into this table, you can use the following SQL code:
INSERT INTO efh54j_service_locations (latitude, longitude) VALUES
(37.7749, -122.4194),
(40.7128, -74.0060),
(51.5074, -0.1278),
(35.6895, 139.6917);