PHP&MYSQL-Contents

V E S R N TECHNOLOGIES

Contents

Introduction
Softwares
Syntax & First Program
Variables & DataTypes
Operators


Dear Student! we are Vesrn Technologies giving a great opportunity to you and all, to learn PHP & MYSQL course. Our motto is "Making Programmers". 

Present we are giving two courses namely

1. C Language (in Telugu)

2. PHP & MYSQL

So, in this blog you can find both courses, and your can learn very easily.

If you like this, share to all. 


Introduction to WebProgramming


Client-side scripting generates code that may be executed on the client end without needing server-side processing. These scripts are typically embedded into HTML text.

Examples are HTML, CSS, and JavaScript.

Server-side scripting is a programming technique for creating code that may run software on the server side. In other words, server-side scripting is any scripting method that may operate on a web server.

Examples are PHP, ColdFusion, Python, ASP.net, Java, C++, Ruby, C#, etc.


What is PHP?

PHP stands for Hypertext Pre-processor, that earlier stood for Personal Home Pages. PHP is a server side scripting language. that is used to develop Static websites or Dynamic websites or Web applications.

PHP scripts can only be interpreted on a server that has PHP installed. The client computers accessing the PHP scripts require a web browser only. means that, The client applications do not need to have PHP installed.

The server-side scripting and client-side scripting collaborate with one another. However, these two scripting techniques are different, where the client-side scripting focuses on developing the web application or website's interface to be more appealing and functional. On the other hand, server-side scripting mainly focuses on data access techniques, quick processing, error handling, etc.


<------------ V e s r n ------------->

 PHP - Softwares

1) What is XAMPP?

XAMPP is an open-source, cross-platform web server that consists of a web server, MySQL database engine, and PHP and Perl programming packages. It is compiled and maintained by Apache. It allows users to create WordPress websites online using a local web server on their computer. It supports Windows, Linux, and Mac.

It is compiled and maintained by apache. The acronym XAMPP stands for;

  • X – [cross platform operating systems] meaning it can run on any OS Mac OX , Windows , Linux etc.
  • A –Apache– this is the web server software.
  • M – MySQL – Database.
  • P – PHP
  • P – Perl – scripting language

you can download here
https://www.apachefriends.org/index.html

2) Editors

Netbeans, Notepad++, Sublime Text Editor, etc

Watch Video here :
https://youtu.be/cZVBAsnJf3k

-----------------------------------------------------V e s r n-----------------------------------------------------------


 Basic PHP Syntax


A PHP script is executed on the server only, and the plain HTML result is sent back to the browser.

A PHP script can be placed anywhere in the document.

However, A PHP script starts with <?php and ends with ?>:


A PHP file normally contains HTML tags, and some PHP scripting code.



Example


<html>

<body>


<h1>My first PHP page</h1>


<?php

echo "Hello World!";

?>


</body>

</html>

Video

 PHP Variables

PHP Variables are "containers" for storing information.

A variable can have a short name (like m and n) or a more descriptive name (age, carname, total_volume).


Rules for PHP variables:

  • A variable starts with the $ sign, followed by the name of the variable
  • A variable name must start with a letter or the underscore character
  • A variable name cannot start with a number
  • A variable name can only contain alpha-numeric characters and underscores (A-z, 0-9, and _ )
  • Variable names are case-sensitive ($id and $ID are two different variables)
Eg: $student_name
$s1
$s2

PHP Data Types

    Variables can store data of different types, and different data types can do different things.

PHP supports the following data types:

  • String
  • Integer
  • Float (floating point numbers - also called double)
  • Boolean
  • Array
  • Object
  • NULL
  • Resource
Ex1 :
<?php
$str = "Vesrn";
echo $str;
?>

Ex2
<?php
$str1 = "Vesrn";
$str2 = "Technologies";
echo $str1.$str2;
?>

Ex3:
<?php
$x = 10;
$y = 20;
echo $x+$y;
?>


Ex4:
<?php
$rank = 1;
echo "Vesrn Technologies is always in $rank";

?>


Video

Operators

The Operator exhibits an operation

$z = $x + $y

here =, + are operators

