Re: RE: [PHP-DB] FastTemplates and MySQL data?

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@salamander.net> 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@conex.com.br> >> Date: Thu, 28 Dec 2000 17:56:24 -0200 >> To: <php-db@lists.php.net> >> 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@salamander.net> >> Para: <php-general@lists.php.net>; <php-db@lists.php.net> >> 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@lists.php.net >>> For additional commands, e-mail: php-db-help@lists.php.net >>> To contact the list administrators, e-mail: php-list-admin@lists.php.net >>> >> >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >> For additional commands, e-mail: php-db-help@lists.php.net >> To contact the list administrators, e-mail: php-list-admin@lists.php.net >> >> >> >> ------ End of Forwarded Message >> >> >