如何读取和导入.txt文件到数据库中？
问题描述：
我在我们的网络服务器上有一个.txt文件，该文件被更新并由客户端的第三方属性软件取代。如何读取和导入.txt文件到数据库中？
有没有人有一个脚本（PHP/MySQL的）我可以读取此文件并将其导入到我的数据库中的表中？理想情况下使用codeigniter的东西，但标准的PHP也可以很好地工作。
正是在这样的格式：
"BranchID","PropertyID","PropertyName","Street","DisplayStreet","Postcode","PricePrefix","Price","Bedrooms","Receptions","Bathrooms","ParkingSpaces","Numeric5","Numeric6","Numeric7","Numeric8","Numeric9","AREA","TYPE","FURNISHED","CHILDREN","SMOKING","PETS","GARDEN","DSS","PARKING","cFacility1","cFacility2","cFacility3","cFacility4","cFacility5","cFacility6","cFacility7","cFacility8","cFacility9","cFacility10","Tenure","ShortDescription","MainDescription","AvailabilityCode","AvailabilityDate","FullAddress","PricePrefixPos"
我的字段名称完全匹配，这些头。
是不是说txt一个csv其实呢？ – mishu
是的，相同的格式...但文件是'xfile.txt' – Adam
这并不重要..我正在谈论的格式..如果你把它重命名为.jpg它不会使它成为一张图片..有很多解决方案可以将csv导入数据库（并且您已经有答案），我只是想通过清除此问题，人们会更好地理解 – mishu