So basically the form saves a large serialized array in the database. Now since you have multiple forms, you need to iterate over the result from get_results, unserialize the column and then access the city key. global $wpdb; $table_name = $wpdb->prefix.’db7_forms’; $results = $wpdb->get_results( “SELECT form_value FROM $table_name WHERE form_post_id = 6062”, OBJECT ); // … Read more
It looks like the problem was the wp-config.php Though not sure what. I copied the content of wp-config-sample.php while keeping the same db credentials and it started working. I then reverted the changes and it is still working… Only differences were: Initially, when replacing the file, the Salts were not set. And hese lines… define( … Read more
In most cases, the database server is not open to remote connections by default, meaning that you can connect to it locally (web server and database server are on the same machine). By default, MySQL is binding to the localhost or 127.0.0.1. Here is one tutorial on how to grant remote access to specific IP … Read more
Yes, you can use wpdb to delete the record in the custom table. Something like this in the wordpress function. require_once (‘../../../../wp-load.php’); if (!empty($_POST[‘id’])) { global $wpdb; $table=”table_name”; $id = $_POST[‘id’]; $wpdb->delete( $table, array( ‘id’ => $id ) ); }
It returns 10, because that is usually the default specified at your site “read” settings (IIRC) and is used obviously explicitly for the front end, but also as default for the number of posts returned by wp_query. What you are looking for is the number_of_posts (don’t trust me, check the docs) argument for the query. … Read more
A diamond question mark is browser for “I can’t decode that.” I would assume what is happening is when you migrated the HTML entity for space was encoded in your database wrong or WordPress is reading it with the wrong encoding assumed.
You’ll have to make the variable global when you define it, e.g. global $mydb; $mydb = new wpdb(‘username’,’password’,’database’,’localhost’); and then use global $mydb; in the other plugins. Aside from theme files, functions.php, and plugins while being loaded, pretty much nothing in WP runs in global context, so if you need to access global variables, you’ll … Read more
First off please note that although you plan to use different themes and plugins, your core content is identical, so search engines can and will figure out that all of these sites contain the same content. So if you proceed, just know that you won’t be bringing in much if any organic traffic. Perhaps there … Read more
You could use the MONTHNAME(dato) on your select Like $rows = $wpdb->get_results( “SELECT MONTHNAME(dato) as month_name, avg(fiske_vaegt) as fiske_vaegt FROM `wp_registreringer` WHERE MONTH(dato) = 11 AND YEAR(dato) = 2017;”); and access it like this echo $row->month_name
I found the solution. The result 1 for my query means true and it’s a boolean so $wpdb->query can return true, not only int|false as it is written above the public function query : wpdb::query PHP code $res = $wpdb->query(“ALTER TABLE ” . $table_name. ” ADD ” . $column_name . ” varchar(35)”); error_log( $res ); … Read more