When building my website "Crossword Heaven" I came across a problem. I created a PHP object called "crossword" but needed to save the information in the object to a database. Now considering that this object contained a lot of information this was not an easy thing to do. Or was it?

The answer: serialize().

What the serialize() function does is take something like an array or object and converts it into a string that can be stored in a database. All I had to do so that I could save the crossword object is something like "serialize($crossword)." Easy! Some words of warning though. If you're using a version of PHP less than version 4 watch out because only properties get saved, not methods.

Here's a peek at the actual code:

$data = addslashes(serialize($crossword));
$name="";
if(isset($xwordInfo['xword_name'])){
$name = $xwordInfo['xword_name'];
}

$today = date('Y-m-d H-i-s');

$sql = "INSERT INTO `xword` ( `xword_id` , `xword_obj` , `xword_name`, `xword_owner`, `xword_width`,
`xword_height`,`xword_date`)
VALUES ('', '" . $data . "', '$name', '$owner', '$width', '$height', '$today');";


And here's the SQL to create the table 'xword':

CREATE TABLE `xword` (
`xword_id` int(11) NOT NULL auto_increment,
`xword_obj` blob NOT NULL,
`xword_name` varchar(100) NOT NULL default '',
`xword_owner` varchar(100) NOT NULL default '',
`xword_width` int(11) NOT NULL default '0',
`xword_height` int(11) NOT NULL default '0',
`xword_date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`xword_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


You'll see that I used the addSlashes() function. That's because when the crossword object was serialized it contained characters like double quotes. These had to be escaped before the crossword could be saved to the database.

Now having saved a crossword object to a database I had to have a way to get it back. Surely, if there was a method to serialize an object there had to be one to unserialize an object, right? And yes, there is:
unserialize().

As you'd expect, unserialize() works the same way as serialize(), but in the opposite direction. You give it some serialized data and it returns the thing that was serialized. To get the crossword back all I had to do was something like "unserialize($crosswordData)."

Here's a look at the code:


$xwordId = (get_magic_quotes_gpc()) ? $xwordId :
addslashes($xwordId);

$sql = "SELECT xword_id, xword_obj, xword_name, xword_age from w3b_xword where xword_id=$xwordId";
$result = parent::getSQL($sql);
$row = parent::getRow($result);

if(parent::getNumRows($result)>0){
$crossword = unserialize($row['xword_obj']);
}


And that's it. Obviously serialize() and unserialize() are pretty handy functions to have around. And in my case I couldn't do without them.

About the Author:
Kevin Davies is the webmaster of Crossword Heaven (http://www.crosswordheaven.com) - a site that lets you create and solve crosswords online. If you're a webmaster you can also link to crosswords. Crosswords are a great way to keep your visitors on your site and keep them returning.

The most important part of a successful internet business is totally depending on your ability to automate maximum no. of tasks to increase your productivity.

The operation of an internet website involves many repetitive tasks which can frustrate the most effective business marketing person. There are many software programs which are varied in terms of the tasks they perform to save your time by automating routine and repetitive work.

There are many free software programs available online. One of them is Google Keyword Adwords software program which you can use to ensure your efforts are on right track. A software program gives searches for the past including within one month. Keyword research is the most import part of the websites or blogs and without it many will fall flat and instead of obtaining high rankings they will even loose the current rank also. The main goal of any website is to obtain high rank in a search engine like Google. A software like keyword research helps to automate the task of finding the right keywords, including similarly related keywords for you.

An overview of keyword research software:

Most SEO experts use freely available Google Keyword Software program. There are many keyword rank checker software programs which will give you valuable insight on how your content is ranked by the search engines. Also there are software programs which suggest keywords. Google also provides this information technically in its Google Keyword Software program for Adwords. There are many link analysis software programs available which determine which links are bringing traffic to your website. You can automate this tasks which takes hours of research in this area.

An overview of traffic analyzer software:

Traffic analyzing mainly involves finding out from where traffic is coming and the statistics of your audience. These programs will review traffic of your website and will give you updates on latest trends time to time. This will help you to improve in many areas of SEO. Remember one thing; all the analysis in the world does not guarantee you to improve your website's rank. This software program will help you analyze data quickly and efficiently to succeed in business.

An overview of article submission software:

There are many programs which can automate submitting to directories task. There are several programs available like WEBCEO which can help you in article submission but they are limited in functionality. For those who are new to internet marketing these are complicated software programs to master.

An overview of new evolution in Internet software:

There are products which creatively gains high page rank and automate backlinks to your website. This is very useful for getting a website indexed by the search engine like Google. This software automates and streamlines the tasks of promoting your website to get a high rank.

Copyright 2009

SPINX, Inc. - social networking website designers los angeles offers services like Organic SEO Services Los Angeles, Website Design Bay Area, Website Design San Diego & also across the globe.

Web Royalty, an internet leader in Website Management Services today announced their Trade-In Your Website special offer. Starting December 01st through December 31, 2009, business owners can trade-in their outdated website for a new Web 2.0 technologically advanced website with internet marketing and social networking functionality for 50% off their original website purchase price. Get the new Web 2.0 Technology Internet Marketing and Social Networking with Twitter, Facebook, and LinkedIn.

Small businesses are hugely dependent on their cash flow, says Web Royalty president, Nick Matyas. In the recent economic downturn, businesses had to cut costs and scramble for every penny of revenue they could get, Matyas continues. Advertising, marketing and sales took the brunt of business cutbacks. According to a U.S. study by the Association of National Advertisers, more than one-third of business owners plan to cut their advertising budgets over the next six months as revenue continues to shrink.

Cash-strapped companies are in an awkward position, says Matyas. Web technology and social networking are rapidly changing the dynamics of how businesses market, sell, retain and connect with clients and customers. The cost of traditional phone book and print advertising is becoming prohibitive. To make matters worse most business websites are obsolete and lack the social networking functionality to handle a successful internet marketing campaign. It is difficult to get high search engine ranking with an outdated website. They cannot be optimized to drive traffic internet users for conversion into customers and revenue. Updated websites translate to top notch marketing and sales.

Web Royalty will completely re-engineer your business website with the latest Web 2.0 technology internet marketing, social networking and other important features such as event calendar, blog, company news, newsletter signup and content management system for 50% off the original price of your existing website. Some restrictions apply. At Web Royalty, we don't sell websites, we manage your Internet Success!

Visit the Web Royalty website http://www.webroyalty.com for more details.

For many businesses, moving into the e commerce industry can be a daunting process. Not only is the design of the website crucial, but you also must ensure that you are getting your site noticed by optimizing it correctly. This can be a very tricky process and it can sometimes be very tricky to determine how users are taking to your site and where key problem areas are. Google Analytics is a free internet application which provides a variety of tools to generate a variety of information about visitors to your website.

Once you have created an account for your site on Analytics, there are a selection of tools made available to you. Some of the most useful are available in the dashboard view where you can monitor the trends of use of your site. It contains charts displaying vital information about site usage. This can display information from several months to just a single day allowing you to measure total number of visits, page views and average time spent on the site. It also allows you to track the bounce rate (users jumping straight to another site on reaching yours, and the % of visits which came from new visitors.

Furthermore, you can trace exactly where (geographically and internet methods) your visits are coming from as well as which of your pages are receiving the most views. Through all of these informative features you can determine what is popular or unpopular about your site and to an extent determine who your demographic is.

These only constitute the basic aspects of Analytics. You can tailor certain aspects of Analytics so that it provides invaluable feedback such as alerts. Alerts allow you to select certain aspects of your site of advertising campaigns, and get Analytics to provide feedback once they have reached a set goal. For example, it can alert you once you have reached a target number in an ad campaign.

Goals are an extremely useful feature as they allow you to set up funnels to track how successfully users are navigating through key areas of your site (i.e. shopping basket) to the ultimate goal page, transaction complete. For any ecommerce site the key aim is to get as many users to this stage as possible. Payment gateways play a vital part in internet sales because of this and a vital process in getting a successful sales business up and running is to secure a good payment service provider. By creating funnels you can determine at what pages of the site the most users are dropping out. Through this useful feature you can adjust your site to improve sales without having to go through extensive trial and error.

There are many other features available in Analytics and it is worth looking into whether you are looking to improve your site, or are just getting your business online.