Datagrid Class

munky334 · October 29, 2008

Hi there,

I found a datagrid class script on the internet and it is exactly what I am looking for , the problem is that I can get the script to run. The localhost returns no errors or anything but just displays a page with a whole bunch of characters and things that don't make sense. I'm running PHP 5.2.6 on a wampserver configuration so I'm not too sure if this is perhaps causing a problem. I really need to get this datagrid to work as it will solve a lot of my issues with regards to displaying my data. It's vital that I get this script to work and I have been trying for days now , very frustrating! Please can someone have a look , I would really appreciate it.

Thanking you in advance.

_test.php

_<?

_{include_once("DBinit.php");}

_{include_once("datagrid.class.php");}

_?>

_{<form name="frmAction" action="" method="POST">}

_{<h2>Sections</h2>}

_{<span class='normalTxt <?=$color?>'><?=$t_messg?></span>}

_<?

_{//datagrid for existing sections}

_{$dbp = new flor_db_process();}

_{$query = "select * from patientdemo";}

_{$dbp->fetchQuery($query);}

_{$gridData = $dbp->resultSet;}

_{$dg = new DataGrid($gridData);}

_{$dg->width = "300";}

_{$dg->fontSize = .8;}

_{$dg->autoColumns = false;}

_{$dg->paging = true;}

_{$dg->paging_byPageNos = true;}

_{$dg->paging_NoOfRows = 3;}

_{$dg->borderColor = "gray"; //or values like #C0C0C0}

_{$dg->borderStyle = "dotted"; //or solid, or dashed, etc.,}

_{$dg->borderWidth = 1; //integer}

_{$dg->cellPadding = 2; //integer}

_{$dg->headBackgroundColor = "#FFFFCC"; //or values like green}

_{$dg->headForeColor = "green"; //or values like #FFFFFF}

_{$dg->fontSize = .8; //integer}

_{$dg->fontFamily = "courier new"; //or Arial, verdana, etc.,}

_{$dg->colSet[0] = new Column();}

_{$dg->colSet[0]->displayName = "Headline";}

_{$dg->colSet[0]->fieldName = "dispName";}

_{$dg->colSet[0]->width = "70%";}

_{$dg->colSet[1] = new Column();}

_{$dg->colSet[1]->displayName = "Code";}

_{$dg->colSet[1]->fieldName = "positionCode";}

_{$dg->colSet[1]->width = "30%";}

_{$dg->showGrid();}

_?>

_</form>

^DBinit.php

^<?

^{include_once("flor_db_process.class.php");}

^{define ("DB_DOMAIN","localhost");}

^{//define ("DB_PORT", 3306);}

^{define ("DB_USER","root");}

^{define ("DB_PASS","");}

^{define ("DB_NAME","patient");}

^?>

_{DataGrid.class.php}

_<?

_{/* -----------------------------------------------}

_{* Author: Harish Palaniappan, Floresense.com}

_{* Ver: 1.1}

_{* Last Updated: Jan 2008}

_{* License: LGPL License}

_{* You are free to use/modify/redistribute this script. Keep this comment block intact.}

_{* ----------------------------------------------}

_*

_{* add your own comments here..}

_*

_*/

_{class DataGrid{}

_//vars

_{private $gridHTML = "";}

_{public $columnCount = 0;}

_{public $rowCount = 0;}

_{private $colInfo = null;}

_{private $fontStyle = "";}

_{private $curRowId = -1;}

_{private $curColId = -1;}

_//properties

_{public $width = "100%";}

_{public $autoColumns = true;}

_{public $resultSet = null;}

_{public $fontSize = 1;}

_{public $fontFamily = "Verdana";}

_{public $borderWidth = 1;}

_{public $borderStyle = "solid";}

_{public $borderColor = "black";}

_{public $cellPadding = 2;}

_{public $headBackgroundColor = "#5B59B7";}

_{public $headForeColor = "#FFFFFF";}

_{public $paging_indexAtTop = true;}

_{public $paging_indexAtBottom = true;}

_{public $pageByName = false;}

_{public $pageByName_field = "";}

_{private $curPgAlphaIndex = "";}

_{private $pgAlphaIndexKeys = null;}

_{public $paging = false;}

_{public $paging_byPageNos = false;}

_{public $paging_byNextPrev = false;}

_{public $paging_NoOfRows = 30;}

_{private $curPgIndex = 1;}

_{private $totPages = 1;}

_{public $colSet = array();}

_{public $rowSet = array();}

_{public $dataKey = null;}

_//events

_{public $onRowItem_Bound = null;}

_{function DataGrid($resultSet=null)}

_{

_{$this->resultSet = $resultSet;}

_}

_{function showGrid()}

_{

_{$this->makeGrid();}

_{echo $this->gridHTML;}

_}

_{function makeGrid()}

_{

_{//get params}

_{$gridAction = $_POST['flor_grid_a'];}

_{$gridVal = $_POST['flor_grid_aV'];}

_{if ($gridAction)}

_{

_{$gridAction = strtoupper($gridAction);}

_{switch($gridAction)}

_{

_{case "PGA":}

_{$this->curPgAlphaIndex = strtoupper($gridVal);}

_break;

_{case "PG":}

_{$this->curPgIndex = $gridVal;}

_break;

_}

_{$this->gridHTML = "";}

_{$this->fontStyle="font-size:".$this->fontSize."em;font-family:".$this->fontFamily.";";}

_{$this->initDataInfo();}

_{if ($this->paging_indexAtTop)}

_{if ($this->paging || $this->pageByName)}

_{$this->gridHTML .= $this->getPagingHTML();}

_{$this->gridHTML .= $this->getTableHTML("OPEN");}

_{$this->gridHTML .= $this->getDataHTML();}

_{$this->gridHTML .= $this->getTableHTML("CLOSE");}

_{if ($this->paging_indexAtBottom)}

_{if ($this->paging || $this->pageByName)}

_{$this->gridHTML .= $this->getPagingHTML();}

_{if ($this->paging || $this->pageByName)}

_{$this->gridHTML .= $this->getPaging_supportScripts();}

_}

_{private function getPagingHTML()}

_{

_{if ($this->pageByName)}

_{

_{$this->prepAlphabetIndex();}

_{if ($this->curPgAlphaIndex=="" && count($this->pgAlphaIndexKeys)>0)}

_{$this->curPgAlphaIndex = $this->pgAlphaIndexKeys[1];}

_{return $this->getAlphabetIndex_HTML();}

_}

_{elseif($this->paging)}

_{

_{$this->prepPageIndex();}

_{return $this->getPageIndex_HTML();}

_}

_{private function prepPageIndex()}

_{

_{$totRows = $this->resultSet->num_rows;}

_{$this->totPages = ceil($totRows/$this->paging_NoOfRows);}

_}

_{private function getPageIndex_HTML()}

_{

_{if ($this->paging_byPageNos)}

_{

_{$html = "<div style='padding:2px 5px 2px 5px;background-color:".$this->headBackgroundColor.";".}

_{"color:".$this->headForeColor.";width:".($this->width-10)."px;border:0px solid red;text-align:center;".}

_{"margin:10px 0px 0px 0px;'> Pages - ";}

_{for($idx = 1; $idx<=$this->totPages; $idx++)}

_{

_{$linkStr = "".$idx;}

_{if ($this->curPgIndex == $idx)}

_{$linkStr = "<span style='font-weight:bold;font-size:1.4em;'>$linkStr</span>";}

_else

_{$linkStr = "<a href=\"javascript:florDBgrid_action('pg',$idx);\" style='color:".$this->headForeColor.";'>".}

_{$linkStr."</a>";}

_{if ($idx == 1)}

_{$html .= $linkStr." ";}

_{elseif($idx == $this->totPages)}

_{$html .= " ".$linkStr." ";}

_else

_{$html .= " ".$linkStr." ";}

_}

_{elseif ($this->paging_byNextPrev)}

_{

_{$html = "<div style='padding:2px 5px 2px 5px;background-color:".$this->headBackgroundColor.";".}

_{"color:".$this->headForeColor.";width:".($this->width-10)."px;border:0px solid red;text-align:right;".}

_{"margin:10px 0px 0px 0px;'>";}

_{$prevPage = true; $nextPage = true;}

_{if ($this->curPgIndex == 1)}

_{$prevPage = false;}

_{if ($this->curPgIndex == $this->totPages)}

_{$nextPage = false;}

_{if ($prevPage)}

_{$html .= "<a href=\"javascript:florDBgrid_action('pg',".($this->curPgIndex-1).");\" style='color:".$this->headForeColor.";'>".}

_{"< Prev</a> ";}

_{if($nextPage)}

_{$html .= "<a href=\"javascript:florDBgrid_action('pg',".($this->curPgIndex+1).");\" style='color:".$this->headForeColor.";'>".}

_{"Next ></a>";}

_}

_{$html .= "</div>";}

_{return $html;}

_}

_{private function prepAlphabetIndex()}

_{

_{$db = new flor_db_process();}

_{$db->resultSet = $this->resultSet;}

_{$this->pgAlphaIndexKeys = array("");}

_while(1)

_{

_{$row = $db->getRow2();}

_{if (!$row)}

_break;

_{$tmpCellVal = $row[$this->pageByName_field];}

_{$tmpChar = strtoupper(substr($tmpCellVal,0,1));}

_{if (is_numeric($tmpChar) && !array_search("0-9",$this->pgAlphaIndexKeys))}

_{array_push($this->pgAlphaIndexKeys, "0-9");}

_{if (!array_search($tmpChar,$this->pgAlphaIndexKeys))}

_{array_push($this->pgAlphaIndexKeys, $tmpChar);}

_}

_{private function getAlphabetIndex_HTML()}

_{

_{$html = "<div style='padding:2px 5px 2px 5px;background-color:".$this->headBackgroundColor.";".}

_{"color:".$this->headForeColor.";width:".($this->width-10)."px;border:0px solid red;text-align:center;".}

_{"margin:10px 0px 0px 0px;'>";}

_{$alphabets = preg_split('//', "ABCDEFGHIJKLMNOPQRSTUVWXYZ", -1, PREG_SPLIT_NO_EMPTY);}

_{$chars = array("0-9");}

_{$chars = array_merge($chars,$alphabets);}

_{foreach($chars as $char)}

_{

_{$linkStr = $char;}

_{if ($this->curPgAlphaIndex == $char || (is_numeric($this->curPgAlphaIndex) && $char=="0-9"))}

_{$linkStr = "<span style='font-weight:bold;font-size:1.4em;'>$linkStr</span>";}

_{elseif (array_search($char,$this->pgAlphaIndexKeys))}

_{$linkStr = "<a href=\"javascript:florDBgrid_action('pga','$char');\" style='color:".$this->headForeColor.";'>".}

_{$linkStr."</a>";}

_{if ($char == "0-9")}

_{$html .= $linkStr." ";}

_{elseif($char =="Z")}

_{$html .= " ".$linkStr." ";}

_else

_{$html .= " ".$linkStr." ";}

_}

_{$html .= "</div>";}

_{return $html;}

_}

_{private function getPaging_supportScripts()}

_{

_{$html = <<<END}

_{<input type=hidden name=flor_grid_a id=flor_grid_a value=""/>}

_{<input type=hidden name=flor_grid_aV id=flor_grid_aV value=""/>}

_{<script language="javascript">}

_<!--//

_{function florDBgrid_action(action, value)}

_{

_{var F = document.forms['frmAction'];}

_{F.flor_grid_a.value = action;}

_{F.flor_grid_aV.value = value;}

_F.submit();

_}

_//-->

_</script>

_END;

_{return $html;}

_}

_{private function initDataInfo()}

_{

_{if ($this->autoColumns)}

_{

_{if ($this->resultSet)}

_{

_{$this->colInfo = $this->resultSet->fetch_fields();}

_{$this->columnCount = count($this->colInfo);}

_{for($i=0; $i<$this->columnCount; $i++)}

_{

_{$col = new Column();}

_{$col->fieldName = $this->colInfo[$i]->name;}

_{$this->colSet[$i] = $col;}

_}

_else

_{

_{$this->columnCount = count($this->colSet);}

_}

_{private function getDataHTML()}

_{

_{$tmpHTML = "";}

_{$db = new flor_db_process();}

_{$db->resultSet = $this->resultSet;}

_{$db->reset();}

_{$gridHeaderComplete = false;}

_{if (!$gridHeaderComplete)}

_{

_{$tmpHTML = $this->getHeaderHTML();}

_{$gridHeaderComplete = true;}

_}

_{if ($this->resultSet)}

_{

_{$this->rowCount = $this->resultSet->num_rows;}

_{if ($this->rowCount==0)}

_{$tmpHTML .= $this->getTableHTML("NODATA");}

_else

_{

_{while($tmpRow = $db->getRow2())}

_{

_{$this->curRowId++;}

_{if ($this->pageByName)}

_{

_{$tmpCellVal = $tmpRow[$this->pageByName_field];}

_{if (!$tmpCellVal)}

_{continue; //skip row}

_{$tmpStr1 = strtoupper(substr($tmpCellVal,0,1));}

_{if (is_numeric($tmpStr1) && $this->curPgAlphaIndex == "0-9")}

_{

_{//is numeric value}

_}

_{elseif ($tmpStr1 != strtoupper($this->curPgAlphaIndex))}

_{continue; //skip row}

_}

_{elseif($this->paging)}

_{

_{if ($this->curPgIndex == 1)}

_{$lowRowID = 0;}

_else

_{$lowRowID = (($this->curPgIndex-1) * $this->paging_NoOfRows)+1;}

_{$hiRowID = $this->curPgIndex * $this->paging_NoOfRows;}

_{if ($this->curRowId >= $lowRowID &&}

_{$this->curRowId <= $hiRowID)}

_{

_{//allow row.. it belongs to page}

_}

_else

_{continue; //skip row.}

_}

_{$tmpHTML .= $this->getDataRowHTML($tmpRow);}

_}

_else

_{$tmpHTML .= $this->getTableHTML("NODATA");}

_{//echo "*".$this->rowCount."*".$this->columnCount."*";}

_{//print_r($this->colInfo);}

_{return $tmpHTML;}

_}

_{private function getAddNewRowHTML()}

_{

_{///if ($this->resultSet)}

_{return "";}

_}

_{private function getDataRowHTML($rowData)}

_{

_{$t1 = "\n<tr>";}

_{$this->curColId = -1;}

_{$cells = array();}

_{foreach($this->colSet as $colItem)}

_{

_{$this->curColId++;}

_{if ($colItem->fieldName!=null)}

_{$cellContent = $rowData[$colItem->fieldName];}

_else

_{$cellContent = "";}

_{//row item bound event}

_{//call data_rowItem_bound event handler}

_{$cell = new cell();}

_{$cell->rowId = $this->curRowId;}

_{$cell->colId = $this->curColId;}

_{$cell->dataKey = $rowData[$this->dataKey];}

_{$cell->HTMLContent = $cellContent;}

_{array_push($cells, $cell);}

_}

_{if ($this->onRowItem_Bound != null)}

_{

_{$tmpFn = $this->onRowItem_Bound;}

_{$cells = $tmpFn($cells); //passing a row.. for each row this entire fn is called.}

_}

_$j=-1;

_{foreach($this->colSet as $colItem)}

_{

_$j++;

_{$t1 .= "\n<td style=\"".$this->fontStyle."\">\n".}

_{$cells[$j]->HTMLContent.}

_"\n</td>";

_}

_{$t1 .= "\n</tr>";}

_{return $t1;}

_}

_{private function getHeaderHTML()}

_{

_{if (!$this->colSet)}

_{return "";}

_{$t1 = "\n<tr>";}

_{$headStyle = "background-color:".$this->headBackgroundColor.";color:".}

_{$this->headForeColor.";";}

_{foreach($this->colSet as $colItem)}

_{

_{if ($colItem->displayName != null)}

_{$tmpText = $colItem->displayName;}

_else

_{$tmpText = $colItem->fieldName;}

_{if ($colItem->width!=null)}

_{$colW = "width='".$colItem->width."' ";}

_else

_{$colW = "";}

_{$t1 .= "\n<td $colW style=\"font-weight:bold;".$this->fontStyle.$headStyle."\">\n".}

_$tmpText.

_"\n</td>";

_}

_{$t1 .= "\n</tr>";}

_{return $t1;}

_}

_{private function getTableHTML($code)}

_{

_{switch(strtoupper($code))}

_{

_{case "OPEN":}

_{$pad = $this->cellPadding;}

_{$bw = $this->borderWidth;}

_{$bc = $this->borderColor;}

_{$bs = $this->borderStyle;}

_{return "<table border=$bw width=".$this->width." cellpadding=$pad ".}

_{"style=\"margin:10px 0px 10px 0px;border-collapse:collapse;border-style:$bs;\" borderColor='$bc'>";}

_break;

_{case "CLOSE":}

_{return "\n</table>";}

_break;

_{case "NODATA":}

_{if ($this->columnCount>1)}

_{$colspan= "colspan='".$this->columnCount."' ";}

_else

_{$colspan=" ";}

_{return "\n<tr>\n<td style='font-weight:bold;border:1px dotted gray;padding:4px;".}

_{$this->fontStyle."' $colspan>No Data</td>\n</tr>";}

_break;

_{case "ALPHA_INDEX":}

_{$this->prepAlphabetIndex();}

_{$tmpHTML = $this->getAlphabetIndex_HTML();}

_{if ($this->columnCount>1)}

_{$colspan= "colspan='".$this->columnCount."' ";}

_else

_{$colspan=" ";}

_{$tmpHTML = "\n<tr>\n<td style='font-weight:bold;border:1px dotted gray;padding:4px;".}

_{$this->fontStyle."' $colspan>".$tmpHTML."</td>\n</tr>";}

_{return $tmpHTML;}

_break;

_}

_{class column{}

_{public $displayName = null;}

_{public $fieldName = null;}

_{public $dataFormat = null;}

_{public $width = null;}

_{public $backgroundColor = null;}

_}

_{class cell{}

_{public $rowId = null;}

_{public $colId = null;}

_{public $dataKey = null;}

_{public $HTMLContent = null;}

_}

_?>

_{/* -----------------------------------------------}

_{* CLASS : flor_db_process}

_*

_{* Author: Harish Palaniappan, Floresense.com}

_{* Ver: 1.2 (earlier DBProcess ver 1.0)}

_{* Last Updated: Jan 2008}

_{* License: LGPL License ->}_{http://www.gnu.org/licenses/lgpl.html}

_{* License in brief: You are free to use/modify/redistribute this script.}

_{* Keep this comment block intact.}

_{* ----------------------------------------------}

_*

_{* add your own comments here..}

_*

_*/

_{class flor_db_process{}

_{var $query = "";}

_{var $isFetchMode = false;}

_{var $isUpdateMode = false;}

_{var $isInsertMode = false;}

_{var $resultSet = null;}

_{var $affRows=0;}

_{var $numRows=0;}

_{var $fieldCount = 0;}

_{var $errStr = "";}

_{var $hasErr = false;}

_{var $con = null;}

_{var $isDBConnected = false;}

_{function DBprocess2()}

_{

_{$this->openCon();}

_}

_{function openCon()}

_{

_{$this->closeCon();}

_{global $db;}

_{$dbname ="";}

_{$db_Domain;}

_{$dbname = $cmtDB;}

_{//connecting with mysqli}

_//

_{$this->con = mysqli_init();}

_{/* set connection options */}

_{$this->con->options(MYSQLI_INIT_COMMAND, "SET AUTOCOMMIT=0");}

_{$this->con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 5);}

_{/* connect to server */}

_{error_reporting(0);}

_{if (!defined("DB_DOMAIN") || !defined("DB_USER") || !defined("DB_PASS") || !defined("DB_NAME"))}

_{exit("include common.php?.. db connect info missing for DBProcess2");}

_{$this->con->real_connect(DB_DOMAIN,DB_USER,DB_PASS,DB_NAME,DB_PORT);}

_{error_reporting(E_ALL ^ E_NOTICE);}

_{if (mysqli_connect_errno())}

_{

_{$this->hasErr = true;}

_{$this->errStr = "Connect failed: \n" . mysqli_connect_error();}

_{exit($this->errStr);}

_}

_else

_{

_{$this->hasErr=false;}

_{$this->isDBConnected=true;}

_}

_{//function to close db connection}

_{function closeCon()}

_{

_{//disconnecting with mysqli}

_//

_{if ($this->isDBConnected)}

_{$this->con->close();}

_{$this->con=null;}

_}

_{function processQuery()}

_{

_{global $errReportingType;}

_{if (!$this->query)}

_{return null;}

_{if (!$this->con)}

_{$this->openCon();}

_{error_reporting(0);}

_{$tmpResult = $this->con->query($this->query);}

_{error_reporting($errReportingType);}

_{if ($this->con->error=="")}

_{

_{$this->hasErr = false;}

_{if ($this->isFetchMode)}

_{

_{$this->resultSet = $tmpResult;}

_{if ($tmpResult)}

_{

_{$this->numRows = $tmpResult->num_rows;}

_{$this->fieldCount = $this->field_count;}

_}

_else

_{$this->numRows = 0;}

_}

_{elseif($this->isUpdateMode)}

_{

_{$this->affRows = $this->con->affected_rows;}

_}

_{elseif($this->isInsertMode)}

_{

_{$this->affRows = $this->con->affected_rows;}

_{return $this->con->insert_id;}

_}

_else

_{

_{$this->hasErr = true;}

_{$this->errStr = $this->con->error;}

_{if (APPMODE!="live")}

_{$this->errStr = $this->query."___".$this->errStr;}

_{if ($this->isInsertMode)}

_{return null;}

_}

_{function fetchQuery($qry)}

_{

_{$this->query = $qry;}

_{$this->isFetchMode = true;}

_{$this->isUpdateMode = false;}

_{$this->isInsertMode =false;}

_{$this->processQuery();}

_}

_{function insertQuery($qry)}

_{

_{$this->query = $qry;}

_{$this->isFetchMode = false;}

_{$this->isUpdateMode = false;}

_{$this->isInsertMode = true;}

_{$insert_id = $this->processQuery();}

_{return $insert_id;}

_}

_{function updateQuery($qry)}

_{

_{$this->query = $qry;}

_{$this->isFetchMode = false;}

_{$this->isUpdateMode = true;}

_{$this->isInsertMode = false;}

_{$this->processQuery();}

_}

_{function getRow()}

_{

_{$row = $this->resultSet->fetch_row();}

_{if (isset($row))}

_{return $row;}

_else

_{return null;}

_}

_{function getRow2()}

_{

_{$row = $this->resultSet->fetch_assoc();}

_{if (isset($row))}

_{return $row;}

_else

_{return null;}

_}

_{function reset()}

_{

_{mysqli_data_seek($this->resultSet,0);}

_}

_?>

PFMaBiSmAd · October 29, 2008

The code was written using short open tags <? and <?= Which is sad really because code that is intended to be distributed must use full php tags <?php and <?php echo so that is will be parsed on all servers.

The fix is to go through the code and change any <? to <?php and any <?= to <?php echo

munky334 · October 30, 2008

thank you for this , my script appears to be running now but not displaying the results of the table. see image[/img]. regards.

[attachment deleted by admin]

Sign In

Datagrid Class

Recommended Posts

munky334

Link to comment

Share on other sites

PFMaBiSmAd

Link to comment

Share on other sites

munky334

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information