<?php global $wpdb; $table_name = $wpdb->prefix . “postmeta”; $login_name = sanitize_user( $_POST[‘parent_id’] ); $prepare = $wpdb->prepare( “SELECT COUNT(*) FROM $table_name WHERE meta_value=”Purva” AND meta_key = ‘parent_id’ “, $login_name ); $myrows = $wpdb->get_results( $prepare ); echo ‘<pre>’ . print_r( $myrows, true ) . ‘</pre>’; ?> I tried this and get values but still something missing…
Your data are possibly corrupt from trying to store multibyte characters that your DB could not correctly represent. MySQL’s utf8 collation isn’t actually UTF-8. You will have to convert your tables’ character sets to utf8mb4 (real UTF-8), and then set the DB_CHARSET constant to match.
The answer is: of course they are not – otherwise you couldn’t use them to save them in DB. But… the answer to your question isn’t so easy. Sanitizing is a process of preparing data for storing in DB. So for example if you insert some illegal characters in post_name, then it will be removed, … Read more
Try using a different method. WordPress fires a hook during plugin activation activate_yourplugin/filename.php. You can use this to create tables. function creating_order_tables() { if(!get_option(‘tables_created’, false)) { global $wpdb; $ptbd_table_name = $wpdb->prefix . ‘printtextbd_order’; if ($wpdb->get_var(“SHOW TABLES LIKE ‘”. $ptbd_table_name .”‘” ) != $ptbd_table_name ) { $sql=”CREATE TABLE exone( customer_id INT(20) AUTO_INCREMENT, customer_name VARCHAR(255), order_type VARCHAR(255), … Read more
Use the ajax api: http://codex.wordpress.org/AJAX_in_Plugins If you let all your ajax calls go through this you will have access to all WP functions. Also take a look at these: http://www.james-vandyne.com/process-paypal-ipn-requests-through-wordpress/ http://wordpress.org/extend/plugins/paypal-framework/ Don’t know if what you want is in there, but worth a look.
get_query_var(‘paged’) giving same result
I’ve solved the problem myself though it is probably not be the right way to do it. Note that I’ve had to type “website-address” instead of the actual URL because system here won’t let me use more than one URL in a post without more reputation. That makes it quite difficult to convey what’s actually … Read more
wp_update_post() calls some hooks that $wpdb doesn’t on it’s own. You’ll have to do it on your own to make it compatible with other plugins. wp_update_post() calls some functions related to database entry sanitation, thumbnails, attachments, time (format, zone etc.), comment, taxonomy, meta, cache etc. So if you use $wpdb, make sure you handle all … Read more
Can’t save ajax value to database
Custom Plugin Database relations