search php assoc array (hash map) as mysql

Question

example

public $inputs=array(
    array(  'sysname'=>'pt_name','dbname' => 'users.name','label' => 'user (name/ID)','value' => '',
            'type' => 'text','rules' => 'required','attr'=>'class="autocomplete"'),

    array(  'sysname'=>'pt_dob','dbname' => 'users.dob','label' => 'Patient Dob','value' => '',
            'type' => 'text','rules' => 'required','attr'=>'class="dob ac" Disabled'),

    array(  'sysname'=>'pt_gender','dbname' => 'users.gender','label' => 'gender','value' => 'male,female',
            'type' => 'dropdown','rules' => 'required','attr'=>'class="ac" Disabled'),

    array(  'sysname'=>'visit_date','dbname' => 'visits.date','label' => 'Date','value' => '',
            'type' => 'text','rules' => 'required','attr'=>'class="datepicker"'),

    array(  'sysname'=>'visit_time','dbname' => 'visits.time_booked','label' => 'Time','value' => '',
            'type' => 'text','rules' => 'required','attr'=>'class="timepicker"'),

    array(  'sysname'=>'visit_type','dbname' => 'visits.type','label' => 'Visit type','value' => 'visit,schedule',
            'type' => 'dropdown','rules' => 'required','attr'=>'')
    );

how can i search this array for only arrays that have pt_ in its sysname for example ?

the idea is i have many types of rows all in same table, so instead of running a mysql query to fetch each type separatly example:

$pt=db->query("select * from table where sysname like 'pt_%'")->result();
$visit=db->query("select * from table where sysname like 'visit_%'")->result();

i want to fetch all at one and split them in php to decrease db load.

so how can i do this ? and is it worth it or better of keep my querys separate.

Use foreach and strpos

Pitchinnate
– Pitchinnate

2013-02-13 14:37:30 +00:00
Commented Feb 13, 2013 at 14:37 — Pitchinnate
– Pitchinnate, Commented Feb 13, 2013 at 14:37

TML · Accepted Answer · 2013-02-13 14:52:03Z

1

array_filter and a PHP-style closure* would be a pretty simple solution to this:

function buildFilter($key, $needle) {
    return function($array) use($key, $needle) {
        return (strpos($array[$key], $needle) !== FALSE);
    };
}
$matches = array_filter($inputs, buildFilter('sysname', 'pt_'));
var_dump($matches);

NB: What PHP calls a "closure" is quite a bit different from what most other languages use for the same term, so please make sure to read the PHP documentation.

answered Feb 13, 2013 at 14:52

TML

13k3 gold badges42 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Momen Zalabany Over a year ago

does this works inside class ? Fatal error: Cannot use object of type stdClass as array in

TML Over a year ago

You have to change $array[$key] to $array->$key

TML Over a year ago

Any particular reason you decided to un-accept the answer? I mean, if you had accepted another answer instead, that'd be one thing - but now this is hanging out there as "unanswered" when I think you actually did get a valid answer?

Arnold Daniels · Accepted Answer · 2013-02-13 14:55:57Z

1

Doing a couple of queries is fine, your DB can handle that easily. If you're doing dozens of queries for dozens of types (each with only a few rows), it might be worth investigation moving that logic to PHP.

What I would recommend is to put the systype in a separate column with an index on it. That will speed of your query a lot and take load of your DB. Even better is you can make that column an ENUM.

public $inputs=array(
    array(  'systype'=>'pt', 'sysname'=>'pt_name','dbname' => 'users.name','label' => 'user (name/ID)','value' => '',
            'type' => 'text','rules' => 'required','attr'=>'class="autocomplete"'),
    ...

$pt=db->query("select * from table where systype = 'pt'")->result();
$visit=db->query("select * from table where systype = 'visit'")->result();

edited Feb 13, 2013 at 14:55

answered Feb 13, 2013 at 14:47

Arnold Daniels

16.6k6 gold badges55 silver badges84 bronze badges

Collectives™ on Stack Overflow

search php assoc array (hash map) as mysql

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related