Category Archives: Web Design

How To Create a Local WordPress site with XAMPP

XAMPP is one of many AMP software stacks (Apache – MySQL – PHP) that can be used to create a local web development environment for design and testing.  It automatically installs and configures Apache as a web server so that you can view your pages through http://localhost, MySQL as a database server for website data and PHP to render any PHP code within your pages.

Once you have XAMPP installed, you can install WordPress or other content management systems locally so that you can easily develop and test your web content and programming before uploading it to the web or an intranet.  I also use WordPress as a local CMS for organizing my own content.

Setting up XAMPP and WordPress takes as little as 10 minutes and can be done either on your hard drive or a USB flash drive as I show in this video. The flash drive option is a little slower but it is easily portable between systems as XAMPP runs entirely from the directory it’s installed to.

Downloads: XAMPP is developed by ApacheFriends and maintained by Bitnami. The download is available through SourceForge or from ApacheFriends.org: https://sourceforge.net/projects/xampp/ https://www.apachefriends.org/index.html

The latest version of WordPress is available from WordPress.org. https://wordpress.org/download/

 

Using JavaScript with ASP.NET

Why Use JavaScript?

There are a few technologies that you must be comfortable with if you want to do any serious web development. HTML for content, CSS for formatting and JavaScript for dynamic programming are recognized as the three foundation skills that any good web designer needs.

ASP.NET programmers might be tempted to do away with the last item given that .NET code can do virtually anything when combined with HTML and CSS but JavaScript is still very important and the reason lies in the different domains in which each language operates.

Continue reading →

A Complete Guide to Installing MySQL and PHP with IIS

13 Replies

Note:  This article was written in 2015 and is due for update at some point.  It is still useful as a general guide for issues you might encounter in this type of installation. Please takes this into consideration when downloading components.

One of my latest projects was setting up WordPress, the popular content management system, on a client’s web server which was running Windows Server 2008. WordPress requires installations of MySQL for the database back-end and the PHP scripting language in order to serve up the WordPress content. On a local Windows machine, I’d probably just use a pre-configured WAMP (Windows, Apache, MySQL, PHP) stack package like EasyPHP which is installed quickly and includes all the necessary components. That’s not quite an option in a professional environment, though. I was also working with Internet Information Services (IIS) 7.5 for the web server instead of Apache so the process is a little more involved.

Continue reading →

ASP.NET for Beginners

Leave a reply

31dfef58-1812-4523-ab35-c8bf20fcfd83If you’ve been wanting to learn how to design websites with ASP.NET, here’s your chance! Check out my latest three-part series on OcalaITPros.com where I explain the basics of Microsoft’s ASP.NET framework and how it’s used to create dynamic websites. This series will guide you through creating and publishing a sample application completely from scratch. The series is based on my speaking notes from a recent meeting of the Ocala I.T. Professionals.

Part I – What is ASP.NET?
Learn about the difference between static and dynamic websites and how ASP.NET is used to serve dynamic content.

Part II – Getting Started with Visual Studio and ASP.NET
Installing Visual Studio 2013 Community and starting your first ASP.NET project.

Part III – Building and Publishing Your ASP.NET Application
Completing your ASP.NET project, testing it on on your local machine and publishing it to a hosting service.

 

Importing Meta Descriptions to Yoast SEO

7 Replies

In a recent post, I talked about using the WordPress plugin Add Meta Tags for adding meta descriptions and titles to posts and pages within my WordPress sites. It’s a simple SEO tool but works well. Nevertheless, I decided to switch my sites over to Yoast SEO for all its extra features and guidance in constructing pages. I was anticipating quite a job as this blog alone has almost 100 posts and all of those descriptions needed to be transferred from the fields created by the old plugin to Yoast’s fields. Yoast does have some import tools of its own but they didn’t include the one I’d been using and my experience with a third-party converter had not been good so I was glad to find that I could do it so simply with one query in phpMyAdmin.

Continue reading →

5 Great WordPress Plugins for Your Site

2 Replies

One of the great things about WordPress is the thousands of plugins available. With a little bit of research and just a few clicks, you can quickly add almost any kind of functionality to your site from SEO features to full eCommerce packages. Since I manage multiple sites of my own and more for clients, I’ve had the opportunity to review a number of WordPress plugins and thought I’d list some of my favorites here.

You can find any of these plugins by searching for the name I’ve provided through your own WordPress site. I’ve reviewed the free versions here and included the names of the authors and their sites for reference.

Continue reading →

Web Design – FREE Online Training!

Visit W3Schools.com.If you’ve ever wanted to learn how to design your own website, W3Schools.com is an excellent online resource that offers instruction in all the technologies you need including HTML, CSS, PHP and Javascript. The site offers easy to use tutorials and complete references for these languages with examples and online demos that you can use to practice your new skills.

Before you spend hundreds or even thousands of dollars on classes and specialized materials, check out what’s available online for FREE. Very often, the only investment you need to make now is your time.

Reboot …

If you’ve been to Drewslair.com before, you’ll notice some changes this time around. After more than a dozen years of managing the site with manual tools, I’ve finally decided to got to a content management system (CMS), specifically WordPress. In the last year, I’ve put my design energies into a new website at AndrewComeau.com and hadn’t done much with this site. When I looked at it again a few weeks ago, I realized that it no longer met the standard that I wanted associated with my name so it was time for a redesign.

This blog has been present on the site for a few years under another address and I decided to move it over to serve as the primary site.  I found out in the process how easy it is to move a WordPress blog from one subdomain to another and that was a nice bonus.

A couple of the old articles from Drewslair.com remain but, to be honest, much of the Microsoft Access content was obsolete and other things have been moved to AndrewComeau.com so what you see here now is pretty much what there is. I’ve had the idea to start blogging about some of the many software and online resources that I’ve found over the last couple years and as I find time around a new full-time job that I’ve taken, honing my skills with PHP and MySQL and maybe doing some more work on a new book project, I’ll be doing that here.