php - Linux does not support uppercase file name, any idea? -


i uploaded website linux server, linux know lowercase files. solving converting of file name lowercase , convert of codes lowercase website convert lowercase text.

for example 1 of code this:

 $sql="select * `article` `page` regexp '^$page' , `first_parent_page` = $parent_page , `level` = $level order `page` desc ";     $result=mysql_query($sql,$con);     if($result){         header('location:../login.php');     } 

this converted code:

 $sql="select * `article` `page` regexp '^$page' , `first_parent_page` = $parent_page , `level` = $level order `page` desc "; $result=mysql_query($sql,$con); if($result){     header('location:../login.php'); } 

i should lowercase codes because linux don't know uppercase named files login.php

i used website convert codes convertor, convertor convert lowercase. , don't want convert stuff lowercase.

this question please introduce me way solve problem or please tell me mysql work if use it's order in lowercase like

select * 'table' 

use:

select * 'table' 

and why when want open file on server browser says 404 not found.

linix does know uppercase, in linux files case sensitive.

the following files can happily sit in same folder:

login.php login.php login.php 

and each treated different file. when converting code, need ensure file specifying actual file want specify.

this applied database structure described in detail here:

in mysql, databases correspond directories within data directory. each table within database corresponds @ least 1 file within database directory (and possibly more, depending on storage engine). consequently, case sensitivity of underlying operating system plays part in case sensitivity of database , table names. means database , table names not case sensitive in windows, , case sensitive in varieties of unix. 1 notable exception mac os x, unix-based uses default file system type (hfs+) not case sensitive.


Comments

Popular posts from this blog

commonjs - How to write a typescript definition file for a node module that exports a function? -

openid - Okta: Failed to get authorization code through API call -

thorough guide for profiling racket code -