Grid Control for JavaScript in PHP | Syncfusion Blogs
Live Chat Icon For mobile
Live Chat Icon
Popular Categories.NET  (180).NET Core  (28).NET MAUI  (224)Angular  (113)ASP.NET  (49)ASP.NET Core  (81)ASP.NET MVC  (87)Azure  (41)Black Friday Deal  (1)Blazor  (234)BoldSign  (14)DocIO  (24)Essential JS 2  (110)Essential Studio  (199)File Formats  (72)Flutter  (135)JavaScript  (226)Microsoft  (121)PDF  (83)Python  (1)React  (105)Streamlit  (1)Succinctly series  (131)Syncfusion  (960)TypeScript  (33)Uno Platform  (3)UWP  (3)Vue  (46)Webinar  (53)Windows Forms  (59)WinUI  (72)WPF  (162)Xamarin  (159)XlsIO  (38)Other CategoriesBarcode  (5)BI  (29)Bold BI  (8)Bold Reports  (2)Build conference  (10)Business intelligence  (55)Button  (4)C#  (163)Chart  (145)Chart of the week  (57)Cloud  (15)Company  (440)Dashboard  (8)Data Science  (3)Data Validation  (8)DataGrid  (73)Development  (676)Doc  (7)DockingManager  (1)eBook  (99)Enterprise  (22)Entity Framework  (7)Essential Tools  (13)Excel  (43)Extensions  (23)File Manager  (7)Gantt  (20)Gauge  (12)Git  (5)Grid  (31)HTML  (13)Installer  (2)Knockout  (2)Language  (1)LINQPad  (1)Linux  (2)M-Commerce  (1)Metro Studio  (11)Mobile  (519)Mobile MVC  (9)OLAP server  (2)Open source  (1)Orubase  (12)Partners  (21)PDF viewer  (45)Performance  (13)PHP  (2)PivotGrid  (5)Predictive Analytics  (6)Report Server  (3)Reporting  (8)Reporting / Back Office  (9)Rich Text Editor  (12)Road Map  (12)Scheduler  (54)Security  (5)SfDataGrid  (9)Silverlight  (21)Sneak Peek  (32)Solution Services  (4)Spreadsheet  (11)SQL  (15)Stock Chart  (1)Surface  (4)Tablets  (5)Theme  (12)Tips and Tricks  (113)UI  (400)Uncategorized  (68)Unix  (2)User interface  (68)Visual State Manager  (2)Visual Studio  (31)Visual Studio Code  (19)Web  (624)What's new  (337)Windows 8  (19)Windows App  (2)Windows Phone  (15)Windows Phone 7  (9)WinRT  (26)

Grid Control for JavaScript in PHP

The Grid control for JavaScript in PHP can be used to perform the following operations:

·       Data binding by using PHP Web Service

·       CRUD Operations

The following code example illustrates how DataManager properties are used to perform CRUD operations in Remote Web services, and also configure data by using the UrlAdaptor.

var data = ej.DataManager(
url: 'http://localhost/phpservice/server.php/?action=get_Data',
insertUrl: 'http://localhost/phpservice/server.php/?action=insert_Data',
updateUrl: 'http://localhost/phpservice/server.php/?action=update_Data',
removeUrl: 'http://localhost/phpservice/server.php/?action=delrec'
data.adaptor = new ej.UrlAdaptor();

Data Binding

To bind data to the Grid control, you can use the PHP get_Data Web service method. This method gets the JSON data to be loaded into the grid. The following code example illustrates this.

url: ’http://localhost/phpservice/server.php/?action=get_Data’

Adding Data

With the insertUrl property, you can invoke the insert_Data Web service method to add new data to the grid. The “/?action=insert_Data” section in the URL invokes the Web service method to get the JSON object that contains the data to be inserted to perform the insertion operation. The following code example illustrates this.

insertUrl: ’http://localhost/phpservice/server.php/?action=insert_Data’
$json_insert = file_get_contents('php://input');
$obj_insert = json_decode($json_insert,true)

Updating Data

With the updateUrl property, you can invoke the update_Data Web service method to update grid data. This method posts the JSON object that contains the updated information to the database. The following code example illustrates this.

updateUrl: ’http://localhost/phpservice/server.php/?action=update_Data’

Deleting Data

With the removeUrl property, you can invoke the delrec Web service method to delete grid data. In the server, the “key” to delete the record is fetched from the posted JSON object, and the record is deleted from the database by using the Web service method. The following code example illustrates this.

removeUrl: ’http://localhost/phpservice/server.php/?action=delrec’

To learn more about this, you can download a free sample here: (601.57 kb)


Content Contributors: Bharath M; Madhu Sudhanan Content Editor: GeeGee Inekeya


Share this post:

Comments (3)

Would be great if you could update this example. I got it to work but only after a lot of sweat.

the Php grid is a feature which shows information from database. it is a great information you have posted with code.

hi Matt,

Could you kindly give brief explanation about the difficulties you faced in this blog? We really appreciate your concern and we will update this blog with your concerns provided.

Alan Sangeeth S

Comments are closed.

Popular Now

Be the first to get updates

Subscribe RSS feed

Be the first to get updates

Subscribe RSS feed