Datagrid Class

[munky334]

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]

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]

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]