crud php mysql Archives

This Tutorial helps to Create CRUD(Create, Read, Update and Delete) Operations using Mongo database and PHP. I have already shared a tutorial to Create Bootstrap Table Listing Using Mongo. I am using php7 with mongodb. I am extending the above tutorial and adding add, edit and delete functionality. I will restructure the code for this tutorial. The Mongo connection object will go into a separate file. I am assuming you have installed MongoDB into your machine, if not Please read this tuorial. We also need mongo libs driver for php, which helps to PHP for creating a connection with mongo and its operation. PHP CRUD Operation Using PHP Let us start how to perform CRUD (Create/Read/Update/Delete) operations in MongoDB. We will create the following files into this project. index.php: This file will responsible for the main application entry file and listing of data.connection.php: This file will have mongo DB connection information.add.php: This is a view file for add a record.edit.php: This is a view file for edit a record. How to Create Connection Mongo DB with PHP We will create connection.php file and added the below code into this file. $dbname; // select the collection $collection $db-&gt;movie; ?> We have passed dbname and mongo server hostname. HTML Table Listing with Actions Button I will modify index.php and added an action button for add/edit and delete record. we will include connection.php file into the top of index.php file - find(); ?> We have also fetched all data from the mongo database using cursor query and will use into table to display. Let's Create HTML action buttons into index.php file to add, edit and delete record - Add New Name Age Roll Number Action ">Edit " method"post"> Delete How To Add Record Using MongoDB and PHP We will add a new record using php. The record will insert into mongo database. Let's create add.php file - ", $message); ?> Add Employee " placeholder"Name"> " placeholder"Age"> " placeholder"Roll number"> Add Student In the above code, first we will display errors and success message. We have added add a record HTML view using bootstrap css classes. The Above HTML form will post data to the server using the HTTP Post method, We will get posted data into the same add.php page. The following code will add into the top of the add.php file. 'error', 'errors'&gt; , 'message' &gt; ''); $validate false; $post_data array(); if(isset($_POST)){ //check if form was submitted if(!empty($_POST)) { $post_data $_POST; } else { $message "Name is Empty"; $validate true; } if(!empty($_POST)) { $post_data $_POST; } else { $message "Age is Empty"; $validate true; } if(!empty($_POST)) { $post_data $_POST; } else { $message "Roll Number is Empty"; $validate true; } if(!$validate) { $collection-&gt;insert($post_data); $message 'SuccessFully! Created Record.'; $message 'success'; $_POST array(); } else { $message 'Validation Failed!'; } //$input //print_R($message);die;; //get input text //$message "Success! You entered: ".$input; } ?> The first line will have the mongo DB connection object and then the check method is POST or GET, if the method is GET then we will simply show the add a record view, When the form post the data then Method would be POST and validate posted data. We are displaying a message if the validation has failed, Otherwise inserting a new record into the mongo database. The mongo insert() method helps to add a new record into MongoDB collection. How To Edit A Record Using MongoDb and PHP Let's edit an existing record using PHP in the Mongo database. Created a edit.php file and added below HTML code. This will display the edit form to the end user to enable edit record functionality. ", $message); ?> Edit Employee "> " placeholder"Name"> " placeholder"Age"> " placeholder"Roll number"> Update Student We have added a div to display error and success message notifications. The next div have contained an edit form, we are using the bootstrap css framework to display the view file. We are using an HTTP POST method to post form data to the server. The following code will add to top of the edit.php file. 'error', 'errors'> , 'message' > ''); $validate false; if(!empty($_POST)) { $post_data $_POST; } else { $message "Name is Empty"; $validate true; } if(!empty($_POST)) { $post_data $_POST; } else { $message "Age is Empty"; $validate true; } if(!empty($_POST)) { $post_data $_POST; } else { $message "Roll Number is Empty"; $validate true; } if(!$validate) { $collection->update(array('_id' > new MongoId($_POST)), array('$set' > $post_data)); //$collection->insert($post_data); $message 'SuccessFully! Updated Record.'; $message 'success'; $post_data $collection->findOne(array('_id' > new MongoId($_GET))); } else { $message 'Validation Failed!'; } //$input //print_R($message);die;; //get input text //$message "Success! You entered: ".$input; } else { if(!empty($_GET)) { $post_data $collection->findOne(array('_id' > new MongoId($_GET))); } } ?> First, We have added the mongo connection file into here to access mongo object. The HTTP method help to identify whether the form data has been post or not - If the form data is not posted then we will show the edit form layout, if the form data is posted then we will process data validation. After successfully validating data, we are updating data into the mongo db. We are displaying a message if the validation has failed. We are inserting a new record into the mongo database when the validation passed. The mongo update() method helps to update existing records into the mongodb. How To Delete Record into MongoDb Using PHP I have already added the delete action button, Now we will add functionality to delete records from mongo database. Let's add the below code into the top of the index.php file - if ($_SERVER "POST" && isset($_POST)) { // The delete record if(isset($_GET)) $collection->remove(array( '_id' > new MongoInt32($_GET))); } Conclusion: Created MongoDB connection with PHP. We have also created Add, Edit and Delete CRUD operation using MongoDB and PHP. The mongo libs have many inbuilt methods to support daily uses MongoDB operation.

crud php mysql

CRUD Operations Using PHP and MongoDB

Laravel 8 CRUD Example with jQuery Datatable

Laravel CRUD Tutorial Using Resource Controller

Add, Edit and Delete Record Using Codeigniter and MySQL

Categories

crud php mysql

CRUD Operations Using PHP and MongoDB

Laravel 8 CRUD Example with jQuery Datatable

Laravel CRUD Tutorial Using Resource Controller

Add, Edit and Delete Record Using Codeigniter and MySQL

Categories

Headline