Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Running SQL query

0 views
Skip to first unread message

rjre

unread,
Nov 23, 2009, 12:15:13 PM11/23/09
to
Afternoon all...

A little off-topic but i cannot find a better home for this...

I am running an Apache server on the same box as a MySql server - i'd
like to run an sql query and have this shown on a webpage...where the
hell do i start?!

thx vm

richard

"Álvaro G. Vicario"

unread,
Nov 23, 2009, 12:56:55 PM11/23/09
to
rjre escribi�:

> A little off-topic but i cannot find a better home for this...
>
> I am running an Apache server on the same box as a MySql server - i'd
> like to run an sql query and have this shown on a webpage...where the
> hell do i start?!

PHP is a popular choice.

--
-- http://alvaro.es - �lvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programaci�n web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

Swifty

unread,
Nov 23, 2009, 1:00:30 PM11/23/09
to
rjre wrote:
> I am running an Apache server on the same box as a MySql server - i'd
> like to run an sql query and have this shown on a webpage...where the
> hell do i start?!

What you want is a CGI script. There is a newsgroup
comp.infosystems.www.authoring.cgi but it is all but moribund, but that
is the place; I'll look out for you.

A CGI script is a program (typically written in a language such as PERL,
but almost anything will do; I use Open Object REXX). The script is
assigned to a URI on your server, such as /cgi-bin/mysqlpage.pl and when
a browser fetches that URL, apache runs the CGI script (program), and
everything that the program outputs to STDOUT goes back to the browser,
the way the HTML does when you go to /index.html

--
Steve Swift
http://www.swiftys.org.uk/swifty.html
http://www.ringers.org.uk

Bob Melson

unread,
Nov 23, 2009, 1:35:25 PM11/23/09
to
On Monday 23 November 2009 10:56, "�lvaro G. Vicario"
(alvaro.NO...@demogracia.com.invalid) opined:

> rjre escribi�:
>> A little off-topic but i cannot find a better home for this...
>>
>> I am running an Apache server on the same box as a MySql server - i'd
>> like to run an sql query and have this shown on a webpage...where the
>> hell do i start?!
>
> PHP is a popular choice.
>

You might try "Web Database Applications with PHP and MySQL", 2d Ed., Hugh
E. Williams and David Lane, O'Reilly, 2004. While the book deals with the
creation of a specific application, it has a lot of useful information
regarding web-based database programming.


--
Robert G. Melson | Rio Grande MicroSolutions | El Paso, Texas
-----
A government big enough to give you everything you want is big
enough to take away everything you have. Thomas Jefferson

0 new messages