function displayGrid($tablename, $begin)
{
parent::openConnection();
if ($begin < strval($this->start) + strval($this->perPage)) {
$this->start = 0;
$this->end = strval($this->start) + strval($this->perPage);
} else {
$this->start = $begin;
$this->end = strval($this->start) + strval($this->perPage);
}
$this->sql = "SELECT * FROM `{$tablename}` Limit {$this->start},{$this->perPage}";
$this->rowOut = parent::query2DArray($this->sql);
$this->nr_rows = parent::queryNumRows();
$this->nr_cols = parent::queryNumCols();
echo "<center><table border=1 width={$this->tableWidth} bordercolor={$this->borderColor} cellpadding={$this->cellPadding} cellspacing={$this->cellSpacing}>\n";
// Get Column Headers ---------------
if ($this->showHeader == 1 && $this->customHeader == "") {
$this->sql = "SHOW COLUMNS FROM `{$tablename}`";
$this->colOut = parent::query2DArray($this->sql);
$this->nr_rows2 = count($this->colOut);
echo "<tr>";
for ($i = 0; $i < $this->nr_rows2; $i++) {
echo "<td><center><b>" . $this->colOut[$i][0] . "</b></center></td>";
}
echo "</tr>\n";
} elseif ($this->showHeader == 1 && $this->customHeader != "") {
$cHeader = explode("|", $this->customHeader);
$this->nr_rows2 = count($cHeader);
echo "<tr>";
for ($i = 0; $i < $this->nr_rows2; $i++) {
echo "<td><center><b>" . $cHeader[$i] . "</b></center></td>";
}
echo "</tr>\n";
}
// Show Detail ----------------------
for ($i = 0; $i < $this->nr_rows; $i++) {
echo "<tr>";
for ($j = 0; $j < $this->nr_cols; $j++) {
echo "<td> " . $this->rowOut[$i][$j] . "</td>\n";
}
echo "</tr>\n";
}
echo "<br><br><tr><td colspan={$this->nr_cols}><center>\n";
if ($this->start > 0) {
echo "<a href=\"" . $_SERVER['PHP_SELF'] . "?st=" . ($this->start - $this->perPage) . "\"><b><<</b></a>";
}
echo " <b> | </b> <a href=\"" . $_SERVER['PHP_SELF'] . "?st=" . (strval($this->start) + strval($this->perPage)) . "\"><b>>></b></a>";
echo "</center></tr>\n";
echo "</table></center>\n<br><br>\n";
parent::closeConnection();
}
///////////////////////////////////
// Example to Show How to get 2D
// Array AKA Recordset from a
// Database and output to screen
///////////////////////////////////
include "dbclass.php";
$a = new dbClass('localhost', 'test', 'root', 'password');
$rowOut = array();
$tblList = array();
$dbList = array();
// Set connection variables and open database connection ------------------------------------
$a->openConnection();
// Execute Single Row Query and display results ---------------------------------------------
$sql = "SELECT * FROM `test1`";
$rowOut = $a->query2DArray($sql);
$nr_rows = $a->queryNumRows();
// Number of rows in dataset
$nr_cols = $a->queryNumCols();
// Number of columns in dataset
echo "<table border=1 bordercolor=black>";
for ($i = 0; $i < $nr_rows; $i++) {
echo "<tr>";
for ($j = 0; $j < $nr_cols; $j++) {
echo "<td>" . $rowOut[$i][$j] . "</td>";
}
echo "</tr>";
}
echo "</table><br><br>";
echo "<b>Number of Columns in Query is:</b> " . $nr_cols . "<br>";
echo "<b>Number of Rows in Query is:</b> " . $nr_rows . "<br>";
$a->closeConnection();
// of rows returned for a query
// and how to Insert a new record
// into an existing database table
/////////////////////////////////////
include "dbclass.php";
$a = new dbClass('localhost', 'test', 'root', 'password');
$rowOut = array();
$tblList = array();
$dbList = array();
$numRows = 0;
// Set connection variables and open database connection ------------------------------------
$a->openConnection();
// Execute Single Row Query and display results ---------------------------------------------
$sql = "SELECT * FROM `test1`;";
$rowOut = $a->queryRowArray($sql);
// Count the number of rows returned in a query ----------------------------------------------
$numRows = $a->queryNumRows();
$numCols = $a->queryNumCols();
echo "<table border=1 bordercolor=black>";
for ($i = 0; $i < $numCols; $i++) {
echo "<tr><td><b>Column {$i}:</b></td><td>" . $rowOut[$i] . "</td></tr>";
}
echo "</table><br><br>";
echo "<b>Number of Columns in Query is:</b> " . $numCols . "<br>";
echo "<b>Number of Rows in Query is:</b> " . $numRows . "<br>";
// Execute an SQL command like INSERT or UPDATE ----------------------------------------------
$a->execCommand("INSERT INTO `test1` (column1,column2,column3,column4) VALUES ('1','2','3','4');");
$a->closeConnection();
?>