User Tools

Site Tools


tutorials:zencartmods:quotes.html

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
tutorials:zencartmods:quotes.html [2011/06/29 19:57]
daigo
tutorials:zencartmods:quotes.html [2011/06/29 20:16]
daigo
Line 1: Line 1:
 +==== Put a random quote on your zen cart template ====
  
 +{{:​tutorials:​zencartmods:​quote.png}}
  
 === Create the Table === === Create the Table ===
Line 24: Line 26:
 Find the place in the template where you'd like to insert the random quote, and add these lines: Find the place in the template where you'd like to insert the random quote, and add these lines:
  
 +in file **includes/​templates/​YOUR_TEMPLATE/​tpl_SOME_FILE.php**
 <code php> <code php>
 $quote_sql = $db->​Execute("​SELECT * from quotes WHERE quotes_active = 1 ORDER BY RAND() LIMIT 1;"); $quote_sql = $db->​Execute("​SELECT * from quotes WHERE quotes_active = 1 ORDER BY RAND() LIMIT 1;");
Line 30: Line 33:
 </​code>​ </​code>​
  
-Obviously you should modify this to match your own template, and add whatever ​css would make it look good. +Obviously you should modify this to match your own template, and add whatever ​CSS would make it look good.  
 + 
 +=== Test it Out === 
 + 
 +Add a few quotes into your database and test it out!  
 + 
 +=== Helper File === 
 + 
 +You don't want to have to manually add quotes in the db through mysql every time, that would be a pain! Instead you should [[tariffhelper.html|make yourself a nice helper file]] in php that you can use through the zencart admin.  
 + 
 +Heere'​s an example of a simple file we use to make managing the quote a little easier: 
 + 
 +{{:​tutorials:​zencartmods:​quotes.php.zip|}}
/home/ladyada/public_html/wiki/data/pages/tutorials/zencartmods/quotes.html.txt · Last modified: 2016/01/28 18:05 (external edit)