- Create DB and Table
- Create a Form
- Create connect.php File Create as Common File
- Insert Option
- Update
- Delete
Create DB and Table
- phpmyadmin using crate DB which Like your wish
- create table, Number fields depends your requirement
Create a Form
- Whenever form creates Must enter 'action', 'name', 'method'
Create connection DB
-
Object Oriented DB Connection
First set, Servername, Username, Password, DBname
-
Example
Note - if Your Using Localhost above the example use. Insert Opeartion
-
// Escape user inputs for security
$first_name = mysqli_real_escape_string($link, $_REQUEST['firstname']); $last_name = mysqli_real_escape_string($link, $_REQUEST['lastname']); $email = mysqli_real_escape_string($link, $_REQUEST['email']);
// attempt insert query execution $sql = "INSERT INTO phpcurdinsert (firstname, lastname, email) VALUES ('$first_name', '$last_name', '$email')";