There are a number of issues with the user of update_user_meta() in your function. First, you should never write the value directly from $_POST without sanitizing it first. That’s a good way to open yourself up to exploits. (Note: you didn’t indicate the field types, so I’m going to assume they are text input – … Read more
I have one solution global $wpdb; $db= $wpdb->prefix.’booking’; $dbAdditonal= $wpdb->prefix.’booking_additionals’; $booking = $wpdb->get_results(” SELECT b.*, IFNULL(GROUP_CONCAT(ba.NamePack SEPARATOR ‘<br />’),’N/A’) Extras, FORMAT(IFNULL(SUM(ba.Price),0)+IFNULL(b.Price,0),2) AS Total FROM $db b LEFT JOIN $dbAdditonal ba ON b.Id_Booking = ba.Fk_IdBooking GROUP BY Id_Booking “,ARRAY_A);
Sorry to hear you are getting the “Error while sending QUERY packet’ message. The best we can tell, this has to do with the max_allowed_packet_size. This should be able to be set via the php.ini file. You may find more information at this post regarding the issue. Source: Branex
WordPress has the HTTP API that you could perhaps use to send POST (wp_remote_post) or GET (wp_remote_get) requests to an API, https://developer.wordpress.org/plugins/http-api/. But you could also use cURL to send the requests, I think. If the API is developed by you, then it’s up to you to decide what kind of arguments the API accepts/expects … Read more
I think you’ve got the Custom Post Type a bit wrong, the products are not saved in products table but in the posts table prefix_posts(post_id,title,content,… So to use the options in relation to post_id you can use the build-in custom fields which are key/value pairs. The key is the name of the meta-data element. The … Read more
This query will get all the countries and counts in one query: global $wpdb; $countries_count = $wpdb->get_results( ” SELECT meta_value AS country, COUNT(post_id) AS count FROM {$wpdb->postmeta} WHERE meta_key = ‘tgt_job_country’ GROUP BY country ORDER BY country” ); foreach ($countries_count as $country) echo “<li><a href=”http://dsdjjhfgd.net/s=jobseeker&usertype=jobseeker&country=”.$country->country.”&search=Search”>”.$country->country.”(“.$country->count.”)</a></li>”; Unless you need to get the country list first – … Read more
Connecting a mobile app directly to the database is possible, but ill-advised. WordPress provides great tools for integrating your application with your site using the XML-RPC interface. WordPress has open-source Android and iOS applications, so there’s some great source code there to get you started. http://codex.wordpress.org/XML-RPC_WordPress_API http://ios.wordpress.org/development/ http://android.wordpress.org/development/ In addition, the Jetpack plugin provides a … Read more
There is a SQL query in the theme file /themes/ExtraGrid/content-single.php, and it is asking for a column that doesn’t exist. This seems to be a commercial theme, so we can just guess why that query exists. Maybe you forgot to set a required theme option, or your tables are just incomplete.
Well to say that these custom fields are insecure in the wp core tables is to say that the usernames and passwords are also insecure, along with any private or password protected posts. As long as you are not outputting these custom fields anywhere but a secure page for logged in, paid up users, no … Read more
When you work with any type of database it is of UTMOST importance to create regular backups. Once you delete something from a database it is gone forever. This is what they teach in the first class of any database course. Here is a link to a question in DB stackexchange I highly doubt they … Read more