my notes

User Tools

Site Tools

Trace:
php:php

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
php:php [2016/01/26 16:00] – [Config Slow Log for architecture nginx with php-fpm] adminphp:php [2025/11/10 13:52] (current) – [Debug error in nginx with php-fpm] admin
Line 27: Line 27:
 check http://192.168.2.11/info.php(To run with debug mode, **remove option --disable-debug** when build PHP from source). In php.ini, we need turn on **log_errors = On** for production and development and where to save log file<code> check http://192.168.2.11/info.php(To run with debug mode, **remove option --disable-debug** when build PHP from source). In php.ini, we need turn on **log_errors = On** for production and development and where to save log file<code>
 error_log = /var/log/php_errors.log error_log = /var/log/php_errors.log
 +</code>To be can save log to php_errors.log, you must change own to allow http write log:<code bash>
 +chown www.www /var/log/php_errors.log
 </code> </code>
 Config turn on/off debug log in **php**: Config turn on/off debug log in **php**:
Line 41: Line 43:
 track_errors = On track_errors = On
 </code> </code>
 +  * Explain config:display_errors = On => Allow display debug information in front end
 Config turn on debug log in **ngix with php-fpm backend**: Config turn on debug log in **ngix with php-fpm backend**:
-<code>+  * in php-fpm.conf<code>
 [global] [global]
 error_log = /var/log/php-fpm.log error_log = /var/log/php-fpm.log
Line 48: Line 51:
 [www] [www]
 catch_workers_output = yes catch_workers_output = yes
 +</code>
 +  * in php.ini:<code ini>
 +display_errors = On ⇒ Allow display debug information in front end
 </code> </code>
 Config turn on/off log in httpd: Config turn on/off log in httpd:
Line 63: Line 69:
 ErrorLog "logs/error_log" ErrorLog "logs/error_log"
 LogLevel error LogLevel error
 +</code>
 +==== Debug error in nginx with php-fpm ====
 +You set it per pool, inside: **/etc/php/8.x/fpm/pool.d/www.conf**
 +<code>
 +[www]
 +................
 +catch_workers_output = yes
 +php_admin_flag[log_errors] = on
 +php_admin_value[error_log] = /var/log/php8.2-fpm.log
 +</code>
 +Then restart PHP-FPM
 +
 +Example Before vs After
 +  * Before (catch_workers_output = no):<code>
 +[10-Nov-2025 10:30:21] WARNING: [pool www] child 12345 exited on signal 11 (SIGSEGV)
 +</code>👉 You only see a generic signal crash.
 +  * After (catch_workers_output = yes):<code>
 +[10-Nov-2025 10:30:21] WARNING: [pool www] child 12345 said into stderr: "PHP Fatal error: Uncaught Error: Call to undefined function get_header() in /var/www/html/wp-content/themes/flatsome/page.php:12"
 +</code>
 +✅ Now you can see the exact file and line that crashed WordPress.
 +🛠️ Combine With These for Full Debugging, Inside the same pool file or your **php.ini**:<code ini>
 +log_errors = On
 +error_reporting = E_ALL
 +display_errors = Off
 </code> </code>
 ==== Config in web server to display error log ==== ==== Config in web server to display error log ====
Line 131: Line 161:
   * Debug with Internet Explorer: Turn on Debug Mode in Internet Options for debugging code javascript error   * Debug with Internet Explorer: Turn on Debug Mode in Internet Options for debugging code javascript error
   * Debug in Chrome: Using Developer Tools for debugging Javascript with break points   * Debug in Chrome: Using Developer Tools for debugging Javascript with break points
 +===== PHPUnit =====
 +refer: https://phpunit.de/getting-started/phpunit-5.html
 +==== Install PHPUnit ====
 +  * Install as binary<code bash>
 +wget -O phpunit https://phar.phpunit.de/phpunit-5.phar
 +chmod +x phpunit
 +./phpunit --version
 +</code>
 +  * Install with composer:<code bash>
 +composer require --dev phpunit/phpunit ^5
 +./vendor/bin/phpunit --version
 +</code>
 +==== Run PHPUnit ====
 ===== PHP Slow Log Config ===== ===== PHP Slow Log Config =====
 ==== Config Slow Log in php-fpm ==== ==== Config Slow Log in php-fpm ====
Line 328: Line 371:
 if(!mysql_connect("localhost", "bob", "secret")) //tries to connect to the database server if(!mysql_connect("localhost", "bob", "secret")) //tries to connect to the database server
 die("Unable to connect to the database server!"); //terminates the script, and outputs the error die("Unable to connect to the database server!"); //terminates the script, and outputs the error
