This is a good time for a quick lesson on just exactly what include/require
actually does.
The following two examples are exactly the same, in almost every way:
=== Example 1 ===
example1A.php:
<?php
$greeting = "Hello";
include("example1B.php");
echo $greeting;
?>
example1B.php:
<?php
$greeting .= " World!";
?>
The output is "Hello World!", and that's all.
=== Example 2 ===
example2.php:
<?php
$greeting = "Hello";
$greeting .= " World!";
echo $greeting;
?>
The output is "Hello World!"
When you include a file it is almost exactly the same as if you went into
the included file, cut out all the code, then went back into your first file
and pasted it in.
So what you can use an included file almost exactly as you would use a
function, without declaring anything as global! But there are obvious
reasons why functions are better than includes, but you probably know that
;)
Example:
first file:
<?php
$greeting = "Hello there";
// Let's pretend these variables are actually set by someone POSTing data.
$var1 = "Hi there";
$var2 = "Ho there";
$var3 = "Me there";
$var4 = "My there";
include("include.php");
echo $text;
?>
include.php:
<?php
if ($var1)
{
$greeting .= ", " . $var1;
}
if ($var2)
{
$greeting .= ", " . $var2;
}
if ($var3)
{
$greeting .= ", " . $var3;
}
if ($var4)
{
$greeting .= ", " . $var4;
}
?>
Now you could do the exact same thing by just making the include file into a
function. Or you could just paste it into your original file.
But the output remainds the same, no matter how you slice it.
QUESTION ANSWER:
The following:
> $sql = "..."
> $result = ....;
> include 'variables.php?table=$table';
Can be like this:
$table = "tablename";
$sql = "...";
$result = "...";
include ("variables.php");
The values of $table, $sql, and $result will all be the same in
variables.php as they are in your source file.
Isn't that nice? Aren't you glad that I took 4 pages of text just to explain
that single phrase? Shouldn't I get a pulitser for taking so little content
and putting it into so much display? I should work for microsoft, shouldn't
I?
--
Plutarck
Should be working on something...
...but forgot what it was.
""Ashley M. Kirchner"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> I have a DB project going and every time I query the DB for data
> from a particular table, I want to include a set of variables (that get
> set based on the query result). I was thinking of doing something like
> this:
>
> $sql = "..."
> $result = ....;
> include 'variables.php?table=$table';
>
> However, every time I try that, it tells me it can't find
> 'variables.php'. However, if I rename the file to 'variables.inc', it
> does find it (though it doesn't pass any arguments to it then).
>
> The first method tells me it's not in the include path. Okay,
> easily fixable in php.ini, however, I don't want this extra path info to
> apply to the whole server (which is running several vhosts). How can I
> adjust the include path just for this particular vhost?
>
> Or, is there a better way to do what I'm trying to accomplish? Make
> it a function perhaps? A call that would look kinda like this perhaps:
> variables($table) ? But then, how do I get to the actual variables?
>
> AMK4
>
> --
> W |
> | I haven't lost my mind; it's backed up on tape somewhere.
> |____________________________________________________________________
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Ashley M. Kirchner <mailto:[EMAIL PROTECTED]> . 303.442.6410 x130
> SysAdmin / Websmith . 800.441.3873 x130
> Photo Craft Laboratories, Inc. . eFax 248.671.0909
> http://www.pcraft.com . 3550 Arapahoe Ave #6
> .................. . . . . Boulder, CO 80303, USA
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
