Quote Originally Posted by tpf80 View Post
in Qt is there any equivalent function similar to "mysql_escape_string()" in PHP?
what I am trying to accomplish is to allow a user to enter information into a QTextedit and then transfer the data into a blob in mysql. My code so far works perfectly to get the text edit info into the blob except for cases where certain special characters are entered. For instance entering:
into the text edit causes an error as my query interprets this as part of the SQL statement rather than something the user typed that should be put in the blob.
PHP having 5000 or more function. C++ is different...


For any projekt i make a base class to extendend on evry place i need....

I work so many on XML utf-8 and i put on sql as encodeBase64 and must not quote...
php can read on http://php.net/base64-decode.php and the Dom XML friends....
As caching Dom ist faster.... only must transform xslt ...the data pdf, word, openoffice, svg, csv, ecc...


Qt Code: 
  1. /* insert quote */
  2. QString sql_Quote( QString xml )
  3. {
  4.    QString text = xml;
  5.    text.replace("\"","\\\"");  /* 228 ``*/
  6.    text.replace("'","`");
  7.    return text;
  8. }
  9.  
  10. /* select quote */
  11. QString sql_DeQuote( QString xml )
  12. {
  13.   QString text = xml;
  14.    text.replace("\\\"","\"");  /* 228 ``*/
  15.    text.replace("`","\'");
  16.   return text;
  17. }
  18.  
  19.  
  20. /* encode to name */
  21. QString encodeBase64( QString xml )
  22. {
  23.     QByteArray text;
  24.     text.append(xml);
  25.     return text.toBase64();
  26. }
  27.  
  28. /* decode to name */
  29. QString decodeBase64( QString xml )
  30. {
  31.     QByteArray xcode("");;
  32.     xcode.append(xml);
  33.     QByteArray precode(QByteArray::fromBase64(xcode));
  34.     QString notetxt = precode.data();
  35.     return notetxt;
  36. }
To copy to clipboard, switch view to plain text mode 

is your QTextedit data xhtml? image and so.....


IMO: QTextedit xhtml and image or attachment i zip the file to mysql

blob (mysql longblob 2GB max 4MB query setting) data zip file

QByteArray zipstream;
zipstream.toBase64();
and after to replace field.... is so clean and small data...

SAMPLE: my new Home-Page http://www.swisse.net/ work only on 2 xslt file
http://ciz.ch/map/theme/zest/page.xsl
http://ciz.ch/map/theme/zest/master_html.xsl
PHP unzip data as cache folder , like this http://www.swisse.net/data/2007/01/01/50000/ and xslt transform all no sql query... only admin running sql.