It appears that you provided a large amount of text that is not related to the problem. I'll provide a clear answer to your question.

Understanding SQL Queries in CodeIgniter: A Step-by-Step Guide to Avoiding Subquery Issues

Understanding Image Uploading in CodeIgniter: Resolving Issues with iPhones

Understanding PHPMyAdmin's Character Encoding Issues After AJAX POST Requests