PHP implements the function of directly modifying the table content DataGrid

Home

Backend Development

PHP Tutorial

PHP implements the function of directly modifying the table content DataGrid_PHP tutorial

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jul 20, 2016 am 10:58 AM

phpRevisecontentFunctionaccomplishsurfacepass

Recently I wanted to make something that implements the DataGrid function through PHP, so that the contents of the tables in the database can be directly modified without developing [Add Data Page] and [Edit Page], so I searched online. , there are several similar things, both open source and paid, but they are basically based on MySQL. Since it needs to be connected to Oracle, I personally feel that phpMyDataGrid is relatively easy to get started with in terms of secondary development and page style. This article first introduces the usage based on MySQL, and then briefly introduces the secondary development of Oracle connection (based on sqlrelay).

1. Create test database and tables

<ol class="dp-c">
<li class="alt"><span><span>create database `guru`;  </span></span></li>
<li><span> </span></li>
<li class="alt"><span>USE `guru`;  </span></li>
<li><span> </span></li>
<li class="alt"><span>CREATE TABLE `employees` (  </span></li>
<li><span>      `id` int(6) NOT NULL auto_increment,  </span></li>
<li class="alt">
<span>      `name` char(20) </span><span class="keyword">default</span><span> NULL,  </span>
</li>
<li>
<span>      `lastname` char(20) </span><span class="keyword">default</span><span> NULL,  </span>
</li>
<li class="alt">
<span>      `salary` float </span><span class="keyword">default</span><span> NULL,  </span>
</li>
<li>
<span>      `age` int(2) </span><span class="keyword">default</span><span> NULL,  </span>
</li>
<li class="alt">
<span>      `afiliation` </span><span class="func">date</span><span> </span><span class="keyword">default</span><span> NULL,  </span>
</li>
<li>
<span>      `status` int(1) </span><span class="keyword">default</span><span> NULL,  </span>
</li>
<li class="alt">
<span>      `active` tinyint(1) </span><span class="keyword">default</span><span> NULL,  </span>
</li>
<li>
<span>      `workeddays` int(2) </span><span class="keyword">default</span><span> NULL,  </span>
</li>
<li class="alt">
<span>      `photo` char(30) </span><span class="keyword">default</span><span> NULL,  </span>
</li>
<li><span>      PRIMARY KEY  (`id`)  </span></li>
<li class="alt"><span>)  </span></li>
<li><span> </span></li>
<li class="alt"><span>insert into `employees`  </span></li>
<li><span>    (`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`)   </span></li>
<li class="alt">
<span>    values (1, </span><span class="string">'Ana'</span><span>, </span><span class="string">'Trujillo'</span><span>,2000,45, </span><span class="string">'2005-05-13'</span><span>,1,1,10, </span><span class="string">'1.jpg'</span><span>);  </span>
</li>
<li><span>insert into `employees`   </span></li>
<li class="alt"><span>    (`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`)  </span></li>
<li>
<span>    values (2, </span><span class="string">'Jennifer'</span><span>, </span><span class="string">'Aniston'</span><span>,3500,23, </span><span class="string">'2004-10-22'</span><span>,1,0,0, </span><span class="string">'2.jpg'</span><span>);  </span>
</li>
<li class="alt"><span>insert into `employees`   </span></li>
<li><span>    (`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`)  </span></li>
<li class="alt">
<span>    values (3, </span><span class="string">'Michael'</span><span>, </span><span class="string">'Norman'</span><span>,1200,19, </span><span class="string">'2007-01-10'</span><span>,1,1,5, </span><span class="string">'3.jpg'</span><span>);  </span>
</li>
<li><span>insert into `employees`   </span></li>
<li class="alt"><span>    (`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`)  </span></li>
<li>
<span>    values (4, </span><span class="string">'Vanessa'</span><span>, </span><span class="string">'Black'</span><span>,6500,31, </span><span class="string">'2000-11-05'</span><span>,1,1,30, </span><span class="string">'4.jpg'</span><span>);  </span>
</li>
<li class="alt"><span>insert into `employees`   </span></li>
<li><span>    (`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`)  </span></li>
<li class="alt">
<span>    values (5, </span><span class="string">'Michael'</span><span>, </span><span class="string">'Strauss'</span><span>,3200,45, </span><span class="string">'2006-10-21'</span><span>,2,0,22, </span><span class="string">'5.jpg'</span><span>);  </span>
</li>
<li><span>insert into `employees`   </span></li>
<li class="alt"><span>    (`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`)  </span></li>
<li>
<span>    values (6, </span><span class="string">'William'</span><span>, </span><span class="string">'Brown'</span><span>,2300,21, </span><span class="string">'2001-03-10'</span><span>,3,1,10, </span><span class="string">'6.jpg'</span><span>);  </span>
</li>
<li class="alt"><span>insert into `employees`   </span></li>
<li><span>    (`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`)  </span></li>
<li class="alt">
<span>    values (7, </span><span class="string">'Lucca'</span><span>, </span><span class="string">'Normany'</span><span>,2800,36, </span><span class="string">'2006-10-02'</span><span>,3,1,20, </span><span class="string">'7.jpg'</span><span>); </span>
</li>
</ol>

