Gemeinschaft Lernen Tools-Bibliothek Freizeit
suchen
Deutsch
Heim > Backend-Entwicklung > PHP-Tutorial > PHP实现直接修改表内容DataGrid功能_PHP教程

PHP实现直接修改表内容DataGrid功能_PHP教程

WBOY
Freigeben： 2016-07-20 10:58:31
Original
1094 Leute haben es durchsucht

最近想做一个通过PHP实现DataGrid功能的东西，这样可以直接修改数据库中表的内容，而不用开发【新增数据页面】，【编辑页面】，于是乎在网上找了找，类似的东西也有几个，开源的、付费的都有，不过基本都是基于MySQL。由于需要连接Oracle所以从二次开发和页面样式来说个人觉得 phpMyDataGrid还是比较好上手。本篇首先介绍基于MySQL的使用方法，再简单介绍对于Oracle连接（基于sqlrelay）的二次开发。

1. 创建测试数据库和表

<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>
Nach dem Login kopieren

2. PHP程序介绍

phpMyDataGrid主要是通过phpmydatagrid.class.php，dgscripts.js来实现的，总共加起来不到100kB，又是一个小巧的软件。对于这两个文件就不多讲了，感兴趣的同学可以“打包带走”回去慢慢品。主要介绍该软件的使用方法，即实例 datagrid_for_mysql.php。先看一下页面示意图：

2009-8-11-19.22.06

程序讲解：

<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>
Nach dem Login kopieren

3. 基于Oracle简介

对于Oracle的读取主要是把phpmydatagrid.class.php中与MySQL连接的函数修改为Oracle，本篇是通过sqlrelay（可参考

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/445682.htmlTechArticle最近想做一个通过PHP实现DataGrid功能的东西，这样可以直接修改数据库中表的内容，而不用开发【新增数据页面】，【编辑页面】，于是乎...
Verwandte Etiketten：
php 修改 内容 功能 实现 表 通过
Quelle：php.cn
Vorheriger Artikel：查看PHP opcode扩展模块及Web服务_PHP教程 Nächster Artikel：我们什么时候应该使用异常?_PHP教程
Erklärung dieser Website
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Neueste Artikel des Autors
Aktuelle Ausgaben
Aus URL-Parametern erhaltene PHP-Arrays verhalten sich nicht wie erwartet Ich habe einen URL-Parameter, der die Kategorie-ID enthält, und ich möchte ihn als Array w...
Aus 2024-04-06 22:09:02
0
1
1428
Wo soll ich die CustomLog-Direktive in Apache platzieren? Ich verwende php:7.2-apachedocker. Ich muss das URL-Anmeldezugriffsprotokoll zur Gesundhei...
Aus 2024-04-06 22:03:59
0
1
990
Welches Format haben die Variablen im Rückgabewert? Ich bin ein PHP-Neuling. Ich habe einen Code gefunden: if($x<time()){return[false,'erro...
Aus 2024-04-06 21:55:20
0
1
778
Bei der Verwendung von opentbs zum Generieren von ODT-Dateien sind Probleme aufgetreten: Werte desselben Schlüssels werden in derselben Zeile statt in separaten Spalten angezeigt. Ich verwende eine Bibliothek namens OpenTbs, um ODT mit PHP zu erstellen. Ich verwende sie...
Aus 2024-04-06 20:18:18
0
1
483
Gruppieren Sie MySQL-Ergebnisse nach ID für die Schleife Ich habe eine Tabelle mit Flugdaten in MySQL. Ich schreibe einen PHP-Code, der Daten mithi...
Aus 2024-04-06 17:27:56
0
1
406
verwandte Themen
Mehr>
Beliebte Empfehlungen
Beliebte Tutorials
Mehr>
Verwandte Tutorials
Beliebte Empfehlungen
Aktuelle Kurse
Neueste Downloads
Mehr>
Web-Effekte
Quellcode der Website
Website-Materialien
Frontend-Vorlage