Jump to content
Larry Ullman's Book Forums

Hillbilly

Members
  • Content Count

    11
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Hillbilly

  • Rank
    Newbie
  1. I have setup Google Enhanced Analytics on my website to track each stage of the checkout process. I.E. 1) Step 1 - View Cart 2) Step 2 - Add Billing Details (Checkout page in book) 3) Step 3 - Review order, add payment details This triggers when a user loads each page. However the Google analytics is showing more users are reaching Step 3 than are reaching the Step 2 (an impossible event). So I am wondering, as per the book: "The shopping part of the site purposefully does not use sessions (in order to give longevity to the customer’s cart and wish list), but the checkout proce
  2. Perfect! I should have tried that first and saved myself alot of effort! I was testing on both IE and Chrome and both were giving the same issues - now cleared. (Site was already live when the issues showed up) Thank you for your input. Now my mind is at ease.
  3. Hi Larry, You can view yourself - the site is live: www.ltprtz.co.uk If you select the (for eg) "On Road Lights" and then choose one of the drop down menu links: All the menu links EXCEPT the last menu link will link correctly: Ie: The resultant page will open and the link will display: /browse/on-road/headlights However - the last menu item in this drop down - in our case "Round Driving Lights", when clicked, will show: /browse/on-road/driving-round-lights?type=on-road&category=driving-round-lights This is the same across all the product menu items. I'm stumped.
  4. Hi David - sorry for the late response: Code is as follows //fetch data $r = mysqli_query($dbc, "SELECT * FROM categories WHERE master_category = 'on-road' ORDER by id;"); // create variable $on_road_products_basic_menu = ''; //create links while ( $row = mysqli_fetch_array( $r, MYSQLI_ASSOC ) ) { if ( $r ) { $on_road_products_basic_menu .= '<li> <a href="/browse/'.$row['master_category'].'/'.$row['category'].'/"> '.$row['display_name'].'</a>
  5. ok - now I see that it is just the last link in each of my drop down menu lists that show the variables in the URL bar when clicked? The links look EXACTLY the same to the other links in the drop down menu (dynamically created). Any ideas anyone? Im going around in circles here... Here is the html of a drop down menu - the highlighted link shows the variables once clicked? (its always the last link that does this) <ul class="menu photo-dropdown submenu is-dropdown-submenu first-sub vertical js-dropdown-active" data-submenu="" role="menu" style=""> <li class="cell is
  6. Hi, My htaccess has a this ReWriteRule which works perfectly: RewriteRule ^browse/([A-Za-z\+\-]+)/([A-Za-z\+\-]+)/?$ browse.php?type=$1&category=$2 However sometimes I see the variables included in the URL bar. Eg: https://www.mysite.com/browse/on-road/lights?type=on-road&category=lights Other links are fine: https://www.mysite.com/browse/on-road/worklights I cant tell why only a few select links show the variables. Any help would be appreciated. Here is my full htaccess file - some bits added for SEO: <if "%{HTTPS} == 'on'"> Header always set St
  7. Thanks Larry, One last question regarding the above. I just have one small issue in that some of the columns names in Winch Specifications table and the Hoist Specifications table are the same. Is there any way to add a prefix to the column names of the entire table? Eg: SELECT psw.* AS psw_*, psh.* AS psh_* ... (rather than listing every singles column with AS)
  8. OK - I managed to return the products and the specifications in a big table as follows: IN product_ids VARCHAR (300) // the product ids and sku's sent concatenated in an array eg: "1-WIN01","123-HOIS98","206-WIN651" // I concatenated the sku and ids as if I used the id on its own then the WHERE clause failed as it would find "1" in "123" BEGIN set @query = concat("SELECT c.category, pr.*, psh.*, psw.* FROM products AS pr INNER JOIN categories AS c ON c.id = pr.category_id LEFT JOIN product_specs_hoists AS psh ON psh.id = pr.specs_id LEFT JOIN product_specs_winches AS
  9. Thanks for responding Larry, Basically I would like to return a list of products with their technical specifications. The database has a list of products, each product belongs to a category and each category has a separate table for it's technical specifications. For example: Product (Winch 1) - Category (Winches) - Specifications (Winches Technical Specs) Product (Hoist 1) - Category (Hoists) - Specifications (Hoists Technical Specs) Product (Winch 2) - Category (Winches) - Specifications (Winches Technical Specs) etc I have a situation where I need to call products from bot
  10. Hi, (Thanks for the great book ) I am trying to write a a stored procedure that will perhaps loop through an array of product ids and then JOIN tables in the database depending on what category the product is in (their may be multiple products in different categories). I am not sure if this possible - am I barking up the wrong tree? Very simplified - this obviously doesn't work but perhaps you can get an idea of what I'm trying to achieve) IN: product_ids_array VARCHAR (300) //Array of ids sent with the call BEGIN // start loop here somehow ? Would I have to split ID array fi
  11. I am sure this is a stupid question but I'm tearing my hair out. I am trying to email data that I have cleaned (from a multi-line text box) with escape_data. The problem is the data is sent with \r\n instead of actual line breaks. Eg: message in email will read "Hello\r\nThis is the 1st parapgraph\r\n\r\nThis is another" I have tried to remedy this below but it does not work: if ($_POST['Information'] != '') { $Information = escape_data($_POST['Information'], $dbc); $Informationformatted = str_replace(array("\r\n", "\r", "\n"), "<br />", $Informati
×
×
  • Create New...