Expand|Select|Wrap|Line Numbers
- <?php
- session_start();
- require_once('db.php');
- include('functions.php');
- $user = get_username ( $_SESSION['user_id'] );
- //if ( $_SESSION['logged_in'] ):
- checkLogin ( '1 2' );
- ?>
- <html>
- <title>Manage Articles </title>
- <head><link href="css/styles.css" rel="stylesheet" type="text/css" /></head>
- <body>
- <?php
- if($_REQUEST['action']=="edit")
- {
- mysql_query("UPDATE articles SET status = '0' WHERE id={$_REQUEST['id']};");
- }
- if($_REQUEST['action']=="read")
- {
- $s = mysql_query("SELECT * FROM articles where id={$_REQUEST['id']};");
- $a = 0;
- while( $article = mysql_fetch_array($s) )
- {
- echo "<b> Article Details </b></br></br></br>";
- echo "<i>Title </i>:: ".$article['title']."</br></br>";
- echo "<i>Keyword</i> :: ".$article['keyword']." </br></br>";
- echo "<i>Body</i> :: ".$article['body']." </br></br>";
- echo "<i>Submitted By</i> :: ".$article['user']." </br></br>";
- echo "<i>Submitted On</i> :: ".$article['date']." </br></br></br>";
- echo "<hr>";
- $a++;
- }
- }
- if($_REQUEST['action']=="del")
- {
- mysql_query("DELETE FROM articles WHERE id={$_REQUEST['id']};");
- }
- if($_REQUEST['action']=="activate")
- {
- mysql_query("UPDATE articles SET status = '1' WHERE id={$_REQUEST['id']};");
- }
- $result=mysql_query("SELECT * FROM articles where status = 0 and user = \"$user\" order by id;");
- $i=0;
- echo "<table border = 1 class = border1>";
- echo "<tr><a><b>Inactive Articles</b></a></tr>";
- echo "<td>Title</td>";
- echo "<td>Submitted By</td>";
- echo "<td>Date</td>";
- echo "<td></td>";
- echo "<td></td>";
- echo "<td></td></tr>";
- while( $row = mysql_fetch_array($result) )
- {
- echo "<td>".$row['title']."</td>";
- //echo "<td >".$row['keyword']." </td>";
- //echo "<td >".$row['body']." </td>";
- echo "<td >".$row['user']." </td>";
- echo "<td >".$row['date']." </td>";
- echo "<td><a onclick=\"return confirm('Are you sure ?');\" href=manage_articles.php?action=del&id=".$row['id']."><span class=red>Delete</span></a></td>";
- echo "<td><a onclick=\"return confirm('Are you sure ?');\" href=manage_articles.php?action=activate&id=".$row['id']."><span class=red>Edit</span></a></td>";
- echo "<td><a onclick=\"return confirm('Are you sure ?');\" href=manage_articles.php?action=read&id=".$row['id']."><span class=red>Read</span></a></td></tr>";
- //echo "<td class=tabval></td>";
- //echo "</tr>";
- $i++;
- }
- echo "</table>";
- ?>
- <?php
- $result=mysql_query("SELECT * FROM articles where status = 1 and user = \"$user\" order by id;");
- $i=0;
- echo "</br></br></br>";
- echo "<hr>";
- echo "<table border = 1>";
- echo "</br>";
- echo "<tr><a ><b>Active Articles</b></a></tr>";
- echo "<td>Title</td>";
- echo "<td>Submitted By</td>";
- echo "<td>Date</td>";
- echo "<td></td>";
- echo "<td></td>";
- echo "</tr>";
- while( $row = mysql_fetch_array($result) )
- {
- echo "<td>".$row['title']."</td>";
- //echo "<td >".$row['keyword']." </td>";
- //echo "<td >".$row['body']." </td>";
- echo "<td >".$row['user']." </td>";
- echo "<td >".$row['date']." </td>";
- echo "<td><a onclick=\"return confirm('Are you sure ?');\" href=manage_articles.php?action=del&id=".$row['id']."><span class=red>Delete</span></a></td>";
- //echo "<td><a onclick=\"return confirm('Are you sure ?');\" href=manage_article.php?action=suspend&id=".$row['id']."><span class=red>Suspend</span></a></td>";
- echo "<td><a onclick=\"return confirm('Are you sure ?');\" href=manage_articles.php?action=read&id=".$row['id']."><span class=red>Read</span></a></td></tr>";
- //echo "<td class=tabval></td>";
- //echo "</tr>";
- $i++;
- }
- ?>
- </table>
- </body>
- </html>
Why is it ?
Expand|Select|Wrap|Line Numbers
- <table>
- <?php if($_REQUEST['action']=="view")
- {//{$_REQUEST['id']};
- $s = mysql_query("select * from cards where card={$_REQUEST['card']}");
- $a = 0;
- while( $article = mysql_fetch_array($s) )
- {
- //$sql10=mysql_query("select * from cards where card={$_REQUEST['card']};")or die("<h5 align=center>Could Not Find the Table named cards</h5>") ;
- // while($rs10=mysql_fetch_array($sql10))
- // {
- echo"<tr><embed src='./_cards/".$article['card']."' border=0 width=500 height=400 type='application/x-shockwave-flash'></embed></tr>";
- $a++;
- }
- }
- ?> <?php if($_REQUEST['action']=="show")
- {print"<a class='titlegreen'>Birthday Cards </a></br></br>";
- print"<tr>";
- $sql=mysql_query("select * from cards where type = 'Birthday' ") or die("<h5 align=center>Could Not Find the Table named cards</h5>");
- while($rs=mysql_fetch_array($sql))
- {
- print"<td>";
- print"<table>";
- print"<tr><a href= index.php?action=view&card=".$rs['card']."><img src='./_cards/".$rs["thumbnail"]."' width=60 height=50 border=0></a></tr>";
- echo "<tr class='bodyblue' align='center'><div align='center'>";
- echo $rs['name'];
- echo"</div>";
- print"</tr>";
- print"</table>";
- print"</td>";
- }
- print"</tr>";
- }
Plese help i keep gettin this kinda prblms