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.