PHP divides the operators like

  • Arithmetic operators
  • Assignment operators
  • Comparison operators
  • Increment/Decrement operators
  • Logical operators
  • String operators
  • Array operators
  • Conditional assignment operators


PHP Arithmetic Operators


OperatorNameExampleResult
+Addition$x + $ySum of $x and $y
-Subtraction$x - $yDifference of $x and $y
*Multiplication$x * $yProduct of $x and $y
/Division$x / $yQuotient of $x and $y
%Modulus$x % $yRemainder of $x divided by $y
**Exponentiation$x ** $yResult of raising $x to the $y'th power

Ex: +

<!DOCTYPE html>
<html>
<body>
<?php
$x = 10;  
$y = 6;
echo $x + $y;
?>  
</body>
</html>

Ex: -

<!DOCTYPE html>
<html>
<body>
<?php
$x = 10;  
$y = 6;
echo $x - $y;
?>  
</body>
</html>

Ex: *

<!DOCTYPE html>
<html>
<body>
<?php
$x = 10;  
$y = 6;
echo $x * $y;
?>  
</body>
</html>

Ex: /

<!DOCTYPE html>
<html>
<body>
<?php
$x = 10;  
$y = 6;
echo $x / $y;
?>  
</body>
</html>

Ex: %

<!DOCTYPE html>
<html>
<body>
<?php
$x = 10;  
$y = 6;
echo $x % $y;
?>  
</body>
</html>

Ex: **

<!DOCTYPE html>
<html>
<body>
<?php
$x = 10;  
$y = 3;
echo $x ** $y;
?>  
</body>
</html>



For Video Lesson Click here Video

Asssignment Operators

 

AssignmentSame as...Description
x = yx = yThe left operand gets set to the value of the expression on the right
x += yx = x + yAddition
x -= yx = x - ySubtraction
x *= yx = x * yMultiplication
x /= yx = x / yDivision
x %= yx = x % yModulus                    
Ex: =
<!DOCTYPE html>
<html>
<body>

<?php
$x = 100;  
echo $x;
?>  

</body>
</html>

Ex: +=
<!DOCTYPE html>
<html>
<body>

<?php
$x = 10;  
$y = 20;

 $x+=$y;
echo $x;

?>  

</body>
</html>

Video

Comparision Operators

PHP Comparison Operators

The PHP comparison operators are used to compare two values (number or string):

OperatorNameExampleResult
==Equal$x == $yReturns true if $x is equal to $y
===Identical$x === $yReturns true if $x is equal to $y, and they are of the same type
!=Not equal$x != $yReturns true if $x is not equal to $y
<>Not equal$x <> $yReturns true if $x is not equal to $y
!==Not identical$x !== $yReturns true if $x is not equal to $y, or they are not of the same type
>Greater than$x > $yReturns true if $x is greater than $y
<Less than$x < $yReturns true if $x is less than $y
>=Greater than or equal to$x >= $yReturns true if $x is greater than or equal to $y
<=Less than or equal to$x <= $yReturns true if $x is less than or equal to $y

Example ( ==)

<!DOCTYPE html>
<html>
<body>

<?php
$x = 10;  
$y = "10";

var_dump($x == $y); // returns true because values are equal
?>  

</body>
</html>

Output: 
bool(true)
because values are same, even datatypes are different.

Example (===)
<!DOCTYPE html>
<html>
<body>

<?php
$x = 10;  
$y = "10";

var_dump($x === $y); // returns false because types are not equal
?>  

</body>
</html>

Output: 
bool(false)
because values same but   datatypes are different.

Example (!=)

 <!DOCTYPE html>

<html>

<body>

<?php

$x = 100;  

$y = "100";

var_dump($x != $y); // returns false because values are equal

?>  

</body>

</html>

Output: 
bool(false)

Example (<>)

 <!DOCTYPE html>

<html>

<body>

<?php

$x = 100;  

$y = "100";

var_dump($x != $y); // returns false because values are equal

?>  

</body>

</html>

Output: 
bool(false)

Example(!==)

<!DOCTYPE html>
<html>
<body>

<?php
$x = 100;  
$y = "100";

var_dump($x !== $y); // returns true because types are not equal
?>  

