User Credential Form

• This is a user credential form project for 'customers' and business vendors; written scripts are in PHP and SQL for the MySQL database.
• NOTE: To use database, create a database name like 'customers' and import the users.sql in phpmyadmin, etc. To connect, you can use " localhost:port/ " if you're using Apache or WAMPserver.
• This comes with a GUI database. As you'll find, the CSS stylesheets are in separate folders.

DEMO

• User Credentials Form
• Database for the form

Instructions on how to install

• Download the release .zip file.
• Extract all of the folders and files.
• Open your domain's SQL database server.
• Import the 'users.sql' from the 'sql' folder to the database (this will include blanket info to use to test the database).
• Open the 'connect.php' & 'customer.php' files from the .zip file to manually change the database credentials to your own database credentials. Example @ Establishing connection to server
• Upload all files (except 'users.sql' and 'sql folder) and folders to your FTP server.
• Go to your web browser and type in the web address https://yourdomain.com/users.php to see the user credential form.
• Try out the https://yourdomain.com/customer.php to ensure the database works as well.

Establishing connection to server

$db = mysqli_connect("servername", "username", "password", "databasename");

Server request determines if the request is POST or GET

if ($_SERVER["REQUEST_METHOD"] == "POST") 

SQL server check connection with error handling

// Check connection
if ($mysqli -> connect_errno) {
  echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
  exit();
}

Customized Cascade Stylesheet

	  /* Form CSS Layout*/
      form {
      width: 500px; 
      padding: 2px;
      border-radius: 10px;
      box-shadow: 0 5px 10px 0 #c3c9b5; 
	  padding-left: 250px;
      padding-right: 250px;
	  padding-bottom: 50px;
	  background-color: #fafafa;
	  }
	  
	  /* Form CSS User Input */
      input {
      margin-bottom: 10px;
      border: 1px dotted #ccc;
      border-radius: 7px;
      width: calc(100% - 5px);
      padding: 1px;
	  padding-left: 20px;
	  box-shadow: 2px 2px 5px 2px #ccc;
      }
      

Contributors

Jamil Matheny

Sample Screenshots

The user credential form

The database (dummy data)

License

GNU General Public License v3.0