How can PHP developers efficiently store and retrieve data from a MySQL database using form fields?
To efficiently store and retrieve data from a MySQL database using form fields in PHP, developers can utilize the $_POST superglobal array to capture form field values and then use MySQL queries to insert or retrieve data from the database.
// Assuming a form with input fields named 'name' and 'email'
$name = $_POST['name'];
$email = $_POST['email'];
// Connect to MySQL database
$connection = mysqli_connect('localhost', 'username', 'password', 'database_name');
// Insert data into database
$insert_query = "INSERT INTO users (name, email) VALUES ('$name', '$email')";
mysqli_query($connection, $insert_query);
// Retrieve data from database
$select_query = "SELECT * FROM users";
$result = mysqli_query($connection, $select_query);
// Display retrieved data
while ($row = mysqli_fetch_assoc($result)) {
echo "Name: " . $row['name'] . ", Email: " . $row['email'] . "<br>";
}
// Close database connection
mysqli_close($connection);
Related questions
-
global variables PHP scripts potential pitfalls
-
include require errors
-
HTML output PHP performance optimization