{"id":136,"date":"2013-04-01T12:53:37","date_gmt":"2013-04-01T10:53:37","guid":{"rendered":"http:\/\/blog.momo-webdevelopment.de\/?p=136"},"modified":"2013-04-01T12:59:51","modified_gmt":"2013-04-01T10:59:51","slug":"contao-database","status":"publish","type":"post","link":"https:\/\/blog.momo-webdevelopment.de\/?p=136","title":{"rendered":"contao database"},"content":{"rendered":"

uncached database query<\/p>\n

\r\n$entries = $this->Database->query("SELECT * FROM table WHERE id=$id");\r\nwhile ($entries->next()) {\r\n $entry = $entries->row(); \r\n}\r\n<\/pre>\n
cached database query with prepare statement<\/p>\n
\r\n$entries = $this->Database->prepare("SELECT * FROM table WHERE email=?")\r\n\t\t\t  ->execute($email);\r\nif($entries->numRows) {\r\n\twhile ($entries->next()) {\r\n                 $entry = $entries->row();\r\n        }\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
uncached database query cached database query with prepare statement<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-136","post","type-post","status-publish","format-standard","hentry","category-contao"],"_links":{"self":[{"href":"https:\/\/blog.momo-webdevelopment.de\/index.php?rest_route=\/wp\/v2\/posts\/136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.momo-webdevelopment.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.momo-webdevelopment.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.momo-webdevelopment.de\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.momo-webdevelopment.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=136"}],"version-history":[{"count":6,"href":"https:\/\/blog.momo-webdevelopment.de\/index.php?rest_route=\/wp\/v2\/posts\/136\/revisions"}],"predecessor-version":[{"id":142,"href":"https:\/\/blog.momo-webdevelopment.de\/index.php?rest_route=\/wp\/v2\/posts\/136\/revisions\/142"}],"wp:attachment":[{"href":"https:\/\/blog.momo-webdevelopment.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.momo-webdevelopment.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.momo-webdevelopment.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}