Creating a MySQL database for WordPress

Creating a MySQL database with cPanel, which is included in all of hosting plans(may differ with different hosting providers), can be easily accomplished.

Create a MySQL database on your hosting account, you need to log in control Panel. This can be done by either using the Go to cPanel button in the Customer Area My Accounts section or by entering one of the following URLs in your web browser:

http://yourdomainname.com/cpanel

 

create database with cpanel

Creating MySQL Database with cpanel

In order to connect a new database you need to enter the desired name of the database in the New Database field and click on the Submit button as shown below:

where to enter details to create wordpress database

enter your details to create wordpress database

Hint enter keyword into Table Prefix e.g. wp_horseriding to avoid spam emails. Spammers search the internet for newly installed wp_ databases. And make note of Username and password.

Wordpress Training Teaching full install

WordPress Login Screen

A confirmation screen will be displayed, informing that the database has been successfully created.

Next Run the install

WordPress Login Screen

Planning Your Website

The difference between a disappointing website and a website that becomes the life line of your business? Simple and it all in the planning.

Now lets start we are going to spend some time thinking about our goals and developing the plan.

This phase includes everything from planning our content to creating a budget

Learnables:
  • Defining Your Business Website
  • Content Planning what will be on it
  • Diagram Your Website
  • Have site Budget

What is the purpose of your website.

With WordPress you dont need techanical skills or know-how to use it.

But while WordPress is simple and taken the work out of making a site, the one thing that you still have to do, planning behind your site.

For your site to be an effective business tool, it must reflect the core goals and missions of your company. Whereas many of us start the planning of a site by looking at the available WordPress themes and letting those designs sway our decisions, we really need to be starting from a more strategic point of view and making decisions about themes, plugins etc, based on the bigger picture.

1) What are the values and overall mission of your company?

fundamentally your website must be a reflection of the driving force behind your business. What are you trying to convey? What is it about your business that keeps you motivated to run it every day?

What are the business goals of the company?

Website development to marketing strategy. Get clear on what the specific goals of your company are. Your goals may change over time, so it’s good to review them periodically and make sure your site is still in alignment with your business goals.

Who are your desired clients?

Provide a certain service or make a certain product and do that well. So focus on catering to the customers you really want to attract to ensure you are building a business and client base that will serve its purpose.

What do you want visitors to do at your site – your call to action?

 

Have a Clear, defined serving you and your purpose. The more clear your sense of direction, the better result you will get out of your site.

Understanding WordPress and SEO

WordPress Training. Pinguis Website Training, Irish WordPress Experts.

We provide Training in WordPress and seo.

WordPress was at first a blogging platform and later a good content management system but now its a great c.m.s. Ideally suited for business owners and bloggers who are looking to be able to manage and update their own wordpress website, when ever they want.

This website is an example of the level of understanding of WordPress, its a multisite wordpress install. With several sub-domains installed and separate websites on this domain. All websites are on page one in their chosen category for searches. And there is a lot of sub domains to install.

Contact 087 754-7098

How to find the right web host, How to install WordPress, Getting to know the WordPress Dashboard, Creating Content: Posts vs. Pages and when to use each, How to write a WordPress post, Using WordPress themes, How to use WordPress widgets, Using WordPress plugins, How to create custom WordPress menus
Getting Started the Install, and Planning Your Website

More than 25% of website are now designed with WordPress and its free. And more business owners are requesting that they have full access to their own website’s back-end, allowing them to update and change their website when and how they choose.

They wish to add in a new page or blog post, delete a part of a certain page or change the entire theme and look of their website.

Early Content Management Systems (CMS) were hard to use. Even adding in something simple such as a new line of text was hard work. WordPress  to the rescue, its a platform for building and updating websites.

What is WordPress?

WordPress started off as a blogging platform which allowed users to share with the world their passions, hobbies and images. Businesses quickly noticed how easy and straight forward this system was to use and quickly adopted it as their platform of choice on which to build their business website. In the spirit of WordPress we provide free WordPress Training in Kerry and Cork

Why use WordPress?

Why WordPress is a winning solution for your business website:

1) Extremely easy of use – If you can work Microsoft Word or send an email then WordPress will be a breeze to learn.

2) Millions of businesses around the world now use WordPress. With a massive community online assistance is always online with D.I.Y. enthusiasts waiting to help you. Is it the #1 choice of Content Management Systems available today.

3) Safe and secure  WordPress is updated regularly which makes it harder and harder for hackers and bad guys to break into your website.

4) It’s free  and governed by GPL a body, responsible for free open source software – free to download and use with no monthly or yearly costs.

