{"id":1634,"date":"2017-03-13T14:48:44","date_gmt":"2017-03-13T13:48:44","guid":{"rendered":"http:\/\/www.si-hu.eu\/en2\/?page_id=1634"},"modified":"2017-09-08T10:50:25","modified_gmt":"2017-09-08T09:50:25","slug":"testna","status":"publish","type":"page","link":"http:\/\/www.si-hu.eu\/en2\/projects\/testna\/","title":{"rendered":"Testna"},"content":{"rendered":"<div id='layer_slider_1'  class='avia-layerslider main_color avia-shadow  avia-builder-el-0  el_before_av_heading  avia-builder-el-first  container_wrap sidebar_right'  style='height: 151px;'  ><\/div><div id='after_layer_slider_1'  class='main_color av_default_container_wrap container_wrap sidebar_right'  ><div class='container av-section-cont-open' ><div class='template-page content  av-content-small alpha units'><div class='post-entry post-entry-type-page post-entry-1634'><div class='entry-content-wrapper clearfix'>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_heading-5f07bd71f81fbf80626149734ea6965c\">\n#top .av-special-heading.av-av_heading-5f07bd71f81fbf80626149734ea6965c{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-av_heading-5f07bd71f81fbf80626149734ea6965c .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-av_heading-5f07bd71f81fbf80626149734ea6965c .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-av_heading-5f07bd71f81fbf80626149734ea6965c av-special-heading-h3  avia-builder-el-1  el_after_av_layerslider  el_before_av_one_fifth  avia-builder-el-first '><h3 class='av-special-heading-tag'  itemprop=\"headline\"  >APPROVED PROJECTS<\/h3><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_fifth-6126cab7d8fab8d08143dd2dacdf673c\">\n.flex_column.av-av_one_fifth-6126cab7d8fab8d08143dd2dacdf673c{\nborder-radius:0px 0px 0px 0px;\n-webkit-border-radius:0px 0px 0px 0px;\n-moz-border-radius:0px 0px 0px 0px;\n}\n<\/style>\n<div class='flex_column av-av_one_fifth-6126cab7d8fab8d08143dd2dacdf673c av_one_fifth  avia-builder-el-2  el_after_av_heading  el_before_av_four_fifth  first flex_column_div av-zero-column-padding '   ><section  class='av_textblock_section av-av_textblock-0366cc7376be6c9e82a3e9cc8987b64f'  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>6<\/p>\n<p>APPROVED PROJECTS<\/p>\n<\/div><\/section><\/div>\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_four_fifth-0aa7055fe62c3622faec82866afbaeb2\">\n.flex_column.av-av_four_fifth-0aa7055fe62c3622faec82866afbaeb2{\nborder-radius:0px 0px 0px 0px;\n-webkit-border-radius:0px 0px 0px 0px;\n-moz-border-radius:0px 0px 0px 0px;\n}\n<\/style>\n<div class='flex_column av-av_four_fifth-0aa7055fe62c3622faec82866afbaeb2 av_four_fifth  avia-builder-el-4  el_after_av_one_fifth  el_before_av_textblock  flex_column_div av-zero-column-padding '   ><section  class='av_textblock_section av-av_textblock-0366cc7376be6c9e82a3e9cc8987b64f'  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p><strong>[wpdatatable id=1]<\/strong><\/p>\n<\/div><\/section><\/div>\n<section  class='av_textblock_section av-av_textblock-0366cc7376be6c9e82a3e9cc8987b64f'  itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/CreativeWork\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Test<\/p>\n<p>[insert_php]<\/p>\n<p>$servername = &#8220;mysql.arr.sigov.si&#8221;;<br \/>\n$username = &#8220;admin&#8221;;<br \/>\n$password = &#8220;admin375xa&#8221;;<\/p>\n<p>\/\/ Create connection<br \/>\n$conn = new mysqli($servername, $username, $password);<\/p>\n<p>\/\/ Check connection<br \/>\nif ($conn-&gt;connect_error)&nbsp;{<br \/>\n&nbsp;&nbsp;&nbsp; die(&#8220;Connection failed: &#8221; . $conn-&gt;connect_error);<br \/>\n}<\/p>\n<p>echo &#8220;Test 123&#8221;;<\/p>\n<p>$sql = &#8220;SELECT * FROM wp_test&#8221;;<br \/>\n$result = $conn-&gt;query($sql);<\/p>\n<p>if ($result-&gt;num_rows &gt; 0) {<br \/>\n\/\/ output data of each row<br \/>\nwhile($row = $result-&gt;fetch_assoc()) {<br \/>\necho &#8220;id: &#8221; . $row[&#8220;id&#8221;]. &#8221; &#8211; Name: &#8221; . $row[&#8220;first&#8221;]. &#8221; &#8221; . $row[&#8220;last&#8221;]. &#8221;<br \/>\n&#8220;;<br \/>\n}<br \/>\n} else {<br \/>\necho &#8220;0 results&#8221;;<br \/>\n}<br \/>\n$conn-&gt;close();<\/p>\n<p>[\/insert_php]<\/p>\n<\/div><\/section>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":5,"featured_media":0,"parent":87,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0},"_links":{"self":[{"href":"http:\/\/www.si-hu.eu\/en2\/wp-json\/wp\/v2\/pages\/1634"}],"collection":[{"href":"http:\/\/www.si-hu.eu\/en2\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/www.si-hu.eu\/en2\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/www.si-hu.eu\/en2\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"http:\/\/www.si-hu.eu\/en2\/wp-json\/wp\/v2\/comments?post=1634"}],"version-history":[{"count":20,"href":"http:\/\/www.si-hu.eu\/en2\/wp-json\/wp\/v2\/pages\/1634\/revisions"}],"predecessor-version":[{"id":3842,"href":"http:\/\/www.si-hu.eu\/en2\/wp-json\/wp\/v2\/pages\/1634\/revisions\/3842"}],"up":[{"embeddable":true,"href":"http:\/\/www.si-hu.eu\/en2\/wp-json\/wp\/v2\/pages\/87"}],"wp:attachment":[{"href":"http:\/\/www.si-hu.eu\/en2\/wp-json\/wp\/v2\/media?parent=1634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}