Before you begin, make sure you have the following installed:
- PHP
- MySQL
- Web server (e.g., Apache)
- A web browser
-
Create a Database:
-
Open your MySQL database management tool (e.g., phpMyAdmin).
-
Create a new database named
crud. -
If you are using phpMyAdmin, follow these steps:
- Click on the "Databases" tab.
- Enter
crudin the "Database name" field. - Click the "Create" button.
-
-
Create a Table:
- Inside the
cruddatabase, create a table nameduserdetailsusing the following SQL query:
CREATE TABLE `userdetails` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `mobile` varchar(15) NOT NULL, `password` varchar(255) NOT NULL, PRIMARY KEY (`id`) );
- Inside the
-
Using a MySQL Database Management Tool (e.g., phpMyAdmin):
-
Open phpMyAdmin or any other MySQL database management tool you are using.
-
Select the database where you want to create the table (in this case,
crud). -
Navigate to the "SQL" tab or equivalent.
-
Copy and paste the provided SQL query into the input box.
-
Click the "Go" or "Execute" button to run the query.
Example:
CREATE TABLE `userdetails` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `mobile` varchar(15) NOT NULL, `password` varchar(255) NOT NULL, PRIMARY KEY (`id`) );
This will create the
userdetailstable with the specified structure in thecruddatabase. -
<?php
// Database connection parameters
$servername = "localhost";
$username = "root";
$password = "";
$database = "crud";
// Create a connection to the database
$conn = new mysqli($servername, $username, $password, $database);
// Check if the database connection is successful
if (!$conn) {
die("Connection Error". mysqli_error($conn));
}
// Check if the form is submitted using the POST method
if (isset($_POST["submit"])) {
// Retrieve user inputs from the form
$name = $_POST['name'];
$email = $_POST['email'];
$mobile = $_POST['mobile'];
$password = $_POST['password'];
// Validate if all fields are filled
if (empty($name) || empty($email) || empty($mobile) || empty($password)) {
echo "All fields are required";
} else {
// Construct SQL query to insert data into the 'userdetails' table
$sql = "INSERT INTO `userdetails` (`name`, `email`, `mobile`, `password`) VALUES ('$name', '$email', '$mobile', '$password')";
// Execute the SQL query
$result = mysqli_query($conn, $sql);
// Check if the query execution was successful
if ($result) {
echo "New record created successfully";
} else {
die(mysqli_error($conn));
}
}
}
// Close the database connection
$conn->close();
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>CRUD App using PHP MySQL</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-T3c6CoIi6uLrA9TneNEoa7RxnatzjcDSCmG1MXxSR1GAsXEV/Dwwykc2MPK8M2HN" crossorigin="anonymous">
</head>
<body>
<style>
html,
body {
background-color: gainsboro;
}
</style>
<div class="container py-5 px-5">
<div class="container text-center py-3">
<h2>CRUD OPERATIONS</h2>
</div>
<!-- Form with POST method to submit data to PHP -->
<form method="post">
<div class="mb-3">
<label for="name" class="form-label">Name</label>
<input type="name" class="form-control" name="name" id="name" placeholder="Enter Your Name">
</div>
<div class="mb-3">
<label for="email" class="form-label">Email address</label>
<!-- 'name' attribute is used to identify this input field in PHP -->
<input type="email" class="form-control" name="email" id="email" placeholder="Enter Your Email address" aria-describedby="emailHelp">
</div>
<div class="mb-3">
<label for="mobile" class="form-label">Mobile Number</label>
<input type="number" class="form-control" name="mobile" id="mobile" placeholder="Enter Your Mobile Number">
</div>
<div class="mb-3">
<label for="password" class="form-label">Password</label>
<input type="password" class="form-control" name="password" id="password" placeholder="Enter Your Password">
</div>
<button type="submit" name="submit" class="btn btn-primary">Submit</button>
</form>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-C6RzsynM9kWDrMNeT87bh95OGNyZPhcTNXj1NW7RuBCsyN/o0jlpcV8Qyq46cDfL" crossorigin="anonymous"></script>
</body>
</html>git checkout maingit checkout read-datagit checkout delete-datagit checkout update-datagit checkout crud-with-imagesUpload Img in DB and Display it Repo Link