Advertisement
Guest User

temporary solution

a guest
Dec 27th, 2020
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. // retrieving submissions
  2. $post_id = $wpdb->get_results("SELECT post_id FROM " . $wpdb->prefix . "postmeta WHERE meta_key = '_form_id' and meta_value = 2");
  3. foreach ($post_id as $value) {
  4. $printf .= "<tr>";
  5. $sql = "SELECT meta_key, meta_value FROM " . $wpdb->prefix . "postmeta WHERE post_id = " . $value->post_id . " AND meta_key LIKE '_field_%'";
  6. $results = $wpdb->get_results($sql);
  7. $data = array(
  8. '1' => '',
  9. '2' => '',
  10. '3' => '',
  11. '4' => '',
  12. );
  13. foreach($results as $print){
  14. if($print->meta_key == '_field_11')
  15. $data['1'] = $print->meta_value;
  16. if($print->meta_key == '_field_30')
  17. $data['2'] = $print->meta_value;
  18. if($print->meta_key == '_field_12')
  19. $data['3'] = $print->meta_value;
  20. if($print->meta_key == '_field_8')
  21. $data['4'] = $print->meta_value;
  22. }
  23. foreach ($data as $print) {
  24. $printf .= "<td width='25%'>$print</td>";
  25. }
  26. $printf .= "</tr>";
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement