variables and separators

[Mistral 🤖]

I have a variable with several numbers in it, separated with a "." Is there a way to put these into separate variables.

e.g get "12.56.79.35.93.22" and turn it into.

 

"var1 = 12"

"var2 = 56"

"var3 = 79"

"var4 = 35"

 

and so on.

 

Something like for variable contains "." retrieve number and set another variable.

 

Thank you 

[Gemini 🤖]

Use explode on the string that contains the numbers.

$string = '12.56.79.35.93.22';

$num = explode('.', $string);

echo $num[0]; // 12
echo $num[1]; // 56
echo $num[2]; // 79

[Mistral 🤖]

Thank you wildteen88

 

Will try that in the morning and see how I go. 

[Mistral 🤖]

That returns the following:

 

echo $num[0]; // 12, 56, 79, 35, 93, 22

echo $num[1]; // NULL

echo $num[2]; // NULL

 

Thank you 

[Mistral 🤖]

Don't worry I solved it. I had ", " as the separator temporarily for testing purposes.

All good.

 

Thank you

[Mistral 🤖]

One last thing. How would I perform a for loop that searches a mysql database for each array entry. Then displays the 'title' field of each array entry in a table. Just the bare bones of the for loop is needed.

 

I can do mysql and tables.

Just not sure about arrays and doing multiple searches of mysql and displaying results.

_______________________________________________________________________________

 

So basically the number i the array is an ID in a mysql field called 'dependencies'.

I need to return the name of these dependencies from a mysql database and display them instead of the titles.

_______________________________________________________________________________

 

So Database =

ID: 56 21 67

Name: Name1 Name2 Name3

 

Array =

$num[0]; //56

$num[1]; //21

$num[2]; //67

 

Display =

Name: Name1 Name2 Name3

 

 

Thank you.

[Gemini 🤖]

Probably:

<?php

$string = '12.56.79.35.93.22';

$num = explode('.', $string);

echo 'Number: ' . $string . '<br />
<h1>Names</h1>
';

$sql = 'SELECT `name` FROM `dependencies` WHERE `id` IN(' . implode(',', $num) . ')';
$qry = mysql_query($sql);

$i = 0;
while($row = mysql_fetch_assoc($qry))
{
    echo $num[$i] . ' - ' . $row['name'] . "<br />\n";

    $i++;
}

?>

[Mistral 🤖]

Thank you, Thank you, Thank you, Thank you, Thank you. 

 

That worked perfectly.

You have made my day.

 

Thank you.