To insert data you should use query() (documentation), get_var() method is for selecting data. If error is encountered, query() returns FALSE. query() This function returns an integer value indicating the number of rows affected/selected for SELECT, INSERT, DELETE, UPDATE, etc. For CREATE, ALTER, TRUNCATE and DROP SQL statements, (which affect whole tables instead of specific … Read more
There appears to be a syntax error on line 4. string is not quoted ↓ ↓ ↓ $sql = “CREATE TABLE IF NOT EXISTS ” . $wpdb->prefix.credofy_contact_form. ” ( Instead, I would recommend moving your table creation logic to a plugin and having it run off an installation hook. Below is an example: <?php /** … Read more
You can get the last inserted ID from $wpdb with the insert_id property: $wpdb->insert( … ); $couponId = $wpdb->insert_id
Yes, usually you create a new database, user and password as well as use another copy of WordPress to create a new site. You can create a new directory in the same place where the “wordpress” directory is located and use that one for the new site. Note that it is possible to use the … Read more
You should have not searched the field and replaced all the references to wp_ with anything. For example : the value of the entry with meta_key wp_page_for_privacy_policy will be change to wp_addtionnal_prefix page_for_privacy_policy. Hence there could be a lot of misfitted values in your table. A better way would have been to : export the … Read more
Your code worked absolutely fine for me, so I suspected you forgot to flush the rewrite rules. Each time after you added code which alters the WordPress rewrite rules, e.g. add_rewrite_rule() or code which registers/un-registers a CPT or custom taxonomy with URL rewriting enabled, you should always flush the rewrite rules which means WordPress will … Read more
@Ooker It’s the Jetpack that is serving you the images on https. If you’d turn off the Photon add-on from Jetpack you should be able to get images served over http from your own server. Also if you turn off Photon, images won’t be served from CDN anymore, so you might have to figure that … Read more
You can (and should) use the existing database connection by accessing global $wpdb. The simplest way to use it is with the get_results() method: global $wpdb; $results = $wpdb->get_results( ‘SELECT * FROM my_table’ ); There’s other methods available, and things you need to consider like preparing queries and using the correct table prefix (if your … Read more
Why am I getting this error? Because the table wp_term_taxonomy does not have the column object_id. And the correct table that you should update is the wp_term_relationships table which does have the column object_id. See the WordPress database diagram and also the WordPress database description for more details. So your SQL query should be: UPDATE … Read more
Slugs are saved in the very same table but in the post_name column. So your query would look like this: UPDATE wp_posts SET post_name = REPLACE(post_name, ‘m’ , ‘p’) WHERE post_type=”post” AND post_status=”publish”; By the way, I’d suggest you to use $wpdb->posts instead of just wp_posts ( then it would be compatible with different prefixes, … Read more