CGI script to sql db - Shell Programming and Scripting

frustrated1 · #1 02-16-2006

I am not sure if you can help - but I am desparate so I will ask anyway.

I have a solaris server which I am running apache and mysql db on.
I have a basic web page (internal to my lan only)
I know some shell scripting (ksh etc) and I can create a very basic cgi script using shell scripting.

I want to be to interface with my 'mysql' db using a script and pull back the details to the web page...
I also want for a user to be able to enter a number (ie a log number) on a web form and this gets submitted using the cgi script and executes some sql to the db based on the log number..

Any ideas to help me get started here? I really have no clue what the best way to do this is using cgi scripts etc and my html is also very basic..

frustrated1 · #2 02-16-2006

Obviously I didnt look hard enough - Found exactly what I was looking for:

http://www.scit.wlv.ac.uk/~jphb/sst/sh/ex3d.html

Thanks all the same

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
help me in sending parameters from sqlplus script to unix shell script	Hara	Shell Programming and Scripting	2	01-29-2008 12:31 PM
Shell Script: want to insert values in database when update script runs	ring	Shell Programming and Scripting	1	10-25-2007 12:06 AM
here document to automate perl script that call script	hogger84	Shell Programming and Scripting	3	10-22-2007 07:15 AM
returning to the parent shell after invoking a script within a script	gurukottur	Shell Programming and Scripting	5	09-26-2006 04:05 AM
return valuse from child script to parent script	borncrazy	Shell Programming and Scripting	1	08-20-2004 12:39 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode