table list $tbl = new C_DataGrid("SELECT TABLE_NAME, TABLE_SCHEMA, TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES", "TABLE_NAME", "INFORMATION_SCHEMA.TABLES") If not, follow this guide to learn how – įirst, add the following lines to the TOP of our page Presumably, you have already installed phpGrid on your web server. Luckily, CSSPortal has an excellent layout tool which easily generates a column-based layout with only point and click.Īn alternative is to download this boilerplate (File -> Save As) which contains all the HTML and CSS code needed for this demo application. The main grid will be populated with data from the database table selected from the left sidebar. What we need is a fixed-width sidebar on the left while the main – a grid – stays “fluid” so it fills the remaining document width. On the main datagrid, which contains the database table, we will also add a search bar so users can search within the displayed grid. Both the sidebar and the main are datagrids.
Our application will have a list of database schemas and tables on the left side – the sidebar – and a database table on the main screen – the main. The demo uses MySQL, however, the same basic code should work with other databases with the use of a different SQL schema SELECT statement. Note the demo application requires phpGrid version 7 and above.
The application will perform common data operations such as Create, Read, Update, Delete, otherwise known as CRUD on MySQL database tables. We will learn how to build a fully functional, single-page database content administration application using phpGrid and other PHP components with a minimum amount of code. The source code of this tutorial is publicly available on Github.
0 kommentar(er)
