Web Programming

Get-Simple CMS – A Non-MySQL, XML Data-Based Content Management System (CMS)

150 150 rhecht

get-simple-logo-screenI have been using WordPress for building most of my websites and plan to continue doing so. It has become a very robust platform that can do many things. However, I find that with the robustness, WordPress can bog down the page load time on a shared hosting server, especially on Godaddy. The requirements on a MySQL database can cause a sluggish, overloaded MySQL server to slow down an otherwise-perfectly fast site.

Enter a CMS that utilizes XML files for data that’s not as robust as WordPress but “does the job.” I recently was introduced to a CMS called “Get-Simple CMS,” and am hooked. Get-Simple is a very lightweight Content Management System (CMS) that is relatively limited in features. However, it requires no MySQL database and is already looks like it has the basic array of materials for a CMS. It has a photo gallery, basic shopping cart, SEO plugin, custom SEO-friendly URLs, a WYSIWYG editor, an XML sitemap, a contact form, and more. It’s also very easy to theme from any HTML theme you choose. What’s more is that it loads very fast.

I strongly recommend Get-Simple to anyone looking for a simple 5-20 page site with some “kick.” I’ve been using it for my personal site and so far like it’s functionality, though again, it’s not as feature-rich as WordPress.

For more XML-based Content Management Systems, visit the following links:

Top Best Useful Infographics about HTML 5

150 150 yitzchoklevine

Everything in this Internet world is fundamentally based on web pages. Web pages are like the bricks that constitute the vast world of Internet we see and use often. Now, web pages can be active or static. Regardless of the type of web pages, it is absolutely granted that HTML is used in extensive manner to format and design the pages. Hypertext Markup Language is what HTML stands for and this language and its derivatives are mainly responsible for the decorating part of any web page. HTML 5 is one of those derivatives of HTML and HTML 5 is used more often these days as it comes with a variety of facilities.

We will now delve into those facilities by pondering over the best infographic about HTML 5.

HTML 5: Past, Present and Future

This infographic can be found on internet. It mainly depicts the development timeline of HTML 5. The past is the origin of HTML itself and it goes back to 1991 when HTML was officially documented and released. Then through the development of CSS and enhancements of HTML with versions like HTML3 and HTML4, the path of development of HTML 5 was paved. 2009 was the year when HTML 5 was released with its official documentation. The future of HTML 5 is almost certain to be bright. Browsers like Firefox and Chrome already fully support all the extensions of HTML 5 and it is only likely that all other browsers will follow suit. Newer versions of Internet Explorer are supposed to have built-in support mechanisms for HTML 5.

Why is HTML 5 Developers’ and Designers’ First Choice?

This infographic mainly concentrates on the need of HTML 5 and its advantages. The hitch of HTML 5 was that most browsers had not been supporting all the features of it. But as time goes by, all the browsers are starting to support them. Mozilla Firefox and Google Chrome are leaders in that aspect. A survey of modern day applications has estimated that by 2015 80% of all mobile applications will be using HTML 5 for their designing part. Various platforms including Windows OS, Android, Mac OS X and others are already providing built-in support functionalities for HTML 5. Also in comparison with its rival development frameworks like Silverlight, Flash, HTML 5 is comparatively cheap and more adaptable. As HTML 5 is non-native and open source, most developers and designers prefer this.

Some important and wonderful features of HTML 5

A primary feature for HTML 5 is that it incorporates platform independency. An application, built on and with HTML 5, can be run or executed on any smartphones or devices. HTML 5 actually accelerates the AJAX revolution. It is more suitable with Javascript and Jquery. It provides simple tags for audio, video and animations. The example for this could be that most YouTube videos can be played via HTML 5 player. HTML 5 provides section and article tags that can make an easy-to-build blog template. Canvas tag enables rendering of dynamic images on the fly. This is immensely important for web-based games and drawing applications.

Like any other development, HTML 5 has its disadvantages too. Those mainly include the non-support functionalities of most browsers. But this is evident from the opinions of developers, designers and users that HTML 5 is definitely the way to go now.

 

Top 5 Reasons to Become a Web Developer

150 150 rhecht

Top 5 Reasons to become a Web Developer

1. Average salary: $82,000+*

You’ll be rewarded handsomely for your awesome developer skills.

2. If you’ve ever dreamt of living in cities like San Francisco, New York, Chicago, Seattle, Atlanta or Philadelphia web developers are in high demand in these major hubs and well — nationwide!**

