mysql

How vincule a image with a product via mysql

Question

I want to introduce a product and its image via mysql using php script.I am not using wordpress functions. The problem is that I don't know how to make the product have the thumbnail that I specified and it is ...

mysql, php, scripts, woocommerce 30 mins 0 Answers 1 views

How to change the publishing date of each posts?

Question

I need to set the publishing date of many posts with the post date (the creation date). I know that I can do it editing the single post and changing the Published on value but this procedure is problematic if I ...

admin, database, mysql, posts, wp-admin 3 days 0 Answers 9 views

WordPress database error: [Unknown column ‘wp_learndash_pro_quiz_question’ in ‘where clause’] when i uploading a excel file using a plugin

Question

i am getting this error while uploading a excel file using a plugin excel to learndash ? its working fine after uploading but some time it fetching duplicate data. WordPress database error: [Unknown column 'wp_learndash_pro_quiz_question' in 'where clause'] SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE ...

mysql, phpmyadmin, plugin-development, plugins, wordpress-version 4 days 0 Answers 9 views

How to search usermeta table

Question

What is the best way to search usermeta to find a user_id based on a meta_value? For example in usermeta table there is a row with user_id = 123 , meta_key = deviceid and meta_value = 45545. I know the ...

meta-value, mysql, select, user-meta, wpdb 6 days 0 Answers 13 views

how to access 2nd Mysqli Database from different server for wordpress

Question

hello I have an old website https://www.manthanpublication.com/manthantest hosted using Codeigniter as it is hard to customize I decide to change to Wordpress now the problem is I have student result on old website server. I want to access ...

database, functions, javascript, mysql, wordpress.org 6 days 0 Answers 14 views

How to add a custom field and incrementing value for all the published posts

Question

I'm trying to add a custom field value "article" and auto - increment value starting from 1 for all the published and new post starting from the first post. I'm trying with the below code in Mysql. but its ...

mysql, wp-query 6 days 0 Answers 16 views

Accessing 2nd Mysql Database from different server in wordpress to display student result

Question

I'm trying to access 2nd MySQL database in Wordpress from a different server (Wordpress is hosted on AWS using bitami, 2nd database I want to access is on a different server) 2nd database info(which found on original server) (example please ...

database, migration, mysql, wordpress.org 1 week 0 Answers 21 views

How to open a wordpress post from remote mysql?

Question

--How to open a wordpress post from remote mysql? My remote mysql custom tables: posts, titles, imagelinks Original wordpress tables: post_content, post_title, image(i dont know) I have no coding knowledge, please help. I need paid help if necessary. If you can write the ...

customization, mysql 1 week 0 Answers 20 views

Woocommerce SQL Query to find products with no sales [closed]

Question

My client wants to find products which have never had a sale. What is the SQL to do this?

mysql, sql, woocommerce 1 week 0 Answers 16 views

How to pass username into form that sends data to database

Question

I am trying to pass username to database through form: [insert_php] $current_user= wp_get_current_user(); $id= $current_user->user_login; [/insert_php] <input type="hidden" name="id" value="[insert_php]$id[/insert_php]"> But it doesn't get through, the rest of visible inputs do go through though.

database, forms, mysql, php 1 week 0 Answers 19 views

1 2 … 19

Register Now

Login

Lost Password

Login

Register Now

mysql

2020's Best Selling WordPress Themes