//DATABASE FETCH DATA
require_once( "DataObject.class.php" );
class Display extends DataObject { protected $data = Array(
"login_Id" => "",
"login_Name" => "",
"login_Email" => "",
"login_Password" => "",
"message_Id" => "",
"message_Title" => "",
"message_Text" => "",
"message_Image" => "",
"video_Id" => "",
"video_Title" => "",
"video_Src" => "",
);
public static function getVideo($id) {
$conn=DataObject::connect();
if($id) {
$cond.=" where video_id='$id'";
}
$sql="SELECT * FROM Video $cond order by video_Id DESC";
//echo $sql."
";
$result=$conn->query($sql);
if($result->num_rows > 0) {
while($row=$result->fetch_assoc()) {
$data[]=new Display($row);
}
}
DataObject::disconnect($conn);
if($data) return $data; }
public static function getMessage($id) {
$conn=DataObject::connect();
if($id) {
$cond.=" where message_Id='$id'";
}
$sql="SELECT * FROM Message $cond order by message_Id DESC";
$result=$conn->query($sql);
if($result->num_rows > 0) {
while($row=$result->fetch_assoc()) {
$data[]=new Display($row);
}
}
DataObject::disconnect($conn);
if($data) return $data; }
public static function getDisplay($id,$table,$varId) {
$conn=DataObject::connect();
if($id) {
$cond.="where $varId='$id'";
}
$order=" order by $varId DESC";
$sql="SELECT * FROM $table $cond $order ";
$result=$conn->query($sql);
if($result->num_rows > 0) {
while($row=$result->fetch_assoc()) {
$data[]=new Display($row);
}
}
DataObject::disconnect($conn);
if($data) return $data; }
public static function getLogin($email,$password) {
$conn=DataObject::connect();
$email=addslashes($email);
$password=addslashes($password);
$sql="SELECT * FROM Login where login_Email='$email' and login_Password='".md5($password)."' ORDER BY `Login`.`login_Id` DESC ";
$result=$conn->query($sql);
if($result->num_rows > 0) {
while($row=$result->fetch_assoc()) {
$data[]=$row['login_Email'];
}
}
DataObject::disconnect($conn);
if($data) return $data; }
}
?>