database

Insert NULL value using prepare()

the quick solution I found is to str_replace empty value. /* Query */ global $wpdb; $tablename = $wpdb->prefix . ‘data’; $sql = $wpdb->prepare( ” UPDATE $tablename SET `date` = %s, WHERE id= %d “, $_POST[‘date’], $_POST[‘id’] ); // SQL = UPDATE prefix_data SET `date` = ” WHERE id = 1 $sql = str_replace(“””,’NULL’, $sql); // … Read more

Performing CRUD operations on front end in wordpress

Yes. You can do. Try using ajax, or better? using wordpress rest api Ajax method: need register your function and action to do Simple example: add_action( ‘wp_ajax_my_action’, ‘my_action’ ); add_action( ‘wp_ajax_nopriv_my_action’, ‘my_action’ ); function my_action() { return json_encode(‘hello word’); } jQuery(document).ready(function() { var data = { ‘action’: ‘my_action’ }; jQuery.post(ajax_url, data, function(response) { alert(response); }); … Read more

+ More