Wednesday, December 23, 2009

html



1)connection.php

<?php
$hostname = "localhost";
$database = "zfblog";
$username = "newbank";
$password = "new_bank";
$conn = mysql_connect($hostname, $username, $password) or die(mysql_error());
mysql_select_db($database, $conn);

?>

2)login.php

<?php
session_start();
require_once "connection.php";
?>
<html>
<HEAD><TITLE>pradeep</TITLE></HEAD>
<body>
<form action="#" method="POST">
<INPUT type="text" name="username">
<INPUT type="password" name="password">
<INPUT type="submit" name="login" value="Login">
</form>
<?php
if($_POST["login"]=='Login') {
$username=$_POST["username"];
$password=$_POST["password"];
$sql="SELECT * FROM authors WHERE username='".$username."' AND password='".$password."'";
$result=mysql_query($sql);

if(mysql_num_rows($result)>0) {
$_SESSION['user_name']=ucwords($username);
echo "<script>document.location='pradeep.php';</script>";
} else {
echo "enter correct login data";
}
}
if($_REQUEST["logout"]=='logout') {
if(isset($_GET['logout'])) {
$_SESSION['user_name']='';
echo "<script>document.location='login.php';</script>";
}
}
?>
</body>
</html>
3)modifi.php

<?php
session_start();
require_once "connection.php";
if(empty($_SESSION['user_name'])) {
header("Location:login.php");
}
?>


<?php
if($_REQUEST["type"]=='edit') {
?> <table><TR><TD></TD><td><a href="login.php?logout=logout">logout</a></td></TR></table>
<?php
echo $_SESSION['user_name'];
$sql="SELECT * FROM comments where id='".$_REQUEST['id']."'";
$result=mysql_query($sql);?>
<form action="modifi.php" method="POST">
<table width="60%" border="1px">
<TR>
<Th width="30%">Author</Th>
<Th width="50%">Email</Th>
</TR>
<?php
while($row=mysql_fetch_array($result)) {
?>
<tr>
<TD><INPUT type="text" name="author" value="<?php echo $row["author"]; ?>"><INPUT type="Hidden" name="id" value="<?php echo $row["id"]; ?>"></TD>
<TD><INPUT type="text" name="email" value="<?php echo $row["email"]; ?>"></TD>

</tr>

<?php }

?>
</table>
<INPUT type="submit" name="update" value="Update">
</form>
<?php
} else if($_REQUEST["type"]=='delete') {
echo "delete";
}
if($_POST["update"]=='Update') {
$update1="UPDATE comments SET author ='".$_POST["author"]."',email ='".$_POST["email"]."' WHERE id='".$_POST['id']."'";
$result=mysql_query($update1);
echo "<script>document.location='pradeep.php';</script>";
}
?>

4) pradeep.php

<?php
session_start();
require_once "connection.php";
if(empty($_SESSION['user_name'])) {
header("Location:login.php");
}
?>
<TITLE>pradeep</TITLE>
<table><TR><TD></TD><td><a href="login.php?logout=logout">logout</a></td></TR></table>
<?php
echo $_SESSION['user_name'];
$sql="SELECT * FROM comments";
$result=mysql_query($sql);?>
<table border="1px">
<TR>
<Th width="30%">Author</Th>
<Th width="50%">Email</Th>
<Th width="10%">Edit</Th>
<Th width="10%">Delete</Th>
</TR>
<?php
while($row=mysql_fetch_array($result)) {
?>
<tr>
<TD><?php echo $row["author"]; ?></TD>
<TD><?php echo $row["email"]; ?></TD>
<TD><a href="modifi.php?id=<?php echo $row["id"]; ?>&type=edit">Edit</a></TD>
<TD><a href="modifi.php?id=<?php echo $row["id"]; ?>&type=delete">Delete</a></TD>
</tr>

<?php }

?>
</table>




5) zfblog.sql
-- phpMyAdmin SQL Dump
-- version 3.1.2deb1ubuntu0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 24, 2009 at 02:06 PM
-- Server version: 5.0.75
-- PHP Version: 5.2.6-3ubuntu4.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `zfblog`
--

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

--
-- Table structure for table `authors`
--

CREATE TABLE IF NOT EXISTS `authors` (
`id` int(11) NOT NULL auto_increment,
`realname` varchar(255) collate utf8_unicode_ci NOT NULL,
`username` varchar(20) collate utf8_unicode_ci NOT NULL,
`password` varchar(64) collate utf8_unicode_ci NOT NULL,
`email` varchar(128) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `authors`
--

INSERT INTO `authors` (`id`, `realname`, `username`, `password`, `email`) VALUES
(1, 'pradeep kumar', 'pradeep', 'pradeep', 'pradeep.kumarrcs67@gmail.com');

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

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
`id` int(11) NOT NULL auto_increment,
`entry_id` int(10) unsigned NOT NULL default '0',
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,
`author` varchar(60) collate utf8_unicode_ci default NULL,
`email` varchar(200) collate utf8_unicode_ci default NULL,
`url` varchar(200) collate utf8_unicode_ci default NULL,
`body` text collate utf8_unicode_ci NOT NULL,
`type` varchar(10) collate utf8_unicode_ci NOT NULL default 'comment',
`status` varchar(10) collate utf8_unicode_ci NOT NULL default 'pending',
`referer` varchar(200) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`id`, `entry_id`, `date`, `author`, `email`, `url`, `body`, `type`, `status`, `referer`) VALUES
(1, 1, '2009-07-15 13:22:44', 'pradeep kumar', 'pradeep_rcs@odeyarpalya.com', 'http://pradeepkumarrcs.blogspot.com', 'fffff', 'comment', 'pending', NULL),
(2, 1, '2009-07-15 13:39:24', 'pradeep kumar', 'pradeep.kumarrcs67@gmail.com', 'http://pradeepkumarrcs.blogspot.com', 'dsfdsf', 'pradeepr4c', 'pending', NULL);

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

--
-- Table structure for table `entries`
--

CREATE TABLE IF NOT EXISTS `entries` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(200) collate utf8_unicode_ci NOT NULL,
`date` timestamp NOT NULL default '0000-00-00 00:00:00',
`author` varchar(60) collate utf8_unicode_ci NOT NULL default 'anonymous',
`author_id` int(11) NOT NULL default '0',
`body` text collate utf8_unicode_ci NOT NULL,
`extended_body` text collate utf8_unicode_ci NOT NULL,
`has_extended` tinyint(1) NOT NULL default '0',
`comment_count` int(4) NOT NULL default '0',
`last_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
FULLTEXT KEY `title` (`title`),
FULLTEXT KEY `body` (`body`),
FULLTEXT KEY `extended_body` (`extended_body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `entries`
--

INSERT INTO `entries` (`id`, `title`, `date`, `author`, `author_id`, `body`, `extended_body`, `has_extended`, `comment_count`, `last_modified`) VALUES
(1, 'pradeep', '2009-07-15 00:00:00', 'pradeep', 1, 'kumar', 'rcs', 2, 2, '2009-07-15 13:20:55');

Simple Login in php