title: Send an http request in mysql trigger after insertion in a table
body: <p>I am working in PHP.I have to created a mysql trigger which fires an http request after insertion on table.Below is the code.</p>
  <pre><code>DELIMITER @@
  CREATE TRIGGER Test_Trigger
  AFTER INSERT ON insertsms
  FOR EACH ROW
  BEGIN
    SET @tt_json = (SELECT json_object(id,addtime,title) 
                    FROM insertsms WHERE id = NEW.id LIMIT 1);
    SET @tt_resu = (SELECT http_put(CONCAT('--url localhost--')));
  END;
  @@
  DELIMITER ;
  </code></pre>
  <p>But I am getting errors like</p>
  <blockquote>
  <p>Message: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION emg.json_object does not exist</p>
  <p>Message: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION emg.http_put does not exist</p>
  </blockquote>
  <p>How to remove this error? I was not able to download the supporting files containing these functions.I have tested in localhost.Is there any other way to achieve my requirement? Please anyone help me..</p>