mysql

How much PHP and MySQL or MariaDB knowledge should I know to start writing WordPress themes and plug-ins and whatever else a beginner can edit?

Question

I'm not a novice web developer. I know how to use Python and Django at a beginner to intermediate level. I know my basic HTML5, CSS, and JS. I've been learning React.js through Scrimba.com as well as CSS Grid and ...

mysql, php, plugins, rest-api, theme-development 5 hours 0 Answers 2 views

WordPress INNER JOIN custom tables – SQL Query

Question

H, I am trying to get results from two tables with INNER JOIN in WordPress theme template file, but I don't know what's I am doing wrong. Please help me, here is the code below global $wpdb; $user_id = get_current_user_id(); $sql= "SELECT client_id ...

mysql, page-template, theme-development, wordpress.com, wp-query 13 hours 0 Answers 5 views

INNER JOIN custom tables – SQL Query

Question

mysql, page-template, wp-query 13 hours 0 Answers 3 views

MySQL error or data corruption after database migration

Question

I migrated my database to a new host, as well as my WordPress files, I have an online shop using WooCommerce, and everything ran smoothly after migration, what I did not notice at first was that WooCommerce categories are no ...

mysql, taxonomy, woocommerce 2 days 0 Answers 6 views

Upgrade MySQL %.1 to 5>5

Question

How do I upgrade MySQL from 5.1 to 5.5? I upraged WP to 5.2.4 and am using Yahoo as host. Also updated PHP. I cannot find any way to upgrade MySQL.

mysql 3 days 0 Answers 8 views

How to import products in host instead of database on wordpress?

Question

Once I add new product in WordPress, this product adds in MySQL database and database gets bigger and bigger after months I would like to write post/page/products on the host instead of the database how can I do this? for the second ...

database, mysql 3 days 0 Answers 6 views

PHP Warning: mysqli_error(): Couldn’t fetch mysqli in

Question

I am new at this, so this is my case. I am getting this error on my Wordpress site and I need someone to point me out where to search the problem. I know that is written in a log file ...

mysql, php, query 5 days 0 Answers 5 views

wordpress dutch characters encoding problem

Question

I am using the dutch special characters like ï and its being converted to u00ef I have tried ut8_unicode_ci on the wp-config as well as on the database tables where the value is being saved but still it is being ...

characters, encoding, mysql 6 days 0 Answers 10 views

Replace a character in all post titles and slugs

Question

I have hundreds of posts whose titles are of the form XmY, where X and Y are natural numbers, for example 18m324. I'd like to replace m with p in all post titles and slugs, while keeping X and Y unchanged. ...

bulk, mysql 7 days 0 Answers 9 views

update custom post types texsonomies with sql

Question

im trying to update post category but i keep error messages. I have built an update form. each category is a different product type (and a custom post). all the other fields are working except the category i use this ...