I am working on wordpress which is new to me Now I have been provided with site completely designed in wp But the problem is I am unable to search the query for each functionality/page I found $wpdb->get_results used for getting result from database also this is not working $wpdb->queries Is there any way to … Read more
In order of figuring out the following issue, see https://wordpress.stackexchange.com/questions/178995/sanitize-a-working-query-string-by-using-wpdb-prepare-fails-with-mysql-db-er i ran into an rather odd behaviour. Even that my used query was correct and showing the right output. global $wpdb; $wpdb->show_errors(); $pageposts = $wpdb->get_results( $wpdb->prepare( ” SELECT skposts.* FROM $wpdb->posts skposts, $wpdb->postmeta skpostmeta1, $wpdb->postmeta skpostmeta2 WHERE skposts.ID = skpostmeta1.post_id AND skposts.ID = skpostmeta2.post_id AND … Read more
I have the following: $query = ‘SELECT * FROM wp_pod_tbl_add_questions WHERE id LIKE ‘. $id; $row = $wpdb -> get_results($query); How do I get the columns named ‘id’ and ‘name’ from $row? 4 foreach( $wpdb->get_results(“SELECT * FROM your_table_name WHERE id LIKE’ . $id . ‘;”) as $key => $row) { // each column in your … Read more
When i try something like this $status = NULL; $wpdb->update( ‘table’, array( ‘status’ => $status, ), array( ‘id’ => 1 ) ); In the ‘status’ column now i have an empty string ”, it simply won’t set it to NULL. The column can be NULL of course. I’ve also tested $wpdb->query and $wpdb->prepare and the … Read more
As in the title, how to programatically change user’s login? I wanted to use wp_insert_user function, but it appears that when updating current user, it doesn’t change their username. Should I use $wpdb->update for that? If yes, how would code for changing username look like? What consequences would changing user login have, given that WordPress … Read more
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 … Read more
Do I need to use wpdb prepare before wpdb->insert? If I am inserting values into a wordpress table using wpdb->insert, do I need to “clean” my data before inserting it or does this method (wpdb->insert) do that for me? 3 No, you shouldn’t prepare or escape the data, this is done for you by the … Read more
Sorry if this question is trivial. I’m just beginning to develop plugins in WordPress. In all the tutorials I found this: while creating the custom tables, $wpdb->prefix is used. Example: $table_name = $wpdb->prefix . “liveshoutbox”; My question: Is it mandatory to use $wpdb->prefix? What happens If I don’t use prefix for my custom tables? 2 … Read more
I wrote a function which is supposed to return the number of rows found in a SELECT query but it always either seems to return 0 or an array. I have been messing around with this for about an hour now and I still can’t figure it out! I’m sure I’m doing something stupidly wrong. … Read more
I am using $wpdb->update to update a custom table I have in my database. When I var_dump the result it returns: int(0) So I tried $wpdb->print_error() to see what’s wrong. However, it shows nothing. I also tried $wpdb->show_errors(), but again it showed nothing. The wpdb docs don’t go into much detail on how to use … Read more
