dongmao7195 2019-02-16 06:45
浏览 82

使用PHP将CSV导入MySQL,将第一个csv数据作为MySQL列

I have a csv file, that has different payment types in, it is from an EPOS system. Somethimes it doesn't include all the different payment types listed below. It looks like this

Payment type,Payment transactions,Payments amount
Card Payment,6,110.3
Cash,5,59.1
Online Order,2,59.4
Voucher,1,19.5

I am attempting to get the 'Payments amount' into a MYSQL DB via PHP, into a single row with columns which are the 'Payment type' like this

| transaction_id | Card Payment | Cash | Online Order | Voucher |
-----------------------------------------------------------------
| 12-12-19       |   110.30     |59.10 |   59.40      | 19.50   |
-----------------------------------------------------------------

I have got the data into the DB by following the tutorial here but I am having a problem getting the data onto a single line. Could someone point me in the right direction please.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
    • ¥15 C#调用python代码(python带有库)
    • ¥15 矩阵加法的规则是两个矩阵中对应位置的数的绝对值进行加和
    • ¥15 活动选择题。最多可以参加几个项目?
    • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
    • ¥15 vs2019中数据导出问题
    • ¥20 云服务Linux系统TCP-MSS值修改?
    • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)
    • ¥20 怎么在stm32门禁成品上增加查询记录功能
    • ¥15 Source insight编写代码后使用CCS5.2版本import之后,代码跳到注释行里面