Hello Programmers

By greg | Posted in RPG Intro
Hello Programmers

This FREE site is dedicated to all professional programmers trying to write clear structured code, network their pc's and, in some cases, deal with web site issues. We have free source code, free samples, free tips and techniques, free utilities, free sample test questions and answers, free downloads, free books and manuals, free examples. You do...
Read more »

change root password in MySQL

By greg | Posted in MySQL

how to change / fix the root password in MySQL from a root command prompt, stop mysql and then restart it in a controlled mode: /etc/init.d/mysql stop or service mysql stop then /usr/sbin/mysqld --skip-grant-tables --skip-networking & --skip-grant-tables is...
Read more »

How to install and customize-personalize Zen-Cart Fast

By greg | Posted in PHP Zen-Cart
How to install and customize-personalize Zen-Cart Fast

Tutorial help: how to find settings to set up, customize, Zen-Cart Fast. What Zen-Cart Won't Tell You Running the installation program is easy. The time consuming part is removing their sample...
Read more »

Delete the Zen-Cart Store Demo files, images, and Data

By greg | Posted in PHP Zen-Cart
Delete the Zen-Cart Store Demo files, images, and Data

"How to clean up default install and remove example store related files." How to remove, or delete, the "Zen Cart demonstration categories and products". How to Delete all the Zen-Cart Sample Store files, images, and...
Read more »

Function: Convert Numbers to Words

By greg | Posted in PHP Advanced

This little, recursive, script is to convert a number, an integer, to words. It has an upper limit of 999,999,999 but you can expand or reduce it from there. Put the function in your...
Read more »

Stopping Website Visitor Blog Spam

By greg | Posted in PHP Advanced, PHP WordPress

Stopping Website Visitor Comment Spam. (ex: wordpress) IF you have a blog and want visitors to easily add a comment to an item, you will also get spam - lots of it -...
Read more »

Unix-Apache .htaccess

By greg | Posted in Networking

.htaccess files (or "distributed configuration files") allow you to do many different things, ... commonly, to have your own custom 404 error pages, to redirect pages, and to enhance security. (for security, see ...
Read more »

Internet, Web Site, Security

By greg | Posted in Networking

Neither the best passwords, nor .htaccess, nor php.ini files, nor a super-helpful hosting co., will protect your web site if your pc is infected with a key-stroke-logger sending crooks your every id and password...
Read more »

SDA and RDA is now “RDS” or “RDPi”?, A.K.A. Eclipse

By greg | Posted in RPG Advanced
SDA and RDA is now “RDS” or “RDPi”?, A.K.A. Eclipse

April 2010 IBM Rational Developer for i (renamed in 2008 from WDSc), has been withdrawn from market and is replaced by the Rational Developer for Power Systems Software – RPG and COBOL Development Tools for...
Read more »

RPG-ILE : 35 Question quiz

By Ken | Posted in RPG test Q’s

RPG-ILE - RPG-IV Quiz offered in 2007 to co's and agencies for technical testing of their RPG programmer job applicants. If you have been in an interview recently and were asked a question...
Read more »

RPG-ILE-FREE subfile pgm (2)

By Ken | Posted in RPG SUBFILES
RPG-ILE-FREE subfile pgm (2)

In February of 2010 I asked my friend Ken Killian to update the RPG program RPG-ILE subfile pgm (1) to FREE FORMAT. (the DSPF and etc. are at "RPG-ILE subfile pgm (1)") Now,...
Read more »

object listing

By greg | Posted in RPG Utilities

valuable for discovering old objects that have never been used, or not in the last X years - etc. As the administrator of the system, the QSECOFR, this was a handy utility for finding and...
Read more »

Structured display of All Variables in memory

By greg | Posted in PHP Advanced

"The function, get_defined_vars(), returns a multidimensional array containing a list of all defined variables at that location in your program." To get ALL variables, list ALL variables, display ALL variables, in memory and available at...
Read more »

PHP6: Character encoding and other new features

By greg | Posted in PHP Advanced

The Internet is converging on UTF-8 for a common / universal character encoding. Set your apache environment to utf-8 by adding 'AddDefaultCharset utf-8' to your .htaccess. If you do not...
Read more »

SQL db Injection, Cross-Scripting, RFI, and LFI

It is possible for a hacker to enter the following seemingly innocuous text into the UserName textbox to gain entry to the system without having to know a valid user name and password: ' Or...
Read more »

Original Technology terms translated

By admin | Posted in asides
Original Technology terms translated

Just for the fun of it: (found this a long time ago) Hope you enjoy it also!
Read more »

Clean up WordPress

By greg | Posted in PHP WordPress

There are some problems with WordPress which can be easy to fix if someone would just tell you how. Some issues involve portability: when you change internet hosting providers, and when you have...
Read more »

RPG-ILE subfile pgm (1)

By Ken | Posted in RPG SUBFILES
RPG-ILE subfile pgm (1)

I got this code and pieced it together from IBM's book RPG USERS GUIDE, book 26 in 1991 and, in about 1994 I enhanced it to toggle more columns. Later, 1998 I...
Read more »

Comparing OOP in php, java, and C++

By greg | Posted in C++ and C#, PHP Advanced

Sample introductory Object Oriented Programming code in php, java, and C++ showing the similarities and differences. Never-the-less, OOP, despite all the bragging we hear about it, is a lot more expensive to write...
Read more »

WDSC tracks TODO/Tasks

By Ken | Posted in RPG WDSC
WDSC tracks TODO/Tasks

Using IBM's WDSC/Rdi, ("WebSphere Development Studio Client") you can use your Task View Window to mark places that you need to update code. This is a very handy Feature! You create create a...
Read more »

more details on the power of Visual Explain

By Ken | Posted in RPG Visual Explain
more details on the power of Visual Explain

I have mentioned Visual Explain before, but thought I would show more details… Recently, I had several people ask me for more details on the power of "Visual Explain" I *think* this option has been around...
Read more »

IBM Bringing MySQL to the iSeries, to DB2

By Ken | Posted in RPG Advanced
IBM Bringing MySQL to the iSeries, to DB2

What a Lifelong DB2 Fanatic Sees in MySQL Published: February 3, 2010 by Susan Gantner In my mind, you can't beat our database. It's not only integrated into the operating system, it's also incredibly flexible. You...
Read more »

Passing Variable-Length Parameters to Subprocedures

By Ken | Posted in RPG Advanced

In RPG, there is a subtle but important difference between the VARYING keyword that is used to assign a variable-length attribute to a character field and the OPTIONS(*VARSIZE) keyword that is used to permit...
Read more »

SQL: some basic JOIN syntax

By greg | Posted in MySQL

INNER JOIN and , (comma) are equivalent in the absence of a join condition and "JOIN" is defined to be equivalent to an "INNER JOIN" Examples: SELECT * FROM customer AS c, ...
Read more »