Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by Mohd Mohtashim
Page 2 of 19
Database INSERT Operation in Python
It is required when you want to create your records into a database table.ExampleThe following example, executes SQL INSERT statement to create a record into EMPLOYEE table −#!/usr/bin/python import MySQLdb # Open database connection db = MySQLdb.connect("localhost", "testuser", "test123", "TESTDB" ) # prepare a cursor object using cursor() method cursor = db.cursor() # Prepare SQL query to INSERT a record into the database. sql = """INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) VALUES ('Mac', 'Mohan', 20, 'M', 2000)""" try: # Execute the SQL command cursor.execute(sql) # Commit your changes in the database db.commit() except: # ...
Read MoreHow To Raise a "File Download" Dialog Box in Python?
Sometimes, it is desired that you want to give option where a user can click a link and it will pop up a "File Download" dialogue box to the user instead of displaying actual content. This is very easy and can be achieved through HTTP header. This HTTP header is be different from the header mentioned in previous section.For example, if you want make a FileName file downloadable from a given link, then its syntax is as follows −#!/usr/bin/python # HTTP Header print "Content-Type:application/octet-stream; name = \"FileName\"\r"; print "Content-Disposition: attachment; filename = \"FileName\"\r"; # Actual File Content will go here. ...
Read MorePassing Checkbox Data to CGI Program in Python
Checkboxes are used when more than one option is required to be selected.ExampleHere is example HTML code for a form with two checkboxes − Maths Physics OutputThe result of this code is the following form −Below is checkbox.cgi script to handle input given by web browser for checkbox button.#!/usr/bin/python # Import modules for CGI handling import cgi, cgitb # Create instance of FieldStorage form = cgi.FieldStorage() # Get data from fields if form.getvalue('maths'): math_flag = "ON" else: math_flag = "OFF" if form.getvalue('physics'): physics_flag = "ON" else: physics_flag = "OFF" print "Content-type:text/html\r\r" print "" ...
Read MorePassing Information Using POST Method in Python
A generally more reliable method of passing information to a CGI program is the POST method. This packages the information in exactly the same way as GET methods, but instead of sending it as a text string after a ? in the URL it sends it as a separate message. This message comes into the CGI script in the form of the standard input.ExampleBelow is same hello_get.py script which handles GET as well as POST method.#!/usr/bin/python Import modules for CGI handling import cgi, cgitb # Create instance of FieldStorage form = cgi.FieldStorage() # Get data from fields first_name = form.getvalue('first_name') ...
Read MorePassing Information using GET method in Python
The GET method sends the encoded user information appended to the page request. The page and the encoded information are separated by the ? character as follows −http://www.test.com/cgi-bin/hello.py?key1=value1&key2=value2The GET method is the default method to pass information from browser to web server and it produces a long string that appears in your browser's Location:box. Never use GET method if you have password or other sensitive information to pass to the server.The GET method has size limitation: only 1024 characters can be sent in a request string. The GET method sends information using QUERY_STRING header and will be accessible in your ...
Read MoreRegular Expression Examples in Python
Literal charactersSr.No.Example & Description1pythonMatches beginning of line.Character classesSr.No.Example & Description1[Pp]ythonMatch "Python" or "python"2rub[ye]Match "ruby" or "rube"3[aeiou]Match any one lowercase vowel4[0-9]Match any digit; same as [0123456789]5[a-z]Match any lowercase ASCII letter6[A-Z]Match any uppercase ASCII letter7[a-zA-Z0-9]Match any of the above8[^aeiou]Match anything other than a lowercase vowel9[^0-9]Match anything other than a digitSpecial Character ClassesSr.No.Example & Description1.Match any character except newline2\dMatch a digit: [0-9]3\DMatch a nondigit: [^0-9]4\sMatch a whitespace character: [ \t\r\f]5\SMatch nonwhitespace: [^ \t\r\f]6\wMatch a single word character: [A-Za-z0-9_]7\WMatch a nonword character: [^A-Za-z0-9_]Repetition CasesSr.No.Example & Description1ruby?Match "rub" or "ruby": the y is optional2ruby*Match "rub" plus 0 or more ys3ruby+Match "rub" plus 1 or more ...
Read MoreCGI Environment Variables in Python
All the CGI programs have access to the following environment variables. These variables play an important role while writing any CGI program.Sr.No.Variable Name & Description1CONTENT_TYPEThe data type of the content. Used when the client is sending attached content to the server. For example, file upload.2CONTENT_LENGTHThe length of the query information. It is available only for POST requests.3HTTP_COOKIEReturns the set cookies in the form of key & value pair.4HTTP_USER_AGENTThe User-Agent request-header field contains information about the user agent originating the request. It is name of the web browser.5PATH_INFOThe path for the CGI script.6QUERY_STRINGThe URL-encoded information that is sent with GET method ...
Read MoreSpecial Syntax with Parentheses in Python
Sr.No.Example & Description1R(?#comment)Matches "R". All the rest is a comment2R(?i)ubyCase-insensitive while matching "uby"3R(?i:uby)Same as above4rub(?:y|le))Group only without creating \1 backreference
Read MoreRegular Expression Patterns in Python
Except for control characters, (+ ? . * ^ $ ( ) [ ] { } | \), all characters match themselves. You can escape a control character by preceding it with a backslash.Following table lists the regular expression syntax that is available in Python −Sr.No.Pattern & Description1^Matches beginning of line.2$Matches end of line.3.Matches any single character except newline. Using m option allows it to match newline as well.4[...]Matches any single character in brackets.5[^...]Matches any single character not in brackets6re*Matches 0 or more occurrences of preceding expression.7re+Matches 1 or more occurrence of preceding expression.8re?Matches 0 or 1 occurrence of preceding ...
Read MoreRegular Expression Modifiers in Python
Regular expression literals may include an optional modifier to control various aspects of matching. The modifiers are specified as an optional flag. You can provide multiple modifiers using exclusive OR (|), as shown previously and may be represented by one of these −Sr.No.Modifier & Description1re.IPerforms case-insensitive matching.2re.LInterprets words according to the current locale. This interpretation affects the alphabetic group (\w and \W), as well as word boundary behavior(\b and \B).3re.MMakes $ match the end of a line (not just the end of the string) and makes ^ match the start of any line (not just the start of the string).4re.SMakes ...
Read More