|
class cBanner {
private $vBannerId;
private $vIdCity;
private $vTitle;
private $vScriptCode;
private $vPosition;
function __construct($pParam1) {
$this -> vBannerId = $pParam1;
}
function fGetAllCityBanners ($pParam1) {
global $database_connection, $connection;
$strSQL = "SELECT * FROM TbBanners WHERE ville_id =".$pParam1." Order By Position; ";
mysql_select_db($database_connection, $connection);
$qry = mysql_query($strSQL, $connection) or die(mysql_error());
return $qry;
}
function fSetAtribute ($pParam1, $pParam2) {
$this -> $pParam1 = $pParam2;
}
function fGetLastPosition () {
global $database_connection, $connection;
$strSQL = "SELECT Max(Position) AS LastPosition FROM TbBanners WHERE ville_id = ".$this -> vIdCity." ; ";
mysql_select_db($database_connection, $connection);
$qry = mysql_query($strSQL, $connection) or die(mysql_error());
$vTemp = mysql_fetch_object($qry);
if ($vTemp -> LastPosition == "") {
return 1;
} else {
return $vTemp -> LastPosition + 1;
}
}
function fInsertNewBanner ($pParam1, $pParam2, $pParam3, $pParam4) {
global $database_connection, $connection;
$this -> fSetAtribute ("vTitle", $pParam1);
$this -> fSetAtribute ("vScriptCode", $pParam2);
$this -> fSetAtribute ("vIdCity", $pParam3);
$this -> fSetAtribute ("vPosition", $pParam4);
$vTempPostion = $this -> fGetLastPosition ();
$strSQL = "INSERT INTO TbBanners (Title, ScriptCode, ville_id, Position) VALUES ('".addslashes($this -> vTitle)."', '".addslashes($this -> vScriptCode)."', ".$this -> vIdCity.", ".$this -> vPosition."); ";
mysql_select_db($database_connection, $connection);
$qry = mysql_query($strSQL, $connection) or die(mysql_error());
}
function fDeleteBanner () {
global $database_connection, $connection;
$strSQL = "DELETE FROM TbBanners WHERE BannerId = ".$this->vBannerId;
mysql_select_db($database_connection, $connection);
$qry = mysql_query($strSQL, $connection) or die(mysql_error());
}
function fGetBanner () {
global $database_connection, $connection;
$strSQL = "SELECT * FROM TbBanners WHERE BannerId = ".$this->vBannerId;
mysql_select_db($database_connection, $connection);
$qry = mysql_query($strSQL, $connection) or die(mysql_error());
if (mysql_num_rows($qry) > 0) {
$vRow = mysql_fetch_object($qry);
$this -> fSetAtribute ('vTitle', $vRow -> Title);
$this -> fSetAtribute ('vScriptCode', $vRow -> ScriptCode);
$this -> fSetAtribute ('vIdCity', $vRow -> ville_id);
$this -> fSetAtribute ('vPosition', $vRow -> Position);
return true;
} else {
return false;
}
}
function fUpdateBanner ($pParam1, $pParam2, $pParam3) {
global $database_connection, $connection;
$this -> vTitle = $pParam1;
$this -> vScriptCode = $pParam2;
$this -> vPosition = $pParam3;
$strSQL = "UPDATE TbBanners SET Title = '".addslashes($this -> vTitle)."', ScriptCode = '".addslashes($this -> vScriptCode)."', Position = '".$this -> vPosition."' WHERE BannerId = ".$this->vBannerId;
mysql_select_db($database_connection, $connection);
$qry = mysql_query($strSQL, $connection) or die(mysql_error());
}
function fReturnAtribute ($pParam1) {
return $this -> $pParam1;
}
}
?> |