Nov 11, 2021
How to change phpMyAdmin to utilise a domain socket when conecting to MariaDB on the IBM i We use phpMyAdmin to do some important database adminstration on our MySQL databases. phpMyAdmin comes as a free piece of software developed using PHP. The software allows us to...
Apr 14, 2021
How to add autocomplete functionality to an HTML input field to aid selection and permit effortless form field pre-population on the IBM i When presenting users with an HTML form to be filled in it can be helpful to present the user with an autocomplete list of...
Apr 4, 2021
How to call and debug a stored procedure from PHP, the free Community version, with PDO ODBC installed using Yum via Access Client Solutions (ACS) on the IBM i Now that we have the opportunity to run the free Community edition of PHP on the IBM i in part courtesy of...
Dec 29, 2020
Using Bootstrap and Datatables on IBM i with ajax auto-refresh Do you have a requirement to display a table with data that needs to be refreshed regularly and automaticlly on the IBM i? In the following blog we will highlight example code showing how to populate a...
Nov 24, 2020
Using argon2id as part of a 2FA (2 Factor Authentication) process on the IBM i In the following blog we will highlight example code showing how to perform password hashing using argon2id. This is part of a multipart article outlining a complete example web app on the...
Nov 21, 2020
Sending texts as part of a 2FA (2 Factor Authentication) process on the IBM i In the following article we will highlight example code showing how to text directly from the IBM i using just a cellular modem, an asynchronous communication line, an ICF file and all the...
Nov 3, 2020
Creating QR codes and emailing them in a pdf as an attachment from the IBM i QR codes are very much in the news at the moment. QR codes are basically 2D barcodes but with the ability to contain a greater amount of information that can be read much faster and more...
Oct 24, 2020
Here is some simple code that we use to do a mass replace of text strings in physical file source members. It does a case sensitive search and replaces the entire search string with the replacement sting and will always produce data shift if the search and replacement...
Aug 25, 2020
We needed to do a table update remotely over the internet from a very old version of OS/400 (V4R3) using SQL in an RPGLE program on a table which was on a remote machine running a much newer version (V7R1). The connection of the two machines is across the internet....
Aug 25, 2020
First we need to purchase the SSL certificate or certificates. In order to process the purchase we need to create a Certificate Signing Request (CSR). To do this start the HTTP admin server: STRTCPSVR SERVER(HTTP) HTTPSVR(ADMIN) Then goto port 2001 of the HTTP...
