Splitting a variable

[whiteboikyle]

$name = 'Kyle Cribbs';

 

how to make this into an array like

$array[0] = Kyle;

$array[1] = Cribbs;

I know there is a php function that will do this but dont know what it is -.- haha

[AyKay47]

$name = 'Kyle Cribbs';
$explode = explode(" ",$name);

[whiteboikyle]

THANKS!

another question this doesnt really regard that, well kinda, but lets say i exploded it like so

$fullName = 'kyle cribbs'

$name = explode(' ', $fullName);

 

how would i do a 'like' SQL using an array?

like this?

SELECT * FROM `users` WHERE `name` LIKE '%$name%'

[MasterACE14]

THANKS!

another question this doesnt really regard that, well kinda, but lets say i exploded it like so

$fullName = 'kyle cribbs'

$name = explode(' ', $fullName);

 

how would i do a 'like' SQL using an array?

like this?

SELECT * FROM `users` WHERE `name` LIKE '%$name%'

 

$fullName = 'kyle cribbs'
$name = explode(' ', $fullName);

$sql = "SELECT * FROM `users` WHERE `name` LIKE '%".$name[0]."%'"; // $name[0] = kyle , $name[1] = cribbs

[whiteboikyle]

What if its more then 2 arrays

[jcbones]

Then:

$fullName = 'kyle cribbs'
$name = explode(' ', $fullName);

foreach($name as $value) {
$search[] = "`name` LIKE '%$value%'";
}

$sql = "SELECT * FROM `users` WHERE " . implode(' OR ', $search); //name LIKE '%kyle%' OR name LIKE '%cribbs%'

[AyKay47]

Then:

$fullName = 'kyle cribbs'
$name = explode(' ', $fullName);

foreach($name as $value) {
$search[] = "`name` LIKE '%$value%'";
}

$sql = "SELECT * FROM `users` WHERE " . implode(' OR ', $search); //name LIKE '%kyle%' OR name LIKE '%cribbs%'

good solution..