Windows Tips
1. In Windows 98 CD-ROM go to \tools\oldwin95\message\us folder
2. Run awfax.exe. you might have to add Windows Messaging in the same folder
first.
3. After reboot, open the Mail icon in the Control Panel.
4. Click add. Uncheck Microsoft Mail.
5. Follow the wizard. (From PC World, Jan. 2000)
If you're on Windows NT and you want to run Apache as a service, realize that Apache for Windows will not start straight out of the box.
edit httpd.conf and add a server name, like so:
ServerName http://192.168.1.2 -OR-
ServerName http://localhost or whatever
Select "Install Apache as Service (NT only)" from your Start
menu.
ASP Find out if ASP is installed
Open the registry to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\W3SVC. If there is no ASP folder the extentions are not installed
Backup system.dat, system.ini, user.dat, and win.ini. Use crtl-c, crtl-v. Do not drag.
C
[FMP-field: fieldname] returns field name
[FMP-CurrentDate: short/long] returns current date in short or long form
[FMP-CurrentDay] returns current date
[FMP-CLIENTADDRESS] returns client IP number
M
Just install the MySQL --shareware download as you would install anything. It won't show up automatically in the services, though; you have to do that by hand. Read on:
Killing the MySQL server: bin\mysqladmin -u root shutdown
Testing MySQL: bin\mysqlshow bin\mysqlshow -u root mysql bin\mysqladmin version
status proc bin\mysql test
On NT mysqld can be installed as a service with:
bin\mysqld-shareware --install __This will Install MySQL as a service
bin\mysqld-shareware --remove __ This will remove MySQL as a service
Start/stop MySQL as a service with: NET START mysql --OR-- NET STOP mysql
Of course, you can also do this in "services" in the Control Panel.
PHP on Windows 95/98/NT and PWS / IIS 3
General Installation Steps
The following steps should be performed on all installations before the server
specific instructions.
Extract the distribution file to a directory of your choice. "C:\PHP3\" is a
good start.
Copy the file, 'php3.ini-dist' to your '%WINDOWS%' directory and rename it to
'php3.ini'. Your '%WINDOWS%' directory is typically: c:\windows for Windows
95/98 c:\winnt or c:\winnt40 for NT servers
Edit your 'php3.ini' file: You will need to change the 'extension_dir' setting
to point to your php-install-dir, or where you have placed your 'php3_*.dll'
files. ex: c:\php3 If you are using Omni Httpd, do not follow the next step.
Set the 'doc_root' to point to your webservers document_root. ex: c:\apache\htdocs
or c:\webroot
The recommended method for configuring these servers is to use the INF file included with the distribution (php_iis_reg.inf). You may want to edit this file and make sure the extensions and php install directories match your configuration. Or you can do it manually as shown below: (Didn't work for me-GE)
Go to: HKEY_LOCAL_MACHINE/System/CurrentControlSet/Services/W3Svc/Parameters/ScriptMap
1.) Go to the edit menu and select: New->String Value
2.) Type in the EXTENSION you wish to use for your php scripts '.php3'
3.) Double click on the new string value and enter the path to php.exe in the
value data field. example:'c:\php3\php.exe %s %s'. The '%s %s' is VERY important,
you musnt leave this out. PHP will not work without it.
4.) Repeat these steps for each extension you wish to associate with PHP. .php3
and .phtml are the most common.
To associate 'php.exe' with .php3 .phtml files, complete the following:
1.) Open the HKEY_CLASSES_ROOT tree
2.) Go to the edit menu and select: New->Key
3.) Name the key the extension you wish to use to associate php files with:
'.php3'
4.) Highlight the new key and in the right pane, double-click the default value
and enter 'phpfile'
5.) Repeat these steps for each extension you wish to associate with php.
6.) Go to the edit menu and select: New->Key
7.) Name the key 'phpfile'
8.) Highlight the key 'phpfile' and in the right pane, double-click the default
value and enter 'PHP Script' 9.) Now create a new key under 'phpfile' and name
it 'Shell'
10.) Now create a new key under 'Shell' and name it 'open'
11.) Now create a new key under 'open' and name it 'command'
12.) Double click the default value for the key 'command' and enter: 'c:\path-to-php-dir\php.exe
-q %1' 13.) Exit Regedit You must make any directory that will contain php scripts
'Script' permissions Consult the documentation that came with your server on
how to do this.
Windows NT and IIS 4 Installation
--- To install PHP3 on an NT Server running IIS 4, follow these instructions:
1.) In Internet Service Manager(MMC), select the Web site or the starting point
directory of an application.
2.) Open the directory's property sheet (by right clicking and selecting properties),
and then click the Home Directory, Virtual Directory, or Directory tab.
3.) Click the Configuration button, and then click the App Mappings tab.
4.) Click Add, and in the Executable box, type: 'c:\path-to-php-dir\php.exe
%s %s'. You MUST have the %s %s on the end, PHP will not function properly if
you forget to do this.
5.) In the Extension box, type the file name extension you want associated with
php scripts. (You must repeat step 5 and 6 for each extension you want associated
with php scripts. .php3 and .phtml are common.
6.) Set up the appropriate security. Make sure the directories that have php
script files have 'Script' permission. (This is done in Internet Service Manager),
and if your NT Server uses NTFS file system, add execute rights for I_USR_
Windows NT and Apache Installation (thanks to Julie Meloni)
This is from a WinNT installation on C: that worked.
R
Remove Windows elements (games, etc) hidden from the Add / Remove applet
Cut and paste this text in and make your changes to make the Microsoft
rollover from blue to red on mouseover. Works with IE only.
<A HREF="http://www.microsoft.com/"> <FONT
COLOR="#0000ff" onMouseOver="this.style.color = '#cc0000'" onMouseOut="this.style.color
= '#0000ff'">Microsoft</FONT></A>
To share a FileMaker data base on the network:
1. Create the data base normally, but don't set up restrictions, because network
users will only get a generic "no good" message. Set up your restrictions
with Java Script scripts.
2. Go to Edit>Preferences>Applications and select the plug-ins tab.
3. Click the Web Companion plug-in box.
4. Configure the TCP/IP port to use. If 80 is being used by something else,
use 591, which has been designated for FileMaker.
5. Go to File>Sharing... and select Multi-User and the Web Companion plug-in
again.
6. Hit the editable view of the data base by pointing your browser to http://computername(:591
if you used that port). Edit>Preferences>Web-Companion>Configure has
a Home Page: box in the Web Companion User Interface box. This should be set
to "built-in" to see the list of shared data bases.
To set up a special web interface for a FM data base using Claris Home Page :
1. Have the data base open.
2. File>New...>Use Assistant. Be sure FileMaker Connection Assistant is
selected.
3. Follow the wizard. For IP click the "This Computer" button and
then "Connect to Server." The open data bases will come up in the
right hand window. Be sure to add the :591 if using a port other than 80.
Click the data base you want to use and then click Next.
To add new fields to an on-line data base:
1. In FM, File>Define Fields Add the new fields as a new layout.
2. In HTML editor, add the text fields, etc.
3. Name the new fields the same as the new fields on the new layout
4. Change the layout name on the new page and save.
1. ' (apostrophe) is used for comments.
2. All code goes between <% %> tags. Spaces within the tags are
not important.
3. Declare variables using Dim. You can declare them all at once at the
beginning, separating them with commas: <% Dim func1, func2 %>
4. Declare constants using Const. Ex.
<% Const Temperature = "98.6"%>
5. VBScript is not case sensitive.
6. If a line gets too long, put an underscore ( _ ) at the end and continue
on the next line.
7. Put <% Option Explicit %>
at the top of a page, even before the <HTML> tag. This will cause an error
if you do not declare variables. It will help with misspellings.
8. Put strings between double quotes.( " " )
9. Concatenate quotes with an ampersand. ( & )
10. Statements stand on their own and simply do something. Functions return
values.
11. An argument is a value that you can send to a function when you call it.
Arguments are placed directly after the function name in parentheses. If there
are two arguments, they are separated by a comma.
12. Always put Randomize on a page before the Rnd function is called.
13. Calculations in parentheses are done first.
Some functions and what they return. The code needs to be between
<% %>
tags.
| Code | Returns |
| =Date | 01/10/2000 |
| =Weekday(Date) | 1, 2, etc |
| =WeekdayName(Weekday(Date)) | Monday, Tuesday, etc. |
| =Time | 5:23:47 PM |
| =Now | 1/10/2000 6:42:37 PM |
| =Year(Date) | 2000 |
| (Rnd * 6) + 1 | Numbers between 1 and 6 (includes decimal) |
| Int(Rnd * 6) + 1 | Integers between 1 and 6 (decimal cut off) |
| Round(Rnd * 6) + 1 | Integers between 1 and 6 (rounded to integers) |
1. Have TCP/IP installed on server
2. Set up the server first
3. Have the server running when you install Wingate on the clients
4. Have TCP/IP working on the client before installing Wingate
5. You install WinNT version even on 98 clients. It will detect the running
server on install and select the client software
6. Select the netcard in the control panel and enable DNS. Put in the name of
the box on the upper left and the domain name of the provider in the upper right,
plus the provider's IPs in the middle box. I set the Wingate server as the gateway,
but I'm not sure that was necessary.
7. Anyway, it worked.