You are missing comma end of phone varchar(10) NOT NULL line, add comma end of line after that table will be created. I have tested https://prnt.sc/qgqmog function lapizzeria_database() { global $wpdb; global $lapizzeria_db_version; $lapizzeria_db_version = “1.0”; $table = $wpdb->prefix . ‘reservation’; $charset_collate = $wpdb->get_charset_collate(); //SQL Statement $sql = “CREATE TABLE $table ( id mediumint(9) NOT … Read more
Via Velvet Blues Update URLs Plugin You can also use the Velvet Blues Update URLs plugin. After installation, go to Tools> Update URLs. In the Old URL field we enter what we need to change, and in the New URL we enter what we need to substitute. As a result, you can change the permalinks … Read more
I would strongly suggest using AJAX for this purpose. Using “init” for inserting some data to your database is not a good solution. Here’s a good guide on how to do it with AJAX: https://webprogramo.com/how-to-create-an-ajax-form-in-wordpress/1156/
WordPress stores meta and option values in a serialized format if they are objects or arrays. So what you have there is an array (a) with an integer (i) key 0 and a string (s) value with 82 characters.
Recommend a database backup before you do this. ** updated the statement to specify “Y”, empty string, or null ** global $wpdb; $wpdb->query( “update {$wpdb->postmeta} SET meta_value=”X” WHERE meta_key = ‘old_price’ AND ( meta_value=”Y” OR meta_value=”” OR meta_value IS NULL ) );” );
How to add virtual column in wpdb get_result statement
Why is that only the first row getting inserted into Mysql table when i import csv file on backend custom plugin?
Ok I’v created a admin plugin to do this… If you have better idea 🙂 I’m in Create a admin button to open a csv file of meta_value to compare with existing products. and update products as featured if exist. add_action(‘admin_menu’, ‘featured_button_menu’); function featured_button_menu() { add_menu_page(‘Featured Products Page’, ‘Mise en avant produits’, ‘manage_options’, ‘featured-button-slug’, ‘featured_button_admin_page’); … Read more
Update WooCommerce stock status with SQL query if stock value is greater than 0
I found the problem. I had defined variables using the names DB_USER, DB_PASSWORD etc in my own database connection config file. I then found that wordpress already defines variables using these exact same names, which are stored in one of the files in the wp-includes directory. So my own defined variables with the same name … Read more