</body>
</html>
Output:
bool(true)


Example (>)
<!DOCTYPE html>
<html>
<body>

<?php
$x = 100;
$y = 50;

var_dump($x > $y); // returns true because $x is greater than $y
?>  

</body>
</html>
Output:
bool(true)

Example (>=)
<!DOCTYPE html>
<html>
<body>

<?php
$x = 100;
$y = 50;

var_dump($x > =$y); // returns true because $x is greater than $y
?>  

</body>
</html>
Output:
bool(true)

Example (<)
<!DOCTYPE html>
<html>
<body>

<?php
$x = 100;
$y = 50;

var_dump($x < $y); // returns true because $x is greater than $y
?>  

</body>
</html>
Output:
bool(false)

Example (<=)
<!DOCTYPE html>
<html>
<body>

<?php
$x = 100;
$y = 50;

var_dump($x > $y); // returns true because $x is greater than $y
?>  

</body>
</html>
Output:
bool(false)


 

PHP Increment / Decrement Operators

The PHP increment operators are used to increment a variable's value by adding one.

The PHP decrement operators are used to decrement a variable's value by subtracting one.


OperatorNameDescription
++$xPre-incrementIncrements $x by one, then returns $x
$x++Post-incrementReturns $x, then increments $x by one
--$xPre-decrementDecrements $x by one, then returns $x
$x--Post-decrementReturns $x, then decrements $x by one                        
Example: 
Prefix Increment Operator 
<!DOCTYPE html>
<html>
<body>

<?php
$x = 10;  
echo ++$x;
?>  

</body>
</html>

Output:
11

Example: 
Postfix Increment Operator 
<!DOCTYPE html>
<html>
<body>

<?php
$x = 10;  
echo $x++;
?>  

</body>
</html>
Output:
10

Similarly prefix --, postfix -- operators works


 PHP MYSQL - Operators - 5.5 Logical Operators

PHP Logical Operators

The PHP logical operators are used to combine conditional statements.

OperatorNameExampleResult
andAnd$x and $yTrue if both $x and $y are true
orOr$x or $yTrue if either $x or $y is true
xorXor$x xor $yTrue if either $x or $y is true, but not both
&&And$x && $yTrue if both $x and $y are true
||Or$x || $yTrue if either $x or $y is true
!Not!$xTrue if $x is not true
Example 'and'

<!DOCTYPE html>
<html>
<body>

<?php
$x = 10;  
$y = 20;

if ($x == 100 and $y == 50) {
    echo "Vesrn Technologies!";
}
?>  

</body>
</html>
Output:
Vesrn Technologies

Logical operators are widely used when it necessary, dear student you can try remaining operators with your own.





 

PHP String Operators

PHP has two operators that are specially designed for strings.

OperatorNameExampleResult
.Concatenation$txt1 . $txt2Concatenation of $txt1 and $txt2
.=Concatenation assignment$txt1 .= $txt2Appends $txt2 to $txt1

<!DOCTYPE html>
<html>
<body>

<?php
$txt1 = "Vesrn";
$txt2 = "Technologies";
echo $txt1 . $txt2;
?>  

</body>
</html>

Output:
VesrnTechnologies

2)<!DOCTYPE html>
<html>
<body>

<?php
$txt1 = "Vesrn;
$txt2 = "Technologies!";
$txt1 .= $txt2;
echo $txt1;
?>  

</body>
</html>

Output:
VesrnTechnologies

 

PHP Array Operators

The PHP array operators are used to compare arrays.

OperatorNameExampleResult
+Union$x + $yUnion of $x and $y
==Equality$x == $yReturns true if $x and $y have the same key/value pairs
===Identity$x === $yReturns true if $x and $y have the same key/value pairs in the same order and of the same types
!=Inequality$x != $yReturns true if $x is not equal to $y
<>Inequality$x <> $yReturns true if $x is not equal to $y
!==Non-identity$x !== $yReturns true if $x is not identical to $y
<!DOCTYPE html>
<html>
<body>

<?php
$x = array("a" => "red", "b" => "green");  
$y = array("c" => "blue", "d" => "yellow");  

print_r($x + $y); // union of $x and $y
?>  

