Dumb Question

cmccomas

If I have a .php on my server, and want that in my .html what is the code for that?

kevinsequeira

no code , u cant embed .php file in a .html page directly as far as i know, unless you use frames and have one of the frame source as .php file

reg
kevin

cmccomas

I have a .php that will bring up the last 5 news items, I must paste all of the coding where I want it in my .HTML?

Also:

Create a mySQL database to store news information:

mysql> CREATE DATABASE news;

Create the database tables using the dump file:

$ mysql -u <username> -p <password> -D <database> < news.sql

How do I do that?

kevinsequeira

😕

BuzzLY

What are you asking? How to link to a PHP page?

http://www.yourserver.com/dir/yourpage.php

If you are asking how to make an .html file parse like a .php file, then you'll have to modify your httpd.conf file. Look for a line similar to this:

AddType application/x-httpd-php .php .php3 .phtml .php4

Add .html to the end of that line, and restart your Apache server.

cmccomas

I figured out the question about embed. How do I do this?

Create a mySQL database to store news information:

mysql> CREATE DATABASE news;

Create the database tables using the dump file:

$ mysql -u <username> -p <password> -D <database> < news.sql

How do I do that?

Where do I type mysql> CREATE DATABASE news;

Do I put it in a file and save it as a certain thing?

cmccomas

Buzzly,

This is the code:

<?

// list.php - display list of five most recent press releases
?>
<html>
<head>
<basefont face="Verdana">
</head>

<body>


 

<table width="100%" cellspacing="0" cellpadding="5">
<tr>
<td></td>
</tr>
<tr>
<td bgcolor="Navy">Pistons Central</td>
</tr>
</table>


<ul>
<?
// includes
include("../conf.php");
include("../functions.php");

// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to select database!");

// generate and execute query
$query = "SELECT id, slug, timestamp FROM news ORDER BY timestamp DESC LIMIT 0, 5";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

// if records present
if (mysql_num_rows($result) > 0)
{
// iterate through resultset
// print article titles
while($row = mysql_fetch_object($result))
{
?>
<li><a href="story.php?id=<? echo $row->id; ?>"><? echo $row->slug; ?></a>
 
<? echo formatDate($row->timestamp); ?>

<?
}
}
// if no records present
// display message
else
{
?>
No news items currently available
<?
}

// close database connection
mysql_close($connection);
?>
</ul>



<table width="100%" cellspacing="0" cellpadding="5">
<tr>
<td align="center">Pistons Central</td>
</tr>
</table>


</body>
</html>

It's a full page, but I want it to list the last five news items in a cell of a table on my index pag e.

BuzzLY

If you want to use include() in your html file, you will need to tell the apache server that .html files should be parsed for php. I told you how to do that.

As for your list.php file -- get rid of the <HTML>, <HEAD>, etc. tags. The only thing list.php should contain is a table with the desired information.

cmccomas

BuzzLy thanks...

So get rid of the HTML>, <HEAD>, etc. tags. Then edit my server info, then what do I use to insert list.php at the spot I want it?

cmccomas

can i not just insert:

<ul>
<?
// includes
include("../conf.php");
include("../functions.php");

// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to select database!");

// generate and execute query
$query = "SELECT id, slug, timestamp FROM news ORDER BY timestamp DESC LIMIT 0, 5";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

// if records present
if (mysql_num_rows($result) > 0)
{
// iterate through resultset
// print article titles
while($row = mysql_fetch_object($result))
{
?>
<li><a href="story.php?id=<? echo $row->id; ?>"><? echo $row->slug; ?></a>
 
<? echo formatDate($row->timestamp); ?>

<?
}
}
// if no records present
// display message
else
{
?>
No news items currently available
<?
}

// close database connection
mysql_close($connection);
?>
</ul>

Where I want the .php in the .html?

I know there has to be a way.

BuzzLY

just use the insert() command. If it's inside a table element, it might look like this:

<table cellpadding="0" cellspacing="0" border="0">
   <tr>
      <td><?php insert("list.php");?></td>
   </tr>
</table>

Obviously, put in the proper path to your list.php file, or better yet, put list.php in your includes folder.

That's it.