Import csv file

[kev1n]

There are syntax errors in import.php (use https://phpcodechecker.com/ to check for errors).

I think it should be like this:

Code: Select all

<?php
//import.php
if (isset($_POST["customerName"])) {
    $connect = new PDO("mysql:host=localhost;dbname=nubuilder4", "root", "");
    $customerName = $_POST["customerName"];
    $customerPhone = $_POST["customerPhone"];
    $customerEmail = $_POST["customerEmail"];
    $customerAddress = $_POST["customerAddress"];
    $appointmentDate = $_POST["appointmentDate"];

    for ($count = 0;$count < count($customerName);$count++) {
        $query .= "
  INSERT INTO tbl_Customers(customerName, customerPhone, customerEmail, customerAddress, appointmentDate)
  VALUES ('" . $customerName[$count] . "', '" . $customerPhone[$count] . "', '" . $ccustomerEmail[$count] . "', '" . $customerAddress[$count] . "', '" . $appointmentDate[$count] . "');

  ";
    }
    $statement = $connect->prepare($query);
    $statement->execute();
}

?>

[hiramalik]

You are a saviour..
Thank you sooooo much

[hiramalik]

Here again with another issue. Now that everything else works fine, file is being imported thrice. For example if I have imported 3 rows. Each row will be imported thrice making total of 9 rows. Please help..

[kev1n]

Replace this line:

Code: Select all

 $(document).on('click', '#import_data', function(){

with this:

Code: Select all

 $(document).off('click', '#import_data').on('click', '#import_data', function(){

[hiramalik]

Thanks Kev1n

[admin]

There is now a simple CSV Import/Export available in nuBuilder Forte.

https://forums.nubuilder.cloud/viewtopic.php?f=18&t=10583


Steven

[kev1n]

Cool - it's a nice addition!

[admin]

Thanks.

I used some of your code.


Steven