Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

get manufacture in products.php

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions
 
Thread Tools Search this Thread
  #21  
Old 10-29-2004, 11:41 AM
  dalmuti's Avatar 
dalmuti dalmuti is offline
 

eXpert
  
Join Date: Oct 2004
Location: Kansas
Posts: 343
 

Default

Perfect! Got it done. Appreciate the help!

Dalmuti
__________________
Louise

Studio 57 Designs - X-Cart Customization
Providing X-Cart Services since 2004
Hottest Blog Directory - Submit Your Blog for a Free Listing
Reply With Quote
  #22  
Old 11-11-2004, 12:06 AM
  august's Avatar 
august august is offline
 

Senior Member
  
Join Date: Jul 2003
Posts: 178
 

Default

Quote:
$smarty->assign("product",$product_info);

+ $manufacturer = func_query_first("SELECT manufacturer FROM $sql_tbl[manufacturers] WHERE manufacturerid='$product_info[manufacturerid]'");
+ $smarty->assign("manufacturer", $manufacturer);

Could anybody post the variant that instead of saying
Manufacturer:Timex
It will show the brandlogo, something like
Timex.gif (brand logo)
else
Timex (text)

To me the customer recognize faster the logo than the name
.

Also, how can I change the manufacturer.php so it will put the brandlogos and names in several columns, instead of one column name.
With an output like this: http://www.makeitfast.com/default.php?manufacturers_id=11
__________________
"The point is, to make so much money, that money isn't the point anymore."

Pro Version 4.0.19
Gold Version 4.1.3
Linux
Reply With Quote
  #23  
Old 02-07-2005, 10:34 AM
 
vortexonline vortexonline is offline
 

Member
  
Join Date: Nov 2004
Location: Albany, NY
Posts: 25
 

Default Manufacturer logo?

How about a manufacturer logo?
How can I place the manufacturer's logo above the product tile?

I am kind of envious of newegg.com

I like how the manufacturer logo appears with the products.

Thanks in advance.
__________________
X-Cart 4.0.7
PHP 4.3.10
MySQL 4.0.22-standard
Reply With Quote
  #24  
Old 02-07-2005, 11:39 AM
 
pmstudios pmstudios is offline
 

Senior Member
  
Join Date: May 2004
Posts: 133
 

Default Re: Manufacturer logo?

Quote:
Originally Posted by vortexonline
How about a manufacturer logo?
How can I place the manufacturer's logo above the product tile?

I am kind of envious of newegg.com

I like how the manufacturer logo appears with the products.

Thanks in advance.


Basically the same exact method, but instead use {$manufacturer.image}

Make sure you have image included in the SELECT query too.
__________________
X-Cart 4.0.5
MySQL: 3.23.58
PHP 4.3.2
Reply With Quote
  #25  
Old 02-07-2005, 04:09 PM
 
mpj mpj is offline
 

Senior Member
  
Join Date: Feb 2005
Posts: 106
 

Default

Quote:
Make sure you have image included in the SELECT query too.

Sorry, how do you go about doing this ?

Here is the MySQL table fields:

Full Texts manufacturerid manufacturer url image image_type descr orderby provider avail





Thanks for a great mod !
__________________
X-Cart 4.0.11


{My simple mods}
Adding Market list and % save on product detail
Quantity input box
Reply With Quote
  #26  
Old 02-07-2005, 07:21 PM
 
pmstudios pmstudios is offline
 

Senior Member
  
Join Date: May 2004
Posts: 133
 

Default

Quote:
Originally Posted by mpj
Sorry, how do you go about doing this ?

Modify the code added in product.php so the query looks like this:
Code:
$manufacturer = func_query_first("SELECT manufacturer,image FROM $sql_tbl[manufacturers] WHERE manufacturerid='$product_info[manufacturerid]'");

Quote:
Originally Posted by mpj
Thanks for a great mod !

And you're welcome
__________________
X-Cart 4.0.5
MySQL: 3.23.58
PHP 4.3.2
Reply With Quote
  #27  
Old 02-08-2005, 08:24 AM
 
mpj mpj is offline
 

Senior Member
  
Join Date: Feb 2005
Posts: 106
 

Default

great work pmstudios!

I've just started out on PHP so please forgive my noobness

As for
Code:
{manufacturer.image}
this would output the blob in raw GIF89 code.


Here's what I've done for displaying manufacturer's image:

in products.tpl

to display image:
Code:
[img]mlogo.php?manufacturerid={$manufacturerid.manufacturerid}[/img]

to display the manufacturer name and a link that display other products by the manufacturer:
Code:


in product.php
Code:
$manufacturer = func_query_first("SELECT manufacturer,image,image_type,manufacturerid FROM $sql_tbl[manufacturers] WHERE manufacturerid='$product_info[manufacturerid]'"); $smarty->assign("manufacturer", $manufacturer); $manufacturerid = func_query_first("SELECT manufacturerid FROM $sql_tbl[products] WHERE manufacturerid='$product_info[manufacturerid]'"); $smarty->assign("manufacturerid", $manufacturerid);


Thanks again pmstudios for an excellent code!
__________________
X-Cart 4.0.11


{My simple mods}
Adding Market list and % save on product detail
Quantity input box
Reply With Quote
  #28  
Old 05-10-2005, 09:34 PM
  RQJay's Avatar 
RQJay RQJay is offline
 

Senior Member
  
Join Date: Oct 2004
Posts: 185
 

Default

I am sorry to ask, but i am having no luck on getting this to work for me, I have to be missing somthing....

In my Product.php file I added this code :
Code:
# Manufacturers Logo In Products $smarty->assign("product",$product_info); $manufacturer = func_query_first("SELECT manufacturer,image FROM $sql_tbl[manufacturers] WHERE manufacturerid='$product_info[manufacturerid]'"); #end logo in Products

And added this to my Product.Tpl file :
Code:
[img]mlogo.php?manufacturerid={$manufacturerid.manufacturerid}[/img]

Pretty much as directed. But still no luck. My product template does display the Xcart image place holder but not the manufacturers Logo.

Any help is greatly appreciated.
Jason
Reply With Quote
  #29  
Old 05-11-2005, 11:02 PM
  august's Avatar 
august august is offline
 

Senior Member
  
Join Date: Jul 2003
Posts: 178
 

Default

Hey MPJ, it is in products.tpl or product.tpl
In the other post they are talking about product.tpl

Hey Vortex, can you post your code, is exactly what I want to do, put the logo at the top, and the text under the image product.
__________________
"The point is, to make so much money, that money isn't the point anymore."

Pro Version 4.0.19
Gold Version 4.1.3
Linux
Reply With Quote
  #30  
Old 05-14-2005, 09:22 PM
  RQJay's Avatar 
RQJay RQJay is offline
 

Senior Member
  
Join Date: Oct 2004
Posts: 185
 

Default

Bump-o-
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 03:45 PM.

   

 
X-Cart forums © 2001-2020