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