MariaDB和PHP - 查询不能正常工作

Question

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.

Answer 1

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..