Search through a json array obtained from a database

Question

First of all: Yes i did check other answers but they sadly didn't do the trick.

So i'm currently working on a script that checks if an email exists in the database. So the database data is obtained through a webservice and with an input filter function the following JSON object is returned:

{"customers":{"customer":{"lastname":"test","firstname":"login","email":"[email protected]"}}}

Now i would like to check if the email is filled in correctly. I'm using a foreach() statement to compare the values but i'm always getting a not found returned. Maybe someone here is able to find the mistake i've made. So the full code is shown down below.

$resultEmail = ($webService->get( $optUser ));

$emailResult = json_encode($resultEmail);
$emailArray = json_decode($resultEmail);

echo ($emailResult);
echo ($chopEmail);
foreach($emailArray->customers->customer as $item)
{
    if($item->email == $email)
    {
        echo "found it!";
    }
}

// The $optUser is the JSON object

$emailResult is a json object. You can not use it in array. — urfusion
– urfusion, Commented Nov 30, 2017 at 12:57
@jeroen php will execute a foreach if an StdClass is passed to it — William Perron
– William Perron, Commented Nov 30, 2017 at 13:02
@WilliamPerron You're right, and not only StdClass it seems... — jeroen
– jeroen, Commented Nov 30, 2017 at 13:05
Why do you use json_encode on the json before you use json_decode? Wouldn't that give the original result? Also the returned string looks a bit strange, you have an object customers with an object customer, not with an array of customer objects — rypskar
– rypskar, Commented Nov 30, 2017 at 13:06
@rypskar Yeah i'm aware of that but that's how the database of prestashop is build. Can't do much about that. — Deathstorm
– Deathstorm, Commented Nov 30, 2017 at 13:07

Nazariy · Accepted Answer · 2017-11-30 12:59:46Z

1

Probably the quickest way would be strpos function, so you can use it this way

function hasEmail($string, $email)
{
    return strpos($string, $email) !== false;
}

//example
echo hasEmail($resultEmail, $email) ? 'Has email' : 'Email not found';

answered Nov 30, 2017 at 12:59

Nazariy

6,0785 gold badges40 silver badges61 bronze badges

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

1 Comment

Deathstorm Over a year ago

Great! I already took a look at strpos() but at first it didn't work. Now it does, thank you for your explanation and answer!

William Perron · Accepted Answer · 2017-11-30 13:10:43Z

0

The easiest way to do this would probably be to decode the string as an associative array instead of a json object, and then check if the key email exists using the array_key_exists function.

// passing true to json_decode will make it return an array
$emailArray = json_decode($resultEmail, true);

foreach($emailArray['customers'] as $customer) {
    if(array_key_exists('email', $customer)) {
        echo 'Found it!';
    }
}

answered Nov 30, 2017 at 13:10

William Perron

1,39813 silver badges19 bronze badges

Comments

Lebr1 · Accepted Answer · 2017-11-30 13:16:52Z

0

It seems your mistake come from the foreach loop. You should write it this way :

foreach($emailArray->customers as $customer) {
    if($customer->email == $email) {
        echo "found it!";
    }
}

Please note that $emailArray is not an array but an object when you don't set the second parameter of the json_decode function :

$obj = json_decode($data);
$array = json_decode($data,true);

answered Nov 30, 2017 at 13:16

Lebr1

513 bronze badges

Collectives™ on Stack Overflow

Search through a json array obtained from a database

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related