AJ Justo aj-justo
aj-justo
/ ZenCart_SQL_Get_cats_with_products
Created
May 27, 2011 10:23
Zen Cart SQL: Get all categories with products on them
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select * from categories_description where language_id=1 and ( categories_id in (select categories_id from products_to_categories) or categories_id in (select parent_id from categories) ) |
aj-justo
/ truncatetext.php
Created
May 26, 2011 19:17
— forked from odino/truncatetext.php
aj safe truncate text try!
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| function safe_truncate_text($text, $lenght) | |
| { | |
| $trunc_text_parts = explode(' ', substr($text, 0,$length)); | |
| $parts = count($trunc_text_parts); | |
| $final_text_parts = array_slice( explode(' ', $text), 0, $parts ); | |
| $final_text = implode(' ', $final_text_parts).' ...'; | |
| return $final_text; |
NewerOlder