Advanced SQL
version of SQL. For example, MySQL's functions are useful tools for
working with strings, dates and times, and math. Also, we'll show some
ways to tune MySQL in order to improve application performance.
It's important to know how to choose and design indexes for fast querying,
and how to use MySQL's query cache for fast results.
Exploring your database, tables, indexes, and performance with SHOW
More on SELECT queries, including advanced join types, aliases, nested queries,
user variables, and the limitations of MySQL.
More on manipulating data and databases, including finding out about tables
and databases, creating tables with queries, altering tables, more on the
UPDATE and DELETE statements, and bulk loading and exporting data.
Functions and operators in SQL and MySQL
Automatically running queries
MyISAM, InnoDB, and Heap table types
Backup and recovery, and transferring data between database servers
Managing database server users and privileges, and creating users for web
database applications.
Basic tuning of MySQL, including index design, using the query cache,
and, miscellaneous tips for speed.
The SHOW command is useful for exploring the details of databases, tables,
indexes, and MySQL. It's a handy tool when you're writing new queries,
modifying database structure, creating reports, or understanding how your
MySQL server is performing. The SHOW command isn't part of the SQL
standard and is MySQL-specific. It can be used in several ways:
SHOW DATABASES
Lists the databases that are accessible by the MySQL server. You will only
see those databases that you have access to, unless you have the
SHOW DATABASES privilege;
privileges and user rights are discussed later in this chapter.
SHOW TABLES
Shows the tables in the database, after a database has been
selected with the use command.
SHOW TABLE STATUS
Provides information about all tables in the current database,
including the table type, number of rows, how the rows are stored,
average row length, size of the datafile, next auto_increment value if applicable,
creation time, last modification time, and any extra options
used with CREATE TABLE.
SHOW CREATE TABLE tablename
Shows the CREATE TABLE statement that was used to create the table tablename.
The output always includes any additional information automatically added or
changed by MySQL during the creation process, such as the table type and
character set used.
SHOW OPEN TABLES
Shows which tables the server currently has open and which tables are locked.
SHOW COLUMNS FROM tablename
Shows the attributes, types of attributes, key information, whether NULL
is permitted, defaults, and other information for a table tablename.
The alias DESCRIBE table produces the same output.
SHOW INDEX FROM tablename
Presents the details of all indexes on the table tablename, including the
PRIMARY KEY. It shows amongst other information what the attributes are
that form each index, whether values in the index uniquely identify rows,
how many different values there are in the index the cardinality,
and the index data structure used usually a B-tree.
SHOW PRIVILEGES
Lists the access privileges that can be given or denied to users of the
version of MySQL server that you've installed.
SHOW PROCESSLIST
Lists the current MySQL processes or threads that are running,
and what query they're carrying out on which database.
SHOW STATUS
Reports details of the MySQL server performance and statistics.
Selected statistics .
SHOW TABLE TYPES
Lists the possible table types that are available in the version
of the MySQL server that you have installed, and notes alongside
each whether you have compiled-in support for that table type.
SHOW VARIABLES
Reports the values of most MySQL system variables.
SHOW WARNING and SHOW ERRORS
Reports warnings or errors from the last command or statement
that was run on a table
How to promote my website
Create RSS feeds. Try registering with Feedburner
Publish free newsletters.Recruit site visitors to your
free benefit-packed newsletter and you are building an
emailing list. Use your newsletter to promote your
content.Post on your site/blog.You’re doing that anyway,
of course. But it’s amazing what people forget if it’s
not on a checklist.
Submit content to generic social siteseg,
Twitter, LinkedIn, Facebook, StumbleUpon, Digg and now
Google +,social-bookmarking.
Submit to your specialist social networking sites
Use your specialist contactsby email, direct tweets
and even telephone.
If your content is good and your network strong then
you will get links from your immediate contacts.
Then their readers and others will find your site,
visit and perhaps link to it.
Check visits, Google ranks for target keywords, response
rates and numbers for different metrics including goals
like email recruitment, sales numbers and revenue.
Check whatever measures you’ve got. If you don’t have
Goals or Ecommerce configured then use bounce rate,
average time on site and pages per visit.
Check seasonal demand and trends in your target niches
with Google Insights.
Long tail content absolutely must still be high quality
but its job for SEO is to target many thousands of your
target keyword niches long tail keywords.
SEO never stops because your competition never stops.
Continue on the SEO Circle of Response.
Look for the latest most-responsive short term target
keyword niches. Chase short term target keyword niches
for fast results, maximum response rates, and quick profits.
Invest in your long term target keyword niches with quality
content, link building, promotion and brand building.
To build quality links:
• Good content
• An understanding of your online community
• To know how to get external sites to link to yours
You can do this, no matter what level of experience you have.
You’ll soon be getting quality inbound links if you approach
the job systematically and give it sufficient time.
Add Antivirus software: A computer program that scans a computer’s memory and mass storage to identify, isolate, and eliminate viruses, and that examines incoming files for viruses as the computer receives them.
keep antivirus on pc
Publish free newsletters.Recruit site visitors to your
free benefit-packed newsletter and you are building an
emailing list. Use your newsletter to promote your
content.Post on your site/blog.You’re doing that anyway,
of course. But it’s amazing what people forget if it’s
not on a checklist.
Submit content to generic social siteseg,
Twitter, LinkedIn, Facebook, StumbleUpon, Digg and now
Google +,social-bookmarking.
Submit to your specialist social networking sites
Use your specialist contactsby email, direct tweets
and even telephone.
If your content is good and your network strong then
you will get links from your immediate contacts.
Then their readers and others will find your site,
visit and perhaps link to it.
Check visits, Google ranks for target keywords, response
rates and numbers for different metrics including goals
like email recruitment, sales numbers and revenue.
Check whatever measures you’ve got. If you don’t have
Goals or Ecommerce configured then use bounce rate,
average time on site and pages per visit.
Check seasonal demand and trends in your target niches
with Google Insights.
Long tail content absolutely must still be high quality
but its job for SEO is to target many thousands of your
target keyword niches long tail keywords.
SEO never stops because your competition never stops.
Continue on the SEO Circle of Response.
Look for the latest most-responsive short term target
keyword niches. Chase short term target keyword niches
for fast results, maximum response rates, and quick profits.
Invest in your long term target keyword niches with quality
content, link building, promotion and brand building.
To build quality links:
• Good content
• An understanding of your online community
• To know how to get external sites to link to yours
You can do this, no matter what level of experience you have.
You’ll soon be getting quality inbound links if you approach
the job systematically and give it sufficient time.
Add Antivirus software: A computer program that scans a computer’s memory and mass storage to identify, isolate, and eliminate viruses, and that examines incoming files for viruses as the computer receives them.
keep antivirus on pc
SEO-Blocking Spiders
SEO-Blocking Spiders
google let webmasters block unwanted links in you canliterally block any visitor including search engines
and secure the data or information you have on your
website by the help of htaccess deny from all.
Block spiders from part of a page - webproworld if
for no other reason than this, it is worth setting up
a robots.txt file to control search engine spiders
blocking specific robots seo articles rss feed.
Let the spiders in to increase your seo visibility -
youtube trending news about spiders bots search engine
watch is the authoritative guide to search engine marketing -sem
and search engine optimization.
Blocking robots txt from being indexed using robots txt
to block spiders from dynamic pages.
Black hat search engine optimization is customarily defined
as the practice of using unethical techniques to make your
search rankings go up find out how to spot it.
web analytics black hat search engine optimization is
customarily defined as the practice of using unethical
techniques to make your search rankings go up find
how to spot it.
a search engine spider practical the great thing about
using the screaming frog seo spider is that within a
couple of collect information for use in blocking
specific urls and folders from.
How to block bad bots - how to protect web page content
series search results. Seo ranking factors - search engine
ranking factors robots.txt and search engine spiders -
seo a spider can be defined as which crawls over the web
and fetches the webpages for search engines it can
virtually start.
robots.txt-Blocking spiders block and stop bots, crawlers and search
engine spiders from using your visitor statistics logs any
online content is a subject for being indexed by search engines.
PHP-Session Security
you need to treat the session as a possible security
hole. Session security is necessary to create and
implement a session. If someone is listening in or
snooping on a network, it's possible that he can
intercept a session ID and use it to look like he
is someone else. It's also possible to access session
data from the local filesystem on multiuser systems
such as ISP hosting machines.
Session hijacking is when someone accesses either
a client's cookie or session ID, and then attempts
to use this data. Session fixation is attempting to set
your own session ID. Session fixation and hijacking
are easy to combat. We'll make use of the super global
variables for the client's IP address and browser
type to keep things secure.
<?php
session_start();
$user_check = md5($_SERVER['HTTP_USER_AGENT'] .
$_SERVER['REMOTE_ADDR']);
if (empty($_SESSION['user_data'])) {
session_regenerate_id();
echo ("New session, saving user_check.");
$_SESSION['user_data'] = $user_check;
}
if (strcmp($_SESSION['user_data'], $user_check) !== 0) {
session_regenerate_id();
echo ("Warning, you must reenter your session.");
$_SESSION = array();
$_SESSION['user_data'] = $user_check;
}
else {
echo ("Connection verified!");
}
?>
When a browser first requests the page,a session is
started. In that session, we stored the encoded
combination of the IP address and browser type.
That way, when the user returns to this page, we
can compare the value stored in the session versus
a fresh computation of the IP address and browser
type. If the two don't match, we potentially
have a hijacker, so we pick a new ID and clear
any saved data for that session. That way, the
hijacker cannot retrieve any of the private
information stored in the session. This doesn't
cause a problem for legitimate users, because
they aren't going to change browser or IP
addresses in the middle of a session with
your web site.
You know that trusting data from a user isn't a
great idea. But what exactly do you consider
to be user data versus system data that you trust?
GET
Data from GET operations is inherently user
data since it usually comes from form submissions.
POST
Data from POST operations is inherently
data since it usually comes from form submissions.
Cookies
Cookies may seem like they could be trusted
since they are automatically sent, but in reality,
since they are stored on the client's computer,
they could be intentionally altered. Therefore,
they're considered user data.
Session data
Session data can be trusted as long as the session
value is set based on validated data. If it's set
to a user-supplied value without validation,
it's not trustworthy.
User input should be checked and escaped properly.
Data that's bound for the database must have all
special characters such as single and double
quotes escaped.
PHP-simple Form
a search query, let's begin by building a form
to handle the user's input. Every form must
have these basic components:
The submission type defined with the method keyword
One or more input elements defined with the input tag
The destination to go to when submitted defined with
the action keyword
<html>
<head>
<title>Building a Form</title>
</head>
<body>
<form action="<?php echo($_SERVER['PHP_SELF']); ?>"
method="get">
<label>
Search: <input type="text" name="search" />
</label>
<input type="submit" value="Go!" />
</form>
</body>
</html>
A file called simple.php in a web-accessible directory
on your web server, such as the document root. Strictly
speaking, forms are defined purely by HTML, but we're
using some PHP code on line 6 to reference the super
global PHP_SELF. This provides a shortcut to the name of
the current PHP file that handles the submission of
the form data.
The form allows you to capture the search sting from
the user for a search. Notice how we wrapped a label
tag around the input where the text was; this makes
the form easier to use. Since clicking on the Search:
text automatically sends the cursor to the search field.
we set the form submission method to GET. This is done
to insure that users can bookmark their searches and
not have to come back to the page and reenter their
data.
PHP-Database-Basics-DB-Arrays
dynamic web site is a great start. But, it helps tremendously
to structure your database right. We'll give you a solid
understanding of both database design and the language that's
used to communicate with the database, SQL. The first step in
setting up your database is to design how you'll store your data.
Then, you'll learn how to add, view, and change data.
Databases are a repository for information.
They excel at managing and manipulating structured information.
Structured information is a way to organize related pieces of
information, which we discussed previously in our chapters on PHP.
The basic types of structured information,
which can also be called data structures, include:
Files
Lists
Arrays
Records
Trees
Tables
Each of these basic structures has many variations and allows
for different operations to be performed on the data. An easy
way to understand this concept is to think of the phone book.
It's the most widespread database, and it contains several
items of informationname, address, and phone number, as well
as each phone subscriber in a particular area. Phone books
have evolved, and some people may have bolded names, but for
the most part, each entry in the phone book takes the same form.
If you think of the physical hardcopy phone book in similar
terms as a database, the phone book is a table, which
contains a record for each subscriber. Each subscriber record
contains three fields also known as columns or
attributes: name, address, and phone number. These records
are sorted alphabetically by the name field, which is
called the key field.
Adding MySQL to PHP and combining the applications for your
dynamic web site is a great start. But, it helps tremendously
to structure your database right. We'll give you a solid
understanding of both database design and the language that's
used to communicate with the database, SQL. The first step in
setting up your database is to design how you'll store your
data. Then, you'll learn how to add, view, and change data.
Databases are a repository for information. They excel at managing
and manipulating structured information. Structured information
is a way to organize related pieces of information, which we
discussed previously in our chapters on PHP. The basic types of
structured information, which can also be called data structures
include:
Files
Lists
Arrays
Records
Trees
Tables
Each of these basic structures has many variations and allows
for different operations to be performed on the data.
An easy way to understand this concept is to think of the
phone book. It's the most widespread database, and it
contains several items of informationname, address,
and phone number, as well as each phone subscriber
in a particular area. Phone books have evolved, and some
people may have bolded names, but for the most part,
each entry in the phone book takes the same form.
If you think of the physical hardcopy phone book in
similar terms as a database, the phone book is a table,
which contains a record for each subscriber.
Each subscriber record contains three fields also known
as columns or attributes: name, address, and phone number.
These records are sorted alphabetically by the name field,
which is called the key field.
Nokia x-launched
part of asha range according to a recent report by go android, the nokia x will join
nokia s asha range in india in march. Nokia lumia 920, 820 & 620 launched in india.
Nokia x benchmarked on browsermark 2, shows us its predictable performance when stacked
up against other smartphones. Nokia x unveiled: combines android with windows phone finnish
mobile phone maker nokia is reportedly planning the launch of more than one smartphone
running under the android operating system, and it should unveil such. Yet another proof
that nokia x is real normandy s hitting the stage at mobile world congress to announce the
latest happenings from nokia, stephen elop confirmed that bbm will be coming to lumia devices,
joining. Nokia to launch more android phones following nokia x nokia introduce its android os
version with optional dual sim, mobile phones named x, x+ and xl last week the phones pack a 4
lcd display and come with nokia and. Ridiculously low price revealed for upcoming nokia x mobile
world congress 2014 is now in full swing, and nokia has just taken the wraps off its long-rumored
android smartphone that s actually an entire line.
Nokia x android smartphones: hands-on and first a new rumor suggests that nokia s android
smartphone, which has the code name normandy, could have the official name nokia x if and
when it is released to. Nokia normandy/nokia x: budget android phone to be nokia s first android
smartphone is expected to be launched at the mobile world congress in barcelona on monday nokia
has an event planned for the first. Nokia x android smartphone set for launch yes, nokia has
launched a series of android devices at mwc 2014, as expected from numerous leaks in the lead up
to today s press conference the low-cost. Nokia x full detailed specifications mobiles view finnish
mobile phone maker nokia is reportedly planning the launch of more than one smartphone running under
the android operating system, and it should unveil such.
The nokia x strat chery by ben thompson the nokia x has the excellent build quality and design nokia
is famous for, but software based on android this means you get a gorgeous phone with access to 100,000.
Ridiculously low price revealed for upcoming nokia x nokia introduce its android os version with optional
dual sim, mobile phones named x, x+ and xl last week the phones pack a 4 lcd display and come with nokia and.
Androidspin nokia x benchmarked on browsermark 2, shows nokia, the company that adopted windows phone
because its ceo was too afraid of samsung to shift to android, is about to debut its first android phone by.
Nokia x finnish mobile phone maker nokia is reportedly planning the launch of more than one smartphone
running under the android operating system
Internet Speed Tester
Test your broadband connection quality and speed try megapath
speed test plus and see if your connection can support voip and
other net applications. Internet speed and performance test by toast.
net this speed test will identify both the upstream and downstream
speeds of your current connection to the internet the test measures
speed by determining how long it.
http://testmyspeed.com
http://www.thinkbroadband.com
speedtest.net.in
www.speedtest.net/results.php
www.speakeasy.net/speedtest
www.whatismyip.com
speedtest.net.in/testers
my.verizon.com/services/speedtest
testmy.net
www.speed-test.in
www.auditmypc.com/internet-speed-test.asp
www.internetspeedtest.in
Testmyspeed.com road runner broadband speed test what is internet
speed test this internet speed test will show you the results of the fastest
download burst rates during your internet speed test from your.
Internet speed test - surewest communications cable one is now offering an
authorized speed test through your myaccount login we provide this speed
test to our high speed internet subscribers as a diagnostic.
test my net speed take this internet speed test to uncover problems and learn
how to increase your broadband connection performance. Internet speed test -
cable one fast speed test for your internet broadband cable or dsl connection
upload and download speeds in an easy to use interface. Internet speed test -
cable one get an instant review of your broadband speed connection.
10 ways to test and boost your speed ispeedometer check your internet connection
speed for free cable modem speed test, dsl, dialup, cable broadband test your
time warner cable, isp interner service. Megapath speed test plus test your broadband
quality & speed pc pitstop offers free computer help and bandwidth, download,
and upload speed testing test pings and trace routes for your internet connection.
The speed test summary the cox high speed internet speed check tool is available
through internet tools and provides customers access to a speed test that measures
downloads. Internet speed test here - online bandwidth test your isp learn more
about what broadband speed is and check how fast our broadband speed will be in
your area with our bt business broadband packages.