PHP Email Notifications

[dannyp100]

Hey guys, i'm nearly there with this project.

I have created a personal messaging system on my site.

I am creating email notifications to be sent to the users email address when they have been sent a message

 

I need logic on how to do this.

Would the send email notification script be in the confirmation page when a message is sent?

These are the tables in gn_users

Field Type Collation Attributes Null Default Extra Action
userID int(3)   No None AUTO_INCREMENT			
userEmail varchar(40) latin1_swedish_ci  No None			   
userPassword varchar(64) latin1_swedish_ci  No None			   
userSalt varchar(3) latin1_swedish_ci  No None			   
userFirstName varchar(20) latin1_swedish_ci  No None			   
userSurname varchar(20) latin1_swedish_ci  No None			   
userActive char(1) latin1_swedish_ci  Yes Y			   
userType char(1) latin1_swedish_ci  Yes U			   
userLastLogin date   Yes NULL			 
userGender char(1) latin1_swedish_ci  Yes NULL			   
userDOB date   Yes NULL			 
userTown varchar(20) latin1_swedish_ci  Yes NULL			   
userHobby varchar(1000) latin1_swedish_ci  Yes NULL			   
userLinks varchar(1000) latin1_swedish_ci  Yes NULL			   

 

 

 

These are the tables in gn_messages

 

Field Type Collation Attributes Null Default Extra Action
messageID int(3)   No None AUTO_INCREMENT			
messageTo int(3)   No None			 
messageFrom int(3)   No None			 
messageSubject varchar(500) latin1_swedish_ci  No None			   
messageBody varchar(9999) latin1_swedish_ci  No None			   
messageDate text latin1_swedish_ci  No None		    
messageRead enum('0','1') latin1_swedish_ci  No None			 
messageDeleted enum('0','1') latin1_swedish_ci  No None			 
sent_deleted varchar(3) latin1_swedish_ci  No None			   

 

 

any logic, solution or links welcome please!

[timothyarden]

Not entirely sure what you mean, could you please explain what you want a bit better (for example explain how the tables relate to what you want done)

 

Would the send email notification script be in the confirmation page when a message is sent?

Yes, that would work - depends on what you want

[Christian F.]

Send the notification just after you've verified that the data has been successfully saved to the database.

Then redirect the user to the confirmation page.