close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

ASCII characters in mysql tables, not view correctly in the browser.

Thread began 8/30/2018 9:04 am by Mike | Last modified 9/13/2018 11:15 pm by Ray Borduin | 42 views | 7 replies |

Mike

ASCII characters in mysql tables, not view correctly in the browser.

I'm upgrading an old website with the new DataBridge v2.
Now I've a problem with ASCII characters in the records of the database's table.
For example, the code « view in the browser with « instead of "«".
In the db connection file I've insert this code but without success:
$connTest->set_charset('utf8');

Is there any solution?

Sign in to reply to this post

Ray BorduinWebAssist

I just updated the extension to fix this issue in the latest rsobj.php file. If you reinstall the extension and re-apply the recordset object, it should replace the file. I've also attached it, so you can replace it manually.

Attached Files
rsobj.php
Sign in to reply to this post

Mike

Hi Ray,
it's perfect. Thanks.

A last question, now if I regenerate the connection file, I've these two new instructions:
$connTest = mysqli_init();
$connTest->options(MYSQLI_OPT_INT_AND_FLOAT_NATIVE, TRUE);

Do you confirm me that is necessary to regenerate the connection file?
Thanks.

Sign in to reply to this post

Ray BorduinWebAssist

It is not necessary. The connection was updated to use that syntax to preserve the native data types for returned data. So that integers stay integers instead of returning as strings. In 99% of cases wouldn't matter, but a user found it wasn't integrating with a charting plugin properly because of the data type so I made the change.

Sign in to reply to this post

Mike

Ok, thanks Ray!

Sign in to reply to this post

Mike

Hi Ray,
I've a new problem with the characters in the records of the database's table (see screenshots in the private area).
I've a field in a mysql's table (type "text") with html content (e.g. "p" tags) but when I open the page in the browser I see the html structure with the tags.

For example, if I have in the field:
<p>Lorem ipsum...</p>

The browser view...
<p>Lorem ipsum...</p>

and not:
Lorem ipsum...

How can I fix it?
Thanks.

Sign in to reply to this post

Ray BorduinWebAssist

Yes. We have built in Cross Site Scripting (XSS) security in the new MySQLi code. It will automatically encode html entered to prevent malicious attempts by hackers to inject code or script onto your page. In order to disable the protection you can manually update your column reference from:

php:
<?php echo $rsNewsProducts->getColumnVal('desc_ita_news'); ?>


to:

php:
<?php echo $rsNewsProducts->getColumnVal('desc_ita_news',false); ?>
Sign in to reply to this post

Mike

Perfect, thanks!

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...