| Autor | Zpráva | ||
|---|---|---|---|
| jirivo Profil * |
#1 · Zasláno: 7. 7. 2009, 13:33:31
Mám rpoblém se zápisem dat do databáze, vždycky mě to napíše tuto chybu: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1246965671,'Y','N')' at line 1
Tady je kód:
if ($action=="submit_article_query") {
check_magic_quotes();
$keys = $fldsarr = Array();
foreach($_POST as $key => $val) {
$val = addslashes(trim($val));
$fldsarr []= "\"$val\"";
$keys []= "`".str_replace('ar_','art_',$key)."`";
}
$keys []= "`art_user_id`";
$keys []= "`art_date`";
$fldsarr []= $member['aut_id'];
$fldsarr []= time();
if($group['grp_show_richedit'] =='Y') {
$keys []= "`art_html`";
$fldsarr []= "'Y'";
$keys []= "`art_bbcode`";
$fldsarr []= "'N'";
} else {
$keys []= "`art_html`";
$fldsarr []= "'N'";
$keys []= "`art_bbcode`";
$fldsarr []= "'Y'";
}
$fldsarr = implode(",",$fldsarr);
$keys = implode(",",$keys);
mysql_query("INSERT INTO clanky_articles ($keys) VALUES ($fldsarr)") or cdie("aa:".mysql_error());
}
|
||
| fuckin Profil |
#2 · Zasláno: 7. 7. 2009, 16:13:19 · Upravil/a: fuckin
nemuzes vlozit pole do db timto zpusobem, bud v cyklu nebo zapisem napr.
mysql_query("INSERT INTO clanky_articles ($keys[1],$keys[2],$keys[3]) VALUES ('$fldsarr[1]','$fldsarr[2]','$fldsarr[3]')")a nevim jestli se jedna o preklep nebo mas tak pojmenovanou fci ale ma tam byt DIE() misto CDIE() |
||
|
Časová prodleva: 15 let
|
|||
0