SMS Message and Email Message

[veledrom]

Hi,

I need to send a SMS message or/and Email in my database project. Which one is better option for me;

Shall i create database with Oracle or MySQL?

Thanks

[mwasif]

You can create database with either of them. Sending an SMS will cost you but email does not. To send SMS, you need a SMS gatewy like clickatell.com.

[Daedal]

Hi,

I need to send a SMS message or/and Email in my database project. Which one is better option for me;

Shall i create database with Oracle or MySQL?

Thanks

Depending on the SMS messages you are sending, it could be free. If you are sending to cell phone carriers you only need to know their CELL NUMBER and the CELL PHONE CARRIER to determine the appropriate SMS e-mail address.

Use this format:
[10-digit phone number]@cell_provider.com

Alltel
[10-digit phone number]@message.alltel.com
Example: [email][e-mail][/email]

AT&T Wireless (now part of Cingular)
[10-digit phone number]@mmode.com
Example: [email][e-mail][/email]

Boost Mobile
[10-digit phone number]@myboostmobile.com
Example: [email][e-mail][/email]

Cingular
[10-digit phone number]@mobile.mycingular.com OR
[10-digit number]@cingularme.com
Example: [email][e-mail][/email]

Nextel (now part of Sprint Nextel)
[10-digit telephone number]@messaging.nextel.com
Example: [email][e-mail][/email]

Sprint PCS (now Sprint Nextel)
[10-digit phone number]@messaging.sprintpcs.com
Example: [email][e-mail][/email]

T-Mobile
[10-digit phone number]@tmomail.net
Example: [email][e-mail][/email]

Verizon
[10-digit phone number]@vtext.com
Example: [email][e-mail][/email]

Virgin Mobile USA
[10-digit phone number]@vmobl.com
Example: [email][e-mail][/email]

Here is a table for example:

CREATE TABLE `cell_providers` (
  `providerID` mediumint(8) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`providerID`)
) TYPE=MyISAM AUTO_INCREMENT=19 COMMENT='cell providers for fans table' AUTO_INCREMENT=19 ;

-- 
-- Dumping data for table `cell_providers`
-- 

INSERT INTO `cell_providers` (`providerID`, `name`) VALUES (1, 'Only Send Me Email'),
(2, 'Cingular'),
(3, 'Cricket'),
(4, 'Verizon'),
(5, 'Sprint'),
(6, 'T-Mobile US'),
(7, 'T-Mobile UK'),
(8, 'T-Mobile Germany'),
(9, 'Bell Canada'),
(10, 'Rogers Canada'),
(11, 'Telus Canada'),
(12, 'Vodafone UK'),
(13, 'Vodafone Germany'),
(14, 'E-Plus Germany'),
(15, 'Personal Argentina'),
(16, '02 UK'),
(17, 'Orange UK'),
(18, 'Orange France');