Подскажите пожалуйста! Есть парсер который добавляет товары в VirtueMart из XML.
Проблема в том что он добавляет только категории 2-го уровня, как мне добавить категорию 3-го уровня вроде всё прописываю, но получается полная ерунда…
Вот код на котегории 2-го уровня:
$query = "Select category_id from krp_vm_category where category_name='".str_replace($catname,$replname,mysql_escape_string($group))."'";
$result = mysql_query($query);
$result = mysql_fetch_array($result);
$gr_id = $result[0];
if(is_null($gr_id)){
$query = "Insert into krp_vm_category set category_name='".str_replace($catname,$replname,mysql_escape_string($group))."',category_description='',category_thumb_image='',category_full_image='',category_publish='Y',vendor_id=1,category_browsepage='my_browse',products_per_row='1'";
mysql_query($query);
$result = mysql_query("select last_insert_id()");
$result = mysql_fetch_array($result);
$gr_id = $result[0];
$query = "insert into krp_vm_category_xref set category_child_id=$gr_id,category_parent_id=0";
mysql_query($query) or die("Invalid query, element: $i, group");
}
$query = "Select category_id from krp_vm_category where category_name='".str_replace($catname,$replname,mysql_escape_string($category))."'";
$result = mysql_query($query);
$result = mysql_fetch_array($result);
$c_id = $result[0];
if(is_null($c_id)){
$query = "Insert into krp_vm_category set category_name='".str_replace($catname,$replname,mysql_escape_string($category))."',category_description='',category_thumb_image='',category_full_image='',category_publish='Y',vendor_id=1,category_browsepage='my_browse1',products_per_row='1'";
mysql_query($query) or die( "<br>".mysql_errno().":".mysql_error()."<br>Invalid query, element: $i, category, insert into categories<br>");
$result = mysql_query("select last_insert_id()");
$result = mysql_fetch_array($result);
$c_id = $result[0];
$query = "insert into krp_vm_category_xref set category_child_id=$c_id,category_parent_id=$gr_id";
mysql_query($query) or die( mysql_errno().":".mysql_error()."<br>Invalid query, element: $i, category, insert into categories_description<br>");
}
и то что прописываю я:
$query = "Select category_id from krp_vm_category where category_name='".str_replace($catname,$replname,mysql_escape_string($groupgl))."'";
$result = mysql_query($query);
$result = mysql_fetch_array($result);
$gr_id = $result[0];
if(is_null($gl_id)){
$query = "Insert into krp_vm_category set category_name='".str_replace($catname,$replname,mysql_escape_string($groupgl))."',category_description='',category_thumb_image='',category_full_image='',category_publish='Y',vendor_id=1,category_browsepage='my_browse',products_per_row='1'";
mysql_query($query);
$result = mysql_query("select last_insert_id()");
$result = mysql_fetch_array($result);
$gl_id = $result[0];
$query = "insert into krp_vm_category_xref set category_child_id=$gl_id,category_parent_id=0";
mysql_query($query) or die("Invalid query, element: $i, groupgl");
}
$query = "Select category_id from krp_vm_category where category_name='".str_replace($catname,$replname,mysql_escape_string($group))."'";
$result = mysql_query($query);
$result = mysql_fetch_array($result);
$gr_id = $result[0];
if(is_null($gr_id)){
$query = "Insert into krp_vm_category set category_name='".str_replace($catname,$replname,mysql_escape_string($group))."',category_description='',category_thumb_image='',category_full_image='',category_publish='Y',vendor_id=1,category_browsepage='my_browse1',products_per_row='1'";
mysql_query($query) or die( "<br>".mysql_errno().":".mysql_error()."<br>Invalid query, element: $i, category, insert into group<br>");
$result = mysql_query("select last_insert_id()");
$result = mysql_fetch_array($result);
$gr_id = $result[0];
$query = "insert into krp_vm_category_xref set category_child_id=$gr_id,category_parent_id=gl_id";
mysql_query($query) or die( mysql_errno().":".mysql_error()."<br>Invalid query, element: $i, group, insert into categories_description<br>");
}
$query = "Select category_id from krp_vm_category where category_name='".str_replace($catname,$replname,mysql_escape_string($category))."'";
$result = mysql_query($query);
$result = mysql_fetch_array($result);
$c_id = $result[0];
if(is_null($c_id)){
$query = "Insert into krp_vm_category set category_name='".str_replace($catname,$replname,mysql_escape_string($category))."',category_description='',category_thumb_image='',category_full_image='',category_publish='Y',vendor_id=1,category_browsepage='my_browse1',products_per_row='1'";
mysql_query($query) or die( "<br>".mysql_errno().":".mysql_error()."<br>Invalid query, element: $i, category, insert into categories<br>");
$result = mysql_query("select last_insert_id()");
$result = mysql_fetch_array($result);
$c_id = $result[0];
$query = "insert into krp_vm_category_xref set category_child_id=$c_id,category_parent_id=$gr_id";
mysql_query($query) or die( mysql_errno().":".mysql_error()."<br>Invalid query, element: $i, category, insert into categories_description<br>");
}
подскажите, что я делаю не так
23.02.2017, 15:15:42