5) It’s highly customisable – With thousands of free templates or Premium WordPress Themes, the choice is yours. With 100’s of thousands of themes to choose from there is the perfect layout and look for you – available free or to buy today.

WordPress Design, Training and SEO

 

� Character Error in WordPress

Different (special) characters showing on all pages and posts even navigation. Lately i have noticed some character showing in my WordPress website design blog. These characters are appearing when the ” , ‘ and space character is used

I have installed some plugins in the hope of speeding up the website. But to my dismay it has not worked and left all these little guys(basically everywhere).

After reading up on solutions i realised that the plugin has changed my wp-config page see below for a sample
In my wp-config there was characters at the start of every line an upside down question mark ¿
This was then translated to � on the front end or my live website.

 
¿// ** MySQL settings - You can get this info from your web host ** //

¿/** The name of the database for WordPress */
¿define('DB_NAME', 'database_name_here');

¿/** MySQL database username */
¿define('DB_USER', 'username_here');

¿/** MySQL database password */
¿define('DB_PASSWORD', 'password_here');

Upon reading further i realised it was a character miscoding error.
How to fix character miscoding errors.

Fixing the Character Encoding Mismatch Problem in WordPress

Step 1) Open the ‘wp-config.php’ file in a text editor such as textwrangler or BBEdit even notepad (the wp-config.php file can be found on the directory where you installed WordPress).

locate the wp-config file with wordpress

Where to locate the wp-config file with wordpress

Step 2) Find the following two lines and comment them out:

define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');

They should look like the following after you comment them out:

//define('DB_CHARSET', 'utf8');
//define('DB_COLLATE', '');

Step 3) Now upload the updated ‘wp-config.php’ file to your web server.

Write, Edit and Publish Content WordPress

Working with WordPress pages or posts.

How to Write, Add a New Posts and use posts Features

Writing a post or adding content in a WordPress Website can be as easy or as hard as you make it. Their is way around the large learning curve it involves, having said that you have to be prepared to learn and learn from mistakes, many website owners are sick of relying on website designers to upload their content, make small grammatical alterations, spellings corrections and of course dated content with maybe years old, with speed regulations change, that’s not good enough to base your business on.

This would usually involve a phone call or email to the designer, a wait and they they might or might not agree to the changes proposed changes, after this the website owner usually puts up with the changes. Trying to avoiding conflict with the webmaster.

 

Then, they hear about this great software that allows them to login to the back-end and make the changes straight away, and they feel they are able and get their static old Website converted to WordPress.

The beginner finds the interface a bit overwhelming. We will show users the necessary features in order to add new posts so that you can use the features available. It truly is a complex as you want it to be.

 

Our WordPress Posts and Pages layout starts with the Content Editor and a Title and content area.

Title and Content Editor are the most noticeable areas on the Add New Post Editor.

Title and Content area on WordPress Posts ScreenYours might look slightly different depending on whether you are using the visual or the text editor.

You can switch between visual and text editor while writing a post, but we do not recommend switching as this could mess up your post’s format.

Visual Editor is the beginners text editor with buttons and a visual layout for content area. On the other hand, text editor is a plain text editor where you can actually see the HTML or write your own code.

The first text area on the top is where you add the post’s title. If you are using SEO Friendly URL structure, then WordPress will auto generate post URL based on the title. You can edit the URL by clicking on the edit button. The Post URL or Slug marked above.

The content area is where you will write your post. Use the formatting buttons from the toolbar or use one of the many keyboard shortcuts available which will speed up your writing process. We have use the B for Bold formatting option above.

In the bottom left area of the content editor, WordPress will show you the word count for your post.

One of the beauties of WordPress is as you write the post, it automatically save a draft of the post. This auto-save is stored in your WordPress database temporarily and the date and time is on the bottom right of the screenshot above.

As soon as you save your draft or write more content, WordPress cleans up your autosaved draft and replaces it with the newer up to date one. This process ensures that you do not lose your content due to internet connection or any other failures.

The post editor shows your current draft and autosave status in the bottom next to word count.

Adding Images and Media

Between the title and content fields, there is a large Add Media button. Click on it when you want to upload an image or any other media to your WordPress post. This will launch the media uploader window.

Media uploader in the WordPress Editor

Clicking on the select file button to upload images or any other media to your WordPress site. You can also create galleries and video and audio playlists from uploaded files.

Tip: You can Drag and Drop media files.  Select more than 1 image to create galleries within your post. 

WordPress also comes with some basic image editing tools. You can to edit, flip vertically horizontally, rotate, and crop images in WordPress.

EditImages Screen Options WordPress

When Publishing a Post Your Options

WordPress post editor is divided into two columns. The column on your left contains the post title and content editor. On your right hand side, you have different meta boxes to configure post options.

The top most meta box in this column is labeled Publish. This is where all the publishing options for your posts are managed.

Save Draft button stores a draft of the post or page that you are working on. WordPress also auto-saves your posts as you write them, its better to save as draft for peace of mind.

Preview button shows a live preview of your post. You can use it to see how your post will look after publishing.

Status allows you to set a status for your post. WordPress automatically handles post status for drafts and published posts. Unless you are using a plugin to add custom statuses, you don’t need to worry about this option.

Click on the Edit link next to visibility to expand it. The first option under visibility will allow you to make your post sticky on front-page. Sticky posts in WordPress are like featured content that are displayed on top of all other posts.

The third option under visibility is labeled private. This allows you to privately publish a post on your WordPress site. The private posts will be visible to users who have the editing privileges on your site.

Click on the edit link next to Publish, and WordPress will display the time and date options. You can use this option to schedule posts or create back dated post in WordPress.

Move to trash allows you to delete a WordPress post. Deleted posts live under trash, and you can restore them if you need to for up to 30 days.

Finally, the publish button makes your WordPress post public, if your site is live your content is now too.

Adding Categories and Tags

You can sort your posts into categories and tags. The categories and tags meta boxes usually appear in the right hand column, below the publish button. Or click posts on the left hand side to reveal the posts drop down which includes categories and tags.

 

Categories and tags help you organize your content in a meaningful and browsable format. Not only your users can easily find your content, it also boosts your site’s SEO. See our guide on the difference between categories and tags and how to use them to sort your content.

Featured Image (Post Thumbnails)

WordPress themes support featured images or post thumbnails for it’s articles. Usually it is one of the last boxes on the right hand column on the post edit screen.

Click on this to set featured image link, and it will bring up the media Library or you can upload your media. You can select an image from a your previous uploads or upload a new image from your computer.

Pinguis Website Design are Experts in converting old dated, static websites to WordPress.

 

Below Options are for the more comfortable User

Screen Options dropdown next to help on the Top Right.

Some of the options on the post edit screen are hidden by default in order to keep wordpress cleaner and simpler for editing. These options are not commonly used by beginners. However, you may need them later, after editing your post.

Click on the Screen Options button on the top right corner of the page. This will show a menu with check boxes next to option names.

Wordpress Screen Options Top RightSome of the options will already be checked. You can display them by clicking on the checkbox next to an option name, and it will appear on your post edit page. Tip: check a box and find out down the page what it does.

Excerpts

Checking this box adds a meta box below your content editor. You can use this box to add a short summary or excerpt for your post.

Excerpt box on WordPress post editing screen

WordPress post editing screen Excerpt box

Ideally, you should display summary or excerpt for your posts on your site’s front-page and archives. Full content should only be displayed on the post’s single page.

Send Trackbacks

Send Trackbacks option allows you to notify other blog owners that you have linked to their content.

If another blog owner is running WordPress, then you don’t need to send them trackbacks. Your WordPress site will automatically send them a ping when you publish the post. Which notifys the administration of the post.

Custom Fields

This option will display a user interface for custom fields below your post editor. You can use it to manually enter custom information in your posts.

Custom Fields

Discussion

While comments are a great way to engage your audience, sometimes you may not want to have comments on a specific post or a page.

The discussion option displays a meta box below post editor to turn on/off comments and pingbacks for your post.

Turn comments and pingbacks off/on for individual WordPress posts

Since pages are static, most users want to turn off comments on them. You can do so by editing each page.

Once your WordPress site gets some reputation, you will start getting an increase of comment and email spam.

Turn off comments – unless you like spammers telling you what valuable content you have and how they would like to become a guest author on your website.

or email spam where they cant be bothered writing, so they post this

Hello,
How are you? Hope you are fine. I have been checking your website quite often ……

I generally turn all comments off across my blog with a plugin called disable comments

Slug

A slug is a clean title that can be used in URLs.

http://pinguisweb.com/how-to-write-post-edit-and-publish-content-wordpress/

WordPress automatically generates a post slug and displays it as the post URL directly below the post title. You can edit this slug by clicking on the edit link below the post title.

You can also enable the slug option from the Screen Options and edit your post slug at the bottom of the window by scrolling to the very bottom.

Options on the Yoast WordPress SEO Plugin

We have explained the default WordPress post edit settings. Many WordPress plugins will also add their own settings panels on the post edit screen.

Yoast WordPress SEO plugin adds its own settings panel. With a snippet of Search results preosented for you to edit. These are search engine snippets and the main reason people will view your pages after searching and clicking the results with yahoo, google or bing.

