THANK YOU VERY MUCH FOR THE HELP i managed to work the code, every thing works great except that the in the database table i have only one row in it , and that is the last content from the result (41) . Here is the code
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "database";
$file_name = basename(__FILE__,'.php');
include("XMLSoccer.php");
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
//CHECKING IF TABLE EXIST IF NOT CREATE NEW
$table = $file_name;
$query = "SELECT ID FROM " . $table;
$resultat = mysqli_query($conn,$query);
if(empty($resultat)) {
echo "<p>" . $table . " table does not exist</p>";
$query = mysqli_query($conn,"CREATE TABLE IF NOT EXISTS $file_name (
Id int NOT NULL PRIMARY KEY,
Name varchar(255) NOT NULL,
Country varchar(255) NOT NULL,
Historical_Data varchar(255) NOT NULL,
Fixtures varchar(255) NOT NULL,
Livescore varchar(255) NOT NULL,
NumberOfMatches varchar(255) NOT NULL,
LatestMatch varchar(255) NOT NULL,
IsCup varchar(255) NOT NULL
)");
}
else {
echo "<p>" . $table . "table exists</p>";
} // else
/////GETING THE DATA FROM SERVICE
try {
$soccer = new XMLSoccer($api_key);
$soccer->setServiceUrl("http://www.xmlsoccer.com/FootballDataDemo.asmx");
$result = $soccer->GetAllLeagues();
print_r($result);
} catch (XMLSoccerException $e) {
echo "XMLSoccerException: " . $e->getMessage();
}
foreach ($result->League as $team) {
$leagueid = $team->Id;
$name = $team->Name;
$country = $team->Country;
$historical_Data = $team->Historical_Data;
$fixtures = $team->Fixtures;
$livescore = $team->Livescore;
$numberOfMatches = $team->NumberOfMatches;
$latestMatch = $team->LatestMatch;
$isCup = $team->IsCup;
}
///INSERTING DATA INTO THE TABLE
$sql = "INSERT INTO $file_name (Id, Name, Country, Historical_Data, Fixtures, Livescore, NumberOfMatches, LatestMatch, IsCup)
VALUES ('$leagueid', '$name', '$country', '$historical_Data', '$fixtures', '$livescore', '$numberOfMatches', '$latestMatch', '$isCup')on duplicate key update id='$leagueid'";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>
The response
testtable exists
SimpleXMLElement Object ( [League] => Array ( [0] => SimpleXMLElement Object ( [Id] => 1 [Name] => English Premier League [Country] => England [Historical_Data] => Yes [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 6080 [LatestMatch] => 2016-05-17T21:00:00+00:00 [IsCup] => false )
[1] => SimpleXMLElement Object ( [Id] => 2 [Name] => English League Championship [Country] => England [Historical_Data] => Yes [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 8925 [LatestMatch] => 2016-05-07T13:30:00+00:00 [IsCup] => false )
[2] => SimpleXMLElement Object ( [Id] => 3 [Name] => Scottish Premier League [Country] => Scotland [Historical_Data] => Yes [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 3648 [LatestMatch] => 2016-05-15T13:30:00+00:00 [IsCup] => false )
[3] => SimpleXMLElement Object ( [Id] => 4 [Name] => Bundesliga [Country] => Germany [Historical_Data] => Yes [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 4897 [LatestMatch] => 2016-05-14T15:30:00+00:00 [IsCup] => false )
[4] => SimpleXMLElement Object ( [Id] => 5 [Name] => Serie A [Country] => Italy [Historical_Data] => Yes [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 5784 [LatestMatch] => 2016-05-15T20:45:00+00:00 [IsCup] => false )
[5] => SimpleXMLElement Object ( [Id] => 6 [Name] => Serie B [Country] => Italy [Historical_Data] => Yes [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 7249 [LatestMatch] => 2016-05-20T20:30:00+00:00 [IsCup] => false )
[6] => SimpleXMLElement Object ( [Id] => 7 [Name] => Ligue 1 [Country] => France [Historical_Data] => Yes [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 5932 [LatestMatch] => 2016-05-14T21:00:00+00:00 [IsCup] => false )
[7] => SimpleXMLElement Object ( [Id] => 8 [Name] => La Liga [Country] => Spain [Historical_Data] => Yes [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 6080 [LatestMatch] => 2016-05-15T19:30:00+00:00 [IsCup] => false )
[8] => SimpleXMLElement Object ( [Id] => 9 [Name] => Superleague Greece [Country] => Greece [Historical_Data] => Yes [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 3898 [LatestMatch] => 2016-04-17T18:00:00+00:00 [IsCup] => false )
[9] => SimpleXMLElement Object ( [Id] => 10 [Name] => Eredivisie [Country] => Holland [Historical_Data] => Yes [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 4896 [LatestMatch] => 2016-05-08T14:30:00+00:00 [IsCup] => false )
[10] => SimpleXMLElement Object ( [Id] => 11 [Name] => Jupiler League [Country] => Belgium [Historical_Data] => Yes [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 4400 [LatestMatch] => 2016-03-13T18:00:00+00:00 [IsCup] => false )
[11] => SimpleXMLElement Object ( [Id] => 12 [Name] => Süper Lig [Country] => Turkey [Historical_Data] => Yes [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 4954 [LatestMatch] => 2016-05-30T00:00:00+00:00 [IsCup] => false )
[12] => SimpleXMLElement Object ( [Id] => 14 [Name] => Superliga [Country] => Denmark [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 988 [LatestMatch] => 2016-07-16T18:30:00+00:00 [IsCup] => false )
[13] => SimpleXMLElement Object ( [Id] => 15 [Name] => EURO 2012 [Country] => Europe [Historical_Data] => Partial [Fixtures] => False [Livescore] => False [NumberOfMatches] => 31 [LatestMatch] => 2012-07-01T20:45:00+00:00 [IsCup] => false )
[14] => SimpleXMLElement Object ( [Id] => 16 [Name] => Champions League [Country] => Europe [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 704 [LatestMatch] => 2016-05-04T20:45:00+00:00 [IsCup] => true )
[15] => SimpleXMLElement Object ( [Id] => 17 [Name] => Europe League [Country] => Europe [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 1477 [LatestMatch] => 2016-05-18T20:45:00+00:00 [IsCup] => true )
[16] => SimpleXMLElement Object ( [Id] => 18 [Name] => Primeira Liga [Country] => Portugal [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 1070 [LatestMatch] => 2016-05-15T18:00:00+00:00 [IsCup] => false )
[17] => SimpleXMLElement Object ( [Id] => 19 [Name] => Scottish First Division [Country] => Scotland [Historical_Data] => Yes [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 2881 [LatestMatch] => 2016-05-01T13:30:00+00:00 [IsCup] => false )
[18] => SimpleXMLElement Object ( [Id] => 20 [Name] => Major League Soccer [Country] => USA [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 1024 [LatestMatch] => 2016-07-17T04:30:00+00:00 [IsCup] => false )
[19] => SimpleXMLElement Object ( [Id] => 33 [Name] => Allsvenskan [Country] => Sweden [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 817 [LatestMatch] => 2016-07-16T16:00:00+00:00 [IsCup] => false )
[20] => SimpleXMLElement Object ( [Id] => 34 [Name] => FA Cup [Country] => England [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 238 [LatestMatch] => 2016-05-21T18:30:00+00:00 [IsCup] => false )
[21] => SimpleXMLElement Object ( [Id] => 35 [Name] => League Cup [Country] => England [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 240 [LatestMatch] => 2016-01-27T20:45:00+00:00 [IsCup] => false )
[22] => SimpleXMLElement Object ( [Id] => 36 [Name] => Mexican Primera League [Country] => Mexico [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 788 [LatestMatch] => 2016-07-17T04:00:00+00:00 [IsCup] => false )
[23] => SimpleXMLElement Object ( [Id] => 37 [Name] => Brasileirao [Country] => Brazil [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 1257 [LatestMatch] => 2016-07-16T23:30:00+00:00 [IsCup] => false )
[24] => SimpleXMLElement Object ( [Id] => 38 [Name] => English League 1 [Country] => England [Historical_Data] => Yes [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 2209 [LatestMatch] => 2016-05-08T13:30:00+00:00 [IsCup] => false )
[25] => SimpleXMLElement Object ( [Id] => 39 [Name] => English League 2 [Country] => England [Historical_Data] => Yes [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 2211 [LatestMatch] => 2016-05-07T16:00:00+00:00 [IsCup] => false )
[26] => SimpleXMLElement Object ( [Id] => 40 [Name] => Ukrainian Premier League [Country] => Ukraine [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 550 [LatestMatch] => 2016-05-15T18:30:00+00:00 [IsCup] => false )
[27] => SimpleXMLElement Object ( [Id] => 41 [Name] => Russian Football Premier League [Country] => Russia [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 732 [LatestMatch] => 2016-05-21T12:30:00+00:00 [IsCup] => false )
[28] => SimpleXMLElement Object ( [Id] => 42 [Name] => Australian A-League [Country] => Australia [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 294 [LatestMatch] => 2016-04-10T09:00:00+00:00 [IsCup] => false )
[29] => SimpleXMLElement Object ( [Id] => 43 [Name] => World Cup 2014 [Country] => International [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 64 [LatestMatch] => 2014-07-13T21:00:00+00:00 [IsCup] => true )
[30] => SimpleXMLElement Object ( [Id] => 44 [Name] => Tippeligaen [Country] => Norway [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 602 [LatestMatch] => 2016-07-16T18:00:00+00:00 [IsCup] => false )
[31] => SimpleXMLElement Object ( [Id] => 45 [Name] => Chinese Super League [Country] => China [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 544 [LatestMatch] => 2016-07-16T13:35:00+00:00 [IsCup] => false )
[32] => SimpleXMLElement Object ( [Id] => 46 [Name] => Lega Pro [Country] => Italy [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 2040 [LatestMatch] => 2016-05-08T18:00:00+00:00 [IsCup] => true )
[33] => SimpleXMLElement Object ( [Id] => 47 [Name] => 2. Bundesliga [Country] => Germany [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 608 [LatestMatch] => 2016-05-15T15:30:00+00:00 [IsCup] => false )
[34] => SimpleXMLElement Object ( [Id] => 48 [Name] => Adelante [Country] => Spain [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 922 [LatestMatch] => 2016-06-04T20:30:00+00:00 [IsCup] => false )
[35] => SimpleXMLElement Object ( [Id] => 49 [Name] => Ligue 2 [Country] => France [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 754 [LatestMatch] => 2016-05-13T20:45:00+00:00 [IsCup] => false )
[36] => SimpleXMLElement Object ( [Id] => 50 [Name] => Superettan [Country] => Sweden [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 598 [LatestMatch] => 2016-07-03T18:00:00+00:00 [IsCup] => false )
[37] => SimpleXMLElement Object ( [Id] => 51 [Name] => Brasileirão Série B [Country] => Brazil [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 913 [LatestMatch] => 2016-07-17T02:00:00+00:00 [IsCup] => false )
[38] => SimpleXMLElement Object ( [Id] => 52 [Name] => Norwegian 1. Divisjon [Country] => Norway [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 615 [LatestMatch] => 2016-07-11T19:00:00+00:00 [IsCup] => false )
[39] => SimpleXMLElement Object ( [Id] => 53 [Name] => Ekstraklasa [Country] => Poland [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 483 [LatestMatch] => 2016-07-16T20:30:00+00:00 [IsCup] => false )
[40] => SimpleXMLElement Object ( [Id] => 54 [Name] => Primera Division [Country] => Argentina [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 679 [LatestMatch] => 2016-05-24T02:15:00+00:00 [IsCup] => false )
[41] => SimpleXMLElement Object ( [Id] => 56 [Name] => EURO 2016 [Country] => International [Historical_Data] => Partial [Fixtures] => Yes [Livescore] => Yes [NumberOfMatches] => 48 [LatestMatch] => 2016-07-10T21:00:00+00:00 [IsCup] => true )
)
[AccountInformation] => Data requested at 7/17/2016 11:05:08 AM .
)
New record created successfully
Process finished with exit code 0