apple2

3 Page:insert.php

<h1><a href="index.php">Back </a></h1>
<?php

include 'db.php';

$name = $_POST['name'];

$insert = mysql_query("insert into apple(name) values ('$name') ");

echo $name;
echo "Data inserted successfully";


?>

<form action="" method="post">
Name: <input type="text" name="name"><br />
<input type="submit" value="Enter" name="enter">
</form>
<h1> List of Companies <a href="Logout.php">
click here to log out</a></h1>
//////////////////////////////////////////////////End//////////////////////////
4:Page login.php
<?php 
session_start("name");

include 'db.php';

$user = $_POST['user'];
$pass = $_POST['pass'];
//echo $user;
//echo $pass;
//var_dump($_POST);

$user =stripcslashes($user);
$pass =stripcslashes($pass);
$user = mysql_escape_string($user);
$pass = mysql_escape_string($pass);

$result = mysql_query("select * from user where username='$user' and password='$pass' ")
or die("Failed to query database ".mysql_error());

$row = mysql_fetch_array($result);
if ($row['username'] == $user & $row['password'] == $pass  ) {
    echo "Login successful!!! Welcome" .$row['username'];
    echo $row['username'];
echo $row['password'];
    header( 'Location: insert.php' );
} else {
echo "Failed to login";
}

?>
<html>
<head><title>Login Page</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<div id="frm">
<form method="POST" action="">
<p>
<label>User Name</label>
<input type="text" id="user"  name="user">
</p>
<p>
<label>Password</label>
<input type="password" id="pass" name="pass">
</p>
<p>
<input type="submit" id="btn" value="Login">
</p>
</form>
</div>
</body>
</html>

Comments

Post a Comment

Popular posts from this blog

Complete Php

Db.php  <?php $host = "localhost"; $user = "root"; $pass = ""; $db   = "practice"; $link =mysqli_connect($host,$user,$pass,$db) or die(mysqli_error()); if($link) { echo "Database Connected Successfully"; } else { echo "Not Connected with a database"; } ?> insert.php <?php include 'db.php'; $phone = $_POST['phone']; $sql =mysqli_query($link,"insert into user (phone) values ('$phone')  "); ?> <hr> Welcome to insert page <br> <a href="logout.php">Logout</a><a href="show.php">show php</a> <form method="post" action=""> Phone<input type="text" name="phone" > <input type="submit"> </form> Show.php with Edit starts here <?php include 'db.php'; $sql = ("select * from user "); $re...
Read more

Crud

Db.php <?php mysql_connect("localhost","root",""); mysql_select_db('crud'); echo "crud Database" ?>              ====================================================== <?php // Steps Edit ////////////////////Show data in the edit field // 1 connection // $id = $_GET['edit']; variable to get data from the last page from <a href="edit.php?edit=' $row['id']">edit</a> //$query = mysql_query("select * from table where id='$id' "); //catch data in $row = mysql_fetch_array($query); //Show data in input field in value="<?php echo $row['id']; > " /////////////// // Update data // if(isset($_POST['update'])){ // set variable names $name=$_POST['name']; and phone etc //$update = "update table set name ='$name' , phone='$phone' where id='$id' "; // $result =mysql_query($update); //} in...
Read more

apple

1: Page: db.php  // to make connection  <?php mysql_connect("localhost","root","");  mysql_select_db('login'); echo "Login database"; ?> //////////End/////////// 2: Page index.php <?php include "db.php";      if(isset($_POST['enter'])) { $name =$_POST['name']; echo $name; $in = "insert into apple (name) values('$name')"; $re = mysql_query($in); } $show = "select * from apple "; $results =mysql_query($show); echo "<table class=\"table table-striped\">       <tr>             <th>ID</th>             <th>Name</th>             <th>Edit</th>             <th>Delete</th>             <th>insert</th>       </tr>"; while ($row = mysql_fetch_array($results)) {...
Read more