Database Query setup

Question

   global $wpdb;

   $res = $wpdb->get_results( $wpdb->prepare(
        "SELECT name, lastname
         FROM datatable
         WHERE userID in ( %d , %d)
         AND
         UserPass in ( %d, %d  )",
         array(
            $val[1],
            $val[2],
            $val[3],
            $val[4],
         )

        ),
        ARRAY_A
    );

where $val[1] and $val[2] should be uset as userID, and $val[3] and $val[4] UserPass. And i think i have problem with ordering the placeholder values and that the query is not setup properly, could use a word of advice.

its a simple PDO statement or word-press prepare statement ? — Ashish Ranade
– Ashish Ranade, Commented Sep 4, 2015 at 11:24
its simple, i was using the prepare only because of the placeholders — Dkikas
– Dkikas, Commented Sep 4, 2015 at 11:30

Ashish Ranade · Accepted Answer · 2015-09-04 11:35:49Z

1

Try with this :

 $querystr = "
    SELECT name, lastname
         FROM datatable
         WHERE userID in ('your user ids implode with commas')
         AND
         UserPass in ('password string implode with commas ')
 ";

 $result = $wpdb->get_results($querystr, OBJECT);

answered Sep 4, 2015 at 11:35

Ashish Ranade

6053 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sanderbee · Accepted Answer · 2015-09-04 11:24:17Z

0

This query returns all the users that match the given passwords.

<?php
    global $wpdb;

   $res = $wpdb->get_results( $wpdb->prepare(
        "SELECT name, lastname, UserPass
         FROM datatable
         WHERE userID in ( %d , %d)
         HAVING UserPass in ( %d, %d  )",
         array(
            $val[1],
            $val[2],
            $val[3],
            $val[4],
         )

        ),
        ARRAY_A
    );
?>

Maybe this helps?

answered Sep 4, 2015 at 11:24

sanderbee

7039 silver badges25 bronze badges

1 Comment

Dkikas Over a year ago

I need only there name and last name, and what i wanted to know rly was if the structure is good and if the placeholder values are writen good, so if WHERE userID in ( $val[1] , $val[2]) AND UserPass in ( $val[3], $val[4] )" has that order of reading

Collectives™ on Stack Overflow

Database Query setup

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related