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

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

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

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

Link Redirecting Vs Link Cloaking

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.

Convert MyISAM to INNODB using phpMyAdmin

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

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