General discussion

Locked

Web Based Database

By matthew.done ·
Hi,
I am looking to create a web based database. I am out on the road alot and need to access my information via the web. I just want to enter in the product number and the page will return the values assigned to that number.Does anyone have anypointers or code that I could use for this problem. Any help would be appreciated.

This conversation is currently closed to new comments.

11 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Web Based Database

by McKayTech In reply to Web Based Database

You didn't mention your preferred platform, but if you are willing to entertain using a Linux or FreeBSD web server, I'm a big fan of using the MySQL database with PHP code to access it. The combination of Apache, MySQL and PHP works pretty well together and the price is right. Plus, they are all open-source and there are some really active newsgroups and mailing lists to provide support.

You might also want to look at one of the many Linux-based e-commerce packages because you might find something that is already set up as an on-line catalog that would do precisely what you need without much coding.

regards!

paul

Collapse -

Web Based Database

by matthew.done In reply to Web Based Database

The question was auto-closed by TechRepublic

Collapse -

Web Based Database

by mightyduk In reply to Web Based Database

Well if the query is really that simple, and the amount of data is not huge, i'd use a flat file system, there would be two pages.
First an HTML page with a form for you to enter product id, minimally:
<form action="query.pl">
<input name="id">
<input type="submit">

second page, a perl/cgi script, searches a text file for the correct record:
$query->new CGI;
$id=$query->param("id");
open(iFILE,'< database.txt');
while(<iFILE>){
@record=split(/\|/,$_);
if($record[0] eq $id){
last;}}

Just out put the @record array in the correct layout.

The flat file would look like this:
id|field1|field2| ...

If you want more details on the code, just send an email.

Collapse -

Web Based Database

by matthew.done In reply to Web Based Database

The question was auto-closed by TechRepublic

Collapse -

Web Based Database

by mukul_gandhi In reply to Web Based Database

There are many technologies which u can use to access database via web. You want to program HTML forms interacting with databases. I am aware of these technologies, which u can consider to use -
1. ASP (Active Server Pages) : You can use any ODBC compliant database on NT Server with ASP. I am doubtful if any unix flavour of ASP exists.
2. Java Servlets : You can use Servlets to interact with databases. You can access databases with ODBC drivers as well propritary drivers provided by DB vendors and 3rd parties also like Weblogic. There are actually 4 kinds of DB drivers u can use with JDBC(Java Database Connectivity) through servlets. You can read details if u want servlets to power ur web site.
3. PHP : You can use PHP with databases like MySQL, or any ODBC compliant database like Oracle, SQL Server, Access, DB2 etc.
4. Perl/CGI : You can use databases with Perl scripts.
5. Coldfusion : You can use databases with Coldfusion scripts.
6. JSP (Java Server Pages) : You can use JSP which is very similar

Collapse -

Web Based Database

by matthew.done In reply to Web Based Database

The question was auto-closed by TechRepublic

Collapse -

Web Based Database

by mukul_gandhi In reply to Web Based Database

(contd .. )
6. JSP (Java Server Pages) : You can use JSP which is very similar to ASP in programming to interact with databases via web.

There may be few more options for web based database access. Along with the above technologies u would need a m/c connected to Internet running web server, so that anybody on Internet can access ur site.

Hope my answer helps u.

regards
-mukul

Collapse -

Web Based Database

by matthew.done In reply to Web Based Database

The question was auto-closed by TechRepublic

Collapse -

Web Based Database

by halleyc In reply to Web Based Database

You can use Free ASP application. Visit http://www.aspcode.net/products/prodmentor/

It is a simple web-based / database-driven product catalog.

Collapse -

Web Based Database

by matthew.done In reply to Web Based Database

The question was auto-closed by TechRepublic

Back to Web Development Forum
11 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums