Matching array of string to numbers to get database values

Question

In my database, I have a status column where I'm using numbers to represent a status of a product. Each of these numbers represents a string value, for example 1 is open, 2 is closed, etc. Now to display a count of these statuses in my webpage, I am converting the following numbers into a string to display them to the user:

array(1=>'Open',8=>'Hot',2=>'Closed',3=>'Transacted',4=>'Dead',9=>'Follow Up',11=>'Working')

Now I have this count as a clickable link, where the user can click the count and it takes them to a new page showing the details of that item. For which I'm using this:

<a target='_blank' href='".site_url('reports/viewall?status=' . $status)."'>".$num."</a>

This correctly passes the argument to the URL and shows http://localhost/reports/viewall?status=Closed

Now I'm storing this variable in my controller as $status, but I cannot use this string value in my model query which is this since it is giving the string value of status and not the number related to it:

SELECT * from TABLE1 where status = $status

Controller Class where I'm storing the $status:

$status = $this->input->get('status');
$content['individualleads'] = $this->leads_model->get_all_leads($status )->result();

AbraCadaver · Accepted Answer · 2021-10-21 17:52:45Z

2

I think the best approach would be to pass the integer in the URL and use the array text value only when it is text meant for the user. So just:

http://localhost/reports/viewall?status=2

Another alternative is to flip the array and access the text key:

$status_num = array_flip($array)[$status];

Or search the original array:

$status_num = array_search($status, $array);

Probably more standard might be to have a status_types table with the integer status_id and text status_text for each status and join this when retrieving the status.

edited Oct 21, 2021 at 17:52

answered Oct 21, 2021 at 17:47

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

Collectives™ on Stack Overflow

Matching array of string to numbers to get database values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related