Dear All,
I am new in using - PHP-Codeigniter 2.1.3, MySQL , XAMPP. I have a Database tables Customer, While new customer interested into the table, I want that immediately to sent a mail or SMS to his phone.
I tried the following code, In MySQL table I added a trigger with customer table, In that trigger I wanted to assign my php file or CONTROLLER Path to sent mail, but showing errors.
BEGIN
IF NEW.flag = 1 THEN
DECLARE result CHAR(255);
SET cmd = CONCAT('E:/xampp/php/php.exe -f "E:/xampp/htdocs/DEN/sentEmail.php"');
SET result = sys_exec(cmd);
END IF;
END
How can I solve this issue, is there any other easy way please…!! I am highly expecting your idea and kind support. Thanking you in Advance.
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.