# Workflow
First, let's create the database and table to store the contact information. We will use a database called "contacts" and a table called "contact\_list". The table will have two columns: "name" and "phone".
```sql
CREATE DATABASE contacts;
USE contacts;
CREATE TABLE contact_list (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
phone VARCHAR(20) NOT NULL
);
```
Next, let's create the HTML form to add a new contact. We'll create a file called "create.php".
```php
Add Contact
Add Contact
show Contact
```
Now, let's create the PHP script to process the form and insert the new contact into the database. We'll create a file called "process.php".
```php
" . mysqli_error($conn);
}
mysqli_close($conn);
// redirect to the show page
header('Location: show.php');
?>
```
Next, let's create the "show\.php" page to display the list of contacts.
```php
Contact List
Add Contact
```
This code fetches all the contacts from the database and displays them in a table with columns for name, contact number, edit button and delete button for each contact. The edit and delete buttons are links that redirect the user to the update\_form.php and delete.php pages respectively, with the contact's ID passed as a parameter in the URL.
Next, let's create code for the update functionality
```php
0) {
$row = mysqli_fetch_assoc($result);
$name = $row['name'];
$phone = $row['phone'];
} else {
echo "No record found";
exit;
}
} else {
echo "Invalid request";
exit;
}
if(isset($_POST['submit'])) {
$name = $_POST['name'];
$phone = $_POST['phone'];
$sql = "UPDATE contact_list SET name='$name', phone='$phone' WHERE id=$id";
if(mysqli_query($conn, $sql)) {
header("Location: show.php");
exit;
} else {
echo "Error updating record: " . mysqli_error($conn);
}
}
mysqli_close($conn);
?>
Update Contact
Update Contact
Back to Contact List
```
And finally let's code for deleting a contact
```php
```
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://dhrubo.gitbook.io/programming-with-js/contact-app-project-2/workflow.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.