Monday, December 22, 2014

Tutorial: How to change username and password in wordpress database


For some reason you would want to change the username and password for your wordpress database installed in your server. Perhaps, the reason you do this is because you can’t able to login into your wordpress admin dashboard.

There are few possible reasons why you can’t access your wordpress dashboard.
1.       Your wordpress website has been hacked.
2.       You forgot your username and password.
3.       Wordpress password retrieval doesn’t work.

So, in order to get into your dashboard is to access your wordpress database.  Now, you may ask how to access your wordpress database? And what table you should look for in changing your username and password?

In this tutorial, I’ll show you a simple process to do this. First thing first, you need to have access to your cpanel. This is pretty basic and easy. See step by step guide below:

  1. Login to your cpanel and look for database section.
  1. Now, tick on phpmyadmin icon and then it will open a new tab in your browser. Take note that some hosting will require you to logon to phpmyadmin using the same username and password as your cpanel.

  1. Select the database of your wordpress installed. Mine here named staging.

  1. Then click on wordpress users tables (wp_users).

  1. Mine here has only one user which is admin. If you happen to have many users, just select the user you would want to change. Then click edit link to change your username and password. See image below.


  1. Now in this step, I’ll show you how to change the username and password.  In the screenshot example below, the user_login  value is “admin” and the user_pass value is “$P$BZ2p8jq312wEb6eJ7Ea4da8nq60Vuk/
Note:  The user_pass value should be using the MD5 function. So whatever password value you’ve changed for the user_pass column it will not stored in the database.  See below screenshots.

For example we are trying to change username and password with the following values below:
User_login: admin >> change to admin_secure
User_pass:  $P$BZ2p8jq312wEb6eJ7Ea4da8nq60Vuk >> change to password123
Old username and password:
Change to new username and password and set to MD5 function
Then click the “GO” button once done. If you notice on the screenshot below, the username and password has been changed.

That’s all! Now, try logging in using your new username and password. I hope this simple tutorial may find you helpful.


Saturday, December 20, 2014

Themeforest – the leading Wordpress premium themes Supermarket

Where to look for a secure and reliable marketplace for your digital product needs? It is now easy to find.  Themeforest could be your go-to-website as well in finding a real value for your money to invest with.

As a web designer, I frequently come across to themeforest website in searching for a wordpress theme design that would best suits my client design specs and functionality.

It’s all in there to buy

What makes themeforest a one-stop shop for all digital products you need? It’s because themeforest provides hundred and thousand of premium quality digital products, such as vector graphics, pre-designed logos, PSD designs, WordPress themes, templates and more.  So, if you are a web designer or a managing director of a start-up company, then themeforest might be the best place for you to start.

Benefit of a web designer

If you want to build a website from scratch based on your client’s requirements, you can easily choose a well-designed PSD and start converting the design into static HTML web pages.  Its prices are not too high though comparing to premium themes and templates. But this kind of process might take a bit longer than getting a theme with built-in functions.

Basically, the best thing you should do to speed up the site development process for your client is to get a premium theme.  Tweak and modify the theme as to your client specs and make use of the theme options. Likely in less than 30 minutes you can be able to show the homepage design to your client. And to top it all, having a developer license would let you install and make use of the theme for your other projects – that makes it even worth it. You can get an outstanding support from its elite authors.

Advantage of non-web designer

More and more business owners are on digital marketing today to promote their services and products. So having an on-line presence is essential and likely will involve hundreds or thousands of dollar investment.  Some owners do have design skills and computer savvy, hence setting a landing page on a server can be convenient for them.

Now what about those business owners not technically inclined to set up a business website? No stress for them as themeforest will be their business buddy. Just choose a premium WordPress theme for your website and they will let you avail a service from their trusted partners. Third party services will include setting up a hosting account and install the theme for you. It’s just like a one day process and in the next day you can begin showcasing your products on-line.


Reliable support and quality digital products

All premium theme authors provide supports to their buyers. Mostly in real-time support through forums, support ticket, and live chat. This is pretty much standard requirements to authors where they should have a sole portal for users to get theme documentation and guidelines as well.

