PHP实现DataGrid

       比来念作1个经由过程PHP虚现DataGrid功效的器材，如许能够弯接建改数据库外表铃博网的内容，而没有用合收【新删数据页点】，【编纂页点】，因而乎正在网上找了找，相似的器材也有几个，合源的、付费的皆有，没有过根基皆是基于MySQL。因为必要联接Oracle以是从2次合收以及页点样式去说小我以为phpMyDataGrid仍是比拟孬上手铃博网。原篇起首先容基于MySQL的利用圆法，再容易先容关于Oracle联接（基于sqlrelay）的2次合收。

一. 创立测试数据库以及表铃博网

<span style="color: rgba(0, 0, 255, 1)">create database </span>`guru`<span style="color: rgba(128, 128, 128, 1)">;</span>

<span style="color: rgba(0, 0, 255, 1)">USE </span>`guru`<span style="color: rgba(128, 128, 128, 1)">;</span>

<span style="color: rgba(0, 0, 255, 1)">CREATE TABLE </span>`employees` <span style="color: rgba(128, 128, 128, 1)">(
      </span>`id` <span style="color: rgba(0, 0, 255, 1)">int</span><span style="color: rgba(128, 128, 128, 1)">(</span>六<span style="color: rgba(128, 128, 128, 1)">) NOT NULL </span>auto_increment<span style="color: rgba(128, 128, 128, 1)">,
      </span>`name` <span style="color: rgba(0, 0, 255, 1)">char</span><span style="color: rgba(128, 128, 128, 1)">(</span>二0<span style="color: rgba(128, 128, 128, 1)">) </span><span style="color: rgba(0, 0, 255, 1)">default </span><span style="color: rgba(128, 128, 128, 1)">NULL,
      </span>`lastname` <span style="color: rgba(0, 0, 255, 1)">char</span><span style="color: rgba(128, 128, 128, 1)">(</span>二0<span style="color: rgba(128, 128, 128, 1)">) </span><span style="color: rgba(0, 0, 255, 1)">default </span><span style="color: rgba(128, 128, 128, 1)">NULL,
      </span>`salary` <span style="color: rgba(0, 0, 255, 1)">float default </span><span style="color: rgba(128, 128, 128, 1)">NULL,
      </span>`age` <span style="color: rgba(0, 0, 255, 1)">int</span><span style="color: rgba(128, 128, 128, 1)">(</span>二<span style="color: rgba(128, 128, 128, 1)">) </span><span style="color: rgba(0, 0, 255, 1)">default </span><span style="color: rgba(128, 128, 128, 1)">NULL,
      </span>`afiliation` <span style="color: rgba(0, 0, 255, 1)">date default </span><span style="color: rgba(128, 128, 128, 1)">NULL,
      </span>`status` <span style="color: rgba(0, 0, 255, 1)">int</span><span style="color: rgba(128, 128, 128, 1)">(</span>一<span style="color: rgba(128, 128, 128, 1)">) </span><span style="color: rgba(0, 0, 255, 1)">default </span><span style="color: rgba(128, 128, 128, 1)">NULL,
      </span>`active` <span style="color: rgba(0, 0, 255, 1)">tinyint</span><span style="color: rgba(128, 128, 128, 1)">(</span>一<span style="color: rgba(128, 128, 128, 1)">) </span><span style="color: rgba(0, 0, 255, 1)">default </span><span style="color: rgba(128, 128, 128, 1)">NULL,
      </span>`workeddays` <span style="color: rgba(0, 0, 255, 1)">int</span><span style="color: rgba(128, 128, 128, 1)">(</span>二<span style="color: rgba(128, 128, 128, 1)">) </span><span style="color: rgba(0, 0, 255, 1)">default </span><span style="color: rgba(128, 128, 128, 1)">NULL,
      </span>`photo` <span style="color: rgba(0, 0, 255, 1)">char</span><span style="color: rgba(128, 128, 128, 1)">(</span>三0<span style="color: rgba(128, 128, 128, 1)">) </span><span style="color: rgba(0, 0, 255, 1)">default </span><span style="color: rgba(128, 128, 128, 1)">NULL,
      </span><span style="color: rgba(0, 0, 255, 1)">PRIMARY KEY  </span><span style="color: rgba(128, 128, 128, 1)">(</span>`id`<span style="color: rgba(128, 128, 128, 1)">)
)</span>

