//////////////////////////////Task5 //////////////////////////
query($query); //$rate is the PDOStatement object
//Add Data
$r_Date = date("Y-m-d");;
$r_EUR = 8;
$r_USD = 11;
$r_GBR = 12;
$date_id = 0;
//Function to Get Data from DB
function get_data() {
global $db;
$query = $query = 'SELECT date, eur, usd,gbr'
. ' FROM exchangerates';
$exrate = $db->query($query);
return $exrate;
}
//Function TO Add Data to MySQL
function add_data($r_Date, $r_EUR, $r_USD, $r_GBR){
global $db;
$query = "INSERT INTO exchangerates
(date,eur, usd, gbr)
VALUES
(:r_Date,:r_EUR, :r_USD, :r_GBR)";
$add_data = $db->prepare($query);
$add_data->bindValue(':r_EUR', $r_EUR);
$add_data->bindValue(':r_USD', $r_USD);
$add_data->bindValue(':r_GBR', $r_GBR);
$add_data->bindValue(':r_Date', $r_Date);
$add_data->execute();
$add_data->closeCursor();
return $add_data;
}
//Function To Delete Data From MySQL
function delete_data($date_id) {
global $db;
$query = "DELETE FROM exchangerates
WHERE date = :date_id";
$delete_data = $db->prepare($query);
$delete_data->bindValue(':date_id', $date_id);
$delete_data->execute();
$delete_data->closeCursor();
return $delete_data;
}
?>
Task5