Metrics and setting up a web analytics program (09/15/2008)
(...) Your web analytics program will do its best to determine a total number of unique visitors based on IP addresses and any other info it can gather. Admittedly, the number is not perfectly accurate. But it's a good tool for tracking trends. (...)

Database example (05/12/2008)
(...) The table has the following definition: CREATE TABLE EPAL (email varchar(32) NOT NULL, type varchar(8) NOT NULL, want varchar(8) NOT NULL, interest1 number(4), interest2 number(4), interest3 number(4), interest4 number(4), interest5 number(4), CONSTRAINT id_pkey PRIMARY KEY(email), CONSTRAINT type_check CHECK (type in ('MALE', 'FEMALE', 'EPERSON')), CONSTRAINT want_check CHECK (want in ('MALE', 'FEMALE', 'EPERSON', 'ANY')) ); The ‘check’ constraints are not particularly important and can be omitted if the database that you use does not support such constraints; the program code essentially duplicates these checks. The example program is a standalone Perl program reading data from the keyboard and working directly with the database. Commands can be given to the program to add records to the database or to perform searches. (...)

Associated databases (05/12/2008)
(...) The code fragment below would attempt to return all data in Table1 of the database referenced by your $dbh handle. $sth = $dbh->prepare("SELECT * FROM Table1"); $sth->execute; You could be more selective: $sth = $dbh->prepare("SELECT * FROM Table1 WHERE GRADE > 3"); $sth->execute; Often you will want queries that depend on data entered by the user. You can employ interpolation when building a query string: print "Enter Grade cutoff : "; $grade = <STDIN>; chomp($grade); $sth = $dbh->prepare("SELECT * FROM Table1 WHERE GRADE > $grade"); . (...)

Finding what matched and other advanced features (05/01/2008)
(...) The following example illustrates the extraction of two fields from an input line. The input line is supposed to be a message that contains a dollar amount. The dollar amount is expected to consist of a dollar sign, some number of digits, an optional decimal point and an optional fraction amount. (...)

Basics of regex patterns (05/01/2008)
(...) .., ‘Quit’): #read commands entered by user while(<STDIN>) { if( /Quit/ ) { last; } elsif( /Add/ ) { # perform addition operation . (...)

Each output line consists of a list of words (04/26/2008)
(...) The body of the main while loop works by splitting the input line into a list of words and then processing this list. while($title = ) { chomp($title); @Title = split / / , $title; .. (...)

Simple list examples (04/26/2008)
(...) The simplest way is to use Perl’s split() function as illustrated in this example, but there are alternative ways involving more complex uses of regular expression matchers. Once the data are in lists, Perl can easily manipulate the records and so produce reports such as reverse telephone directories (mapping phone numbers to people), listing of employees with no specified room number, and so forth. The following little program (which employs a few Perl ‘tricks’) generates a report that identifies those employees who have no assigned room: while(<STDIN>) { @line= split /:/ ; $room = $line[3]; if(!$room) { print $line[0], "\n" ; } } The main ‘trick’ here is the use of Perl's ‘anonymous’ variable. (...)

Slightly modified specification for a CS1 program (04/24/2008)
(...) The totals option should print details of total sales and largest order. The quit option terminates the program. An invalid option selection is reported; then the program repeats the prompt for input. (...)

Lists and arrays (04/24/2008)
(...) Does (OK, ‘has done to it’, as these are not class member functions): – Create a list, usually initializing it with a non-empty set of data elements (though empty lists are fine). – Add elements ‘at front’ or ‘at end’ of the list. – Remove elements ‘at front’ or ‘at end’ of the lists. (...)

The next few elements define options (04/12/2008)
(...) conf file define options relating to files in user directories, set default values for the names of control and index files, and define the files and formats used for logging. A ScriptAlias directive is then used to define the standard cgi-bin directory, and another Directory directive group sets the access permissions for this directory. The next part of the file contains data used to generate HTML pages with fancy listings of directories (listings that incorporate little GIF images that distinguish subdirectories and different types of files). (...)

The configuration file (04/12/2008)
(...) 27, allows you to define the Apache that you want. The script can be run, from the /home/me/apache_1.3. (...)

Generation of dynamic pages (04/10/2008)
(...) These extra Directory directives must contain control options that permit execution of CGI scripts in a directory or SSI processing of files from a directory. Server-side includes are flagged by special tags in an HTML file, tags such as: <!--#flastmod .. (...)

Apache logs (04/10/2008)
(...) There is a little helper program in the /bin directory that allows you to “rotate” log files; existing log files are renamed, and Apache is told to continue writing at the beginnings of the new log files. An example fragment of an access log is as follows (line breaks have been inserted at convenient points – each entry goes on a single line): 130.130. (...)

The vBulletin Administrator Experience (05/31/2007)
(...) A reason can also be given for the deletion. Also, an administrator can edit a post (again, leaving a reason if they wish). Other options include closing a thread (so that users can no longer post to it) and making the thread sticky (so that it stays at the top). (...)

Blogging healthy athmosphere (05/30/2007)
(...) Having executives who blog and who encourage blogging is a great way to introduce blogging, though it isn’t a requirement. The key to a healthy blogging atmosphere is to have the company, leaders, and managers value blogging, bloggers, and blog feedback. This is why having a corporate blog, product-specific blogs (if you make products such as cars or software), or market-specific blogs (if you create a wide variety of products) is important: it allows your customers to provide feedback in a variety of locations and therefore allows you to use that feedback in a variety of ways. (...)

Employee who blogs (05/30/2007)
(...) But some companies go so far as to provide a single website that lists new posts, features individual bloggers, and links comments made by a blogger to that blogger’s internal blog. The more ways you provide for your employees to connect, the more connections they will make. The challenge is that implementing these features is more expensive than simply allowing employees to set up blogs. (...)