PHP getMainConnectionの例

コード例 #1

ファイル: emailfunctions.php プロジェクト: harshselani/My-Class

function sendUserLogsViaMail($classID)
{
    $conn = getMainConnection();
    $query = "SELECT * FROM info WHERE ID = '" . $classID . "'";
    $result = mysql_query($query);
    $numrows = mysql_affected_rows();
    if ($numrows == 1) {
        $member = mysql_fetch_array($result);
        if ($member['activeflag'] != 0) {
            getTemporaryConnection($member['databasename']);
        }
    }
    $query = "SELECT * FROM login_logs WHERE lastlogin <= '" . time() . "' AND lastlogin >= '" . (time() - 86400) . "'";
    $result = mysql_query($query);
    $mail_string = '';
    while ($member = mysql_fetch_array($result)) {
        $time = date("F j, Y, g:i a", $member['lastlogin']);
        $user = getUser($member['userID'])->getName();
        $mail_string .= $user . ' logged in at ' . $time . ' from the ip ' . $member['ip'] . '<br />';
    }
    //echo $mail_string;
    $toEmail = '*****@*****.**';
    $toName = 'Ace Chemistry';
    $fromEmail = '*****@*****.**';
    $fromName = 'My Class - Knowledge Portal';
    $subject = 'Staff Login Logs : ' . date("d-m-Y");
    $body = 'Staff Login Logs <hr /><br />' . $mail_string;
    $flag = sendEmail($toEmail, $toName, $fromEmail, $fromName, $subject, $body, '');
    return $flag;
}

コード例 #2

ファイル: connection.php プロジェクト: harshselani/My-Class

function getNewStudentConnection($id)
{
    $conn = getMainConnection();
    $query = "SELECT * FROM info WHERE ID = '" . $id . "'";
    $result = mysql_query($query);
    $member = mysql_fetch_array($result);
    $dbname = $member['databasename'];
    $conn1 = @mysql_connect(HOST, USER, PASSWORD);
    mysql_select_db($dbname, $conn1);
    return $conn1;
}

コード例 #3

ファイル: userfunctions.php プロジェクト: harshselani/My-Class

function getAllActiveTeachers($id)
{
    $conn = getMainConnection();
    $list = array();
    $query = "SELECT * FROM users WHERE activeflag=1 AND classID = " . $id . " AND level=3 ORDER BY ID ASC";
    //echo $query;
    $result = mysql_query($query);
    while ($member = mysql_fetch_array($result)) {
        $temp = getUser($member['ID']);
        array_push($list, $temp);
    }
    if (count($list) != 0) {
        return $list;
    }
    return NULL;
}

コード例 #4

ファイル: studentloginfunctions.php プロジェクト: harshselani/My-Class

function getColumnName($number, $id)
{
    $conn = getMainConnection();
    $query = "SELECT * FROM `student` WHERE `ID` = '" . $id . "' AND activeflag <> 0";
    $result = mysql_query($query, $conn);
    $column = NULL;
    if ($result) {
        $member = mysql_fetch_array($result);
        if ($member['phone_stu'] == $number) {
            $column = 'studentpass';
        }
        if ($member['phone_father'] == $number) {
            $column = 'parentpass';
        }
    }
    return $column;
}

コード例 #5

ファイル: permissionfunctions.php プロジェクト: harshselani/My-Class

function getAllUserPermissions($ID)
{
    $conn = getMainConnection();
    $query = "SELECT * FROM permission WHERE userID = '" . $ID . "' AND activeflag = 1";
    $result = mysql_query($query);
    $temp = array();
    while ($member = mysql_fetch_array($result)) {
        array_push($temp, $member['permissionType']);
    }
    return $temp;
}

コード例 #6

ファイル: globalfunctions.php プロジェクト: harshselani/My-Class

function enterLoginLog($ip, $user)
{
    $conn = getMainConnection();
    $id = $user->getClassID();
    $query = "SELECT * FROM info WHERE ID = '" . $id . "'";
    $result = mysql_query($query);
    $numrows = mysql_affected_rows();
    if ($numrows == 1) {
        $member = mysql_fetch_array($result);
        if ($member['activeflag'] != 0) {
            getTemporaryConnection($member['databasename']);
        }
    }
    $query = "INSERT INTO `login_logs` (`ID`, `userID`, `lastlogin`, `ip`) VALUES (NULL, '" . $user->getID() . "', '" . time() . "', '" . $ip . "')";
    $result = mysql_query($query);
}

コード例 #7

ファイル: globalclasses.php プロジェクト: harshselani/My-Class

 function read()
 {
     $conn = getMainConnection();
     $query = "SELECT * FROM permission WHERE ID='" . $this->ID . "'";
     $result = mysql_query($query);
     if (!$result) {
         return;
     } else {
         $member = mysql_fetch_array($result);
         $this->setUserID(trim($member['userID']));
         $this->setPermissionType(trim($member['permissionType']));
         $this->setActiveFlag(trim($member['activeflag']));
         $this->setLastUpdated(trim($member['lastupdated']));
     }
 }

コード例 #8

ファイル: studentfunctions.php プロジェクト: harshselani/My-Class

function removeStudentFromMainTable($mainID)
{
    $instituteID = getCurrentInstituteID1();
    $conn = getMainConnection();
    $query = "SELECT * FROM `studentinstituteid` WHERE `studentID` = '" . $mainID . "' AND `instituteID` = '" . $instituteID . "' AND `activeflag` = 1";
    $result = mysql_query($query, $conn);
    $rows = mysql_num_rows($result);
    if ($rows == 1) {
        $member = mysql_fetch_array($result);
        $query1 = "UPDATE `studentinstituteid` SET `activeflag` = 0 WHERE `ID` = '" . $member['ID'] . "'";
        $result1 = mysql_query($query1, $conn);
        return true;
    }
    return false;
}

コード例 #9

ファイル: globalclassessmall.php プロジェクト: harshselani/My-Class

 function read()
 {
     $conn = getMainConnection();
     $query = "SELECT * FROM users WHERE ID='" . $this->ID . "'";
     $result = mysql_query($query);
     if (!$result) {
         return;
     } else {
         $member = mysql_fetch_array($result);
         $this->setName(trim($member['name']));
         $this->setUsername(trim($member['username']));
         $this->setPassword(trim($member['hashed_password']));
         $this->setLevel(trim($member['level']));
         $this->setActiveFlag(trim($member['activeflag']));
         $this->setDateCreated(trim($member['datecreated']));
         $this->setClassID(trim($member['classID']));
         $this->setLoginFlag(trim($member['loginflag']));
         $this->setLoginIp(trim($member['loginip']));
     }
 }