duan3019 2017-02-23 22:55 采纳率: 100%
浏览 30

PHP MYSQL PDO INSERT加入或如何?

I'm trying to create a messaging system for my site the tables in the Mysql DB looks like this:

PM_HEAD

PM_HEAD_ID (Primary key,AI,INT)
PM_SUBJECT (VARCHAR)
PM_TO (VARCHAR)
PM_FROM (VARCHAR)

.

PM_ROWS

PM_HEAD_ID (INT, FK)
PM_ROWS_ID (INT,Primary key,AI)
PM_MESSAGE (TEXT)
PM_DATE (DATETIME)
PM_FROM (VARCHAR)
PM_TO (VARCHAR)

How do i create my PDO query for inserting on a new message? i've tried a couple of joins, but after reading up on it abit it seems that mysql dont support insert with join?

I need some advice on how i should proceed when a user messages another for the first time, a reply wont be such a hazzle...

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 下图接收小电路,谁知道原理
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度
    • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
    • ¥15 ETLCloud 处理json多层级问题
    • ¥15 matlab中使用gurobi时报错
    • ¥15 这个主板怎么能扩出一两个sata口
    • ¥15 不是,这到底错哪儿了😭
    • ¥15 2020长安杯与连接网探