newbie question > including php script into existing html page

[superstar]

Hello, i just ran through a small php book and feel generally confident working with php.

Here is my problem,

1) I have an existing web page MyBaseballTeam.html built that has a table within it where i want to display my baseball teams stats.

2) I have a php script "stats.php" that works and displays the data from the mySQL database.

How do i insert the php into the html document?

Can i use a function within the table to go read stats.php, execute the script, return the results and display within MyBaseballTeam.html or do i have to build the entire html doc in php?

thanks for input

[Mordecai]

<?php include("stats.php"); ?>

You'll need to tell your server that .html files are PHP, too, though.

[superstar]

ok so if i just toss
<?php include("stats.php"); ?>

into the table that will go out and execute the code?

what do you mean by telling my server html is php too?

i thought the <?php ?> tells the server to process this as php

[laserlight]

No, if you glance through your say, httpd.conf file, there is a part where you have a list like:
AddType application/x-httpd-php .php .phtml

You would then add .html to that line and restart the server.

Actually, it would be easier if you simply changed that page from MyBaseballTeam.html to MyBaseballTeam.php

[superstar]

ok so i renamed MyBaseballTeam.html to MyBaseballTeam.php

and tried

<?php include("stats.php"); ?>

and i received an error

warning: main(stats.php) [function.main]:
failed to create stream: etc. etc.

so i then just cut and copied my php into the file and it worked 🙂

thanks guys!

on a side note why didnt <?php include("stats.php"); ?> work

but <?php ALL MY CODE HERE ?> worked?

[Mordecai]

Honestly, I have no idea.

[BuzzLY]

without knowing what your stats.php has in it, there's no telling why it didn't work.

[Weedpacket]

Tell me, is the "etc. etc." bit you're leaving out something like "No such file or directory in name of script on line n"?