Software: Apache/2.2.3 (CentOS). PHP/5.1.6 uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44 uid=48(apache) gid=48(apache) groups=48(apache) Safe-mode: OFF (not secure) /var/www/html/manage/teacher/class/ drwxr-xr-x |
Viewing file: clsPerson.php (5.01 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) | <?php //--Class person-------------------------- //--PK of person :: // 1. personId class person extends clsDB{ var $result; var $personId; var $deptId; var $workGpId; var $prefixId; var $fName; var $lName; var $fStatus; var $adminId; var $fRetire; var $hireId; function person(&$c){ $this->c=$c->c; $this->DB=$c->db; } function Save(){ if ($this->status==1){ //uncomment a line below if your table use ID as running number //$this->personId=$this->GetNextCode(); //echo $sql."<br>"; $sql = "insert into Person values( '$this->personId', '$this->deptId', '$this->workGpId', '$this->prefixId', '$this->fName', '$this->lName', '$this->fStatus', '$this->adminId', '$this->fRetire', '$this->hireId' )"; }else { $sql = "update Person set deptId='$this->deptId', workGpId='$this->workGpId', prefixId='$this->prefixId', fName='$this->fName', lName='$this->lName', fStatus='$this->fStatus', adminId='$this->adminId', fRetire='$this->fRetire', hireId='$this->hireId' where personId='$this->personId'"; } return $this->Dml($sql); } function Delete(){ return $this->Dml("delete from Person where personId='$this->personId'"); } function GetNextCode(){ $this->SetQuery("select max(personId) as num from Person"); if ($result=$this->GetResult()) { return $result['num']+1; } } function RSperson(){ $this->SetQuery("select * from Person where fStatus='1' and fRetire='0' order by personId"); } function RSperson2(){ $this->SetQuery("select * from Person order by personId"); } function GetRecord(){ $numFields = $this->NumField(); $row = $this->GetResult(); if ($row){ for ($i=0; $i<$numFields; $i++){ eval("\$this->".mysql_field_name($this->rs, $i)."=\$row['".mysql_field_name($this->rs, $i)."'];"); } return true; }else{ // clear value of Member; for ($i=0; $i<$numFields; $i++){ eval("\$this->".mysql_field_name($this->rs, $i)."='';"); } return false; } } function SearchByKey($xKey){ if ($this->SetQuery("select * from Person where personId= '$xKey' order by personId asc")){ return 1; }else { return 0; } } //****************** You can add new functions below **********************// function CountPersonByDPID($xKey,$yKey){ $this->SetQuery("select count(personId) as num from Person where (deptId= '$xKey' or deptId= '$yKey') and fStatus=1 and fRetire=0"); if ($result=$this->GetResult()) { return $result['num']; } } function CountPerson(){ $this->SetQuery("select count(personId) as num from Person where fStatus=1 and fRetire=0"); if ($result=$this->GetResult()) { return $result['num']; } } function CountPersonDept($xKey){ $this->SetQuery("select count(personId) as num from Person where deptId='$xKey' and fStatus=1 and fRetire=0"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchByDPID($xKey,$yKey){ //--ค้นหาข้อมูลตาม PK ต้องระบุพารามิเตอร์ด้วย และต้องตามด้วยเมธอด GetRecord() เสมอ if ($this->SetQuery("select * from Person where (deptId= '$xKey' or deptId= '$yKey') and fStatus=1 and fRetire=0 order by personId asc")){ return 1; }else { return 0; } } function SearchByDeptId($xKey){ if ($this->SetQuery("select * from Person where deptId= '$xKey' and fStatus=1 and fRetire=0 order by personId asc")){ return 1; }else { return 0; } } function SearchByDeptIdadminId($xKey){ if ($this->SetQuery("select * from Person where deptId= '$xKey' and fStatus=1 and fRetire=0 order by adminId asc , hireId asc")){ return 1; }else { return 0; } } function CountPersonDeptWorkGroup($xKey,$yKey){ $this->SetQuery("select count(personId) as num from Person where deptId='$xKey' and fStatus=1 and fRetire=0 and workGpId = '$yKey'"); if ($result=$this->GetResult()) { return $result['num']; } } function SearchByName($xKey){ if ($this->SetQuery("select * from Person where (fName like '%$xKey%' or lName like '%$xKey%') order by personId asc")){ return 1; }else { return 0; } } function SearchfNamelName($xKey,$yKey){ if ($this->SetQuery("select * from Person where (fName ='$xKey' and lName = '$yKey') order by personId asc")){ return 1; }else { return 0; } } function RSPersonf1dept($xKey){ // $this->dpSet = false; $this->SetQuery("select * from Person where fStatus = 1 and fRetire=0 and deptId='$xKey' order by personId asc"); } function RSPersonf1(){ $this->SetQuery("select * from Person where fStatus = 1 order by personId asc"); } function RSPersonf1PE($xKey){ $this->SetQuery("select * from $xKey.Person where fStatus = 1 order by personId asc"); } function SearchByDeptId2($xKey){ //echo "select personId, lName,fName,prefixId, deptId from Person where deptId='$xKey' and fRetire=0 order by personId asc<br>"; if ($this->SetQuery("select personId, lName,fName,prefixId, deptId from Person where deptId='$xKey' and fRetire=0 order by personId asc")){ return 1; }else { return 0; } } } //--End class person-- ?> |
:: Command execute :: | |
:: Shadow's tricks :D :: | |
Useful Commands
|
:: Preddy's tricks :D :: | |
Php Safe-Mode Bypass (Read Files)
|
--[ c999shell v. 1.0 pre-release build #16 Modded by Shadow & Preddy | RootShell Security Group | r57 c99 shell | Generation time: 0.0059 ]-- |