$data = file_get_contents('http://api.eveonline.com/eve/AllianceList.xml.aspx');
$xml = new SimpleXMLElement($data);
#var_dump($xml);

foreach ($xml->result->rowset->row as $row)
{
echo (string)$row{'name'};
echo (Int)$row{'allianceID'};
}

echo $row{'name'};
echo $row{'allianceID'};

echo $row['name'];
echo $row['allianceID'];

Basic PHP:



should be;



Notice the brackets.

Fatal error: Maximum execution time of 30 seconds exceeded in G:\xampp\htdocs\post\a.php on line 23

$data = file_get_contents('http://api.eveonline.com/eve/AllianceList.xml.aspx');
$xml = new SimpleXMLElement($data);
#var_dump($xml);

foreach ($xml->result->rowset->row as $row)
{
$con = mysql_connect("********","*********","**********");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("timers", $con);

$row1 =(string)$row['name'];
$row2 = (Int)$row['allianceID'];

mysql_query("INSERT INTO alliance (allianceName, allianceID) VALUES('$row1', '$row2')");
mysql_close($con);
}

$data = file_get_contents('http://api.eveonline.com/eve/AllianceList.xml.aspx');
$xml = new SimpleXMLElement($data);
#var_dump($xml);

foreach ($xml->result->rowset->row as $row)
{
$alliances[$row['allianceID']]=$row['name'];
}

$i=1;
foreach ($alliances as $k => $v) {
if ($i >50) {
mysql_query ($sql); //May want to do something with the result
$sql='"INSERT INTO tablename VALUES ";
}
$sql.= "($k,$v),";
$i++;
}

This is the error i am getting cause mysql times out after 30 seconds


here is my code with the MySql tried both in and outside the for each.

now the results are been placed in the database just it times out once i got 545 results in and the other time 450

@ini_set('max_execution_time', 300); //300 seconds = 5 minutes

First thing you need to do is stop trying to create a new database connection on each time through the loop and than closing it

foreach ($xml->result->rowset->row as $row)
{
$con = mysql_connect("********","*********","**********");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

....

mysql_query("INSERT INTO alliance (allianceName, allianceID) VALUES('$row1', '$row2')");
mysql_close($con);
}

should be

$con = mysql_connect("********","*********","**********");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
foreach ($xml->result->rowset->row as $row)
{

...

mysql_query("INSERT INTO alliance (allianceName, allianceID) VALUES('$row1', '$row2')");
}
mysql_close($con);

The way you are doing it now you're wasting a lot of time just opening and closing the connections.

You should open the database connection after getting your data from the API then insert all of your data. What you are asking it to do now is make a few thousand connects and insert a single row then disconnect. I think you'll find that correct will solve you timeout errors.

I'd also suggest you look at using one of the many existing PHP API libraries that others have developed since that will save you a lot of work in the long run.

Also, you can try to increase the execution time of the PHP script either by editing php.ini (best method) or by including this line near the top of your PHP script (sometimes works).