工作日志 - 平台数据库交互

PALAA 平台简单数据库交互

ftp.php

case 'openftp':
  $online->islogined || h('user.php');
  $ftpmanager = new FTPManager();
  $ftpmanager->openftp($_GET['username']);
  break;  


ftpmanager.class.php

public function openftp($username,$status=1){
  if ($this->db->exists("SELECT * FROM pal_myftp WHERE {$GLOBALS['wheredid']} AND myftp_username ='$username'")){
   $this->class->error('myftp_username',$this->lang->Emyftp_username_not_exists);return false;   
  }
  $first = $this->db->first("SELECT * FROM pal_myftp WHERE {$GLOBALS['wheredid']} AND myftp_username ='$username'");
  $this->db->write("update pal_myftp set myftp_status='$status' where {$GLOBALS['wheredid']} and myftp_username='$username''");
  return $this->ftpurl($first);
}