Articles by Gerald Hanks

Gerald Hanks has been involved in web development applications since 1996. He has designed applications with JavaScript, ASP.NET and PHP, as well as building databases in MS SQL Server and MySQL. He lives in Houston, Texas.
PHP

PHP Ad Tracker: Reports and Records

In the previous lesson, we examined the basic functions of our banner ad tracking system, including the retrieval of records for both banner ads and advertisers. In this lesson, we will look at the functions responsible for generating reports and manipulating the data in the ads table and advertiser table. The getClientsList() function retrieves active client records and sorts them alphabetically by client name: function getClientsList() { // get clients from db $sql = "SELECT ad_client_id,...

PHP Ad Tracker Part IV: Displaying and Linking Ads

In our last session, we looked at the process of entering information on ad banners and ad clients, as well as generating ad activity reports. This week, we examine how to retrieve a random banner ad. We will also learn how to delete, activate and deactivate ads and clients. The getRandomAd() function retrieves a random ad by using the PHP rand() function. The function returns the ad’s primary key ID, client ID, title, URL and redirect path. The function also updates the activity table for this banner...
PHP

PHP Ad Tracker: Data Object Design and Coding

In our last PHP Ad Tracker lesson, we constructed the database tables for our ad banner application. Now we are ready to construct the data object that will hold the variables and functions that will display, add, edit and delete the data in those tables. Once we name all of the variables and functions, we will start applying the code to them. Variables: The data object class will hold two variables: one to hold the banner ad ID number from the ads table, and one to hold the database connection information....
PHP

PHP Arrays: Array Functions and Multidimensional Arrays

In Part I, we looked at simple arrays, as well as how to loop through and sort array elements.  In this article, we will look at other array functions as well as multidimensional arrays. The difference between one-dimensional and multidimensional arrays is a simple one: a multidimensional array is a simple array that has simple arrays as elements, rather than strings or scalar variables. Building a Multidimensional Array ... Here is how our $arrBooks example from last week’s article can be expanded...

Building a PHP Ad Tracker: Creating the Database Tables

For the vast majority of modern websites, advertising is a major source of revenue. Banner ads for services related to the web site owner’s industry allow customers to view products that tie into the site owner’s core business. In exchange, the web site owner can charge the banner ad owner for every impression (banner ad appearance) or click-through (when a user clicks the banner ad). In order to build a banner ad management system, we must first create the database tables that will hold the ad information,...
PHP

PHP Arrays: Defining, Looping and Sorting Simple Arrays

Unlike scalar variables, which assign only a single value to a variable, an array variable can hold multiple values. Arrays are useful for holding values from database queries or web form entries, where each field (also called a “key”) holds a specific value. Let's take a look at how we define some of the arrays we use in PHP.Numbered Arrays. If the programmer does not specify a key for each value in the array, PHP automatically numbers the keys, starting from zero. This code defines an array $arrMonths[],...
C#

Common C# Build-Time Errors Part II: Inheritance and Interfaces

In our last lesson, we saw many of the most basic build-time errors in C#. In this session, we will look at some of the errors related to: classes subclasses inheritance Once we address some of the more common errors we will take a look at how you can fix them. #1 Hidden Method Name Creates Overload ... This conflict arises when a base class and its subclass have a function of the same name public class MyBaseClass { public void Function() { // function code goes here } { public class MySubClass : MyBaseClass...
C#

Common C# Build-Time Errors: Part I

Here’s the situation: You’ve written a program in C#. You’ve checked the flowcharts, examined your coding and developed your user interface. You’re anticipating that everything will flow as smooth as silk. You’re ready to create a build of the program and, instead of seeing a beautiful, efficient result, you get several (often incomprehensible) error message. How did this happen? Here are SOME ways that these errors occur: #1 Undeclared Variables ... C# throws an error message on undeclared...
Load more
Home CSS Deals HTML HTML5 Java JavaScript jQuery Miscellaneous Mobile MySQL News PHP Resources Security Snippet Tools Tutorial Web Development Web Services WordPress