125 lines
2.5 KiB
PHP
125 lines
2.5 KiB
PHP
<?php
|
|
require_once('class.db.php');
|
|
|
|
class ImageCategoryData
|
|
{
|
|
var $ImageCategoryID; //primary key
|
|
var $ImageCategoryName;
|
|
}
|
|
|
|
|
|
class ImageCategory {
|
|
private $table_name = 'lu_ImageCategory';
|
|
private $required_fields = array( 'ImageCategoryID', 'ImageCategoryName' );
|
|
|
|
public function __construct()
|
|
{
|
|
}
|
|
|
|
function insert(&$obj)
|
|
{
|
|
if (!is_object($obj))
|
|
{
|
|
return false;
|
|
}
|
|
|
|
$return_val = false;
|
|
|
|
$db = new db();
|
|
|
|
$object_vars = get_object_vars($obj);
|
|
array_shift($object_vars);
|
|
|
|
$fields = '';
|
|
$values = '';
|
|
|
|
//array shift the primary key
|
|
foreach ($object_vars as $key => $value)
|
|
{
|
|
$fields .= $key . ",";
|
|
$values .= "'" . $db->escape($value) . "',";
|
|
}
|
|
$fields = rtrim($fields,',');
|
|
$values = rtrim($values,',');
|
|
|
|
$sql = "INSERT INTO " . $this->table_name . " (" . $fields . ") VALUES (" . $values . ")";
|
|
|
|
if ($result = $db->query($sql))
|
|
{
|
|
$obj->ImageCategoryID = $db->insert_id;
|
|
$return_val = true;
|
|
}
|
|
|
|
return $return_val;
|
|
|
|
}
|
|
|
|
function update($obj)
|
|
{
|
|
if (!is_object($obj)) {
|
|
return false;
|
|
}
|
|
|
|
$return_val = false;
|
|
|
|
$db = new db();
|
|
|
|
$object_vars = get_object_vars($obj);
|
|
$shifted = array_shift($object_vars);
|
|
|
|
foreach ($object_vars as $key => $value)
|
|
{
|
|
$set_clause .= " " . $key . " = '" . $db->escape($value) . "',";
|
|
}
|
|
$set_clause = rtrim($set_clause,',');
|
|
|
|
$sql = "UPDATE " . $this->table_name . " SET " . $set_clause . " WHERE ImageCategoryID = '" . $db->escape($obj->ImageCategoryID) . "'";
|
|
|
|
if ($db->query($sql))
|
|
{
|
|
$return_val = true;
|
|
}
|
|
|
|
return $return_val;
|
|
}
|
|
|
|
function getOne($image_category_id)
|
|
{
|
|
if (!is_numeric($image_category_id)) { return false; }
|
|
|
|
$return_val = false;
|
|
|
|
$db = new db();
|
|
|
|
foreach (array_keys(get_class_vars('ImageCategoryData')) as $key)
|
|
{
|
|
$fields .= " " . $key . ",";
|
|
}
|
|
$fields = rtrim($fields,',');
|
|
|
|
$sql = "SELECT " . $fields . " FROM " . $this->table_name . " WHERE ImageCategoryID = '" . $db->escape($image_category_id) . "'";
|
|
|
|
if($result = $db->get_row($sql))
|
|
{
|
|
$return_val = $result;
|
|
}
|
|
|
|
return $return_val;
|
|
}
|
|
|
|
function getAll($orderby='ImageCategoryID')
|
|
{
|
|
$db = new db();
|
|
|
|
foreach (array_keys(get_class_vars('ImageCategoryData')) as $key)
|
|
{
|
|
$fields .= " " . $key . ",";
|
|
}
|
|
$fields = rtrim($fields,',');
|
|
|
|
$sql = "SELECT " . $fields . " FROM " . $this->table_name . " ORDER BY ".$orderby;
|
|
|
|
return $db->get_results($sql);
|
|
}
|
|
}
|
|
?>
|