Welcome Guest, Not a member yet? Register   Sign In
Fatal Memory Error
#11

[eluser]iFadey[/eluser]
<b>Users model class continued...</b>

Code:
function user_exists( $username ) {
        $query = 'SELECT username FROM users WHERE username = ? LIMIT 1';
        
        $username = strtolower( xss_clean( trim( $username ) ) );
        
        $results = $this->db->query( $query, array( $username ) );
        $data = $results->num_rows();
        
        $results->free_result();
        return $data;
    }
    
    
    function email_exists( $email ) {
        $query = 'SELECT email FROM users WHERE email = ? LIMIT 1';
        
        $email = strtolower( xss_clean( trim( $email ) ) );
        
        $results = $this->db->query( $query, array( $email ) );
        $data = $results->num_rows();
        
        $results->free_result();
        return $data;
    }
    
    
    function getUsernameByEmail( $email ) {
        $query = 'SELECT username FROM users WHERE email = ? LIMIT 1';
        
        $results = $this->db->query( $query, array( $email ) );
        $data = $results->row_array();
        
        $results->free_result();
        return $data[ 'username' ];
    }
    
    
    function getImageByUsername( $username ) {
        $query = 'SELECT image FROM users WHERE username = ? LIMIT 1';
        
        $results = $this->db->query( $query, array( $username ) );
        $data = $results->row_array();
        
        $results->free_result();
        return $data[ 'image' ];
    }
    
    
    function getUserRecordByUsername( $username, $display_profile = 0 ) {
        $username = xss_clean( substr( $username, 0, 20 ) );
        
        if( empty( $display_profile ) )
            $query = 'SELECT * FROM users WHERE username = ? LIMIT 1';
        else
            $query = 'SELECT * FROM users WHERE username = ? AND display_profile = 1 LIMIT 1';
        
        $results = $this->db->query( $query, array( $username ) );
        $data = $results->row_array();
        
        $data[ 'articles_written' ] = $this->BlogPosts->countTotalUserArticles( $data[ 'username' ] );
        
        $results->free_result();
        return $data;
    }

} //end Users class


Messages In This Thread
Fatal Memory Error - by El Forum - 11-05-2009, 01:55 AM
Fatal Memory Error - by El Forum - 11-05-2009, 02:34 AM
Fatal Memory Error - by El Forum - 11-05-2009, 03:01 AM
Fatal Memory Error - by El Forum - 11-05-2009, 03:09 AM
Fatal Memory Error - by El Forum - 11-05-2009, 05:07 AM
Fatal Memory Error - by El Forum - 11-05-2009, 08:39 AM
Fatal Memory Error - by El Forum - 11-05-2009, 06:41 PM
Fatal Memory Error - by El Forum - 11-05-2009, 08:19 PM
Fatal Memory Error - by El Forum - 11-05-2009, 10:07 PM
Fatal Memory Error - by El Forum - 11-05-2009, 10:10 PM
Fatal Memory Error - by El Forum - 11-05-2009, 10:12 PM
Fatal Memory Error - by El Forum - 11-05-2009, 10:20 PM
Fatal Memory Error - by El Forum - 11-05-2009, 10:21 PM
Fatal Memory Error - by El Forum - 11-06-2009, 02:51 AM
Fatal Memory Error - by El Forum - 11-06-2009, 06:18 AM
Fatal Memory Error - by El Forum - 11-06-2009, 10:32 AM
Fatal Memory Error - by El Forum - 11-06-2009, 03:25 PM



Theme © iAndrew 2016 - Forum software by © MyBB