Posts: 220
Name: Baris
|
Welcome to The Best Mobile Phones Specifications Database
Please pay attention that there're lots of "new technological features" fields, for example "voice dialing", "internet browsing", "camera flash"...etc. There can be lots of old phones that don't have these kinds of new technologies, so if you see blank cells in this db, it means that this mobile phone doesn't have this new technology, for example if we think about Ericsson T28(which is very old an non-colored screen), it doesn't have "camera size", "camera resolution", "camera flash", "color screen" etc. So these fields are blank or you'll see "No" or "NULL" in this db, I think you got it 
This database is an awesome one which has lots of fields!!!
Here the fields list which it includes:
1) ID
2) BRAND NAME
3) MODEL
4) NETWORK GSM
5) DIMENSION
6) WEIGHT
7) DISPLAY COLOR TYPE
8) DISPLAY SIZE
9) DISPLAY COLORS
10) BATTERY TYPE
11) BATTERY CAPACITY
12) TALK TIME
13) STANDBY TIME
14) ANTENNA
15) OS
16) OS VERSION
17) GPS
18) CAMERA RESOLUTION
19) CAMERA VIDEO CAPTURE
20) CAMERA FLASH
21) CAMERA FEATURES
22) VIDEO
23) VIDEO CALLING
24) DATA
25) INTERNET BROWSING
26) USB
27) INFRARED
28) BLUETOOTH
29) WIRELESS LAN
30) COMPUTER SYNCHRONIZATION
31) MEMORY
32) MEMORY EXPANSION
33) MMS
34) EMAIL
35) MP3 PLAYER
36) RADIO
37) POLYPHONIC RINGS
38) VIBRATION ALERT
39) ALARM
40) CALENDAR
41) CALCULATOR
42) PHONEBOOK FEATURES
43) MULTIPLE NUMBERS PER CONTACT
44) MULTIPLE LANGUAGE
45) PHONE PROFILES
46) GAMES
47) JAVA
48) VOICE DIALING
49) VOICE COMMANDS
50) VOICE RECORDING
51) SPEAKER PHONE
As you see, there're 51 different fields.
The database is uptodate and includes the previous mobile phones(since 1998) to 2007 and some new incoming phones!!!
Structure is here:
PHP Code:
CREATE TABLE `mobilephones` (
`id` bigint(20) NOT NULL auto_increment,
`brandname` varchar(255) character set utf8 collate utf8 NOT NULL default '',
`model` text character set utf8 collate utf8 NOT NULL,
`networkgsm` text character set utf8 collate utf8,
`dimension` text character set utf8 collate utf8,
`weight` text character set utf8 collate utf8,
`displaycolortype` text character set utf8 collate utf8,
`displaysize` text character set utf8 collate utf8,
`displaycolors` text character set utf8 collate utf8,
`batterytype` text character set utf8 collate utf8,
`batterycapacity` text character set utf8 collate utf8,
`talktime` text character set utf8 collate utf8,
`standbytime` text character set utf8 collate utf8,
`antenna` text character set utf8 collate utf8,
`os` text character set utf8 collate utf8,
`osversion` text character set utf8 collate utf8,
`gps` text character set utf8 collate utf8,
`cameraresolution` text character set utf8 collate utf8,
`cameravideocapture` text character set utf8 collate utf8,
`cameraflash` text character set utf8 collate utf8,
`camerafeatures` text character set utf8 collate utf8,
`video` text character set utf8 collate utf8,
`videocalling` text character set utf8 collate utf8,
`data` text character set utf8 collate utf8,
`internetbrowsing` text character set utf8 collate utf8,
`usb` text character set utf8 collate utf8,
`infrared` text character set utf8 collate utf8,
`bluetooth` text character set utf8 collate utf8,
`wirelesslan` text character set utf8 collate utf8,
`computersyn` text character set utf8 collate utf8,
`memory` text character set utf8 collate utf8,
`memoryexpansion` text character set utf8 collate utf8,
`mms` text character set utf8 collate utf8,
`email` text character set utf8 collate utf8,
`mp3player` text character set utf8 collate utf8,
`radio` text character set utf8 collate utf8,
`polyphonicrings` text character set utf8 collate utf8,
`vibrationalert` text character set utf8 collate utf8,
`alarm` text character set utf8 collate utf8,
`calendar` text character set utf8 collate utf8,
`calculator` text character set utf8 collate utf8,
`phonebookfeatures` text character set utf8 collate utf8,
`multiplenumberspercontact` text character set utf8 collate utf8,
`multiplelanguage` text character set utf8 collate utf8,
`phoneprofiles` text character set utf8 collate utf8,
`games` text character set utf8 collate utf8,
`java` text character set utf8 collate utf8,
`voicedialing` text character set utf8 collate utf8,
`voicecommands` text character set utf8 collate utf8,
`voicerecording` text character set utf8 collate utf8,
`speakerphone` text character set utf8 collate utf8,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1468 ;
Sample from the db:
Code:
INSERT INTO `mobilephones` VALUES (1339, '\n Nokia', 'Nokia N95', '900 / 1800 / 1900', '3.9" x 2.1" x 0.8" (99 x 53 x 21mm)', '4.2 oz (120 g)', 'TFT', '240 x 320 pixels', '16 777 216', 'Li - Ion', '950 mAh', '6.50 hours the average is 4 h (240 min)', '228 hours the average is 206 h (9 days)', 'Internal', 'S60 over Symbian', 'Symbian 9.1, S60 3.0', 'Yes', '5 megapixels', 'VGA, MPEG4, 30fps', 'Yes', '2.60Dual-slider (up and down). Multimedia-dedicated keysCarl Zeiss Lens; Auto-Focus; Additional CIF camera for video calling;\nDigital Video Stabilization', 'MPEG-4 , H.264/AVC , H.263/3GPP, RealVideo 8/9/10 formats supported', 'Yes', 'GPRS / EDGE / UMTS / HSDPA', 'HTML', 'No', 'Yes', 'Version\n 2.0', '802.11b / 802.11g', 'Yes', '160MB', 'microSD (T-Flash)', 'Yes', 'IMAP / POP3 / SMTP', 'MP3, AAC, AAC+, eAAC+, WMA formats supported', 'FM radio', 'MP3', 'Yes', 'Yes', 'Yes', 'Yes', 'capacity depends on the available memory', 'Yes', 'Yes', 'Yes', 'Yes plus downloadable', 'Midp 2.0', 'Yes', 'Yes', 'Yes', 'Yes');
Records: 1.467
Price: 49$
Regards
|
Mobile Phones Specifications Database with all details