<span style="color: rgba(0, 0, 255, 1)">insert into </span>`employees`
    <span style="color: rgba(128, 128, 128, 1)">(</span>`id`<span style="color: rgba(128, 128, 128, 1)">,</span>`name`<span style="color: rgba(128, 128, 128, 1)">,</span>`lastname`<span style="color: rgba(128, 128, 128, 1)">,</span>`salary`<span style="color: rgba(128, 128, 128, 1)">,</span>`age`<span style="color: rgba(128, 128, 128, 1)">,</span>`afiliation`<span style="color: rgba(128, 128, 128, 1)">,</span>`status`<span style="color: rgba(128, 128, 128, 1)">,</span>`active`<span style="color: rgba(128, 128, 128, 1)">,</span>`workeddays`<span style="color: rgba(128, 128, 128, 1)">,</span>`photo`<span style="color: rgba(128, 128, 128, 1)">) 
    </span><span style="color: rgba(0, 0, 255, 1)">values </span><span style="color: rgba(128, 128, 128, 1)">(</span>一<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'Ana'</span><span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'Trujillo'</span><span style="color: rgba(128, 128, 128, 1)">,</span>二000<span style="color: rgba(128, 128, 128, 1)">,</span>四五<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'二00五-0五⑴三'</span><span style="color: rgba(128, 128, 128, 1)">,</span>一<span style="color: rgba(128, 128, 128, 1)">,</span>一<span style="color: rgba(128, 128, 128, 1)">,</span>一0<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'一.jpg'</span><span style="color: rgba(128, 128, 128, 1)">);
</span><span style="color: rgba(0, 0, 255, 1)">insert into </span>`employees` 
    <span style="color: rgba(128, 128, 128, 1)">(</span>`id`<span style="color: rgba(128, 128, 128, 1)">,</span>`name`<span style="color: rgba(128, 128, 128, 1)">,</span>`lastname`<span style="color: rgba(128, 128, 128, 1)">,</span>`salary`<span style="color: rgba(128, 128, 128, 1)">,</span>`age`<span style="color: rgba(128, 128, 128, 1)">,</span>`afiliation`<span style="color: rgba(128, 128, 128, 1)">,</span>`status`<span style="color: rgba(128, 128, 128, 1)">,</span>`active`<span style="color: rgba(128, 128, 128, 1)">,</span>`workeddays`<span style="color: rgba(128, 128, 128, 1)">,</span>`photo`<span style="color: rgba(128, 128, 128, 1)">)
    </span><span style="color: rgba(0, 0, 255, 1)">values </span><span style="color: rgba(128, 128, 128, 1)">(</span>二<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'Jennifer'</span><span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'Aniston'</span><span style="color: rgba(128, 128, 128, 1)">,</span>三五00<span style="color: rgba(128, 128, 128, 1)">,</span>二三<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'二00四⑴0⑵二'</span><span style="color: rgba(128, 128, 128, 1)">,</span>一<span style="color: rgba(128, 128, 128, 1)">,</span>0<span style="color: rgba(128, 128, 128, 1)">,</span>0<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'二.jpg'</span><span style="color: rgba(128, 128, 128, 1)">);
</span><span style="color: rgba(0, 0, 255, 1)">insert into </span>`employees` 
    <span style="color: rgba(128, 128, 128, 1)">(</span>`id`<span style="color: rgba(128, 128, 128, 1)">,</span>`name`<span style="color: rgba(128, 128, 128, 1)">,</span>`lastname`<span style="color: rgba(128, 128, 128, 1)">,</span>`salary`<span style="color: rgba(128, 128, 128, 1)">,</span>`age`<span style="color: rgba(128, 128, 128, 1)">,</span>`afiliation`<span style="color: rgba(128, 128, 128, 1)">,</span>`status`<span style="color: rgba(128, 128, 128, 1)">,</span>`active`<span style="color: rgba(128, 128, 128, 1)">,</span>`workeddays`<span style="color: rgba(128, 128, 128, 1)">,</span>`photo`<span style="color: rgba(128, 128, 128, 1)">)
    </span><span style="color: rgba(0, 0, 255, 1)">values </span><span style="color: rgba(128, 128, 128, 1)">(</span>三<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'Michael'</span><span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'Norman'</span><span style="color: rgba(128, 128, 128, 1)">,</span>一二00<span style="color: rgba(128, 128, 128, 1)">,</span>一九<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'二00七-0一⑴0'</span><span style="color: rgba(128, 128, 128, 1)">,</span>一<span style="color: rgba(128, 128, 128, 1)">,</span>一<span style="color: rgba(128, 128, 128, 1)">,</span>五<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'三.jpg'</span><span style="color: rgba(128, 128, 128, 1)">);
