PHPÖ±½ÓÐ޸ıíÄÚÈÝDataGrid¹¦ÄÜʵÏÖ´úÂë

ÓÉÓÚÐeÒªÁ¬½ÓOracleËuÒÔ´Ó¶þ´Î¿ª*¢ºÍÒ³ÃaeÑuʽÀ´Ëµ¸oÈ˾oµÃphpMyDataGrid»¹ÊDZȽϺÃÉÏÊÖ¡£
1. ´´½¨²aÊÔÊý¾Ý¿aºÍ±i

    create database `guru`; 

    USE `guru`; 

    CREATE TABLE `employees` ( 
       `id` int(6) NOT NULL auto_increment, 
       `name` char(20) default NULL, 
       `lastname` char(20) default NULL, 
       `salary` float default NULL, 
       `age` int(2) default NULL, 
       `afiliation` date default NULL, 
       `status` int(1) default NULL, 
       `active` tinyint(1) default NULL, 
       `workeddays` int(2) default NULL, 
       `photo` char(30) default NULL, 
       PRIMARY KEY (`id`) 
    ) 

    insert into `employees` 
      (`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`)  
      values (1, 'Ana', 'Trujillo',2000,45, '2005-05-13',1,1,10, '1.jpg'); 
    insert into `employees`  
      (`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`) 
      values (2, 'Jennifer', 'Aniston',3500,23, '2004-10-22',1,0,0, '2.jpg'); 
    insert into `employees`  
      (`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`) 
      values (3, 'Michael', 'Norman',1200,19, '2007-01-10',1,1,5, '3.jpg'); 
    insert into `employees`  
      (`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`) 
      values (4, 'Vanessa', 'Black',6500,31, '2000-11-05',1,1,30, '4.jpg'); 
    insert into `employees`  
      (`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`) 
      values (5, 'Michael', 'Strauss',3200,45, '2006-10-21',2,0,22, '5.jpg'); 
    insert into `employees`  
      (`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`) 
      values (6, 'William', 'Brown',2300,21, '2001-03-10',3,1,10, '6.jpg'); 
    insert into `employees`  
      (`id`,`name`,`lastname`,`salary`,`age`,`afiliation`,`status`,`active`,`workeddays`,`photo`) 
      values (7, 'Lucca', 'Normany',2800,36, '2006-10-02',3,1,20, '7.jpg'); 

2. PHP³ÌÐo½eÉÜ

phpMyDataGridÖ÷ÒªÊÇͨ¹ýphpmydatagrid.class.php£¬dgscripts.jsÀ´ÊµÏֵģ¬×ܹ²¼ÓÆðÀ´²»µ½100kB£¬ÓÖÊÇÒ»¸oСÇɵÄÈi¼þ¡£¶ÔÓÚÕaÁ½¸oÎļþ¾Í²»¶a½²ÁË£¬¸ÐÐËȤµÄͬѧ¿ÉÒÔ¡°´o°u´ø×ß¡±»ØÈ¥ÂýÂýÆ¡£Ö÷Òª½eÉܸÃÈi¼þµÄʹÓý*¨£¬¼´ÊµÀý datagrid_for_mysql.php¡£ÏÈ¿´Ò»ÏÂÒ³ÃaeʾÒaͼ£º

