String not in array?

Question

I'm having troubles with determining if someone is in an array or not:

<?php
    $depts = $db->query("SELECT depts FROM tbl_staff WHERE id = '".$_SESSION['exp_user']['userid']."'");
    $department = $depts->fetch_assoc();

    if (!in_array($forumdn['permissions'],$department)) {
           error_404("Permissions Violation");
           return;
    }

?>

The value of $forumdn['permissions'] given by var_dump is: string(1) "0"

The value of $department given by var_dump is:

array(1) { ["depts"]=> string(13) "0,1,2,3,4,5,6" }

Any ideas?

uargs. strings as list of foreign keys? it might be better to restructure the db and bring it into NF. the query could then be easily made on an sql level without the need to perform the operation in php — knittl
– knittl, Commented Jun 18, 2011 at 19:31
Trying to restructure this would be a complete nightmare - everything would need to be rewritten :/ — bear
– bear, Commented Jun 18, 2011 at 19:35
Shamil: that's why you create an API to access the database. You only have to fix the API internals and the clients accessing it. If you don't structure your code and it is a big spagetti mess you are in trouble :) — Karoly Horvath
– Karoly Horvath, Commented Jun 18, 2011 at 20:14

Jon · Accepted Answer · 2011-06-18 19:28:55Z

2

Try

$department = explode(',', reset($depts->fetch_assoc()));

without any other changes.

Does this do what you need? (I can't be certain because the question isn't worded very clearly to my eyes).

As I read it, the only problem is that $department is indeed an array, but not the array you want. So you have to isolate the first (and only) value in that array with reset (which gives the string "0,1,2,3,4,5,6") and then make that into the array 0 => 0, 1 => 1 etc (using explode) and then finally call in_array.

answered Jun 18, 2011 at 19:28

Jon

439k85 gold badges756 silver badges820 bronze badges

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

2 Comments

Jon Over a year ago

Downvoter: Please help me improve this answer by providing some feedback. Thanks.

bear Over a year ago

Hi Jon - was trying to hit the checkbox.

pseudoramble · Accepted Answer · 2011-06-19 16:41:58Z

According to the results of your var_dump call, it looks like your results is an array with one string in it - all of the departments (comma separated). My suspicion is that you wanted to have the results end up being separated by commas as individual array elements (so, element 1 contains the value "13", elements 2 contains the value "14", etc). You can use explode for this:

$depts = $db->query("SELECT depts FROM tbl_staff WHERE id = '".$_SESSION['exp_user']['userid']."'");
$department = $depts->fetch_assoc();
$department = explode(",", $department);

Then your call to in_array should work dandy!

Ben · Accepted Answer · 2011-06-18 19:29:26Z

1

try :

if (!in_array($forumdn['permissions'], explode("," $department["depts"]))
{
    ....
}

answered Jun 18, 2011 at 19:29

Ben

3052 silver badges6 bronze badges

Collectives™ on Stack Overflow

String not in array?

3 Answers 3

2 Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Related