3. Have an idea? Just build it. It’s that simple.***
Think Instagram, Facebook, DrawSomething, or Udemy 🙂

4. You create the future. Think about the impact technology has on YOUR life. You can be a part of creating life-changing products and online services.****

5. Let your right and left brain unite. Web development requires high levels of creativity and structured thinking. You’ll finally get those unused synapses firing.*****

Summary: Get paid to build awesome products! Turn your pipedream into a reality by learning how to code it yourself.

Splash-on-Cold-Water Comments by Rafi

*= After a high amount of experience and demonstrated ability to manage web projects and people. Lots of stress and overtime hours, too.

**=These jobs are in demand if the desired web scripts cannot be found in India or Sri Lanka.

***= Just build it, but find a way to earn funding while building it. Sophisticated web programs can take an enormous amount of hours to complete, and if you’re doing it yourself with no one to support you (i.e. not living at home), it can be difficult. Also, you need to find people to buy into your “awesome idea.”

****= High levels of creativity, unless you’re being managed by someone who wants a program done in a specific manner. Also, most people are either very strong right-brain or left-brain, but rarely both.

Interested in learning more? Here’s how coding languages stack up when pitted against each other.

Some courses you may be interested in: 

Become a web developer from scratch

Learn Python the Hard Way

Become a Certified Web Developer

Learn Ruby in Ten Easy Steps

Solution to Annoying WordPress Error Warning: Invalid argument supplied for foreach() wp-includes/query.php on line 2762

150 150 rhecht

Initial post by Blackspotradish, this saved me hours of frustration!

This was an annoying bug on one of my wordpress + buddypress for a while and the fix is amazingly simple :

Edit your wp-includes/query.php around line 2762

// Always sanitize
foreach ( $this->posts as $i => $post ) {
    $this->posts[$i] = sanitize_post( $post, 'raw' );
}

and replace by :

// Always sanitize
if ( $this->post_count > 0 ) {
    foreach ( $this->posts as $i => $post ) {
        $this->posts[$i] = sanitize_post( $post, 'raw' );
    }
}

Create Joomla Super Administrator using SQL

150 150 rhecht

Original post courtesy of projectamplify.com:

There are a number of reasons why you may need to re-create a Joomla! super administrator, most of them are to get you out of trouble if your main Joomla! “admin” account has been corrupted or changed.

Recently we installed an Admin content restriction extension into a clients project at their request. Needless to say it was not well designed and fried all super admin logins! So we thought this information will be bound to help someone out!

Here is how to create a new user in Joomla! 1.5 manually, using the database management tool, phpMyAdmin. (For those who want to know how to use phpMyAdmin tool, it is a tutorial in itself so search for it and thee shall find!).

There are a couple steps involved as the database contains user information spread over a number of tables so we will run 3 segments of SQL code into the “Insert SQL” tab in phpMyAdmin.

Step 1

Create the new Joomla! User

REPLACE INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES ('60', 'Admin2', 'admin2', '[email protected]', '21232f297a57a5a743894a0e4a801fc3:abcdefghijklmnopqrstuvwxyz012345', 'Super Administrator', '0', '0', '25', '2000-01-01 00:00:00', '0000-00-00 00:00:00', '', '');

The code above creates a new user with ID number 60 and the name set to admin2.

Step 2

Create an ARO object out of the new Joomla! user

REPLACE INTO `jos_core_acl_aro` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES ('8', 'users', '60', '0', 'Admin2', '0');

This creates an ARO object with ID number 8. Note that the ‘name’ field must match the ‘name’ field in Step 1

Step 3

Next you will need to map this ARO object to the Super Administrator group, which by default is group ID 25:

REPLACE INTO `jos_core_acl_groups_aro_map` (`group_id`, `section_value`, `aro_id`) VALUES ('25', '', '8');

The user is now ready to login using “admin: admin2, password: admin”. We use the REPLACE instead of INSERT function above because the query will fail if the database record already exists.

Hope this helps!

Setting Up a Social Video Website Like YouTube – Requirements

150 150 rhecht

Image courtesy of TheCinemaSoldier.com: http://www.cinemasoldier.com/articles/2010/8/5/heres-a-great-parody-of-the-social-network-called-the-video.html

Even in 2012, people still want to set up their own niche video streaming websites to compete with YouTube. However, too many run into too many issues. This post attempts to cover the basics in what’s required to run a fully functional social video website.

The Insides

1. Script

Having a strong, as-bug-free-as-possible script is key. The script ideally should be set up in a modular, clean manner that can be extended. Building it in an object-oriented manner and, if possible, utilizing a framework like Zend or CodeIgniter is important as the work can go from one programmer to another. You do not want to be held hostage by your coder which unfortunately is all too common.

2. Fast, Powerful Web Server

This cannot be emphasized enough. One of the reasons why YouTube is famous is because, no matter how many visitors go onto YouTube, YouTube never seems to crash. Google has arguably the most powerful servers in the world and therefore they can afford to run YouTube in a manner where it won’t crash. That said, somebody starting out a non-revenue-generating website needs to realize that a powerful web server starting out will cost some nice dineros. On the other hand, starting out with a shared web server will lead to site slowness and frequent crashes, which in turn will alienate your user base. I honestly don’t have a middle-ground solution here.

What I will recommend though is that the web server for the video website uses Lighty rather than Apache. It lacks the ability to dynamically generate SEO-friendly URLs via an .htaccess file, but it’s wicked fast in processing.

3. Video Streaming/Storage Server

You need storage space to host your videos, so why use your web server to not only process the script but hold all those files? Having files stored on a cloud server (think Amazon Cloud) will help reduce lags in server processing, and it also makes things easier if/when you decide to switch to a more powerful web server (you don’t need to move ALL the files over in the process).

Another option for storing video files is on an RTMP server. If you are super-smart, you can either rent an additional server and set it up by yourself, or, hire a third-party stream service to do the hard work for you.

A third option is to have a server where the video is split up into thousands of 10 second clips, each successive clip loading after the previous one. This is how many streaming sites are able to load videos quickly rather than wait for the entire video to load at once.

Marketing

4. SEO-friendliness

Let’s be honest here: Any time you need something, where is the first place you go to? That’s right, Google. Google this, Google that. Google, Google, Google! Get the point? To reach one of the largest audiences in the world already asking for information (and not the annoyed types), you need to be on the front page of such a platform. This is where SEO comes in.

While SEO-friendly URLs might pose an issue if you’re using Lighttpd for wicked-fast processing, you can still optimize things like auto-Title and H1 tags, as well as an auto-meta keywords and description tags areas. Video transcripts are also popular as it adds content to the page. If the content is SEO-able, that helps your video pages tremendously.

5. Social Interaction

For users to stay beyond the first time around, there needs to be some form of social interaction on the site. This includes comments, sharing on Facebook, Twitter, and Pinterest, and email updates whenever new comments are posted on your videos.

Money

6. Ways to generate revenue

In the end of the day, to be a somewhat-successful website you need a way to generate revenue to at least pay the bills. If the website is somewhat successful you can start to leverage Google Ads. Alternatively, you can also charge separately for custom Ads which people would pay monthly.

Another way to generate revenue is to create a “donate” button with “top donators” showing who donated the most to the website. That way there is an incentive to give more.

7. An alternate source of income starting out

Last but not least, you need to have an alternate source of income to start out, at least to feed your videos habit. Sorry to splash cold water on your face, but you will have a VERY hard time finding an investor trying to invest in another YouTube, a platform which has already matured. And yes, the excuse of “YouTube got $1.5 Billion” worked in 2005 when few others were doing it and it was “new.” It will not work in 2012 or beyond. If you’re really vested in this, fund it yourself somehow.

How to Install & Setup WordPress Multisite

150 150 rhecht

Since version 3.0, you  had the option to activate “WordPress Multisite,” which is great considering that it allows you to run as many sites as you want from a single WordPress installation (whereas previously it was one website per WordPress installation).

If you run a lot of sites, or you have lots of clients that you keep websites for, it can be a lot of maintenance to go to each one individually and update them on a regular basis. With WordPress Multisite, you can update all the plugins and themes with just one click, which is a huge time-saver. I currently run a network of about 20 sites and it makes it so much easier to keep everything updated. You could have a much larger network of sites and it would be no more difficult to update them all. Not to mention that, when you have a bunch of WordPress sites running on a single web server, it can slow everything else down. Having only one installation means less resources are being drained on your web server.

The benefits of WordPress Multisite are massive and I thoroughly recommend it to anyone who wants to run more than one site, unless there is a very good reason for keeping the sites separate from one another.

If you find this tutorial a little too daunting,  hire me to do it for you. However, if you’re comfortable fiddling with code, here is how to do it.

