Re: Anyone recognize "www-mysql"?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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

_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos


[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux