a very smart conditional clause?

Pink_Panther

Hello everyone,

First of all , I'm a new member here (and I'm sorry for my bad English 🙂 )
I wanna share my 2 "LITTLE" problems with you;

THE FIRST : I know how to build a condition that checks if a value is equal exactly to another value (or exactly not) but , what's about value thats includes other value? how does that's condition look like ?

2.I have a mysql table that has (for example) these fields;

id, ask1, if1, ask2.

let's say it has one row with these values:

'1', 'hello, mello, hey, hi' , 'AND' , 'you';

(Which means that id='1' , ask1=''hello, mello, hey, hi' , if1='AND' ....)

I wanna write a little function that takes those values from the table and build from it a new conditional clause and after that ask it itself.

for example, with those values the output-condition should look like that :

IF (($massage <includes one of> $mysql['ask1']) AND ($massage <includes> you)){

something();
}

Thanks anyone!

jib0

I'm not sure to really understand what you want to do. But if you want to call function something() if variable $massage is one of the words 'hello', 'mello', 'hey', or 'hi' AND contains 'you', you'll better use two tables (or three if ask2 can also be multiple words) and a regex with preg_match function.

table 1: id, if1

table ask1: id_table1, word

table ask2: id_table1, word

peytonrm

strpos is probably the fastest method of doing what you want for the first question. so something like:

if(strpos($haystack, 'mello') !== null) {
//do stuff
}

I dont really follow what you're trying to do in the second question, but you might look into the SQL function IN() . It allows you to select rows that have a value that matches one of a given set. so something like:

SELECT ask1 FROM questions WHERE ask1 IN('hello','mello','hi')

laserlight

A slight correction to peytonrm's example: note that strpos() returns false if the needle is not found, so it should be:

if (strpos($haystack, 'mello') !== false) {
    //do stuff
}

tsinka

Do the two fields contain a comma separated list of possible values ?

In that case you may be able to use the mysql strings as part of a regexp pattern and use preg_match to check if a given string contains any of these keywords and also get the matching one(s) with that one call to preg_match. But that depends on how the data looks like.

Thomas