I have a plugin which creates a new database table. Upon activating the plugin is there a way to insert all my posts ids into that table? Right now I’m using an action hook to immediately insert the id of new posts I publish. function transfer_post_id($post_ID) { global $wpdb; if (!($wpdb->get_row(“SELECT post_id FROM $my_table WHERE … Read more
I am using custom php code to perform data insertion, deletion, updating and other tasks. I am able to insert data into a table in two different ways, $wpdb->insert($table_name, array(‘id’ => NULL, ‘name’ => ‘$name’, ’email’ => ‘$email’, ‘city’ => ‘$city’)); and $sql = “INSERT INTO $table_name VALUES(”, ‘$name’, ‘$email’, ‘$city’)”; $wpdb->query($sql); Is it a … Read more
How to restore one of my MySQL databases from .myd, .myi, .frm files? 11 Answers 11
Error message on MySql: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’ I have gone through several other posts and was not able to solve this problem. The part affected is something similar to this: CREATE TABLE users ( userID INT UNSIGNED NOT NULL AUTO_INCREMENT, firstName VARCHAR(24) NOT NULL, lastName VARCHAR(24) NOT NULL, … Read more
I’m looking to be able to run a single query on a remote server in a scripted task. For example, intuitively, I would imagine it would go something like: mysql -uroot -p -hslavedb.mydomain.com mydb_production “select * from users;” 7 Answers 7
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for … Read more
I’ve got a working PHP script that gets Longitude and Latitude values and then inputs them into a MySQL query. I’d like to make it solely MySQL. Here’s my current PHP Code: if ($distance != “Any” && $customer_zip != “”) { //get the great circle distance //get the origin zip code info $zip_sql = “SELECT … Read more
It seems that I may have inadvertently loaded the password validation plugin in MySQL 5.7. This plugin seems to force all passwords to comply to certain rules. I would like to turn this off. I’ve tried changing the validate_password_length variable as suggested here to no avail. mysql> SET GLOBAL validate_password_length=4; Query OK, 0 rows affected … Read more
Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for WordPress Development Stack Exchange. Closed 10 years ago. Improve this question I am trying to create a wordpress blog on an Amazon EC2 instance. The amazon base image had apache and php … Read more
I tried to strip down the Twenty Eleven theme options page and add my own fields correction: I followed a tutorial somewhere, but when I try to echo the data, it comes out multiple times. Here is my theme-options.php: http://pastebin.com/HSZM56jA This is how I am echoing it: <?php $options = get_option(‘gavsiu_theme_options’); echo $options[‘message-primary’]; echo $options[‘message-secondary’]; … Read more
