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!!
$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!!