</body>
</html>

Output:
Array ( [a] => red [b] => green [c] => blue [d] => yellow )

Ex:2
<!DOCTYPE html>
<html>
<body>

<?php
$x = array("a" => "red", "b" => "green");  
$y = array("c" => "blue", "d" => "yellow");  

var_dump($x == $y);
?>  

</body>
</html>

Output:
bool(false)

Dear student try remain operators .

 

PHP Conditional Assignment Operators

The PHP conditional assignment operators are used to set a value depending on conditions:

OperatorNameExampleResult
?:Ternary$x = expr1 ? expr2 : expr3Returns the value of $x.
The value of $x is expr2 if expr1 = TRUE.
The value of $x is expr3 if expr1 = FALSE
??Null coalescing$x = expr1 ?? expr2Returns the value of $x.
The value of $x is expr1 if expr1 exists, and is not NULL.
If expr1 does not exist, or is NULL, the value of $x is expr2.
Introduced in PHP 7
<!DOCTYPE html>
<html>
<body>

<?php
   // if empty($user) = TRUE, set $status = "anonymous"
   echo $status = (empty($user)) ? "anonymous" : "logged in";
   echo("<br>");

   $user = "John Doe";
   // if empty($user) = FALSE, set $status = "logged in"
   echo $status = (empty($user)) ? "anonymous" : "logged in";
?>  

</body>
</html>

Output:

anonymous
logged in

<!DOCTYPE html>
<html>
<body>

<?php
   // variable $user is the value of $_GET['user']
   // and 'anonymous' if it does not exist
   echo $user = $_GET["user"] ?? "anonymous";
   echo("<br>");
  
   // variable $color is "red" if $color does not exist or is null
   echo $color = $color ?? "red";
?>  

</body>
</html>

Output:
anonymous
red

Popular posts from this blog

Install Windows 7 Operating System - Practical

Image
COPA  Install Windows  -7  Operating System I have learned basically these steps to install windows operating system on Personal Computer(PC) The three basic types of clean installation procedures are as follows: Install on a brand new disk or computer system Erase the disk, format it, and install Install into a new directory I am using  first two methods, be sure my computer can boot from a DVD (most newer computers support booting from a DVD drive). Doing so might require changing the drive boot order in the BIOS or CMOS. The Windows 7 DVD is bootable and should run the Setup program automatically. Clean Install from DVD, Step by Step A typical clean installation (on a blank hard disk) step-by-step procedure is as follows: 1. Insert the Windows 7 DVD into your computer’s DVD-ROM drive, and restart the computer. Windows 7 Setup should start automatically. If Setup does not start automatically, ensure that your computer is configured to boot from the DVD drive. 2. In...
Read more

COPA Bits for Computer Based Test (CBT) by Venugopal Vanjarapu

  Computer Operator and Programming Assistant 1st Semester - Module 1 & 2: Safe Working Practice & Introduction to Computer Components 1 Which is the sequence, in which computer operates?  A Input, output, process  B Input, process, output  C Process, input, output  D Output, process, input  2 Which is the first general purpose programmable electronic computer?  A ENIAC B EDVAC  C EDSAC  D UNIVAC  3 What type of device is computer?   A Electrical device  B Electronic device  C Electro magnetic  D Electro mechanical  4 Who is considered as father of computer?  A Charles Babbage  B John Lickert  C John Mauchy  D M.V Wilkes  5 Who invented Analytical engine?  A Charles Babbage  B John Lickert  C John Mauchy  D M.V Wilkes  6 What is the main electronic component of the first generation computer?  A Integrated circuit  B Microprocess  C Transisto...
Read more

COPA

COPA Computer Operator and Programming Assistant (COPA) Exp No Trade Practical Trade Theory CBT Exam Study Material Video Lesson 1 1 1 Study Material Video Lesson 2 2 2 3 3 3 4 Installing Window Operating System Operating System 5 MS-DOS Commands Operating System 6 Linux Commands Operating System 7 Create new document, open existing document, edit document and save the documents Ms Word 8 Formatting text, inserting objects, tables, hyperlinks, autocorrect features, thesaurus, spelling and grammar Ms Word 9 ...
Read more