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...
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...
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...
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...
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...
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...
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...
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....
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...
In this article we outline a way to implement PHPMailer to send emails from the IBM i. The emails can have attachments such as pdf’s and can be sent with SSL/TLS encryption. The PHPMailer software runs using PHP on the IBM i. It does not need a webserver to be...
