You are here: Re: [PHP] PHP code in a MySQL record « PHP « IT news, forums, messages
Re: [PHP] PHP code in a MySQL record

Posted by "Kristen G. Thorson" on 07/29/05 22:50

Is there a particular reason you need *PHP* in the database? If not,
then use a placeholder system of some sort ( like #var# ) and str_replace():

while( $row=mysql_fetch_row($result) ) {
echo str_replace( '#var#', $that_var, $row['entry'] );
}



kgt




Nathaniel Hall wrote:

>I am working on a project that uses an index.php page. Depending on the
>variable in the URL, a different php page is included. I have a
>config.php that contains variables that are accessible from any page.
>That is the easy part.
>
>I have some pages pulling HTML out of a database. I would like to be
>able to reference some of the variables in the config.php in the
>database blob field. Here is an example:
>
>index.phphalln_\@_otc_\._edu
>------
><html><head>...etc
><?php
> include 'config.php';
> if (blabla) {
> include "thispage.php";
> } else {
> include "thatpage.php";
> }
>?>
>
>config.php
>------
><?php
> $this_var=1;
> $that_var="Nothing";
>?>
>
>test.php
>------
><?php
> $query="SELECT * from table";
> $result=mysql_query($query) or die ("Cannot process query");
> $row=mysql_fetch_row($result);
> echo $row[1];
>?>
>
>MySQL record:
>------
>id,year,month,day,entry
>
>1,2005,01,01,This is a test<br><? echo $that_var; ?>
>
>_____________________________
>I have tried using <br>&gt;? echo $that_var; ?&lt; and I have tried
>escaping everything, but that still didn't work. Any ideas?
>
>Nathaniel Hall
>halln_\@_otc_\._edu
>
>
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация