Geolocation is one of the most exciting features offered by HTML5. Using some relatively simple JavaScript code, you can create Web applications that determine various aspects of the user location, including longitude, latitude and altitude plus more. Some Web applications can even provide navigation functionality by monitoring the user position over time, integrating with map systems such as Google Maps API. As with all HTML5 functions, you cannot yet rely on browser support. Where browser...
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...
In XML, you can use XSDs to define markup structures in varying levels of detail. Compositors are among the many XSD structures you can choose from when specifying your XML content models. The XML Schema standard supports three different compositor types, each of which indicates restrictions on the range and ordering of elements. In general terms, a compositor dictates (or describes) the composition of child elements within a parent element in an XML data source. Compositors often appear within...
Most IT professionals do not work in state of the art design shops with all the latest developer suites available to them. Many of us have to make older applications and components work with newer technologies. I found myself in this predicament last year when I was required to make a new ASP.NET (3.5) web application work with a ten year old VB6.0 COM Plus Component. When I suggested to management that I re-write the component, they said: There’s no time. I know you can make it work. By the way, we need...
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,...
MySQL stored procedure's come in really handy at times. I like to let the database do the work for me sometimes. For example, in an e-commerce system you may need to calculate a tax. For our example today though, we will use the tables we made in my previous article on the XREF table. We are going to focus this tutorial on getting the appropriate tables in place to preform our history logging. To start, we are going to create a module's table so that our history table can be one table instead of many and we are...
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[],...
The XREF, or cross reference table, is a database table that links records together. These tables are very good for normalization in your database. I almost always use an xref when I need an many to many relationship. Usually XREF tables have only two columns with no Primary Key. That's right, the two columns together make them unique. They are both Foreign Keys to other tables. A real life example of this would be in any standard CRM. Let's go over this example right now. Many CRM's could have a table to store...