Category: MySQL

Based on yiisoft/yii2-app-advanced, create a new repository yii2-app-advanced on github, and create a new interface application (implement RESTful-style web service services. API), adjust the default character set to: utf8mb4, the adjustment of the interface response format, the empty array is automatically converted to empty objects, and the request log message is collected in the interface application (1 request corresponds to 1 log message) to the database, and the corresponding interface to implement the log function: log list (set data filter to enable filter processing), log details

2018/06/22

Post Views: 39 1. Set the default collation of the database as: utf8mb4_unicode_ci, as shown in Figure 1 2. Modify the default character set for database connections: utf8mb4, edit the configuration file in the development environment, \environments\dev\common\config\m ain-local.php, edit the configuration file in the production environment, \environments\prod\common\config\main-local.php 3. Execute the initialization command, as shown in Figure 2 4. Edit the…
On Yii 2.0, use updateAll() to update the implementation of the table column value to another column value of the same table

2018/06/07

Post Views: 53 1. Use updateAll() to update the value of prev_status to the value of status, and update the value of status to 4, the table structure is shown in Figure 1 2. Based on the query builder, the code is as follows 3. However, it does not meet the expectations. The values of prev_status are updated with 0,…
Based on yiisoft/yii2-app-advanced, create a new repository yii2-app-advanced on github, and create a new interface application (implement RESTful-style web service services. API), prepare some examples of automated tests (API tests) for user-related operations in the tests directory of the API to ensure that the application will not affect existing functions when changing or adding new functions

2018/04/13

Post Views: 73 1. Delete the controller \API\Controllers\SiteController.php, delete the model \api\models\contactform.php, \api\models\loginform.php, \api\models\PasswordResetRequ estform.php, \api\models\resetpasswordform.php, \api\models\signupform.php, delete the directory (view related) \api\views, \api\assets, \api\web\css 2. Delete the relevant files of the test (unit test, functional test, acceptance test), delete \api\tests\acceptance\homecest.php, delete \API\Tests\Functional\AboutCest.php, \API\Tests\Functional\ContactCest.php, \API\Tests\Functio NAL\HOMECEST.php, \API\Tests\Functional\logincest.php, \api\tests\functional\signupcest.php, delete \API\Tests\Unit\Models\ContactFormTest.php, \API\Tests\Unit\Models\PasswordResetRequestFormTest .php, \api\tests\unit\models\resetpasswordformtest.php, \api\tests\unit\models\signupformtest.php 3. Run all the sample tests,…
Based on yiisoft/yii2-app-advanced, create a new repository yii2-app-advanced on github, and create a new interface application (implement RESTful-style web service services. API), implement RESTful web service, support internationalization (drivingly set the target language, default to simplified Chinese)

2018/04/09

Post Views: 71 1. RESTful web service, it is recommended to implement based on a separate interface application, at this time, it is implemented based on the API application 2. Create a new directory: \api\rests, this directory will be used as the operation method category directory of the RESTful web service 3. Create a new controller class \API\Controllers\UserController.php , and…
Based on yiisoft/yii2-app-advanced, create a new repository yii2-app-advanced on github, and create a new interface application (implement RESTful-style web service services. API), implement model hierarchy: data layer, logic layer, clarify common directory, application, module inheritance, reference relationship

2018/04/04

Post Views: 67 1. Definition and specification: Define: (1) Data layer: Models is used to define automatic verification and automatic completion and data access interfaces related to data; (2) Logical layer: Logics is used to define the business logic related to data; Specification: (1) The model class file in the /common/models directory is only allowed to be generated by the…
Dynamic configuration of database connection in Yii 2 Starter Kit, the configuration attribute comes from the multi-tenant system

2018/01/18

Post Views: 13 1. The multi-tenant system contains multiple tenants, and each tenant has its own database configuration information. The existing requirement is to connect the database based on the response host name, user name and password, as shown in Figure 1. 2. Now it is configured as an application component, \common\config\base.php, as shown in Figure 2 3. Open dubug,…
Under WINDWOS 10 and PHP 7.1.12 Based on Yii 2 Starter Kit, the background application is replicated as an interface application to realize the process of RESTful Web service.

2018/01/10

Post Views: 14 1. In Windows PowerSHLL, enter the E:\wwwroot\cmcp-api directory, as shown in Figure 1 2. Create a new application API, copy the backend directory as the API, as shown in Figure 2 3. Edit \.env.dist, add API-related configuration, this is the configuration file submitted to Git version control, as shown in Figure 3 4. Edit \.env, add the…
In CakePHP 2.10.3, print the already executed SQL statement flow in the controller

2017/10/27

Post Views: 13 1. Edit \app\config\core.php, configure::write(debug, 2), as shown in Figure 1 2. Edit \App\View\Layouts\Base.ctp, <?php echo $this->element(sql_dump); ?>, as shown in Figure 2 3. After the GET request, print out the SQL statement that has been executed in the view, as shown in Figure 3 4. If it is a POST request, after the final execution is successful,…
Importing oversized SQL files in MySQL Query Brower

2017/09/14

Post Views: 14 1. Since too large SQL files cannot be imported in phpmyadmin, I decided to import them in mysql query browser, as shown in Figure 1 2. The SQL file size is: 186MB, as shown in Figure 2 3. Click the Execute button to execute the script, as shown in Figure 3 4. During the execution process, the…
When using Navicat 12 for MySQL, when running the SQL file, an error is reported:[ERR]2013 – Lost Connection to MySQL Server During Query

2017/08/23

Post Views: 43 1. When running the SQL file, an error is reported:[ERR]2013 – Lost Connection to MySQL Server During During Query, as shown in Figure 1 [错误]2013 – Loss of connection to mysql server during query 2. Open the directory C:\ProgramData\MySQL\MySQL Server 5.7, edit the my.ini file, as shown in Figure 2 3. Change max_allowed_packet=4m to max_allowed_packet=256m, as shown…