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 renders as emphasized text, displaying the text oblique?
<strong> <pre> <em>
<p>Web development courses: <em>CoursesWeb.net</em></p>
Which CSS property defines the space between the element border and its content?
margin padding position
h3 {
  padding: 2px 0.2em;
}
Click on the method which returns the first element that matches a specified group of selectors.
getElementsByName() querySelector() querySelectorAll()
// gets first Div with class="cls", and shows its content
var elm = document.querySelector("div.cls");
alert(elm.innerHTML);
Indicate the PHP variable that contains data from a form sent with method="post".
$_SESSION $_GET $_POST
if(isset($_POST["field"])) {
  echo $_POST["field"];
}
Currency exchange rates and converter with data from European Central Bank

Last accessed pages

  1. Select in MySQL, Output results in HTML Table (12916)
  2. Disable button and Enable it after specified time (9566)
  3. PHP getElementById and getElementsByTagName (38778)
  4. Display data from PHP Array, or MySQL in HTML table (19267)
  5. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (107205)

Popular pages this month

  1. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (448)
  2. Register and show online users and visitors (324)
  3. PHP-MySQL free course, online tutorials PHP MySQL code (243)
  4. JavaScript Course - Free lessons (237)
  5. querySelector and querySelectorAll (224)