CRUD-App-using-PHP-MySQL

Live Preview - Click to Open

Preview

Before you begin, make sure you have the following installed:

PHP
MySQL
Web server (e.g., Apache)
A web browser

Setup Database

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 crud in the "Database name" field.
  - Click the "Create" button.

Create a Table:

Inside the crud database, create a table named userdetails using 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`)
);

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 userdetails table with the specified structure in the crud database.

<?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 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>  <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>

CRUD-App-using-PHP-MySQL

Live repository statistics

Healthy signals

README preview

CRUD-App-using-PHP-MySQL

Live Preview - Click to Open

Setup Database

Data Insertion

Checkout More Branches for Fetching Data, Editing Data, and Deleting Data from Database.

Insert Data

Fetch Data

Delete Data

Update Data

Crud Operations with Images

More