function get_url($id, $title = '', $type = '')
{
$type = !empty($type) ? $type : 'cat';
if (strstr($title, '.html')) {
//带.html的为已过滤标题的URL
$title = str_replace('.html', '', $title);
} else {
$title = filter_urlstr($title);
}
switch ($type) {
case 'cat':
$url = $title . '-' . CATE_STR . '-' . $id . '.html';
break;
case 'art':
//文章页
$url = $title . '-' . ART_STR . '-' . $id . '.html';
break;
default:
$url = $title . '-' . ART_STR . '-' . $id . '.html';
}
//var_dump($_SERVER);
$url = dis_base_url() . '/' . $url;
return $url;
}
$mptt_left = ++$num_tag_id;
$mptt_right = ++$num_tag_id;
// $num_tag_id=$num_tag_id+1;
// 切割标签
$arr = explode(",", $term);
// if($num==4)
// {
// $arr=explode(",", $goods_list[$num][3]);
// var_dump($arr);
// exit;
// }
$fir_id = DB::query('INSERT INTO {posts} (slug,content_type,title,guid,content,cached_content,user_id,pubdate,status) VALUES (?,?,?,?,?,?,?,?,?)', array($slug, $content_type, $title, $guid, $content, $cached_content, $user_id, $pubdate, $status));
$haha = 1;
foreach ($arr as $key) {
$key = filter_urlstr($key);
$sec_id = DB::query('INSERT INTO {terms} (term,term_display,vocabulary_id,mptt_left,mptt_right) VALUES (?,?,?,?,?)', array(filter_urlstr($key), filter_urlstr($key), 1, $term_id_test, $term_id_test + 1));
// echo $haha."-------------".$key."<br/>";
$num_id = DB::last_insert_id() . "<br/>";
$three_id = DB::query('INSERT INTO {object_terms} (object_id,term_id,object_type_id) VALUES (?,?,?)', array($num_test1, $num_id, $object_type_id));
$haha = $haha++;
$term_id_test = $term_id_test + 2;
}
$num_test1 = $num_test1 + 1;
// 插入数据
// DB::query( 'INSERT INTO {object_terms} (object_id,term_id,object_type_id) VALUES (?,?,?)', array($num+1 ,$num+1,$object_type_id) );
$num_id = DB::last_insert_id();
// $num_id=DB::last_insert_id();
// $vocabulary_id=DB::last_insert_id();
// DB::query('INSERT INTO {terms} (term,term_display,vocabulary_id) VALUES ("zhansgasn","qqqq",1)');
// $terms = DB::query( 'INSERT INTO {terms} (term,term_display,vocabulary_id,mptt_left,mptt_right) VALUES (?,?,?,?,?)', array( $term,$term_display,$vocabulary_id,$mptt_left,$mptt_right) );
// DB::query('INSERT INTO {terms} (term) VALUES (?)', array("zhansgan") );
