Admin Panel in PHP

Satyapriya Nayak
Jun 24, 2012

235.7k
0
11
- facebook
- twitter
- linkedIn
- Reddit
- WhatsApp
- Email
- Print
- Other Artcile

Introduction

In this article we will learn how to create an admin panel. In this panel we have a content link where we can manage the contents. Here admin can add the contents, update the contents and as well as delete the contents. When adding contents we use fckeditor. Paging facilities are also provided for the contents. We have provided a password change link for the admin to change the password.

Table Structure

-- phpMyAdmin SQL Dump

-- version 2.10.1

-- http://www.phpmyadmin.net

-- Host: localhost

-- Generation Time: Jun 24, 2012 at 11:14 AM

-- Server version: 5.0.45

-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- Database: `Work`

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

-- Table structure for table `admin`

CREATE TABLE `admin` (

`id` int(11) NOT NULL auto_increment,

`uid` varchar(255) NOT NULL,

`pass` varchar(255) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- Dumping data for table `admin`

INSERT INTO `admin` (`id`, `uid`, `pass`) VALUES

(1, 'admin', 'admin');

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

-- Table structure for table `content`

CREATE TABLE `content` (

`id` int(11) NOT NULL auto_increment,

`page_title` varchar(1000) NOT NULL,

`details` longtext NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- Dumping data for table `content`

INSERT INTO `content` (`id`, `page_title`, `details`) VALUES

(1, 'Home', '<p>This is home page</p>'),

(2, 'Contact Us', '<p>This is contact us page</p>'),

(3, 'About us', '<p>This is about us page</p>');

Let's move to the coding part.

config.php

<?php

$sDbHost = 'localhost';
$sDbName = 'Work';
$sDbUser = 'root';
$sDbPwd = '';

$dbConn = mysql_connect ($sDbHost, $sDbUser, $sDbPwd) or die ('MySQL connect failed. ' . mysql_error());
mysql_select_db($sDbName,$dbConn) or die('Cannot select database. ' . mysql_error());

?>

index.php(inside admin folder)

<?php session_start();

include_once("config.php");

if(isset($_POST["submit"]))

{

$uname=$_POST["uname"];

$pass=$_POST["pass"];

$sql="select * from admin where uid='".$uname."' and pass='".$pass."'";

$res=mysql_query($sql);

$rs=mysql_fetch_assoc($res);

if(mysql_num_rows($res)>0)

{

$_SESSION["log"]="true";

echo "<script>location.href='home.php'</script>";

}

else

{

echo "<script>location.href='index.php?inv_usr=yes'</script>";

}

if($_REQUEST["qs"]=="logout")

{

$_SESSION["log"]="";

}

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Admin Area</title>

<!--

.style2 {

font-family: Verdana, Arial, Helvetica, sans-serif;

font-size: 18px;

color: #000000;

font-style: italic;

}

.style3 {color: #000000}

-->

</style>

</head>

<?php if($_GET['inv_usr'] == 'yes')

{

echo "<strong>Invalid Username or Password</strong>";

}

</cenetr>

</p>

<tr>

</tr>

<tr>

<tr >

<td height="29" colspan="2" align="center" class="header2 style2">Login Here </td>

</tr>

<tr >

</tr>

<tr >

<td height="27" align="left" class="tahomaheader style3">Password</td>

</tr>

<tr >

       </td>

</tr>

</form>

</table></td>

</tr>

<tr>

</tr>

</table>

</center>

</body>

</html>

home.php

<?php include("session_config.php"); ?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML><HEAD><TITLE>Control Panel</TITLE>

<!--

.style1 {font-weight: bold}

.style7 {

color: #00CCFF;

font-size: 24px;

}

.style8 {

color: #666666;

font-weight: bold;

}

-->

</style>

</HEAD>

<BODY>

<TBODY>

<TR>

<tbody>

<tr>

<div style="padding-left:15px; padding-top:15px"><u>Administrator Control Panel</u></div></td>

</tr>

<tr>

<a href="home.php">Home</a> |

<a href="content.php">Contents</a> |

<a href="password_change.php">Change Password</a> |

<a href="index.php?qs=logout">Logout</a></span></td>

</tr>

<tr>

</td>

</tr>

<tr>

<td width="100%" bgcolor="#999999" height="22px" align="left"><span class="style7">Content Manage System</span></td>

<tr>

<span class="headingtext">Welcome to Admin Panel </span>

<tr>

<tr>

</tr>

</table></td>

<tr>

</tr>

</tbody>

</table>

</TD>

</TR></TBODY></TABLE>

</BODY>

</HTML>

content.php

<?php

include("session_config.php");

include("config.php");

if(isset($_GET['task']) && trim($_GET['task'])=="delete")

{

$del="delete from content where id='".$_GET['id']."'";

mysql_query($del) or die(mysql_error());

}

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML><HEAD><TITLE>Control Panel</TITLE>

<!--

.style1 {font-weight: bold}

.style7 {

color: #00CCFF;

font-size: 24px;

}

.style8 {

color: #FFFFFF;

font-weight: bold;

}

.style9 {

color: #666666;

font-weight: bold;

}

-->

</style>

</HEAD>

<BODY>

<TBODY>

<TR>

<tbody>

<tr>

Administrator - Control Panel</u></div></td>

</tr>

<tr>

<a href="home.php">Home</a> |

<a href="content.php">Contents</a> |

<a href="password_change.php">Change Password</a> |

<a href="index.php?qs=logout">Logout</a></span></td>

</tr>

<tr>

</td>

</tr>

<tr>

<td width="100%" bgcolor="#999999" height="22px" align="left"><span class="style7">Manage Contents</span></td>

</tr>

<tr>

<tr>

</tr>

</tr>

</table></td>

</tr>

</table>

<?php

//********************PAGINATION*********************

if (isset($_GET['pageno']))

{

$pageno = $_GET['pageno'];

}

else

{

$pageno = 1;

}

$query = "SELECT count(*) FROM content order by id asc";

$result = mysql_query($query) or trigger_error("SQL", E_USER_ERROR);

$query_data = mysql_fetch_row($result);

$numrows = $query_data[0];

//3. Calculate number of $lastpage

//This code uses the values in $rows_per_page and $numrows in order to identify the number of the last page.

$rows_per_page = 18;

$lastpage = ceil($numrows/$rows_per_page);

//4. Ensure that $pageno is within range

//This code checks that the value of $pageno is an integer between 1 and $lastpage.

$pageno = (int)$pageno;

if ($pageno > $lastpage)

{

$pageno = $lastpage;

}

if ($pageno < 1)

{

$pageno = 1;

}

//5. Construct LIMIT clause

//This code will construct the LIMIT clause for the sql SELECT statement.

$limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page;

//$query = "SELECT * FROM user $limit";

//$result = mysql_query($query) or trigger_error("SQL", E_USER_ERROR);

<tr>

</tr>

<tr>

<td width="84%" bgcolor="#666633"><span class="style8">Page Title</span></td>

<td width="8%" bgcolor="#666633"><span class="style8">Remove</span></td>

</tr>

<?php

if($_REQUEST["cnt"]!="")

{

$count=$_REQUEST["cnt"];

$cntprev=$count-2;

}

else

{

$count=1;

}

$str="select * from content order by id asc $limit";

$row=mysql_query($str);

while($res=mysql_fetch_assoc($row))

{

<td align="center"><a href="content.php?task=delete&id=<?php echo $res['id'];?>" onClick="return confirm('Are you sure you want to delete this record?');"><img src="adminimages/ddelete.gif" width="25" height="25" border="0"></a></td>

</tr>

<?php }?>

<tr>

<?php

if ($pageno == 1)

{

echo " FIRST PREV ";

}

else

{

echo " <a href='{$_SERVER['PHP_SELF']}?pageno=1&cnt=1'>FIRST</a> ";

$prevpage = $pageno-1;

echo "<a href='{$_SERVER['PHP_SELF']}?pageno=$prevpage&cnt=".$cntprev."'>PREV</a> ";

}

echo "(Page $pageno of $lastpage)";

if ($pageno == $lastpage)

{

echo " NEXT LAST ";

}

else

{

$nextpage = $pageno+1;

echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$nextpage&cnt=$count'>NEXT</a> ";

echo " <a href='{$_SERVER['PHP_SELF']}?pageno=$lastpage&cnt=$numrows'>LAST</a> ";

}

?></td>

</tr>

</table>

<tr>

<tr>

</tr>

</table></td>

<tr>

</tr>

</tbody>

</table>

</TD>

</TR></TBODY></TABLE>

</BODY>

</HTML>

add_new.php

<?php

include("session_config.php");

include("config.php");

include_once("../fckeditor/fckeditor_php4.php");

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML><HEAD><TITLE>Control Panel</TITLE>

function validate()

{

if(document.getElementById("page_title").value=="")

{

alert("Page title can not be Blank !!");

document.getElementById("page_title").focus();

return false;

}

return true;

}

</script>

<!--

.style1 {font-weight: bold}

.style7 {

color: #00CCFF;

font-size: 24px;

}

.style8 {color: #FFFFFF}

.style9 {

color: #333333;

font-weight: bold;

}

.style10 {

color: #666666;

font-weight: bold;

}

-->

</style>

</HEAD>

<BODY>

<TBODY>

<TR>

<tbody>

<tr>

<div class="style10" style="padding-left:15px; padding-top:15px"><u>Web

Administrator - Conrol Panel</u></div></td>

</tr>

<tr>

<a href="home.php">Home</a> |

<a href="content.php">Contents</a> |

<a href="password_change.php">Change Password</a> |

<a href="index.php?qs=logout">Logout</a></span></td>

</tr>

<tr>

</tr>

<tr>

<td width="100%" bgcolor="#999999" height="22px" align="left"><span class="style7">Manage Contents</span></td>

<tr>

<tr>

</tr>

</tr>

</table></td>

</tr>

</table>

<?php

if($_REQUEST["Submit"]==" Add ")

{

$sql="select page_title from content where page_title='".$_REQUEST["page_title"]."'";

$row=mysql_query($sql);

if(mysql_num_rows($row)>0)

{

$msg="This Page is already exist";

}

else

{

$title=$_REQUEST["page_title"];

$details=str_replace("'"," ",$_REQUEST["message"]);

$str="insert into content(page_title,details)values('".$title."','".$details."')";

mysql_query($str);

$msg="Saved Successfully";

}

<td colspan="2" height="25"><span class="heading3 style8"><strong>Basic Details</strong></span></td>

</tr>

<td width="24%" height="30"><span class="style9">Page Title</span></td>

</tr>

<td colspan="2" height="20"><span class="heading3 style8"><strong>Descriptive details</strong></span></td>

</tr>

<tr>

<?php

$sBasePath = "../fckeditor/";

$oFCKeditor = new FCKeditor('message') ;

$oFCKeditor->BasePath = $sBasePath ;

$oFCKeditor->ToolbarSet = "Basic" ;

//$oFCKeditor->Value =$rs["message"];

$BOX_BLOG_RTE=$oFCKeditor->CreateHTML();

echo $BOX_BLOG_RTE;

?></td>

</tr>

</tr>

</tr>

</table>

</form>

<tr>

<tr>

</tr>

</table></td>

</tbody>

</table>

</TD>

</TR></TBODY></TABLE>

</BODY>

</HTML>

content_edit.php

<?php

include("session_config.php");

include("config.php");

include_once("../fckeditor/fckeditor_php4.php");

$id=$_GET["id"];

<?php

if($_REQUEST["Submit"]=="Update")

{

$mesg=str_replace("'",'"',$_REQUEST["message"]);

$str="update content set page_title='".$_REQUEST["page_title"]."',details='".$mesg."' where id='".$_REQUEST["hiddenID"]."'";

mysql_query($str);

//echo $str;

//exit;

$U_mesg="Updated Successfully";

echo "<script>location.href='content.php?qs=$U_mesg'</script>";

}

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML><HEAD><TITLE>Control Panel</TITLE>

function validate()

{

if(document.getElementById("page_title").value=="")

{

alert("Page title can not be Blank !!");

document.getElementById("page_title").focus();

return false;

}

if(document.getElementById("message").value=="")

{

alert("Add Content !!");

//document.getElementById("address").focus();

return false;

}

return true;

}

</script>

<!--

.style1 {font-weight: bold}

.style7 {

color: #00CCFF;

font-size: 24px;

}

.style8 {

color: #666666;

font-weight: bold;

}

.style9 {color: #FFFFFF}

-->

</style>

</HEAD>

<BODY>

<TBODY>

<TR>

<tbody>

<tr>

<div class="style8" style="padding-left:15px; padding-top:15px"><u>Web

Administrator - Conrol Panel</u></div></td>

</tr>

<tr>

<a href="home.php">Home</a> |

<a href="content.php">Contents</a> |

<a href="password_change.php">Change Password</a> |

<a href="index.php?qs=logout">Logout</a></span></td>

</tr>

<tr>

</tr>

<tr>

<td width="100%" bgcolor="#999999" height="22px" align="left"><span class="style7">Manage Contents</span></td>

<tr>

<tr>

</tr>

</tr>

</table></td>

</tr>

</table>

<?php

$sql="SELECT * FROM content where id='".$id."'";

$rows=mysql_query($sql) or die(mysql_error());

//echo $sql;

//exit;

while($result= mysql_fetch_assoc($rows))

{

</tr>

<td colspan="2" height="25"><span class="heading3 style9"><strong>Basic Details</strong></span></td>

</tr>

<td width="24%" height="30"><strong>Page Title</strong></td>

</tr>

<td colspan="2" height="20"><span class="heading3 style9"><strong>Descriptive details</strong></span></td>

</tr>

<tr>

<?php

$sBasePath = "../fckeditor/";

$oFCKeditor = new FCKeditor('message') ;

$oFCKeditor->BasePath = $sBasePath ;

$oFCKeditor->ToolbarSet = "Basic" ;

$oFCKeditor->Value =$result["details"];

$BOX_BLOG_RTE=$oFCKeditor->CreateHTML();

echo $BOX_BLOG_RTE;

?></td>

</tr>

</tr>

</tr>

</table>

<?php } ?>

</form>

<tr>

<tr>

</tr>

</table></td>

</tbody>

</table>

</TD>

</TR></TBODY></TABLE>

</BODY>

</HTML>

password_change.php

<?php

include("session_config.php");

include("config.php");

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML><HEAD><TITLE>Control Panel</TITLE>

function validate()

{

if(document.getElementById("old_uname").value=="")

{

alert("Old User Name Can not be Blank !!");

document.getElementById("uname").focus();

return false;

}

if(document.getElementById("new_uname").value=="")

{

alert("Enter New User Name !!");

document.getElementById("new_uname").focus();

return false;

}

if(document.getElementById("pass").value=="")

{

alert("Password Can not be Blank !!");

document.getElementById("pass").focus();

return false;

}

if(document.getElementById("cpass").value=="")

{

alert("Confirm Password Can not be Blank !!");

document.getElementById("cpass").focus();

return false;

}

if(document.getElementById("pass").value!=document.getElementById("cpass").value)

{

alert("Password Mismatch");

document.getElementById("cpass").focus();

return false;

}

return true;

}

</script>

<!--

.style1 {font-weight: bold}

.style7 {

color: #00CCFF;

font-size: 24px;

}

.style9 {

color: #FF6666;

font-weight: bold;

}

.style12 {

color: #666666;

font-weight: bold;

}

.style14 {color: #CC0033; font-weight: bold; }

-->

</style>

</HEAD>

<BODY>

<TBODY>

<TR>

<tbody>

<tr>

Administrator - Control Panel</u></div></td>

</tr>

<tr>

<a href="home.php">Home</a> |

<a href="content.php">Contents</a> |

<a href="password_change.php">Change Password</a> |

<a href="index.php?qs=logout">Logout</a></span></td>

</tr>

<tr>

</tr>

<tr>

<td width="100%" bgcolor="#999999" height="22px" align="left"><span class="style7">Manage Password </span></td>

<tr>

<tr>

</tr>

</table>

<?php

if($_POST["Submit"]=="Update")

{

$old_user_name=$_REQUEST["old_uname"];

$new_user_name=$_REQUEST["new_uname"];

$qry="select uid from admin where uid='".$old_user_name."'";

//echo $qry;

//exit;

$res=mysql_query($qry);

$num_rows=mysql_num_rows($res);

//echo $num_rows;

//exit;

if($num_rows > 0)

{

$sql="update admin set uid='".$new_user_name."',pass='".$_REQUEST["pass"]."' where id=1";

//echo $sql;

//exit;

mysql_query($sql);

$msg="Password Updated Successfully";

}

else

{

$msg="You Have Entered Invalid User Name";

}

<tr>

</tr>

<td colspan="2"><span class="style7">Change Password</span></td>

</tr>

<?php

$str="select * from admin where id=1";

$row=mysql_query($str);

while($res=mysql_fetch_assoc($row))

{

<tr>

</tr>

<tr>

</tr>

<tr>

<td bgcolor="#CCCCCC"><span class="style14">New Password</span></td>

</tr>

<tr>

<td bgcolor="#CCCCCC"><span class="style14">Confirm Password </span></td>

</tr>

<?php } ?>

</tr>

</table>

</form>

<tr>

<tr>

</tr>

</table></td>

</tbody>

</table>

</TD>

</TR></TBODY></TABLE>

</BODY>

</HTML>

session_config.php

<?php session_start();
if($_SESSION["log"]!="true")
{
echo "<script>location.href='index.php'</script>";
}
?>

index.php(outside admin folder)

<?php include("config.php"); ?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML>

<HEAD>

<TITLE>Admin panel</TITLE>

BODY {

BACKGROUND-REPEAT: repeat; BACKGROUND-COLOR: #CCFFFF}

</STYLE>

.style1 {

COLOR: #cc0000

}

#notice {

Z-INDEX: 1; LEFT: 375px; WIDTH: 422px; POSITION: absolute; TOP: 201px; HEIGHT: 99px; BACKGROUND-COLOR: #ffffff

}

a:link {

color: #FFFFFF;

text-decoration: none;

}

a:visited {

text-decoration: none;

color: #FFFFFF;

}

a:hover {

text-decoration: underline;

color: #000000;

}

a:active {

text-decoration: none;

color: #FFFFFF;

}

.style2 {color: #FFFFFF}

.style3 {FONT-SIZE: 11px; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif; LETTER-SPACING: 0.02em; font-weight: bold;}

.style4 {FONT-SIZE: 11px; FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif; LETTER-SPACING: 0.02em; font-weight: bold; color: #FFFFFF; }

.style5 {

color: #0000FF;

font-weight: bold;

}

.style6 {

font-size: 16px;

font-weight: bold;

}

.style7 { color: #FFFFFF;

font-family: Verdana;

font-size: 11px;

font-weight: normal;

text-decoration: none;

}

</STYLE>

</HEAD>

<TABLE cellSpacing=0 cellPadding=0 width=812 align=center bgColor=#ffffff

border=0>

<TBODY>

<TR>

<TD width=21><IMG height=21 src="index_files/topcorner2.gif"

width=21></TD></TR>

<TR>

<TD>

<TABLE cellSpacing=0 cellPadding=0 width=770 align=center bgColor=#ff6600

border=0>

<TBODY>

<TR>

<TBODY>

<TR>

<TD width=205 bgColor=#9c9a9c><img height=132 alt=""

src="index_files/topbanne.jpg" width=205></TD>

<TBODY>

<TR>

<TD bgColor=#3D7FEF><IMG height=100 alt=""

src="index_files/toprighte1.jpg" width=565></TD>

</TR>

<TR>

<TABLE cellSpacing=0 cellPadding=0 width="100%"

border=0>

<TBODY>

<TR>

<MARQUEE class="redbod style1"

scrollDelay=150>

Welcome to Main page

</MARQUEE></TD>

<SCRIPT language=javascript

src="index_files/date.js"></SCRIPT>

</DIV></TD>

</TR>

</TBODY>

</TABLE></TD>

</TR>

</TBODY>

</TABLE></TD>

</TR>

</TBODY>

</TABLE></TD>

</TR>

<TR>

<TBODY>

<TR>

<TBODY>

<TR>

<TD height=187 colspan="3" vAlign=top bgColor=#3D7FEF><TABLE cellSpacing=0 cellPadding=0 width=180

align=center border=0>

<TBODY>

<?php

$str="select * from content";

//echo $str;

$row=mysql_query($str);

while($res=mysql_fetch_assoc($row))

{

<TR>

</TR>

<?php } ?>

</TBODY>

</TABLE></TD>

</TR>

<TR>

</TR>

<TR>

<TD width="58%"><div align="center" class="redbod style2">Last updated </div></TD>

</TR>

<TR>

</TR>

</TBODY></TABLE></TD>

<TR>

<TD>

<tr>

<?php

if($_REQUEST["qs"]=="cont_show")

{

$_SESSION["ses"]="1";

$cont="select * from content where id='".$_GET["pageid"]."'";

//echo $cont;

//exit;

$cont_row=mysql_query($cont);

$cont_res=mysql_fetch_assoc($cont_row);

<tr>

<?php

echo "<font color='#3D7FEF'>"."<b>"."Site Map >".$cont_res["page_title"]."</b>"."<font>"."<br>"."<br>";

echo $cont_res["details"];

?> </td>

</tr>

<?php } ?>

<?php

if($_SESSION["ses"]=="")

{

$cont="select * from content where id='1'";

//echo $cont;

//exit;

$cont_row=mysql_query($cont);

$cont_res=mysql_fetch_assoc($cont_row);

<TR>

<td>

<?php

echo "<font color='#4A2E0F'>"."<b>"."Site Map >".$cont_res["page_title"]."</b>"."<font>"."<br>"."<br>";

echo $cont_res["details"];

?></td>

</TR>

<?php

}

</table> </td>

</tr>

</table> </TD></TR></TBODY></TABLE></TD>

</TR></TBODY></TABLE></TD></TR>

</TR>

<TBODY>

<TR>

<TD vAlign=bottom align=left width=10><IMG height=10

src="index_files/cornerwhite_lower_left.gif" width=10></TD>

</DIV></TD>

<TD vAlign=bottom align=right width=10><IMG height=10

src="index_files/cornerwhite_lower_right.gif"

width=10></TD>

</TR>

</TBODY>

</TABLE></TD>

</TR></TBODY></TABLE></TD>

<TR>

<TD><IMG height=20 src="index_files/downcorner2.gif"

width=21></TD></TR></TBODY></TABLE>

</BODY></HTML>

Output

http://localhost/Admin Panel/admin/

Login page for admin

After successful login

No contents available

Inserting content

After inserting three contents (Home, Contact us and About us)

Changing password of admin

http://localhost/Admin Panel/

After clicking Home link

After clicking Contact Us link

After clicking About Us link

Conclusion

So here we have learned how to create an admin panel in PHP.

Recommended Free Ebook

Printing in C# Made Easy

Download Now!