Click to See Complete Forum and Search --> : creating a database without php,cgi and asp


Maurice_k
11-13-2003, 02:25 AM
I want to create a database for look-up purpose only, buy my provider won't let me use CGI,PHP and ASP. So I have to do it with HTML and/or javascript.

Q1: is this possible?
Q2: if so, how and what kind of database should i use?
Q3: can anybody help me?

Maybe useful additional info:
A record will consist of about 20 fields and 3 pictures
The database will have about 400 records
Query on a single field and/or multiple fields
My provider won't let anyone write to the website diskspace without my password, so i have to use variables

chestertb
11-13-2003, 06:56 AM
Apart from changing providers... maybe this might help...

You could set up the database as a series of multi-dimensional array fields in javascript. Something like this

record = new Array()
record[1] = new Array("field1","field2","field3"... )

To reference field 2 in record one, you would use
field2 = record[1][2];

trouble with that is that you've got 400 records, 399 of which you don't need, and you've got no indexing. My solution to that, assuming you're only indexing on one field, would be to split the file up into one little file for each letter of the alphabet.

Extract the first character of the reference, open that file as an external javascript file, then scan through the array elements until you find the one you want.

As for the pictures, just save each with a unique name, and reference that name inside the array record.

It's not an elegant solution, but it will work.

Chester

pyro
11-13-2003, 08:09 AM
Originally posted by chestertb
It's not an elegant solution, but it will work....if they have JavaScript enabled. 13% do not.

MeltedMonitor
11-26-2003, 11:15 PM
This should help you... I had to hack this together because it is a one-page site that is parked for free on the registrar's server to avoid hosting charges. Same restrictions: no perl, php or any type of databasing.

http://www.intraxdirect.com/

It might not be elegant, but it does work.

Darren

TheBearMay
12-01-2003, 10:19 AM
Might also want to look at using XML files.