Advertisement
yesamarcos

SQL WordPress Para filtrar posts

Jul 3rd, 2016
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. <?php
  2.  
  3. function getmakers(){
  4.  
  5. $estado = $_POST['estado'];
  6.  
  7. if(isset($estado)){
  8.  
  9. $con = new PDO("mysql:host=localhost;dbname=nome_do_banco", "nome_do_usuario", "senha_do_usuario");
  10. $sql = "
  11. SELECT wp0v_posts.*
  12. FROM wp0v_posts, wp0v_postmeta
  13. WHERE wp0v_posts.ID = wp0v_postmeta.post_id
  14. AND wp0v_postmeta.meta_key = 'estados'
  15. AND wp0v_postmeta.meta_value = '$estado'
  16. AND wp0v_posts.post_status = 'publish'
  17. AND wp0v_posts.post_type = 'representates'
  18. AND wp0v_posts.post_date < NOW()
  19. ORDER BY wp0v_posts.post_date DESC
  20. ";
  21. $rs = $con->query($sql);
  22. $contador = $rs->num_rows;
  23. $registros = $rs->fetchAll();
  24.  
  25. foreach ($registros as $atributo => $valor) {
  26. echo utf8_encode($valor['post_title']) . "<br>";
  27. echo utf8_encode($valor['post_content']) . "<br>";
  28. }
  29.  
  30. }
  31.  
  32. }
  33.  
  34. getmakers();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement