<?php require_once "../conf.php"; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>PHP Datagrid - Set Column Alignment</title> </head> <body> <?php $dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders"); $dg->set_col_align("status", "center"); $dg->set_col_align("customerNumber", "right"); $dg->display(); ?> </body> </html>
// Always the first line in the grid section $dg = new C_DataGrid("SELECT * FROM formstack", "pk", "formstack"); // change default caption $dg->set_caption("Orders List"); // change column titles $dg->set_col_title("pk", "Row No."); $dg->set_col_title("OrderNumber", "Order Number"); $dg->set_col_title("DateTime", "Date Time"); $dg->set_col_title("FirstName", "First Name"); $dg->set_col_title("LastName", "Last Name"); $dg->set_col_title("Address1", "Address 1"); $dg->set_col_title("Address2", "Address 2"); $dg->set_col_title("AddressCity", "City"); $dg->set_col_title("AddressState", "State"); $dg->set_col_title("AddressZip", "Zip"); $dg->set_col_align('email', 'EMail'); $dg->set_col_title("InstallerRating", "Installer Rating"); $dg->set_col_title("InstallType", "Install Type"); $dg->set_col_title("THDStoreNumber", "THD Store #"); $dg->set_col_title("FormstackImage1", "Image 1"); $dg->set_col_title("FormstackImage2", "Image 2"); $dg->set_col_title("FormstackImage3", "Image 3"); $dg->set_col_title("FormstackImage4", "Image 4"); $dg->set_col_title("FormstackImage5", "Image 5"); $dg->set_col_title("FormstackImage6", "Image 6"); $dg->set_col_title("FormstackImage7", "Image 7"); $dg->set_col_title("FormstackImage8", "Image 8"); $dg->set_col_title("BeforeAfter1", "Upload 1"); $dg->set_col_title("BeforeAfter2", "Upload 2"); $dg->set_col_title("BeforeAfter3", "Upload 3"); $dg->set_col_title("BeforeAfter4", "Upload 4");