Sponsored Content
The Lounge What is on Your Mind? Debugging Our Computer Science Trivia Feature Post 303040617 by Neo on Saturday 2nd of November 2019 02:34:46 AM
Old 11-02-2019
Ran this against the DB and manually edited any of these "non JSON friendly" chars:

Code:
SELECT * FROM neo_open_trivia WHERE question REGEXP '[^a-zA-Z0-9@:. \'\-`,\&#%$\\\"\!\|]';

I think the bug is in my submission script and I need to add better filters. Just using the PHP encode HTML entities function does not work perfectly.

SO, the DB should be clean now and the errors in display effect T/F etc, I think, solved.
 

7 More Discussions You Might Find Interesting

1. What is on Your Mind?

Computer Science and Information Technology

Hi, I haven't posted on the forums for a while now, I tried to find the most appropriate section for this post, but if this is in the wrong section please forgive me. First, let me say I'm a sophomore in HS. I know that job wise I definitely want to do something in computers. A while ago I was... (5 Replies)
Discussion started by: hpicracing
5 Replies

2. Programming

Is Web Development is a part of computer science ?

I am now a student in university in 2nd year. I am studying computer science. But I am not sure what type of jobs computer science provide. I know some of them are software programming or network management. Recently, I hear some about Web Development. I wonder if it is a part of computer science.... (1 Reply)
Discussion started by: Anna Hussie
1 Replies

3. Web Development

Is Web Development is a part of computer science ?

I am now a student in university in 2nd year. I am studying computer science. But I am not sure what type of jobs computer science provide. I know some of them are software programming or network management. Recently, I hear some about Web Development. I wonder if it is a part of computer... (3 Replies)
Discussion started by: Anna Hussie
3 Replies

4. What is on Your Mind?

Forum Trivial Pursuit - New Computer Science and Mathematics Trivia for UNIX.com

I have added a new experimental "Computer Science and Mathematics Trivia - True or False" section in the discussions, currently under the tags box. In the future, I plan to Expand this feature to add more trivia categories from math, science and technology. Keep track of correct and... (20 Replies)
Discussion started by: Neo
20 Replies

5. What is on Your Mind?

1000+ Computer Science Trivia Questions at UNIX.COM

The UNIX and Linux Forums now has over 1000 TRUE / FALSE computer science and computer related trivia question in our database. These questions are of relatively high quality (compared to similar sites on the web) and are fun (according to feedback by users). In the first week during the... (1 Reply)
Discussion started by: Neo
1 Replies

6. What is on Your Mind?

New Member and Country Computer Trivia Leaderboards

Thanks to Akshay, who helped me write the core MySQL queries, we now have two new draft leaderboards, by (1) member and by (2) country: https://www.unix.com/trivia_stats.php Currently milhan leads the members with a high score of 90%: ... (3 Replies)
Discussion started by: Neo
3 Replies

7. What is on Your Mind?

Computer Trivia Feature Tops 50,000 Questions Answered

Just noticed that our successful computer trivia feature (stats here) has surpassed over 50,000 questions answered by users: https://www.unix.com/trivia_stats.php This was a coding effort worth while and I'm pleased to see so many people enjoying it in such a short time since it was released... (3 Replies)
Discussion started by: Neo
3 Replies
Jifty::JSON(3pm)					User Contributed Perl Documentation					  Jifty::JSON(3pm)

NAME
Jifty::JSON -- Wrapper around JSON SYNOPSIS
use Jifty::JSON qw/decode_json encode_json/; my $obj = decode_json(q! { "x": "1", "y": "2", "z": "3" } !); my $json = encode_json($obj); DESCRIPTION
Provides a thin wrapper around the JSON 2.xx library, which provides a frontend for JSON::XS and JSON::PP. This module used to wrap JSON::Syck and JSON 1.xx with special-casing for outputting JSON with single quoted values. Single quotes make it easy to simply plop JSON into HTML attributes but are in violation of the JSON spec which mandates only double quoted strings. The old behavior is now unsupported and it is recommended that you simply HTML escape your entire blob of JSON if you are sticking it in an HTML attribute. You can use Jifty->web->escape() to properly escape problematic characters for HTML. FUNCTIONS
decode_json JSON, [ARGUMENT HASHREF] encode_json JSON, [ARGUMENT HASHREF] These functions are just like JSON's, except that you can pass options to them like you can with JSON's "from_json" and "to_json" functions. By default they encode/decode using UTF8 (like JSON's functions of the same name), but you can turn that off by passing "utf8 => 0" in the options. The allow_nonref flag is also enabled for backwards compatibility with earlier versions of this module. It allows encoding/decoding of values that are not references. JSON is imported with the "-support_by_pp" flag in order to support all options that JSON::PP provides when using JSON::XS as the backend. If you are concerned with speed, be careful what options you specify as it may cause the pure Perl backend to be used. Read "JSON::PP SUPPORT METHODS" in JSON for more information. DEPRECATED FUNCTIONS
jsonToObj JSON, [ARGUMENTS] objToJson JSON, [ARGUMENTS] These functions are deprecated and provided for backwards compatibility. They wrap the appropriate function above, but "croak" in Carp if you try to set the "singlequote" option. LICENSE
Jifty is Copyright 2005-2010 Best Practical Solutions, LLC. Jifty is distributed under the same terms as Perl itself. perl v5.14.2 2010-12-08 Jifty::JSON(3pm)
All times are GMT -4. The time now is 11:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy