- PHP Grid with little config, enables Add, Edit, Del, Auto-filter, Search, Sort, Page, Grouping, Export, Custom Add/Del Calls, Master-detail Grids, Multiple Databases, Customizable Themes and many other features.
- It’s Secure & Commercially Opensource so you can extend your own core functions.
- Best suitable for smart engineers, who wish to save development time & effort of creating repetitive CRUD functions through out their projects.
- Custom SELECT query option is useful for cross table data displaying and Reporting generation. PHP Datagrid Controlis extendable and you can write your own Custom Code-behinds for adding, updating or deleting records.
- Supports all major databases including Mysql, SQL Server, Oracle, PGSql & ODBC Driver supported databases.
Data Grid Libraries provides professional-looking Ajax-enabled grid-based editing, create, read, update, and delete (CRUD) operations for Web developers in as little as two lines of code. It features cross-browser inline editing, support for all HTML form controls, integrated search toolbar, a master detail datagrid, image display, MS , HTML and PDF data export, permission control, a theme roller, built-in record sorting by any column, support for major databases including MySQL, SQL Server, and Oracle, support for large database record sets, and some times WYSIWYG and Ajax file upload.
Best 3 PHP Grids are as Follows-
Create a fully functional datagrid in PHP for as little as
five TWO lines of code.
phpGrid allow you to create a fully functional datagrid in PHP for as little as two lines of code.
Here are the keyfutures available:
Master Detail Datagrid
Multiple Editable Datagrids
Master with Multiple Detail Grids
Column Grouping with Summary
Nested Master Detail Grids
KoolPHP is a vendor of PHP User Interface (UI) components. We focus on building the featured rich yet easy-to-use components to help developers increase productivity and deliver highest quality applications within time and budget constraints. Koolphp is my 2nd best dataGrid that contains a group of great UI controls to help developer build excellent web2.0 application.
- Cross-browsers compatible
- Comply to XHTML standard
- Feature-rich and easy to use controls
- Abundant ready-to-use examples
- Working with Zend, CakePHP, Joomla, Smarty.
- Compatible with Prototype,jQuery, Mootools, Extjs
You can check the Demos
It has a free version with limited features and paid version(less expensive than phpGrid)
jqGrid is a grid component for ASP.NET & PHP based on the world’s most popular and flexible jQuery grid plugin.
jqGrid is free, open source and gets distributed under the MIT license.
- Works fine under IE, Firefox, Chrome, Safari, Opera
- The UI comes in 20+ languages
- CSS customizable
- Paging and sorting
- Search and filtering
- In-place cell editing or on-the-fly form creation to edit a record
- Supports subgrids and tree grid for displaying hierarchical data
- AJAX enabled
- Accepts XML/JSON/local array data sources
Free wrappers for PHP and ASP.NET exist.
You can view the Demo
Learn to create a simple login system with php + mysql script, this tutorial is easy to follow, teach you step by step.
In this tutorial, we create 3 php files for testing our code.
1. index.php (loginform)
2. config.php(mysql connectivity)
3. home.php(after login page redirects)
STEP1: Create Database named “ravindra” and make a new table named login
CREATE TABLE `login` (
`id` int(4) NOT NULL auto_increment,
`email_id` varchar(65) NOT NULL default ”,
`password` varchar(65) NOT NULL default ”,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
— Dumping data for table `members`
INSERT INTO `members` VALUES (1, ‘choudhary’, ‘admin’);
STEP2: Create file config.php for database Connectivity
mysql_connect($hostname, $user, $password) or die(mysql_error());
mysql_select_db(“ravindra”) or die (mysql_error());
you can change hostname, user and password according your system
STEP3: Create file index.php having login form
$sql=” select * from login where email_id=’$username’ and password=’$password’ “;
echo “error: Invalid detals”;
<form name=”loginform” id=”loginform” method=”POST” action=””>
email :<input type=”text” name=”username” id=”username” />
password :<input type=”password” name=”password” id=”password” />
<input type=”submit” id=”submit” name=”submit” value=”login” />
STEP4: Make a new file named as home.php
After successfully login page will redirect to the home.php
echo ‘welcome ‘.$_SESSION[‘username’];
STEP5: Make a new file named as logout.php
- Incorrect username / password message and redirect (stackoverflow.com)
It is possible to insert multiple records into MySQL using a comma separated list of fields. This post looks at how to do this using SQL – if you’re using a nice ORM solution instead of writing SQL queries then this won’t really apply.
If we have an example table that was created like this:
CREATE TABLE example ( example_id INT NOT NULL, name VARCHAR( 50 ) NOT NULL, value VARCHAR( 50 ) NOT NULL, other_value VARCHAR( 50 ) NOT NULL ) Normally we could insert a record like this: INSERT INTO example (example_id, name, value, other_value) VALUES (100, 'Name 1', 'Value 1', 'Other 1'); To insert more than one record at once, we can do this, with each set of field values separated by a comma: INSERT INTO example (example_id, name, value, other_value) VALUES (100, 'Name 1', 'Value 1', 'Other 1'), (101, 'Name 2', 'Value 2', 'Other 2'), (102, 'Name 3', 'Value 3', 'Other 3'), (103, 'Name 4', 'Value 4', 'Other 4');