dongzuan4491 2017-08-25 16:50
浏览 66
已采纳

使用uuid Json的PHP MYSQL链接数组

First of all, I'm happy to see people helping people here :D.

I got also a small issue sadly,

DB 1 contains: UUID and much values.

DB 2 contains: UUID and again many other values.

what I want is

[0] => Array
        (
            [UUID] => 96
            [DB1 values]
            [DB2 values] 
        )

i thought that will work with array_combine but that isn't true sadly because then i miss some db1 values

here database images:

  • 写回答

1条回答 默认 最新

  • dtc4547 2017-08-25 17:00
    关注

    --EDIT-- Your picture helped. You can handle that at the SQL Level

    SELECT Login.*, Location.*
    FROM Login
    LEFT JOIN Location ON Login.UUID=Location.UUID
    GROUP BY Login.UUID
    

    Then the resulting data in PHP will already be correctly formatted. Notice that I chose table Login to drive the query, could have also chosen the Location table. depends on the underlying structure

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 广告联盟的兜底广告是什么意思
  • ¥15 如何证明高斯噪声的包络公式
  • ¥150 寻找王者荣耀开发作者,合作或者解答
  • ¥15 乳腺癌数据集 相关矩阵 特征选择
  • ¥15 我的游戏账号被盗取,请问我该怎么做
  • ¥15 通关usb3.0.push文件,导致usb频繁断连
  • ¥15 有没有能解决微信公众号,只能实时拍照,没有选择相册上传功能,我不懂任何技术,,有没有给我发个软件就能搞定的方法
  • ¥15 Pythontxt文本可视化
  • ¥15 如何基于Ryu环境下使用scapy包进行数据包构造
  • ¥15 springboot国际化