Tag: MySQL
-
Post Views: 15 1. Please refer to the previous blog:https://www.shuijingwanwq.com/en/2016/11/26/10288/ 2. Prepare to implement RESTful web services based on shujujixi 3. Based on the GII generation model on the Frontend application, edit \environments\dev\frontend\config\main-local.php, as shown in Figure 1 4. Execute .\init in Windows PowerShell to overwrite \frontend\config\main-local.php, and set the IP allowed by GII, as shown in Figure 2 5.…
-
Post Views: 14 1. Install yii2-starter-kit under Windows 10 and Nginx 1.10, and run on the command line: php console/yii app/setup, as shown in Figure 1 2. Error: create unique index IDx_article_slug on {{%article}} (slug) …exception: sqlstate[42000]: Syntax error or access Violation: 1071 specific key was too long; max key length is 767 bytes, as shown in Figure 2 Translation:…
-
Post Views: 13 1. Based on the authorization of WeChat webpage, the nickname obtained: 🌵yangqin🍬✨, as shown in Figure 1: 2. The relevant information of WeChat users obtained, as shown in Figure 2: 3. The first solution, in order to make mysql support the storage of letters, modify the collation as: utf8mb4_general_ci, as shown in Figure 3: 4. The execution…
-
Post Views: 11 1. ;extension=php_mysql.dll, disable mysql extension in php.ini; 2. In the function dependency check, mysqli_connect is supported; 3. After installation, open the blank; 4. Delete the program file, copy the file to the installation directory, edit discuz_x3.2_sc_utf8/source/class/discuz/discuz_database.php, and find the function quote, modify, because it does not make the judgment of extended support: tiveting if (is_string($str)) return\. mysql_escape_string($str)…
-
Post Views: 13 1. The $QUERY code implements screenshots: 2. Error: sqlstate[HY093]: Invalid parameter number: number of bound variables not match number of tokens\nthe sql being executed was 3. After the $query is modified, the screenshot is realized, and the $query->addParams is cancelled: 4. $Query is successfully implemented
-
Post Views: 11 1. Use Putty to connect to the server remotely; 2. The current operating system is CentOS 6.5 64-bit. 3. Check the disk space usage, command: df-h 4. Check the disk space usage, including the data disk that has not been mounted, command: fdisk-l Friendly reminder: If you execute the fdisk -l command and find that there is…
-
Post Views: 14 An error is reported in this step, but the screenshot is not sorted, and finally I have to modify $cfg on the server phpmyadmin[‘Servers’][$i][‘controlhost’]=localhost; Only the steps to successfully copy the root user successfully realize the successful step.
-
Post Views: 14
-
Post Views: 13
-
Post Views: 14 In order to make the test environment of the intranet as much as possible to the online production environment, the httpd, ftp, mysql, etc. of the intranet are all installed on the CentOS 6.5 64 bit, but my development environment is still Windows 8.1 64-bit, and the program is also in the development environment, so the problem…