如何从.txt获取这个城市并使用PHP将其添加到数据库? [关闭]
问题描述:
city.txt
City
City1
City2
City3
City4
City One
City Other
How to get this city from .txt and add this to database using PHP?
city.txt p>
City
City1
City2
City3
City4
City One
City Other
code> pre>
如何从.txt获取此城市并使用PHP将其添加到数据库? p>
div >
答
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.
}
答
Or try:
$file = file_get_contents("city.txt");
$cities = explode("
", $file);
foreach ($cities as $city) {
$SQL = "INSERT INTO table_name (city) VALUES ('$city')";
//now execute the SQL statement
}