XML would be perfect for this. You store the XML in the database (usually a
BLOB/CLOB/Long VARCHAR/etc)
and your script pulls the XML out, and parses it there.
You can have a set of "input forms" written in PHP which'll generate the XML
for you.
Of course, this assumes some knowledge of XML, but theoretically you could
do it with
a "flat file format" (like comma/tilde delimited) and just store the string
in the database.
It's trivial to write a PHP script that generates PHP directly...
$str = "echo \"hi!\";"; // you can use single-quotes if you're more
comfortable with them
$str .= "echo \"Done!\";"; // note that it's got a ; INSIDE the
string...it's PHP in there, after all....
eval($str);
If you wanted to pre-generate it, I don't see any reason why you couldn't
addslashes()
the code, and INSERT it that way. Pull it back out, stripslashes() it, and
eval() it.
Voila!
-Szii
----- Original Message -----
From: "Mark McCray" <[EMAIL PROTECTED]>
To: "olinux" <[EMAIL PROTECTED]>; "php-db" <[EMAIL PROTECTED]>
Sent: Monday, July 02, 2001 5:54 PM
Subject: Re: [PHP-DB] RE: Storing Code in a db?
> Here was the application I was thinking of creating for my organization.
> We wanted to make an online survey tool. Where you can create a survey,
> with sections, possibly subsections, questions, and acceptable answers.
>
> It's easy enough to create this stuff each and every time, but it's
> ridiculously tedious.
>
> So why not make an application that does it automatically.
>
> So we were thinking that you kind of have to define the different types of
> questions/answers that can be used in the survey. For example, a straight
> text field, multiline text field, 5 radio button selection, 5 option
> pull-down, Yes/No radio button, checkboxes, etc...
>
> So in defining the types of questions/answers, we thought it might be cool
> to define each type of answer and the code that goes along with generating
> it. So when defining the survey questions, you tell it that the question
> has a 3 radio button answer, and the system would pull code from the
> database to help generate the question/answer html dynamically when
someone
> goes to the survey.
>
> I know you could store the functions as includes, but just thought it
would
> be cool if people could store the code in the database, because there
might
> just be an answer type that I haven't yet thought to program.
>
> Marky
>
>
>
> on 7/1/01 2:34 PM, olinux at [EMAIL PROTECTED] wrote:
>
> >
> > Couldn't you just store the php commands as a txt file and then use a
SSI
> > [server side include]?
> >
> > olinux
> >
> >> It would be very convenient to be able to store PHP (or any other
server
> >> side code) in a database, then retrieve and execute it.
> >>
> >> I store a lot of website content with embedded HTML commands in a
> > database.
> >> Being able to store PHP code in the database as well would be very
> >> convenient.
> > Lets think about something:
> > if we put some code in a field and then we out the of code from code put
in
> > temporal file and then include in our principal code :)))
> >
> > but i have a doubt eval funcion we work with functions printf, echo? i
> > don't think so.
> >
> >
> >>
> >> The only way I can think of doing it would involve a lot of very messy
> >> parsing out of the php commands. I expect that would take way to much
> >> processing time. I don't imagine that would work for entire functions
> >> either. Maybe just individual PHP commands.
> >>
> >> Any ideas????
> >>
> >> Thanks! Rita
> >>
> >
> >
> > _________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.com address at http://mail.yahoo.com
> >
> >
>
>
> --
> PHP Database 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 Database 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]
