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.


Currency Rate - ECB

Installation Instructions

Currency list

AUD - Australian dollar
BGN - Bulgarian lev
BRL - Brazilian real
CAD - Canadian dollar
CHF - Swiss franc
CNY - Chinese yuan renminbi
CZK - Czech koruna
DKK - Danish krone
EUR - Euro
GBP - Pound sterling
HKD - Hong Kong dollar
HRK - Croatian kuna
HUF - Hungarian forint
IDR - Indonesian rupiah
ILS - Israeli shekel
INR - Indian rupee
ISK - Icelandic krona
JPY - Japanese yen
KRW - South Korean won
MXN - Mexican peso
NOK - Norwegian krone
NZD - New Zealand dollar
PHP - Philippine piso
PLN - Polish zloty
RON - Romanian leu
RUB - Russian rouble
SEK - Swedish krona
SGD - Singapore dollar
THB - Thai baht
TRY - Turkish lira
USD - US dollar
ZAR - South African rand

Daily Test with Code Example

HTML
CSS
JavaScript
PHP-MySQL
Which attribute is used in <a> tag for the address of the link?
src href rel
<a href="http://coursesweb.net/" title="CoursesWeb.net">CoursesWeb.net</a>
Which CSS property sets the type of the text font?
font-family text-decoration font-size
h2 {
  font-family:"Calibri",sans-serif;
}
What instruction selects all the <div> tags with class="cls"?
querySelector("div.cls") getElementsByTagName("div") querySelectorAll("div.cls")
var elm_list = document.querySelectorAll("div.cls");
var nr_elms = elm_list.length;       // number of selected items
alert(nr_elms);
Indicate the function that can be used to get the sum of values in an array.
array_sum() array_diff() array_shift()
$arr =[1, 2, 3, 4);
$arr_sum = array_sum($arr);
echo $arr_sum;       // 10
Currency exchange rates and converter with data from European Central Bank

Last accessed pages

  1. Get and Modify content of an Iframe (32494)
  2. The Mastery of Love (7690)
  3. Download HTM resources (90)
  4. HTML5 Quick Tutorial (5041)
  5. Styling HTML table with CSS (412)

Popular pages this month

  1. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (715)
  2. CSS cursor property - Custom Cursors (94)
  3. Read Excel file data in PHP - PhpExcelReader (71)
  4. PHP-MySQL free course, online tutorials PHP MySQL code (67)
  5. PHP Unzipper - Extract Zip, Rar Archives (53)