How to insert data in a database with PHP and MySQL
To insert data into a MySQL database using PHP, you can use the following syntax:
$servername = "localhost"; $username = "root"; $password = ""; $dbname = "mydatabase"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // Insert data $sql = "INSERT INTO users (name, email, age) VALUES ('John Doe', 'john.doe@email.com', 30)"; if ($conn->query($sql) === TRUE) { echo "Data inserted successfully"; } else { echo "Error: " . $sql . " " . $conn->error; } // Close connection $conn->close();
In the above example, we first create a connection to the MySQL database using the mysqli() function. We then check if the connection was successful, and if so, we use the INSERT INTO query to insert data into the “users” table.
Note that we use single quotes to enclose the data values we want to insert, and we separate them using commas. Also, we wrap the query within an if statement to check if the query was executed successfully, and we output an error message if it failed.
Here is another example that inserts data dynamically using a form:
$servername = "localhost"; $username = "root"; $password = ""; $dbname = "mydatabase"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // Insert data if (isset($_POST['name']) && isset($_POST['email']) && isset($_POST['age'])) { $name = $_POST['name']; $email = $_POST['email']; $age = $_POST['age']; $sql = "INSERT INTO users (name, email, age) VALUES ('$name', '$email', '$age')"; if ($conn->query($sql) === TRUE) { echo "Data inserted successfully"; } else { echo "Error: " . $sql . " " . $conn->error; } } // Close connection $conn->close();
In this example, we first check if the form fields are set using the isset() function. We then retrieve the values entered by the user and insert them into the “users” table using the INSERT INTO query.
Here is a helpful resource for learning more about SQL queries: https://www.w3schools.com/sql/.
Written by: Michael from Beginnrtuts.com 13-06-2023 Written in: PHP tutorials
This tutorial was really helpful! I was struggling with inserting data into a database using PHP and MySQL, but this step-by-step guide made it so easy to understand . The explanations were clear, and the code examples were spot-on. Now I feel confident in my ability to insert data successfully. Thank you for sharing this valuable resource!
This tutorial really helped me understand how to insert data into a database using PHP and MySQL . I was struggling with this concept before, but the step-by-step explanation and code examples made it much easier to grasp. Now I feel more confident in implementing this in my own projects. Thank you for providing such clear and concise instructions!
This tutorial was super helpful in teaching me how to insert data into a database using PHP and MySQL! I had been struggling with this concept, but the step-by-step instructions, along with the clear code examples, made it much easier to understand . Now, I feel confident in my ability to incorporate databases into my future web development projects. Thank you!
Great tutorial! I was struggling to figure out how to insert data into a database using PHP and MySQL, but your step-by-step instructions made it crystal clear . The code snippets were incredibly helpful, especially for a beginner like me. Can’t wait to try out this method in my own projects. Thanks a ton for sharing this valuable knowledge!
This tutorial was super helpful! I was struggling with inserting data into my database using PHP and MySQL, but now I feel much more confident thanks to this step-by-step guide . Thank you!
This article waѕ ѵery helрful for me . I waѕ able tо learn hоw tо insert data іn a database ѡith PHP and MySQL. Ƭhe explanation waѕ clear and easy tо follow. Thank үоu for sharing thiѕ helpful information!