Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function getmakers(){
- $estado = $_POST['estado'];
- if(isset($estado)){
- $con = new PDO("mysql:host=localhost;dbname=nome_do_banco", "nome_do_usuario", "senha_do_usuario");
- $sql = "
- SELECT wp0v_posts.*
- FROM wp0v_posts, wp0v_postmeta
- WHERE wp0v_posts.ID = wp0v_postmeta.post_id
- AND wp0v_postmeta.meta_key = 'estados'
- AND wp0v_postmeta.meta_value = '$estado'
- AND wp0v_posts.post_status = 'publish'
- AND wp0v_posts.post_type = 'representates'
- AND wp0v_posts.post_date < NOW()
- ORDER BY wp0v_posts.post_date DESC
- ";
- $rs = $con->query($sql);
- $contador = $rs->num_rows;
- $registros = $rs->fetchAll();
- foreach ($registros as $atributo => $valor) {
- echo utf8_encode($valor['post_title']) . "<br>";
- echo utf8_encode($valor['post_content']) . "<br>";
- }
- }
- }
- getmakers();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement