PHP, MySql, Jquery, AngularJS and Ajax Tutorial

Thursday, 8 December 2016

This is one more post on Codeigniter Ajax Crud using DataTables, In this part we will learn how to update or edit Mysql table data in Codeigniter Framework by using Ajax method and load data in DataTables Jquery plugin without page refresh. In previous part we have already discussing how to insert or add mysql table data in Codeigniter Framework by using Ajax.

In this we will see one more CRUD operation like updating or editing of data on a single page without page refresh because we have use Ajax method for update of data in Codeigniter Application. In this part we will edit data step by step. We have already load data with update and delete button link in DataTables.

When we have click on update button then we have fetch particular data and load that data under Bootstrap Modals form and under that form we can change that data and then after we can update data. So, In this part we will update data in Codeigniter web application by using Ajax with Bootstrap Modals and DataTables.

For making this type of crud system by using Ajax request in Codeigniter. In this system we can update data with image upload in Codeingniter with Ajax. So we can edit or update data with image upload by using Bootstrap Modals and DataTables in Codeigniter by using Ajax method without refreshing of page. This is the single page crud application in which we can update or edit data without going to other page. So friends if you like this video tutorial, please share this video with your friends or even you can also share video tutorial on social media also.

Wednesday, 7 December 2016

In this post we will discussing on how can we insert data using Ajax in Codeigniter. This is one more video on Codeigniter ajax crud opearation with DataTables. In previous we have seen how can we load into DataTables by using Ajax Server side processing in Codeigniter Framework. But In this part we will Insert or Add data into Mysql database table in Codeigniter Application by using Ajax. So we can Insert data into database without page refresh. For Inserting or Adding data we have use Bootstrap Modals, we will implement form under Bootstrap Modals and this modal will be initialize by clicking button and then after we can fill form data and insert data into database by using Ajax request. After inserting or adding data into table then after we will update data of DataTables. So we will insert data using Ajax request in Codeigniter application and display that data on data table without page refresh.

You have already know how can we use Ajax for insert data in simple php script but in Codeigniter framework we have to follow the rules for Modal view controller pattern. Here according to modal view controller pattern, Ajax will send request for Insert data from view to controller and controller will send request for insert data to modal and modal will insert data and again send request to controller and controller again send request to view page and on that page we have display updated data in Data tables table by using DataTables reload method. We have use new form data object for sending form data to server in Ajax request.

Tuesday, 6 December 2016

From this tutorial we have started learning one new topics in Codeigniter tutorial. In this topics we will discuss how can we make crud system by using Ajax with Codeigniter framework. In this system we will use DataTables Jquery plugin for display data in tabular format and we will also use Bootstrap modals for inserting and updating data. Here we will implement DataTables server side processing by using Ajax. This is the first part in which we will fetch data from Mysql table by using Ajax in Codeigniter Application and then after we will displaying that data in on web page by using DataTables jquery plugin with server side processing. In server side processing we have to write query for search, order and pagination at server side. This all things we will learn in this part. We have make simple query for all different condition like searching, ordering or even pagination and this query has been called by Ajax in codeigniter framework. So we can smoothly search table, can see data in different order or pagination which has been handle by Ajax server side processing in data tables. We can perform different operation in data table by using Ajax in Codeigniter application.

Friday, 2 December 2016

In this post we are going to learn how to export excel file and insert that excel file data into mysql data by using PHP with Ajax. In this example we will export excel file data into mysql database without page refresh this is because we have use ajax request with jquery for upload excel file in php script. For fetch data from excel file we have use PHPExcel library, by using this PHPExcel library we can fetch data from excel and we can use that data into php script. PHPExcel library is used for read, write or create excel file in php script. If you want to fetch data from any excel document to php then you can use this PHPExcel library. We have use ajax request to upload upload excel file and then after by using this PHPExcel library we have use that excel data in php script. So we have make simple data export system, in this system you can export excel data into mysql database without page refresh. This is because we have use ajax method for upload excel file to sever. For exporting excel data we have use PHPExcel library. By using this library we can smoothly export large amount of excel data to database. This system is very important if you are working on any enterprise level application. In that application you have large amount of data in excel file and you want to export that to mysql database server. Then at that time this type of system is very important. In this we have use ajax method so it will export data to server without page refresh. That means it will export data to server fast as compare to simple php script.

Wednesday, 30 November 2016

Part 1 - Select or Fetch Data by using Stored Procedure in PHP with Ajax JQuery

Part 2 - Insert or Add Data by using Stored Procedure in PHP with Ajax JQuery

Part 3 - Update or Edit Data by using Stored Procedure in PHP with Ajax JQuery

Part 4 - Delete or Remove Data by using Stored Procedure in PHP with Ajax JQuery

If you are looking for tutorial on Stored Procedure for Crud operation in PHP with Ajax Jquery then we are going to discuss one more advance topic in web development. In this tutorial we will discuss how can we use store procedure with Ajax and Jquery for Insert Update Delete and fetch data from Mysql table in php script. In this tutorial we will make crud operation in php with ajax. For making crud operation we will use stored procedure for making crud operation in php with Ajax. In this crud operation we have use Ajax with php so all operation will be done without page refresh. Here crud means create, read, update and delete of database table data. Insert, Update, and Delete features is almost use in every website in PHP with Ajax. In this script, we will fetch users data from database and display that user data on web page with update link and delete link. By this type of link we can update and delete data from database. This operation has been done without page refresh event. For this type of operation here we will use stored procedure. First of all what is stored procedure. Stored procedure is a collection of query. It is also called pre compiled sql query. Stored Procedure is mainly used for enterprise level application. If you are working on any large data project then you can use stored procedure for Insert Update Delete of data operation. So here we will stored procedure from crud operation in php with Ajax.

This is our complete system in which we can fetch, insert, edit and delete data from database by using stored procedure in php script with Ajax request. Insert, Fetch, Update and delete records from database by using php is a very simple feature for new programmer. But here is something complex task, In this task first of all we have use stored procedure for crud operation and second is we have use ajax method with stored procedure for crud operation. So it is something new feature, if you have working on very large data application then you can use stored procedure and with Ajax request. You application working speed will be increase than normal php application. This is because stored procedure execute query at database server not on php script. So your application will execute faster than normal php application. Insert Update delete and fetch data is the normal operation in any web application. So if this operation perform fast then your application will run fast. So for execute this basic operation fast, then you can use stored procedure in your application. Mainly stored procedure are stored in your data base and it will execute from database so it will reduce execution load on your php page. So this way we can increase execution speed of any web application by using stored procedure in php script with Ajax method.

Friday, 25 November 2016

This one more tutorial on how to use Bootstrap Modal in Web Development. In this post we will use Bootstrap Modal for upload multiple images on folder by using PHP script with Ajax Jquery without refreshing of page. In this example we will make system for uploading one or more than one image to the specified path. Here we will use Bootstrap Modal for selecting multiple images. On web page we will put simple button and when we have click on that button then after modal will popup on web page and In modal we will put input type file tag and from that tag we can select multiple images for upload. For uploading images to specified path we have use php script for uploading multiple images to specified path as back end by called by Ajax request. For this things we have create one button and then after we have create modal. By clicking on button we can pop up modal on web page. From this modal we can select multiple file and when we have select file then at that time jquery code has been execute and form has been submitted. When form submitted after we have create ajax request and by using form data object we have send selected file data with ajax request to the php script and by php script we have upload multiple images to the folder. After uploading image we have fetch all images from folder by using glob() function and then after we have display images on web page.

Thursday, 24 November 2016

This our one more tutorial in Codeigniter. In this tutorial we will discussing on how can we check email is available for registration or not by using Ajax with Jquery in Codeigniter framework. In most of the website registration we have use email for identify for login into system, then at that time we want to check particular email is already register into our system or not. So it is very important task to check email is already register or not at the time of registration. So In this video we have seen how can we validate email already registered or not in codeigniter application by using Ajax with Jquery. Here we have simple load register page from controller and then after on that view page we have write jquery code on textbox change event. So when we have enter email and go to password field then jquery code execute and in that code we have make ajax request and by using we have send request to controller and in controller first we have check email is proper or not if email is proper then it again check email is available in database or not so it go to model and in it will check email register or not and send result to controller and controller send result to view page. So This way whole cycle of codeigniter framework will run for checking email register or not by using Ajax with Jquery.