Hi the List, Tuviah,

Because i could'nt have, for yet, the revdb up running under Linux, here
is the scripts i continue to use to access to MySQL and PostGreSQL from
within MC :


on the "mc" side :

> on SQLbyMC
>   global DBParsed
>   
>   put "test1=1&test2=2&test3=3&test4=4" into DBParsed # to replace by the SQL 
>statements to post to the .php sockets listener script
>   
>   repeat 22
>     put "z" after DBParsed
>   end repeat
>   set httpheaders to "Content-Type: application/x-www-form-urlencoded" & cr & 
>"Content-Length:" && the length of DBParsed & cr & cr # Apache :yes ; IIS : no
>   post DBParsed to url "http://localhost/wmc4.xml";
>   
>   put line 3 of it into DBParsed
>   answer DBParsed
>   
> end SQLbyMC



on the "php" side :

> <?
> 
> if ($REQUEST_METHOD == POST) {
> 
>       $headers = $HTTP_POST_VARS;
>       while (list($header, $value) = each($headers)) $exAE .= "$header=$value&";
>       
>       print $exAE." vu !"; // using the php commands, SQL statments have to be 
>insered there.
>               
> }
> 
> else print("<HTML><HEAD><TITLE>ERROR: File Not Found</TITLE></HEAD>".
>         "<BODY background='/gif/fond-maison.gif'><H1>File Not Found</H1><P>".
>         "<H3>The file you have requested does not exist on this 
>server.</H3></BODY></HTML><BR>\n");
> 
> ?>


This way run fine too and don't need to have any ODBC bridge installed.

Best Regards, Pierre Sahores

WEB & VPN applications & databases servers
Inspection académique de Seine-Saint-Denis
Qualifier & produire l'avantage compétitif


BTW : I'm far ok with the complete "MC/Rev web applications server"
stack model, i will post to the ones who asked about before Christmas !
;-)
_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to