$counter = sizeof($stats); for ($i = 0; $i <= $counter; $i++) { $statstring = $stats[$i]; $statstemp = explode("\t", $statstring); $statstemp = preg_grep('/^\\s*\\z/', $statstemp, PREG_GREP_INVERT); $statstemp = array_values($statstemp); array_push($statsarray, $statstemp); } $statsarray = array_values(array_filter($statsarray)); echo "<br><br>"; print_r($statsarray); echo "<br><br>"; $counter2 = sizeof($statsarray); for ($i = 0; $i <= $counter2; $i++) { print_r($statsarray[$i]); echo "<br><br>"; } /* $counter = (sizeof($statsarray)); for ($i=0; $i<=$counter; $i++) { for ($t=0; $t<=$counter; $t++) { $statsarray[$i][$t]; echo "<br><br>"; } } */ } gameStatMaker("GameApril172015");
$statsarray = array_values(array_filter($statsarray)); $counter2 = sizeof($statsarray); for ($i = 0; $i <= $counter2; $i++) { print_r($statsarray[$i]); echo "<br><br>"; } for ($i = 0; $i < $counter2; $i++) { $statsarray[$i][0] = "'" . $statsarray[$i][0] . "'"; } //include("connect.php"); for ($i = 1; $i < $counter2; $i++) { $stat_query; $stat_string = ""; $stat_query = implode(",", $statsarray[$i]); echo $stat_query; echo "<br>"; if ($stat_query) { $stat_string .= $stat_query; } echo $stat_query; echo "<br>"; $columns = "`Name`, `Stat1`, `Stat2`, `Stat3`, `Stat4`, \n\t`Stat5`, `Stat6`, `Stat7`, `Stat8`, `Stat9`, `Stat10`, \n\t`Stat11`, `Stat12`, `Stat13`, `Stat14`, `Stat15`, `Stat16`, \n\t`Stat17`, `Stat18`, `Stat19`, `Stat20`, `Stat21`, `Stat22`, \n\t`Stat23`, `Stat24`, `Stat25`"; $query = "INSERT INTO gamestats ({$columns}) VALUES ({$stat_query})"; $result = mysqli_query($connection, $query); } echo "<br><br>"; var_dump($stat_string); //$stats_query = implode(",", $statsarray); } gameStatMaker("GameApril172015.txt");