Yoast SEO Plugin WordPress

SEO Plugin WordPress

 
 
WordPress is a great Content Managment System, second to none with ease of use and flexibility. You have to play with it, learn from mistakes and not to be afraid to make more.

Pinguis Web converting dated, old static websites to WordPress.

htaccess index.html added by Plugin wordpress

This works for any wordpress directory.

If you have a WordPress website and have noticed that some thing has added index.html or a plugin has added it.

Example would be http://pinguisweb.com/about/index.html.

The code below will redirect to http://pinguisweb.com/about/ and drop index.html

try adding

RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteRule ^index\.html$ / [R=301,L]
RewriteRule ^(.*)/index\.html$ /$1/ [R=301,L]

to your .htaccess file

How to redirect subdirectory to url with htaccess file

 

This will redirect all references to Car-Sales directory to 
the car-sales file. 

RedirectMatch 301 ^/Car-Sales/.*$ http://pinguisweb.com/car-sales/

Improve Page Speed

Some tips on how to Improve Page Speed.

Use one of the below suggestions to improve your website speed.

CSS Optimization Test

Analyze the CSS delivery of your web page (ultimately your website).

CSS Compressor

Minimize CSS scripts for page speed.

Javascript Optimization Test

Analyze the Javascript delivery of your web pages.

Javascript Compressor

Minify your JS scripts to maximize performance.

GZIP Compression Test

Test whether your web pages have Gzip compression enabled.

Image Optimization Test

Test the image delivery of your website so you can improve it.

PNG Compressor

Reduce the file size of PNG images while keeping quality.

JPEG Compressor

Play with the quality and size of JPEG images to reduce file size.

CSS Sprites Generator

Save multiple images to a single image to make fewer requests.

Caching Test

Check whether and how your website files are cached.

Broken Links/Requests Test

Test your web pages for broken links and requests.

HTTP Requests Checker

How many HTTP requests do your web pages produce?

Base64 Encoder

Encode web files into a Base64 string to reduce HTTP requests.

Keep-Alive Checker

Check whether your website has keep-alive enabled.

Line Breaks Remover

Remove line breaks from your scripts to reduce file size.

HTTP Header Checker

Check the HTTP server header of a web page.

Taking these actions while not a big influence on page speed individually, do accumulate to that faster speeds.

Debugging WordPress Errors & Issues

Guide to Debugging WordPress Errors & Issues

Save

WordPress Update Services

WordPress Update Services are tools which are used to let other people know you’ve updated your blog.

WordPress automatically updates popular Update Services when you have updated your blog by sending pings each time you create or update a post.

Listed below are Ping Services WordPress uses:

http://rpc.pingomatic.com
http://rpc.twingly.com
http://api.feedster.com/ping
http://api.moreover.com/RPC2
http://api.moreover.com/ping
http://www.blogdigger.com/RPC2
http://www.blogshares.com/rpc.php
http://www.blogsnow.com/ping
http://www.blogstreet.com/xrbin/xmlrpc.cgi
http://bulkfeeds.net/rpc
http://www.newsisfree.com/xmlrpctest.php
http://ping.blo.gs/
http://ping.feedburner.com
http://ping.syndic8.com/xmlrpc.php
http://ping.weblogalot.com/rpc.php
http://rpc.blogrolling.com/pinger/
http://rpc.technorati.com/rpc/ping
http://rpc.weblogs.com/RPC2
http://www.feedsubmitter.com
http://blo.gs/ping.php
http://www.pingerati.net
http://www.pingmyblog.com
http://geourl.org/ping
http://ipings.com
http://www.weblogalot.com/ping

Update service URL’s are listed under “Update Services” under Settings-> Writing Settings

WordPress Address None www. or with www.

WordPress Address www. or none www.

How to get www. before your domain name on your WordPress Website.

WordPress Address none www. or with wwwUltimately, it doesn’t really matter which one you choose. The success of your website will not be determined by a www or non-www URL. The important thing is that whichever one you choose be accurate and consistent.

If visitors type to www.pinguisweb.com or chose to type pinguisweb.com they will still find the Number 1 “Website Design Kerry” website.

In fact when you visit www.pinguisweb.com, the www will not be displayed in the browser’s address bar.

Its assumed when you are searching the world wide web that www. is there.

As long as the domain name is identical there will be no problem with WordPress. Its written into the .htaccess file WordPress has Rewrite Rules to correct this.

To change to either on the left hand black bar go to settings and general. Basically its a matter of choice.

Just be consistent throughout.

Of course, WordPress changes everything when you go installing it in a sub domain and linking it back to you main domain.