Jhoy Imperial and the Web

PHP Table Class

2008-02-06T19:18:00.000-08:00

Here is the link to my new class : PHP Table Class

Simple PHP Database Connection Class

2008-02-04T00:09:00.001-08:00

server  = $_DBINFO['server'];
$this->username = $_DBINFO['username'];
$this->password = $_DBINFO['password'];
$this->database = $_DBINFO['database'];
$this->connect();
}

//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
//xxxxx CREATES A SERVER CONNECTION xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
function connect(){
$this->conn = @mysql_connect($this->server, $this->username, $this->password);
if($this->conn == FALSE){
echo 'Cannot connect to server \''.$this->server.'\'.'; exit;
}
$dbconnect = @mysql_select_db($this->database, $this->conn);
if($dbconnect == FALSE){
echo 'Unable to connect to database \''.$this->database.'\''; exit;
}
}

//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
//xxxxx PROCESS SQL QUERY xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
function query($sql){
$this->query = @mysql_query($sql, $this->conn) or print_r(mysql_error());
}

//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
//xxxxx QUERY RESULT IN ARRAY FORM xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
function getRecord(){
$resultCount = mysql_num_rows($this->query);

if ($resultCount==1){
$result = @mysql_fetch_assoc($this->query);
}
else if ($resultCount > 1){
while($row = @mysql_fetch_assoc($this->query)){
$result[]=$row;
}
}
else{
$result = NULL;
}
return $result;
}

//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
//xxxxx GET TOTAL RESULT COUNT xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
function query_count(){
return @mysql_num_rows($this->query);
}

//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
//xxxxx GET LAST INSERTED ID xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
function last_insert_id(){
return @mysql_insert_id($this->conn);
}

//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
//xxxxx RETURN ONLY ONE SPECIFIC FIELD xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
function getField($fieldname){
while($row = @mysql_fetch_assoc($this->query)){
$result[]=$row[$fieldname];
}
return $result;
}
}

//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
//xxxxx HOW-TO-USE xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
// A simple demo on how to use this module
// DIRECTION: download file and save then remove the ".txt" extension to be saved as a php file
//xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
/*
// ASSIGN DATABASE SERVER INFO INTO ARRAY VALUES
$serverInfo['server']  = 'localhost';
$serverInfo['username'] = 'root';
$serverInfo['password'] = '';
$serverInfo['database'] = 'rednixchat';

// CREATE NEW Database OBJECT
$db = new Database($serverInfo)

// CREATE AN SQL STATEMENT
$sqlSelect = "SELECT * FROM user_info";

// PERFORM SQL STATEMENT ASSIGNED IN $sqlSelect
$db->query($sqlSelect);

// GET TOTAL RESULT FOR SQL QUERY
$totalResult = $db->query_count();

// GET QUERY RESULT IN ARRAY FORM
$queryResult = $db->getRecord();

// DISPLAY QUERY RESULT
print_r($queryResult);
*/
?>

Personal logo

2007-12-12T10:51:00.000-08:00

I have created a personal logo for this blog.
You can view the post and the logo here "Jhoy Imperial and the Web logo"

Szingtoh Products

2007-12-12T08:41:00.000-08:00

Hey guys! Just finished developing a simple product-selling site for my uncle. http://szingtohproducts.com/

It's very simple but easy to navigate. I'll enhance it later, slowly hehe... hope you'll like it =)

Simple PHP Class Example Part 1

2007-10-10T02:51:00.000-07:00

$item = new Items;
$item -> setName("Book");
$book = $item->getName();

$item -> setName("Pencil");
$Pencil = $item->getName();

class Items
{
var $item;

function setName($newname)
{
$this->title=$newname;
}

function getName()
{
return $this->title;
}
}

Simple PHP Class Example Part 2

2007-10-10T01:33:00.001-07:00

/*Create a new Object*/
$pricelist = new PriceList;

/*Set item name and price*/
$pricelist-> setItem("Carrot",10);

/*Get Item information*/
$itemname = $pricelist->getItemName();
$itemprice = $pricelist->getItemPrice();
$iteminfo = $pricelist->getItemInfo();

/*Display Item Information*/
echo "Name: $itemname \n";
echo "Price: $itemprice \n";
echo "Item Information: $iteminfo \n";
/*
OUTPUT
Name: Carrot
Price: 10
Item Information: Item=Carrot, Price=10
*/

/* This is the class object */
/* The Class name is "PriceList"*/
class PriceList
{
var $item; // -> this will hold the item name
var $price; // -> this will hold the item price
var $iteminfo; // -> this will hold the item info

/* This function will set the item name and price and store them in "inteminfo"*/
function setItem($newitem, $newprice)
{
$this->item=$newitem;
$this->price=$newprice;
$this->iteminfo = "Item=".$this->item.", Price=".$this->price;
}
/* This function will return the item info of the object */
function getItemInfo()
{
return $this->iteminfo;
}
/* This function will return the item name of the object */
function getItemName()
{
return $this->item;
}
/* This function will return the item price of the obj*/
function getItemPrice()
{
return $this->price;
}
}

Simple PHP Class Example

2007-09-22T05:13:00.000-07:00

/* Simple Class Structure */
class MathOperation
{
var $value1;
var $value2;

function Sum($value1, $value2)
{
$result = $value1 + $value2;
return $result;
}
function Diff($value1, $value2)
{
$result = $value1 - $value2;
return $result;
}
function Prod($value1, $value2)
{
$result = $value1 * $value2;
return $result;
}
function Quot($value1, $value2)
{
$result = $value1 / $value2;
return $result;
}
}

/*
STRUCTURE : [object variable name] = new [class name]
$compute : is the variable name of the new class object that we created
MathOperation : is the name of the class that we creayed
*/

$compute = new MathOperation;

/*
STRUCTURE : [object variable name] -> functionname(parameter1, parameter2)
$sum : is the variable which would hold the result of the class function that we called
Sum() : is the class function that we called
2 : would be assigned to $value1
9 : would be assigned to $value2
thus, "$value1 = paramater1, $value2 = parameter2" and so on
*/

$sum = $compute->Sum(2,9);
$diff = $compute->Diff(5,6);
$prod = $compute->Prod(3,2);
$quot = $compute->Quot(7,3);

/*This will display the result of the above operation*/

echo "Sum(2,9) = $sum, Diff(5,6) = $diff, Prod(3,2) = $prod, Quot(7,3) = $quot";

/*
OUTPUT :
Sum(2,9) = 11, Diff(5,6) = -1, Prod(3,2) = 6, Quot(7,3) = 2.33333333333
*/