php - Fields with accents are not saved in ocomon mysql database -


i downloaded recommended desk application called ocomon , use wamp .

i installed everything. database uses utf8_general_ci , application in portuguese (br) when try put data accents, record saved, columns accentuated text not saved.

anyone knows doing wrong?

example of code error:

    $qry = "update configusercall set ".             "conf_user_opencall= ".$_post['useropencall'].", ".             "conf_ownarea = ".$_post['ownarea'].", ".             "conf_scr_msg = '".nohtml($_post['msg'])."' conf_cod = 1 ";


Comments

Post a Comment

Popular posts from this blog

apache - Cloudflare bug random 302 redirections -

i've issue cloudflare, (randomly) have 302 redirections on random non-existing subfolders, give examples : get /en/home > 302 > /en/home/swetz > 302 > /en/home > 302 > /en/home/qutis > 302 > /en/home > 200 /en/home > 302 > /en/home/zaiue > 302 > /en/home/zaiue/widut > 302 > /en/home > 200 when disable cloudflare, seems work , no sign of strange redirections. i've noticed these redirections happen on resources when header "cf-cache-status" set miss. it's annoying because "err_too_many_redirections" happen totally breaks website : javascript, styles , images not loaded... please open support ticket & can take look. wouldn't add redirect unless set pagerule instructing so, sounds may have configured incorrectly. forwarding & cache status different things & shouldn't have play here.
Read more

java - Sql binding in Spring throws org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException -

Image
im making spring mvc web application. database access i'm using sql binding. running yesterday encountered unabletoexecutestatementexception when tried edit user data web app. this code i've errors per stacktrace. public string edituser (userdto objuserdto) { handle objhandle = objbaseservice.gethandle(); objhandle.createstatement("update user set email = :email," + "usertypeid = :usertypeid," + "username = :username," + "trackinginterval = :trackinginterval," + "enablewebcam = :enablewebcam," + "showcaptureinfo = :showcaptureinfo," + "showseverinfo = :showserverinfo," + "autologin = :autologin," + "remarks ...
Read more