Input string was not in a correct format

The error means that the string you’re trying to parse an integer from doesn’t actually contain a valid integer. It’s extremely unlikely that the text boxes will contain a valid integer immediately when the form is created – which is where you’re getting the integer values. It would make much more sense to update a and b in the … Read more

MySQL query String contains

Quite simple actually: The % is a wildcard for any characters set (none, one or many). Do note that this can get slow on very large datasets so if your database grows you’ll need to use fulltext indices.

Error: ” ‘dict’ object has no attribute ‘iteritems’ “

As you are in python3 , use dict.items() instead of dict.iteritems() iteritems() was removed in python3, so you can’t use this method anymore. Take a look at Python 3.0 Wiki Built-in Changes section, where it is stated: Removed dict.iteritems(), dict.iterkeys(), and dict.itervalues(). Instead: use dict.items(), dict.keys(), and dict.values() respectively.

How to read an external local JSON file in JavaScript?

You cannot make a AJAX call to a local resource as the request is made using HTTP. A workaround is to run a local webserver, serve up the file and make the AJAX call to localhost. In terms of helping you write code to read JSON, you should read the documentation for jQuery.getJSON(): http://api.jquery.com/jQuery.getJSON/