Author: admin

how to define a function in python

As per the latest trends set python is the most exploring programming language,expert says in the middle of 21st century 70% of the day life application will be depend on python programming language, python and artificial intelligence definitely will brings miracle in the middle of 21st century.So being a programmer without python programming language you cant survive in 21st century.Like other programming language function in python is also so important.so basically our question is how to define a function in python.To define a function in python programming language, python has its on syntax. lets see the syntax

def FUNCTION-NAME( PARAMETER):
    FUNCTION_BLOCK
   return [EXPRESSION]

def            => Function blocks begin with this keyword def 
FUNCTION-NAME  => Name of the function you can define your own name

PARAMETER      => It the Parameter passing to the function when function was called

FUNCTION_BLOCK => Function code block

EXPRESSION     =>  return [EXPRESSION] passing back an expression to the caller

See example

def sum(a,b):
 resultvalue = a+b
 return resultvalue

x =10
y = 40
print(sum(x,y));
x =60
y = 40
print(sum(x,y));

how to define a function in python

def printPrime(lower,upper):
 print( "prime numbers between "+str(lower)+ ", "+str(upper))
 for num in range(lower,upper + 1):
    if num > 1:
       for i in range(2,num):
           if (num % i) == 0:
               break
       else:
           print(num)

x =10
y = 20
printPrime(x,y);
x =1180
y = 1200
printPrime(x,y);

how to define a prime number display function in python

update query in mysql with example

MySQL is an open-source relational database management system,actually the name MySQL come from the combinations of words “My“(name of co-founder Michael Widenius’s daughter) and “SQL“(Structured Query Language).Since MySQL is free and open-source it is the most popular and huge used RDBMS. In this section we are going to check out how to write a update query in MySQL.Let me explain the syntax for update query in mysql with example

Syntax

"UPDATE `TABLE_NAME` SET `COLUMN_NAME` = `VALUE' WHERE  [condition];

Example

"UPDATE student  SET mobile ='9999999999' WHERE id='9'";

update query in mysql

php mysql query where description like any of the word in the given string?

Almost all website having a search field on the top it will search in the entire database and display related data in the user interface.so when user type a group of word almost all case user will not get accurate report,because the MySQL query using the LIKE “%$query%/”,so in this tutorial we are planning to elaborate how to search word by word in the database for given string.


#search Form

<form action="search.php" method="post">
<input type="text" name="q" value="">

</form>


#search.php
$q=$_POST['q'];

$searchQ=explode(' ',$q );
$searchquery="";
foreach($searchQ as $key=>$value)
{
if($searchquery!='')
{
$searchquery.="description LIKE %".$value."%"
}
else
{
$searchquery.=" OR description LIKE %".$value."%"
}
}
$query="SELECT * FROM leads WHERE ".$searchquery;
you can use this query to fetch the data

python print function syntax

Most of the beginners in python always confuse with print function and start searching for print function in google.Like other programming language python print out put function also easy. In this tutorial we are going to explore python print ,the way to print the out put in python. print() is the function used in python to print out put.

Let see example

python print syntax

print(object(s), separator=separator, end=end, file=file, flush=flush)

object = any object, it will convert in to string and print

sep=’separator’ = Optional default ‘ ‘

end=’end’ = Default is line feed, will tell what print at the end

file = Default is sys.stdout , object with a write method.

1) python print a string “Hello World”



print("Hello World")
Output:

Hello World

2) python print a variable numberstart =10

 
numberstart =10
print(numberstart)
Output:

10

3) python print : managing tuble


tupleA = (2, 4, 8, 12) 
tupleB = ('red', 'blue')  
print(tupleA + tupleB ) 

Output:

(2, 4, 8, 12, 'red', 'blue')

python print function