Ilidir
05-11-2014, 14:12
witam chciałbym dodać sobie do tabeli content nowy rekord poniżej przedstawiam kod:
$artykuladd = "INSERT INTO ofria_content(id, asset_id, title, alias, title_alias, introtext, fulltext, state, sectionid, mask, catid, created, created_by,
created_by_alias, modified, modified_by, checked_out, checked_out_time, publish_up, publish_down, images, urls, attribs, version, parentid, ordering,
metakey, metadesc, access, hits, metadata, featured, language, xreference) VALUES (NULL, '$id_asset', '$sama_nazwa_komisji', '$komisja_string', '', '<p>{jumi
[../$miasto_string/$sama_nazwa_komisji/index_skrypt_eodtest.php]}</p>', '', '1', '0', '0', '$id_kategori', '$data', '600', '', '0000-00-00 00:00:00', '0', '0',
'0000-00-00 00:00:00', '$data', '0000-00-00 00:00:00', '{\"image_intro\":\"\",\"float_intro\":\"\",\"image_intro_alt\":\"\",\"image_intro_caption\":\"\",
\"image_fulltext\":\"\",\"float_fulltext\":\"\",\"image_fulltext_alt\":\"\",\"image_fulltext_caption\":\"\"}', '{\"urla\":null,\"urlatext\":\"\",\"targeta\":\"\",\"urlb\":null,
\"urlbtext\":\"\",\"targetb\":\"\",\"urlc\":null,\"urlctext\":\"\",\"targetc\":\"\"}', '{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"show_category\":\"\",
\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",
\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",
\"show_vote\":\"\",\"show_hits\":\"\",\"show_noauth\":\"\",\"alternative_readmore\":\"\",\"article_layout\":\"\",\"show_publishing_options\":\"\",
\"show_article_options\":\"\",\"show_urls_images_backend\":\"\",\"show_urls_images_frontend\":\"\"}', '5', '0', '0', '', '', '0', '0', '{\"robots\":\"\",\"author\":\"\",
\"rights\":\"\",\"xreference\":\"\"}', '0', '*', '')"
or die('COŚ POSZŁO NIE TAK');
$artadd = mysql_query($artykuladd);
skrypt się wykonuje ale gdy podglądam w tabeli to tego rekordu nie ma niestety ;/ Jakieś sugestie ?????
pozdrawiam
$artykuladd = "INSERT INTO ofria_content(id, asset_id, title, alias, title_alias, introtext, fulltext, state, sectionid, mask, catid, created, created_by,
created_by_alias, modified, modified_by, checked_out, checked_out_time, publish_up, publish_down, images, urls, attribs, version, parentid, ordering,
metakey, metadesc, access, hits, metadata, featured, language, xreference) VALUES (NULL, '$id_asset', '$sama_nazwa_komisji', '$komisja_string', '', '<p>{jumi
[../$miasto_string/$sama_nazwa_komisji/index_skrypt_eodtest.php]}</p>', '', '1', '0', '0', '$id_kategori', '$data', '600', '', '0000-00-00 00:00:00', '0', '0',
'0000-00-00 00:00:00', '$data', '0000-00-00 00:00:00', '{\"image_intro\":\"\",\"float_intro\":\"\",\"image_intro_alt\":\"\",\"image_intro_caption\":\"\",
\"image_fulltext\":\"\",\"float_fulltext\":\"\",\"image_fulltext_alt\":\"\",\"image_fulltext_caption\":\"\"}', '{\"urla\":null,\"urlatext\":\"\",\"targeta\":\"\",\"urlb\":null,
\"urlbtext\":\"\",\"targetb\":\"\",\"urlc\":null,\"urlctext\":\"\",\"targetc\":\"\"}', '{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"show_category\":\"\",
\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",
\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_icons\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",
\"show_vote\":\"\",\"show_hits\":\"\",\"show_noauth\":\"\",\"alternative_readmore\":\"\",\"article_layout\":\"\",\"show_publishing_options\":\"\",
\"show_article_options\":\"\",\"show_urls_images_backend\":\"\",\"show_urls_images_frontend\":\"\"}', '5', '0', '0', '', '', '0', '0', '{\"robots\":\"\",\"author\":\"\",
\"rights\":\"\",\"xreference\":\"\"}', '0', '*', '')"
or die('COŚ POSZŁO NIE TAK');
$artadd = mysql_query($artykuladd);
skrypt się wykonuje ale gdy podglądam w tabeli to tego rekordu nie ma niestety ;/ Jakieś sugestie ?????
pozdrawiam