If your data is inside database as I understand, it is possible to export your database to CSV file and import this to WordPress. CSV file is basically a comma separated list of data from your database that makes it possible to transfer data from different database structure to another. It does indeed take some … Read more
This doesn’t have anything to do with WordPress or your user’s passwords. What it means is that your MySQL server is still using the old-password-hash mechanism, which was changed in MySQL 4.1. The PHP mysqli client is newer and doesn’t support the old password mechanism. Since this causes an error, WordPress falls back to the … Read more
Note that the $file in register_activation_hook( $file, $callback ), should be equal to path to the main plugin file, but when you have it in a sub file as __FILE__ then it’s not the same! That means your callback is never called. I would also recommend prefixing the function’s name to avoid possible name collision … Read more
You say “However, I know this is not a good way to do this” in your self answer. One thing I could add answering your question and using your answer is, you can use SQL_CALC_FOUND_ROWS with $wpdb $result = $wpdb->get_results( “SELECT SQL_CALC_FOUND_ROWS * FROM `wp_table` WHERE 1 LIMIT 10;” ); $total_count = $wpdb->get_var( “SELECT FOUND_ROWS();” … Read more
Calling image_resize() would be difficult, since it would search for the image in your main blog’s upload directory. If it is a fixed image size I would just add it to the configuration of your photoblog, so it is created there when you upload new images (you can then rebuild your old image thumbnails). In … Read more
WordPress appears to have a built in function called wp_hash_password that will hash the given password and then you can compare it in the db.
Like so: INSERT INTO $mytable (post_id) SELECT ID FROM $wpdb->posts as posts LEFT JOIN $mytable as dup_check ON dup_check.post_id = posts.ID WHERE dup_check.post_id IS NULL;
If you look a bit into the source, you’ll see that $wpdb->insert() will use ->query() under the hood. So should be the same, right? Not that simple. It doesn’t just use ->query() but also ->prepare(), which is considered best practice. Meanwhile with your code example you’ve probably just opened yourself to SQL injections. The takeaway … Read more
Try logging into the mysql instance from the command line by typing in mysql -u root -p and then entering your mysql root password. If you can connect, even if it rejects your username and password, you know it’s up and running correctly. From that point you can diagnose whether it is username/password issues or … Read more
The options are being output within the loop, so are being repeated for each iteration of the loop. To check within the loop and only output something on the first iteration: while ( have_posts() ) : the_post(); if( $wp_query->current_post == 0 ): // this is the first post // output your options endif; // other … Read more