get_results usando wpdb

Question

get_results usando wpdb

13

105844 2013-08-19

Estoyintentando recuperarinformación sobremi base de datos.Queríamostrartodas las pages usandoesta declaración,pero obtengo un ARRAYen blanco

 global $wpdb;
$result = $wpdb->get_results (
        "
        SELECT * 
        FROM  $wpdb->wp_posts 
        WHERE post_type =  'page'
        "
        );

echo $result; // display data

Resultado:

   ARRAY

EDITAR : después de cambiar las sugerencias a continuación,ahoraestoy usandoesto.pero sigo sin obtenerningún resultado:

 global $wpdb;

    $posts = $wpdb->wp_posts;
    $result = $wpdb->get_results( " SELECT * FROM  $posts WHERE 'post_type' =  'page' "  );

    foreach ($result as $page) {
            echo $page->ID.'<br/>';

    }

I'm trying to retrieve information on my database. I wanted to display all pages using this statement, but I'm getting a blank ARRAY

global $wpdb;
$result = $wpdb->get_results (
        "
        SELECT * 
        FROM  $wpdb->wp_posts 
        WHERE post_type =  'page'
        "
        );

echo $result; // display data

Output:

  ARRAY

EDIT: After changing below suggestions, I'm now using this. but I still don't get any results:

global $wpdb;

    $posts = $wpdb->wp_posts;
    $result = $wpdb->get_results( " SELECT * FROM  $posts WHERE 'post_type' =  'page' "  );

    foreach ($result as $page) {
            echo $page->ID.'<br/>';

    }

- Intenteenvolver `$ wpdb-> wp_posts` con llaves,es decir.`{$ wpdb-> wp_posts}` ..
  
  Try wrapping `$wpdb->wp_posts` with curly braces, ie. `{$wpdb->wp_posts}`..
  - 0
  - 2013-08-19
  - t31os

4 respuestas

votos

- 3
- 2013-08-19
Tiene un ligeromalentendido:

Al llamar a $wpdb,obtiene una lista depropiedades que contienen losnombresprincipales de lastablas:

// The custom prefix from wp-config.php // only needed for custom tables $wpdb->prefix // Tables where you don't need a prefix: built in ones: $wpdb->posts $wpdb->postmeta $wpdb->users

Entonces,su consultafinal se vería como esto:

$wpdb->get_results( "SELECT * FROM {$wpdb->posts} WHERE post_type = 'page'" );
You have a slight misunderstanding:

When calling $wpdb, you get a list of properties that contain the core names of the tables:

// The custom prefix from wp-config.php // only needed for custom tables $wpdb->prefix // Tables where you don't need a prefix: built in ones: $wpdb->posts $wpdb->postmeta $wpdb->users

So your final query would look like this:

$wpdb->get_results( "SELECT * FROM {$wpdb->posts} WHERE post_type = 'page'" );
- +1poresto,gracias.peronecesitaba darle crédito a lapersona queme respondióprimero,él ya dio la respuesta correcta,simplementenopude seguir susinstrucciones.
  
  +1 for this, thank you. but i needed to give credit the person who responded to me first, he already provided the correct answer, i was just wasnt able to follow his instruction.
  - 1
  - 2013-08-19
  - user1933824
- Por supuesto.Nota almargen: Como dije,el `$ wpdb->prefix`no debería usarseparatablasintegradas.Solo llámalos directamente.Arregladaestaes su respuestatambién.
  
  Sure. Sidenote: As I stated, the `$wpdb->prefix` shouldn't be used for built-in tables. Just call them directly. Fixed this is his answer as well.
  - 0
  - 2013-08-19
  - kaiser

1

2014-07-16

Pruebeel siguiente código.Enfrenté unproblema similar y lo resolvíeliminando $ wpdb del campo 'FROM'.

 global $wpdb;
$result = $wpdb->get_results (
            "
            SELECT * 
            FROM  wp_posts 
            WHERE post_type =  'page'
            "
            );

