We are working in a project about DBA
(Data base administrator) and CRM (Customer relationship management) for a web site. I have a question. What are the administrator functions?
'Administrator functions' is the name of a web-page on our website.
The page contains functions that clean-up, compact, edit, and backup our web-based database tables. We also have other functions helpful to maintaining a web site such as functions to create indices, links to web-based documentation, a way to send E-mail, a way to view files uploaded to our site, and a way to do mass E-mails.
Most of the functions on the administrator page are password protected so that web surfers can not execute the functions.
E-mail -- E-mail grabbing webbots
Do you know if E-mail grabbing webbot scan the raw file
PHP just returns an HTML file. The processing is all done by the
server. The webbots can scan the entire resulting file, but not the original PHP file.
are not stored as firstname.lastname@example.org. That is, many webbots scan
the entire file for strings of the email@example.com format. If you
use some other character instead of the at-sign, you can then
That'll probably work.
E-mail -- Hiding addresses from spammer bots
I'm trying to assist the web master of a site for a computer
club of which I'm a member. We have a
great many e-mail addresses listed (forwarding types). As you
might expect the spammer bots have picked up some. On your web
site I noticed that you have a scheme in place to thwart the
bots. Could you point me to a resource where we could get some
how-to info. Thanks.
The trick is to hide E-mail addresses behind a form submit.
That is, the user must press the submit button on a form
in order to view an E-mail address.
This trick works because web spiders follow links but do
not submit forms.
How do I get a User ID?
I am a long-time dancer now interested in calling. I love your site
and resources and would like to know what I need to do to get a user id.
It does not seem obvious on the site.
If you wish to enter data into one of our databases
(e.g., list yourself as a caller or cuer, add your club),
just fill out the appropriate form, enter your choice of a
4-character PIN, and then press the 'Add New Record' button.
The 4-character PIN can be used to make future edits to that database record.
To obtain a User Key for one of my computer programs,
you must purchase the program.
I see you make use of extensive PHP files.
I would be curious what type of database system you're using
and how much of your PHP files are custom vs. generic from
Any insights into your design would be intriguing.
Most of our web site is under PHP4.
We use MySQL under PHP4 as the database system.
One reason I started our web site was to learn
a better way to do web-based databases. I had a project at work
using a Mustang WinServer, Bluestone Sapphire Web, and an
Oracle 7.3 database. I wasn't happy with how it all worked
(primarily with the WinServer), so I started playing around with MySQL/PHP.
I'd say over 95% of our site is PHP instead of HTML.
About 90% of the PHP scripts are custom written by me.
I use three 'freeware' PHP applications:
- Table Viewer
The first two applications are for database administrator functions,
although I had to write a few such functions myself
(primarily backup and restore functions).
WebExplorer is a nice alternative to FTP.
A few times a year, I look at some of the PHP resources
listed on our tools page ( http://www.ceder.net/tools.php )
for PHP scriplets that might be useful.
PHP is excellent for including files, accessing databases,
doing redirection, creating files, and all other sorts
of server-side CGI tasks.
Hi. I'm a caller, and my web site is nearing completion.
I would very much like to include a link from your site to mine. Would that be OK with you? I'd also like you to link to my site. You've got a great site with important (and cool) information to share.
The best thing to do is to add yourself to our
Caller and Cuer Database by filling out the form
This will automatically create a page on our site for you
similar to http://www.ceder.net/callerdb/viewsingle.php?RecordId=393
This will also automatically place your web site
on our list of 'Callers with Web Sites' at
As for our Links page, http://www.ceder.net/links.php,
I only list sites that I deem contain significant and important information.
I'm also curious as to your background. I'm going to guess you
have a programming background (or that you're an active S/W developer).
I'm a software systems engineer, with a mathematics degree.