Hello,
We have a database with the structure :
T_campaign who represent the mailing campaign for our customers,
Here is the structure :
CREATE TABLE IF NOT EXISTS `t_campaign` (
`PK_CAMPAIGN` int(12) unsigned NOT NULL auto_increment,
`FK_USER_ID` int(12) NOT NULL,
`S_NAME` varchar(255) NOT NULL,
`S_SUBJECT` varchar(255) NOT NULL,
…
…
…
…
PRIMARY KEY (`PK_CAMPAIGN`)
)
The job is simple :
The customer is represented by FK_USER_ID, I don’t know the technology on twitter to autopost on it may be by oauth or another thing I don’t know,
You need to create a table with :
T_users_twitter (PK_USER_TWITTER, FK_USER_ID, ……..) who represents the access to the twitter customer.
When a campaign is put on t_campaign you need to twit the S_SUBJECT to the twitter of the customer by cronjob.
We need this technology : [login to view URL]*[login to view URL] like in wordpress to autopost the campaign done on oui email marketing site.
Devellopement in php
Please send me the method you will use and the twitter
Regards,