|
Search the Fire Ring
Support theFireRing.com by shopping at amazon.com
Just shop as you normally would but start by clicking on the link above.
|
user = $user;
$this->pass = $pass;
$this->host = $host;
$this->db = $db;
}
function Create ($db) {
if (!$this->user) {
# Set this to your default username
#$this->user = "u70316192"; #this is for netfirms
$this->user = "u70316192"; #this is for local
}
if (!$this->pass) {
# Set this to your default password
$this->pass = "4c37aa";
}
if (!$this->host) {
# Set this to your default database host
$this->host = "sharedwebsites.netfirmsmysql.com";
}
if (!$this->db && !$db) {
# Set this to your default database
$this->db = "d60291058";
} else {
$this->db = $db;
}
$this->id = @mysql_pconnect($this->host, $this->user, $this->pass) or
MySQL_ErrorMsg("Unable to connect to MySQL server: $this->host : '$SERVER_NAME'");
$this->selectdb($this->db);
}
function SelectDB ($db) {
@mysql_select_db($db, $this->id) or
MySQL_ErrorMsg ("Unable to select database: $db");
}
# Use this function is the query will return multiple rows. Use the Fetch
# routine to loop through those rows.
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 QueryItem ($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);
$this->data = @mysql_fetch_array($this->result) or
MySQL_ErrorMsg ("Unable to fetch data from query: $query");
return($this->data[0]);
}
# This function is useful if the query will only return a
# single row.
function QueryRow ($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);
$this->data = @mysql_fetch_array($this->result) or
//MySQL_ErrorMsg ("Unable to fetch data from query: $query");
MySQL_ErrorMsg ("There was problem with your request.");
return($this->data);
}
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 InsertID () {
return mysql_insert_id();
}
function Update ($query) {
$this->result = @mysql_query($query, $this->id) or
MySQL_ErrorMsg ("Unable to perform update: $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) {
# Close out a bunch of HTML constructs which might prevent
# the HTML page from displaying the error text.
// echo("\n");
// echo(" \n");
# Display the error message
$text = "Error: $msg :";
$text .= mysql_error();
$text .= " \n";
//$text = "Error accessing Database";
$text .= mysql_error();
$text .= " \n";
die($text);
}
?> |
Hike For Discovery
Team In Training - HIKE