{"id":60772,"date":"2016-05-25T14:31:23","date_gmt":"2016-05-25T14:31:23","guid":{"rendered":"https:\/\/br.wordpress.org\/support\/topic\/como-usar-o-wordpress-com-base-de-dados-nao-wp-externa\/"},"modified":"2016-08-06T01:46:46","modified_gmt":"2016-08-06T01:46:46","slug":"como-usar-o-wordpress-com-base-de-dados-nao-wp-externa","status":"publish","type":"topic","link":"https:\/\/br.wordpress.org\/support\/topic\/como-usar-o-wordpress-com-base-de-dados-nao-wp-externa\/","title":{"rendered":"Como usar o WordPress com base de dados (nao wp)  externa."},"content":{"rendered":"<p>Tenho uma base de dados de um site antigo, ele nao utilizava wordpress. agora estamos migrando para o wordpress e gostariamos de utilizar essa base e fazer as querys especificas, vi a possibilidade de usar o WPDB mais tem algumas regras que nao entendi.<\/p>\n<p>um exemplo \u00e9 o codigo abaixo, como poderia fazer ele com o WPDB.<\/p>\n<pre><code>$destaquesImoveis= new MySQL();\n    $destaquesImoveis-&gt;set_table(&#039;Property as imovel&#039;);\n    $destaquesImoveis-&gt;set_where(&#039;      imovel.id=&quot;&#039;.$idImovel[0].&#039;&quot;&#039;);\n    $destaquesImoveis-&gt;set_where(&#039;OR    imovel.id=&quot;&#039;.$idImovel[1].&#039;&quot;&#039;);\n    $destaquesImoveis-&gt;set_where(&#039;OR    imovel.id=&quot;&#039;.$idImovel[2].&#039;&quot;&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;imovel.id&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;imovel.CITY&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;imovel.SALE_PRICE&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;imovel.MS_LISTING_ID&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;imovel.ZIP_CODE&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;imovel.CITY&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;imovel.BUILDING_SQUARE_FOOTAGE&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;imovel.BEDROOMS&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;imovel.BATHS_TOTAL&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;imovel.YEAR_BUILT&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;local.STREET_NAME&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;local.STREET_NUMBER&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;local.PROPERTY_STATE_ID&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;local.STREET_TYPE&#039;);\n    $destaquesImoveis-&gt;join(&quot; INNER &quot;,&#039;_masse_CITY as city&#039;, &#039;city.id=imovel.CITY&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;city.CITY_NAME&#039;);\n    $destaquesImoveis-&gt;set_colum(&#039;foto.URL&#039;);\n    $destaquesImoveis-&gt;join(&quot; INNER &quot;,&#039;PHOTO as foto&#039;, &#039;foto.id=(SELECT id FROM PHOTO as foto2  WHERE foto2.PROPERTY_ID=imovel.MS_LISTING_ID LIMIT 0,1)&#039;);\n    $destaquesImoveis-&gt;join(&quot; INNER &quot;,&#039;LOCATION as local&#039;, &#039;imovel.LOCATION=local.id&#039;);\n    $destaquesImoveis-&gt;select();<\/code><\/pre>\n","protected":false},"template":"","class_list":["post-60772","topic","type-topic","status-publish","hentry","topic-tag-mysql","topic-tag-php"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/br.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/60772","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/br.wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/br.wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/br.wordpress.org\/support\/wp-json\/wp\/v2\/topic\/60772\/revisions"}],"wp:attachment":[{"href":"https:\/\/br.wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=60772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}