Insert Data Value

[Alidad]

Hi, I'm rookie in php and i tried to figure out myself how to write that code.

 

A new member signup as new member and send data value to mysql database name 'temp_member' table aand then admin will need for approval.

 

if admin approve this is just press button to transfer data value from 'temp_member' table to other table name 'per_member'.

 

my question is that how can i write that code to transfer profile information from table to other table like from 'temp_member' to 'per_member'.

 

please help thanks.

 

AM

[ManiacDan]

INSERT INTO PER_MEMBER ( SELECT * FROM TEMP_MEMBER WHERE MEMBER_ID = 123 );

 

Also, this is not PHP in any way.

[Christian F.]

Another option you have, is to add a enum "status" field to the members table. Then you can set it to a value (let's say 'pending') to denote whether or not a member is pending approval. Once approval is given, you can set it to something else (for example 'member').

By using an enum you have a limited set of values, all which can be referenced via plain text or their index. You can also extend this set, in case you want to add more user-levels in the future.

[jcbones]

Christian's way is how I always handle this situation. I will vote it up on that basis.

[ManiacDan]

Depends on how many people will be rejected and how you want to handle that.  If a very small percentage will be in "rejected" or "pending" state, then the enum is a good idea.  If a large number, a separate table may be faster.