2. Introduction to PHP program

phpMyDataGrid is mainly through phpmydatagrid .class.php, dgscripts.js to implement, the total total is less than 100kB, it is a small software. I won’t go into detail about these two documents. Interested students can “pack them away” and go back to read them slowly. It mainly introduces how to use the software, that is, the example datagrid_for_mysql.php. Take a look at the page diagram first:

PHP implements the function of directly modifying the table content DataGrid_PHP tutorial

Program explanation:

<ol class="dp-c">
<li class="alt"><span><span><?php    </span></span></span></li>
<li>
<span class="keyword">include</span><span> (</span><span class="string">"phpmydatagrid.class.php"</span><span>);  </span>
</li>
<li class="alt">
<span class="vars">$objGrid</span><span> = </span><span class="keyword">new</span><span> datagrid;  </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->closeTags(true);    </span>
</li>
<li class="alt">
<span class="vars">$objGrid</span><span>->friendlyHTML();    </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->methodForm(</span><span class="string">"get"</span><span>);   </span>
</li>
<li class="alt">
<span class="comment">//连接数据库 </span><span> </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->conectadb(</span><span class="string">"127.0.0.1"</span><span>, </span><span class="string">"root"</span><span>, </span><span class="string">"root"</span><span>, </span><span class="string">"guru"</span><span>);</span><span class="comment">//加密字符串 </span><span> </span>
</li>
<li class="alt">
<span class="vars">$objGrid</span><span>->salt(</span><span class="string">"Myc0defor5tr0ng3r-Pro3EctiOn"</span><span>);  </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->language(</span><span class="string">"en"</span><span>);  </span>
</li>
<li class="alt">
<span class="comment">//最后一列显示的功能键，从左向右功能为“新增键”、“编辑键”、“删除键”、“浏览键”。 </span><span> </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->buttons(true,true,true,true);  </span>
</li>
<li class="alt">
<span class="comment">//修改数值时产生的Form名称 </span><span> </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->form(</span><span class="string">'employee'</span><span>, true);  </span>
</li>
<li class="alt">
<span class="comment">//可检索列名 </span><span> </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->searchby(</span><span class="string">"name,lastname"</span><span>);  </span>
</li>
<li class="alt">
<span class="comment">//需要读取的表 </span><span> </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->tabla(</span><span class="string">"employees"</span><span>);  </span>
</li>
<li class="alt">
<span class="comment">//索引值用于修改数据 </span><span> </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->keyfield(</span><span class="string">"id"</span><span>);  </span>
</li>
<li class="alt">
<span class="comment">//分页显示行数 </span><span> </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->datarows(20);  </span>
</li>
<li class="alt">
<span class="comment">//默认排序方式 </span><span> </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->orderby(</span><span class="string">"name"</span><span>, </span><span class="string">"ASC"</span><span>);  </span>
</li>
<li class="alt">
<span class="comment">//显示列设置，相关设置可参考phpmydatagrid.class.php </span><span> </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->FormatColumn(</span><span class="string">"id"</span><span>, </span><span class="string">"ID Employee"</span><span>, 5, 5, 1, </span><span class="string">"50"</span><span>, </span><span class="string">"center"</span><span>, </span><span class="string">"integer"</span><span>);  </span>
</li>
<li class="alt">
<span class="vars">$objGrid</span><span>->FormatColumn(</span><span class="string">"name"</span><span>, </span><span class="string">"Name"</span><span>, 30, 30, 0, </span><span class="string">"150"</span><span>, </span><span class="string">"left"</span><span>);  </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->FormatColumn(</span><span class="string">"lastname"</span><span>, </span><span class="string">"Last name"</span><span>, 30, 30, 0, </span><span class="string">"150"</span><span>, </span><span class="string">"left"</span><span>);  </span>
</li>
<li class="alt">
<span class="vars">$objGrid</span><span>->FormatColumn(</span><span class="string">"age"</span><span>, </span><span class="string">"Age"</span><span>, 5, 5, 0, </span><span class="string">"50"</span><span>, </span><span class="string">"right"</span><span>);</span><span class="comment">//自定义日期格式 </span><span> </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->FormatColumn(</span><span class="string">"afiliation"</span><span>, </span><span class="string">"Afiliation Date"</span><span>, 10, 10, 0, </span><span class="string">"100"</span><span>, </span><span class="string">"center"</span><span>, </span><span class="string">"date:dmy:/"</span><span>);</span><span class="comment">//编辑时可以自定义为<select>模式 </select></span><span> </span>
</li>
<li class="alt">
<span class="vars">$objGrid</span><span>->FormatColumn(</span><span class="string">"status"</span><span>, </span><span class="string">"Status"</span><span>, 5, 5, 0, </span><span class="string">"60"</span><span>, </span><span class="string">"left"</span><span>, </span><span class="string">"select:1_Single:2_Married:3_Divorced"</span><span>);  </span>
</li>
<li>
<span class="comment">//编辑时可以自定义为<checkbox>模式 </checkbox></span><span> </span>
</li>
<li class="alt">
<span class="vars">$objGrid</span><span>->FormatColumn(</span><span class="string">"active"</span><span>, </span><span class="string">"Active"</span><span>, 2, 2, 0,</span><span class="string">"50"</span><span>, </span><span class="string">"center"</span><span>, </span><span class="string">"check:No:Yes"</span><span>);</span><span class="comment">//自定义货币显示形式 </span><span> </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->FormatColumn(</span><span class="string">"salary"</span><span>, </span><span class="string">"Salary"</span><span>, 10, 10, 0, </span><span class="string">"90"</span><span>, </span><span class="string">"right"</span><span>, </span><span class="string">"money:€"</span><span>);</span><span class="comment">//将数据以柱状图显示 </span><span> </span>
</li>
<li class="alt">
<span class="vars">$objGrid</span><span>->FormatColumn(</span><span class="string">"workeddays"</span><span>, </span><span class="string">"Work days"</span><span>, 5, 2, 0, </span><span class="string">"50"</span><span>, </span><span class="string">"right"</span><span>, </span><span class="string">"chart:percent:val:31"</span><span>);  </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->checkable();  </span>
</li>
<li class="alt">
<span class="vars">$objGrid</span><span>->setHeader();  </span>
</li>
<li>
<span class="vars">$objGrid</span><span>->ajax(</span><span class="string">'silent'</span><span>);  </span>
</li>
<li class="alt">
<span class="func">echo</span><span> '  </span>
</li>
<li><span>      <title>PHPDataGrid</title>  </span></li>
<li class="alt">
<span>      <div>
<span class="string">"center"</span><span>><br>';  </span><li>
<span class="comment">//生成DataGrid </span><span> </span>
</li>
<li class="alt">
<span class="vars">$objGrid</span><span>->grid();  </span>
</li>
<li>
<span class="func">echo</span><span> </span><span class="string">'</span>
</li>
</div>'</span><span>;</span><span class="comment">//关闭数据库连接 </span><span> </span>
</li>
<li class="alt">
<span class="vars">$objGrid</span><span>->desconectar();  </span>
</li>
<li><span>?>  </span></li>
</ol>

