How do I manipulate the "Select" array? about php-mysql-class

[a1phanumeric]

Hello,

Can you elaborate a little more? Let's say you have a users table, you can get all results from that table using $oMySQL->Select('users'). If you want to get a user with a specific username and password, use:

$where = array();
$where['username'] = 'a1phanumeric';
$where['password'] = 'password'; // Can be MD5 / AES etc...
$oMySQL->Select('users', $where);

[AlbertSanIza]

This is the code i am using...

    include_once('class.MySQL.php');
    $oMySQL = new MySQL('TEST', 'root', 'root', 'localhost:3306');
    $myUsername=$_POST['myusername']; //This is sent by the LogIn Form
    $myPassword=$_POST['mypassword']; //This is sent by the LogIn Form
    $Login = array('id' => "$myUsername",'password'=>"$myPassword");
    $Result = $oMySQL->Select('Untitled',$Login);

The problem is that I can't find a way to manipulate $Result, for example I want to compare:

$myUsername to $Result key 'id'
$myPasword to $Result key 'password'

To check if the LogIn credentials are correct

-Sorry bad english, and thanks for your time (: -

never mind my friend, I solved the problem with this code:

    if($Result[id] == $myUsername){
        if($Result[password] == $myPassword){
            //Successful LogIn
            header("Location: http://google.com");
        }
    }
    else{
        //Failed LogIn
        header("Location: http://applesfera.com");
    }

[a1phanumeric]

Haha! I was just about to say that Select() returns an array that you can use!

Thanks for your interest in my MySQL class - it is an active project so feel free to suggest improvements!

I'll close the issue now :)

[AlbertSanIza]

What do you think about this?

function MySQL($Type,$database, $username, $password, $hostname){
     $this->MySQLServer($Type,$database, $username, $password, $hostname);
     $this->Connect();
}

/* *******************
* Private Functions *
* *******************/

private function MySQLServer($Type,$database, $username, $password, $hostname='localhost'){
     if($Type == 0){
        $this->database = $database;
        $this->username = $username;
        $this->password = $password;
        $this->hostname = $hostname;
     }
     if($Type == 1){
        $databaseArray = array(1=>'CUSTOM_database1',2=>'CUSTOM_databas2',3=>'CUSTOM_database3');
        $usernameArray = array(1=>'CUSTOM_username1',2=>'CUSTOM_username2');
        $passwordArray = array(1=>'CUSTOM_password1',2=>'CUSTOM_password2');
        $hostnameArray = array(1=>'CUSTOM_hostname1');

        $this->database = $databaseArray[$database];
        $this->username = $usernameArray[$username];
        $this->password = $passwordArray[$password];
        $this->hostname = $hostnameArray[$hostname];
     }
}

This way the user will only place its connection data once.
//Normal Mode

$oMySQL = new MySQL(0,'my_database','username','password');

//Presets Mode

$oMySQL = new MySQL(1,3,1,2,1);

and the equivalent of this with Normal Mode would be

$oMySQL = new MySQL(1,'CUSTOM_database3','CUSTOM_username1','CUSTOM_password2','CUSTOM_hostname1');