[PHP] SQL Klasse

[Sedrika]

.

[Supr3matt]

Thanks, it is very helpful

[Sedrika]

Is anyone using this class?

[raventh1984]

Its an nice class but i have my own class that doesnt relay on ODBC.

But its an good job. I wish i could see more of OOP.

I am currently working an an flyff website thats based on OOP.

[Sedrika]

There are both scripts. One for mssql connection and one for odbc.

[raventh1984]

o.O didnt say the first one.

haha ok

Here i am using this one. its MSSQL

PHP Code:

<?php
class MSSQL
{
    private $_link;

    public function connect($server='', $username='', $password='', $new_link=true)
    {
        $this->_link = mssql_connect($server, $username, $password, $new_link);
    }
    
    public function Escape($string)
    {
        return str_replace("'", "''", $string);
    }
    
     public function query($query) {
        return mssql_query($query, $this->_link);  
    }
    
    public function fetchArray($result, $array_type = MYSQL_BOTH) {
        return mssql_fetch_array($result, $array_type);  
    }
    
    public function fetchRow($result) {
        return mssql_fetch_row($result);  
    }
    
    public function fetchAssoc($result) {
        return mssql_fetch_assoc($result);
    }
    
    public function fetchObject($result) {
        return mssql_fetch_object($result);  
    }
    
    public function numRows($result) {
        return mssql_num_rows($result);
    }
    
    public function close() {
        return mssql_close($this->_link);
    }
}

//Example
//Select DB
$db->query('USE ACCOUNT_DBF');
//Getting data
$result = $db->query('SELECT account,password FROM ACCOUNT_TBL WHERE account = "accountname"');
//Fetching the data
echo $db->fetchAssoc($result);

?>

[Sedrika]

Use at least my escape function it's way better then yours

[DarkFlyffTeam]

@raventh1984 that's a really poor class. Use at least prepared statements as in Sedrika script.
I've somewhere a SQL class I don't use since a long time ago, I will post if I find it.

[raventh1984]

Thanks for the comment DarkFlyff
I will take an look into prepared statements.