{"id":12168697,"date":"2020-03-21T17:31:03","date_gmt":"2020-03-21T16:31:03","guid":{"rendered":"https:\/\/it.wordpress.org\/support\/topic\/query-su-tabella-personale\/"},"modified":"2020-03-21T17:31:28","modified_gmt":"2020-03-21T16:31:28","slug":"query-su-tabella-personale","status":"publish","type":"topic","link":"https:\/\/it.wordpress.org\/support\/topic\/query-su-tabella-personale\/","title":{"rendered":"Query su tabella personale"},"content":{"rendered":"<p>Ho importato una mia tabella personale nel db di wordpress.`<br \/>\nOra sto provando a recuperare i dati senza successo<\/p>\n<p>Ricevo tale errore:<br \/>\nErrore sul database di WordPress: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near &#8216;7991&#8217; at line 1]<\/p>\n<p>Il file page.php<\/p>\n<pre><code>....\n&lt;?php is_page(&#039;statistiche&#039;); include_once(&#039;inc\/statistiche.php&#039;); ?&gt;\n....<\/code><\/pre>\n<p>Il file statistiche.php<\/p>\n<pre><code> &lt;?php \n global $wpdb;\n $table_name =  &quot;mytabella&quot;;\n $sql=$wpdb-&gt;query(&quot;SELECT * FROM $table_name&quot;);\n   $result = $wpdb-&gt;get_results($sql);\n   foreach ($result as $mt) {\n   echo &quot;&lt;p&gt;&quot; . $mt-&gt;id. &quot;&lt;\/p&gt;&quot;;\n}\n ?&gt;<\/code><\/pre>\n","protected":false},"template":"","class_list":["post-12168697","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/it.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/12168697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/it.wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/it.wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/it.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/12168697\/revisions"}],"predecessor-version":[{"id":12168698,"href":"https:\/\/it.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/12168697\/revisions\/12168698"}],"wp:attachment":[{"href":"https:\/\/it.wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=12168697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}