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 do that accessing the phpmyadmin dashboard of your host, but that is no the right way to do it, i recommend you to research and learn about: Custom Post Types Custom Taxonomies
Try to edit your wp-config.php and add the lines: define(‘WP_SITEURL’, ‘http://example.com/’); define(‘WP_HOME’, ‘http://example.com/’); with https or http.
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 ));
If your entire page fits in the 4GB LONGTEXT post content field, the limit to the number of pages would be related to the amount of RAM available on your server. When a multipage post is loaded, it is exploded on <!–nextpage–> to put your post into an array of individual pages, so at that … Read more
No, it is not safe to resize columns in WP core tables, or to alter them. When you next update WordPress, the update process will alter the tables to the official table schema, truncating all your GUIDs and breaking them. Instead, you need to contact the support route for the plugin so that they can … Read more
First Never modify the database options directly. Instead, to deactivate all of your plugins, FTP to your site and rename the /plugins directory as /plugins-1 or something along those lines. WordPress will automatically deactivate them the next time you try to load the site, then you can change the name back to /plugins. Troubleshooting There … Read more
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
have_posts() needs a WordPress database query before it will show anything, check it here like this: $the_query = new WP_Query( ‘post_type=post’ ); if ( $the_query->have_posts() ) { echo ‘<ul>’; while ( $the_query->have_posts() ) { $the_query->the_post(); echo ‘<li>’ . get_the_title() . ‘</li>’; } echo ‘</ul>’; } else { // no posts found } it will display … Read more
If you want to output the $id, you need to echo. Also be sure to use esc_attr() as a good security practice. <input type=”hidden” name=”id” value=”[insert_php]echo esc_attr( $id );[/insert_php]”> In addition, as was noted in another answer, you’re calling it an ‘id’, but you’re actually using the login (username). If all you need is the … Read more