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.
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"
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.