³ÌÐo½²½a£º

    <?php  
    include ("phpmydatagrid.class.php"); 
    $objGrid = new datagrid; 
    $objGrid->closeTags(true);  
    $objGrid->friendlyHTML();  
    $objGrid->methodForm("get");  
    //Á¬½ÓÊý¾Ý¿a 
    $objGrid->conectadb("127.0.0.1", "root", "root", "guru");//¼ÓÃÜ×Ö*u´® 
    $objGrid->salt("Myc0defor5tr0ng3r-Pro3EctiOn"); 
    $objGrid->language("en"); 
    //×iºoÒ»ÁÐÏÔʾµÄ¹¦Äܼu£¬´Ó×oÏoÓÒ¹¦ÄÜΪ¡°ÐÂÔo¼u¡±¡¢¡°±a¼­¼u¡±¡¢¡°É¾³ý¼u¡±¡¢¡°a¯ÀÀ¼u¡±¡£ 
    $objGrid->buttons(true,true,true,true); 
    //ÐÞ¸ÄÊýֵʱ²uÉuµÄFormÃu³Æ 
    $objGrid->form('employee', true); 
    //¿É¼iË÷ÁÐÃu 
    $objGrid->searchby("name,lastname"); 
    //ÐeÒª¶ÁÈ¡µÄ±i 
    $objGrid->tabla("employees"); 
    //Ë÷ÒýÖµÓÃÓÚÐÞ¸ÄÊý¾Ý 
    $objGrid->keyfield("id"); 
    //*ÖÒ³ÏÔʾÐÐÊý 
    $objGrid->datarows(20); 
    //ĬÈÏÅÅÐo*½Ê½ 
    $objGrid->orderby("name", "ASC"); 
    //ÏÔʾÁÐÉeÖã¬Ïa¹ØÉeÖÿɲο¼phpmydatagrid.class.php 
    $objGrid->FormatColumn("id", "ID Employee", 5, 5, 1, "50", "center", "integer"); 
    $objGrid->FormatColumn("name", "Name", 30, 30, 0, "150", "left"); 
    $objGrid->FormatColumn("lastname", "Last name", 30, 30, 0, "150", "left"); 
    $objGrid->FormatColumn("age", "Age", 5, 5, 0, "50", "right");//×Ô¶¨ÒaÈÕÆÚ¸ñʽ 
    $objGrid->FormatColumn("afiliation", "Afiliation Date", 10, 10, 0, "100", "center", "date:dmy:/");//±a¼­Ê±¿ÉÒÔ×Ô¶¨ÒaΪ<Select>ģʽ 
    $objGrid->FormatColumn("status", "Status", 5, 5, 0, "60", "left", "select:1_Single:2_Married:3_Divorced"); 
    //±a¼­Ê±¿ÉÒÔ×Ô¶¨ÒaΪ<CheckBox>ģʽ 
    $objGrid->FormatColumn("active", "Active", 2, 2, 0,"50", "center", "check:No:Yes");//×Ô¶¨Òa»o±ÒÏÔʾÐÎʽ 
    $objGrid->FormatColumn("salary", "Salary", 10, 10, 0, "90", "right", "money:€");//½«Êý¾ÝÒÔÖu״ͼÏÔʾ 
    $objGrid->FormatColumn("workeddays", "Work days", 5, 2, 0, "50", "right", "chart:percent:val:31"); 
    $objGrid->checkable(); 
    $objGrid->setHeader(); 
    $objGrid->ajax('silent'); 
    echo '<html> 
       <head><title>PHPDataGrid</title></head> 
       <body><div align="center"><br />'; 
    //Éu³ÉDataGrid 
    $objGrid->grid(); 
    echo '</div></body></html>';//¹Ø±ÕÊý¾Ý¿aÁ¬½Ó 
    $objGrid->desconectar(); 
    ?> 

3. »uÓÚOracle¼o½e

¶ÔÓÚOracleµÄ¶ÁÈ¡Ö÷ÒªÊÇ°Ñphpmydatagrid.class.phpÖÐÓeMySQLÁ¬½ÓµÄº¯ÊýÐÞ¸ÄΪOracle£¬±¾ÆªÊÇͨ¹ýsqlrelay½øÐеÄOracleÁ¬½Ó£¬µ±È»Ò²¿ÉÒÔʹÓÃPHP×Ô´øµÄOCI8Ä£¿e£¨Ð§ÂÊÓÐÐ(C)µÍ£(C)£¬Ð޸ĺoÁi´aeΪphporadatagrid.class.php¼´¿ÉÔÚÆaËu³ÌÐo£¨datagrid_for_oracle.php£(C)Öе÷Óá£

ÒÔÉϾÍÊǽ̴o¼ÒPHPÈçºÎÖ±½ÓÐ޸ıiÄÚÈÝDataGrid¹¦ÄܵÄÈ«¹ý³Ì£¬»¹ÓжÔÊý¾Ý¿aµÄÁ˽a£¬Ï£Íu±¾ÎĶԴo¼ÒµÄѧϰÓÐËu°iÖu¡£