Please enable JavaScript.

Coggle requires JavaScript to display documents.

PHP and MySQL (Basic Commands (MySQL commands (Sessions and Cookies ($…

- - - - To Display Output on the screen
        
        echo "string";
        
        echo "<p>html tags can also be echoed</p>"
        
        echo "My name is ".$name;
        
        print_r
      - Variables
        
        Types of variables:
        Strings
        integers
        floating points
        booleans
        
        Note: no need to declare what type of variable it is
        
        To declare variable
        
        $name = "Rob";
        
        $name = 1;
        
        $name = true;
        
        $name = 1.134;
        
        Arrays
        
        Creating arrays
        
        Associative Array
        
        $myArray["myFavouriteFood"] = "ice cream";
        
        $AnotherArray = array("France" => "French", "USA" => "English");
        
        Standard Array
        
        $myArray = array("Rob", "Kirsten");
        
        To get the size of an array
        
        sizeof($myArray);
        
        To add or remove an element from an array
        
        Removing: unset($myArray["France"]);
        *This will remove the element associated with "France"
        Adding: $myArray[3] = "coffee";
        *This will add the element to the end of the list with it being associated with 3.
      - Conditional Code — Code that sometimes run and sometimes don't depending on the conditions on the program at that time. Conditional Expressions (Branches)
        
        The IF statement
        
        Conditions
        
        TRUE
        
        FALSE
        
        Complex Conditions
        
        if (condition) {
        action if true
        } else {
        action if false
        }
        
        if (condition1) {
        action if condition1 is true
        } else if (condition2) {
        action if condition2 is true
        } else if (condition3) {
        action if condition3 is true
        } else {
        action if all false
        }
        
        if (condition) {
        action if true ;
        if (new condition) {
        action if true ;
        }
        } else {
        action if false;
        }
        
        int x = (expr) ? 5 : 6;
        
        int x;
        if (expr) {
        x = 5;
        }
        else
        {
        x = 6;
        }
        
        if (condition) {
        code block
        }
        
        The SWITCH (select / select case) statement — conditional statement that permits enumeration of discrete cases, instead of relying on Boolean expressions
        
        switch ( $i ) {
        case value1:
        action1;
        break;
        case value2:
        action2;
        break;
        case value3:
        action3;
        break;
        default:
        action if false;
        }
    - - Getting input from the users after they have submitted their form
        
        $_GET variables
        
        $_GET variables are encoded into the URL itself
        
        E.g: http://www.mywebsite.com/homepage/?var1=value1&var2=value2
        
        $_GET variables can be accessed by:
        
        $_GET["var1"];
        
        Works like an array #
        
        $_POST variables
        
        Unlike $_GET, $_POST variables are not encoded into the URL
        
        Otherwise, it works like $_GET variables
      - Functions that check the values
        
        Checking of numeric values
        
        Inbuilt functions
        
        is_numeric($value) - checks if value is numeric
        
        Combinations of if statements and other functions
        
        if($value = round($value,0)); - checks if number is a whole number
        if($value > 0); - checks if number is a positive number
        if($value < 0) - checks if number is a negative number
        
        Checking of String values
        
        These functions usually return a boolean value
      - Ending the scirpt
        
        die();
      - Redirecting to other pages
        
        header("Location: filename.php");
  - - - Before the database can be accessed or edited a connection request to the database has to first be made
        
        Connecting to the database
        
        Querying the database
        
        First, define the database you want to query and the query you want to make with variables
        
        $query = SELECT column FROM table
        
        Types of Queries
        
        5 more items...
        
        Then, query the database using
        
        $row = mysqli_fetch_array($result);
        
        1 more item...
        
        $result = mysqli_query($link, $query);
        
        $link = mysqli_connect("HostServer" , "Username" , "Password" , "DatabaseName");
        
        $link = mysqli_connect("HostServer" , "Username" , "Password" , "DatabaseName");
    - - $_SESSION['username']
      - setcookie("variableName" , "value" , time());
      - $_COOKIE("variableName");
      - setcookie("variableName", "" ,time());
      - session_start();