What I am Running (so no one asks the obvious)
Database: MariaDB ver. 10.0.20
Database client-version: libmysql - 5.6.27
PHP-version: 5.6.4
MYSQL-Extension: mysqli
So I made the decision to immigrate my database to MariaDB. I have never had a problem with PHP and Mysql, but now I am learning that values are being selected weird from the database.
When I make the following query:
SELECT `stock_ticker`, `stock_simpleName` FROM `stocks` WHERE `stock_ticker` LIKE '%mon%' OR `stock_simpleName` LIKE '%mon%'
I get two results that are correct (Monsanto and Mondelez). When I run the same query in PHP, I get whatever the hell PHP wants to give me.
I have dissected the PHP code for days, and I promise, the code is sound. It has worked perfectly with other PHP and Mysql projects. I have determined it is a crossover between PHP and MariaDB possibly using the mysqli extension. I have no clue what the problem is though. Does anyone else know what it could be? Please help! This has been aggravating me for days. It might be a simple Google search, but everything I have searched has turned up nada.
Have you checked your connection? Can you edit your question with more information about the database name etc? Perhaps, you might be connecting to the wrong database on PHP!
I had problems like this, but was my fault, I forgot to change the name on my PHP connections config..