|MySql C API Example - Called from PHP Script
mysql_c_api.cgi // NOT A CGI SCRIPT. I nameed it this so it would run on the web server
$cmd = "cgi-bin/mysql_c_api.cgi ussss q.sql";
$cmd = "cgi-bin/mysql_c_api.cgi ussss q.sql HTML";
$cmd = "cgi-bin/mysql_c_api.cgi ussss q.sql XML";
$rv = `$cmd`;
called using `backticks`
PHP supports one execution operator: backticks (``). Note that these are not single-quotes! PHP will attempt to execute the
contents of the backticks as a shell command; the output will be returned (i.e., it won't simply be dumped to output; it can
be assigned to a variable). Use of the backtick operator is identical to shell_exec().
called using passthru()
The passthru() function is similar to the exec() function in that it executes a command. This function should be used in place of exec()
or system() when the output from the Unix command is binary data which needs to be passed directly back to the browser.
A common use for this is to execute something like the pbmplus utilities that can output an image stream directly.
By setting the Content-type to image/gif and then calling a pbmplus program to output a gif, you can create PHP scripts that output images directly.