- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
$path = "a/b/c/d";
$sections = array_reverse (explode ("/", $path));
$sql = "SELECT `t1`.`id` FROM ";
for ($i = 1; $i <= count ($sections); $i ++)
$from_tables[] = "`test` `t".$i."`";
$sql = $sql.implode (", ", $from_tables);
$sql .= " WHERE ";
for ($i = 1; $i < count ($sections); $i ++)
$sql .= "`t".$i."`.`parent_id` = `t".($i+1)."`.`id` AND `t".$i."`.`name` = '".$sections[$i-1]."' AND";
$sql .= " `t".count ($sections)."`.`parent_id` = '0' AND `t".count ($sections)."`.`name` = '".$sections[count($sections)-1]."'";
echo $sql;
Комментарии (1) RSS