Hi,
I need some Apache Module that connects to MySql and also to be able to search/replace some HTML-like tags in the HTML pages.
What i need is to add some HTML_like tags to my HTML pages and the module will take info from that tags to make MySql queries and replace the HTML_like tags with the results.
Per example, if i put this HTML_like tag on my page:
<MySqlSearch database=my_database" table="my_table" Column='*' field='ARTIST' Limit='20' query="madonna" Pattern='<a href="%VID%"> %ARTIST% - %SONG%</a><br>' />
And then, it will return all result that matches with the query on the patter defined inisde 'pattern' Tag. In pseudo code the query wil be something like this:
"SELECT " + $Column + " FROM " + $Table + " WHERE " + $field + " LIKE '%" + $Query + "%' LIMIT 1," + $limit
The result is that the Apache module will return the HTML page with the results of MySql query in the place where it find (And replace) the <MySqlSearch TAG.
Also i need that some other possible HTML_like TAGS will be replaced with some javascripts i will provide.
This must be compiled in versions tu run with windows and linux/unix Apache, with not much CPU/memory usage, etc.
## Deliverables
windows, unix/linux
## Platform
windows, unix/linux