WordPress Multisite Step 1: Back Everything UP!!!

You’re about to be making some significant changes to your core files and in particular, your database, so be sure to take a thorough backup of both even if you automate your database backups. This is standard procedure and “I pity the fool” who doesn’t back everything up prior to updating core files.

WordPress Multisite Step 2: Allow Multisite Installation

To avoid dangerous mistakes, you need  to intentionally enable the option to even install multisite. Fortunately, it doesn’t require much of you. Hunt down your wp-config.php file which should be in the root of your WordPress installation, find the “stop editing” line and insert the following line just above it, like so:

define('WP_ALLOW_MULTISITE', true);

/* That's all, stop editing! Happy blogging. */

WordPress Multisite Step 3: Setup the network

Now when you refresh your WordPress admin, you’ll see an additional option under the Tools menu called Network Setup. Head there. You’ll be presented with a few options, like what to call your network and the email address of your Super Admin (see A Quick Guide to User Roles). You may also be presented with the option to choose between sub-directory or subdomain installation. Unless you desperately want a subdirectory installation, I would strongly suggest subdomain installation. Fill the options out and hit the big old install button (but only if you promise me that backed up your site first).

WordPress Multisite Step 4: Enable the network

Now that your database is ready to get the network going, you need to edit a couple more files to make the network active. Fortunately, the clever WordPress monkeys made it very explicit and easy for you to understand.

After setting up the network, you should be presented with a page that shows you a few blocks of code. Enabling the network involves adding some code to two files: wp-config.php and .htaccess, both of which should be in your website’s root folder. The code for your wp-config.php will look something like the code below:

define('WP_ALLOW_MULTISITE', true);
define( 'MULTISITE', true );
define( 'SUBDOMAIN_INSTALL', true );
$base = '/';
define( 'DOMAIN_CURRENT_SITE', 'wpsites.rafihecht.com' );
define( 'PATH_CURRENT_SITE', '/' );
define( 'SITE_ID_CURRENT_SITE', 1 );
define( 'BLOG_ID_CURRENT_SITE', 1 );

/* That's all, stop editing! Happy blogging. */

WordPress Multisite Step 5: Add a Wildcard Subdomain (optional)

At this point, you should also enable a “wildcard subdomain” in your hosting account, which will allow WordPress to use whatever subdomain it needs to create all the different sites. I’m going to show you how to do this in cPanel, since this should be available to most of you (especially if you use HostGator).

Once logged in to cPanel, hit the Subdomains icon. You’ll then have a small form that will enable you to add a new subdomain (above any subdomains that might already exist). Create a new subdomain of * on the domain of your WordPress master site, setting the document root as public_html, or wherever the root of your website is, if it’s not there.

Once you’ve successfully done that and added all the code that WordPress asks you to, you’ll need to login again. There should be a link at the bottom of the Network setup page. Click there and log back in, where your new multisite-enabled site will be waiting for you.
Note: this is optional as not every host, such as GoDaddy, will have the option to add a wildcard subdomain for security reasons. In that case you can always just do “wpsites.rafihecht.com/foo.”

WordPress Multisite Step 6: Tweaking your settings

How you set up your network will largely depend on how you want to run it. For example, on my network, I don’t want to allow anyone to be able to create their own site, though that is an option if you want to do that. I also don’t want to limit what kind of files can be uploaded (since I’m in charge of all the sites), or what size they can be, though if you have a more open network, you may want to put some of those restrictions in place.
To modify your network settings, you’ll need to go to the newly created Network Admin area; your original WordPress site will continue to have it’s own admin area, but there will be a new overarching Network Admin Area where you can install themes, plugins and add new sites and users from. To access it, you can go to the admin bar and find it under the My Sites menu. You can also go to yourdomain.com/wp-admin/network to get to the Network Admin area.

Once you’re at the dashboard, you can find the network setup page under Settings > Network Settings. Just have a good look through at everything and set up the options as you see fit for what your network needs are. You can of course change them if they are too strict or lax in the future.

If you’re going to disable new site registrations, so that only a Super Admin can create new sites, you might want to add another declaration to your wp-config.php file, just below all the ones you pasted earlier. This will redirect people to a specified site if they try to access a site that doesn’t exist (presumably your master site). For example, since I have the following declaration in my wp-config.php file, anyone trying to access wpsites.rafihecht.com/rjhsolutions, which does not exist, will be redirected to wpsites.rafihecht.com:

define( 'NOBLOGREDIRECT', 'http://wpsites.rafihecht.com');

WordPress Multisite Step 7: Adding a new network site

Now that your network is all set up, you’ll probably want to add your first network site. Doing so is a fairly simple process. Go to the Add New option under the Sites menu in your Network Admin area.

The process of adding the site is incredibly simple. Just three pieces of information are required of you; the site address, which is where your site will be accessed from. For example, if I was going to create a site at wpsites.rafihecht.com/parties, I would simple insert parties in this field.

You’re then asked for the Site Title and finally the Administrator’s email. If you want to add yourself as the site’s admin, just enter the same email address that you used in your existing profile. Alternatively, you can set it as someone completely new.

Once you click on Add Site, it will create the site for you and you are then given the option to go to the Dashboard, or Edit the Site. Simple huh!?

How about using custom domains for my new sites?

As you’ll have noticed, everything up to this point has allowed you to create new sites as subdomains to the Network Master Site, where you installed Multisite. But what if you want to use custom domains for your new sites? For example, I have WordPress Multisite installed on rafihecht.com, but RJH Solutions is a network site from that installation, even though it’s domain (doitwithwp.com) is not a subdomain of rafihecht.com.

Well, I’ve written a tutorial that walks you through that process. If you’ve gotten this far, it’s only a small step to be able to use individual domains for your network sites. Go ahead and read How to Set Up Domain Mapping for WordPress Multisite.

Content of this part of the blog post was courtesy of doitwithwp.com.

Meta-tutorial: How to Disable Multisite Once it’s on

Let’s say you made a mistake during the enabling process, but only figured it out in the end. Perhaps you realized after setting it up as a subdomain network that your host doesn’t have wildcard subdomain support and now you’re out of luck. Perhaps you would only like to run through the process again, to show someone how to do it or to work up a tutorial (like me!). Here’s how to un-do the network:

Only undo your multisite setup if you’re comfortable looking at things like this. Otherwise, just restore from your backups.

  1. First you will want to remove the lines you added to wp-config.php, so that it appears as it did before you started the network setup. Since these lines are all right next to each other, this should be simple enough.
  2. You will need to remove what you added to your .htaccess file as well, returning it to its previous version. If you have made no further customizations to your .htaccess file other than what you did with the network setup, than you can simply delete the .htaccess file.
  3. Delete your /blogs.dir directory within the /wp-content folder. This held all of your site’s uploads (but not your primary site, those are still in /wp-content/uploads).
  4. Finally, you will need to remove a few tables in your database. Open up phpMyAdmin and delete the following rows: every wp_#_ row (these were created for each of your sites, and the number of them depends on how many sites you created) and wp_blogs,wp_blog_versions, and wp_site. This will remove all of the tables created during the multisite setup process.

Of course, since you made a backup of your site before enabling multisite, you can always revert to your old database and files if you need to. This is just another way to achieve the same thing.

You will know this process works when you log back in and the Super Admin menu is gone. Now you can re-create your network, or continue on in single-site WordPress bliss.

Content of this part of the blog post was courtesy of : http://wpcandy.com/teaches/how-to-enable-multisite

 

How to Set Up Domain Mapping for WordPress Multisite

150 150 rhecht

So you’ve gone through setting up WordPress Multisite, and now you’re ready to start setting up new sites in your network. Only trouble is, you want to use unique domains for your sites instead of using subdomains of your main installation. Well, with a little extra effort, it’s entirely possible.

Install the required plugin

There’s an excellent plugin that will do most of the hard work for you. Install the WordPress MU Domain Mapping plugin and Network Activate the plugin.

Before you proceed any further, there’s a couple of things that you have to do manually. Access your site’s installation, either using FTP or your hosting Control Panel and go to wp-content/plugins/wordpress-mu-domain-mapping/ and locate the sunrise.php file. You must move this file up two levels, to the wp-content folder.

Once you’ve done that, find your wp-config.php file and add the following definition. Add it below your previous multisite rules (i.e. above the “Stop editing” line):

define( 'SUNRISE', 'on' );

Domain-Mapping.php
Move “domain-mapping.php” to the mu-plugins” folder at the wp-content “root” level. This is important as certain web servers won’t render the mapped URLs correctly unless this is done.

Configure the plugin

