Free Programming Source Codes and Computer Programming Tutorials: Login and Registration in PHP and MySQL Using Bootstrap

Here are a sample login and registration system that I wrote in PHP and MySQL using the Bootstrap CSS framework. I hope you will find my work useful. Thank you.

I am currently accepting programming work, it projects, school

programming projects, thesis and capstone projects, IT consulting

work, computer tutorials, and web development work kindly contact me in the following email address for further details. If you want to advertise on my website kindly contact me also in my email address also. Thank you.

My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.

My mobile number here in the Philippines is 09173084360.

My telephone number at home here in Bacolod City, Negros Occidental Philippines is +63 (034) 4335675.

My personal website is http://www.jakerpomperada.com

Sample Program Output

Program Listing

index.php

<!DOCTYPE html>

<head>

<title>PHP Login Form</title>

</head>

<!-- NAVBAR

================================================== -->

<body>

<h2>Please Sign In</h2>

</div>

</div>

</div>

<div class="col-xs-6 col-sm-6 col-md-6"> <a href="register.php" target="_blank" class="btn btn-lg btn-primary btn-block">Register</a> </div>

</div>

</fieldset>

</form>

</div>

<?php

include('connect.php');

if (isset($_POST['Submit'])) {

{

$username = $_POST['username'];

$password = $_POST['password'];

$sql1= "select * from emp where username= '".$_REQUEST['username']."' && password ='".$_REQUEST['password']."'";

$result=mysql_query($sql1) or exit("Sql Error".mysql_error());

$num_rows=mysql_num_rows($result);

if($num_rows>0)

{

echo "<script> alert('You have logged in successfully'); </script>";

}

else

{

echo "<script> alert('username or password incorrect'); </script>";

}

</body>

</html>

connect.php

<?php

$hostname="localhost"; //local server name default localhost

$username="root"; //mysql username default is root.

$password=""; //blank if no password is set for mysql.

$database="employees"; //database name which you created

$con=mysql_connect($hostname,$username,$password);

if(! $con)

{

die('Connection Failed'.mysql_error());

}

mysql_select_db($database,$con);

register.php

<!DOCTYPE html>

<head>

<title>Registration</title>

</head>

<!-- NAVBAR

================================================== -->

<body>

<h2>Please Register Here</h2>

</div>

</div>

</fieldset>

</form>

</div>

</body>

</html>

<?php

include('connect.php');

if (isset($_POST['submit'])) {

$username = $_POST['username'];

$password = $_POST['password'];

$query = "INSERT INTO emp (username,password) VALUES('$username', '$password')";

$result = mysql_query($query);

if ($result == TRUE) {

echo 'Successfully Registered!';

} else {

echo 'Registration failed. Check database settings';

}

emp.sql

-- phpMyAdmin SQL Dump

-- version 4.5.1

-- http://www.phpmyadmin.net

-- Host: 127.0.0.1

-- Generation Time: Oct 07, 2018 at 04:02 PM

-- Server version: 5.7.21

-- PHP Version: 5.6.24

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;

-- Database: `employees`

-- --------------------------------------------------------

-- Table structure for table `emp`

CREATE TABLE `emp` (

`id` int(11) NOT NULL,

`username` varchar(100) NOT NULL,

`password` varchar(100) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Dumping data for table `emp`

INSERT INTO `emp` (`id`, `username`, `password`) VALUES

(1, '123', '123'),

(2, 'a', 'a'),

(3, 'jake', 'jake');

-- Indexes for dumped tables

-- Indexes for table `emp`

ALTER TABLE `emp`

ADD PRIMARY KEY (`id`);

-- AUTO_INCREMENT for dumped tables

-- AUTO_INCREMENT for table `emp`

ALTER TABLE `emp`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

DOWNLOAD SOURCE CODE HERE

Free Programming Source Codes and Computer Programming Tutorials

Sunday, October 7, 2018

Login and Registration in PHP and MySQL Using Bootstrap

Sample Program Output

No comments:

Post a Comment

Google Ads

Followers