PHP CLASS

<br /><?php <br />class Admin <br />{ <br /> var $username; <br /> var $password; <br /> var $newpassword; <br /> var $admin_table=ADMIN; <br /> var $table; <br /> var $static_page_key; <br /> var $values; <br /> <br /> function adminLogin() <br /> { <br /> global $DB; <br /> $username=$this->username; <br /> $password=$this->password; <br /> $admin_table=$this->admin_table; <br /> $admin_login=$DB->getOne("select username from $admin_table where username='$username' and password='$password' and status=1"); <br /> if($admin_login == '' || $admin_login == NULL) <br /> { <br /> <br /> return false; <br /> } <br /> else <br /> { <br /> $_SESSION['admin_username']=$admin_login; <br /> return true; <br /> } <br /> } <br /> <br /> function adminChangePassword() <br /> { <br /> global $DB; <br /> $username=$this->username; <br /> $password=$this->password; <br /> $newpassword=$this->newpassword; <br /> $admin_table=$this->admin_table; <br /> $admin_login=$DB->getOne("select username from $admin_table where username='$username' and password='$password' and status=1"); <br /> if($admin_login == '' || $admin_login == NULL) <br /> { <br /> <br /> return false; <br /> } <br /> else <br /> { <br /> $DB->Execute("update $admin_table set password='$newpassword' where username='$username' and status=1"); <br /> return true; <br /> } <br /> } <br /> <br /> function adminUpdateStaticPage() <br /> { <br /> global $DB; <br /> $values=$this->values; <br /> $page_key=$this->static_page_key; <br /> $table=$this->table ; <br /> <br /> $check_avail=$DB->getOne("select count(*) from $table where page_key='$page_key'"); <br /> <br /> $i=0; <br /> foreach($values as $key => $value) <br /> { <br /> $i++; <br /> $sql_part.=" $key='".addslashes($value)."' "; <br /> if($i != count($values)) <br /> $sql_part.=","; <br /> } <br /> <br /> if($check_avail == 0) <br /> { <br /> <br /> $DB->Execute("insert into $table set $sql_part"); <br /> } <br /> else <br /> { <br /> $DB->Execute("update $table set $sql_part where page_key='$page_key'"); <br /> } <br /> echo mysql_error(); <br /> return true; <br /> } <br />} <br />?> <br /> <br /> <br /> <br />