{"id":2038,"date":"2019-05-10T20:21:29","date_gmt":"2019-05-10T19:21:29","guid":{"rendered":"https:\/\/ibex.tech\/cloud\/?p=2038"},"modified":"2022-02-17T07:13:49","modified_gmt":"2022-02-17T07:13:49","slug":"event-logging-table","status":"publish","type":"post","link":"https:\/\/ibex.tech\/cloud\/mysql\/examples-mysql\/event-logging-table","title":{"rendered":"Event Logging Table"},"content":{"rendered":"\n<p>A table used to store recent special events so db admins can see whats happening for instance.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Add event to table<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>\n\/\/*********************************************\n\/\/*********************************************\n\/\/********** ADD API EVENT LOG ENTRY **********\n\/\/*********************************************\n\/\/*********************************************\nfunction ApiEventLogAdd ($EventType, $EventText)\n{\n  global $dblink;\n\t\n\t\/\/----- DELETE OLD EVENTS -----\n\tmysqli_query($dblink, \"DELETE FROM tblApiEventsLog WHERE EventTime &lt; DATE_SUB(now(), INTERVAL 30 DAY)\");\n\t\n\t\/\/----- ADD THE NEW EVENT -----\n\t$EventType = intval($EventType);\n\t$EventText = mysqli_real_escape_string($dblink, $EventText);\n\t\n\tmysqli_query($dblink, \"INSERT INTO tblApiEventsLog (\n\t\t\t\tEventTime,\n\t\t\t\tEventType,\n\t\t\t\tEventMessage\n\t\t\t) VALUES (\n\t\t\t\tNow(),\n\t\t\t\t$EventType,\n\t\t\t\t'$EventText'\n\t\t\t)\");\n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>A table used to store recent special events so db admins can see whats happening for instance. Add event to table<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[148],"tags":[],"class_list":["post-2038","post","type-post","status-publish","format-standard","hentry","category-examples-mysql"],"_links":{"self":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/2038","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/comments?post=2038"}],"version-history":[{"count":3,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/2038\/revisions"}],"predecessor-version":[{"id":2926,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/2038\/revisions\/2926"}],"wp:attachment":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/media?parent=2038"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/categories?post=2038"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/tags?post=2038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}