thinking nothing...............!!
Fetch DEFAULT value from MySQL table or MySQL get DEFAULT value for Column or How to SELECT DEFAULT value of a field or How Can I get back DEFAULT values for Column names in a MySQL Table.
We can fetch the column names in a MySQL Table fairly easily by the simple command:
[bash]
DESC tbl_admin_modules;
[/bash]
If you have already created your MySQL database and table and suddenly realize that one or more table columns need to be modified, you can either drop / delete / remove the respective column and create new or you can alter the table. Altering of the table can be done using any MySQL GUI Tool / Editor like MySQL Query Browser (for Windows) or Sequel Pro (for Mac OSX) or using a MySQL ALTER TABLE Query. [Read more…]
With the advent of technologies like Cloud and Open Source launching your own self hosted CMS based Website or Blog is now nothing more than a series of operational activities which is why lot a surge of enthusiasm is seen among a lot of people from various professional backgrounds; be it technological or non-technological. Most of these Websites and / or Blogs are developed using WordPress with a free or premium theme as per the requirement of the user. I personally feel WordPress’s technological growth and tremendous community support are among the key reasons that more and more people are showing interest in launching their very own Website using WordPress.
One’s main goal for launching a personal Website is to build a strong social and online presence, yes of course there are social networking websites like Facebook, Twitter, Pinterest, Quora, Tumblr, etc to facilitate the same but they can never give you the same gratification or feeling of identity you get from your own Website.
Is launching your self hosted Website enough to make sure you are found online? Or guarantee of a strong online identity for you? The answer is… NO! You need the support of Digital Marketing, precisely Search Engine Optimization or SEO. But a Digital Marketer or SEO Expert doesn’t come for cheap, forget marketing agencies even an individual would cost you premium! Does that mean the end of your online identity dream? Of course not! There are few simple things you can do to make sure Google, Bing and other search engines are duly notified about your Website’s presence and their crawlers / bots visit your Website quite often which in turn will make your Website rank well in search engines.
SEO Tips for your WordPress Website
Navigation… A search engine friendly navigation is the most important thing for any website, make sure you have a well structured menu and permalink is turned on to make the URLs search friendly, click here for WordPress Permalink Settings. My recommendation would be to select the postname as permalink structure.
Content Optimization… Content is the King!… Might sound cliched but content still is the thing that works best. Make sure your content is unique and plagiarism free, not stuffed with keywords but contains a healthy balance of the same. Titles should be intuitive and represent long tail keywords. Try to cover common topics at the initial stage because that will increase your Website’s chances of getting found frequently… “Travel the world in 80 days” or “Write your first PHP program” or “Understanding ISO, Shutter Speed and Aperture” or “How to cook Dal fry” are some good examples of intuitive and search friendly content titles. Make sure you to use More and Nextpage tags to increase pageviews.
SEO
Yoast is the most popular WordPress plugin but I would never recommend that because it slows down your Website and at times even throws errors but most importantly I have never seen it helping any Website or Blog rank well in search engines. The plugin I would recommend is All in One SEO Pack. Very simple and easy to use, lightweight and works well for WordPress SEO. Every image in your Website must have ALT / TITLE tag, if you are using one image then use the content title for ALT and if there are multiple images then use long tail keywords relevant to your content. Simply search with your content title in Google, if it is competitive enough Google will show some keyword suggestion at the bottom of the search results page. Use these keywords in the keyword field of your post / page and for tags.
XML Sitemap
Use the plugin called Google XML Sitemaps. Then submit your XML sitemap to Google Webmaster Tools. If you don’t know how to use Google Webmaster Tools, click here. Use the Fetch as Google feature sparingly, in fact use it only when your Website or Blog has changed significantly.
Performance
Majority of the WordPress themes comes with a lot of jQuery and every time your Website is opened all these jQuery scripts also load which slows down your entire Website and causes bad user experience. Also Google and Bing bots don’t like slow Websites. Use the the plugin called Use Google Libraries so that all the jQuery are pulled from Google repositories lowering the burden on your Server and Website. You can use W3 Total Cache plugin for caching, remember this plugin is a bit tricky and technical and it sometimes breaks the functionality of other plugins like Google XML Sitemaps. Google loves faster loading websites! Keep testing / quality checking your Website’s performance in Google Page Speed and understand the performance issues. Sometimes these issues may sound really technical, simply search Google with the issues or consult somebody technical if you can.
Analytics
Until you are measuring what you are doing all these fuss don’t make any sense. Integrate Google Analytics in your Website using a plugin called Ultimate Google Analytics, don’t go by the threatening message on the top of the plugin directory page, this plugins still works very well with all the WordPress versions since 1.5.1.3.
Though these are the stepping stones of your WordPress Website’s SEO but they do fairly well for better search engine rankings, at least you’ll start seeing organic traffic coming to your Website.
CMS is the abbreviation of Content Management System. As per Wikipedia definition… “A content management system (CMS) is a computer application that allows publishing, editing and modifying content, organising, deleting as well as maintenance from a central interface. Such systems of content management provide procedures to manage workflow in a collaborative environment. These procedures can be manual steps or an automated cascade.”
Why you need a CMS
If you want your business to be searched and found online, then your website needs to be content-driven. Now, what do content-driven means? It means you have to keep adding fresh and unique content to your website frequently. Adding content requires modification of the current content, and how do you do it? Depends on how you have built your website. If it is an HTML driven website, then you have to manipulate the HTML code which will require you to understand HTML basics. If you have used a freelance developer, then you’d need to contact that guy. Both have one common problem, dependency! Either you have to be knowledgeable enough, or you’ll have to depend on someone. So what should do you if you want to build and manage your online presence quickly and cost-effectively? The solution to this problem lies in a Content Management System or CMS.
[Read more…]
In this article we’ll try to achieve three things:
1) Connect to MySQL using PHP
2) Create a database and table in MySQL
3) Connect to MySQL using PHP and fetch / retrieve data from the database
Scope of this article is to guide beginners who have just started PHP programming and have never tried to connect to any database using PHP, although PHP have the capability to connect to MySQL, MySQLi, PostGRESQL, Oracle and other number of databases today we’ll only discuss about PHP and MySQL connectivity and the development environment considered is XAMPP on Windows. [Read more…]