[Cerrado] Cred Form Does Not Save Value Into Database
This support ticket is created hace 7 años, 6 meses. There's a good chance that you are reading advice that it now obsolete.
This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.
I setup post fields group called "Average Ratings and Total Reviews" and create two number fields one is called "Ratings Average" with slug ratings-average and another called "Reviews Total" with slug reviews-total. I attached these fields to Restaurant CPT which is a parent of Review.
Under Review CPT I created Radio fields from 0-5 for ratings called Overall Ratings with slug overall-ratings.
Then I create rating form with Overall Ratings radio so it generated ID=831
I follow the reference thread and have my code in my function as follow
I went ahead testing the review. The review title and review description go through but the form did not saved/pass data to Ratings Average and Reviews Total.
Generic fields does not give option to add class inside input tag and label tag that I need to style on star rating using pure css star rating. hidden link
This method of getting average ratings and total reviews is better than calculate it on the fly that was previously.
I managed to save overall rating from the radio inputs by adding this code below.
if (isset($_POST['wpcf-overall-ratings']))
{
// add it to saved post meta
add_post_meta($post_id, 'wpcf-overall-ratings', $_POST['wpcf-overall-ratings']);
}
However, the wpcf-ratings-average and wpcf-reviews-total does pass data and saved in the database.
Here is my new code:
//*Update Avg Ratings and Total # of Ratings after review submission
function update_post_ratings($post_id, $form_data)
{
// if a specific form, change ID to the CRED "Review" ID
if ($form_data['id']==831)
{
//save overall ratings to database
if (isset($_POST['wpcf-overall-ratings']))
{
// add it to saved post meta
add_post_meta($post_id, 'wpcf-overall-ratings', $_POST['wpcf-overall-ratings']);
}
//Get ID of Post Being Reviewed
$current_post_id = $form_data["container_id"];
$post = get_post( $current_post_id );
$args = array(
'posts_per_page' => -1,
'post_type' => 'review',
'meta_key' => '_wpcf_belongs_' . $post->post_type . '_id',
'meta_value' => $post->ID,
);
$child_posts = get_posts($args);
$sum = 0;
$num = 0;
foreach ($child_posts as $child_post) {
$ratings = get_post_meta($child_post->ID, 'wpcf-overall-ratings', true);
if($ratings)
{
$sum += $ratings;
$num ++;
}
}
$average = 0;
if($num>0)
{
$average = $sum/$num;
}
$res = $average;
if($average==0) $res = 0;
if($average>0.001 && $average<0.5)$res = 0.5;
if($average>0.501 && $average<1) $res = 1;
if($average>1.001 && $average<1.5) $res = 1.5;
if($average>1.501 && $average<2) $res = 2;
if($average>2.001 && $average<2.5) $res = 2.5;
if($average>2.501 && $average<3) $res = 3;
if($average>3.001 && $average<3.5) $res = 3.5;
if($average>3.501 && $average<4) $res = 4;
if($average>4.001 && $average<4.5) $res = 4.5;
if($average>4.501 && $average<5) $res = 5;
update_post_meta( $current_post_id, 'wpcf-ratings-average', $res );
update_post_meta( $current_post_id, 'wpcf-reviews-total', $num );
}
}
add_action('cred_save_data', 'update_post_ratings',10,2);
So the field is actually in the payload so the problem is the hook.
Can you just try a simple hook like this and let me know if it populates.
//*Update Avg Ratings and Total # of Ratings after review submission
function update_post_ratings($post_id, $form_data)
{
// if a specific form, change ID to the CRED "Review" ID
if ($form_data['id']==831)
{
//save overall ratings to database
if (isset($_POST['wpcf-overall-ratings']))
{
// add it to saved post meta
add_post_meta($post_id, 'wpcf-overall-ratings', $_POST['wpcf-overall-ratings']);
}
}
add_action('cred_save_data', 'update_post_ratings',10,2);
The reason why I want you to try just this section is to ensure that the function actually works.
Add it to your functions.php file
//*Update Avg Ratings and Total # of Ratings after review submission
function update_post_ratings($post_id, $form_data)
{
// if a specific form, change ID to the CRED "Review" ID
if ($form_data['id']==831)
{
//save overall ratings to database
if (isset($_POST['wpcf-overall-ratings']))
{
// add it to saved post meta
add_post_meta($post_id, 'wpcf-overall-ratings', $_POST['wpcf-overall-ratings']);
}
}
add_action('cred_save_data', 'update_post_ratings',10,2);
As it stands now this function should populate the overall-ratings field with the rating value. I want to see if this is being successfully saved to the database like this.
Yes, with this code provided does saved wpcf-overall-ratings to database. When form submitted it saved that value.
Now, what can we do next to use the codes above to calculate ratings average and reviews total then pass that data to custom fields wpcf-ratings-average and wpcf-reviews-total so that we can display average rating and total reviews at front-end.
I think the problem lies in getting the id of the parent post. You might want to doublecheck that the slug of your restaurants post type is "restaurants" and not the singular, "restaurant". Also the same for your reviews post type!
Since it's outputting the parent post ID in the url, you could probably just use a GET:
//Get ID of Post Being Reviewed
$parent_post = $_GET['parent_restaurants_id'];
$post = get_post( $parent_post );
$args = array(
'posts_per_page' => -1,
'post_type' => 'review',
'meta_key' => '_wpcf_belongs_' . $post->post_type . '_id',
'meta_value' => $post->ID,
);
