Tuesday, 8 October 2013

Contact Form & Admin Login to view Contact details

POSTED BY :
ON
/
--------------------------------------------------------------------------------------
DATABASE
---------------------------------------------------------------------------------------
Create a database with name tour . Now copy paste the code below in a text file and save it with the name tour.sql .Import the sql file in your database created.

---------------------------------------------------------------------------------------------------------------
 -- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Oct 06, 2013 at 03:39 PM
-- Server version: 5.5.27
-- PHP Version: 5.4.7

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 utf8 */;

--
-- Database: `tour`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) DEFAULT NULL,
  `passcode` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `passcode`) VALUES
(1, 'test', 'test');

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

--
-- Table structure for table `contact`
--

CREATE TABLE IF NOT EXISTS `contact` (
  `name` varchar(30) NOT NULL,
  `email` varchar(30) NOT NULL,
  `message` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`name`, `email`, `message`) VALUES
('Kiran Shinde', 'djkiru07@gmail.com', 'A good Website...Keep it up!'),
('Rupesh Shinde', 'djruki007@gmail.com', 'Excellent...try to improve user interace'),
('Prasad Mane', 'pmane@gmail.com', 'I liked it.'),
('Durvesh Shinde', 'dshinde@gmail.com', 'Helped me to plan my trip..good effort.');

/*!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 */;
--------------------------------------------------------------------------------------------------------------- 


--------------------------------------------------------------------------------------
CONFIG.PHP(config.php)
---------------------------------------------------------------------------------------

<?php
$mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "tour";

$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Opps some thing went wrong");
mysql_select_db($mysql_database, $bd) or die("Opps some thing went wrong");

?>

---------------------------------------------------------------------------------------------------------------   
--------------------------------------------------------------------------------------
CONTACTS.HTML : (contacts.html)
---------------------------------------------------------------------------------------

<!DOCTYPE html>
<html lang="en">
<head>
  <title>TourDeMumbai</title>
  <meta charset="utf-8">
<style type="text/css">
label
{
font-weight:bold;

width:100px;
font-size:14px;

}
.box
{
border:#666666 solid 1px;

}
</style>
<script type="text/javascript">
function validateForm()
{
var name=document.forms["contact"]["name"].value;
var email=document.forms["contact"]["email"].value;
var filter = /^([a-zA-Z0-9_\.\-])+\@(([a-zA-Z0-9\-])+\.)+([a-zA-Z0-9]{2,4})+$/;
var message=document.forms["contact"]["message"].value;


if (name==null || name=="")
  {
  alert("First name must be filled out");
  name.focus;
  return false;
  }
if (!filter.test(email))
  {
    alert('Please provide a valid email address');
    email.focus;
    return false;
  }
 if (message==null || message=="")
  {
  alert("Message must be filled out");
  message.focus;
  return false;
  }
}
</script>

</head>
 <body>
<div align="center">
<div style="width:400px; border: solid 1px #333333; " align="left">
<div style="background-color:#333333; color:#FFFFFF; padding:3px;"><b>Contact Form</b></div>


<div style="margin:30px">

<form id="contacts-form" name="contact" action="contact.php" method="post" onSubmit="return validateForm()";>
    <table>
     <tr>
      <td>Your Name:</td>
      <td><input type="text" name="name" value=""/></td>
     </tr>
     <tr>
       <td>Your E-mail:</td>
       <td><input type="text" name="email" value=""/></td>
      </tr>
     <tr>
       <td>Your Message:</td>
       <td><textarea name="message"></textarea></td>
     </tr>
    </table>
     <div align="center"><input type="submit" value="Send">
       <input type="reset" value="Clear"></div>
     </form>
<div style="font-size:11px; color:#cc0000; margin-top:10px" align="center"><?php echo $error; ?></div>
</div>

</body>
</html>

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

--------------------------------------------------------------------------------------
CONTACT.PHP : (contact.php)
---------------------------------------------------------------------------------------

<?php
// Create connection
$con=mysqli_connect("127.0.0.1","root","","tour");

// Check connection
if (mysqli_connect_errno($con))
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }


