Sprint Android 4.4.3 for the Nexus 5

Android 4.4.3 KitKat update is out today for and the Nexus 5 users on Sprint
are the first to get it. Carrying a version number KTU48F the update enables
 the device to work on Sprint's LTE network on bands 26 and 41.

 The new Android version is strictly fixing existing bugs and doesn't bring new feature or UI tweaks, as previously rumored. Google has fixed mostly bugs regarding Bluetooth and
Wi-Fi connectivity, but known problems with data connection loss, random reboots,
missed calls and various camera bugs have also been fixed. The update hasn't appeared
 on the list of factory images for Nexus devices just yet, but Sprint is currently seeding it to its customers with Nexus 5 phones.

Samsung Galaxy S5 costs

Analytics company IHS has released its teardown report of the Samsung Galaxy S5,
 which also reveals an estimate of the phone's bill of materials how much its parts cost.


 The Galaxy S5 costs Samsung about $256 to build, which is just slightly more than what the Galaxy S4 cost back in 2013 - $244. The most expensive component in the Galaxy S5 is its 5.1" full HD

 Super AMOLED display. It costs $63, which is $12 cheaper than the 5" one of the Galaxy S4.


 It appears that Samsung has managed to streamline its display production to achieve the lower price. The DRAM and flash memory of the Galaxy S5 cost $33 combined. Interestingly, according to IHS the fingerprint sensor in the Galaxy S5 costs just $4, which is significantly less expensive than the one found in the iPhone 5s. Apple spends $15 for each one they place in their current flagship phone,
 which carries a $199 bill of materials. Lastly, Galaxy S5's heart rate biosensor is made by
 chipmaker Maxim and adds $1.45 to the cost of the device.

IHS estimates the cost of assembly is $5 per device. Be wary that while this component price estimation gives a neat overview of the phone's cost, it doesn't include R&D, software, distribution and marketing costs.

Japanese market-LG G3

The Japanese market version of LG's yet to be revealed G3 flagship might have leaked

 on Twitter. A duo of press shots showing a mysterious high-end LG handset made the
rounds on the social network, courtesy of @evleaks.




LG isai for KDDI click to enlarge The leaked press photos reveal the front and the back of the yet to be announced device in blue and white color scheme. Dubbed LG isai, the smartphone is headed to KDDI in Japan. There is no word on the specs of the upcoming handset just yet.
 

However, LG isai impresses with ultra-slim bezels possibly to accommodate that rumored 5.5"
QHD display in a more manageable footprint). The volume rocker on the back of the leaked handset on the other hand is standard high-end LG smartphone affair.


While we don't see a physical power/lock key on the device, we wouldn't be surprised if that mysterious strip on the left of the volume rocker plays the role it could well be a fingerprint scanner too). LG isai is yet to be annoucned. We'll keep a close eye on any further details on the handset.

Basic MySQL

Basic MySQL


Create or Drop a Database

Starting with something simple, you can use the CREATE command to create a new database. The syntax is

CREATE DATABASE IF NOT EXISTS [yourDBName];

When you create a database with this command, you're really just creating a directory to hold the files that make up the tables in the database.

To delete an entire database from the system, use the DROP command:

DROP DATABASE IF EXISTS [yourDBName];

Be extremely careful when using the DROP command,
because once you drop the database,


You can also use the CREATE command to create a table within the current database. The syntax is

CREATE TABLE [yourTableName] ([fieldName1] (type], [fieldName2]
[type], ...) [options]

To delete a table from the current database, use the DROP command:

DROP TABLE [yourTableName];

Be extremely careful when using the DROP command, because once you drop the tables,

Altering a Table


To add a column to a table, use this:

ALTER TABLE [yourTableName] ADD [newColumn] [fieldDefinition];

To delete a column from a table, use this:

ALTER TABLE [yourTableName] DROP [columnName];

To change a column from one type to another, use this:

ALTER TABLE [yourTableName] CHANGE [columnName]
[newfieldDefinition];

To make a unique column in your table, use this:

ALTER TABLE [yourTableName] ADD UNIQUE [columnName]
([columnName]);

To index a column in your table, use this:

ALTER TABLE [yourTableName] ADD INDEX [columnName]
([columnName]);

Using the ALTER command alleviates the need to delete an entire
table and re-create it .

Insert, Update, or Replace tables record


The INSERT and REPLACE commands populate your tables one record at a time. The syntax of INSERT is

INSERT INTO [yourTableName] ([fieldName1], [fieldName2], ...)
VALUES ('[value of fieldName1]', '[value of fieldName2]'...);

