UNITY PHP MYSQL DATABASE TUTORIAL

CHECKING VALUE

The following are the possible callbacks – SELECTING single data from MySQL database.

  • “Success” – User inputs and database value corresponds.
  • “Incorrect” – User password is incorrect.
  • “Unknown” – Username not available to the database.
  • “Failed” – Failed to connect to the database.
  • “Error” – User authentication is not valid.
<?php
  //Variables for Authentication.
  $server_key = "defaultkey123";
  $server_auth = $_POST["serverKeycode"];
  
  if($server_auth == $server_key)
  {
    //Variables for SQL Server.
    $server_mainname = $_POST["serverMainName"];
    $server_username = $_POST["serverUsername"];
    $server_password = $_POST["serverPassword"];
    $server_database = $_POST["serverDatabase"];
    
    //Established the connection to the mySQL server.
    $connection = new mysqli($server_mainname, $server_username, $server_password, $server_database);

    if($connection) 
    {
      //Variables for userdatabase.
      $username = $_POST["check_username"];
      $password = $_POST["check_password"];
    
      //Check data to the database.
      $sql = "SELECT password FROM userinfo WHERE username = '".$username."' ";
      $result = mysqli_query($connection, $sql);
      
      if($result)
      {
        if(mysqli_num_rows($result) > 0)
        {
          while($row = mysqli_fetch_assoc($result))
          {
            if($row['password'] == $password)
            {
              echo("Success");
            }

            else
            {
              echo("Incorrect");
            }	
          }
        }
      
        else
        {
          echo("Unknown");
        }
      }
    
      else
      {
        echo("Failed");
      }
    }
    
    else
    {
      die("Coonection Failed.".mysql_connect_error());
      echo("Failed");
    }
  }
  
  else
  {
    echo("Error");
  }
?>

SETTING VALUE

The following are the possible callbacks – INSERTING single data from MySQL database.

  • “Success” – Successfully adding inputs to the database.
  • “Existed” – Username existed from the database
  • “Failed” – Failed adding inputs to the database.
  • “Error” – User authentication is not valid.
<?php
  //Variables for Authentication.
  $server_key = "defaultkey123";
  $server_auth = $_POST["serverKeycode"];
  
  if($server_auth == $server_key)
  {		
    //Variables for SQL Server.
    $server_mainname = $_POST["serverMainName"];
    $server_username = $_POST["serverUsername"];
    $server_password = $_POST["serverPassword"];
    $server_database = $_POST["serverDatabase"];
    
    //Established the connection to the mySQL server.
    $connection = new mysqli($server_mainname, $server_username, $server_password, $server_database);
  
    if($connection) 
    {
      //Variables for userdatabase.
      $username = $_POST["set_username"];
      $password = $_POST["set_password"];
      $email = $_POST["set_email"];
      $firstname = $_POST["set_firstname"];
      $lastname = $_POST["set_lastname"];
      $gender = $_POST["set_gender"];
      $age = $_POST["set_age"];
    
      //Getting data from the database.
      $sqlCheck = "SELECT identity FROM userinfo WHERE username = '".$username."' ";
      $resultCheck = mysqli_query($connection, $sqlCheck);
      
      if($resultCheck)
      {
        if(mysqli_num_rows($resultCheck) < 1) 
        {
          //Insert data to the database.
          $sqlSet = "INSERT INTO userinfo (username, password, email, firstname, lastname, gender, age)
              VALUES('".$username."','".$password."','".$email."','".$firstname."','".$lastname."','".$gender."','".$age."')";
          $resultSet = mysqli_query($connection, $sqlSet);
          
          if($resultSet)
          {
            echo("Success");
          }
          
          else
          {
            echo("Failed");
          }
        }
        
        else
        {
          echo("Existed");
        }
      }
      
      else
      {
        echo("Failed");
      }
    }
  
    else
    {
      die("Coonection Failed.".mysql_connect_error());
      echo("Failed");
    }
  }
    
  else
  {
    echo("Error");
  }	
