Insert Data in PhP

# Insert Data in PHP Ajax MySQL By Using Bootstrap Modal - Link: https://technotaught.com/insert-data-in-php-ajax-mysql-by-using-bootstrap-modal/ - Published: 2021-01-03T04:00:00+05:30 - Author: Ashishkumar Vishwakarma In this tutorial, we will Insert and view data in modal using PHP Ajax MySQL table along with Javascript/ Sweet alert through Bootstrap Modal by using PHP script with Ajax jquery without page refresh. ## Insert Data in PHP Ajax MySQL By Using Bootstrap Modal Bootstrap Modal is a pop-up/ dialog-box that appeared on the web page. Bootstrap Modal is used to display dynamic data from the database to pop-up/ dialog box, we use Bootstrap Modal for inserting or updating database data also. By using this plugin we can insert or fetch data without open a new page, but we can do on-page without opening the new web page. This is the latest concept of inserting data through Bootstrap Modal by using the Ajax request method. It sends a request to PHP script and PHP script has clean data and inserts into MySQL table and after inserting data successfully then after we want to show an alert message, in PHP script we have to fetch data from MySQL table and send back data to ajax request method in HTML form. And by using jquery code we have to display that HTML data on the web page. This process has done without a page refresh event. ![](https://technotaught.com/wp-content/uploads/2021/01/Insert-Data-Through-Bootstrap- Modal-by-using-Ajax-PHP.png) ### File need Now, we will create five files here for the login system. 1. **db.php –** Connection file contains the connection code for database connectivity 2. **index**.**php –** Contain all html, php, ajax code 3. **insert.php –** php code of insert and view data. ![](https://technotaught.com/wp-content/uploads/2021/01/Insert-in-php-1024x588.png) ![](https://technotaught.com/wp-content/uploads/2021/01/Insert-in-php-view.png) ### Source Code #### Creating the DB File After creating the table, we need to create a PHP script in order to connect to the MySQL database server. Let’s create a file named “db.php” and put the following code inside it ```php ``` #### index.php ```php Insert Data in PhP

Technotaught - Insert Data Through Bootstrap Modal by using Ajax PHP

Employee Name	View
	" class="btn btn-info btn-xs view_data" />

``` #### insert.php File contain php code that insert and view data. ```php 1)); } else{ echo json_encode(array("status"=>2)); } } // ################################################################## // View Data if(isset($_POST["employee_id"])) { $output = ''; $query = "SELECT * FROM files WHERE id = '".$_POST["employee_id"]."'"; $result = mysqli_query($con, $query); $output .= '

'; while($row = mysqli_fetch_array($result)) { $output .= ' '; } $output .= '

Name	'.$row["title"].'
Address	'.$row["description"].'
Address	'.$row["uploaded_on"].'

'; echo $output; } ?> ``` #### Creating the Database Table Execute the following SQL query to create the _users _table in your MySQL database. Database name should be **test**. ```language-sql - -- Database `test` -- Table `files` -- CREATE TABLE `files` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `uploaded_on` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `files` -- INSERT INTO `files` (`id`, `title`, `description`, `uploaded_on`) VALUES (1, 'hii', 'how ar u', '2021-01-02 15:38:32'), (2, 'hii', 'bye', '2021-01-02 15:41:29'), (3, 'title', 'description', '2021-01-02 15:52:42'), (4, 'title', 'description', '2021-01-02 15:53:03'), (5, 'no', 'yes', '2021-01-02 15:55:11'), (6, 'test', 'how are you guys', '2021-01-02 20:28:49'); ``` ### Share this: * [ X ](https://technotaught.com/insert-data-in-php-ajax-mysql-by-using-bootstrap-modal/?share=twitter) * [ Facebook ](https://technotaught.com/insert-data-in-php-ajax-mysql-by-using-bootstrap-modal/?share=facebook) * [More](https://technotaught.com/insert-data-in-php-ajax-mysql-by-using-bootstrap-modal/#) * [ WhatsApp ](https://technotaught.com/insert-data-in-php-ajax-mysql-by-using-bootstrap-modal/?share=jetpack-whatsapp) * [ LinkedIn ](https://technotaught.com/insert-data-in-php-ajax-mysql-by-using-bootstrap-modal/?share=linkedin) * [ Email ](https://technotaught.com/insert-data-in-php-ajax-mysql-by-using-bootstrap-modal/?subject=%5BShared%20Post%5D%20Insert%20Data%20in%20PHP%20Ajax%20MySQL%20By%20Using%20Bootstrap%20Modal&body=https%3A%2F%2Ftechnotaught.com%2Finsert-data-in-php-ajax-mysql-by-using-bootstrap-modal%2F&share=email) * [ Reddit ](https://technotaught.com/insert-data-in-php-ajax-mysql-by-using-bootstrap-modal/?share=reddit) * [ Tumblr ](https://technotaught.com/insert-data-in-php-ajax-mysql-by-using-bootstrap-modal/?share=tumblr) * [ Pinterest ](https://technotaught.com/insert-data-in-php-ajax-mysql-by-using-bootstrap-modal/?share=pinterest) * [ Telegram ](https://technotaught.com/insert-data-in-php-ajax-mysql-by-using-bootstrap-modal/?share=telegram) * [ Print ](https://technotaught.com/insert-data-in-php-ajax-mysql-by-using-bootstrap-modal/#print?share=print) ### _Related_

Technotaught - Insert Data Through Bootstrap Modal by using Ajax PHP

Employee Details