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 [...]
Continue reading...Thursday, November 18, 2010
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, [...]
Continue reading...Thursday, November 18, 2010
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. [...]
Continue reading...Friday, November 12, 2010
Many people use Squidoo and HubPages in their SEO efforts. In this article, I will present many articles discussing Squidoo and HubPages, their differences, and whether they are worth your SEO time.
Continue reading...Friday, November 12, 2010
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.
Continue reading...Wednesday, October 6, 2010
If you promote affiliate programs, it is important to understand the difference between link redirects and link cloaking. Some affiliate programs permit both forms of link usage, some permit just one, and others may prohibit both. In this article, I will tell you why this is important, how to find out what is an acceptable practice, and what is exactly the difference between redirecting a link and cloaking a link.
Continue reading...Sunday, August 29, 2010
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 [...]
Continue reading...Sunday, August 29, 2010
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 [...]
Continue reading...Friday, August 20, 2010
Near the end of May, Google released an update to their search algorithm-dubbed “Mayday” by most-that affects natural search engine rankings, especially for what are known as “long-tail keywords“. In looking at this Mayday update, we will ask the question: Are these Google updates “fair and balanced“?
Continue reading...Thursday, May 27, 2010
When you begin using WordPress, you realize that it can be fairly easy to setup a website quickly. However, when you wish to customize your WordPress, it is then that you can run into many problems. One of the problems that many people run into with WordPress is the order of their categories. In this article, I will tell you how to arrange your WordPress categories using the WordPress “My Category Order” plugin.
Continue reading...
Friday, January 7, 2011
4 Comments