You should not change anything in the DB structure of wordpress as this is essentially the same as hacking the core. You should simply write your own json end points which provide you with the relevant info.
Ordering topics by most replies in X days using MYSQL statement
Oh dear, that was extremely obvious – there was a missing closing bracket! Here is the working query. SELECT ID, ( 6371 * acos ( cos ( radians( 35.665833 ) ) * cos( radians( latitude.meta_value ) ) * cos( radians( longitude.meta_value ) – radians( 139.731111 ) ) + sin ( radians(35.665833 ) ) * sin( … Read more
I had a similar issue on a website with ~100k rows in wp_posts and ~500k in wp_postmeta. Truth is WordPress have some really slow queries in the admin when you start to have a lot of posts. The best way to find the bottleneck is to use the Debug Bar plugin. You will probably find … Read more
Store id from database query in cookie
Not sure if this is the case in dreamhost, but in most hosts, you need to “attach” or “assign” the db user to the db in cpanel. If you ahve not done this, you will get the error you describe. http://www.wpwhitesecurity.com/wordpress-tutorial/wordpress-database-cpanel/
You do not need to use quotes around some data types in SQL, integers being one of those types. That is why the first block of code works. It is a perfectly valid SQL statement. You do need to quote strings in SQL. That is why your second block of code does not work. The … Read more
Syntax The issue with your WordPress approach is the get_var calls used to get the subscriber id and interest name. get_var is intended to get just a variable from the database like the number of rows in the table or sum of a numeric column in the table, see the WordPress Codex What your looking … Read more
I solve it. public function insertionRow($id){ global $wpdb; $wpdb->query(“INSERT INTO wp_choix_attributs_liste (att_id) VALUES (“.$id.”);”); } In my html with the checkbox. if(isset($_POST[‘sub’])) { foreach ($_POST[‘choixP’] as $id) { self::insertionRow($id); } }
get_the_terms is not working