ferda2

Thank you for answer. I need to display the data from the form in real time. In the administration (Advanced CF7 DB), the data is rendered nicely. I need the same for display on a separate page. There must be some solution ??

I see an overview of forms (data) in the administration. I am using Advanced CF7 DB.

I use Contact Form 7 + Advanced CF7 DB, I need to extract the data separately (on the WP page).

Unfortunately, this script does not work. My experiment:

PHP

global $wpdb;
$results = $wpdb->get_col("SELECT value FROM wp_cf7_vdata_entry WHERE name = 'psc'");
foreach ( $results as &$result ) {
	$result = '"' . $result . '"';
}
$formatted_results = implode( ',', $results );
$_SESSION["psc"] = $formatted_results;

Javascript

var addressArray = new Array('<?php echo $_SESSION["psc"]; ?>') // Console output: Array [ "\"590 06\",\"301 00\",\"691 41\",\"602 00\",\"350 66\",\"590 06\"" ]
var addressArray = addressArray.join(" and "); // Console output: "590 06","301 00","691 41","602 00","350 66","590 06"

It’s very difficult for me. I only control HTML and CSS (at least PHP). Can we arrange processing (for money)? I need to create a map (Google – Marker Clustering) from the Contact Form 7 data (postal code only). In Drupal it works well, there is a plugin Leaflet Markercluster. WordPress does not offer anything like this.

My goal is to create a map according to https://developers.google.com/maps/documentation/javascript/marker-clustering, but I only have postcode from Contact Form 7.

Great, thank you! Please advise how to paste the result into javascript? My code (PHP):

$_SESSION["psc"] = $formatted_results;

Javascript:

...
var addressArray = new Array("150 00","602 00","709 00"); // TEST only - working (fixed definition)
var addressArray = new Array('<?php echo $_SESSION["psc"]; ?>') // show only 602 00 marker
var geocoder = new google.maps.Geocoder();
...

Conn is:
$conn = new mysqli($servername, $username, $password, $dbname);
Now I have the result in the format 150 00,602 00,709 00. I need the result in the format “150 00″,”602 00″,”709 00” (quotes around the numbers) for further use.

This is the Advanced CF7 DB Advanced Table (s). The Name column contains all field data. From the name column, I need to get the values of the city (city) and psc (zip) fields. It works, but I need to list “Prague 110 00”, “Brno 620 00”, etc. Thanks for your help.

Not usable …