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 tag is used to include external CSS file in web page?
<body> <script> <link>
<link href="/templ/style.css" rel="stylesheet" type="text/css" />
Which CSS property sets the text size?
font-weight text-decoration font-size
h2 {
  font-size: 1em;
}
Indicate the JavaScript property that can add HTML code into an element.
text value innerHTML
document.getElementById("someID").innerHTML = "HTML content";
Click on the function that returns the number of characters of a string in PHP.
count() strlen() stristr()
$str = "http://CoursesWeb.net/";
$nr_chr = strlen($str);
echo $nr_chr;       // 22
Currency exchange rates and converter with data from European Central Bank

Last accessed pages

  1. Ajax-PHP Chat Script (44679)
  2. createElement and insertBefore (6461)
  3. Using file_put_contents, file_get_contents, readfile and file() (7478)
  4. Countdown Timer with starting time added into a form (8467)
  5. Add, Change, and Remove Attributes with jQuery (40271)

Popular pages this month

  1. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (656)
  2. Read Excel file data in PHP - PhpExcelReader (371)
  3. PHP-MySQL free course, online tutorials PHP MySQL code (355)
  4. HTML Course - Free Lessons (339)
  5. querySelector and querySelectorAll (322)