HTML markup showing on webpage

I've manually added some code to DB records... for example:

<p>Stock item.</p> <p>Choice of wood finishes.</p> <p>Various types available ranging from basic tables to tables with storage drawers.</p>

So, nothing out of the ordinary, but it is printing on the page as shown above.

I've called the text in via a MySQLi recordset and placed on the page as a normal databinding, and within the bindings panel I have tried to convert new lines to BRs and have tried encode HTML entities. In the previous DA it used to print as expected and the HTML mark up styles content how it's meant to, but not so with this version.

Why's this happening? Has something changed between MySQL and MySQLi that has caused this?

Thanks.

Which version of rsobj.php file do you have? You may have CrossSiteProtect set to true. I have version 2.2 and have this set to false so this doesn't happen. If you need version 2.2 let me know and will post here

Hi Jamie, I have 2.21 and 2.6 (which I think came from Ray). Both are showing the issue.

It's an odd one to say the least.

On your rsobj.php file, about line 11, do you have

$this->CrossSiteProtect = true;

If so change it to

$this->CrossSiteProtect = false;

You can remove Cross Site protection in the rsobj.php file, in the recordset code on the page, or in the individual references to each column.

I usually suggest making the change for columns instead of site wide in the rsobj.php file.

Thanks for your responses and sorry for the delay in getting back... 11 months! =D

What does CrossSiteProtect do then if you recommend not to make a site-wide change? I made the change in the rsobj file and it corrected the issue, but if I can avoid doing too much messing with the website, then I will. The client has been less than proactive with the site!

You can disable it specifically for the fields where you need to allow html editing where only the admin has access. It is fine to disable this globally if you don't ever allow database manipulation by end users and the admin side is password protected.

Originally Said By: Ray Borduin

  You can disable it specifically for the fields where you need to allow html editing where only the admin has access. It is fine to disable this globally if you don't ever allow database manipulation by end users and the admin side is password protected.  

Hello,

I recently bought data bridge 2.2 and I had the same problem of displaying html tags for 1 month.
I applied your solution mentioned above, it worked very well, until today.
Since today dreamweaver cc 2019 crached non stop.

I uninstalled data bridge 2.35 and reinstalled it by changing the line again
$ this-> CrossSiteProtect = true;
to
$ this-> CrossSiteProtect = false;
But the problem persists.
the browser cache is empty but nothing helps.

Thank you for your advice.

Philippe
(French user)

It may have something to do with the page you are working on. I'd need to reproduce this to debug it. Can you attach the page causing the issue? If not, then we could do screen sharing. Just post your Skype contact information and I can message you there to coordinate a time when we can share your screen and figure out what is going wrong.

Originally Said By: Ray Borduin

  It may have something to do with the page you are working on. I'd need to reproduce this to debug it. Can you attach the page causing the issue? If not, then we could do screen sharing. Just post your Skype contact information and I can message you there to coordinate a time when we can share your screen and figure out what is going wrong.  

Thank you for your quick return

To be sure that my page is not in issue, I created a new one with just the query and displayed the query result but the problem was still the same.

It's strange because I had to re-validate the dreamweaver cc 2019 testing server parameters ( wamp php 7.3 mysql 5.7.36)

The display problem was solved after re validating the records. i have to re validate all the records !
It's not a problem but really strange.

It makes no sense, If you have any suggestion I'll take it.

After uninstalling date bridge I could no longer connect to my project admin but it works well with firefox and chrome before uninstalling data bridge.

To solved this i restored the Webassist backup folder from this morning to bring the admin panel back.

So I'm going to reinstall data bridge and see what happens.

Data bridge is really a very good product, I can very quickly transcode dreamweaver mysql requests into myqli. it is a considerable time saver. congratulations for this work.

Philippe