[Resolved] Cannot get php embedded in .htm template to work when loaded by Perl/CGI script

[omarlee]

Howdy,

Have done a search here and not even sure I should post it here instead of at a Perl/CGI forum but here goes....

I have embedded the following php in a .htm template.

<?php
include ("db_access.inc");
$result = mysql_query ("SELECT COUNT(*) FROM store")
or exit ();
if ($row = mysql_fetch_array ($result))
echo "Currently contains " . $row[0] . " images";
mysql_free_result ($result);
?>

db_access.inc

<?php
@mysql_pconnect ("localhost", "db_user", "password")
or exit ();
mysql_select_db ("db_name")
or exit ();
?>

I have also uploaded .htaccess with the following

AddType application/x-httpd-php .shtml .html .htm

I have even tried adding .cgi to .htaccess without success.. you can tell how much I know...

Server is running PHP 4.3.2 /Apache 1.3.28 /linux/MySQL 3.23.56

The idea is to get the php to access database, count the # of rows and dynamically display the following text and total - Currrently contains 607 images

BTW, this .htm template is called by a cgi script which also loads other dynamic info from the same database.

Problem:

I cannot get the page to display the text and count total when loaded via index.cgi.

Error

Total " . $row[0] . " images currently online."; mysql_free_result ($result); ?>

The text and count figure gets parsed/processed and displays fine when I access the .htm template by itself via browser. Changing my template extension to .php didn't help either?

Does php have to be coded differently when it's embedded in a .htm template called by a cgi script?

TIA,
-omar

[HalfaBee]

You might have to put the full URL in to retrieve the page via CGI.
If it loads the page from disk php will not be parsed.

HalfaBee

[omarlee]

thx for responding HalfaBee, but if i do that, it says the directory or file is not found

The snippet of perl that loads the template is:-

sub ShowIndex{
&Show_Cats;
&PageOut("$cgiurl/template.php");
exit;
}

The error is now

No such file or directory: http://domain.com/some_directory/template.php

But template.php is there which I can access directly via browser.????

[HalfaBee]

I just thought I would say,

I HATE PERL. 🙂

You might have to execute the php binary to make it work.
I don't know how in perl, but I am sure you do.

/usr/local/bin/php $cgiurl/template.php

HalfaBee

[drawmack]

let me rephrase your question and see if it helps you understand the problem.

I have written a templating system which the webserver executes using the PERL engine. In the templates used by this system I have embedded PHP. Why isn't my php executing?

Ummm
because perl.exe cannot execute code writting in the php language you deeter head.

You can't mix the two like that.

[omarlee]

thx HalfaBee and drawmack for your recomendations..

i also know now that perl cannot call and parse SSI on .shtml template.

finally solved my problem by inserting a tag on the .htm template and adding corresponding codes in the original index.cgi script.

.....closing this thread