Re: [SMARTY] Assigning mysql query to smarty template

From: Date: Fri, 13 Sep 2002 20:44:58 +0000
Subject: Re: [SMARTY] Assigning mysql query to smarty template
References: 1  Groups: php.smarty.general 
Request: Send a blank email to php-smarty-general+get-5964@lists.php.net to get a copy of this message
Thanks for all I found the correct way now: {foreach from=$dbresult item=current key=ISBN} Either item=current nor key=ISBN should have any $-prefixes. Everything works like a dream gawan ----- Original Message ----- From: "James Puddicombe" <james.puddicombe@jjpsolutions.com> To: "gawan" <mail@gawan.net>; <smarty-general@lists.php.net> Sent: Wednesday, September 11, 2002 1:17 AM Subject: RE: [SMARTY] Assigning mysql query to smarty template > I believe you have a syntax error in the line: > > {foreach from=$dbresult item=$current key=$ISBN} > > in that the reference to '$current' should not have a prefix of '$'. > > James > > -----Original Message----- > From: gawan [mailto:mail@gawan.net] > Sent: 09 September 2002 00:47 > To: smarty-general@lists.php.net > Subject: Re: [SMARTY] Assigning mysql query to smarty template > > > I tried writing host, user and password directly to the mysql_pconnenct > function. It did not help. There is no typo in where calusus, I am comparing > a larger table against a sample table, both have similar primary keys that > should match (P_ISBN in Product and isbn in Sample). But one other typo I > found: "order by P_ISBN" should be "order by ISBN". That did not help > though) > Also in fact the error appeared also when removing the template code, I just > did not notice it in a darker upper edge on my page :( > > After correcting the order by syntax, mysql_fetch_object(): ... error > disappeared, but now I got a template parsing error: > > Parse error: parse error, unexpected T_STRING, expecting ']' in ... this > line: > > <?php if (count((array)$this->_tpl_vars['dbresult'])): > foreach ((array)$this->_tpl_vars['dbresult'] as > $this->_tpl_vars['$this->_tpl_vars['ISBN']'] => > $this->_tpl_vars['$this->_tpl_vars['current']']): > ?> > > Does the use of item=$current and key=$ISBN seem OK? > > thanks > > ----- Original Message ----- > From: "Josh Johnson" <mailing_lists@allusiveimage.com> > To: "'gawan'" <mail@gawan.net>; <smarty-general@lists.php.net> > Sent: Monday, September 09, 2002 1:20 AM > Subject: RE: [SMARTY] Assigning mysql query to smarty template > > > > The first thing that comes to mind is maybe the scope of your $host, > > $user, etc vars is outside of your template... maybe in a file that > > isn't being included before smarty is called... Or maybe "where P_ISBN = > > isbn" in your query is a typo? Usually mysql_fetch_object will give that > > error when the result id ($result) is no good, usually because the query > > had a syntax error or the connection failed, which would be the case in > > any of the other possible situations I mentioned above. > > > > -- Josh > > > > -----Original Message----- > > From: gawan [mailto:mail@gawan.net] > > Sent: Sunday, September 08, 2002 5:58 PM > > To: smarty-general@lists.php.net > > Subject: Re: [SMARTY] Assigning mysql query to smarty template > > > > Returning to my question: I have the following code, but I can't seem to > > get > > it to work. > > I got error saying "mysql_fetch_object(): supplied argument is not a > > valid > > MySQL result resource". > > > > But when I comment out the {foreach} loop in the template, no errors > > occur. > > So the trouble seems to be in the template inspite of what the message > > says. > > I don't quite understand what to put in the item and key attributes in > > the > > foreach block. > > > > Any further advice appreciated. > > > > gawan > > > > ---- in my php code ---- > > > > $conn = mysql_pconnect("$host", "$user", "$passwd"); > > mysql_select_db("shop", $conn); > > > > $query = ("select > > P_ISBN as ISBN, > > DistinctiveTitle as Title, > > PublisherName as Publisher, > > AvailabilityCode as Availability, > > PriceAmount, > > DiscountPercent, > > PriceFrom, > > PriceEuro > > from Product, Sample > > where P_ISBN = isbn order by P_ISBN"); > > > > $result = mysql_query($query, $conn); > > > > $resarray = array(); > > while ($row = mysql_fetch_object($result)) > > { > > $resarray[$row->ISBN]; > > } > > > > $smarty->assign("dbresult", $resarray); > > > > $smarty->display("sample.tpl"); > > > > > > ---- then in the template ----- > > > > {foreach from=$dbresult item=$current key=$ISBN} > > <tr> > > <td>{$current->ISBN}</td> > > <td>{$current->Title}</td> > > <td>{$current->Publisher}</td> > > <td>{$current->Availability}</td> > > <td>{$current->PriceAmount}</td> > > <td>{$current->DiscountPercent}</td> > > <td>{$current->PriceFrom}</td> > > <td>{$current->PriceEuro}</td> > > </tr> > > {/foreach} > > > > --------------------------- > > > > ----- Original Message ----- > > From: "Josh Johnson" <mailing_lists@allusiveimage.com> > > To: "'gawan'" <mail@gawan.net>; > > <smarty-general@lists.php.net> > > Sent: Sunday, September 01, 2002 7:43 PM > > Subject: RE: [SMARTY] Assigning mysql query to smarty template > > > > > > > In the past, I've assigned an entire array to a template variable, and > > > so far it's worked great (the templated part of the site has gotten > > over > > > 30,000 unique accesses in the past week). I made an array of > > > mysql_fetch_object generated objects, which I think made the data more > > > accessable in the template. > > > > > > I'd do something like this (inside of a plugin function, but you could > > > do it inside of the php part of your code, or in a {php} tag): > > > > > > ... > > > mysql query code that assigns the result id to $mysql_result_id > > > ... > > > > > > $result = Array(); //keeps the foreach below from breaking > > > while($row = mysql_fetch_object($mysql_result_id)){ > > > $result[$row->id] = $row; // I used the id for > > > // the key of the array, > > > // you could use whatever > > > // fielf you want > > > } > > > > > > $smarty->assign("database_result", $result); // replace $smarty with > > > // $this if you're using > > a > > > // {php} block, otherwise > > > // this is the name of > > your > > > // smarty object. > > > > > > .... > > > > > > Then, in the template, I can loop through the returned objects like > > so: > > > {foreach from=$database_result item=current key=$id} > > > id: {$current->id} or {$id}<br> > > > name: {$current->fname} {$current->lname} > > > etc... > > > {/foreach} > > > > > > It might be more efficient though to use mysql_data_seek to pull an > > > array or object from the database as needed, instead of all at once, > > > especially if you have a really large amount of data that's being > > > displayed. Depending on how your query is structured, and when you get > > > the array, if a large amount of data is being put into an array, it > > can > > > delay the display of the information, even if some of it is disgarded > > > (I've had this problem in the past). With mysql_data_seek, you could > > out > > > spit out the data for the row as you receive it. I haven't tried it > > yet, > > > but if I ever get around to writing a plugin that uses > > mysql_data_seek, > > > I'll post it. > > > > > > Hope that helps. > > > > > > -- Josh > > > > > > -----Original Message----- > > > From: gawan [mailto:mail@gawan.net] > > > Sent: Sunday, September 01, 2002 12:13 PM > > > To: smarty-general@lists.php.net > > > Subject: [SMARTY] Assigning mysql query to smarty template > > > > > > Hi > > > > > > I am a beginner in using Smarty. Where could I find a basic example on > > > how > > > to assign a mysql query to a smarty template variable. > > > > > > Should I try to assign every result row separately or would assigning > > > the > > > whole query at once be more elegant (as an array of arrays). I am > > still > > > struggling with getting the basics right. > > > > > > thank you > > > > > > P.S. I wonder why smarty.php.net is so often unreachable? > > > > > > > > > -- > > > Smarty General Mailing List (http://smarty.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > -- > > > Smarty General Mailing List (http://smarty.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > -- > > Smarty General Mailing List (http://smarty.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > -- > Smarty General Mailing List (http://smarty.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >

« previous php.smarty.general (#5964) next »