php - Query doesn't insert medium/large text -


i have pretty awkward problem query won't insert medium/large texts. when try example insert/update database records tester works, when try insert/update 4 lines of text, doesn't (won't give me error either). strange part process 2 'lorem ipsum' paragraphs.

my query looks (for insert):

 $ncp_id = $defaults->query("insert ".$table[0]." (p_id, p_title, p_date, p_desc) values ('','".$_post['p_title']."','".$_post['p_date']."','".$_post['p_desc']."')"); $defaults->query("insert ".$table[2]." (ncp_id, ncp_client_id, ncp_project_id) values ('','".$_post['c_name']."','".$ncp_id."')");

my database field text type.

all post data legit. when print these, see texts should inserted

i don't have more information, or code. i'm hoping heard of simular problem before.

i suppose real mediumtext contains special characters breaks query.

that's why have use prepared statements

instead of interpolating data right in query string.

also, know nothing of query() implementation , if can return scalar value this.

also, have configure dbal , php translate database errors php errors , make latter available you. that's important part. without error message can guess ages, while know problem on sight.


Comments

Popular posts from this blog

blackberry 10 - how to add multiple markers on the google map just by url? -

php - guestbook returning database data to flash -

delphi - Dynamic file type icon -