All themeforest digital products are strictly required to follow a quality standard set by themeforest. Authors should submit first their items for validation and review prior to publishing to themeforest marketplace.

How themeforest wordpress theme designs boosted my web design services

I would say themeforest wordpress themes are not cheap. Particularly those themes come from elite authors. So whenever I purchase a theme, I thoroughly check its features and functionality to make sure I can make use of it entirely for different website design projects.

So far, I've used rocco theme for most of my projects. It works out of the box where I can easily implement a design either from a PSD or a rough wire-frame provided by the client.

Before my process for a single website design would take 2 to 3 weeks to complete or even a month. But after using a premium theme from themeforest, my projects ETA made quicker and the results are excellent. 

Tuesday, August 19, 2014

Discover 17 Basic and Advance Form add-ons for GravityForms

Gravityforms is very popular these days as a powerful form builders ever made for WordPress plugin. If you haven’t tried Gravityforms yet, read on and learn what GravityForms can do for your site or blog. In fact, GravityForms is now made even better. There are already a number  of extended add-on plugins which you can download for free in the WordPress repository.

In the mean time, if you decide to buy gravityforms Business and Developer license, please take a look of some of its basic and advance form add-ons below.  See Gravityforms pricing and compare which license will fit your needs.

If you’re a web developer, these basic and advance gravityforms add-ons are useful for building multiple websites for your clients.


Gravityforms Basic Add-Ons Form


Aweber


Aweber is a simple and fast email marketing 3rd party service. Now, you can easily integrate it with Gravityforms. Install it and collect and add subscribers to your email marketing list within your wordpress forms.

Aweber

Read more...


Campaign Monitor


Campaign Monitor is also a 3rd party newsletter service. Collect and add subscribers automatically right into your wordpress site. Install this add-on and enjoy creating beautiful newsletters.


Gravity forms Campaign Monitor plugin

Read more...


Mailchimp

You can now connect your online gravityforms using mailchimp add-on.  It will automatically add subscriber to your email list when a form is submitted using your gravityforms.

Mailchimp Gravity forms plugin

Read more...



Picatcha

Make your gravityforms even more secure by installing Picatcha add-on. Picatcha is an image based CAPTCHA which is easy to read by humans but hard to crack by spam bots.

Gravity forms Picatcha plugin








Read more...





Gravityforms Advance Add-Ons Form


Below are the Advance Form Add-ons that you can download for free when you purchased the Developer License.


Authorize.Net

With the Authorize.Net Add-On,  you can capture credit card payments along with any other data you want from the user right on your WordPress site without sending the user to a 3rd party to complete the transaction. Make your credit card payments more easy and quickly with Gravityforms Authorize.Net add-on.

Gravity forms Authorize.Net plugin










Read more...


Coupons

Coupons add-on will make your life easier in incorporating coupon functionality into your gravity forms. It allows you to choose which specific form you want to display the coupon fields.

Gravity Forms Coupons Add-On










Read more...



FreshBooks

With FreeBooks add-ons, you can  create FreshBooks clients automatically into your WordPress site. Turn any Gravity Forms submission into a FreshBooks invoice or estimates easily.

Gravity Forms Freshbooks Add-On









Read more...


Paypal Payment Standard

Turn your WordPress forms into paypal ready with Paypal payment Standard add-on.  Paypal is now seamlessly integrated into your forms which automatically transfer the user to paypal portal to complete the transaction when user submits the form.

Gravity Forms PayPal Payments Standard Add-On









Read more...


Paypal Payments Pro

Paypal Payments Pro allows user to pay directly into your WordPress forms. This is more way better which makes the user pays easily and fast.

Gravity Forms PayPal Payments Pro Add-On









Read more...


Paypal Pro

Integrate Gravity Forms with PayPal’s legacy PayPal Pro payment solution. Note, this add-on will only work with users who have legacy PayPal Pro accounts that use the old PayPal Pro API.

Gravity Forms PayPal Pro Add-On









Read more...



Polls

This gravity forms add-on allows you to easily add polls on your WordPress website. This is ideal for polls website or product site.

Gravity Forms Polls Add-On










Read more...



Quiz Add-on

If you’re thinking to build a quiz form in your WordPress site. With gravity-forms quiz add-on, you can seamlessly and easily deploy quiz forms.

Gravity Forms Quiz Add-On









Read more...



Signiture

With Signiture add-on, you can easily capture signitures online by allowing users to sign using touchscreen devices, mouse and touch pads. No need to install browser plugins or any software for the online  signiture.

Gravity Forms Signature Add-On









Read more...


Survey

The Gravityform Survey Add-On allows you to easily interact with your users by collecting and analysing data on your target audience. You can easily do research, employee surveys, food surveys, customer and services satisfaction surveys, employee surveys and job satisfaction surveys, and anything else.











Read more...



Twilio

Notify your subscriber with a customizable SMS text message when a form is submitted or payment is received via an order for

Gravity Forms Twilio SMS Add-On









Read more...


User Registration

This add-on allows user to register in your WordPress website using any forms. This is one of my most useful gravity forms add-on when you run a membership website.

Gravity Forms User Registration Add-On









Read more...



Zapier

The Gravity Forms Zapier Add-On allows you to leverage Zapier to integrate with over 200 different web services and counting!

Gravity Forms Zapier Add-On










Read more...



That’s it, I hope you will find this post noteworthy to read.  With these add-ons, you can make your WordPress forms even better. If you have used one of the 3rd party web applications mentioned above, getting this add-ons will make your life easier. Good luck!


Monday, August 18, 2014

11 Free useful Gravity Forms Add-ons Plug-in

The most popular WordPress form builder plugin – Gravity Forms was recently updated to its latest version 1.8. From its first  appear in the market, many users find it very useful and easy to use  in creating any kind of forms such as contact form, job application form, registration form, and anything else.

Aside from Gravity Forms premium extended add-ons, there are also Gravity Forms extended plugins that we can use for free.  And they are available to download in the WordPress repository.


I’ve listed below the extend add-ons for gravity Form plugins that might be useful to integrate with your on-line gravity forms.


Free Gravity Forms Add-ons


1. Gravity Forms PDF Extended

The PDF Extended is one of the gravity forms add-on that I find very useful. It allows you to download a PDF format in any of your forms from WordPress back-end and front-end. It create automatically a PDF file after form submission. This plugin can be install and configured easily.


Gravity Forms PDF Extended


More info/download


2. Gravity Forms Salesforce Add-on

Do you have a salesforce.com account? Gravity Form Salesforce add-on is the most powerful plugin integration available for WordPress platform.  Your customer relation management will even become more simple and easy on your WordPress site With this add-on.

Gravity Forms Salesforce Add-on

More info/download



3. Gravity Forms Directory


With Gravity Forms Directory add-on, you can build a directory application on your WordPress site. You can display any information submitted in your gravity forms and format it based on your specifications. You can display it by tables or lists. This add-on is very useful if you create a directory of user, clients, members, and clients.

Gravity Forms Directory


More info/download


4. Gravity Forms Constant Contact

Do you have Constant Contact account? I’m sure you will want this plugin for  your WordPress website. This plugin will simply add your entries into your Constant Contact list automatically when a form is submitted.

Gravity Forms Constant Contact

More info/download


5. Gravity Forms Mad Mimi Add-on

If you have a mad mimi account, you can simply integrate it with your gravity forms using this add-on. Each form submission will automatically added to your mad mimi account.

Gravity Forms Mad Mimi Add-on


More info/download


6. infoGeniuz Advanced Form Analytics for Gravity Forms

This Gravity Form add-on is a powerful plugin that allows adding number of visits, page-views, browser and geolocation data to all your gravity forms email notifications and entries table. It adds functions to collect marketing and sales information from the users who filled out the forms on your WordPress site.

infoGeniuz Gravity forms

More info/download


7. Gravity Forms Highrise Add-on

This add-on plugin allows you to easily integrate your Highrise account. It  adds automatically your contacts into Highrise and making your customer relationship management simple with fast and easy set up.

 Gravity Forms Highrise Add-on


More info/download


8. Gravity Forms ExactTarget Add-on

This add-on includes a widget subscription box in your WordPress that links to your ExactTarget account.

Gravity Forms ExactTarget Add-on


More info/download


9. Pronamic iDEAL

This plugin allows you to  easily add the iDEAL payment method to your WordPress website.

 Pronamic iDEAL


More info/download


10. Gravity Forms CSS Ready Class Selector

This plugin allows you to easily create more advanced alternative layouts for the fields in your Gravity Forms. This add-on comes with a pre-defined CSS class which you can easily select for your style modifications.

Gravity Forms CSS Ready Class Selector


More info/download


11. Headway Leaf: Gravity Forms Leaf

If you are a headway user, this plugin allows you to add gravity forms easily on your headway framework. You will find some cool features when you integrate this plugin into your WordPress and gravity forms.


Note. This plugin hasn’t been updated in over 2 years.

Headway Leaf: Gravity Forms Leaf

More info/download


One thing to note. Some of this plugin may not compatible any more with the latest version of WordPress 1.8. I suggest checking the plug-in first before installing. It would be better if you can do a thorough testing to see if there’s any issue. Make sure to make a back-up before doing so.


That’s it, I hope you find this article noteworthy to read. If you happen to know some other useful free gravity forms add-ons out there that is not included here, please feel free to comment below.


You might interested also with the Premium Basic and Advance Forms for Gravity Forms? Click on the link.


Saturday, August 16, 2014

Basic Guide on How to Start a Web Design Business

Getting into web designing business could be difficult for some factors. It depends of what level of specialization you have for this area and the available resources needed at hand to start with. Basically, all you need is a striking portfolio, and a range of designing, business management, and marketing skills.  If you think you have all these basic requirements, then you’re good to go.

Single owned and Agency Web design Business Set Up


Single Owned Set Up

A web design business can possibly manage by a single person. One can start through a home-based set up or a rented co-working space. If you decide to solely start your own, that’s fine. As long as you got what it takes to handle everything from designing aspect, billing management, and to strategic marketing.  But you need to know the disadvantage of running your own. In the long-term, your client-based network will getting bigger and you will probably getting a lot of emails from your clients asking support, project quotations, and consultancy. And this time, an extra workforce is necessary to help you cope up with the client’s demand.

The solution is to hire someone from your local or just outsource talents through job marketplace platform such as oDesk, eLance, and Freelancer.com. But you need to provide a working bank account or debit/credit cards for online transaction like this. These web portals allow you to create an agency and manage your online team of experts. The advantage of this kind of web design business set up is the ability to manage your time and flexible target income.

Agency Set Up

Having the right group of talents in a website design company is a good advantage. Your business will surely prosper through their help and contribution. But you need to take certain process before putting them on board. And that’s the big challenge. Since you will be investing your precious money to compensate them, your selected employees must have firsthand knowledge to their designated task.  Remember capable workers are lifeblood of your business.

Ideally, having a few workers like 3 or 4 would be a good starting point. To kick-start your website design business, you need a propeller head to work on the programming and server task, a web designer who can produce quality web graphics and layout, a business minded staff to handle financial matters, and a marketing expert who can do search engine placement and advertising campaign. As a founder of your own agency, your role is the most important in bringing your business into success. Moreover, this is also important as to your workers. Invest equipment needed to run such as computers, office tools and equipment, Internet connection, peripheral device for computers, and software.

Home-based set up is not ideal for agency setup unless you envision having a co-working space style in manning your business. Co-working set up is commonly used  today with various firms in the US especially in the IT industry. Starting a web design business utilizing this set up would need ample budget. And you need to further research and do business planning before starting.

Now it’s time to work on the bigger picture. I've listed couple of ways below that might be useful to start your web design business.


Create your Identity

As an old saying, first impression is lasting. So make sure your website design and logo is stunning.  Choose a unique and short company title that is easily remembered. Ideally a two or three syllable would sound recognizable and include a tagline that best describe what your company is all about. And most importantly, include a portfolio of your recent works so that your potential client may know what best you can do for their business.

Set up your goals and objectives

For me, setting up goals is a paramount on every business venture. You need to set mission and mission and let your clients inform what you’re up to. Set your target market and know your competitors. Set a reasonable rates and focus more on reputation than getting high paid from your clients.

Get your first real client

If you’re working as a freelance web designer or have worked  in a company, well – make those people as your potential first real client. Send them a newsletter campaign or a proposal letter informing them that you’re launching a new web design business. Offer them an enticing competitive price and benefits. And convince them what makes you different from the other web design companies. In case you’re just starting at all, be positive and always put your best foot forward. As the founder of your own web design business, you should be the first one to make the real deal with a client. Getting your first client is such an achievement.

Establish your good reputation for a solid client-based

Establishing your good reputation is just like building your monument. The more your clients trust you, the more they become confident in signing you a new contract. There’s a big chance of getting referrals from word of mouth. So always aim on getting good feedback rather than good earnings.

Market your services using SEO, SEM, and SMM.

Deciding which marketing method and strategy is a crucial part of your business. You need to balance both traditional and online marketing. In today’s modernization, more and more people are getting into the internet and social media. So using the internet for your marketing effort will indeed effective. Since we’re talking about web design business, I know this is something you can handle with. All you need is a marketing guy who can do SEO content. But getting a real traffic for your site and obtaining organic search results through search engines could be frustrating.

However, you can use the power of social media while waiting for your site to be crawled by search engine bots. Social media is free and one of the most effective way in marketing your business. And lastly, get an adwords account and start campaigning through PPC and CPM. It will surely increase your change of getting potential clients.

Provide paid and free support

Always get involve with your clients. Best if you can provide them free support for minor fixes right after you launch their website. While making you available when they seek consultation for whatever improvement they’re working. In this way, your clients will think that you’re more of a partner who likes to grow with them. Also, offer them paid support for major works involve such as website redesigning, adding features and custom functions, and other third-party integration that involves advance programming.

I hope you find this article useful to start your own web design business.

Building A Website with an Impact

Web design today - is far more different from the last 10 years ago. Through the use of today's latest front-end technologies, designing a complex user interface is no longer a tedious task for web designers. I guess you’re already familiar with Ajax, jQuery, HTML5, CSS3, and twitter bootstrap? Well, those are just the popular front-end technologies for building a modern and attractive looking web design.

You probably have many creative ideas, but not sure, or lets say not confident enough to convert your ideas into a great web design. I assume that you have the basic knowledge of HTML mark-ups and know how to upload your website into a server. In this article, I will cover here a brief information in building a standard website with an impact to your clients or users.

Essentials of Building a Website

The best websites are not necessarily a stunning and the best looking website. The point is, they are the website that carry out what the business or platform wants them to represent. Website is not only created to bear the company’s reputation or to showcase a product or services, but also to serve as a portal or landing page for an on-line presence.

That’s why it is essential to optimize a website for better search engine results. Implement Search Engine Optimization (SEO) effectively and follow best practices in web designing. There are plenty of helpful article out there to help you better understand the latest modern web design and best practices like smashingmagazine.com.

Standard Website Elements

Whether a small or mid-size business websites should have the basic pages and elements as a norm. It should have a homepage and at least one product or services page. A good Website should have a page of contact information with a Google map and complete address. Also having a Frequently Asked Questions(FAQ) is useful for websites visitors as well.

It is important also to tell your visitors "who you are", 'what can you do", and "how you work"  by providing an about page section. This section must also include the website history, its mission and vision statements, and the people behind the organization. Visit  UI and UX design trend for more helpful articles and insights about standard website elements.


Basics in Building a Website

Before a web designer starts building a website. He or she needs to gather information first, such as target market research, goals, and visitors demographic for  the site. Then build a foundation by creating a staging server where you can upload your test pages. Create a coming soon page and include a lead capture form for subscriptions. Then create the layout of the website. Do some wire frame and PSD mock-ups. Once you come up with a final layout and design, work next on the html mark-up and website structure for your  static or dynamic pages. Read more information about the Basics in Building a website and website planning guide.

There you have it, this post is  just a simple recommendation in building a standard web design. I hope you find it useful and good luck.

The Essentials of Building a Fully Optimized Business Website

