Thinkphp 数据库表名区分大小写问题
这是我控制器的代码
1 |
|
这是报错:
1146:Table 'MovierDC.praise' doesn't exist [ SQL语句 ] : SHOW COLUMNS FROM `praise`
声明一下,我的表名没错,数据库中有一个全小写的表,查询正常。这个首字母大写就不行
以下是尝试过的方法,没用
'DB_PARAMS' => array(\PDO::ATTR_CASE => \PDO::CASE_NATURAL),
有没有碰到类似的问题,怎么解决? 求职!
回复讨论(解决方案)
windows 中不会有问题
linux 中就不好说了
'DB_PARAMS' => array(\PDO::ATTR_CASE => \PDO::CASE_NATURAL),
'DB_PARAMS' => array(\PDO::ATTR_CASE => \PDO::CASE_NATURAL),
这个配置是 让字段名不区分大小写。对表名无效。
我自己看了源代码,这是thinkphp默认将所有表名转换成小写,大写的在大写字母中间拆开,用_连接,并将大写字母改成小写。
我查不到关于配置表名的配置项。所以我直接从源代码入手,将转换成小写的函数去掉,拆分重组的函数也去掉。最后能用了。
那么久才上CSDN自己把帖子结了!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



Alipay PHP...

JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,

Article discusses late static binding (LSB) in PHP, introduced in PHP 5.3, allowing runtime resolution of static method calls for more flexible inheritance.Main issue: LSB vs. traditional polymorphism; LSB's practical applications and potential perfo

The application of SOLID principle in PHP development includes: 1. Single responsibility principle (SRP): Each class is responsible for only one function. 2. Open and close principle (OCP): Changes are achieved through extension rather than modification. 3. Lisch's Substitution Principle (LSP): Subclasses can replace base classes without affecting program accuracy. 4. Interface isolation principle (ISP): Use fine-grained interfaces to avoid dependencies and unused methods. 5. Dependency inversion principle (DIP): High and low-level modules rely on abstraction and are implemented through dependency injection.

How to automatically set the permissions of unixsocket after the system restarts. Every time the system restarts, we need to execute the following command to modify the permissions of unixsocket: sudo...

Session hijacking can be achieved through the following steps: 1. Obtain the session ID, 2. Use the session ID, 3. Keep the session active. The methods to prevent session hijacking in PHP include: 1. Use the session_regenerate_id() function to regenerate the session ID, 2. Store session data through the database, 3. Ensure that all session data is transmitted through HTTPS.

Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.

How to debug CLI mode in PHPStorm? When developing with PHPStorm, sometimes we need to debug PHP in command line interface (CLI) mode...