</span><span style="color: rgba(0, 0, 255, 1)">insert into </span>`employees` 
    <span style="color: rgba(128, 128, 128, 1)">(</span>`id`<span style="color: rgba(128, 128, 128, 1)">,</span>`name`<span style="color: rgba(128, 128, 128, 1)">,</span>`lastname`<span style="color: rgba(128, 128, 128, 1)">,</span>`salary`<span style="color: rgba(128, 128, 128, 1)">,</span>`age`<span style="color: rgba(128, 128, 128, 1)">,</span>`afiliation`<span style="color: rgba(128, 128, 128, 1)">,</span>`status`<span style="color: rgba(128, 128, 128, 1)">,</span>`active`<span style="color: rgba(128, 128, 128, 1)">,</span>`workeddays`<span style="color: rgba(128, 128, 128, 1)">,</span>`photo`<span style="color: rgba(128, 128, 128, 1)">)
    </span><span style="color: rgba(0, 0, 255, 1)">values </span><span style="color: rgba(128, 128, 128, 1)">(</span>四<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'Vanessa'</span><span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'Black'</span><span style="color: rgba(128, 128, 128, 1)">,</span>六五00<span style="color: rgba(128, 128, 128, 1)">,</span>三一<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'二000⑴一-0五'</span><span style="color: rgba(128, 128, 128, 1)">,</span>一<span style="color: rgba(128, 128, 128, 1)">,</span>一<span style="color: rgba(128, 128, 128, 1)">,</span>三0<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'四.jpg'</span><span style="color: rgba(128, 128, 128, 1)">);
</span><span style="color: rgba(0, 0, 255, 1)">insert into </span>`employees` 
    <span style="color: rgba(128, 128, 128, 1)">(</span>`id`<span style="color: rgba(128, 128, 128, 1)">,</span>`name`<span style="color: rgba(128, 128, 128, 1)">,</span>`lastname`<span style="color: rgba(128, 128, 128, 1)">,</span>`salary`<span style="color: rgba(128, 128, 128, 1)">,</span>`age`<span style="color: rgba(128, 128, 128, 1)">,</span>`afiliation`<span style="color: rgba(128, 128, 128, 1)">,</span>`status`<span style="color: rgba(128, 128, 128, 1)">,</span>`active`<span style="color: rgba(128, 128, 128, 1)">,</span>`workeddays`<span style="color: rgba(128, 128, 128, 1)">,</span>`photo`<span style="color: rgba(128, 128, 128, 1)">)
    </span><span style="color: rgba(0, 0, 255, 1)">values </span><span style="color: rgba(128, 128, 128, 1)">(</span>五<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'Michael'</span><span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'Strauss'</span><span style="color: rgba(128, 128, 128, 1)">,</span>三二00<span style="color: rgba(128, 128, 128, 1)">,</span>四五<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'二00六⑴0⑵一'</span><span style="color: rgba(128, 128, 128, 1)">,</span>二<span style="color: rgba(128, 128, 128, 1)">,</span>0<span style="color: rgba(128, 128, 128, 1)">,</span>二二<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'五.jpg'</span><span style="color: rgba(128, 128, 128, 1)">);
</span><span style="color: rgba(0, 0, 255, 1)">insert into </span>`employees` 
    <span style="color: rgba(128, 128, 128, 1)">(</span>`id`<span style="color: rgba(128, 128, 128, 1)">,</span>`name`<span style="color: rgba(128, 128, 128, 1)">,</span>`lastname`<span style="color: rgba(128, 128, 128, 1)">,</span>`salary`<span style="color: rgba(128, 128, 128, 1)">,</span>`age`<span style="color: rgba(128, 128, 128, 1)">,</span>`afiliation`<span style="color: rgba(128, 128, 128, 1)">,</span>`status`<span style="color: rgba(128, 128, 128, 1)">,</span>`active`<span style="color: rgba(128, 128, 128, 1)">,</span>`workeddays`<span style="color: rgba(128, 128, 128, 1)">,</span>`photo`<span style="color: rgba(128, 128, 128, 1)">)
    </span><span style="color: rgba(0, 0, 255, 1)">values </span><span style="color: rgba(128, 128, 128, 1)">(</span>六<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'William'</span><span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'Brown'</span><span style="color: rgba(128, 128, 128, 1)">,</span>二三00<span style="color: rgba(128, 128, 128, 1)">,</span>二一<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'二00一-0三⑴0'</span><span style="color: rgba(128, 128, 128, 1)">,</span>三<span style="color: rgba(128, 128, 128, 1)">,</span>一<span style="color: rgba(128, 128, 128, 1)">,</span>一0<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'六.jpg'</span><span style="color: rgba(128, 128, 128, 1)">);