3. Based on the introduction to Oracle

The main way to read Oracle is to modify the function connected to MySQL in phpmydatagrid.class.php to Oracle. This article is through sqlrelay (please refer to

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

How does PHP type hinting work, including scalar types, return types, union types, and nullable types?Apr 17, 2025 am 12:25 AM

PHP type prompts to improve code quality and readability. 1) Scalar type tips: Since PHP7.0, basic data types are allowed to be specified in function parameters, such as int, float, etc. 2) Return type prompt: Ensure the consistency of the function return value type. 3) Union type prompt: Since PHP8.0, multiple types are allowed to be specified in function parameters or return values. 4) Nullable type prompt: Allows to include null values and handle functions that may return null values.

How does PHP handle object cloning (clone keyword) and the __clone magic method?Apr 17, 2025 am 12:24 AM

In PHP, use the clone keyword to create a copy of the object and customize the cloning behavior through the \_\_clone magic method. 1. Use the clone keyword to make a shallow copy, cloning the object's properties but not the object's properties. 2. The \_\_clone method can deeply copy nested objects to avoid shallow copying problems. 3. Pay attention to avoid circular references and performance problems in cloning, and optimize cloning operations to improve efficiency.

PHP vs. Python: Use Cases and ApplicationsApr 17, 2025 am 12:23 AM

PHP is suitable for web development and content management systems, and Python is suitable for data science, machine learning and automation scripts. 1.PHP performs well in building fast and scalable websites and applications and is commonly used in CMS such as WordPress. 2. Python has performed outstandingly in the fields of data science and machine learning, with rich libraries such as NumPy and TensorFlow.

Describe different HTTP caching headers (e.g., Cache-Control, ETag, Last-Modified).Apr 17, 2025 am 12:22 AM

Key players in HTTP cache headers include Cache-Control, ETag, and Last-Modified. 1.Cache-Control is used to control caching policies. Example: Cache-Control:max-age=3600,public. 2. ETag verifies resource changes through unique identifiers, example: ETag: "686897696a7c876b7e". 3.Last-Modified indicates the resource's last modification time, example: Last-Modified:Wed,21Oct201507:28:00GMT.

Explain secure password hashing in PHP (e.g., password_hash, password_verify). Why not use MD5 or SHA1?Apr 17, 2025 am 12:06 AM

In PHP, password_hash and password_verify functions should be used to implement secure password hashing, and MD5 or SHA1 should not be used. 1) password_hash generates a hash containing salt values to enhance security. 2) Password_verify verify password and ensure security by comparing hash values. 3) MD5 and SHA1 are vulnerable and lack salt values, and are not suitable for modern password security.

PHP: An Introduction to the Server-Side Scripting LanguageApr 16, 2025 am 12:18 AM

PHP is a server-side scripting language used for dynamic web development and server-side applications. 1.PHP is an interpreted language that does not require compilation and is suitable for rapid development. 2. PHP code is embedded in HTML, making it easy to develop web pages. 3. PHP processes server-side logic, generates HTML output, and supports user interaction and data processing. 4. PHP can interact with the database, process form submission, and execute server-side tasks.

PHP and the Web: Exploring its Long-Term ImpactApr 16, 2025 am 12:17 AM

PHP has shaped the network over the past few decades and will continue to play an important role in web development. 1) PHP originated in 1994 and has become the first choice for developers due to its ease of use and seamless integration with MySQL. 2) Its core functions include generating dynamic content and integrating with the database, allowing the website to be updated in real time and displayed in personalized manner. 3) The wide application and ecosystem of PHP have driven its long-term impact, but it also faces version updates and security challenges. 4) Performance improvements in recent years, such as the release of PHP7, enable it to compete with modern languages. 5) In the future, PHP needs to deal with new challenges such as containerization and microservices, but its flexibility and active community make it adaptable.

Why Use PHP? Advantages and Benefits ExplainedApr 16, 2025 am 12:16 AM

The core benefits of PHP include ease of learning, strong web development support, rich libraries and frameworks, high performance and scalability, cross-platform compatibility, and cost-effectiveness. 1) Easy to learn and use, suitable for beginners; 2) Good integration with web servers and supports multiple databases; 3) Have powerful frameworks such as Laravel; 4) High performance can be achieved through optimization; 5) Support multiple operating systems; 6) Open source to reduce development costs.

See all articles

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)

1 months agoBy尊渡假赌尊渡假赌尊渡假赌

R.E.P.O. Best Graphic Settings

4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Assassin's Creed Shadows: Seashell Riddle Solution

2 weeks agoByDDD

R.E.P.O. How to Fix Audio if You Can't Hear Anyone

1 months agoBy尊渡假赌尊渡假赌尊渡假赌

R.E.P.O. Chat Commands and How to Use Them

1 months agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

ZendStudio 13.5.1 Mac

Powerful PHP integrated development environment

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software