How to use sphinx technology in our PHP development?
Answer: Corresponding to the fields in the MySQL database, it means splitting the Chinese information in the fields into multiple words, and then indexing these words. When querying in the future, first query these index files, then return the primary key IDs of the records that meet the conditions, and then query the MySQL database based on the primary key IDs to return the records.
What is sphinx? (Baidu Encyclopedia)
Note: For sphinx, if there are tens of millions of records in a single table, the response time is at the millisecond level.
Note: By default sphinx only supports English and Russian
Official website:
http://sphinxsearch.com/
Since Sphinx only supports the above two languages, a third-party company has developed a middle segmentation package for sphinx called coreseek
Official website:
http://www.coreseek.cn/
Customer case: http://www.coreseek.cn/products/ft_powered/
Note two points:
sphinx is a full-text search engine that only supports Russian and English
Due to the above reasons, a specialized company has developed a Chinese word segmentation package called coresesk.
-
There is a company in China that does a better job (massive word segmentation)
http://www.hylanda.com/
Story: http://home.hylanda.com/show_5_19.html
Practical operation
-
Download
2. Build a big data table (lyrics table)
mysql > source d:/songs.sql
File Directory:
Command:
sphinx installation-use
Installation
Please note: sphinx configuration file must not be opened using Windows Notepad. (BOM header)
API interface file: You can use php to call this interface to operate the index file on the sphinx server side.
-
Modify configuration file
Index file
Memory settings:
sphinxd configuration:
-
Indexing
The name after index in the configuration file
Directory structure after indexing
3. Actual use
a. Start the sphinx service and use the help information to see how to use it.
Use:
You can read the configuration file separately and run it
-
can also be installed as a system service in Windows to run
Start the sphinx service (read the configuration file for a single start)
is defined as after system service (installation)
Use
1. Specific use (sphinx process can be seen in the picture below)
sphinx flow chart:
sphinx storage engine: Through the following steps, we found that when the PHP program performs a query, it must first return the primary key ID based on the sphinx server, then query the MySQL database based on the primary key ID, and finally return the database.
At this time, you can think like this, use sphinx as a storage engine of MySQL. At this time, the php program can directly connect to the MySQL server, and the MySQL server obtains the word segmented data from its own sphinx storage engine. There is no need to connect to the sphinx server once. This storage engine is called sphinxSE.
http://blog.csdn.net/uestc_huan/article/details/6395145
-
Easy to use
-
use
The above has introduced learning sphinx, including sphinx content. I hope it will be helpful to friends who are interested in PHP tutorials.

Setting session cookie parameters in PHP can be achieved through the session_set_cookie_params() function. 1) Use this function to set parameters, such as expiration time, path, domain name, security flag, etc.; 2) Call session_start() to make the parameters take effect; 3) Dynamically adjust parameters according to needs, such as user login status; 4) Pay attention to setting secure and httponly flags to improve security.

The main purpose of using sessions in PHP is to maintain the status of the user between different pages. 1) The session is started through the session_start() function, creating a unique session ID and storing it in the user cookie. 2) Session data is saved on the server, allowing data to be passed between different requests, such as login status and shopping cart content.

How to share a session between subdomains? Implemented by setting session cookies for common domain names. 1. Set the domain of the session cookie to .example.com on the server side. 2. Choose the appropriate session storage method, such as memory, database or distributed cache. 3. Pass the session ID through cookies, and the server retrieves and updates the session data based on the ID.

HTTPS significantly improves the security of sessions by encrypting data transmission, preventing man-in-the-middle attacks and providing authentication. 1) Encrypted data transmission: HTTPS uses SSL/TLS protocol to encrypt data to ensure that the data is not stolen or tampered during transmission. 2) Prevent man-in-the-middle attacks: Through the SSL/TLS handshake process, the client verifies the server certificate to ensure the connection legitimacy. 3) Provide authentication: HTTPS ensures that the connection is a legitimate server and protects data integrity and confidentiality.

What’s still popular is the ease of use, flexibility and a strong ecosystem. 1) Ease of use and simple syntax make it the first choice for beginners. 2) Closely integrated with web development, excellent interaction with HTTP requests and database. 3) The huge ecosystem provides a wealth of tools and libraries. 4) Active community and open source nature adapts them to new needs and technology trends.

PHP and Python are both high-level programming languages that are widely used in web development, data processing and automation tasks. 1.PHP is often used to build dynamic websites and content management systems, while Python is often used to build web frameworks and data science. 2.PHP uses echo to output content, Python uses print. 3. Both support object-oriented programming, but the syntax and keywords are different. 4. PHP supports weak type conversion, while Python is more stringent. 5. PHP performance optimization includes using OPcache and asynchronous programming, while Python uses cProfile and asynchronous programming.

PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.

PHP originated in 1994 and was developed by RasmusLerdorf. It was originally used to track website visitors and gradually evolved into a server-side scripting language and was widely used in web development. Python was developed by Guidovan Rossum in the late 1980s and was first released in 1991. It emphasizes code readability and simplicity, and is suitable for scientific computing, data analysis and other fields.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

Zend Studio 13.0.1
Powerful PHP integrated development environment

Notepad++7.3.1
Easy-to-use and free code editor

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.