echo $result; // display data

Try the following code. I faced the similar problem and solved it by removing $wpdb from 'FROM' field.

global $wpdb;
$result = $wpdb->get_results (
            "
            SELECT * 
            FROM  wp_posts 
            WHERE post_type =  'page'
            "
            );

echo $result; // display data

- 0
- 2013-08-19
Por "matrizen blanco",¿te refieres a una 'matriz vacía' oes la salida 'ARRAY'.Siesel último,entoncesesel resultadoesperado.Necesita recorreresamatriz ymostrar los resultadosen consecuencia.

Referencia: http://codex.wordpress.org/Class_Reference/wpdb#SELECT_Generic_Results

By "blank Array" do you mean an 'empty array' or is the output 'ARRAY'. If it's the latter then, it is the expected output. You need to loop through that array and display results accordingly.

Reference: http://codex.wordpress.org/Class_Reference/wpdb#SELECT_Generic_Results

Balas · Accepted Answer · 2013-08-19

18

2013-08-19

 global $wpdb;

$result = $wpdb->get_results ( "
    SELECT * 
    FROM  $wpdb->posts
        WHERE post_type = 'page'
" );

foreach ( $result as $page )
{
   echo $page->ID.'<br/>';
   echo $page->post_title.'<br/>';
}

global $wpdb;

$result = $wpdb->get_results ( "
    SELECT * 
    FROM  $wpdb->posts
        WHERE post_type = 'page'
" );

foreach ( $result as $page )
{
   echo $page->ID.'<br/>';
   echo $page->post_title.'<br/>';
}

fuente
Balas

hola @balamurugan,intentétu respuestaperotodavíano obtengoningún resultado.puedes vermi parte [EDITAR] arriba.

hi @balamurugan, i tried your answer but im still not getting any results. you can see my [EDIT] part above.
- 0
- 2013-08-19
- user1933824
en realidad,lo que obtienes y quitas ... demi código.loprobé y obtuvetoda laidentificación de lapágina

actually what u r getting and do u remove ... from my code. i tested it and getting all page id
- 0
- 2013-08-19
- Balas
Estoy usandomi parte [editar] como se ve arriba demi publicación original. Intenté `echo $ result` solopara asegurarme de queestoy recuperando datos de la` consulta`,lo que obtengoesimprimir `Array`.cuando uso `echo $page-> ID`no obtengonada.Realmentenoestoy seguro depor qué ...

im using my [edit] part as seen above my original post. i tried `echo $result` just to make sure that im retrieving data from the `query` what i get is print `Array`. when i use `echo $page->ID` i dont get anything. im really not sure why..
- 0
- 2013-08-19
- user1933824
simplemente copia ypegaese códigopor completo.Esoestodo lo que hay que hacerpara obtenerel resultado.

you just simply copy & paste that code completely. That's all to do to get the result.
- 0
- 2013-08-19
- Balas
sí,funcionó!cuandotrato de revisarmi código yeltuyo,la única diferencia que viesestaparte `$tablename=$ wpdb->prefix.'posts ';`estapartenoestabaen la documentación del códice.¿puedesexplicarmepor quéfunciona?

yes, it worked! when i try to review my code and yours, the only difference i saw is this part `$tablename = $wpdb->prefix.'posts';` this part wasnt in the codex documentation. can you explain to me why it works?
- 0
- 2013-08-19
- user1933824
$ wpdb->prefix=wp_ (comoen elprefijo de latabla de labase de datos) que será como wp_postsen labase de datos.enelfuturo,puede dar sunombre comoprefijo.para queno afecte aestetipo de código.Eintente usarlo siempre deestamanera.

$wpdb->prefix = wp_ ( as in database table prefix) which will be as wp_posts in database. in future u can give yourname as prefix. so that it will not affect this kind of code. And try always use this way.
- 0
- 2013-08-19
- Balas