php 多個(gè)關(guān)鍵字智能查詢解決方法
Jun 13, 2016 pm 12:01 PM
php 多個(gè)關(guān)鍵字智能查詢
求助?需求如下
當(dāng)我輸入網(wǎng)站?就出現(xiàn)網(wǎng)站建設(shè)?網(wǎng)站制作?網(wǎng)站設(shè)計(jì)?等類似的多個(gè)關(guān)鍵詞
當(dāng)我選擇四川(或者北京?上海等全國(guó)地名)?就出現(xiàn)成都網(wǎng)站建設(shè)?成都網(wǎng)站制作等多個(gè)地名
可以智能提示?比如四川網(wǎng)站建設(shè)哪家好??四川成都網(wǎng)站建設(shè)公司哪家最好等類似語(yǔ)句?
尋求思路?謝謝
------解決方案--------------------
要做好一些數(shù)據(jù)關(guān)聯(lián)的表
例如四川可以關(guān)聯(lián)到成都的地區(qū)關(guān)聯(lián)。
------解決方案--------------------
你是想組詞造句呢?還是想查詢?
------解決方案--------------------
把那堆詞句入庫(kù),后臺(tái)弄個(gè)頁(yè)面管理編輯唄?可以再加個(gè)分類哈
當(dāng)前臺(tái)輸入文字(比如成都)時(shí)觸發(fā)事件,ajax提交到后臺(tái),sql語(yǔ)句用?like?'%成都%'?查出關(guān)聯(lián)詞句,打個(gè)json包輸出給前臺(tái)
如果要實(shí)現(xiàn)輸入四川提示成都XXX這種,就多加個(gè)關(guān)聯(lián)文字的字段,然后前臺(tái)輸入唄
比如我輸入一個(gè)詞?成都網(wǎng)站制作?另一個(gè)輸入框可以輸入?成都四川網(wǎng)建?等等擴(kuò)展詞?到時(shí)候一起查?2個(gè)like用或連起來(lái)就歐了
------解決方案--------------------
做什么用?是寫(xiě)文章還是當(dāng)槍手?
------解決方案--------------------
你的句子不是有那六種詞組成的嗎?
分別把他們放到數(shù)組里,并補(bǔ)一個(gè)空元素
在?6?層嵌套循環(huán)里轉(zhuǎn)就是了
唯一的約束條件就是?簡(jiǎn)單核心詞?和?復(fù)雜核心詞?不能同時(shí)為空
------解決方案--------------------
成都哪家網(wǎng)站制作公司收費(fèi)最便宜
成都哪家網(wǎng)站制作公司制作的網(wǎng)站最好??比如說(shuō)這樣的??成都地名可以變?網(wǎng)站制作也可以變?后面那句公司收費(fèi)最便宜?和公司制作的網(wǎng)站最好??你是說(shuō)把他們?nèi)霂?kù)??然后地方?和公司制作這樣的在分別入庫(kù)??然后用ajax提交??在連接出來(lái)?這樣做么?
仔細(xì)看了下3樓后的回帖,發(fā)現(xiàn)我原來(lái)的理解可能錯(cuò)了,無(wú)視吧...
沒(méi)有看明白你的需求,

------解決方案--------------------
換個(gè)瀏覽器,
------解決方案--------------------
嵌套太多了。
------解決方案--------------------
coreseek+php

Hot AI Tools

Undress AI Tool
Undress images for free

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

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

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

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

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

In PHP, you can use square brackets or curly braces to obtain string specific index characters, but square brackets are recommended; the index starts from 0, and the access outside the range returns a null value and cannot be assigned a value; mb_substr is required to handle multi-byte characters. For example: $str="hello";echo$str[0]; output h; and Chinese characters such as mb_substr($str,1,1) need to obtain the correct result; in actual applications, the length of the string should be checked before looping, dynamic strings need to be verified for validity, and multilingual projects recommend using multi-byte security functions uniformly.

AgeneratorinPHPisamemory-efficientwaytoiterateoverlargedatasetsbyyieldingvaluesoneatatimeinsteadofreturningthemallatonce.1.Generatorsusetheyieldkeywordtoproducevaluesondemand,reducingmemoryusage.2.Theyareusefulforhandlingbigloops,readinglargefiles,or

To prevent session hijacking in PHP, the following measures need to be taken: 1. Use HTTPS to encrypt the transmission and set session.cookie_secure=1 in php.ini; 2. Set the security cookie attributes, including httponly, secure and samesite; 3. Call session_regenerate_id(true) when the user logs in or permissions change to change to change the SessionID; 4. Limit the Session life cycle, reasonably configure gc_maxlifetime and record the user's activity time; 5. Prohibit exposing the SessionID to the URL, and set session.use_only

You can use substr() or mb_substr() to get the first N characters in PHP. The specific steps are as follows: 1. Use substr($string,0,N) to intercept the first N characters, which is suitable for ASCII characters and is simple and efficient; 2. When processing multi-byte characters (such as Chinese), mb_substr($string,0,N,'UTF-8'), and ensure that mbstring extension is enabled; 3. If the string contains HTML or whitespace characters, you should first use strip_tags() to remove the tags and trim() to clean the spaces, and then intercept them to ensure the results are clean.

There are two main ways to get the last N characters of a string in PHP: 1. Use the substr() function to intercept through the negative starting position, which is suitable for single-byte characters; 2. Use the mb_substr() function to support multilingual and UTF-8 encoding to avoid truncating non-English characters; 3. Optionally determine whether the string length is sufficient to handle boundary situations; 4. It is not recommended to use strrev() substr() combination method because it is not safe and inefficient for multi-byte characters.

The urlencode() function is used to encode strings into URL-safe formats, where non-alphanumeric characters (except -, _, and .) are replaced with a percent sign followed by a two-digit hexadecimal number. For example, spaces are converted to signs, exclamation marks are converted to!, and Chinese characters are converted to their UTF-8 encoding form. When using, only the parameter values ??should be encoded, not the entire URL, to avoid damaging the URL structure. For other parts of the URL, such as path segments, the rawurlencode() function should be used, which converts the space to . When processing array parameters, you can use http_build_query() to automatically encode, or manually call urlencode() on each value to ensure safe transfer of data. just

To set and get session variables in PHP, you must first always call session_start() at the top of the script to start the session. 1. When setting session variables, use $_SESSION hyperglobal array to assign values ??to specific keys, such as $_SESSION['username']='john_doe'; it can store strings, numbers, arrays and even objects, but avoid storing too much data to avoid affecting performance. 2. When obtaining session variables, you need to call session_start() first, and then access the $_SESSION array through the key, such as echo$_SESSION['username']; it is recommended to use isset() to check whether the variable exists to avoid errors

Key methods to prevent SQL injection in PHP include: 1. Use preprocessing statements (such as PDO or MySQLi) to separate SQL code and data; 2. Turn off simulated preprocessing mode to ensure true preprocessing; 3. Filter and verify user input, such as using is_numeric() and filter_var(); 4. Avoid directly splicing SQL strings and use parameter binding instead; 5. Turn off error display in the production environment and record error logs. These measures comprehensively prevent the risk of SQL injection from mechanisms and details.
