?? ??? ?? PHP? MySQL? ?? ?? ?? ??
??
?? ?? ??? ?? ?? ??? ?? ?? ????? ???? ?????. ? ??? ????? ???? ??? ?? ???? ?? ????? ???? ??? ??? ? ????.
Soundex Indexing
?? ??? ?? ? ?? ?? ??? Soundex? ???? ????. ???. Soundex? ??? ???? ??? ????? ?? ???????. ?? ?? ??? ?? ???? ??? ????? ???? ? ????. ??? Soundex ????? ? ???? ??? ? ?? ? ??? ???? ?? ?? ??? ????.
Levenshtein Distance
? ??? ?? ?? ?? ??? Levenshtein ??? ?????. Levenshtein ??? ? ???? ?? ???? ???? ? ??? ??, ?? ?? ?? ??? ?????. Soundex? ?? ? ???? ?? ??? ??? ????.
PHP?? Levenshtein Distance ??
codejanitor.com ????? MySQL ?? ??? ?? ?????. Levenshtein ??? ?????. ? ??? ???? ??? ?? ?? ??? ?? ?? ??? ??? ? ????.
// Load MySQL stored function (if not already loaded)
if (!function_exists('Levenshtein')) {
$sql = "CREATE FUNCTION Levenshtein(s1 VARCHAR(255), s2 VARCHAR(255)) RETURNS INT
BEGIN
DECLARE lv_s1, lv_s2 VARCHAR(255);
DECLARE lv_len1, lv_len2, lv_i, lv_j, lv_c, lv_cost INT;
DECLARE lv_arr1[255] INT;
SET lv_s1 = LOWER(s1);
SET lv_s2 = LOWER(s2);
SET lv_len1 = LENGTH(lv_s1);
SET lv_len2 = LENGTH(lv_s2);
-- Initialize the array
SET lv_arr1[1] = 0;
FOR lv_i = 1 TO lv_len1 DO
SET lv_arr1[lv_i + 1] = lv_i;
END FOR;
-- Step 2
FOR lv_j = 1 TO lv_len2 DO
SET lv_c = lv_j;
FOR lv_i = 1 TO lv_len1 DO
IF SUBSTRING(lv_s1, lv_i, 1) = SUBSTRING(lv_s2, lv_j, 1) THEN
SET lv_cost = 0;
ELSE
SET lv_cost = 1;
END IF;
SET lv_c = LEAST(lv_c + 1, lv_arr1[lv_i] + lv_cost, lv_arr1[lv_i - 1] + 1);
SET lv_arr1[lv_i] = lv_c;
END FOR;
END FOR;
RETURN lv_c;
END;";
$result = $mysqli->query($sql);
}
// Execute fuzzy matching query
$numWords = 0;
$userInput = "Microsift";
$query = "SELECT company_name, Levenshtein('$userInput', company_name) AS distance
FROM companies
ORDER BY distance ASC";
$result = $mysqli->query($query);
// Display results
while ($row = $result->fetch_assoc()) {
$numWords++;
echo $row['company_name'] . " (" . $row['distance'] . ")\n";
}
if ($numWords == 0) {
echo "No matches found.\n";
}? ??? ?? ??? ?? PHP? ???? MySQL?? ?? ?? ?? ??? ??? ??? ? ?????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!
? AI ??
Undress AI Tool
??? ???? ??
Undresser.AI Undress
???? ?? ??? ??? ?? AI ?? ?
AI Clothes Remover
???? ?? ???? ??? AI ?????.
Clothoff.io
AI ? ???
Video Face Swap
??? ??? AI ?? ?? ??? ???? ?? ???? ??? ?? ????!
?? ??
??? ??
???++7.3.1
???? ?? ?? ?? ???
SublimeText3 ??? ??
??? ??, ???? ?? ????.
???? 13.0.1 ???
??? PHP ?? ?? ??
???? CS6
??? ? ?? ??
SublimeText3 Mac ??
? ??? ?? ?? ?????(SublimeText3)
MySQL ??? ?? ??? ?? ?? ??
Jul 04, 2025 am 01:44 AM
TOSECIBERYNECTTOEREMOTEMYSQLSERVER, USESSHTUNNENG, CONFIGUREMYSQLFORREMOTEACCESS, SETFIREWALLRULES ? CONSIDERSSLENCRYPTION .First, SpectionANSSHTUNNELWITHSSH-L3307 : LocalHost : 3306user@remote-Server-NandConnectViamySQL-H127.0.1-P3307.second, editmys
MySQL ??? ????? ?? ?? ?? ??
Jul 03, 2025 am 02:34 AM
Relationshipsbetweentables.TheyPretorPhanEdrecords, andCancascadeCangeAutomically. BotheThustusEtheInnodbstorageEngine ? foreignKeyColumnsMatchThatteTeTeTeTeTeFeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTeTePle
MySQL?? mysqldump? ???? ?? ??? ?????
Jul 06, 2025 am 02:55 AM
MySQLDump? MySQL ??????? ??? ??? ???? ???? ?????. ??????? ???? ?? ?? ? ?? ?? ???? SQL ??? ?????. 1. ?? ??? ????? ??? ?????? ??? ???? ??? SQL ???? ?????. 2. ??? ?????? ?? ??? ??? ???? TB ?? ???? ?? ???? ???? ????. 3. ???? ???-single transaction,-databases,-all-databases,-routines ?; 4. MySQL ??? ???? ?? ?? ?? ?? ?? ? ??? ?? ??? ???? ? ????. 5. ??? ????? ????? ?? ? ?? ??? ???? ?? ????.
?? ?? ??? ?? ?? MySQL ?? ?? ?? ??
Jul 04, 2025 am 02:46 AM
MySQL ??? ?? ??? ?? ?? ??? ?? ??? ??????. 1. ?? ?? ?? ?? ???? Slow_Query_Log ? Long_Query_Time; 2. ???? ??? ?? ??? ???? ? ????? query_time, lock_time, rows_examined? ?? ?? ??? ???? ????. 3. ??? ????? ???? ?? mysqldumpslow ?? pt-query idigest ??? ??????. 4. ??? ???? ??? ??, ??*???*, ??? ?? ?? ?? ?????. ?? ??, user_id? ???? ???? ?? ? ?? ?? ?? ??? ?? ???? ???? ? ????.
MySQL ? ? ???? NULL ?? ?????
Jul 05, 2025 am 02:46 AM
MySQL?? NULL ?? ?? ? ? 1. ???? ?? ? ? ? ??? NotNull? ???? ?? ??? NULL? ?????. 2. iSnull ?? ISNOTNULL = ??! =; 3. Ifnull ?? Coalesce ??? ????? ???? ???? ? ??? ? ????. 4. ?? ?? ????? NULL ?? ?? ??? ?? ???? ??? ?? ? ORM ??? ?? ?? ?????? ??????. NULL? ???? ?? ?? ???? ??? ???? ?? ?? ?? ????. ??? ???? ??, ?? ? ???? ?? ? ??? ?? ??? ??? ?? ???????. ??? ??? ???? ??? ?? ?? ??? ????? ?? ? ????.
MySQL ??? ?? ???? ???
Jul 03, 2025 am 02:32 AM
MySQL? ?? ????? ?????? ?? ??? ?????. 1. MySQL ?? ??, sudosystemctlstopmysql ?? sudosystemctlstopmysqld? ??????. 2. -skip-grant-tables ???? mysql? ???? sudomysqld-skip-grant-tables &; 3. MySQL? ????? ?? SQL ??? ???? FlushPrivileges; Alteruser'Root '@'localHost'IndifiedBy'Your_new? ?? ??? ?? ????? ??????.
MySQL?? ?????? ? ??? ?? ??
Jul 06, 2025 am 02:41 AM
MySQL ?????? ? ???? ??? ??? information_schema? ?? ????? ?? ? ??? ??? ? ????. 1. ?? ?????? ?? ?? : SQL ?? ???? selecttable_schemaas'database ', sum (data_length index_length)/1024/1024as'size (mb) 'frominformation_schema.tablessgroupbytable_schema; ?? ??????? ? ??? ??? ?? ??????? ???? ??? ?? ? ? ????. 2. ?? ??? ??? ?????? : selectta? ??????
MySQL?? ??? ?? ? ???? ??? ?????
Jul 08, 2025 am 02:51 AM
?? ?? ? ?? ?? ??? ??? ??? ?????? ?? ??? ??? ?????? ??? ?????? ?????? ??? ?????. ? ?? ?? ???? ????. ??, ??????, ??? ? ??? ?? ??? UTF8MB4? ???? ???? ShowCreatedAtabase/Table? ???? ? Alter ??? ??????. ??, ?????? ??? ? UTF8MB4 ?? ??? ???? ?? ?? ??? ????? SetNames? ??????. ??, ?? ??? ????? ???? UTF8MB4_UNICODE_CI? ???? ?? ? ????? ???? ???? ?????? ???? ?? ? ? ?? ?? ??? ????? ??????.
