Untitled

<html>
    <head>
        <title> Panel Firmy </title>
        <meta name="UTF-8">
        <link rel="stylesheet" type="text/css" href="style.css">
    </head>

    <body>
        <center>
        <br><br><br><br><br><br><br><br><br><br><br><br><br>
            Panel


        <?php
        /*
        $servername = "localhost";
            $username = "root";
            $password = "";
            $base = "database";

            $conn = new mysqli($servername, $username, $password, $base);
            if ($conn->connect_error) {
                die("Connection failed: " . $conn->connect_error);


    <------> II opcja

define('DB_HOST', 'localhost');
define('DB_NAME', 'practice');
define('DB_USER','root');
define('DB_PASSWORD','');

$con=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MySQL: " . mysql_error());
$db=mysql_select_db(DB_NAME,$con) or die("Failed to connect to MySQL: " . mysql_error());
*/

        /*
        $ID = $_POST['login'];
        $Password = $_POST['psw'];

function SignIn()
{
session_start();   //starting the session for user profile page
if(!empty($_POST['login']))   //checking the 'user' name which is from formular, is it empty or have some text
{
    $query = mysql_query("SELECT *  FROM user where login = '$_POST[login]' AND pass = '$_POST[psw]'") or die(mysql_error());
    $row = mysql_fetch_array($query) or die(mysql_error());
    if(!empty($row['user']) AND !empty($row['psw']))
    {
        $_SESSION['user'] = $row['psw'];
        echo "SUCCESSFULLY LOGIN TO USER PROFILE PAGE...";

    }
    else
    {
        echo "SORRY... YOU ENTERD WRONG ID AND PASSWORD... PLEASE RETRY...";
    }
}
}
if(isset($_POST['submit']))
{
    SignIn();
}
        */


   define('DB_SERVER', 'localhost');
   define('DB_USERNAME', 'root');
   define('DB_PASSWORD', '');
   define('DB_DATABASE', 'database');
   $db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);


    session_start();

   if($_SERVER["REQUEST_METHOD"] == "POST") {
      // username and password sent from form

      $myusername = mysqli_real_escape_string($db,$_POST['login']);
      $mypassword = mysqli_real_escape_string($db,$_POST['psw']);

      $sql = "SELECT id FROM user WHERE username = '$myusername' and passcode = '$mypassword'";
      $result = mysqli_query($db,$sql);
      $row = mysqli_fetch_array($result,MYSQLI_ASSOC);
      $active = $row['active'];

      $count = mysqli_num_rows($result);

      // If result matched $myusername and $mypassword, table row must be 1 row

      if($count == 1) {
         session_register("myusername");
         $_SESSION['login_user'] = $myusername;

         header("location: welcome.php");
      }else {
         $error = "Your Login Name or Password is invalid";
      }
   }
        ?>
                </center>
    </body>
</html>