PHP Variables Are Always Null

Question

I am trying to create a php login page, and capture the username and password input into html text boxes. But my issue is that my echo statement always returns null for the variables.

Why are these variables not beting set?

<?php
  include("config.php");
  session_start();

  if($_SERVER["REQUEST_METHOD"] == "POST") {
      $myusername = mysqli_real_escape_string($db,$_POST['username']);
      $mypassword = mysqli_real_escape_string($db,$_POST['password']); 
      echo $myusername;
      echo $mypassword;
  }
?>
<html>   
<head>
  <title>Login Page</title>      
  <style type = "text/css">
     body {
        font-family:Arial, Helvetica, sans-serif;
        font-size:14px;
     }
     label {
        font-weight:bold;
        width:100px;
        font-size:14px;
     }
     .box {
        border:#666666 solid 1px;
     }
  </style>      
   </head>   
   <body bgcolor = "#FFFFFF">             
           <form action = "" method = "post">
              <label>UserName:</label><input type = "text" name = "username" class = "box"/><br /><br />
              <label>Passwore:</label><input type = "password" name = "password" class = "box" /><br/><br />
              <input type = "submit" value = " Submit "/><br />
           </form>
</body>
</html>

EDIT
This is my config.php where I am using the mysqli_connect()

<?php
 define('DB_SERVER', 'localhost:3036');
 define('DB_USERNAME', 'user');
 define('DB_PASSWORD', 'pass');
 define('DB_DATABASE', 'db');
 $db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
?>

@SalmonKiller Blank action means to use the current URL as the action. — Barmar
– Barmar, Commented Sep 20, 2018 at 19:39
If you haven't yet connected to the database, i.e. through mysqli_connect, then the mysqli_real_escape_string function won't work. This is your problem. — Chris
– Chris, Commented Sep 20, 2018 at 19:42
You have an incorrect quote on the second define line. You have a curly quote instead of a straight quote. — Barmar
– Barmar, Commented Sep 20, 2018 at 19:45

Barmar · Accepted Answer · 2018-09-20 19:49:50Z

1

You can't specify a port number in the server name like that. It works for an external hostname, but it doesn't work when using localhost, according to this comment in the documentation. You need to use the optional port argument.

 define('DB_SERVER', 'localhost');
 define('DB_USERNAME', 'user');
 define('DB_PASSWORD', 'pass');
 define('DB_DATABASE', 'db');
 define('DB_PORT', 3036);
 $db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE,DB_PORT);

answered Sep 20, 2018 at 19:49

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Timmy Turner Over a year ago

That was it - adding the port to it's own define has the code functioning as it should

Collectives™ on Stack Overflow

PHP Variables Are Always Null

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related