How to setup default value of post_id
How to setup default value of post_id
database
how add more field to wp user and save it to database
You want to use the WordPress function; add_user_meta add_user_meta( $user_id, ‘_level_of_awesomeness’, $awesome_level); https://developer.wordpress.org/reference/functions/add_user_meta/
“BS_” rows in postmeta table
They’re from wordpress.org/plugins/guest-author. The keys suggested they were from a guest author plugin, so I searched Google for guest author plugins, opened the first result, browsed the code, and found that it uses those keys.
I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
I think you’ll have to do a little PHP work and SQL-ing. As you might know, WordPress stores data in a database—and that database has multiple tables, each of which has several fields. You first have to know in what specific field(s) in which specific table(s) that youtube content resides. When you know where it … Read more
local wordpress broke after changing URL
local wordpress broke after changing URL
User input to database
User input to database
How to get inserted row IDs for bulk/batch insert with wpdb query?
As described here: If you insert multiple rows using a single INSERT statement, LAST_INSERT_ID() returns the value generated for the first inserted row only. The reason for this is to make it possible to reproduce easily the same INSERT statement against some other server. So if you need every inserted ID you should use single … Read more
is MariaDB error related to Automatically add new top-level pages
I can’t see how, because the wp_usermeta table contains the metadata about your users. The menu items are stored in the wp_posts table, and the menu options (including the status of the “Automatically add new top-level pages”) is stored in wp_options. I would definitely recommend that you repair the crashed table, though, because it’s likely … Read more
Problems with WordPress multisite directories/url structures and admin access after migration
I don’t know how the migration was executed, but here are some things that have caught me out in the past. Files: Check the .htaccess and wp-config.php files. htaccess for a multisite should look something like this: RewriteEngine On RewriteBase / RewriteRule ^index\.php$ – [L] # add a trailing slash to /wp-admin RewriteRule ^([_0-9a-zA-Z-]+/)?wp-admin$ $1wp-admin/ … Read more
Help with $wpdb on custom code
If the IDuser field is an integer, try: $um_profile_id = um_profile_id(); $fivesdrafts = $wpdb->get_results(“SELECT * FROM wpjk_vuln WHERE IDuser = $um_profile_id”);