所以基本上我想做的是,当我的网站用户在我们的注册页面上创建一个新帐户时,我想要User表(基本信息表,电子邮件,密码等)插入到个人资料"表的新行中(有关我的更多描述性信息,显示名称等)
So basically what I am trying to do is when a user of my site creates a new account on our register page, I'd like the primary key from the newly created row on the User table (basic info table, email, password, etc.) to be inserted into a new row on the Profile table (more descriptive info, about me, display name, etc.)
我想用PHP做到这一点,任何帮助将不胜感激.
I'd like to do this in PHP and any help would be appreciated.
推荐答案如果不是真的需要在php中进行",则可以使用MySQL的内置Trigger机制来进行此更新.
If doing it "in php" isn't really a requirement, then you can use MySQL's built in Trigger mechanism to do this update.
触发器在事件(插入,更新,删除)之后或之前导致某些事情发生
Triggers cause something to happen AFTER or BEFORE an event(INSERT, UPDATE,DELETE)
所以您的触发条件是:
CREATE TRIGGER thistrigger AFTER INSERT ON User FOR EACH ROW UPDATE PROFILE SET "whatever"关于触发器: dev.mysql/doc/refman/5.0/en/create-trigger.html
更多推荐
PHP MySQL外键自动插入
发布评论