Loading 0
Share

My Blog

Scroll Down

Zigaform Export records directly from database

Zigaform Export records directly from database

Heres a simple php script to export records directly from database, as always by Nicolas 😉

<?php $sqlHost = 'localhost'; $sqlUser = 'USERNAME'; $sqlPass = 'PASSWORD'; $database = 'DATABASE'; $conn = new mysqli($sqlHost, $sqlUser, $sqlPass, $database); if($conn->connect_errno){
    printf("Connect failed: %sn", $conn->connect_error);
    exit();
}
$sql = "SELECT `fbh_data_rec_xml` FROM `fbcf_uiform_form_records`";
$result = mysqli_query($conn, $sql); // First parameter is just return of "mysqli_connect()" function
echo "
";
echo "
<table border='1'>";
while ($row = mysqli_fetch_assoc($result)) { // Important line !!! Check summary get row on array ..
    echo "
<tr>";
    foreach ($row as $field => $value) { // I you want you can right this line like this: foreach($row as $value) {
        echo "
<td>" . $value . "</td>

"; // I just did not use "htmlspecialchars()" function. 
    }
    echo "</tr>

";
}
echo "</table>

";
?>

This post is also available in: Ελληνικά

Leave a Reply

Your email address will not be published. Required fields are marked *

01.

Here you can see all the services I provide

Registration and management of domain names (website address such as www.nicolaslagios.com)

Also management of dns records (e.g. connecting the domain to a specific server, fixing email spam problems, etc.)

Also ssl renewals etc

Installation and management of web & mail server in ubuntu vps with virtualmin, plesk, cpanel

Also studying and fixing server problems.

Necessary condition, the target server meets the conditions

At the moment for new wordpress websites you can choose from ready-made themes and we change the content (no custom changes). You can buy with a fixed price by clicking here!

My team and I undertake any data bridging implementation for Wordpress, Prestashop, Opencart, Joomla platforms.

We can connect data from any source, as long as the structure is stable and there is proper documentation and briefing.

We undertake the creation, regulation and enrichment of pages for social networks: Facebook, Linkedin, Instagram (profile), Twitter (profile), Tiktok (profile).

We also undertake the first boost of your pages for quick results in followers.

We undertake the repair and maintenance of your existing wordpress website.

For more information about the services, you can read the following and return here to schedule a meeting with me: https://maxservices.gr/en/internet-services/website-services-blank/additional-website-services/