Quite often I am slow to troubleshoot an application error when I don’t know which layer of the whole system is the broken piece.

 1. Determining the cause of a database permissions error.

Forced to learn more about my hosts chosen cPanel interface setting permissions. Fine. So many web pages advised that the Flush Privileges command was required, but it was good.

Also re-checked phpMyAdmin to see if the error was there. Adjusted some table settings, but looked ok.

HTML / FBML code looked alright. Facebook developer canvas page was at least loading the permission error itself ok. No parsing errors.

Eventually found out it was the final part of my query statement. It worked great after adding the WHERE ID_FB=’$user’.

2. Creating an image submit button in PHP.

Spent way too much time finding the tip that for image submit buttons in the POST you check for the  if($_POST['color_x']) and not for $_POST['color'].

3. Next I am checking into scripting to avoid the full page re-loads on form submit presses.

4. Also that it is impossible to do a CSS style hover on an input type=image in IE6. Ouch. 

5. Within the <?php tags ?> gettings a variable uid passed to the facebook profile picture field. echo ‘<fb:profile-pic uid=’.$arFriends.’ size=”square” linked=”false” />’.”<br />”; 

Trackback URI | Comments RSS