Category Archive

Apostrophe, Input Form, PHP, MySQL: The Easy Solution!

Richard CummingsJanuary 7, 2011Quick Solutions, Technologies/Solutions6 Comments

In this article, I will tell you how to deal with the apostrophe not working in form data that writes to MySql using PHP. I do a lot of work involving input forms on PHP pages that write the input data to MySQL. Every time I do this, I have to account for the user who puts in an apostrophe. … Read More

PHP: Convert Variable To Date

Richard CummingsNovember 18, 2010Quick Solutions, Technologies/Solutions, Web Consulting2 Comments

In this article, I will review how to convert a variable that represents a date to an actual MySQL date column using PHP. Dealing with dates and times in MySQL and PHP is at once fascinating and frustrating. Everybody seems to store their date information with slight variances. Thus, everyone’s solution is slightly different. So, today I will show you … Read More

Import CSV File Into MySQL

Richard CummingsNovember 18, 2010Quick Solutions, Technologies/Solutions, Web Consulting3 Comments

In this article, I will show you how to configure a CSV properly and then import the CSV file into MySql. A client of mine recently asked me if I could upload his .CSV file into a MySQL database. He runs a sports site and wanted to have the entire NBA schedule available in MySQL. He presented me with the … Read More

Windows 7 Screen Maximizes When Dragged Partially Off Screen | Get Rid of It!

Richard CummingsNovember 12, 2010Quick Solutions, Technologies/Solutions1 Comment

This is just a quick tech note on Windows 7 Screen behavior and the new feature in which the screen maximizes when you drag it partially off the screen.

Convert MyISAM to INNODB using phpMyAdmin

Richard CummingsAugust 29, 2010Quick Solutions, Technologies/Solutions9 Comments

This is a technical post on how to convert from MyISAM to InnoDB using phpMyAdmin. Yesterday, I was using phpMyAdmin to set up database tables in MySQL. The solution that I was implementing called for me to use foreign keys to relate the tables to one another. Well, foreign keys require the use of the InnoDB search engine instead of … Read More

The Used Table Type Doesn’t Support FULLTEXT Indexes

Richard CummingsAugust 29, 2010Quick Solutions, Technologies/Solutions2 Comments

This is a technical post for those who are receiving the message “The Used Table Type Doesn’t Support FULLTEXT Indexes” in phpMyAdmin.” I received this message as I was trying to convert a MySQL table from MyISAM to InnoDB in phpMyAdmin. I was converting this MySQL table from MyISAM to InnoDB so that I could create foreign keys in MySQL … Read More

How To Show WordPress Category IDs

Richard CummingsMay 13, 2010Quick Solutions, Technologies/Solutions, Web ConsultingLeave a Comment

Learn how to show WordPress Category IDs so that you can customize your WordPress Categories and catapult them to the top of the search rankings.

How To Redirect Web Image Results To Web Page

Richard CummingsMay 13, 2010Blogging, Making Money Online, Quick Solutions, SEO/Site Promotion, Technologies/Solutions, Web ConsultingLeave a Comment

In this article, we will take a quick look at how to redirect Google search image results to the actual web page that hosts the image. Occasionally, there are those little things that you can do which yield large results. This is one of them–take advantage of it!

Create Custom Ads for WordPress and Websites

Richard CummingsSeptember 10, 2009Quick Solutions, Technologies/SolutionsLeave a Comment

Often, Google Adsense and other advertising programs do not suit your needs. Thus, you need to create your own Google-like ads. In this article, I’ll explain how to create your own custom revolving ads for WordPress or your website using a relatively simple PHP script.

Search Replace within MySQL

Richard CummingsSeptember 3, 2009Quick Solutions, Technologies/SolutionsLeave a Comment

This article reviews a quick way to do a search and replace in MySQL using phpMyAdmin. This solution can be used to do a quick search and replace of any condition within your MySQL database fields.

Page 2 of 3
←
1
2
3
→