Ниже вы можете увидеть мою форму, на этой странице вы загружаете xml-файл.
<html> <body> <form enctype="multipart/form-data" action="arrayincludefiletest.php" method="POST"> <input type="hidden" name="MAX_FILE_SIZE" value="2000000" /> <table width="600"> <tr> <td>File name:</td> <td><input type="file" name="file" /></td> <td><input type="submit" value="Upload" /></td> </tr> </table> </form> </body> </html> Ниже вы можете увидеть мой PHP-код, если вы посмотрите, вы видите, что теперь все ручное. Я должен заполнить массив самостоятельно. Вы также можете увидеть, что я вставляю массив в свою базу данных. Я хочу загрузить xml-файл и что значения файла xml-файла будут помещены в мой массив.
<html> <head> <title> Bom Array </title> </head> <body> <?php $bom= array( array("Aantal" =>1, "Manufactorer" =>"Panasonic", "Partno" =>"EEEFC1H1R0R", "Description" =>"Capacitor 0603","Footprint" =>"CAP0603", "Refdes" =>"B1"), array("Aantal" =>2, "Manufactorer" =>"Vishay", "Partno" =>"MAL215371228E3", "Description" =>"Capacitor 1210","Footprint" =>"CAP1210", "Refdes" =>"C6,C7"), array("Aantal" =>3, "Manufactorer" =>"Ferroxcube", "Partno" =>"MAL215371109E3", "Description" =>"Buzzer 80dB 3,4 KHz","Footprint" =>"KPEG238", "Refdes" =>"C8,C25"), array("Aantal" =>4, "Manufactorer" =>"Philips", "Partno" =>"EEEFC1E101P", "Description" =>"Tantaal 100uF, 6,3V Case_B","Footprint" =>"Case_B", "Refdes" =>"C1") ); echo "<table border='1'>"; echo "<tr> <th>Aantal</th> <th>Manufactorer</th> <th>Partno</th> <th>Description</th> <th>Footprint</th> <th>Refdes</th> </tr>"; echo "<tr> <td>" . $bom[0]['Aantal'] . "</td> <td>" . $bom[0]['Manufactorer'] . "</td> <td>" . $bom[0]['Partno'] . "</td> <td>" . $bom[0]['Description'] . "</td> <td>" . $bom[0]['Footprint'] . "</td> <td>" . $bom[0]['Refdes'] . "</td> </tr>"; echo "<tr> <td>" . $bom[1]['Aantal'] . "</td> <td>" . $bom[1]['Manufactorer'] . "</td> <td>" . $bom[1]['Partno'] . "</td> <td>" . $bom[1]['Description'] . "</td> <td>" . $bom[1]['Footprint'] . "</td> <td>" . $bom[1]['Refdes'] . "</td> </tr>"; echo "<tr> <td>" . $bom[2]['Aantal'] . "</td> <td>" . $bom[2]['Manufactorer'] . "</td> <td>" . $bom[2]['Partno'] . "</td> <td>" . $bom[2]['Description'] . "</td> <td>" . $bom[2]['Footprint'] . "</td> <td>" . $bom[2]['Refdes'] . "</td> </tr>"; echo "<tr> <td>" . $bom[3]['Aantal'] . "</td> <td>" . $bom[3]['Manufactorer'] . "</td> <td>" . $bom[3]['Partno'] . "</td> <td>" . $bom[3]['Description'] . "</td> <td>" . $bom[3]['Footprint'] . "</td> <td>" . $bom[3]['Refdes'] . "</td> </tr>"; echo "</table>"; // Connectie database and Insert into database $con = mysqli_connect("localhost", "csa", "csa", "csa"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL:" . mysqli_connect_error(); } if(is_array($bom)) { $sql= "INSERT INTO bom (Aantal, Manufactorer, Partno, Description, Footprint, Refdes) values"; $valuesArr = array(); foreach ($bom as $row) { $aantal = (int) $row['Aantal']; $manufactorer = mysqli_real_escape_string($con, $row['Manufactorer']); $partno = mysqli_real_escape_string($con, $row['Partno']); $description = mysqli_real_escape_string($con, $row['Description']); $footprint = mysqli_real_escape_string($con, $row['Footprint']); $refdes = mysqli_real_escape_string($con, $row['Refdes']); $valuesArr[] = "('$aantal', '$manufactorer', '$partno', '$description', '$footprint', '$refdes')"; } $sql .= implode(',', $valuesArr); mysqli_query($con, $sql) or die('Error:' . mysqli_errno($con)); } mysqli_close($con); ?> </body> </html>