Did you try something like this? User variables <?php // Define user ID // Replace NULL with ID of user to be queried $user_id = NULL; // Example: Get ID of current user // $user_id = get_current_user_id(); // Define prefixed user ID $user_acf_prefix = ‘user_’; $user_id_prefixed = $user_acf_prefix . $user_id; ?> Display avatar <?php $avatar … Read more
Escaping a WPDB Object in One Shot
How to store additional data that is related to core data
/*you’re expecting a single row result so better use $wpdb->get_row ..$id I guess it’s numeric so dont’use quote*/ global $wpdb; $download = $wpdb->get_row(“SELECT realname FROM odm_data where id=”.$id); <a href=”https://wordpress.stackexchange.com/questions/308676/download.php?file=<?php echo $download->realname ?>”>Download</a>
In the table, all columns are set with NOT NULL consent. that means they can not be empty at all and considered as required fields. But in the insert query, You are saving only 3 records. $wpdb->insert( $table_name, array( ‘holiday_name’ => $holiday_name, ‘date’ => $date, ‘state’ => $state_form_select, ) ); That’s the issue. Either insert … Read more
I recommend changing the form tag to: This will ensure that the form submits to the same page it is on. Also post_title and post_content are required, so the insert will fail if either of those values are blank or missing. (https://developer.wordpress.org/reference/functions/wp_insert_post/)
You should not use the $errors globally, but use hooks in WordPress development. Since you are new to WP development, I will explain briefly how it works. What you should do instead: make a new hook, or use an existing one which you call at the location you want this error to appear in your … Read more
How to grab data from input and store it into custom table in database?
AJAX is not submitting data to database
While your question isn’t entirely clear on the issue you’re having, I’m guessing that it’s the way that you defined the elements of the array you were trying to insert. You had a mix of commas and semicolons separating the elements. I revised your code to correct that – and to aid readability of your … Read more