function add_students_from_csv($files) { $filename = ""; //print_r($files); $filename = $files["file"]["tmp_name"]; //print_r($files); $options['delimiter'] = ","; //echo tableFromCsv($files["file"]["name"], true, $options); //echo "<pre>"; $result = extractCsv($filename, true, $options); // echo"<pre>";print_r($result); // echo "iambatman . $result"; // print_r($result); $ids = array_column($result, "ID #"); //echo "<pre>";print_r($ids); $keys = array_keys($result[0]); $check_keys = array_slice($keys, 0, 6); //echo "<pre>";print_r($check_keys); $format_key = array("ID #", "Last", "First", "Advisor", "Start SEM.", "Option"); // echo "<pre>";print_r($format_key); //echo "value".($check_keys === $format_key); if ($check_keys === $format_key) { //echo "iambatman"; $students = array(); $counter = 0; // echo"<pre>";print_r($ids); for ($i = 0; $i < sizeof($ids); $i++) { $check = studentid_validation($ids[$i]); if ($check == "false") { // echo "<br>".$ids[$i]; $students[$counter][$i] = $ids[$i]; $counter++; } // echo $i." ".$ids[$i]."<br>"; } if ($counter > 0) { // echo"<pre>";print_r($students); return $students; } else { $keys = array_keys($result[0]); //echo "<pre>";print_r($keys); /*foreach ($result as $i => $values) { //echo "<pre>";print_r($values); add_student($values); }*/ foreach ($result as $i => $values) { add_student($values); for ($i = 6; $i < sizeof($keys); $i++) { //echo $values ['ID #'].$keys[$i];print_r($values[$keys[$i]]);echo "<br>"; add_foundatation($values['ID #'], "GCIS " . $keys[$i], $values[$keys[$i]]); } } return 1; } } else { return 0; } }
<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Tab-separated Values</title> <link rel="stylesheet" type="text/css" href="tabs.css"> </head> <body> <?php include '../includes/csv_functions.php'; $cars = extractCsv('cars_tab.csv', 0, "\t"); ?> <table> <tr> <th>Make</th> <th>Year</th> <th>Price</th> <th>Mileage</th> <th>Description</th> </tr> <?php foreach ($cars as $car) { ?> <tr> <td><?php echo $car['make']; ?> </td> <td><?php echo $car['yearmade']; ?>
</td> <td> <?php echo $row['credit hours']; ?> </td> </tr> <?php } ?> </table> <?php } else { echo '<p><em>Curriculum for semester 1 not available.</em></p>'; } if ($table2 = extractCsv('../_assets/second_semester.csv')) { ?> <table> <tr> <th>Second Semester</th> <th>Credit Hours</th> </tr> <?php foreach ($table2 as $row) { ?> <tr> <td> <?php $space = strpos($row['Second Semester'], ' '); echo '<strong>' . substr_replace($row['Second Semester'], '</strong>', $space, 0); ?>
?> ?> <?php $studentdata = array(); if (isset($_FILES["file"])) { $semester = $_POST['semester']; $year = $_POST['year']; $result = file_check($_FILES); if ($result == "success") { $dbc = dbConnect('local'); $filename = ""; $filename = $_FILES["file"]["name"]; // print_r($_FILES); $options['delimiter'] = ","; // echo tableFromCsv($filename, true, $options); $result = extractCsv($filename, true, $options); echo "<pre> batman"; print_r($result); $keys = array_keys($result[0]); $loop = sizeof($result); $numkey = sizeof($keys); $numofstudent = -1; $numofcourse = -1; $numofgrd = -1; //print_r($keys); //echo "$loop"; for ($i = 0; $i < $loop; $i++) { for ($j = 0; $j < $numkey; $j++) { //echo "<pre>".$keys[$j]." ".$result[$i][$keys[$j]]; if (!empty($result[$i]['ID']) && $keys[$j] == "ID") { $numofstudent++;