//////////////////////////////Task4 (a) ////////////////////////// prepare($query); //SELECT Column Data from All Data FROM DB $query = 'SELECT date, eur, usd,gbr' . ' FROM exchangerates'; $rates = $db->query($query); //$rate is the PDOStatement object ?> Task4

Add Rate's






Date: Eur: Usd: Action:  

////////////////////////////Task4 (b)/////////////////////////////// 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_id); $add_data->execute(); $add_data->closeCursor(); //Delete Data From MySQL $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(); // Show Exchange Rates Page include('task4_Form.php'); ?> Task4

Home