This is something that creates one common question for all SW engineers. How you can do this “guide the user to select” and also “provide the capability” so the user can add their own data. Well, there is not an easy way to do it. You can try different technics like live searching, recommendation for … Read more
There is some way to import excel to WordPress database. but I have an easy solution to import this file. Go to convertcsv.com and convert your excel file to JSON. Create the below files and folders: Folder: wp-content/plugins/import/ File: wp-content/plugins/import/import.json File: wp-content/plugins/import/import.php Then save JSON file to import.json Put below code in import.php . /* … Read more
wordpress is designed around a database. You need the database to have the site load at all. It wouldn’t be possible to do what you’re asking. What you could do though is go to the internet archive www.archive.org and see if they have a visual representation of your site backed up there and you could … Read more
I found a post on Stack Overflow advising that converting a column from blob to text should result in no data loss. I didn’t really care about data loss since I wanted to remove the plugin data anyway, so I gave it a shot. On the Structure tab in phpMyAdmin, I edited the val column … Read more
The straight answer is “no” and it is also inpossible to have such a thing as code always depends on some DB format, and you can not just change the code without the DB. What happens when you upgrade over several releases will depend on the quality of the plugins and the testings being done … Read more
I would just keep it confined to the WP database. That way you have everything in 1 place. I have several databases which have over 50 tables. I wouldn’t worry about it. In case your site becomes real big you can always move your db to a separate server.
Check your wp-config.php file and look for the table prefix. That should be wp6t_.
You’re must load WP-load function To do that you need to require wp-load file, so if, your custom file is in theme it shoudl look like somethink like that: $wp_load = ‘../../../../../wp-load.php’; if ( file_exists( $wp_load ) ) { require_once( $wp_load ); }else{ die(‘no-load’); } You could also set const SHORTINIT to true to minimalize … Read more
This code is working for me with no “WordPress database error” messages: if ( $wpdb->get_var( $wpdb->prepare( “SHOW TABLES LIKE %s”, $table_name ) ) === $table_name ) { error_log( ‘Table exists’ . ‘: ‘ . print_r( $table_name, true ) ); } else { error_log( ‘Table does not exist’ . ‘: ‘ . print_r( $table_name, true ) … Read more
It appears as though you’re altering the users table – this is a WordPress core table (if using the wp_ prefix) and this is probably not a good idea – create a separate table with an ID foreign key to avoid potential problems. Use $wpdb->prefix to get the prefix that’s actually being used on a … Read more