Include; Require

KITTfan2K

What does the Include statement do (if anything!)
How would I use it (if it exists!)

Same questions for require.

Could you provide some code examples.

Basically, I want to include a HTML file that acts as a header, and I can't be bothered to type it into each PHP file.

KITTfan2K

I'm using this code to display results from my search.

I'm wondering why the following part doesn't work:

 while(list($Fields) = mysql_fetch_array($result2))
  {

   echo "   <TD>
    ".$Field1."
   </TD>";
  }

It echoes the <TD> and the </TD> but there's nothing inside them.

Please explain.

KITTfan2K

bernouli

include() , as the function's name already said, it includes file
for example you have 1.php and you have some functions inside it, now you have 2.php you want to use the function, which in 1.php, you can simple include("1.php"); than you can use the functions

while(list($Fields) = mysql_fetch_array($result2))
  {

   echo "   <TD>
    ".$Field1."
   </TD>";
  }

should that be $Fields?

danielle

as far as include/require it will do exactly what you need. if you name you html header file header.html you simply will say at the top of your php page <? include "header.html" ?> and there you go. Be sure you don't have redundant <head> tags and such. Basically an include will put whatever you include directly in the spot you include it....

as far as your second question ... do some error checking.

//counts elements in array to see if you have any.
$array=mysql_fetch_array($results2);
$arr_count=count($array);
echo "Count:".$arr_count;

or try this:
while($array = mysql_fetch_array($result2))
{

echo " <TD>
".$array[fieldName]."
</TD>";
}

jc94062

Include will try to include a file and give an error (Warning) if its not present.

Require will try to include a file and stop the page executing if its not present (Fatal error).

http://www.php.net/manual/en/function.include.php

KITTfan2K

Thanks. I just wondered if the two functions were interchangable, or if there was any special syntax that had to be used.

I've discovered that the $Fields variable in the script in the second post contains the ID number of the particular skin that it found. Now I just need to make the PHP execute a seperate query for every single line of search results.

Any ideas?

Would this work?

 while(list($Fields) = mysql_fetch_array($result2))
  {

  $query3 = "SELECT * FROM MyTable WHERE comp_id=".$Fields;
  $result3 = mysql_query ($query3,$db);
  $searchRes = mysql_fetch_object($result3);


   echo "   <TD>
    ".$searchRes->SkinName."
   </TD>";
  }

KITTfan2K

jc94062

The syntax can just be

include "nameoffile.extension";
and same for require, just change include for require..

But its generally better to do:
include ("nameoffile.extension");

Doesn't normally make a difference, but in some rare cases it can do, I believe. (ie: don't everyone flame me just because it hasn't happened to you!)

"Would this work"? I don't know, give it a shot and see if it works / gives errors etc..

KITTfan2K

Works for only one search result. My DB isn't the largest in the world. 😉

Edit: It works for two results, too. Probably works for up to 20 results.

Edit: What's wrong with this code?
It's supposed to use a different image depending upon what is in the particular field of the database. Unfortunately, it only displays the "No.png" version.

  function Winamp($win)
   {
    if ($skinFile->$win=="y")
     {
      echo "
        <IMG ALT='Component is skinned' SRC='Yes.png'>
";
     }
    else
     {
      echo "
        <IMG ALT='Component is not included' SRC='No.png'>
";
     }
   }

KITTfan2K

p.s. I know that PNG isn't widely supported, and some might call me foolish for using it, but I wanted to.

jc94062

Firstly, theres nothing wrong with using png, its the way to go with all the gif copyright issues.

Try this code:

function Winamp($win)
{
    if ($skinFile->$win=="y")
    {
        echo "<IMG ALT='Component is skinned' SRC='Yes.png'>";
        echo "<br>Yes: ".$skinFile->$win;
    }
    else
    {
    echo "<IMG ALT='Component is not included' SRC='No.png'>";
    echo "<br>Yes: ".$skinFile->$win;
    }
}

and see what you get for the value of $skinFile->$win each time...

As your using an if / else, its quite possible its not returning y or n, its returning Y or N or something instead...

KITTfan2K

Originally posted by jc94062
Firstly, theres nothing wrong with using png, its the way to go with all the gif copyright issues.
Code...
and see what you get for the value of $skinFile->$win each time...[/B]

I used some code to display the value of $skinFile->$win in between quotes. It came back with the following result every single time:

""

It doesn't seem to be able to access the part of the DB that contains the "y" or "n"

KITTfan2K

jc94062

Well the only way I can now see to fix it is that you grab all your code, and any include files (I'd advice you out passwords first though) and put it up on the web in a file.phps format (phps is a standard extention and should* allow people to view the actual code)
ie: http://www.eliteguard.co.uk/sortstringbynumber.phps

Then also put up some information about any database tables you are using and any data (dumping the tables into an sql file via phpMyAdmin would be the best way here).

Then I can take a look at it myself and see whats going wrong.

Be a few hours though as I'm tied up until at least 20:30 - but I'll try to take a look then if you put it all up, maybe someone else can fix it in the meantime.

Edit Forgot to add link, then computer and connection died

KITTfan2K

I haven't colour-coded the syntax like you did, but the file's here: http://members.lycos.co.uk/kittfan2k/File.txt

You'll probably need to view the source, because Internet Explorer (for me at least) treats it as a HTML page with some unusual code on it.

I tried to use <pre> tags to preserve the formatting, but it didn't work too well. 🙁

KITTfan2K