 | 11/28: In spring I will be teaching E-Business Strategy
and Planning on Thursday nights. |
| 11/27:
 |
Lab on 12/01 will be in
the Center for Instructional Technology, Education Building, lower level. |
|
12/03 team presentations should be 20-25 minutes with
discussion. |
|
| 11/21: Recommended one day course Presenting Data and
Information by Edward Tufte at the Grand Hyatt Union Square 12/03 or
12/04. Student price $160 includes 3 books Visual Explanations,
Envisioning Information, The Visual Display of Quantitative Information.
For details see www.edwardtufte.com
To register call 800-822-2454 students need a copy of student id and phone
number of the USF registrar. |
| 11/10:
|
If you are not calling PageBegin and you want to display
Status Messages, call ShowStatusMessage() at the place in your page
where you want the messages to appear. |
|
To check for an empty column in a where clause, use
column_name <=> '' or column_name is null
This will match a column that contains an empty string or is Null. |
|
| 11/03:
|
The s-lookup.php example has been changed to not display
values unless the user has tried to do a lookup. |
|
To create a password field, add 'type=password'
as the third argument to FormInput. |
|
For a FormSelect that shows ENUM values from a table for
lookup, the third argument should be (replacing table_name and
column_name with your table and column names):
"SHOW COLUMNS FROM table_name LIKE 'column_name' "
|
|
| 10/22:
|
Usability testing on 11/19 will be in the McLaren
Lab. |
|
For better looking messages, copy admin.css from the
examples page and store it in your public_html directory. |
|
ShowStatusMessage will not work when changing pages. |
|
| 10/15:
|
Let me know if you are getting PHP parse errors that you
can't correct. |
|
If you want to delete a Form Variable named $foo, use
this command:
unset($GLOBALS[foo]); |
|
| 10/08:
|
I've added more examples and the ability to look at the
examples database with phpMyAdmin. See http://eb-tech.handsonguide.com/ |
| For error display, create an img subdirectory within
public_html and copy these files into it: bullet.gif
and x.gif. You can also copy them from
/home/hog/lib/img on the server, be sure to copy them as Binary files. |
| The .htaccess file goes in your public_html
directory and takes effect automatically. Copy htaccess.txt
and save it as .htaccess (note the leading period and no extension),
this file should contain only three lines. If this file is not correct,
you will get a Configuration Error when you access your site. |
|
Create a file: account.inc.php by
copying account.inc.txt, editing it to
include your account name and password, and saving it as account.inc.php
(substituting your account name for account) in your public_html
directory. Put the following command (changing the file name to
reference the file you just created) at the beginning of the code area
of every .php page:
require_once("account.inc.php");
This adds your identifying information and the library code to your
program. |
|
| 10/02
|
To add an auto_increment Id column to a table that
contains data; follow these steps in phpMyAdmin, starting from the table
view:
 |
Add new field 1 At Beginning of Table. Enter
the column (or field) name, Type: INT, and click Save to create the
field. |
|
Make the new column an Index by clicking Action Index
for the new column. |
|
Make the column auto_increment by clicking Action Change
for the column, and select Extra: auto_increment. This will insert
values into the column if it is empty. |
|
|
Student price for the SVRT meeting is $10. |
|
Editing SQL in Word? Be sure to turn off Smart Quotes as
follows: go to Tools, Autocorrect, AutoFormat as you type, and clear the
check box Replace as you type "Straight Quotes" with
"smart quotes" and click OK. |
|
MySQL, avoid 'table' and other SQL reserved words as
column names. |
|
| 10/01 There was a with phpMyAdmin loading CSV files, I've
installed a new version that fixes the problem and looks slightly different.
See the revised instructions on the Ref: MySQL
page. |
| 9/29 If you are using Front Page to create Web pages:
|
Check the HTML for your hyperlinks for:
|
Links where the href= begins with file://. These are
local page links and will not work. FP may insert this type of link
if you are not working within a Web (File, New, Web or File, Open
Web), or if you refer to a file outside of your Web. |
|
References to directories that are outside of your
Web site. All your Web pages should be in your public_html directory
or subdirectories of it. |
|
Names of files or directories that contain
characters other than lower case letters, numbers, hyphen or
underscore. |
|
|
To create second level bullets like this, create a
bulleted list and then click the Increase Indent button twice. |
|
Use a photo program to convert your images to the size
you want:
|
Microsoft Photo Editor comes with Windows and is on
most machines at USF. |
|
Photo Shop is on some machines at USF. |
|
Microsoft Image Composer comes with Front Page,
check the install instructions. If you got FP separately (not as
part of Office), Image Composer is on the second CD. |
|
|
| 9/17, examples are on page http://eb-tech.handsonguide.com.
This page has been secured, use your account and password for access. |
| 9/13, the URL for your pages was missing from the e-mail,
it is account-name.handsonguide.com. for example http://baumed2.handsonguide.com.
See Student Info
for a list of accounts. Initially your public_html
directory contains an index.html page generated by Hurricane Electric, you
may replace this page. |
| 9/12, passwords have been sent via e-mail. Please let me
know if you did not get yours or if it does not work. |
|
8/28, I've added links to the Spring 01 projects to the past
project page: www.ehrlichorg.com/class-proj.htm.
See examples for previous projects. |
