Code is Here
Kindly Help m
***** PLEASE USE PHP/CODE TAGS *****
Code: Select all
<?
function pagination($query)
{
// Obtain The Required Page NO
if (isset($_GET['pageno'])) {
$pageno = $_GET['pageno'];
} else {
$pageno = 1;
}
$numrows=mysql_num_rows(mysql_query($query));
// Calculate The Number Of Last Page
$rows_per_page = 3;
$lastpage = ceil($numrows/$rows_per_page);
$_SESSION['lastpage']=$lastpage;
$pageno = (int)$pageno;
if ($pageno < 1) {
$pageno = 1;
}
elseif ($pageno > $lastpage) {
$pageno = $lastpage;
}
//Construction Limit Clause
$limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page;
return $limit;
}
if(isset($_POST['action']) || $_POST['actress_name']!="")
{
$aname=$_POST["actress_name"];
$query="select * FROM stars s LEFT OUTER JOIN images i ON s.Star_ID = i.Star_ID where s.First_Name like '%$aname%' ";
$_SESSION['query']=$query;
$limit=pagination($query);
}
else if(isset($_SESSION['query']) && $_GET['value']=="searchActress")
{
$query=$_SESSION['query'];
$limit=pagination($query);
}
else
{
$query="SELECT * FROM stars s LEFT OUTER JOIN images i On s.Star_ID=i.Star_ID WHERE i.status='Main'";
$limit=pagination($query);
}
$result=mysql_query($query.$limit);
?>
<script language="javascript">
function makeSure(id)
{
var conf=confirm("Are you sure you want to delete this Actress?");
if(conf)
{
var link="deleteActress.php?id="+id;
document.location.href=link;
}
else
return false;
}
</script>
<table width='100%' align='center' cellspacing="5" cellpadding="5">
<tr>
<td class="heading1" colspan="4" align="center">
<span class="heading">Hollywood Stars Biography</span>
</td>
</tr>
<tr>
<td class="heading1" colspan="4" align="center">
<? include("searchActress.php")?>
</td>
</tr>
<tr>
<td colspan="4" align="center">
<?
echo "<table border='0' align='center'>";
echo "<tr>";
for ($i=1; $i<=$_SESSION['lastpage']; $i++)
{
if($_GET['value']=="searchActress" )
{
echo "<td>";
echo "<a href='controlPanel.php?pageno=$i&value=searchActress' class='paginationLink'>".$i."</a>";
echo "</td>";
}
else if($_GET['value']=="viewActress")
{
echo "<td>";
echo "<a href='controlPanel.php?pageno=$i&value=viewActress' class='paginationLink'>".$i."</a>";
echo "</td>";
}
}
echo "</tr></table>";
?>
</td>
</tr>
<tr>
<td colspan="4" align="center">
<?
if($_GET[msg]=="added")
{
echo "<center><span class='confirmation'>Actress was successfully Added</span></center>";
}
else if($_GET[msg]=="deleted")
{
echo "<center><span class='confirmation'>Actress was successfully Deleted</span></center>";
}
else if($_GET[msg]=="edited")
{
echo "<center><span class='confirmation'>Actress was successfully Updated</span></center>";
}
?>
</br></br>
</td>
</tr>
<?
while($row = mysql_fetch_array($result))
{
?>
<tr>
<td align="center" valign="middle" width="20%" >
<a href='controlPanel.php?id=<?=$row[Star_ID]?>&value=editActress' class='pictureLink'><img src="<?=$row['Path'] ?>" width="100" height="100" border="0"></a>
</td>
<td align="left" valign="middle" width="30%" >
<a href='editActress.php?id=<?=$row[Star_ID] ?>' class='textLink'>First Name:<? echo $row['First_Name']; ?></a>
<br/>
<span class="textDetail">Last Name:<? echo $row['Last_Name']; ?></span>
<br/>
<span class="textDetail">Date Of Birth:<? echo $row['DOB']; ?></span>
<br/>
<span class="textDetail">Place Of Birth:<? echo $row['POB']; ?></span>
<br/>
<span class="textDetail">Father Name:<? echo $row['Father_Name']; ?></span>
<br/>
<span class="textDetail">Mother Name:<? echo $row['Mother_Name']; ?></span>
<br/>
<span class="textDetail">Height:<? echo $row['Height']; ?></span>
<br/>
</td>
<td align="left" valign="middle" width="25%">
<? echo "<a href='controlPanel.php?value=editActress&id=$row[Star_ID]'><img src='./MenuImages/Edit.jpg' border='0'></a>" ?>
</td>
<td align="left" valign="middle" width="25%">
<? echo "<a href='javascript::void(0);' onclick=\"makeSure($row[Star_ID]);\"><img src='./MenuImages/Delete.jpg' border='0'</a>" ?> </td>
</tr>
<tr>
<td colspan="4" align="left">
<span class="textDesc"><? echo $row['Extra']; ?></span>
<hr></hr>
</td>
</tr>
<? } ?>
<tr>
<td colspan="4" align="center">
<?
echo "<table border='0' align='center'>";
echo "<tr>";
for ($i=1; $i<=$lastpage; $i++)
{
echo "<td bgcolor='#33CCFF'>";
if($_GET['value']=="searchActress" )
{
$aname=$_GET["actress_name"];
echo "<a href='controlPanel.php?pageno=$i&value=searchActress' class='paginationLink'><strong>".$i."</strong></a>";
echo "</td>";
}
else if($_GET['value']=="viewActress")
{
echo "<td bgcolor='#33CCFF'>";
echo "<a href='controlPanel.php?pageno=$i&value=viewActress' class='paginationLink'><strong>".$i."</strong></a>";
echo "</td>";
}
}
echo "</tr></table>";
?>
</td>
</tr>
<tr>
<td colspan="4" align="center">
<?
echo "<table border='0' align='center'>";
echo "<tr>";
for ($i=1; $i<=$_SESSION['lastpage']; $i++)
{
if($_GET['value']=="searchActress" )
{
echo "<td>";
echo "<a href='controlPanel.php?pageno=$i&value=searchActress' class='paginationLink'>".$i."</a>";
echo "</td>";
}
else if($_GET['value']=="viewActress")
{
echo "<td>";
echo "<a href='controlPanel.php?pageno=$i&value=viewActress' class='paginationLink'>".$i."</a>";
echo "</td>";
}
}
echo "</tr></table>";
?>
</td>
</tr>
</table>