Php & MySQL - WebTechGlobal

Quicker IDE Code Suggestion Without Case Sensitivity

Oct 22nd, 2011 // In: Php & MySQL // By: Ryan BayneComments 0

It is amazing how much time we can waste by not creating and sticking to a style of coding. A lot of new young web designers don’t realise that case sensitvity can be activated for code suggestion tools. Some won’t know code suggestion exists of an IDE does not activate it automatically. If your like [...]

WordPress Breaking AdSense Script

Sep 22nd, 2011 // In: Easy CSV Importer, Help, Php & MySQL // By: Ryan BayneComments 0

A couple of Easy CSV Importer users have reported that when trying to insert Google AdSense scripts to their custom post content, the script does not work. The problem can be at the point of saving the template, when WordPress escapes the content before storing in the database. Instead of explaining it to you, I’ll [...]

Strange Problem With date() Function

Sep 11th, 2011 // In: Php & MySQL // By: Ryan BayneComments 0

In short date(“Y-m-d H:i:s”) and date(“Y-m-d h:i:s”) were returning the exact same date and time with the same format. Both had 24 hour format but the lower-case “h” is meant to return 12 hour format. This date() function is a standard PHP function, not written by myself. I have no idea why this would happen. To get [...]

SHOW TABLES FROM Returns False

Aug 29th, 2011 // In: Php & MySQL // By: Ryan BayneComments 0

I’m working on Easy CSV Importer and I’ve discovered a problem caused by the database name including hyphens. Well at least that is what I’ve read and my database does have hyphens. Using “SHOW TABLES FROM” in MySQL seems to trigger an error as if a hyphened database name is illegal. Strange, others have experienced [...]

MySQL: NOT LIKE

Aug 18th, 2011 // In: Php & MySQL // By: Ryan BayneComments 0

An important fact to know about the NOT LIKE is that it will cause your query to always return NULL/false, unless you add further argument that uses OR. Further argument that uses AND will not do the job of OR in the case. Below is a query that will work… $query = “SELECT * FROM [...]

WordPress – is_my_plugin_page

Aug 4th, 2011 // In: Php & MySQL, Wordpress // By: Ryan BayneComments 0

This is for new plugin developers. How to code a simple script that checks if the current admin page is one of your plugins pages. I needed something like this when I begun created my WTG Plugin Template, a plugin I plan to use to create many other plugins. It needed a flexible administration menu, [...]

Maintenance 25th July 2011

Jul 25th, 2011 // In: Advertising, Affiliate Earning, Blog, e-Commerce, Easy CSV Importer, Graphics Design, Hardware Reviews, Help, Information, Php & MySQL, RomanCart on Wordpress, Services, Wordpress // By: Ryan BayneComments 0

I’m in the middle of updating my WordPress installation to version 3.2.1 and it is causing some issues. I’m going to try and leave as much service available as possible why I work on issues individually. Please email the webmaster@webtechglobal.co.uk if you are seeking to buy or download any software.