Advertisement
Guest User

Untitled

a guest
Oct 1st, 2018
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.50 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "autoaukcje_wp1";
  4. $password = "W)0[2cz[]jZGDvLgUY.50(]6";
  5. $dbname = 'autoaukcje_wp1';
  6.  
  7. // Create connection
  8.  
  9.  
  10. $mydb = new wpdb($username, $password, $dbname, $servername);
  11. // echo var_dump($mydb);
  12. $sql = "SELECT `ID` FROM `wp_posts`  WHERE `post_status` = 'publish' AND  `post_type` = 'listing_type' ORDER BY 'post_date' DESC ";
  13. $rows = $mydb -> get_var( $sql, 0, 0 );
  14. echo var_dump($rows);
  15. foreach ($rows as $obj) :
  16.    echo $obj->id;
  17. endforeach;
  18.  
  19.  
  20. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement