"; // SPLIT BY ROW $rows = explode("\n", $text); // COUNT HOW MANY ROWS $number_of_rows = count($rows); // CONNECT TO DATABASE $dbh = DB::connect("$dbType://$dbUser:$dbPass@$dbHost/$dbName"); // LOOP AS MANY TIMES AS ROWS for ($i=0;$i<$number_of_rows;$i++) { $result_$i = $dbh->query("INSERT INTO $dbTabl (name) VALUES ('$rows[$i]')"); } // DISCONNECT FROM DATABASE $dbh->disconnect(); echo "
Inserted $number_of_rows rows.
"; ?>