?>

 

GETTING VALUE

The following are the possible callbacks – SELECTING single/multiple data from MySQL database.

  • “Success” – User inputs and database value corresponds.
  • “Unknown” – User inputs not available to the database.
  • “Failed” – Failed to connect to the database.
  • “Error” – User authentication is not valid.
<?php
  //Variables for Authentication.
  $server_key = "defaultkey123";
  $server_auth = $_POST["serverKeycode"];
  
  if($server_auth == $server_key)
  {
    //Variables for SQL Server.
    $server_mainname = $_POST["serverMainName"];
    $server_username = $_POST["serverUsername"];
    $server_password = $_POST["serverPassword"];
    $server_database = $_POST["serverDatabase"];
    
    //Established the connection to the mySQL server.
    $connection = new mysqli($server_mainname, $server_username, $server_password, $server_database);

    if($connection) 
    {
      //Variables for userdatabase.
      $username = $_POST["get_username"];
    
      //Getting data from the database.
      $sql = "SELECT username, password, email, firstname, lastname, gender, age FROM userinfo WHERE username = '".$username."' ";
      $result = mysqli_query($connection, $sql);
      
      if($result)
      {
        if(mysqli_num_rows($result) > 0) 
        {
          while($row = mysqli_fetch_assoc($result))
          {
            echo "Success:".$row['username'].":".$row['password'].":".$row['email'].":".$row['firstname'].":".$row['lastname'].":".$row['gender'].":".$row['age']."";
          }
        }
    
        else
        {
          echo("Unknown");
        }
      }
    
      else
      {
        echo("Failed");
      }
    }
    
    else
    {
      die("Coonection Failed.".mysql_connect_error());
      echo("Failed");
    }
  }
  
  else
  {
    echo("Error");
  }	
  //dns1.register.com
?>

 

UPDATING VALUE

The following are the possible callbacks – UPDATING single data from MySQL database.

  • “Success” – Successfully adding inputs to the database.
  • “Existed” – Username existed from the database
  • “Failed” – Failed adding inputs to the database.
  • “Error” – User authentication is not valid.
<?php
  //Variables for Authentication.
  $server_key = "defaultkey123";
  $server_auth = $_POST["serverKeycode"];
  
  if($server_auth == $server_key)
  {
    //Variables for SQL Server.
    $server_mainname = $_POST["serverMainName"];
    $server_username = $_POST["serverUsername"];
    $server_password = $_POST["serverPassword"];
    $server_database = $_POST["serverDatabase"];
    
    //Established the connection to the mySQL server.
    $connection = new mysqli($server_mainname, $server_username, $server_password, $server_database);

    if($connection) 
    {
      //Variables for userdatabase.
      $identity = $_POST["update_identity"];
      $username = $_POST["update_username"];
      $password = $_POST["update_password"];
      $email = $_POST["update_email"];
      $firstname = $_POST["update_firstname"];
      $lastname = $_POST["update_lastname"];
      $gender = $_POST["update_gender"];
      $age = $_POST["update_age"];

      //Getting data from the database.
      $sqlCheck = "SELECT identity FROM userinfo WHERE identity = '".$identity."' ";
      $resultCheck = mysqli_query($connection, $sqlCheck);
      
      if($resultCheck)
      {
        if(mysqli_num_rows($resultCheck) > 0) 
        {
          //Insert data to the database.					
          $sqlUpdate = "UPDATE userinfo SET 
            username = '".$username."', 
            password = '".$password."', 
            email = '".$email."', 
            firstname = '".$firstname."', 
            lastname = '".$lastname."', 
            gender = '".$gender."', 
            age = '".$age."'
            WHERE identity = '".$identity."' ";
            
          $resultUpdate = mysqli_query($connection, $sqlUpdate);
          
          if($resultUpdate)
          {
            echo("Success");
          }
          
          else
          {
            echo("Failed");
          }
        }
        
        else
        {
          echo("Unknown");
        }
      }
      
      else
      {
        echo("Failed");
      }
    }
    
    else
    {
      die("Coonection Failed.".mysql_connect_error());
      echo("Failed");
    }
  }
    
  else
  {
    echo("Error");
  }	
