convert to array

pedroteixeira07

Hello,

I need help PLEASE!

I'm posting an array in this format from Android OS:

[date1=1999-04-22, date2=2000-09-11, keyword=["whatever","testing"]]

I can get the date1 and date2 value in php with this:

$data1 = $_POST['date1'];
$data2 = $_POST['date2'];

How can I get the list of keywords to an array lets say keywords[]

Can someone please help me with this? I've been on and on with this... I've tried to put it on a JSON String format then decoding to Array.. I don't know how else I can use it... posterior I implode the Array to perform a query so I need it to be in a variable like $keyword and be an array

HELP PLEASE 🙁

dagon

explode()

pedroteixeira07

Ok thank you .. still I don't know how to do that.. something like this

$keys=$_POST['keyword'];

$keywordtosendtoquery = explode(",", $keys);

Will that work and transform this: keyword=["whatever","testing"] into a normal array ?

I don't know how to test it since I don't know how to create a variable with thoose values...

dagon

<?php
$_POST['keyword']='["whatever","testing"]';
$exp=explode(',',trim($_POST['keyword'],"[]"));
print_r($exp);
//Array ( [0] => "whatever" [1] => "testing" ) 
?>

pedroteixeira07

Oh thank you very much. It's working perfectly .. I wasn't going to find the solution so soon. MAde my day

Thank you again

pedroteixeira07

<?php
$POST['keyword']='["whatever","testing"]';
$exp=explode(',',trim($POST['keyword'],"[]"));
print_r($exp);
//Array ( [0] => "whatever" [1] => "testing" )
?>

One last question.. can I trim the ""'s out?

When I perform the query:

"SELECT SP.ServicePic_ID, SP.ServicePic FROM Service_Pic SP, Keyword K, SPKeywords SPK WHERE SP.ServicePic_ID=SPK.ServicePic_ID AND SPK.Keyword_ID=K.Keyword_ID AND K.Keyword IN ('" . implode("','", $keyword) . "')"

It doesn't use the correct format .. the IN statment stays something like:

IN ('"whatever"','"testing"')

dagon

str_replace()

Saviola

dagon;10955877 wrote:
str_replace()

$_POST['keyword']='["whatever","testing"]'; 
$exp=explode(',',str_replace('"', '',trim($_POST['keyword'],"[]")));
print_r($exp);
//Array ( [0] => whatever [1] => testing )

pedroteixeira07

Thank you for your answers! It's working now..

Besides all that trimming and replacing I also had to replace like this after those steps:

$exp=trim($exp('///','');

Aparentlly the format I saw the Android debugger sending is not the one that actually arrives to the PHP.. thoose characters come appended god knows why! Anyway. Isworking. Fine for me.

Thank you all!