SMS Message and Email Message

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 330,223 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,987 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

•

FAQ | Community Rules | Welcome Guide

Please support our MySQL advertiser:

Thread Tools Display Modes

Views: 166 | Replies: 2

•

Join Date: Apr 2008

Posts: 33

Reputation: veledrom is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

veledrom

Offline

Light Poster

SMS Message and Email Message

12 Days Ago

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

•

Join Date: Dec 2007

Posts: 77

Reputation: mwasif is an unknown quantity at this point

Rep Power: 1

Solved Threads: 5

mwasif

Offline

Junior Poster in Training

Re: SMS Message and Email Message

9 Days Ago

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.

•

Join Date: Apr 2008

Posts: 14

Reputation: Daedal is an unknown quantity at this point

Rep Power: 1

Solved Threads: 4

Daedal

Offline

Newbie Poster

Re: SMS Message and Email Message

7 Days Ago

•

Originally Posted by 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

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: 2125551212@message.alltel.com

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

Boost Mobile
[10-digit phone number]@myboostmobile.com
Example: 2125551212@myboostmobile.com

Cingular
[10-digit phone number]@mobile.mycingular.com OR
[10-digit number]@cingularme.com
Example: 4152221212@cingularme.com

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

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

T-Mobile
[10-digit phone number]@tmomail.net
Example: 4251234567@tmomail.net

Verizon
[10-digit phone number]@vtext.com
Example: 5552223333@vtext.com

Virgin Mobile USA
[10-digit phone number]@vmobl.com
Example: 5551234567@vmobl.com

Here is a table for example:

Help with Code Tags

(Toggle Plain Text)

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');

//Joe
Web Carpenter: Web Development, Graphic Design, Database Solutions