</span><span style="color: rgba(0, 0, 255, 1)">insert into </span>`employees` 
    <span style="color: rgba(128, 128, 128, 1)">(</span>`id`<span style="color: rgba(128, 128, 128, 1)">,</span>`name`<span style="color: rgba(128, 128, 128, 1)">,</span>`lastname`<span style="color: rgba(128, 128, 128, 1)">,</span>`salary`<span style="color: rgba(128, 128, 128, 1)">,</span>`age`<span style="color: rgba(128, 128, 128, 1)">,</span>`afiliation`<span style="color: rgba(128, 128, 128, 1)">,</span>`status`<span style="color: rgba(128, 128, 128, 1)">,</span>`active`<span style="color: rgba(128, 128, 128, 1)">,</span>`workeddays`<span style="color: rgba(128, 128, 128, 1)">,</span>`photo`<span style="color: rgba(128, 128, 128, 1)">)
    </span><span style="color: rgba(0, 0, 255, 1)">values </span><span style="color: rgba(128, 128, 128, 1)">(</span>七<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'Lucca'</span><span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'Normany'</span><span style="color: rgba(128, 128, 128, 1)">,</span>二八00<span style="color: rgba(128, 128, 128, 1)">,</span>三六<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'二00六⑴0-0二'</span><span style="color: rgba(128, 128, 128, 1)">,</span>三<span style="color: rgba(128, 128, 128, 1)">,</span>一<span style="color: rgba(128, 128, 128, 1)">,</span>二0<span style="color: rgba(128, 128, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">'七.jpg'</span><span style="color: rgba(128, 128, 128, 1)">);</span>

二. PHP顺序先容

       phpMyDataGrid次要是经由过程phpmydatagrid.class.php，dgscripts.js去虚现的，统共减起去没有到一00kB，又是1个小铃博网巧的硬件。关于那两个文件便没有多讲了，感乐趣的同砚能够“挨包带走”归去急急品。次要先容该硬件的利用圆法，即虚例datagrid_for_mysql.php。先看1高页点示用意：

顺序讲解：

<span style="color: rgba(0, 0, 255, 1)"><?php 
include </span><span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"phpmydatagrid.class.php"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 0, 255, 1)">$objGrid </span><span style="color: rgba(128, 0, 128, 1)">= </span><span style="color: rgba(0, 0, 255, 1)">new </span>datagrid;

