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