TOPIC:

Object (JSON) removed from the view 18 Aug 2013 22:53 #10812

dyoungers
Topic Author
Offline
Premium Member
Posts: 123
Thank you received: 16

First, thanks tp Tomaselli for this tip on how to get the JSON data type to "work"!

One thing I've noted in testing is that I had extra slashes being added for special characters that the user typed into the fields I was storing into the JSON field, e.g. ', ", etc.

Adding the following code to the fork for my item model took care of things:

protected function prepareTable($table)
	{
		$table->customoptions = stripslashes($table->customoptions);
		parent::prepareTable($table);
	}

Without digging into this in any detail, my assumption is that the data is being prepared for an SQL update/insert statement and slashes are added for that before the JSON encode, which then means that more slashes are being added to the data (and removing them here before the jsonencode call fixes things.)

If I'm missing something I'd love to hear from the experts here

Thanks!
Dave

Please Log in or Create an account to join the conversation.

Object (JSON) removed from the view 07 Oct 2013 23:03 #11315

admin Offline Administrator Chef Posts: 3711 Thank you received: 986	This is now working for me I think this was because the JSON was encoded twice time when model loads for pagination count, and then for listing Coding is now a piece of cake
	Please Log in or Create an account to join the conversation. Last edit: by admin.

Page:
1

Forum

Debug

Closed tickets.

[CLOSED] Object (JSON) strip slashes

Time to create page: 0.072 seconds

“

”

Amazing Tool !
And only tool I know that allows complete Scaffolding in terms of component creation. It really saves loads of time (actually much more than that). Simple architecture enables quick and painless changes at any time. Code is clean and consintent. It's just... what's the word... neat! :) Great work! You should definetely try this one!
pi_wo (JED)

TOPIC:

Object (JSON) removed from the view 18 Aug 2013 22:53 #10812

Object (JSON) removed from the view 07 Oct 2013 23:03 #11315

Get Started

Newsletter