Your question lacks info, but I think you only need a guidance on how to start. If you want do develop locally, you should install XAMPP, WAMPP or any other program that ’emulates’ a server in your computer. After you do that, you need to configure your database with PhpMyAdmin for example, to create the … Read more
There are many ways to achieve this. You can use a widget and custom widgetareas or print it with a plugin like widget on pages. You can create a page and print the pages content like this. (you can 301 redirect that page to the homepage to disallow users to hit the page directly) You … Read more
Your database contains all your data for each of your sites. Without the databases, your sites will not have any posts, pages, site configuration, users, comments, or settings. If you stand these back up, you will have to create blank databases for each and install WordPress from scratch. You can follow the “Famous 5-minute Installation” … Read more
Short answer: You should use the way described in the documentation, sanitize anything that goes in an SQL query, and always use prepared statements. Slightly longer answer: The main use of $wpdb->prepare() is to prevent against SQL injection attacks. Here, we don’t know where ‘foo’, 1337 and ‘%bar’ come from. And that’s somewhat the deciding … Read more
I’m guessing that your WordPress Address URL or your Site URL (both under Settings> General) are incorrect. You can find them in your database in the options table option_name siteurlor home. You might have overwritten the original settings while importing your database from a local server or something.
You can try use: MySQL WorkBench or other MySQL Client program; SSH to the Server and connect from the command prompt; Use PHPMyAdmin (make sure to password protect and set the right configuration); If you are really in need of an extra level of security you may want to consider setting up a VPN between … Read more
Personaly I would go with one table for all users. Having more tables with the same columns seems like a strange idea to me. The database will be a complete mess after you gwt more users. Make sure that the user_id is an index for the table and all your select/update/delete will be fine. The … Read more
You can’t “delete” a field in MySQL, this only works for complete rows. However, you can unset values, meaning setting them to their original state, usually NULL or an empty string. $wpdb->update($wpdb->posts, array( ‘product_rank’ => NULL ), array( ‘ID’ => $post_id ));
This is probably what you want: update wp_users set user_email = lower(user_email) where user_email is not null; However I’m surprised you need this: WordPress’s default collation is case-insensitive.
To update a new option name each time you need something unique to be used as option name so may be using ‘time’ in the option name $now = new DateTime(); $mytime = $now->format(‘Y-m-d H:i:s’); // MySQL datetime format // $now->getTimestamp(); // Unix Timestamp $option[‘prefix-‘.$mytime] = ‘your value’; Then you can update as you wish. … Read more