Arkadaşlar aşapıdaki kodda
Could not insert into table trial.Column count doesn't match value count at row
diye hata veriyor insert into komutlarının tamamını denedim ama hata ordan kaynaklanmıyor galiba size zahmet hata nerde söyleyebilirmisiniz kod ve xml aşağıda
<?
$connection = mysql_connect("localhost","xxx", "xxx") or die ("could not connect to database");
$db = mysql_select_db("xxx",$connection) or die ("Couldn't select database.");
$p = xml_parser_create(); //Create XML parser and get a handle
//file(filename) reads file in an array
//implode will give data string to be inserted into database
//file(filename) reads file in an array
//implode will give data string to be inserted into database
$data = implode("",file("kategori.xml")) or die(mysql_error());
xml_parser_set_option($p,XML_OPTION_CASE_FOLDING,0);//Will not convert tags in upper case
xml_parser_set_option($p,XML_OPTION_SKIP_WHITE,20); //Probably will skip white spaces not sure
xml_parse_into_struct($p,$data,$vals,$index); //Read from manual
xml_parser_free($p); //Free parser
{
if($vals[$i][tag]=="PRODUCT")
{
$i++;
continue;
}
$val_index=$i;
$j=0;
while($j < count($vals[$val_index]))
{
$value_array[$j]=$vals[$val_index][value];
$val_index++;
$j++;
}
$i=$val_index-1;
mysql_query("insert into trial values(2,'$value_array[1]','$value_array[2]','$value_array[3]',' $value_array[4]') ") or die("Could not insert into table trial.".mysql_error());
$i++;
}
?>
<?xml version="1.0" ?>
- <result>
- <PRODUCT>
<aaa>3</aaa>
<bbb>Category2</bbb>
<ccc>0</ccc>
<ddd>2</ddd>
<deee>41</deee>
</PRODUCT>
- <PRODUCT>
<aaa>2</aaa>
<bbb>Category 1</bbb>
<ccc>0</ccc>
<ddd>1</ddd>
<deee>11</deee>
</PRODUCT>
- <PRODUCT>
<aaa>4</aaa>
<bbb>Sub Category1</bbb>
<ccc>2</ccc>
<ddd>1</ddd>
<deee>8</deee>
</PRODUCT>
- <PRODUCT>
<aaa>5</aaa>
<bbb>Sub Category2</bbb>
<ccc>3</ccc>
<ddd>2</ddd>
<deee>2</deee>
</PRODUCT>
</result>