datagrid PHP Code Examples

Example #1

0

Show file

File: sample12.php Project: n-sakib/avijatryerp

For more info, samples, tips, screenshots, help, contact, forum, please visit phpMyDataGrid site  
http://www.gurusistemas.com/indexdatagrid.php

For contact author: tavoarcila at gmail dot com or info at gurusistemas dot com
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>phpMyDatagrid - Sample file</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
$objGrid->friendlyHTML();
$objGrid->pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->total("salary,workeddays");
$objGrid->searchby("id,name,lastname,afiliation");
$objGrid->linkparam("sess=" . $_REQUEST["sess"] . "&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
$objGrid->conectadb("127.0.0.1", "phpclasses", "test", "guru");
$objGrid->tabla("employees");
$objGrid->buttons(true, true, true, true);
$objGrid->keyfield("id");
$objGrid->salt("Some Code4Stronger(Protection)");

Example #2

0

Show file

File: sample1.php Project: n-sakib/avijatryerp

For contact author: tavoarcila at gmail dot com or info at gurusistemas dot com
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>phpMyDatagrid - Sample file</title>

<?php 
/* Include class file */
include "phpmydatagrid.class.php";
/* Create object */
$objGrid = new datagrid();
/* Define the "FORM" will be named employee and Must be 
   created by the grid script */
$objGrid->form('employee', true);
/* Connect with the database */
$objGrid->conectadb("127.0.0.1", "phpclasses", "test", "guru");
/* Select the table to use */
$objGrid->tabla("employees");
/* Define fields to show */
$objGrid->FormatColumn("id", "ID Employee", 5, 5, 1, "50", "center");
$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");
$objGrid->FormatColumn("afiliation", "Afiliation Date", 10, 10, 0, "100", "center", "date:dmy:/");
$objGrid->FormatColumn("status", "Status", 5, 5, 0, "60", "left");
$objGrid->FormatColumn("active", "Active", 2, 2, 0, "50", "center");

Example #3

0

Show file

File: option_page_custome_redirection_list.php Project: adwleg/site

		<td align="right">
		<input onkeyup="if (event.keyCode == 13) go_search();" style="height: 30px;" id="search" type="text" name="search" value="<?php 
echo htmlentities($util->get('search'), ENT_QUOTES);
?>
" size="40">
		<a onclick="go_search()" href="#"><div class="search_link">Search</div></a> 
		<a href="<?php 
echo htmlentities($util->get_current_parameters('search'), ENT_QUOTES);
?>
"><div class="see_link">Show All</div></a>
		</td>
	</tr>
</table>
</div>
<?php 
$grid = new datagrid();
$grid->set_data_source($table_name);
$grid->add_select_field('ID');
$grid->add_select_field('redirect_from');
$grid->add_select_field('redirect_from_type');
$grid->add_select_field('redirect_to');
$grid->add_select_field('redirect_to_type');
$grid->add_select_field('enabled');
$grid->set_table_attr('width', '100%');
$grid->set_col_attr(5, 'width', '50px');
$grid->set_col_attr(3, 'width', '50%');
$grid->set_col_attr(4, 'width', '50%');
$grid->set_col_attr(5, 'width', '50px', 'header');
$grid->set_col_attr(1, 'width', '20px', 'header');
$grid->set_col_attr(2, 'width', '20px', 'header');
$grid->set_order(" ID desc ");

Example #4

0

Show file

File: index.php Project: Esleelkartea/arotz

<?php

include "local.php";
error_reporting(E_ALL);
$p = new aworkspage();
$sf = new scaffold("pedidos");
$p->addWidget(html::write("<h1>Bienvenid@</h1>"));
$d = new datagrid("pedido", "pedido.php?");
$d->toolbar = false;
$sf->__query = "SELECT * FROM pedidos order by estado";
$d->objectField("idmodelo", new scaffold("modelos"), "referencia");
$d->objectField("idmadera", new scaffold("maderas"), "referencia");
$d->specialField("fecha", "timestamp", "date", "html");
$d->headers("tipo_pedido", "Tipo de Pedido");
$d->specialField("tipo_pedido", "tipo_pedido", "ooentity", "tipowidget");
$d->headers("estado", "Estado");
$d->headers("cliente", "Cliente");
$d->headers("referencia", "Referencia");
$d->hideField("observaciones");
$d->hideField("otro_material");
$d->specialField("estado", "estado", ooentity, estadolistwidget);
$d->specialField("fecha_pedido", "timestamp", date, html);
$d->specialField("fecha_entrega_prevista", "timestamp", date, html);
$d->specialField("fecha_entrega", "timestamp", date, html);
$d->headers("fecha_entrega", "Fecha de Entrega");
$d->headers("fecha_entrega_prevista", "Fecha de Entrega Prevista");
$d->headers("fecha_pedido", "Fecha de Pedido");
$b = new Box("Pedidos en Cartera");
$d->drop($sf);
$t = new toolbar();
$t->addWidget(new button("A&ntilde;adir Pedido", "pedido_add.php", "add"));

Example #5

0

Show file

File: option_page_404.php Project: nhathong1204/bdshungthinh

		<input onkeyup="if (event.keyCode == 13) go_search();" style="height: 30px;" id="search" type="text" name="search" value="<?php 
echo $util->get('search');
?>
" size="40">
		<a onclick="go_search()" href="#"><div class="search_link">Search</div></a> 
		<a href="<?php 
echo $util->get_current_parameters('search');
?>
"><div class="see_link">Show All</div></a>
		</td>
	</tr>
</table>
</div>
<?php 
$table_name = $table_prefix . 'WP_SEO_404_links';
$grid = new datagrid();
$grid->set_data_source($table_name);
$grid->add_select_field('ID');
$grid->add_select_field('link');
$grid->add_select_field('referrer');
$grid->set_order(" ID desc ");
if ($util->get('search') != '') {
    $search = $util->get('search');
    $grid->set_filter(" link like '%%{$search}%%' or ctime like '%%{$search}%%'\n\t\tor referrer like '%%{$search}%%'   or country like '%%{$search}%%'   or ip like '%%{$search}%%'\n\t\tor os like '%%{$search}%%' or browser like '%%{$search}%%'\n\t\t ");
}
$grid->set_table_attr('width', '100%');
$grid->set_col_attr(1, 'width', '140px');
$grid->set_col_attr(1, 'align', 'center');
$grid->set_col_attr(3, 'width', '20px');
$grid->set_col_attr(3, 'align', 'center');
$grid->set_col_attr(4, 'align', 'center');

Example #6

0

Show file

File: sell_memo.php Project: n-sakib/avijatryerp

For more info, samples, tips, screenshots, help, contact, forum, please visit phpMyDataGrid site  
http://www.gurusistemas.com/indexdatagrid.php

For contact author: tavoarcila at gmail dot com or info at gurusistemas dot com
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>avijatry inventory</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry");
/* Select the table to use */
$objGrid->tabla("sell_memos");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->total("total_qty");
$objGrid->searchby("table_index,factory_name");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */

Example #7

0

Show file

File: datagrid.test.php Project: BackupTheBerlios/thinkedit-svn

<?php

require_once '../thinkedit.init.php';
require_once '../class/datagrid.class.php';
require_once '../class/page.class.php';
$page = new page();
$datagrid = new datagrid();
$datagrid->addColumn('firstname', 'First name', true, true);
$datagrid->addColumn('lastname', 'Last name', true, true);
$datagrid->addColumn('title', 'Last name', true, true);
for ($i = 1; $i < 1000; $i++) {
    $data['firstname'] = rand(1, 100);
    $data['lastname'] = rand(1, 100);
    $data['title'] = rand(1, 100);
    $datagrid->add($data);
}
$page->startPanel('test');
$page->add($datagrid->render('icon'));
$page->endPanel('test');
echo $page->render();

Example #8

0

Show file

File: sample6.php Project: n-sakib/avijatryerp

For more info, samples, tips, screenshots, help, contact, forum, please visit phpMyDataGrid site  
http://www.gurusistemas.com/indexdatagrid.php

For contact author: tavoarcila at gmail dot com or info at gurusistemas dot com
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>phpMyDatagrid - Sample file</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
$objGrid->friendlyHTML();
$objGrid->pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->total("salary,workeddays");
$objGrid->searchby("id,name,lastname,afiliation");
$objGrid->linkparam("sess=" . $_REQUEST["sess"] . "&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
$objGrid->conectadb("127.0.0.1", "phpclasses", "test", "guru");
$objGrid->tabla("employees");
$objGrid->TituloGrid("phpMyDataGrid Sample page");
$objGrid->FooterGrid("<div style='float:left'>&copy; 2007 Gurusistemas.com</div>");
/* Define the number of rows to show per page */

Example #9

0

Show file

File: test.php Project: n-sakib/avijatryerp

For contact author: tavoarcila at gmail dot com or info at gurusistemas dot com
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>phpMyDatagrid - Sample file</title>

<?php 
/* Include class file */
include "phpmydatagrid.class.php";
/* Create object */
$objGrid = new datagrid();
/* Define the "FORM" will be named employee and Must be 
   created by the grid script */
$objGrid->form('employee', true);
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry_beta_v2");
/* Select the table to use */
$objGrid->tabla("factories");
/* Define fields to show */
$objGrid->FormatColumn("table_index", "ID Employee", 5, 5, 1, "50", "center");
$objGrid->FormatColumn("factory_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");
	$objGrid -> FormatColumn("afiliation", "Afiliation Date", 10, 10, 0, "100", "center", "date:dmy:/");
	$objGrid -> FormatColumn("status", "Status", 5, 5, 0, "60", "left");
	$objGrid -> FormatColumn("active", "Active", 2, 2, 0,"50", "center");

Example #10

0

Show file

File: bankLog.php Project: n-sakib/avijatryerp

For more info, samples, tips, screenshots, help, contact, forum, please visit phpMyDataGrid site  
http://www.gurusistemas.com/indexdatagrid.php

For contact author: tavoarcila at gmail dot com or info at gurusistemas dot com
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>avijatry inventory</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry");
/* Select the table to use */
$objGrid->tabla("bank_log");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->searchby("table_index,bank_name");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */
$objGrid->buttons(true, true, true, true);

Example #11

0

Show file

File: option_page_history.php Project: nhathong1204/bdshungthinh

		<input onkeyup="if (event.keyCode == 13) go_search();" style="height: 30px;" id="search" type="text" name="search" value="<?php 
echo $util->get('search');
?>
" size="40">
		<a onclick="go_search()" href="#"><div class="search_link">Search</div></a> 
		<a href="<?php 
echo $util->get_current_parameters('search');
?>
"><div class="see_link">Show All</div></a>
		</td>
	</tr>
</table>
</div>

<?php 
$grid = new datagrid();
$grid->set_data_source($table_name);
$grid->set_order(" ID desc ");
if ($util->get('search') != '') {
    $search = $util->get('search');
    $grid->set_filter(" rfrom like '%%{$search}%%' or rto like '%%{$search}%%' or ctime like '%%{$search}%%'\n\t\tor referrer like '%%{$search}%%'   or country like '%%{$search}%%'   or ip like '%%{$search}%%'\n\t\tor os like '%%{$search}%%' or browser like '%%{$search}%%' or rsrc like '%%{$search}%%' or rtype like '%%{$search}%%' \n\t\t ");
}
$grid->add_select_field('rID');
$grid->add_select_field('postID');
$grid->add_select_field('referrer');
$grid->add_select_field('country');
$grid->add_select_field('ip');
$grid->add_select_field('os');
$grid->add_select_field('browser');
$grid->add_select_field('rsrc');
$grid->add_select_field('rfrom');

Example #12

0

Show file

File: sample11.php Project: n-sakib/avijatryerp

For more info, samples, tips, screenshots, help, contact, forum, please visit phpMyDataGrid site  
http://www.gurusistemas.com/indexdatagrid.php

For contact author: tavoarcila at gmail dot com or info at gurusistemas dot com
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>phpMyDatagrid - Sample file</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
$objGrid->friendlyHTML();
$objGrid->pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->total("salary,workeddays");
$objGrid->searchby("id,name,lastname,afiliation");
$objGrid->linkparam("sess=" . $_REQUEST["sess"] . "&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry_beta_v2");
/* Select the table to use */
$objGrid->tabla("factories");
$objGrid->buttons(true, true, true, true);

Example #13

0

Show file

File: list.php Project: BackupTheBerlios/thinkedit-svn

require_once ROOT . '/class/datagrid.class.php';
$page = new page();
$page->startPanel('title', 'title');
$page->add('Thinkedit 2.0');
$page->endPanel('title');
$module_selector = new dropdown();
$module_selector->setId('module_list');
$module_selector->setTitle('Choisissez un type d\'élément à éditer');
$modules = $thinkedit->getModuleList();
$module_selector->persist();
foreach ($modules as $module) {
    $module_selector->add($module, $module);
}
$page->startPanel('module_list');
$page->add($module_selector->render());
$page->endPanel('module_list');
if ($module_selector->getSelected()) {
    $list = new modulelist();
    $list->setType($module_selector->getSelected());
    $modules = $list->load();
    $datagrid = new datagrid();
    $datagrid->addColumn('id', 'Id');
    $datagrid->addColumn('title', 'Title');
    foreach ($modules as $module) {
        $datagrid->add($module->getArray());
    }
    $page->startPanel('datagrid');
    $page->add($datagrid->render());
    $page->endPanel('datagrid');
}
echo $page->render();

Example #14

0

Show file

File: sample3.php Project: n-sakib/avijatryerp

For more info, samples, tips, screenshots, help, contact, forum, please visit phpMyDataGrid site  
http://www.gurusistemas.com/indexdatagrid.php

For contact author: tavoarcila at gmail dot com or info at gurusistemas dot com
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>phpMyDatagrid - Sample file</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
$objGrid->friendlyHTML();
$objGrid->pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
/* Define the amount of decimal characters to show in numeric fields */
$objGrid->decimalDigits(2);
/* Define the decimal character to use in numeric fields */
$objGrid->decimalPoint(",");
$objGrid->conectadb("127.0.0.1", "phpclasses", "test", "guru");
$objGrid->tabla("employees");
$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");
$objGrid->FormatColumn("afiliation", "Afiliation Date", 10, 10, 0, "100", "center", "date:dmy:/");

Example #15

0

Show file

File: purchase_memo.php Project: n-sakib/avijatryerp

For more info, samples, tips, screenshots, help, contact, forum, please visit phpMyDataGrid site  
http://www.gurusistemas.com/indexdatagrid.php

For contact author: tavoarcila at gmail dot com or info at gurusistemas dot com
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>avijatry inventory</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry");
/* Select the table to use */
$objGrid->tabla("purchase_memos");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->total("total_qty");
$objGrid->searchby("table_index,factory_name");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */

Example #16

0

Show file

File: expenses.php Project: n-sakib/avijatryerp

For more info, samples, tips, screenshots, help, contact, forum, please visit phpMyDataGrid site  
http://www.gurusistemas.com/indexdatagrid.php

For contact author: tavoarcila at gmail dot com or info at gurusistemas dot com
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>avijatry inventory</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry");
/* Select the table to use */
$objGrid->tabla("other_expenses");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->searchby("table_index,expense_name");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */
$objGrid->buttons(true, true, true, true);

Example #17

0

Show file

File: inventory_db.php Project: n-sakib/avijatryerp

For more info, samples, tips, screenshots, help, contact, forum, please visit phpMyDataGrid site  
http://www.gurusistemas.com/indexdatagrid.php

For contact author: tavoarcila at gmail dot com or info at gurusistemas dot com
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>avijatry inventory</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry");
/* Select the table to use */
$objGrid->tabla("inventory");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->total("total_qty");
$objGrid->searchby("table_index,factory_name,pid");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */

Example #18

0

Show file

File: sample15.php Project: n-sakib/avijatryerp

BUT NOT LIMITED TO,  THE IMPLIED WARRANTIES  OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.  IN NO EVENT
SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,  INDIRECT,  INCIDENTAL, SPECIAL, EXEMPLARY,  OR CONSEQUENTIAL 
DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF  USE, DATA, OR PROFITS;  OR BUSINESS 
INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE 
OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. 

Please remember donating is one way to show your support, copy and paste in your internet browser the following link to make your donation
https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=tavoarcila%40gmail%2ecom&item_name=phpMyDataGrid%202007&no_shipping=0&no_note=1&tax=0&currency_code=USD&lc=US&bn=PP%2dDonationsBF&charset=UTF%2d8

For more info, samples, tips, screenshots, help, contact, forum, please visit phpMyDataGrid site  
http://www.gurusistemas.com/indexdatagrid.php

For contact author: tavoarcila at gmail dot com or info at gurusistemas dot com
*/
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
$objGrid->closeTags(true);
$objGrid->friendlyHTML();
$objGrid->methodForm("get");
$objGrid->conectadb("127.0.0.1", "phpclasses", "test", "guru");
$objGrid->salt("Myc0defor5tr0ng3r-Pro3EctiOn");
$objGrid->language("en");
$objGrid->buttons(true, false, true, false);
$objGrid->form('employee', true);
$objGrid->searchby("name,lastname");
$objGrid->tabla("employees");
$objGrid->keyfield("id");
$objGrid->datarows(20);
$objGrid->orderby("name", "ASC");
$objGrid->FormatColumn("id", "ID Employee", 5, 5, 1, "50", "center", "integer");
$objGrid->FormatColumn("name", "Name", 30, 30, 0, "150", "left");

Example #19

0

Show file

File: sample14.php Project: n-sakib/avijatryerp

For more info, samples, tips, screenshots, help, contact, forum, please visit phpMyDataGrid site  
http://www.gurusistemas.com/indexdatagrid.php

For contact author: tavoarcila at gmail dot com or info at gurusistemas dot com
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>phpMyDatagrid - Sample file</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry_beta_v2");
/* Select the table to use */
$objGrid->tabla("factories");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->total("table_index");
$objGrid->searchby("table_index,factory_name");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */

Example #20

0

Show file

File: inventory_config_types.php Project: n-sakib/avijatryerp

For more info, samples, tips, screenshots, help, contact, forum, please visit phpMyDataGrid site  
http://www.gurusistemas.com/indexdatagrid.php

For contact author: tavoarcila at gmail dot com or info at gurusistemas dot com
*/
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>avijatry inventory</title>

<?php 
include "phpmydatagrid.class.php";
$objGrid = new datagrid();
/* Connect with the database */
$objGrid->conectadb("localhost", "root", "", "avijatry");
/* Select the table to use */
$objGrid->tabla("inventory_config_types");
$objGrid->friendlyHTML();
//$objGrid -> pathtoimages("./images/");
$objGrid->closeTags(true);
$objGrid->form('employee', true);
$objGrid->methodForm("post");
$objGrid->total("total_qty");
$objGrid->searchby("table_index,factory_name");
//$objGrid -> linkparam("sess=".$_REQUEST["sess"]."&username="******"username"]);
$objGrid->decimalDigits(2);
$objGrid->decimalPoint(",");
/* Select the table to use */

Example #21

0

Show file

File: datagrid_for_oracle.php Project: u0mo5/app

<?php

include "phporadatagrid.class.php";
$objGrid = new datagrid();
$objGrid->closeTags(true);
$objGrid->friendlyHTML();
$objGrid->methodForm("post");
$objGrid->conectadb();
$objGrid->salt("Myc0defor5tr0ng3r-Pro3EctiOn");
$objGrid->language("en");
$objGrid->buttons(true, true, true, false);
$objGrid->form('Add', true);
$objGrid->searchby("ID,NAME,LASTNAME,AGE,SALARY");
$objGrid->tabla("EMPLOYEES");
$objGrid->keyfield("ID");
$objGrid->orderby("ID", "ASC");
$objGrid->FormatColumn("ID", "ID", 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");
$objGrid->FormatColumn("SALARY", "Salary", 10, 10, 0, "90", "right", "2");
$objGrid->setHeader();
echo '<div align="center"><br />';
$objGrid->ajax('silent');
$objGrid->grid();
$objGrid->desconectar();
echo '</div>';

PHP datagrid Examples