public function insertToDB($tableName, $listOfObjects)
{
$con = conFatory();
mysqli_query($con, "TRUNCATE TABLE {$tableName}");
switch ($tableName) {
case 'country':
$first = true;
$sqlstring = "INSERT INTO country (capital,car_code,datacode,gdp_agri,gdp_ind,gdp_serv,gdp_total,government,id,indep_date,infant_mortality,inflation,name,population,population_growth,total_area) VALUES ";
foreach ($listOfObjects as $country) {
if (!$first) {
$sqlstring .= ",";
} else {
$first = false;
}
$sqlstring .= "('" . $country->getCapital() . "','" . $country->getCarcode() . "','" . $country->getDatacode() . "'," . floatval($country->getGdp_agri()) . "," . floatval($country->getGdp_ind()) . "," . floatval($country->getGdp_serv()) . ",";
$sqlstring .= floatval($country->getGdp_total()) . ",'" . $country->getGoverment() . "','" . $country->getId() . "','" . $country->getIndep_date() . "','" . $country->getInfant_mortality() . "',";
$sqlstring .= floatval($country->getInflation()) . ",'" . $country->getName() . "'," . intval($country->getPopulation()) . "," . floatval($country->getPopulation_growth()) . "," . intval($country->getTotal_area()) . ")";
}
$sqlstring .= ";";
mysqli_query($con, $sqlstring);
break;
case 'city':
$first = true;
$sqlstring = "INSERT INTO city (country,id,latitude,longitude,name,province) VALUES ";
foreach ($listOfObjects as $city) {
if (!$first) {
$sqlstring .= ",";
} else {
$first = false;
}
$sqlstring .= "('" . $city->getCountry() . "','" . $city->getId() . "'," . floatval($city->getLatitude()) . "," . floatval($city->getLongtitude()) . ",'" . $city->getName() . "','" . $city->getProvince() . "')";
}
$sqlstring .= ";";
mysqli_query($con, $sqlstring);
break;
case 'continent':
$first = true;
$sqlstring = "INSERT INTO continent (id,name) VALUES ";
foreach ($listOfObjects as $continent) {
if (!$first) {
$sqlstring .= ",";
} else {
$first = false;
}
$sqlstring .= "('" . $continent->getId() . "','" . $continent->getName() . "')";
}
$sqlstring .= ";";
mysqli_query($con, $sqlstring);
break;
default:
# code...
break;
}
mysqli_close($con);
}
private function dbReplace($searchKey, $name, $capital, $population)
{
$con = conFatory();
mysqli_query($con, "UPDATE country SET name='" . $name . "', capital='" . $capital . "', population=" . $population . " WHERE id='" . $searchKey . "'");
mysqli_close($con);
}