thinkphp realizes mailbox activation when users register
When some websites register, they will send email to the user's mailbox. Click the link in the email to activate the account. The basic principle is to save the user's information into the database at the time of registration (i.e. Click to send email). In addition, there is an activated field (default is not activated) that clicks the link in ...
Added by guyfromfl on Wed, 08 Apr 2020 07:46:04 +0300
Gausdb t distributed cluster deployment and upgrade Guide
In this paper, we use four nodes to deploy the gausdb t 1.0.1 distributed cluster, and then upgrade it to version 1.0.2 after the deployment is completed (install version 1.0.2 directly, during the installation process, segment fault will be reported, which has not been resolved yet). Refer to the previous articles for the preparation of the o ...
Added by Michael on Tue, 07 Apr 2020 14:16:59 +0300
Openstack control host installation and configuration process III
1. Environment configuration
Hosts configuration modify the / etc/hosts file and add wtcontroller, wtcompute1 and wtcompute2:
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
172.16.10.100 wtcontroller
172.16.10.101 wtcompu ...
Added by fastidious on Tue, 07 Apr 2020 12:54:15 +0300
Using SMO to programmatically generate SQL Server table data
As a part of ETL, sometimes you need to generate the Insert script of the data, and then copy the human flesh to another place for execution.
Students who are familiar with SMSS all know that there is a task of generating scripts, which can generate database create scripts, and in fact can also produce data in tables.
Automatic ETL can't even e ...
Added by michalchojno on Mon, 06 Apr 2020 17:33:04 +0300
EF multi tenant instance: fast implementation of sub database and sub table
Preface
In this essay, we continue to demonstrate how to implement EF multi tenancy.
Today, we mainly demonstrate the transformation under multi tenancy, as shown in the following figure
Implementation
Project structure
This time, our sample project is streamlined, with only one API project, directly containing all the code.
As ...
Added by akumakeenta on Mon, 06 Apr 2020 04:53:13 +0300
ios local various paths, cache, etc
Caching images locally is used in many scenarios. If only storing file information, it is convenient to build a plist file or database to solve the problem, but it is not so convenient to store images in sandbox. Here are two simple ways to save pictures to sandbox.
1, Save the image as a base64 string in the database o ...
Added by yaron on Sun, 05 Apr 2020 13:34:35 +0300
ZABBIX server suddenly goes down
Reference document
https://blog.51cto.com/seekerwolf/2357220
https://www.centos.bz/2017/08/zabbix-zbx_mem_malloc-out-of-memory/
Environmental Science
CentOS 7.5.1804
Zabbix 3.4.15
phenomenonzabbix web graphical interface shows that zabbix server is not running. Enter zabbix server systemctl status zabbix server display service to down
Troubles ...
Added by codects on Sun, 05 Apr 2020 09:01:15 +0300
Automated installation of unattended batch scripts for SQL Server 2014 Enterprise Edition
_Copyright Statement: This is an original article created by a blogger and may not be reproduced without the permission of the blogger.
SQL Server series software is a relational database management system introduced by Microsoft.At a conference in San Francisco on April 16, 2014, Microsoft CEO Satia Nadela officially launched "SQL Ser ...
Added by blade_922 on Sun, 05 Apr 2020 08:45:43 +0300
JDBC of database
JDBC
JDBC(Java Database Connectivity)
Java database connection specification (a set of interfaces) provided by Sun company
JDBC core class
DriverManager create connection
Connection connection class
Statement execute sql statement
ResultSet result set
JDBC connection steps
1. Registration driver
2. ...
Added by thinguy on Sat, 04 Apr 2020 18:04:51 +0300
Executing SQL statements with PDO
There are two methods to execute SQL statements in PDO:
1. exec() is used to process statements that do not return SQL results, such as insert update delete create, etc., but it will return the number of affected rows
If you are executing an insert statement, you can use the lastinsertid() method to get t ...
Added by flOid on Sat, 04 Apr 2020 11:29:40 +0300