php-export csv函数为每个条目重复标题

g6baxovj  于 2021-06-18  发布在  Mysql
关注(0)|答案(1)|浏览(275)

我们正在创建一个将数据从表导出到csv的函数。但是,代码似乎重复了我们为csv中插入的每一行设置的标题,因此它最终看起来是这样的:
csv数据(红线是被屏蔽的数据,但您可以看到每行的标题是如何重复的)
下面是我们创建导出的代码:

//inserts data into import table
$sql = "INSERT into import (suid, studentName, studentEmail, studentAffiliation, studentProgram, studentEduLevel) values ('$suid', '$studentName', '$studentEmail', '$studentAffiliation', '$studentProgram', '$studentEduLevel')";
if (!$fail) {

    if (mysqli_multi_query($csvDatabase, $sql)) {
            //once imported properly, export csv

        $query = "SELECT suid, studentName, studentEmail, studentAffiliation, studentProgram, studentEduLevel from import ORDER BY id DESC LIMIT {$successCount}";  
          $result = mysqli_query($csvDatabase, $query); 
                if ($result->num_rows > 0) {
                  header('Content-Type: text/csv; charset=utf-8');  
                  header('Content-Disposition: attachment; filename=data-export.csv'); 
                    $output = fopen("php://output", "w"); 
                    $headers = array('SUID', 'Student Name', 'Student Email', 'Student Affiliation', 'studentProgram', 'Student Edu Level');
                    fputcsv($output, $headers); 
                     while($row = mysqli_fetch_assoc($result))  
                  {  
                         fputcsv($output, $row);
                  }  
                  fclose($output); 
                    //then delete records in database
                $deletesql = "DELETE FROM import ORDER BY id DESC LIMIT {$successCount}";
                    if (mysqli_query($csvDatabase, $deletesql)) {
                        //echo "Record deleted successfully";
                    } else {
                        echo "Error deleting record: " . mysqli_error($csvDatabase);
                    }

        }

    } else {
        echo "Error: " . $sql . "<br>" . mysqli_error($csvDatabase);
    }
 }

有什么想法可以在代码中发生重复的标题?
编辑:省略服务器信息的完整代码:

<?php
require_once('connection.php');

$successCount = 0;

if(isset($_POST['submit'])){

$filename = $_FILES["file"]["tmp_name"];
if($_FILES["file"]["size"] > 0) {
for($i=0; $i<count($filename); $i++) {
    $file = $filename[$i];
    //open file in read only
    $files = fopen($file, "r");
    //skips first line
    fgets($files); 
    //get data from csv & uses comma to find separate values
        while (($getData = fgetcsv($files, 0, ",")) !== FALSE)
         {
            $fail = FALSE;
            //store SUID from 2nd line in csv
            $suid = $getData[0];
            if (strlen($suid) === 9 && ctype_digit($suid) ) {
            // start ldap look up
            $server="***";
            $basedn="***";

            //Connect to server
            $ds=ldap_connect($server);

            if ($ds) {
                //bind with our special account that retrieves more attributes
                $ldaprdn  = '***';     // ldap rdn or dn
                $ldappass = '***';  // associated password
                $r=ldap_bind($ds,$ldaprdn,$ldappass);    // this is an authenticated bind
                if (substr($suid, 0, 1) === ";" || is_numeric($suid)) {
                        if ($r) {
                            //filter to all objectclasses that the SUID we are looking for
                            $filter = "(&(objectClass=*)(syrEduSUID={$suid}))";

                            //We are only interested in retrieving these attributes
                            $justthese = array("displayName", "syrEduLevel", "syrEduProgramDesc", "syrEduProgram", "mail", "eduPersonPrimaryAffiliation", "eduPersonAffiliation" );

                            // Search SUID
                            $sr=ldap_search($ds, $basedn, $filter, $justthese );
                            //Need to test if the search succeeded. FALSE value means it failed
                            //if ($sr!==FALSE) {
                                //Search found something. Now return Attributes and their values - note, there can be multiple values per attribute. We need to make sure the search only returned one result

                                $entry = ldap_get_entries($ds, $sr);
                                // if we have only one result, return the values, if not, we have a problem

                                if ($entry["count"] == 1) {
                                // get student name and email from suid

                                $studentName = mysqli_real_escape_string($csvDatabase, $entry[0]['displayname'][0]);
                                $studentEmail = mysqli_real_escape_string($csvDatabase, $entry[0]['mail'][0]);
                                $studentAffiliation = mysqli_real_escape_string($csvDatabase, $entry[0]['edupersonprimaryaffiliation'][0]);
                                $studentProgram = mysqli_real_escape_string($csvDatabase, $entry[0]['syreduprogramdesc'][0]);
                                $studentEduLevel = mysqli_real_escape_string($csvDatabase, $entry[0]['syredulevel'][0]);

                                    $successCount++;

                                // close ldap
                                ldap_close($ds);

                                } else {
                                    $msg  = "Ldap search returned 0 or more than one result";
                                    $fail = TRUE;
                                }

                        //} else {
                        //    $msg  = "Search failed";
                        //    $fail = TRUE;
                        //}
                    }
                } else {
                    $msg  = "Bind failed";
                    $fail = TRUE;
                }
            } else {
                $msg  = "LDAP connection failed";
                $fail = TRUE;
            }

                        //inserts data into import table
                        $sql = "INSERT into import (suid, studentName, studentEmail, studentAffiliation, studentProgram, studentEduLevel) values ('$suid', '$studentName', '$studentEmail', '$studentAffiliation', '$studentProgram', '$studentEduLevel')";
                        if (!$fail) {

                            if (mysqli_multi_query($csvDatabase, $sql)) {
                                    //once imported properly, export csv

                                $query = "SELECT suid, studentName, studentEmail, studentAffiliation, studentProgram, studentEduLevel from import ORDER BY id DESC LIMIT {$successCount}";  
                                  $result = mysqli_query($csvDatabase, $query); 
                                        if ($result->num_rows > 0) {
                                          header('Content-Type: text/csv; charset=utf-8');  
                                          header('Content-Disposition: attachment; filename=data-export.csv'); 
                                            $output = fopen("php://output", "w"); 
                                            $headers = array('SUID', 'Student Name', 'Student Email', 'Student Affiliation', 'studentProgram', 'Student Edu Level');
                                            fputcsv($output, $headers); 
                                             while($row = mysqli_fetch_assoc($result))  
                                          {  
                                                 fputcsv($output, $row);
                                          }  
                                          fclose($output); 
                                            //then delete records in database
                                        $deletesql = "DELETE FROM import ORDER BY id DESC LIMIT {$successCount}";
                                            if (mysqli_query($csvDatabase, $deletesql)) {
                                                //echo "Record deleted successfully";
                                            } else {
                                                echo "Error deleting record: " . mysqli_error($csvDatabase);
                                            }

                                }

                            } else {
                                echo "Error: " . $sql . "<br>" . mysqli_error($csvDatabase);
                            }
                         }
                }
        }

    //closes file    
    fclose($files); 
     }
} else {
    echo "You did not upload a CSV file or the CSV file is blank.";
}
} else {
?>
hec6srdp

hec6srdp1#

正如idontdownvote所指出的,代码被放在每个文件循环中。一旦取出并放置在fclose($files)之后,它就不会重复标题。

相关问题