Differences

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

--- php:php [2016/04/06 06:41] – [Config debug mode in PHP] admin
+++ php:php [2019/02/20 06:10] – [Convert from mysql to mysqli] admin
@@ Line 45: / Line 45: @@
   * 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 51: / 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 134: / Line 137: @@
   * 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 in php-fpm ====
@@ Line 331: / Line 347: @@
 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>