• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

Need a bit of help understanding some PHP

Take a look at the code below this....

I want to trigger another variation in this code.  I've already written the variation as this:

<?php
  $promo_title="Promotions";
  $promos[1]["sc_amount"]=40;

  $promos[2]["sc_amount"]=100; //            <-- variation
?>
 
I also have a different SQL string to look for, which is handy....

"and promotion_offer_1 like '%Offer%';

What I want to do is simply incorporate this.
So essentially, the same thing but with Offer for the SQL and the 'promos' code as 2

require("promo.php");
		global $sc_total;
		$sql_string.=" and promotion_offer_1 like '%True%' ";
				
		
		if ($sc_total<$promos[1]["sc_amount"]) 					
				
		{
			$sql_string.=" and 1=0 ";
			
			require("info_promotions.php");
		}	
		
	}

Open in new window

0
chriscounter07
Asked:
chriscounter07
  • 3
  • 3
1 Solution
 
twocandlesCommented:
But what's your actual target? Apply a new filter to the query? Could you describe your problem a little more?

I'm understanding this:

You have a promo_1 applied to a value equal or greater than $promos[1]["sc_amount"] and you want to add a second promo with $promos[2]["sc_amount"] "trigger" value to be added to your query. Is that right?
0
 
chriscounter07Author Commented:
You have a promo_1 applied to a value equal or greater than $promos[1]["sc_amount"] and you want to add a second promo with $promos[2]["sc_amount"] "trigger" value to be added to your query. Is that right?


This is statement is correct.  I just want it to do two things rather than one at two different values
0
 
twocandlesCommented:
OK, I modified your piece of code. I don't know if it works, but I gess you'll get the idea.

The where clause has to be modified in order to take into account the new filter with an OR.

require("promo.php");
                global $sc_total;
                $sql_string.=" and ( promotion_offer_1 like '%True%' ";
                                
                
                if ($sc_total<$promos[1]["sc_amount"])                                  
                                
                {
                        $sql_string.=" and 1=0 ";
                        
                        require("info_promotions.php");
                }       
                $sql_string .= ") or ( promotion_offer_1 like '%Offer% ";
                if ($sc_total<$promos[2]["sc_amount"])                                  
                                
                {
                        $sql_string.=" and 1=0 ";
                        
                        require("info_promotions.php");
                }       
                $sql_string .= ")"; 
                
        }

Open in new window

0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
twocandlesCommented:
There's a opening parenthesis missing after the first AND and a closing parenthesis in the last line (so the operator precedence between the outer AND and the inner OR don't become a problem)
0
 
chriscounter07Author Commented:
right.  Shall give that a go then....
0
 
chriscounter07Author Commented:
I could only put Good as a grade because the code in fact crashed the SQL server.  However, a guideline was what I requested and this is what I got.  I am very happy with the code and I can see by reading it it only requires a subtle change to make it work for me.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now