?? ?? PHP ? MySQL?? ?? ???? ??? ?? ??? ????? ???? ??? ??????
Oct 31, 2024 pm 07:23 PM
?? ???? ??? ?? ???:
???????? ??? ???? ?? ?? ?? ??? ???? ?? ? ???? ???? ??? ? ????. ?? ? ?????? ??? ???? ?? PHP ? MySQL?? ?? ????? ?? ?? ????? ???? ??? ??? ??? ? ????.
??? ??? ???? ??-?? ??? ???? parent_id ??? ????. . ?? ??? ????? ??? ?? ??? ?????:
<code class="php">function build_menu($page_objects) {
// Create an array to store parent-child relationships
$parents = array();
// Loop through the page objects
foreach ($page_objects as $page) {
$parents[$page['id']] = $page['parent_id'];
}
// Initialize the menu string
$menu = '';
// Loop through the page objects again
foreach ($page_objects as $page) {
// Check if the current page has no parent (root page)
if (!isset($parents[$page['id']])) {
$menu .= "<ul><li>{$page['title']}";
}
// Handle child pages
else {
$parent_id = $parents[$page['id']];
// Find the parent 'ul' tag for the child page
$parent_index = strrpos($menu, "<li>{$page_objects[$parent_id]['title']}");
// Append the child page to the parent 'ul' tag
$menu = substr_replace($menu, "<li>{$page['title']}", $parent_index + strlen($page_objects[$parent_id]['title']) + 4, 0);
}
// Close the 'li' tag
$menu .= '</li>';
// Handle closing the 'ul' tag for root pages
if (!isset($parents[$page['parent_id']])) {
$menu .= "</ul>";
}
}
return $menu;
}</code>
???:
?? ??, ??? ??? ??? ????:
<code class="php">$page_objects = array(
array('id' => 1, 'title' => 'Menu 1', 'parent_id' => null),
array('id' => 2, 'title' => 'Sub 1.1', 'parent_id' => 1),
array('id' => 3, 'title' => 'Sub 1.2', 'parent_id' => 1),
array('id' => 4, 'title' => 'Sub 1.3', 'parent_id' => 1),
array('id' => 5, 'title' => 'Menu 2', 'parent_id' => null),
array('id' => 6, 'title' => 'Sub 2.1', 'parent_id' => 5),
array('id' => 7, 'title' => 'Sub Sub 2.1.1', 'parent_id' => 6),
array('id' => 8, 'title' => 'Sub 2.2', 'parent_id' => 5),
array('id' => 9, 'title' => 'Menu 3', 'parent_id' => null)
);</code>
?? ??? ????? ??:
<code class="php">$menu_html = build_menu($page_objects);</code>
??? ??? ?? ??? ???? ??? HTML ??? ?????.
? ??? ?? ?? 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 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?? 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 ? ? ???? 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 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? ???? ?? ? ????? ???? ???? ?????? ???? ?? ? ? ?? ?? ??? ????? ??????.
MySQL?? ??? ?? ???? ???? ??? ????.
Jul 05, 2025 am 02:42 AM
GroupBy? ???? ???? ????? ?? ??? ???? ? ???? ??? ? ??? ????? ? ?????. ?? ??, GroupByCustomer_ID? ???? ? ??? ? ???? ??? ? ????. ???? ? 1,000 ? ??? ? ??? ??? ?? ? ? ????. ?? ? ? ?? ??? GroupBy? ??????, ?? ?? ?? ???? ???? ??? ??? ? ? ????. ???? ???? ? ??? ? ??, ?? ?? ??? ? ?? ???? ???? ?????.
MySQL?? ???? ?? ? ?? ?? ??
Jul 08, 2025 am 02:50 AM
MySQL? ???? ??? ???? InnoDB ?? ??? ???? ??? ???? ???? ?????. 1. ????? ??? SQL ?? ????, ?? ?? ?? ?? ??? ?????. 2. ? ???? ???, ???, ?? ? ???? ?????. 3. ????? ???? ????? ??? STARTTRANSACTION, CONMING ? ROLLBACK???. 4. 4 ?? ?? ???? ?? ??, ?? ? ??, ?? ??? ?? ? ???? ?????. 5. ????? ???? ???? ?? ??? ??? ?? ??? ?? ?? ? ??? ????? ??????. ??? ????? ?? MySQL? ?? ???? ?? ??? ?? ? ? ????.
