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
Post a Comment