lost and confused with an array - help

phpdeano

I have never really understood "for" loops, which I think I need here but I am confused and trying to learn.

I am reading a response from an http post using:

$ret = file($url);

I am then using:

$send = split(" ",$ret[0]);
$send1 = count($send);
echo "count = ",$send1;

foreach($send as $messageid)
{
echo "message id = ",$messageid,"<p>";
}

which shows the info 1 line at a time, but is very messy and I am confused.

The response from the web page reads:

ID: 81f9221c92deaa058ad56ab4192e45b3 To: xxxxxxxxx ID: 7eb83d2a00dd15e56a13a7bd74c0ed6c To: yyyyyyyyyy

all in one line and what I actually need to do is write each "ID" and each "To" to a mysql database.

I have searched the forum but can not find anything that I am able to understand enough to resolve the problem.

Would someone please give me some pointers as to what functions I should look at, otherwise it is going to be a very long day!

Thanks

shawon22

try this code
$string = "ID: 81f9221c92deaa058ad56ab4192e45b3 To: xxxxxxxxx ID: 7eb83d2a00dd15e56a13a7bd74c0ed6c To: yyyyyyyyyy";

//space is the seperator
$seperator = " ";
$arr_string = explode($seperator, $string);

for($i=0; $i<count($arr_string); $i++)
{

echo "ID: $arr_string[$i+1] TO: $arr_string[$i+2] <BR>";

$i = $i + 2;
}

phpdeano

Thanks, I appreciate your time and patience helping me out.

That works, I had more spaces in the array than in my example so I needed to change the last section a bit but it works, Thanks.

Now all I need is to work out is how to write the info into a mysql table.

I understand how to do it when I have static info, ie one value for each field name, not sure what to do wjhen each filed has more than one value. I loop I guess.

Any suggestion would be greatly appreciated.

phpdeano

All sorted, just being dumb!

Final script reads, in case anyone else looks for this problem one day:

// Connecting, selecting database
$link = mysql_connect("localhost", "root")
or die("Could not connect");

mysql_select_db("autoalertdb")
or die("Could not select database");

$url = "http://localhost/multiresponse.htm";

$ret = file($url);

foreach ($ret as $names)

//space is the seperator
$seperator = " ";
$arr_string = explode($seperator, $names);
for($i=0; $i<count($arr_string); $i++)
{

if (($apimsgid = $arr_string[$i+1]) && ($recipient = $arr_string[$i+3]))
{
echo $apimsgid,"<br>";

$sql = "INSERT into logs (apimsgid, recipient)
values ('$apimsgid', '$recipient')";
// run SQL against the DB
$result = mysql_query($sql)
or die("Adding new message failed!");
}
$i = $i + 3;

}

Many thanks to shawon22 for the original reply, much better understanding now, thanks.