Re: [PHP] RE: [PHP-DB] FastTemplates and MySQL data? From: andrew (andrew <email protected>)
Date: 12/29/00

For that matter does anyone have any examples of FastTemplate in use with
MySQL data?

regards,
andrew

On 12/29/00 8:58 AM, "Andrew" <andrew <email protected>> wrote:

> Hi Jayme,
>
> I'm not sure I understand - do you happen to have an example of using a
> variable as a create parameter?
>
> regards,
> andrew
>
>> ------ Forwarded Message
>> From: "JJeffman" <jjeffmanweb <email protected>>
>> Date: Thu, 28 Dec 2000 17:56:24 -0200
>> To: <php-db <email protected>>
>> Subject: Re: [PHP-DB] FastTemplates and MySQL data?
>>
>> FastTemplate is not a MySQL neither a PHP function or object. If
>> you create
>> a php class named FastTemplate which has a php variable as create
>> parameter
>> you can use it just the way you wrote in your previous message.
>>
>> Jayme.
>>
>> http://www.conex.com.br/jjeffman
>>
>>
>>
>> -----Mensagem Original-----
>> De: Andrew <andrew <email protected>>
>> Para: <php-general <email protected>>; <php-db <email protected>>
>> Enviada em: quinta-feira, 28 de dezembro de 2000 15:04
>> Assunto: [PHP-DB] FastTemplates and MySQL data?
>>
>>
>>> This is a second post, since no one responded the first time... :)
>>>
>>> Can I somehow pass FastTemplates a MySQL result array, and also
>> pass it a
>>> template pointer, and get a resultant page? I really just want
>> to set up
>> a
>>> script where a Select parameter is passed in, a result set array is
>>> generated, and the array is evaluated against an array of template {}
>>> variables. This way I can call pages with essentially one variable.
>>>
>>> Any ideas?
>>> The original post is below.
>>>
>>> TIA!
>>> andrew
>>>
>>>> Hi,
>>>>
>>>> <NEWBIE ALERT>
>>>>
>>>> Can anyone show me an example (or better, point me to some code)
>>>> where the FastTemplate class pulls info from MySQL?
>>>>
>>>> e.g. something like this maybe?:
>>>>
>>>> <?
>>>> $sql = "select * from database where id = id"; file://to get one
>> row
>>>> $location = "path/to/template/directory"; file://one per
>> template set
>>>>
>>>> mysql_connect($hostname, $user, $password);
>>>>
>>>> $result = mysql_db_query ("database", $sql);
>>>> while ($row = mysql_fetch_assoc ($result))
>>>>
>>>> {
>>>> echo $row["field1"]; file://maybe build dynamically with a
>> for loop?
>>>> echo $row["field2"];
>>>> }
>>>>
>>>> mysql_free_result ($result);
>>>>
>>>> $tpl = new FastTemplate($location);
>>>> $tpl->define(array ($result, main => main.tpl)); // help!
>>>> ?>
>>>>
>>>> So basically every page (or page section) can be stored as
>> one row in a
>>>> database and to get your script to generate a different page you just
>> have
>>>> to pass $sql and $location, since $location defines a set of
>>>> templates that
>>>> work together to define your page and $sql defines which result
>>>> set will get
>>>> parsed against the *.tpl in $location
>>>>
>>>>
>>>> I can't believe that this hasn't been done before, but I'm too
>>>> green to know
>>>> exactly what to do here...
>>>>
>>>
>>>>
>>>
>>>
>>> --
>>> PHP Database Mailing List (http://www.php.net/)
>>> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
>>> For additional commands, e-mail: php-db-help <email protected>
>>> To contact the list administrators, e-mail: php-list-admin <email protected>
>>>
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
>> For additional commands, e-mail: php-db-help <email protected>
>> To contact the list administrators, e-mail: php-list-admin <email protected>
>>
>>
>>
>> ------ End of Forwarded Message
>>
>>
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>