-</code>  +</code> 
 +==== PHP mysql ==== 
 +<code php> 
 +'connect'            => 'mysql_connect', 
 +'pconnect'           => 'mysql_pconnect', 
 +'select_db'          => 'mysql_select_db', 
 +'query'              => 'mysql_query', 
 +'query_unbuffered'   => 'mysql_unbuffered_query', 
 +'fetch_row'          => 'mysql_fetch_row', 
 +'fetch_array'        => 'mysql_fetch_array', 
 +'fetch_field'        => 'mysql_fetch_field', 
 +'free_result'        => 'mysql_free_result', 
 +'data_seek'          => 'mysql_data_seek', 
 +'error'              => 'mysql_error', 
 +'errno'              => 'mysql_errno', 
 +'affected_rows'      => 'mysql_affected_rows', 
 +'num_rows'           => 'mysql_num_rows', 
 +'num_fields'         => 'mysql_num_fields', 
 +'field_name'         => 'mysql_field_name', 
 +'insert_id'          => 'mysql_insert_id', 
 +'escape_string'      => 'mysql_escape_string', 
 +'real_escape_string' => 'mysql_real_escape_string', 
 +'close'              => 'mysql_close', 
 +'client_encoding'    => 'mysql_client_encoding', 
 +'ping'               => 'mysql_ping', 
 +</code> 
 +==== PHP mysqli ==== 
 +<code php> 
 +'connect'            => 'mysqli_real_connect', 
 +'pconnect'           => 'mysqli_real_connect', // mysqli doesn't support persistent connections THANK YOU! 
 +'select_db'          => 'mysqli_select_db', 
 +'query'              => 'mysqli_query', 
 +'query_unbuffered'   => 'mysqli_unbuffered_query', 
 +'fetch_row'          => 'mysqli_fetch_row', 
 +'fetch_array'        => 'mysqli_fetch_array', 
 +'fetch_field'        => 'mysqli_fetch_field', 
 +'free_result'        => 'mysqli_free_result', 
 +'data_seek'          => 'mysqli_data_seek', 
 +'error'              => 'mysqli_error', 
 +'errno'              => 'mysqli_errno', 
 +'affected_rows'      => 'mysqli_affected_rows', 
 +'num_rows'           => 'mysqli_num_rows', 
 +'num_fields'         => 'mysqli_num_fields', 
 +'field_name'         => 'mysqli_field_tell', 
 +'insert_id'          => 'mysqli_insert_id', 
 +'escape_string'      => 'mysqli_real_escape_string', 
 +'real_escape_string' => 'mysqli_real_escape_string', 
 +'close'              => 'mysqli_close', 
 +'client_encoding'    => 'mysqli_client_encoding', 
 +'ping'               => 'mysqli_ping', 
 +</code> 
 +==== Convert from mysql to mysqli ==== 
 +Using tool: https://github.com/philip/MySQLConverterTool 
 +<code bash> 
 +php MySQLConverterTool-master/cli.php -f changeusername.php > changeusername_new.php 
 +</code> 
 +And Modify some missing in tool:<code php> 
 +mysqli_connect("127.0.0.1", "forum_ttb", "xxxxxxxxxx")); 
 +</code>to<code php> 
 +=> mysqli_connect("127.0.0.1", "forum_ttb", "xxxxxxxxxx","forum_ttb")); 
 +</code> 
 +===== PHP curl ===== 
 +<code php> 
 +<?php 
 +function curl_post($url, $vars=array(), $second=10) 
 +{ 
 +    try{ 
 +        $ch = curl_init(); 
 +        if ($ch === false) { 
 +            throw new Exception('failed to initialize'); 
 +        } 
 +        curl_setopt($ch,CURLOPT_TIMEOUT,$second); 
 +        curl_setopt($ch,CURLOPT_RETURNTRANSFER, 1); 
 +        curl_setopt($ch,CURLOPT_URL,$url); 
 +        curl_setopt($ch,CURLOPT_POST, 1); 
 +        curl_setopt($ch,CURLOPT_POSTFIELDS,$vars); 
 +        $data = curl_exec($ch); 
 +        if ($data === false) { 
 +            throw new Exception(curl_error($ch), curl_errno($ch)); 
 +        } 
 +        curl_close($ch); 
 +    }catch(Exception $e){ 
 +        echo "Curl Error: " . $e->getCode . $e->getMessage(); 
 +    } 
 +    if($data) 
 +        return $data; 
 +    else 
 +        return false; 
 +} 
 +</code>
php/php.1453824019.txt.gz · Last modified: (external edit)