[CentOS] Anyone recognize "www-mysql"?

John R Pierce pierce at hogranch.com
Wed Mar 7 16:18:40 EST 2012


On 03/07/12 1:00 PM, Adam Tauno Williams wrote:
> This a binary that executes HTML
> pages containing embedded SQL statements.


I found the debian package here: http://archive.debian.net/etch/www-mysql

ah, and peeking into the source tarball, www-mysql (and www-pgsql) build 
from www-sql, which comes from here
http://www.jamesh.id.au/software/www-sql/

this stuff looks really old, like its not been touched since 1998.    
its a pretty simple cgi package written in C, so it probably can be 
built for newer systems.

it also seems like an awful way of doing things.  from the man pages, 
here's a sample cgi sql file... the <! SQL ...> stuff is processed by 
this extension.


<html>
<head><title>Telephone Numbers</title></head>
<body>
<H1>Telephone Numbers</H1>
<!-- Let user change query -->
<form action=example.sql>
<input name=sur>  <input type=submit><br>
</form>
<! sql connect>
<! sql database telephone>
<! sql setdefault sur "-">
<! sql setdefault ofs 0>
<! sql query "select * from numbers where surname like '?sur'
  order by firstname limit $ofs,10" q1>
<! sql if $NUM_ROWS != 0>
<!-- Put in table -->
<table>
<tr>  <th>Surname</th>  <th>First Name</th>  <th>Number</th>  </tr>
<! sql print_rows q1 "<tr>  <td>@q1.0</td>  <td>@q1.1</td>
  <td>@q1.2</td>  </tr>\n">
</table>
<!-- Put in navigation links -->
<center>
<! sql if 9<  $ofs>
<! sql print "<a href=\"example.sql\?sur=#sur&ofs="><! sql
  eval $ofs - 10><! sql print "\">">Prev</a>
<! sql else>
Prev
<! sql endif>
<! sql if $NUM_ROWS = 10>
<! sql print "<a href=\"example.sql\?sur=#sur&ofs="><! sql
  eval $ofs + 10><! sql print "\">">Next</a>
<! sql else>
Next
<! sql endif>
</center>
<! sql endif>
<p>
<center><em>Page produced by WWW-SQL</em></center>
</body>
</html>



-- 
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast



More information about the CentOS mailing list