Currency exchange rates and converter with data from European Central Bank

Php-mysql Course

Application made with PHP and JavaScript that displays and converts currency exchange rates with data from European Central Bank (ECB).
This script displays foreign exchange rates according to a base currency, and it can convert the sum of a currency in the other currencies (optionally you can calculate the sum with a VAT percentage).
The script uses the exchange rates from an .xml file directly from ECB, and can be registered into a MySQL database. It uses cache file that is actualized every 5 hours and around 16:00 CET (when data from ECB is usually updated).

- This application can easily be included in any web page, with a simple HTML code. Installation instructions in a "readme.txt" file in the archive with the script.

Installation Instructions

• Download and unzip the archive from the Download link (above).
• By default the script uses only text file with data from ECB saved in the "cache" folder. If you want to register data into a MySQL database, open the file "ce_ecb.php" and edit the values of these constants: STORE and CONN_MYSQL.
  1. For STORE, replace 'file' with 'mysql'.
  2. In CONN_MYSQL add your data to connect to MySQL:
     ['host'=>'localhost', 'user'=>'user_name', 'pass'=>'password', 'bdname'=>'db_name']
• Copy the "ce_ecb" folder in the Root folder of your website (www, public_html or htdocs).
• Give writable permissions to the "cache" directory, CHMOD(0755), or 0777.
• If you register data in MySQL, access the page "create_table.php" in your browser (in the "ce_ecb" folder) to create the table in your database.
  //site_name.net/ce_ecb/create_table.php
• In the page where you want to include this script add the following HTML code (in the place where you want to display this application):

  <div id='ce_ecb' data-def_ce='EUR: USD, GBP, HKD, JPY' data-cv_ce='1'>
  <h4>Currency Rate - ECB</h4>
  </div>
  <script src='/ce_ecb/ce_ecb.js'></script>
  

  - The "data-def_ce" attribute contains these values: "BASE: currencies to be initially displayed" (separated by commas), in order of display.
  For example, in the code above, EUR is the base, and the script will display the rates for the specified foreign currencies: USD, GBP, HKD, JPY (according to base). Below is the list of valid currencies.
  - The "data-cv_ce" attribute determines to add or not the currency converter area. Put the value 0 if you want to not display the converter area ( data-cv_ce="0" ).
• The VAT value can be changed in the "ce_ecb.js" file (it is also editable in the page), in the code:
  '..<b id="cv_vat" contenteditable>9</b> %..'

Currency list