HELP! Selecting Array Rows based on an array of field=>value s

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • josh.23.french

    #1

    HELP! Selecting Array Rows based on an array of field=>value s

    Here's the code i have:

    $db = array(); //main array
    $db['main'] = array(); //table `main`
    $db['main'][] = array('id'=>0,
    'username'=>'jo shfrench','user pass'=>'passwor d','userlevel'= >'admin');
    //row
    $db['main'][] = array('id'=>1,
    'username'=>'bo b_smith','userp ass'=>'psswrd', 'userlevel'=>'u ser');
    //row

    function trim_value(&$va lue){
    $value = strtolower(trim ($value));
    }
    function fdb_select($fie lds = "*", $table, $where = false, $limit =
    false){
    global $db;
    $retv = $db[$table];

    //LIMIT RESULTS TO FIELDS
    if(strrpos($fie lds, ",") === false){$field=a rray($fields);} else{$field
    = explode(",", $fields);};
    array_walk($fie ld, "trim_value ");
    $all_fields = array_keys($ret v[0]);
    if($fields == '*'|| is_null($fields )){$field = $all_fields;};
    $field = array_uintersec t($all_fields, $field, "strcasecmp ");
    $retvi = array();
    foreach($retv as $num =$row){
    foreach($row as $fname =$fvalue){
    $fname1 = strtolower($fna me);
    if(in_array($fn ame1, $field)){
    $retvi[$num][$fname]=$fvalue;
    };
    };
    };
    //DONE LIMITING TO FIELDS
    if($where != false){

    //UP TO HERE IT WORKS FINE
    //LIMIT TO WHERE CLAUSE
    $retvj = array();
    foreach($retvi as $num =$row){
    //IN THE ROW
    foreach($where as $k =$v){
    //IF ROW MEETS ALL REQUIREMENTS
    if($row[$k] == $v){
    $retvj[] = $retvi[$num]; //Keep that row
    };
    };
    };
    //DONE LIMITING TO WHERE CLAUSE
    };
    $retvi = (isset($retvj)) ? $retvj:$retvi;
    //SEND A FINAL ASSOCIATIVE ARRAY
    return $retvi;
    };
    print_r(fdb_sel ect("*", "main", array('id'=>"1" ,
    "username"=>"jo shfrench")));

    the previous code outputs this:

    Array
    (
    [0] =Array
    (
    [id] =0
    [username] =joshfrench
    [userpass] =password
    [userlevel] =admin
    )

    [1] =Array
    (
    [id] =1
    [username] =bob_smith
    [userpass] =psswrd
    [userlevel] =user
    )

    )

    if i make the last option array('id'=>'1' ), it does what i want.

    HELP!!

Working...