PHP in HTML pages

simonjeffs

Hi,

I have a php script in a .php file which returns the result set correctly, however the same php script placed in a htm file created in Frontpage the result set is blank. There are no errors reported, just blank rows.

Any ideas would be greatfully received.

<TABLE BORDER=0 BGCOLOR='#55BFFF' CELLSPACING=2 CELLPADDING=0 WIDTH='50%'>
<TR>
<TD><P><B>Name</B></P></TD>
<TD><P><B>Address</B></P></TD>
</TR>

</table>

<?php

$db = mysql_connect("localhost","user","password") or die("Unable to connect");
mysql_select_db("mydb_uk_db",$db);
$requete = "SELECT * from test";
$result = mysql_query ($requete,$db)or die("No record");

While ($row = mysql_fetch_assoc($result))

{
echo "<TR>";
echo "<TD><SPAN STYLE= 'font-size: 11px;'>";
echo $row["name"];
echo "</TD>";
echo "<TD><SPAN STYLE= 'font-size: 11px;'>";
echo $row["address"];
echo "</TD>";
echo "</TR>";

}
echo "</table>";
mysql_free_result($result);
?>

</body>
</html>

intenz

Apache doesn't support .htm and .html then.

You can fix by changing a line that looks something like this in httpd.conf ...

AddType application/x-httpd-php .php

To...

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

simonjeffs

This is on a hosted site, don't think I have access to that file

BuzzLY

Then you are simply going to have to rename your page from page.html to page.php.

slaya

there's a reason why php files end with php!

onyx

Also you have an </table> tag in the middle of your table so my guess would be that it wouldn't display correctly even when you have it accepting your php.

simonjeffs

I removed that and it still doesn't work

onyx

It can not interpret the php unless you put it in a file name <nice file name>.php. Putting .htm as the extention is not good enough. Try copying all of your file and saving it as a .php extention. Also ensure that the server you are running the code on actually has php installed.

simonjeffs

but won't that mean I can no longer use the frontpage navigation aspects?

onyx

I have no idea if they will work or not as I have never used frontpage extentions, perhaps just try it and see what happens. However I can not think of a work around where you can keep the .htm extention and also use php.

Black_Hobbit

I'm having a similar problem, but, I read somewhere that you can put it in an html tag like this:

<script language="php">

<--flashy code-->
//cool stuff
/*wow where'd that come from?*/

</script>

But, I tried that and it didn't work.

slaya

Unless PHP is told to check .htm pages I doubt it would no matter what you put in there, but I think(not sure) that you can tell it to in the php.ini file.

Black_Hobbit

So how do people who are hosted ( I'm on www.lowesthosting.com ) use both Frontpage Server Extentions and Php?

Norman_Graham

Hi Hobbit

If you know people who are doing this at your hoster, send them an e-mail and ask them what they do. I know nothing about Frontpage extensions, although, knowing our friends from Redmond, it probably means proprietary HTML/JS code which only works in IE5 and above.

If that's the case, the extensions won't affect the PHP at all. To the best of my knowledge, you cannot insert PHP into <script> tags. PHP is server side - script tags denote a client-side script.

However, what it all boils down to is ... if you want PHP, you need a .php file suffix. You can put any kind of HTML/JS you want in that file, however. When it reaches the client, the browser will do its job.

HTH

Norm

Black_Hobbit

I asked my Tech support and they were able to use .htaccess files and make it so that php would parse .html pages allowing me to use frontpage server extentions. (so there! Ha!😉 )