Now your plugin is correctly installed and when you head to the Network Admin area you’ll notice a menu under Settings called Domain Mapping. Click on that so that you can configure the plugin.
The main thing you need to be concerned with is setting the IP address of your server. To find this, log in to your hosting cPanel and on the main page, you should be able to see the IP address of your server in the information on the left-hand side. If you can’t find the IP address, you can get in touch with your host, or use one of many available free tools to convert the web address to an IP address.

If you fill out the IP address, you can ignore the CNAME field. Then, the remaining options are as follows:

  1. Remote Login – Means that logging in to one site will log you in to all sites.
  2. Permanent Redirect – This will create a 301 redirect on your subdomain (as opposed to a temporary 302 redirect) – highly recommended if the domain mapping will be permanent.
  3. User Domain Mapping Page – Creates a new menu in each site which allows that site’s users to map their own domains (instead of being controlled by the network’s Super Admin only).
  4. Redirect administration pages – Means that all administration pages will be kept on the original site’s domain, instead of on the mapped domains.
  5. Disable primary domain check – Means that multiple domains pointing to a single site will be treated as separate sites, instead of redirecting all domains to the noted primary domain (not recommended).

Map domains to your network sites

Now you’re ready to set up the domain for your new sites. You should have already created the site that you’re wanting to map your domain to. At the moment, it will just be a subdomain of your main site – it doesn’t have to be set up or looking perfect – it just has to exist.

Once you’ve purchased your domain, make sure that you set the nameservers for the domain to your hosting account’s nameservers. Then, go to your hosting account cPanel (which all good hosts, including HostGator, should have) and find the Parked Domains option under Domains.

Once in there, add your new domain as a parked domain, making sure that the document root shows as the same folder as your WordPress installation (probably /public_html). If you can’t do this (because you don’t have cPanel for instance), you need to set an A record on your new domain that points to the IP address of your hosting server (which you found out earlier).

Now is the final step. You’ll need to know the “Site ID” of the site you want to map the domain to. If you click on Sites > Sites in the Network Admin, and click on the name of the site (as if to edit it), the URL will include the site ID. It will look something like this (where the Site ID is 2 in the example):

http://wpsites.rafihecht.com/wp-admin/network/site-info.php?id=2

Now back in your Network Admin, go to Domains under the Settings Menu. You’ll see a section for adding a new domain, with three fields: one for the site ID, which you just found out, the domain name and an option whether to set the domain as the primary domain for the site. This is because you can set more than one domain to point to a single site, so you want to specify which one should be the site’s primary domain.

Once you save that, with any luck (and assuming that DNS changes have propagated), if you go to your new domain in a web browser, you should find yourself at your new site.

I’ll grant you that it is a little bit fiddly, and it would be nice if WordPress would bring this into the core and make it a bit more of a fluid process, but once it is set up, you never need to look at it again; the plugin will keep serving up the right site at the right domain.

Did you manage to get through the setup process? Did you encounter any problems? If you need any help getting through this process, you can always ask a question here, or hire me to do it for you.

 

Content of this part of the blog post was courtesy of : http://www.doitwithwp.com/domain-mapping-for-wordpress-multisite/

REPLACE: Find and Replace Text in MySQL Database Using SQL

150 150 rhecht

The syntax of REPLACE is REPLACE(text_string, from_string, to_string)

update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, ‘find this string’, ‘replace found string with this string’);

update client_table set company_name = replace(company_name, ‘Old Company’, ‘New Company’)

Another example:


SELECT REPLACE(‘www.mysql.com’, ‘w’, ‘Ww’);

Above statement will return ‘WwWwWw.mysql.com’ as result.

Great. Joe Blo Can Build a Website. So What?

150 150 rhecht

Once upon a time, building a website was an arduous task. One would need to painfully go through thousands of lines of code just to code a professional looking, yet static, HTML site, or even a Flash-based website. Today, many of the processes in creating a simple, standard website are automated. With a simple CMS (Content Management System), creating a site with a standard theme takes minutes, if not hours. The real work lies in the custom design should the client choose to go that route.

However, anyone with some technical know-how can set up a website for someone. The question is, how can someone drive traffic to ones website?

The first step is to identify where most website visitors come from. Most people, when they want to find a product or service, will search on Google or Bing to find the product they’re looking for. Social media buffs spending their time on Facebook or Twitter may visit sites relating to interesting things people post, so that’s important to note as well.

Therefore, not only building your website, but building it cleanly and correctly the first time around, plus utilizing various strategies to drive traffic to your website in a most cost-effective manner is important. Not too many joe blo’s can claim that!