HRD Web logbook scripting

I would like to share my PHP scripting that I am currently using with my Ham Radio logbooks.
My logs are directly uploaded from the Ham Radio Logbook to a MySQL database on my server.

How to install a MySQL data base, Mike WA9PIE has made a good video explaining how.

With my script it is possible to read out a local or remote SQL database.

The script reads out the database and is listed directly on a page.
You can also search for callsings, and partially like i.e. “hb9” or “2rt”

The files can be downloaded here.

logbook v1.22

Changes:

20-04-2018
v1.22 -Added QRA calculation
-Rearranged Rows Time, Date, Year, Flag
-Changed and added LOTW icon's corrensponding to its status.
-Added hover text on Callsign and LOTW
-Added Back button on search page.
-Added Expand view button for viewing fullsize when using iframe or on mobiles.

 

The zip file cointains the following editable files:

a style sheet “logbook.css”

The Style sheet contains all formatting of the whole logbook page, it is tweakable in any way you like.

Let’s take a look at “index.php” file:

$db_host = "hostname" ; // Hostname
$db_port = "3306" ; // Port, if set to 0 it will connect to localhost
$db_user = 'username'; // Username
$db_pass = 'password'; // Password
$db_name = 'mysql-database-name'; // Database Name
$db_table = 'TABLE_HRD_CONTACTS_V01'; // HRD Table name
$db_pagetitle = 'Ham Radio Deluxe online Logbook'; // Page title
$db_booktitle = 'Digital Mode Logbook'; // Logbook Title
$db_typetitle = 'HF,VHF/UHF QSOs'; // Logbook content info
$satellite = false ; // True or False, True if this is a satellite logbook
$results_per_page = 200; // number of results per page

 

$db_host = "hostname"
Here you can enter a url or ip adress of the server that holds the database

$db_port = "3306"
This is the MySQL TCP port, mostly port 3306 is used.
If you enter a value of “0”, then $db_host is overidden and the script connects to the “localhost”
This is mostly used when running the script (website) and MySQL logbook on the same server.

$db_user = "username"
Enter your MySQL username

$db_password = "password"
Enter your MySQL password

$db_name = "mysql-database-name"
Here you can enter the name of your HRD MySQL database.

db_table = "TABLE_HRD_CONTACTS_V01"
HRD logbook uses the name “TABLE_HRD_CONTACTS_V01” by default, but you can change it if needed.

$db_pagetitle = 'Ham Radio Deluxe online Logbook'
This will show ‘Ham Radio Deluxe online Logbook’ as the webpage title.

$db_booktitle = 'Digital Mode Logbook'
Here you can enter the logbook name, it it will show up centered on top of the logbook.

$db_typetitle = 'HF,VHF/UHF QSOs'
Here you can enter what kind of qso’s are logged in this logbook.

$satellite = false ; // True or False, True if this is a satellite logbook
If you set this to True or False a row is added in the table called “SATELLITE”

$results_per_page = 200; // number of results per page
Here you can set the maximum logs per page.