The best website is not necessarily the best looking website. There are several factors to consider for a well designed and fully optimized website. If your client shows you a website that glitters and shimmers but doesn't meet what the client wants, it is not a good website at all.

Yes, it is easy to agree with your client and work on his design specification. But as a professional web developer, it is your obligation to make sure the client understand everything. Because there is a possibility that your client will lose any number of customers because what he thinks of his design specification might not work well for some reasons. It means you must be willing to diplomatically tell your client that his wrong with his ideas.

Generally, a good business website should appear quickly on a screen. It should be consistently very easy for beginners as well as experienced users to navigate. Importantly, the website should be attractive when viewed with any of the major browsers and should look better in any screen sizes (responsiveness). Users should be able to quickly find what they’re looking for on the site.

Essentials of Building Websites


Fast Load

There are many design techniques to cut a page downloading time. Use HTML text as much as possible in designing a website. More often, designers will just slice an image from a PSD to save time working on style sheets. Use image sprites for background and graphic icons. In fact, there are CSS frameworks today that use glyphicons which are lighter than image icons. As much as possible, do not use nested table. Use divs and classes in your HTML instead.

If you’re using CMS like wordpress, compressing and reducing graphic files is easy without destroying the graphics quality. You can use various plug-ins like EWWW Image Optimizer and WP Smush.it by wpmudev. Also, it is important to minify and compress your HTML, CSS, and JavaScript. And place all your JavaScript links as much as possible in the footer area. This way, it will load first your HTML elements before the browsers make any JavaScript action.

Moreover, it is also important to avoid rendering blocking JavaScript and CSS on your website internal pages. An example of this is a welcome pop-up or modal window when a new user visits a home page. To check your website’s loading speed and performance, you can use pingdom.com or google pagespeed insights. They are free to use and reliably provide you a detailed evaluation of your site fixes to optimize the loading speed.

Easy Navigation

Many internet users got lost in navigating a website. Problems in viewing a website are not fault of the inexperienced user but rather the web designer who designed the user interface (UI). This is true; a badly designed navigation layout could lead the visitor to jump off to another website. To prevent this from happening, you need to make sure that your navigation tools are easy and user-friendly.

You’ve probably seen many websites that uses a consistent navigation bar on the left side of every page on the site. This is done so visitor can better understand how to navigate through the site. If you go to smashingmagazine.com and wpmudev.com, you’ll see that the same navigation bar is consistent throughout the website.

No matter how complex the website is, you should be able to organize the topics and subtopics to make navigation easy. If you’re building websites for eCommerce and your main navigation is in the header area, you need to have a mega menu where visitor can easily navigate throughout hundreds of product categories and sub-categories. If you go to zalora.com.hk and lazada.com.ph you will see how easy it is to navigate using their drop-down mega menu.

Cross-Platform Compatibility

As a web designer, making your website’s elements to be consistent on all browsers is one of the major complex workaround to deal with. More often web designers tend to look for browser issues after the website’s 90% completion. I tell you; the more you do this process the more likely you will get fired by your boss.

I suggest checking your website elements from all browsers while doing HTML markups and CSS coding can save you time and effort. This is way better than fixing it later in the development. This will help you identify minor issues during the process and help you speed up the development.

Also, a well designed website can able to adapt various sizes of screen device such as mobile, tablet, and wide-screen monitors. Especially today that more and more people are using smart phones where they can browse the internet easily and fun.

Content Readability

To give your site an impact to your visitors, design your website’s pages that are easy to skim in finding pertinent information. A good website pages should have a Title, Heading, introduction, and well formatted body content.

If you are using CMS like Joomla or WordPress, formatting your content is a breeze.  Using the latest text and visual (WYSIWYG) editor you can format your content the way you want. This CMS feature can make your website pages content easy to update and allowing you to add relevant images. Also, don't mess up your content by placing too much banner ads within the content area.

In conclusion:


A technically stunning website that ignores many really important things will end up as a website that doesn’t work. Use coding standards and best practices to make sure your website is fully working and optimized  for your client. By doing this, you simply make everything easy for your visitors. And of course, for your clients to make a passive income and high return of investment (ROI).