Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

two questions (product_listing and checkout)


Guest

Recommended Posts

Hello,

 

I've been modding the checkout procedure, as i found that it was to long.

I've been able to bring it back to two pages, with as third page the confirmation. I only got stuck on the next part.

 

during checkout, you must give in a shipping method. That is where I'm stuck. Since i've got only one shipping method, i wanted that my customers didn't have to select the shipping method, but have it posted in a hidden field. Only what values must i pass, so that it's correct registerd.

Is it enough if i only pass the value "shipping=flat_flat " or must i pass the id's for the shipping. If i must pass the id's, how can i find the correct id's?

 

Another problem i've come upon is that i only want to display a link to product_details.php if the field 'products_description' in the tabel 'products_description' is not empty.

using PhpMyAdmin the following query works:

select products_id, products_description from catalog.products_description where products_description = ''

 

I've created the following query + array for in the file products_listing.php:

//check if the product has a description

$product_description_query = tep_db_query('select products_id, products_description from products_description where products_id =' . $listing_values['products_id']);

$product_description = tep_fetch_array($products_description_query);

Then i have a if statement to check if products_description is empty. If it is, it uses the first statement, otherwise the other.

if ($product_description['products_description'] == '') {

 case 'PRODUCT_LIST_DESCRIPTION':

   $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing_values['products_id']) . '">' . '</a> ';

break;

} else {

 case 'PRODUCT_LIST_DESCRIPTION':

   $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing_values['products_id']) . '">' . tep_image(DIR_WS_IMAGES . 'info.gif', 'meer info') . '</a> ';

break;

}

 

But that doesn't seem to work.

Either php or mysql is ended by windows.

I'm not a expert with php + mysql, and haven't got a clue what is wrong.

 

Any help would be welcome.

Link to comment
Share on other sites

Well, i'm almost finished.

I only have one problem left.

i read at mysql.com that a text field always has space.

How can i now check if it has no value, or that is has.

If tried it with

if (empty($listinvalues['pd.productsdescription']))

if ($listingvalues['pd.productsdescription'])

if (isset($listinvalues['pd.productsdescription']))

 

but it always shows an image infront of all the products or no image at all.

It must only show an image if there is a productsdescription.

Link to comment
Share on other sites

Tried it, and doesn't work.

It contains a space by default in the DB, so it always returns false.

that's also my problem.

Link to comment
Share on other sites

Just tried it. but now i get my image nowhere.

this is the complete code i have now:

    case 'PRODUCT_LIST_DESCRIPTION':

     if (strlen($listingvalues['pd.productsdescription'] < 2)) {

       $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing_values['products_id']) . '">' . '</a> ';

     } else {

       $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing_values['products_id']) . '">' . tep_image(DIR_WS_IMAGES . 'info.gif', 'meer info') . '</a> ';

	 }

          break;

 

I don't see anything what could be wrong.

Link to comment
Share on other sites

Sorry... I have been pasting what you posted before.... should be:

 

if (strlen($listingvalues['pd.products_description'] < 2)) {

Link to comment
Share on other sites

Sorry... I have been pasting what you posted before.... should be:  

 

No prob, i should learn reading before copy -> paste :D

very strange, but doesn't work.

 

Also doesn't work with:

 

<=

==

=>

 

i'm clueless :?

Link to comment
Share on other sites

You've got a bracket in the wrong place guys!

Should be

if (strlen($listingvalues['pd.products_description']) < 2) {

Just a suggestion but an alternative might be to use trim() ... ?

if (trim($listingvalues['pd.products_description']) = '' {

Regards, Wizzud

"It is better to remain silent and be thought a fool, than to open your mouth and remove all doubt."

Link to comment
Share on other sites

thanks wizzud. but still no succes.

current code

    case 'PRODUCT_LIST_DESCRIPTION':

     if (strlen($listingvalues['pd.products_description']) < 2) {

       $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing_values['products_id']) . '">' . '</a> ';

     } else {

       $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing_values['products_id']) . '">' . tep_image(DIR_WS_IMAGES . 'info.gif', 'meer info') . '</a> ';

	 }

          break;

 

Trim doesn't work, php goes down on my server.

 

Shall upload and try it.

Link to comment
Share on other sites

Sorry... its 12:40 am here and I'm a bit too bleary to get thru your code...

It should work using strlen.... you could try str_word_count

Link to comment
Share on other sites

Well, just installed the new php version (was working with an old one on my test server), but it still doesn't work. I get or an image in front of all products or get no image atall.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...