1

I wrote code in PHP using SQL queries.

I have a MySQL database (using a xamp server for windows) named mydatabase. It is in lower case, table names are also lower case.

I did use some queries in PHP like the following

SELECT * FROM BRANCHPARAMETERES

(Actually, the mysql database itself contains a table named branchparameters)

I migrated code like this into linux using a lamp server.

I am facing problem of queries case sensetivity while running page in linux.

How can i solve this one time?

dirkk
  • 6,160
  • 5
  • 33
  • 51
user3497205
  • 11
  • 1
  • 2
    Take a look at: http://stackoverflow.com/questions/11165944/how-to-change-mysql-table-names-in-linux-server-to-be-case-insensitive – aurbano Apr 04 '14 at 08:53

1 Answers1

0

Just try this strtolower

<?php
echo $tablename = strtolower('BRANCHPARAMETERES');
echo "SELECT * FROM ".$tablename;
?>

Just Different Method

Padmanathan J
  • 4,614
  • 5
  • 37
  • 75