Collection of Articles and eBooks

A huge collection of articles and eBooks on various subjects

by: Mark Alexander Bain

The web site designer often needs to obtain information from the web site user. For example they may need to know:

  • The user name and password of the user (when logging in)
  • Details about the user when registering (such as the proposed user name and password)
  • Details about products when ordering on line (such as a discount voucher number)

The information gathering process consists of two stages:

  • The web page presents an HTML form to the user. The form will contain input boxes, radio button and drop down lists to illicit the required information from the user
  • PHP code then processes the information entered by the user. For example the code may check whether a required username already exists and creates it if it doesn’t.

Read More…

by: Mark Alexander Bain

It’s very easy to send SQL queries to a MYSQL database and process the results (see How to Run MySQL Queries with PHP). However, running a number of queries one after another can be time consuming and memory intensive.

Fortunately PHP enables the programmer to run a number of queries at the same time and then process the returned results one record set at a time. The PHP programmer does this by using PHP’s mysqli object and its multi_query method.
Read More…

by: Mark Alexander Bain

The distribution of a PHP application is always very easy. It is just a matter of compressing the application files, transferring the compressed file to a user’s web server, and then decompressing the files again. In just a few minutes the application can be up and running in a few minutes. However, it’s not quite as easy with the MySQL supporting the application. The MySQL database needs more than a few files to be transferred. Fortunately the programmer can create the database automatically by using some additional PHP code.
Read More…

by: John L

Most interactive websites nowadays would require a user to log in into the website’s system in order to provide a customized experience for the user. Once the user has logged in, the website will be able to provide a presentation that is tailored to the user’s preferences.
Read More…

by: Halstatt Pires

You’ve decided to automate your web site. Now what? Here are some ideas to help you choose how to automate your site.

A bit of programming is going to be necessary if you want to automate a site. There are many types of programs that can be used to automate a web site including JavaScript, PHP, Perl, ASP, Java and more. So, which do you use? For many, it is a personal choice.
Read More…