Help with PHP include, please

purdles · October 20, 2006

Hi, new here. :D

And new to PHP but I have already installed a few scripts very successfully.

I am trying to get a Quote of the Day script to work properly, using the include function. The script works fine on its own, I followed the instructions and if I type it in the browser, it displays. Itdid not come with any directions on running it inside of an HTML page, which is what I need to do, so I just typed in <?php include("quotes.php"); ?>, but nothing shows up at all. The php file is located in the same directory as the html file, from what i can see, it all looks set up right. Like I said, it works fine if I direct browse to it.

Any ideas on how to fix this? I appreciate all help!

hostfreak · October 20, 2006

Can you post the code for "quotes.php" ? That would help. Is it possible that quotes.php doesn't output anything?

purdles · October 20, 2006

This is quotes.php:

[code]
<style type="text/css">

</style>
</head>
<body bgcolor="#696d71">
<img src="images/tip.gif" >  Quote of the day - <?php echo date("F jS, Y"); ?>
<table border="0" cellpadding="6" width="40%" cellspacing="0">
<tr>
<td width="100%" class="style2"><code>
<?php

// *****************************************************************************
// -------"The World's simplest PHP Message/Quote of the Day Script"----------
//
// Author: Mads Søgaard (mads@acm.org)
// Homepage: http://www.emacs.dk/quote/
// Version: 1.0
//
//
// *****************************************************************************
// -------------------- Description --------------------------------------------
//
// "The World's simplest PHP Message/Quote of the Day Script" is a simple
// "quote-of-the-day script" that needs access to a MySQL database. It only
// consists of one script that's SIMPLE and hence easy to customize. This is how
// it works: You put any number of quotes/messages/whatever into the database,
// and then the script will show one quote every day. When all quotes have been
// shown, the script starts from the beginning of the quotes again. And if your
// quote-of-the-day page doesn't receive any visitors on a given day, the given
// quote-of-the-day will be shown the next day too. It simple, yet smart.
//
//
// *****************************************************************************
// -------------------- Installation --------------------------------------------
// 1. Upload the quote.php to your web server.
// 2. Change the following variables $DB_SERVER,$DB_USER, $DB_PASS, $DB_NAME
// (see below)
// 3. Create the needed tables in your database with the quotes.sql file.
// You can do it from the prompt (mysql -u[username] [-p] [database] < quotes.sql)
// or you can use the wonderful phpMyAdmin at http://www.phpwizard.net/projects/phpMyAdmin/
// 4. Point your browser to http://yourdomain/quotes.php
// 5. Add your own quotes to the database and custumize the script as you see fit.
//
// *****************************************************************************
// -------------------- Do you find this script useful? ------------------------
//
// Then by all means recommend it to other people! Or link back to me from your
// homepage (that would be greatly appreciated)
// You can also review my script and give it good grades at:
// http://www.hotscripts.com/PHP/Scripts_and_Programs/Quote_Display/
// (or anywhere else you may have found it)
//
// ******************************************************************************

// ****************************************
// Fill in your database information below
// ****************************************
$DB_SERVER = "mysql";
$DB_USER = "name";
$DB_PASS = "pwd";
$DB_NAME = "quotes";
// ****************************************

// ****************************************
// you do NOT have to edit below this line
// ****************************************
$con = mysql_connect($DB_SERVER, $DB_USER, $DB_PASS);
mysql_select_db($DB_NAME);

$getNoOfQuotesQuery = mysql_query("select count(*) from quotes", $con);
$no_of_quotes = mysql_result($getNoOfQuotesQuery,0);

$getMetaDataQuery = mysql_query("SELECT * FROM quotes_meta", $con);
$row = mysql_fetch_row($getMetaDataQuery);
$number_reached = $row[1];
$date_modified= $row[2];

// get the current day of the month (from 1 to 31)
$day_today = date("j");

