Set below to your db username
$this->user = "lazy";
// ------------------------->Set below to your db password
$this->pass = "pokolgep";
// ------------------------->Set below to your default database host
// (if colocated on the same machine as the
// server executing this script, "localhost"
// will work fine
$this->host = "localhost";
// ------------------------->Set below to your database where the table
// "gBook" should reside
$this->db = "gBook";
##############################################################################
# DONT TOUCH BELOW THIS LINE
$this->id = @mysql_pconnect($this->host, $this->user, $this->pass)
or
MySQL_ErrorMsg("Unable to connect to MySQL server: $this->host : '" . $_SERVER['SERVER_NAME'] . "'");
$this->selectdb($this->db);
}
function SelectDB($db) {
@mysql_select_db($db, $this->id)
or
MySQL_ErrorMsg("Unable to select database: $db");
}
function Query($query) {
$this->result = @mysql_query($query, $this->id)
or
MySQL_ErrorMsg("Unable to perform query: $query");
$this->rows = @mysql_num_rows($this->result);
$this->a_rows = @mysql_affected_rows($this->id);
}
/* Use this function if the query will only return a
single data element. */
function Fetch($row) {
@mysql_data_seek($this->result, $row)
or
MySQL_ErrorMsg("Unable to seek data row: $row");
$this->data = @mysql_fetch_array($this->result)
or
MySQL_ErrorMsg("Unable to fetch row: $row");
}
function Insert($query) {
$this->result = @mysql_query($query, $this->id)
or
MySQL_ErrorMsg("Unable to perform insert: $query");
$this->a_rows = @mysql_affected_rows($this->id);
}
function Delete($query) {
$this->result = @mysql_query($query, $this->id)
or
MySQL_ErrorMsg("Unable to perform Delete: $query");
$this->a_rows = @mysql_affected_rows($this->id);
}
}
/* MySQL_ErrorMsg
Print out an MySQL error message */
function MySQL_ErrorMsg($msg) {
echo "\n"
."\n";
// Display the error message
$text = "Error: $msg
\nMySQL said: \"" . mysql_error() . "\"
\n";
die($text);
}
# END MySQL INTERACTION CODE
##############################################################################
function printEntry($name,$email,$date,$comment,$id,$admin) {
echo "\n"
." \n"
."
| \n"
."
\n"
." \n"
." | $name | \n"
." \n"
." \n"
." \n"
." \n"
." | e-mail | \n"
." ![\"\"](\"pix.gif\") | \n"
." $date | \n"
." \n"
." \n"
." | \n"
."
\n"
." \n"
." | \n"
."
\n"
." \n"
." \n"
." \n"
." \n"
." ![\"\"](\"dot_w.gif\") | \n"
." $comment | \n"
." \n";
if ($admin == "yes") {
echo " \n"
." | \n"
." \n"
." *delete | \n"
." \n";
}
echo " | \n"
."
\n"
."
\n";
}
function viewAll($admin) {
require_once("functions.php");
$viewAll = new MySQL_class();
$viewAll->Connect("");
$viewAll->Query("SELECT * FROM gBook ORDER BY id DESC");
for ($i="0"; $i<$viewAll->rows; $i++) {
$viewAll->fetch($i);
$id = $viewAll->data[0];
$date = $viewAll->data[1];
$name = $viewAll->data[2];
$email = $viewAll->data[3];
$comment = $viewAll->data[4];
if ($admin == "yes") {
printEntry($name,$email,$date,$comment,$id,$admin);
}
else {
printEntry($name,$email,$date,$comment,"none",$admin);
}
}
}
?>