When inserting records, be sure to separate your strings with single quotes or double quotes. If you use single quotes around your strings and the data you are adding contains apostrophes, avoid errors by escaping the apostrophe (\ ') within the INSERT statement. Similarly, if you use double quotes around your strings and you want to include double quotes as part of the data, escape them (\ ") within your INSERT statement.

The REPLACE command has the same syntax and requirements as the INSERT command. The only difference is that you use REPLACE to overwrite a record in a table, based on a unique value:

REPLACE INTO [yourTableName] ([fieldName1], [fieldName2], ...)
VALUES ('[value of fieldName1]', '[value of fieldName2]'...);

The UPDATE command modifies parts of a record without replacing the entire record. To update an entire column in a table with the same new value, use this:

UPDATE [yourTableName] SET [fieldName] = '[new value]';

If you want to update only specific rows, use a WHERE clause:

UPDATE [yourTableName] SET [fieldName] = '[new value]' WHERE [some
expression];

UPDATE can be a very powerful SQL command.


Deleting from a Table


Like the DROP command, using DELETE without paying attention to what you're doing can have horrible consequences in a production environment. Once you drop a table or delete a record, it's gone forever. Don't be afraid; just be careful. To delete all the contents of a table, use the following:

DELETE FROM [yourTableName];

If you want to delete only specific rows, use a WHERE clause:

DELETE FROM [yourTableName] WHERE [some expression];

If you're going to start deleting records, be sure you have a backup.



Selecting from a Table

When creating database-driven Web sites, the SELECT command will likely be the most often-used command in your arsenal. The SELECT command causes certain records in your table to be chosen, based on criteria that you define. Here is the basic syntax of SELECT:

SELECT [field names] FROM [table name]
WHERE [some expression]
ORDER BY [field names];

To select all the records in a table, use this:

SELECT * FROM [yourTableName];

To select just the entries in a given column of a table, use this:

SELECT [columnName] FROM [yourTableName];

To select all the records in a table and have them returned in a particular order, use an expression for ORDER BY. For example, if you have a date field for record entries and you want to see all the record entries ordered by newest to oldest, use this:

SELECT * FROM [yourTableName] ORDER BY [dateField] DESC;

DESC stands for "descending." To view from oldest to newest, use ASC for "ascending." ASC is the default order.

You can also perform mathematical and string functions within SQL statements,


PHP Functions
Php tutorial - imagemagick
php.ini Basics
PHP Sessions
Cookies Versus Sessions
PHP Web-Related Variables
PHP ERRORS
maximum size of a file uploaded
Php Image upload
php file_get_contents
MySQL Data on the Web
What are GET and POST
php and pdf
$_ENV and $_SERVER
PEAR with php
SELECTING DATA PHP
prevent hijacking with PHP
LAMP
PHP MySQL Functions
PHP Zip File Functions
Substrings PHP
PHP Variable names
PHP magic methods
How to get current session id
Add variables into a session
$_GET , $_POST,$_COOKIE
different tables present in mysql
PHP CURL
php Sessions page
PHP-sorting an array
PHP-count the elements of array
Operators for If/Else Statements
PHP file uploading code
PHP global variables
Testing working using phpinfo
PHP Code for a Valid Number
PHP-Associative Arrays
PHP mvc tutorial
PHP get_meta_tags-Extracts
difference between print and echo
PHP best tutorial-PHP variables
Reading DOC file in PHP
PHP interview questions
convert time PHP
PHP implode array elements
header function-PHP
PHP-Renaming Files Directories
PHP Classes
in_array function in PHP
keep your session secure PHP
Web Application with PHP
What is SQL Injection
PHP-extract part of a string
PHP urlencode
PHP- know browser properties
PHP- Extracting Substrings
Checking Variable Values /Types
PHP-best 20 Open Source cms
IP AddressPHP
PHP-Scope Resolution Operator
how create new instance of object
how eliminate an object
PHP- ob_start
XML file using the DOM API
PHP- MVC
PHP- CAPTCHA
PHP- Position of a Value in an Array
PHP-Mail Functions
PHP-difference include vs require
calculate the sum of values in an array
PHP-total number of rows
Show unique records mysql
MySQL Triggers
MySQL data directory
MySQL Subqueries
PHP- Networking Functions
PHP- Operators
Restore database
Conditional Functions mysql
PHP-function overloading
Friend function
mysql_connect /mysql_pconnect
PHP-Error Control Operators
what is IMAP
Apache-Specific Functions
Send Email from a PHP Script
SQL inherently
WAMP, MAMP, LAMP
Php tutorial-SYMBOLS
Table Types-MySQL
PHP-Encryption data management
PHP Array
Running MySQL on Windows
Maximum Performance MySQL
XML-RPC
PHP-static variables
Advanced Database Techniques
FTP
Codeigniter
Apache Pool Size
Why NoSQL
MySQL Server Performance
Database software
SQL Interview Answers
PHP Redirect
PHP Interview Questions with Answers
Advanced PHP

Nokia Lumia 630 - Russia- just €160

Nokia Lumia 630 went official just a few days ago.
It is among the first smartphones to run Windows Phone 8.1 with Lumia Cyan out of the box.
 The smartphone is considered as a successor of the Lumia 620. Nokia has announced the
3G Lumia 630 will launch in various EU and Asian markets this May for €119, 
while its dual-SIM sibling should set you back €129. The smartphone will be also released worldwide with LTE connectivity under the Lumia 635 moniker in July for €139.






 This is at least the official info, but as usual it doesn't include taxes or subsidies. Nokia has begun taking pre-orders for the single and dual-SIM Lumia 630 in Russia via its official Nokia store. The single-SIM Lumia 630 is priced at €163 RUB 7,990, while the dual-SIM version costs €173 RUB 8,490.

Microsoft to release two GDR updates for WP8.1

Microsoft separates Windows Phone 8 updates into major and minor ones - 

 so far we've seen one major 8.1 and three minor ones GDR 1, 2 and 3.


The company is reportedly planning at least two GDR updates for WP8.1 this year.
That's wholly unconfirmed for now, but a 3D Touch system is a possibility.
We heard the first murmurs about it last year - it's essentially Samsung's Air
Gestures from the Galaxy S and Note devices, at least that's what the first rumor made
 it sound like. Another possibility is evolving Nokia's Refocus app which got many imitators
 in this flagship generation. The rumor mill is talking of a dual-camera setup to create
 Lytro-like refocusable photos with just one shot. HTC tried just that and the results were not perfect. The first of the GDR updates for Windows Phone 8.1


Nokia lumia 630

HTC looking to smartphone market


HTC has big plans, and most of them are probably riding on the success of the
new HTC One, aka the M8. Reception to the new device has been good, so HTC's
projections may very well come to fruition. Peter Chou, CEO and co-founder of
HTC believes that the company will be able to grab 8-10% of the total smartphone
market "in the long run". This should come from a combination of both the sale of
their high-end smartphones, and some of their lower end offerings, like their Desire
line of phones, which are competitively priced. Chou also confirmed, again, that
HTC would be offering wearable devices and tablets in the future. As to the specific
details regarding these future tech offerings, well, there aren't any. However, there
have been rumors that HTC would be the manufacturer of the next 8.9" Google Nexus tablet.


Also, expect an android-based HTC smartwatch later in the year. Chou may be positive
about the company's future, but analysts sure aren't. C.K. Cheng, anaylst for the brokerage
 firm, CLSA ltd. Believes that HTC doesn't have what it takes to stand up to the
juggernaut that is Samsung.

Sprint users are reporting that the Android 4.4.2 KitKat update is rolling out for their
 HTC One Max phablets. The update, version 2.09.651.1, weighs in at 344MB and is available
 for download over the air. Other than the latest Android version, the new software brings
security enhancements, a cloud printing service and additional Bluetooth profiles.

HTC One Max is getting updated to Android 4.4 KitKat Note that the international version of
the HTC One Max received its KitKat update in mid-February.

Top 100 Website For Work From Home Jobs

Part Time Jobs | Data Entry Jobs | Earn Money Online Work ...
www.earnparttimejobs.com/index.php
part time jobs for students & housewives. Work from Home doing data entry jobs. Earn $1,000-2,000 USD/month. No investment. Free Training. 
 
 
NetJobs4all.com - Daily Updates on Online Jobs, Data Entry ...
netjobs4all.com/
Earn Rs.50,000 every month.Find latest Updates in Online Job Opportunities,Data Entry Jobs,Part time Jobs,Freelancing Jobs,Work from Home. We update Daily.
 
 
Work From Home, Part Time Jobs In Pune At work from home jobs ...
www.simplyhired.co.in/a/jobs/list/q-work from home, part time jobs in pune at work from home
Every Work From Home, Part Time Jobs In Pune At Work From Home job on the web. 30 jobs available. 
 
Net Survey Jobs - Work From Home, Part Time Online Jobs, Paid ...
www.netsurveyjobs.com/
Net Survey Jobs is an excellent source of information for work from home jobs, Part time Online Jobs, Paid Surveys, Data Entry Jobs etc., exclusively for India
 
Data Entry, Data Entry Job, Data Entry Jobs, Part Time Jobs
easypostjob4u.com/
Data Entry Jobs, Data entry jobs Operators requirements urgently , Salary Rs.30000 to 40000. Inter/Graduates can apply. Part time home based data entry jobs. 
 
Part Time Jobs - Work from Home - Jobs in India
jobs.vivastreet.co.in/mlm
We are looking for Data Processing Operator to Work from home on their Computer. It is Part Time Job. Monthly Payment will be Rs. 21,000/-. Internet is not required.
 
Work at Home :: home business ideas, jobs and opportunities
biz-whiz.com/
Working from home has its own set of advantages and disadvantages. A home business or a work from home job is not for everyone. 
 

 
How to Work From Home, Legitimate work from home jobs
www.work-from-home.co/
How to work from home and find a legitimate work from home job
 
Work From Home - Articles - AOL Jobs
jobs.aol.com/articles/category/work-from-home-jobs/
Ready to make money from home? We have in-depth information about work from home jobs and how to find a home business opportunity right for you.
 

Online Part Time Jobs | Online Data Entry Jobs | Work from ...
www.online-parttime-jobs.com/
Online jobs, data entry jobs for part time workers


Work at home jobs | Work at home ideas | Work at home careers
thehomeworker.org/
Providing work from home data entry, work at home jobs, work at home programs, work at home plans, work at home tips, work at home advice, work .
 
EJobsJunction - Online Jobs | Work from Home | Work From The ...
www.ejobsjunction.com/
Internet jobs can help you earn extra income by sitting at home and relaxing.
 
Clerical work from home jobs. No investment required
www.dataconversionjobs.com/clerical-work-from-home-jobs/
Clerical work from home jobs
 
Work at Home Jobs: Free legitimate Opportunities to work
www.workathomecareers.com/
Complete resource providing free Work at home jobs online, careers, home businesses. 
 
 
work from home jobs
www.work-from-home-data-entry.net/Work_from_Home_Jobs.html
work from home jobs, Start making money with very popular companies. Complete training and support. Start your legitimate work from home jobs today.
 
Work at Home Data Entry | Work From Home
work-at-home-data-entry.com/
Your source for a quality work at home data entry programs, we support our customers just ask our members using or data entry program. A top work at home experience
 
Workathomeexplorer - Free Work at Home Job Opportunities
www.workathomeexplorer.com/
Find free, legitimate work at home jobs, freelance projects, telecommuting friendly companies, home businesses and how to avoid internet scams.
 
 
work from home jobs
www.adminclericalonlinejobs.com/
Online jobs and work at home opportunities for everyone. Access home based businesses and online jobs 
 
  Work At Home Job Search: Work At Home Careers.com
www.workathomecareers.com/workathomejobs/
Complete resource providing free Work at home jobs, home business ideas, articles and companies that hire workers. Avoid scams now.
 
Work from home, Stay at Home Mom Jobs with Home with the Kids
www.homewiththekids.com/
Helping stay at home parents to find legitimate work at home jobs and learn to save money. 
 
Surveys Pay U - Online Surveys,Online Jobs,Part time jobs ...
www.surveyspaysu.com/
This website offers online jobs , part time jobs, home based jobs without any investment and you can work from home.. Dear Friend, Are you looking for online.
 
Work From Home
www.uvocorp.com/work_from_home.html
Work from home, writing jobs from home. Start earning money from writing. Apply for a job online with UvoCorp.com. Registration is free.
 
Part time Jobs Online, Work from Home, Ad Posting Jobs, Data ...
www.adpostingjob.com/
Learn how to make money online at home. Discover how teens make money online with free resources. 
 
work home data entry bangalore Workers and Jobs | Freelancer.in
www.freelancer.in/work/work-home-data-entry-bangalore/
Hire the top work home data entry bangalore Workers, or work on the latest work home data entry bangalore Jobs.
 
Work from Home India | Home Based Jobs in India
www.naukrihub.com/job-openings/work-from-home-india/
Know various type of work that you can do from home in india, submitted it to the clients and earn money while you are at home.
 
Home working jobs
jobs.theguardian.com/jobs/home-working/
Apply for home working jobs on Guardian Jobs. Browse through 100s of working from home job vacancies


Online Jobs, Home Jobs, Part time Jobs, Work From Home, Data ...
www.visionjobcare.com/
Offline Data Entry Jobs: Offline Data Entry Jobs, is Quite Different compared to Online Data Entry, but gives the same Profit.
 
Work At Home | work from home jobs and Online Opportunities
www.homenetpro.com/
Legitimate work at home jobs, business opportunities, ideas and more to help you locate an honest work from home career and make money online.
 
365OnlineJobs.com - Online Jobs - work from home jobs
www.365onlinejobs.com/
Best and Reliable work from home opportunity. Data entry, ad pasting, marketing etc jobs available, checkout website for more information.

 
Work-At-Home :: Jobs and Home Business
www.2work-at-home.com/
Provides telecommuting job listings, home business ideas and other work from home resources.
 
work from home jobs List
genuinejobs.com/update1.htm
If you're interested in any of the jobs mentioned above, or would like to search through the full list.
 
Working From Home Jobs Your Source For Working At Home
workingfromhomejobs.com/
Working From Home Jobs offers work at home, home business, and money making opportunities and is your source for working at home.
 
Data Entry Work , Data Entry Jobs, Online Jobs , Data Entry ...
www.onlinejobsfree.com/
The best available online jobs just a click away. A whole range of data entry jobs and lots more to help you earn from home and that too for FREE. 
 
Work From Home and Earn a Second or Fulltime Income Working ...
remoteonlineworkfromhome.com/
Work from No Home Review 
 
 
Part Time Home Jobs | Online Data Entry Jobs | Work From Home ...
www.onlinedataentryjobsinus.com/online-data-entry-home-jobs/index.php
Online Data Entry Jobs are offered at www.onlinedataentryjobsinus.com. Maximum Earning Part time Home Jobs
 

Why Social media is the powerful network



Social media sites are wildly popular, but there are still no marketing rules
 carved  stone, and many companies grapple with measuring its value.
A majority of
companies do not have standard frameworks in place to measure the value
of social media.

In looking at a data snapshot of monthly
aggregate time spent on a site for Facebook
and the ROW (rest of the web), Facebook
has toppled some big names. The Nielsen
Company data show that even Yahoo users
come in a distant second with an average of
17.2 billion minutes per month, less than
one-third Facebook’s total.

In measuring time spent per user, Nielsen
data shows that for the second straight
month, Facebook dominated U.S. web
brands in average monthly time during
August 2011. The average Facebook user
spent seven hours, 46 minutes on the site.
AOL Media Network, averaged two hours,
52 minutes and 52 seconds. YouTube also
ranked in the top 10 with an average of one
hour, 41 minutes of user time for the month.


Enter Google. Google+ emerged as a player in the Social
Network and Forums category in late September, Experian
Hitwise reported, a day after the site went from invitationonly to open access
 and became available to everyone.



Opening access created a massive spike in market share of
visits for the site, with a 1269% growth from the week
ending September 17 to the week of September 24. The
site also received nearly 15 million total US visits last week.
In just one week, Google+ went from ranking as 54th most
visited site in the Social Networking and Forums category to
8th place.

Google+ also received nearly 15
million total US visits during the week
of its initial public offering, according to
Experian Hitwise, not quite half of what
Twitter attracted in that time. Google+
also created a decent challenge to
MySpace and LinkedIn, sites that
received about 16 million and 18
million visits, respectively. During the
invite-stage of the launch, for week
ending July 16, Google+ received 1.86
million total visits.
Google+ Grabs 15 Million Visitors
Top Social Networking sites and Forums
Total visits, millions.

Facebook
YouTube
Twitter
Yahoo! Answers
Tagged
Linkedin
MySpace
Google+

The ROI research survey asked consumers about their discussions
on a variety of vertical products on social networks.
myYearbook
iVillage

Social sign-in is another growing activity
among social media users. SSI allows users to
sign into a restricted access site using existing
sign-in data, rather than having to create a new
account.

Facebook
Twitter
Windows Live Profile
LinkedIn
QQ.com
microblogging
MySpace
Renren
Vkontakte
Orkut
Yahoo Pulse

Google packs-new gaming features





Google took a big step over the weekend to address problems with in-game
 purchases, but that's not all that the company has in store for game
developers this week.

As the annual Game Developers Conference kicks off at the Moscone Center in
San Francisco, Google has announced several improvements to Play Games on Monday
 that the company says will take several weeks to become available.

Game Gifts, a new feature, will let players send virtual in-game objects to anyone
 in their Google+ Circles or through player search, just as in other social-media-driven
 games.


The Play Games app will add support for multiplayer game invites, and the Google Play
 Store is adding 18 new game categories for faster game search.