if ($date_modified != $day_today){
// we have reached the end of the quotes
if ($number_reached >($no_of_quotes - 1)){
$number_reached = 1;
$query3 = mysql_query('UPDATE quotes_meta SET date_modified = "'.$day_today.'", number_reached = "'.$number_reached.'"', $con);
mysql_query($query3,$con);
} else {
// we haven't reached the end of the quotes
// therefore we increment $number_reached
$number_reached = $number_reached + 1;
$query3 = mysql_query('UPDATE quotes_meta SET date_modified = "'.$day_today.'", number_reached = "'.$number_reached.'"', $con);
mysql_query($query3,$con);
}
}

// we get the quote with 'id = $number_reached' from the database
$getQuoteQuery = mysql_query("SELECT quote,author FROM quotes WHERE id = ".$number_reached, $con);
$row = mysql_fetch_row($getQuoteQuery);

// we print the quote ($row[0]) and the author ($row[0])
echo $row[0]."~ " . $row[1];

// close the database connection
mysql_close($con);
?>
</code></td>
</tr>
</table>
 
</body>
</html>
[/code]

*************************
Then there's an SQL file that goes with it....

hostfreak · October 20, 2006

Have you done:
[code]
3. Create the needed tables in your database with the quotes.sql file.
You can do it from the prompt (mysql -u[username] [-p] [database] < quotes.sql)
or you can use the wonderful phpMyAdmin at http://www.phpwizard.net/projects/phpMyAdmin/
[/code]
? If so, do you get anything when you access quotes.php directly?

hostfreak · October 20, 2006

Oh, and please use the [ code ]code here[ /code ] Tags (you will need to take the space's out for the tag to work). It makes things a lot easier to read.

purdles · October 20, 2006

Sorry! I fixed that above.

Yes, if I type it in directly, the quote script runs just fine.

kenrbnsn · October 20, 2006

You're HTML file needs an extension of php instead of html for this to work.

Ken

joebpa · October 20, 2006

Here is something i found out on my server.
I have a similar issue that might be the same as yours.
I have a main.html page with a php script inside the file using the include statement. The html file doesnt display anything from the php, but if i copy the entire html file and name the file ending in php it works great.

Here is the contents of the main.html file:
<html>

<head>
<meta name="generator" content="Microsoft FrontPage 4.0">
<meta http-equiv="content-Type" content="text/html; charset=utf-8">

<style>
p
{
margin-top: 0px;
margin-bottom: 1px
}

body
{
font-family: "Times New Roman", serif;
font-size: 12pt;
font-weight: normal;
font-style: normal
}
</style>

</head>

<body>
This is the Future Home Page of our web site.
 
This site is currently under construction.
Please use the back button of your browser to exit this site.
 
Thank you for your patience and hope to see you soon.
 

<img src="Construction.gif">

 

This site is being hosted by <a href="http://www.ourwebsite.com" target="_blank">ourwebsite</a>, a Division of ourcompany,
Inc.
</body>
</html>
<?PHP include ("counter.php"); ?>

If this same file is called main.php teh script runs, but not if it ends in .html

hope this helps some.
If at first you dont succeed your a programmer.

Psycho · October 20, 2006

You say that if you access the file directly that it works, but not when you include it in another page. I'm thinking the problem might be that you are trying to include a complete HTML page (i.e. head and body tags) within another HTML page. If the page that is calling the quote of the day page already has the HTML constructs, then edit the quote of the page day just to display the quote itself. In other words, remove the HTML, HEAD, and BODY tags.

purdles · October 21, 2006

That was definitely it, it needed to be a PHP page also, the HTML was throwing it off. So you can't include PHP in an HTML page? I'm so happy because I sat here all day typing and configuring quotes (removing all those little ' and - ::) ) and if the script didn't work I was going to cry. Literally. ;D

Thanks SOOOOO much everybody! I appreciate all of your input!

Sign In

Help with PHP include, please

Recommended Posts

purdles

Link to comment

Share on other sites

hostfreak

Link to comment

Share on other sites

purdles

Link to comment

Share on other sites

hostfreak

Link to comment

Share on other sites

hostfreak

Link to comment

Share on other sites

purdles

Link to comment

Share on other sites

kenrbnsn

Link to comment

Share on other sites

joebpa

Link to comment

Share on other sites

Psycho

Link to comment

Share on other sites

purdles

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information