Its pretty easy. You need to google to read file in PHP and write to database in PHP.
Here I’ll start you off:
$file_handle = fopen("cit.txt", "rb");
while (!feof($file_handle) ) {
$line_of_text = fgets($file_handle);
// write your insert statement here, depending on your table structure.
}
solved How to get this city from .txt and add this to database using PHP? [closed]