PHP
- Getting started with PHP
- Awesome Book
- Awesome Community
- Awesome Course
- Awesome Tutorial
- Awesome YouTube
- Alternative Syntax for Control Structures
- APCu
- Array iteration
- Arrays
- Asynchronous programming
- Autoloading Primer
- BC Math (Binary Calculator)
- Cache
- Classes and Objects
- Closure
- Coding Conventions
- Command Line Interface (CLI)
- Comments
- Common Errors
- Compilation of Errors and Warnings
- Compile PHP Extensions
- Composer Dependency Manager
- Constants
- Contributing to the PHP Core
- Contributing to the PHP Manual
- Control Structures
- Cookies
- Create PDF files in PHP
- Cryptography
- Datetime Class
- Debugging
- Dependency Injection
- Design Patterns
- Docker deployment
- Exception Handling and Error Reporting
- Executing Upon an Array
- File handling
- Filters & Filter Functions
- Functional Programming
- Functions
- Generators
- Headers Manipulation
- How to break down an URL
- How to Detect Client IP Address
- HTTP Authentication
- Image Processing with GD
- Imagick
- IMAP
- Installing a PHP environment on Windows
- Installing on Linux/Unix Environments
- JSON
- Localization
- Loops
- Machine learning
- Magic Constants
- Magic Methods
- Manipulating an Array
- mongo-php
- Multi Threading Extension
- Multiprocessing
- Namespaces
- Object Serialization
- Operators
- Output Buffering
- Outputting the Value of a Variable
- Parsing HTML
- Password Hashing Functions
- PDO
- Performance
- PHP Built in server
- PHP MySQLi
- Close connection
- Debugging SQL in MySQLi
- Escaping Strings
- How to get data from a prepared statement
- Loop through MySQLi results
- MySQLi connect
- MySQLi Insert ID
- MySQLi query
- Prepared statements in MySQLi
- php mysqli affected rows returns 0 when it should return a positive integer
- PHPDoc
- Processing Multiple Arrays Together
- PSR
- Reading Request Data
- Recipes
- References
- Reflection
- Regular Expressions (regexp/PCRE)
- Secure Remeber Me
- Security
- Sending Email
- Serialization
- Sessions
- SimpleXML
- SOAP Client
- SOAP Server
- Sockets
- SPL data structures
- SQLite3
- Streams
- String formatting
- String Parsing
- Superglobal Variables PHP
- Traits
- Type hinting
- Type juggling and Non-Strict Comparison Issues
- Types
- Unicode Support in PHP
- Unit Testing
- URLs
- Using cURL in PHP
- Using MongoDB
- Using Redis with PHP
- Using SQLSRV
- UTF-8
- Variable Scope
- Variables
- WebSockets
- Working with Dates and Time
- XML
- YAML in PHP
PHP PHP MySQLi Debugging SQL in MySQLi
Example
So your query has failed (see MySQLi connect for how we made $conn)
$result = $conn->query('SELECT * FROM non_existent_table'); // This query will fail
How do we find out what happened? $result is false so that's no help. Thankfully the connect $conn can tell us what MySQL told us about the failure
trigger_error($conn->error);
or procedural
trigger_error(mysqli_error($conn));
You should get an error similar to
Table 'my_db.non_existent_table' doesn't exist
