hello ,
-I am making a STORE website with sms gateway feature
-all incoming and outgoing sms are saved in mysql tables
-GAMMU is the application for my sms gateway
please help me solve this problem :
-the incoming sms should be like this [for instance]
ABC 5,CBA 8,CAB 100
note : ABC,CBA and CAB are known as CODES that refer to product name in mysql table
and the following numbers are amount of item of each (well I just want you to know )
1.how to check that incoming sms whether it is in the right format like that I mentioned or not
-so if you :
add more space after comma
use other than comma such as ; or :
write down the CODES more or less than 3 character
or something else that is differ from the predefined format
, such message will be known as wrong message
2.how to know whether the CODES such as ABC,CBA and CAB are available in the table called 'products' in the column called 'product code',
-thanks alotttt
I'll be pleased to know your replies