?>

 

LISTING VALUE

The following are the possible callbacks – SELECTING multiple data rows from MySQL database.

  • “Success” – User inputs and database value corresponds.
  • “Unknown” – User inputs not available to the database.
  • “Failed” – Failed to connect to the database.
  • “Error” – User authentication is not valid.
<?php
  //Variables for Authentication.
  $server_key = "defaultkey123";
  $server_auth = $_POST["serverKeycode"];
  
  if($server_auth == $server_key)
  {
    //Variables for SQL Server.
    $server_mainname = $_POST["serverMainName"];
    $server_username = $_POST["serverUsername"];
    $server_password = $_POST["serverPassword"];
    $server_database = $_POST["serverDatabase"];
    
    //Established the connection to the mySQL server.
    $connection = new mysqli($server_mainname, $server_username, $server_password, $server_database);

    if($connection) 
    {
      //Check data to the database.
      $sql = "SELECT identity, username, password, email, firstname, lastname, gender, age FROM userinfo";
      $result = mysqli_query($connection, $sql);
      
      if($result)
      {
        if(mysqli_num_rows($result) > 0)
        {
          while($row = mysqli_fetch_assoc($result))
          {
            echo "\n"
            .$row['identity'].":"
            .$row['username'].":"
            .$row['password'].":"
            .$row['email'].":"
            .$row['firstname'].":"
            .$row['lastname'].":"
            .$row['gender'].":"
            .$row['age']."";
          }
        }
      
        else
        {
          echo("Unknown");
        }
      }
    
      else
      {
        echo("Failed");
      }
    }
    
    else
    {
      die("Coonection Failed.".mysql_connect_error());
      echo("Failed");
    }
  }
  
  else
  {
    echo("Error");
  }
?>

 

DELETE VALUE

The following are the possible callbacks – DELETING single data from MySQL database.

  • “Success” – Successfully adding inputs to the database.
  • “Existed” – Username existed from the database
  • “Failed” – Failed adding inputs to the database.
  • “Error” – User authentication is not valid.
<?php
  //Variables for Authentication.
  $server_key = "defaultkey123";
  $server_auth = $_POST["serverKeycode"];
  
  if($server_auth == $server_key)
  {
    //Variables for SQL Server.
    $server_mainname = $_POST["serverMainName"];
    $server_username = $_POST["serverUsername"];
    $server_password = $_POST["serverPassword"];
    $server_database = $_POST["serverDatabase"];
    
    //Established the connection to the mySQL server.
    $connection = new mysqli($server_mainname, $server_username, $server_password, $server_database);

    if($connection) 
    {
      //Variables for userdatabase.
      $identity = $_POST["delete_identity"];

      //Getting data from the database.
      $sqlCheck = "SELECT identity FROM userinfo WHERE identity = '".$identity."' ";
      $resultCheck = mysqli_query($connection, $sqlCheck);
      
      if($resultCheck)
      {
        $sqlDelete = "DELETE FROM `userinfo` WHERE identity = '".$identity."' ";
        $resultDelete = mysqli_query($connection, $sqlDelete);
      
        if($resultDelete)
        {
          echo("Success");
        }
      
        else
        {
          echo("Failed!");
        }
      }
      
      else
      {
        echo("Failed");
      }
    }
    
    else
    {
      die("Coonection Failed.".mysql_connect_error());
      echo("Failed");
    }
  }
    
  else
  {
    echo("Error");
  }	
?>

 

Constantly evolving with the latest software design techniques and related technologies. Please feel free to browse my Qualifications.

Leave your Thoughts