Introduction Tutorial PHP

 









Comments

Post a Comment

Popular posts from this blog

Logical_Operators

  <?php     $age = 20 ;     $age1 = 25 ;     if ( $age >= 18 && $age <= 21 )     {         echo "You are Eligible<br>" ;     }         if ( $age >= 18 || $age <= 21 )     {         echo "You are Eligible<br>" ;     }     //Below condition is True So that "Not Operator(!)" will return False condition     if (!( $age >= 18 ))     {         echo "You are Eligible<br>" ;     }     //Below condition is False So that "Not Operator(!)" will return True condition     if (!( $age <= 18 ))     {         echo "You are Eligible<br>" ;     }     //If both condition is "True" OR "False" at that time xor will return "False" and if one condition is     //"True" and s...
Read more

UNION and UNION ALL in PHP

 In "personal" table, there are 6 columns named id, name, percentage, age, gender, city. In "personal" table, column name "id" is PRIMARY KEY and column name "city" is FOREIGN KEY. In "courses" table, there are 2 columns named course_id and course_name. In "courses" table, column name "course_id" is PRIMARY KEY. In "city" table, there are 2 columns named cid and cityname. In "city" table, column name "cid" is PRIMARY KEY. In "lecturers" table, there are 6 columns named id, name, percentage, age, gender, id_of_personal. In "lecturers" table, column name "id" is PRIMARY KEY and column name "id_of_personal" is FOREIGN KEY. UNION and UNION ALL Syntax : SELECT column1, column2 FROM table1 UNION/UNION ALL SELECT column1, column2 FROM table2; RULES : 1) Each SELECT statement within UNION must have the same number of columns. 2) The columns must also have ...
Read more

Read both tables records by INNER JOIN in php

Image
  <?php $servername = "localhost" ; $username = "root" ; $password = "" ; $database = "studenttwo" ; // Create Connection $conn = new mysqli ( $servername , $username , $password , $database ); // Check Connection if ( $conn -> connect_error ) {     die ( "Connection failed : " . $conn -> connect_error ); } Above File is mysqli_conn.php File. Below File is read.php File. <! DOCTYPE html > < html lang = "en" > < head >     < meta charset = "UTF-8" >     < meta name = "viewport" content = "width=device-width, initial-scale=1.0, shrink-to-fit=no" >     < meta http-equiv = "X-UA-Compatible" content = "ie=edge" >     < title > PHP Table </ title > </ head > < body >     < table border = "1px solid black" cellpadding = "5px" cellspacing = "2px" >         < tr...
Read more