$sql="INSERT INTO contact (name, email, message)
VALUES
('$_POST[name]','$_POST[email]','$_POST[message]')";

if (!mysqli_query($con,$sql))
  {
  die('Error: ' . mysqli_error($con));
  }
echo "Thank you for contacting us.";



mysqli_close($con);

?> 
--------------------------------------------------------------------------------------------------------------- 

--------------------------------------------------------------------------------------
LOGIN.PHP : (login.php)
---------------------------------------------------------------------------------------

<?php

include("config.php");
session_start();
$error="Enter your Credentials";

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

$myusername=addslashes($_POST['username']);
$mypassword=addslashes($_POST['password']);


$sql="SELECT id FROM admin WHERE username='$myusername' and passcode='$mypassword'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
$active=$row['active'];
$error="Enter Credentials";
$count=mysql_num_rows($result);


// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1)
{
$_SESSION['login_user']=$myusername;

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

<!DOCTYPE html>
<html lang="en">
<head>
  <title>Tour The Mumbai</title>
  <meta charset="utf-8">
 
  <style type="text/css">
label
{ font-weight:bold;
  width:100px;
  font-size:14px;
}
.box
{border:#666666 solid 1px;}
</style>
</head>
 <body>
<div align="center">
<div style="width:300px; border: solid 1px #333333; " align="left">
<div style="background-color:#333333; color:#FFFFFF; padding:3px;"><b>Login</b></div>


<div style="margin:30px">

<form action="" method="post">
<table cellspacing="10" cellpadding="5"><tr>
<td>UserName  </td><td><input type="text" name="username" class="box"/></td><tr/><br>
<tr><td>Password  </td><td><input type="password" name="password" class="box" /></td></tr>
</table><br>
<div align="center"><input type="submit" value=" Submit "/></div>

</form>
<div style="font-size:11px; color:#cc0000; margin-top:10px" align="center"><?php echo $error; ?></div>
</div>
 
</body>
</html>
---------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------
WELCOME.PHP : (welcome.php)
---------------------------------------------------------------------------------------
<?php
include('lock.php');
?>

<!DOCTYPE html>
<html lang="en">
<head>
  <title>TourDeMumbai</title>
  <meta charset="utf-8">
  </head>
 
 <body>
   <a href="logout.php"><input type="button" style=" background-color:#999" border="1" value="Logout"/></a>
   <h2>Contact <span>Details</span></h2>

  <?php
    $con=mysqli_connect("127.0.0.1","root","","tour");
    // Check connection
    if (mysqli_connect_errno())
     {
       echo "Failed to connect to MySQL: " . mysqli_connect_error();
     }

    $result = mysqli_query($con,"SELECT * FROM contact");

    echo "<table border='5' cellspacing='5' cellpadding='5' bordercolor='#000000' >
    <tr>
    <th>Name</th>
    <th>Email</th>
    <th>Message</th>
    </tr>";

    while($row = mysqli_fetch_array($result))
    {
     echo "<tr>";
     echo "<td>" . $row['name'] . "</td>";
     echo "<td>" . $row['email'] . "</td>";
     echo "<td>" . $row['message'] . "</td>";
     echo "</tr>";
    }
    echo "</table>";

    mysqli_close($con);
 ?>
          
</body>
</html>

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

--------------------------------------------------------------------------------------
LOGOUT.PHP : (logout.php)
---------------------------------------------------------------------------------------

<?php
session_start();
if(session_destroy())
{
header("Location: login.php");
}
?>

---------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------
LOCK.PHP : (lock.php)
---------------------------------------------------------------------------------------

<?php
include('config.php');
session_start();
$user_check=$_SESSION['login_user'];

$ses_sql=mysql_query("select username from admin where username='$user_check' ");

$row=mysql_fetch_array($ses_sql);

$login_session=$row['username'];

if(!isset($login_session))
{
header("Location: login.php");
}
?>
---------------------------------------------------------------------------------------------------------------









Unknown Web Developer

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Total Pageviews

DjKiRu Initative. Powered by Blogger.

Copyright © TechWizard. Created By