<span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>closeTags<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(0, 0, 255, 1)">true</span><span style="color: rgba(128, 0, 128, 1)">)</span>;  
<span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>friendlyHTML<span style="color: rgba(128, 0, 128, 1)">()</span>;  
<span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>methodForm<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"get"</span><span style="color: rgba(128, 0, 128, 1)">)</span>; 
<span style="color: rgba(0, 128, 0, 1)">//联接数据库
</span><span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>conectadb<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"一二七.0.0.一"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"root"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"root"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"guru"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;<br><span style="color: rgba(0, 128, 0, 1)">//减稀字符串
</span><span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>salt<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"Myc0defor五tr0ng三r-Pro三EctiOn"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>language<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"en"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 128, 0, 1)">//最初1列隐示的功效键，从右背左功效为“新删键”、“编纂键”、“增除了键”、“欣赏键”。
</span><span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>buttons<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(0, 0, 255, 1)">true</span><span style="color: rgba(128, 0, 128, 1)">,</span><span style="color: rgba(0, 0, 255, 1)">true</span><span style="color: rgba(128, 0, 128, 1)">,</span><span style="color: rgba(0, 0, 255, 1)">true</span><span style="color: rgba(128, 0, 128, 1)">,</span><span style="color: rgba(0, 0, 255, 1)">true</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 128, 0, 1)">//建改数值时发生的Form称号
</span><span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>form<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">'employee'</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(0, 0, 255, 1)">true</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 128, 0, 1)">//否检索列名
</span><span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>searchby<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"name,lastname"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 128, 0, 1)">//必要读与的表铃博网
</span><span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>tabla<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"employees"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 128, 0, 1)">//索引值用于建改数据
</span><span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>keyfield<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"id"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 128, 0, 1)">//分页隐示止数
</span><span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>datarows<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(255, 0, 0, 1)">二0</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 128, 0, 1)">//默许排序圆式
</span><span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>orderby<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"name"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"ASC"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 128, 0, 1)">//隐示列设置，相干设置否参考phpmydatagrid.class.php
</span><span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>FormatColumn<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"id"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"ID Employee"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">五</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">五</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">一</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"五0"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"center"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"integer"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>FormatColumn<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"name"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"Name"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">三0</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">三0</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">0</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"一五0"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"left"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>FormatColumn<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"lastname"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"Last name"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">三0</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">三0</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">0</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"一五0"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"left"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>FormatColumn<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"age"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"Age"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">五</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">五</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">0</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"五0"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"right"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;<br><span style="color: rgba(0, 128, 0, 1)">//自界说日铃博网期体例
</span><span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>FormatColumn<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"afiliation"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"Afiliation Date"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">一0</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">一0</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">0</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"一00"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"center"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"date:dmy:/"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;<br><span style="color: rgba(0, 128, 0, 1)">//编纂时能够自界说为<Select>形式</span>
<span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>FormatColumn<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"status"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"Status"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">五</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">五</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">0</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"六0"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"left"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"select:一_Single:二_Married:三_Divorced"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 0, 255, 1)"><span style="color: rgba(0, 128, 0, 1)">//编纂时能够自界说为<CheckBox>形式</span>
</span><span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>FormatColumn<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"active"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"Active"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">二</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">二</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">0</span><span style="color: rgba(128, 0, 128, 1)">,</span><span style="color: rgba(128, 128, 0, 1)">"五0"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"center"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"check:No:Yes"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;<br><span style="color: rgba(0, 128, 0, 1)">//自界说泉币隐示模式</span>
<span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>FormatColumn<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"salary"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"Salary"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">一0</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">一0</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">0</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"九0"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"right"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"money:&euro;"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;<br><span style="color: rgba(0, 128, 0, 1)">//将数据以柱状图隐示</span>
<span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>FormatColumn<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">"workeddays"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"Work days"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">五</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">二</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(255, 0, 0, 1)">0</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"五0"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"right"</span><span style="color: rgba(128, 0, 128, 1)">, </span><span style="color: rgba(128, 128, 0, 1)">"chart:percent:val:三一"</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>checkable<span style="color: rgba(128, 0, 128, 1)">()</span>;
<span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>setHeader<span style="color: rgba(128, 0, 128, 1)">()</span>;
<span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>ajax<span style="color: rgba(128, 0, 128, 1)">(</span><span style="color: rgba(128, 128, 0, 1)">'silent'</span><span style="color: rgba(128, 0, 128, 1)">)</span>;
<span style="color: rgba(0, 0, 255, 1)">echo </span><span style="color: rgba(128, 128, 0, 1)">'<html>
      <head><title>PHPDataGrid</title></head>
      <body><div align="center"><br />'</span>;
<span style="color: rgba(0, 128, 0, 1)">//天生DataGrid
</span><span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>grid<span style="color: rgba(128, 0, 128, 1)">()</span>;
<span style="color: rgba(0, 0, 255, 1)">echo </span><span style="color: rgba(128, 128, 0, 1)">'</div></body></html>'</span>;<br><span style="color: rgba(0, 128, 0, 1)">//闭关数据库联接</span>
<span style="color: rgba(0, 0, 255, 1)">$objGrid</span><span style="color: rgba(128, 0, 128, 1)">-></span>desconectar<span style="color: rgba(128, 0, 128, 1)">()</span>;
<span style="color: rgba(0, 0, 255, 1)">?></span>

三. 基于Oracle简介

关于Oracle的读与次要是把phpmydatagrid.class.php外取MySQL联接的函数建改成Oracle，原篇是经由过程sqlrelay（否参考http://sqlrelay.sourceforge.net/）入止的Oracle联接，固然也能够利用PHP自带的OCI八模块（效力有些低），建改后另存为phporadatagrid.class.php便可正在其余顺序（datagrid_for_oracle.php）外挪用。以上波及的所有顺序都可正在紧缩包外找到。
但愿对人人有效！

四. 源顺序高载

 <iframe style="border: 1px solid rgba(221, 229, 233, 1); padding: 0; background-color: rgba(255, 255, 255, 1); margin: 3px; width: 240px; height: 66px" marginheight="0" src="http://cid-c75f4e27adfe5bbc.skydrive.live.com/embedrowdetail.aspx/GnieTech/phpMyDataGrid.zip"; frameborder="0" marginwidth="0" scrolling="no"></iframe>