Strip Tags in Description

With our new online store, we are using descriptions and data from our previous system. Unfortunately, we do not want to strip out all the code that we have in them but we would like to remove it on the fly. Where can I find the spot that I can insert the PHP strip_tags function to apply to the data from the database?

I want the short description limiting (to ~200 characters) to be done after the tags are removed of course.

Where does Zencart keep all its MySQL queries? For example, where is select * from products?? (where...)

benn600:

Where does Zencart keep all its MySQL queries? For example, where is select * from products?? (where...)

you need to look at the developers tool kit in the admin section of your site

I'm looking there. Where should I see queries? My issue is (maybe you can help solve it) that I need to run a php function on the "products_description" field for the main product text. It's a function I wrote to give all our descriptions a similar look (it finds and replaces some things). So if I can find where the queries are at and where they are run, I can just change it there so I don't have to change it on every page.

In looking through the Zencart files I'm having trouble finding a single query!

Reference: http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_54&products_id=378

For the product page, you're probably needing to look at the /includes/modules/pages/product/main_template_vars.php or header_php.php

For the product-listings, try /includes/modules/product_listing.php

main_template_vars worked PERFECTLY for fixing the product info display page. The SQL is in there and I was able to fix the result right there.

Now for the product listing on search results (category listing) I can't seem to find the same thing.

Where is the SQL statement that gets info for listing products on a product_listing page?

Your assistance is greatly appreciated. Thanks!

benn600:

Where is the SQL statement that gets info for listing products on a product_listing page?As I said, the product listing is built in /includes/modules/product_listing.php via:```
zen_trunc_string(zen_clean_html(stripslashes(zen_get_products_description($listing->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION)

Now I am clicking on a category and all the products that list is where I'm seeing the problem.

zen_trunc_string(zen_clean_html(stripslashes(zen_get_products_description($listing->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION)

if I change this to
zen_trunc_string(zen_clean_html(stripslashes('TESTING' . zen_get_products_description($listing->fields['products_id'], $_SESSION['languages_id']))), PRODUCT_LIST_DESCRIPTION)

it doesn't seem to change anything on the description list.

There are two instances of that in the file ... one which fires if a manufacturer filter has been selected, and one where no filter is selected.
Which one did you alter?

Amazing! Thanks! There are two lines. I fixed both of them.

Now one final question. We have a secondary ID for all our products to link with another system. Where is the actual SQL that gets this data? I need to add a field for it to get.

Thank you!

I need to modify a SQL statement, specifically the one that gets item information for listing products after clicking on a category.

Where can I find this SQL statement? I know how to modify it to suit my needs but can't find it.

I solved the problem. It was in product_listing.php and then I made a new function to get my itemnum (that I created in the database).

Hi,

It's in "/includes/index_filters/default_filter.php" file.
About line 55, you have :

// show the products in a given category

Right after, there's the SQL statement that you were looking for.

Good luck !

I modified a file but cannot figure out what file I was editing. I have looked everywhere.

What file contains the line:
$sql = "select p.products_id," ...?
It is the one that actually gets and displays the product info for a specific product's page.

Thanks!

Looking back at one of your previous posts, it could be..

includes/index_filters/default_filter.php

Sorry, it seems the problem was solved before i replied, but when i replied i didn't see any answers to your question (maybe because of a forum cache or my browser cache).