Differences

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

--- php:php [2016/01/25 03:12] – [Config Slow Log for php-fpm] admin
+++ php:php [2025/11/10 13:52] (current) – [Debug error in nginx with php-fpm] admin
@@ Line 4: / Line 4: @@
   * Eclipse pdt: [[php:eclipsepdt|Eclipse PDT(PHP Development Tool)]]
 ===== Create PHP simple code and run =====
-==== create helloworld.php ====
+==== Create helloworld.php ====
 <code php>
 <?php
@@ 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>
 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>
 Config turn on/off debug log in **php**:
@@ Line 41: / Line 43: @@
 track_errors = On
 </code>
+  * Explain config:display_errors = On => Allow display debug information in front end
 Config turn on debug log in **ngix with php-fpm backend**:
-<code>
+  * in php-fpm.conf<code>
 [global]
 error_log = /var/log/php-fpm.log
@@ Line 48: / Line 51: @@
 [www]
 catch_workers_output = yes
+</code>
+  * in php.ini:<code ini>
+display_errors = On ⇒ Allow display debug information in front end
 </code>
 Config turn on/off log in httpd:
@@ Line 63: / Line 69: @@
 ErrorLog "logs/error_log"
 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>
 ==== Config in web server to display error log ====
@@ Line 127: / Line 157: @@
 ==== Debug with xdebug ====
 Refer: [[php:xdebug|Debug PHP with xdebug]]
-==== Query log of mysql server ====
-[windows]
-  log = "C:/genquery.log"
-[linux]
-[mysqld]
-  log=/var/log/mysqld.general.log
-<code bash>
-touch /var/log/mysqld.general.log
-chown mysql.mysql /var/log/mysqld.general.log
-SET GLOBAL general_log = 'ON'
-/etc/init.d/mysqld restart
-</code>
 ==== Debug with Javascript ====
   * 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
+===== 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 =====
-==== Config Slow Log for architecture nginx with php-fpm ====
+==== Config Slow Log in php-fpm ====
 <code>
 request_slowlog_timeout = 5s
@@ Line 339: / Line 371: @@
 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
 </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>