<?php
require_once "db.php";
$request_id = $_REQUEST['id'];
if (!$page){
echo"<br><br>What would you like to do? <br> <br>
<a href='?page=view-all'>View all affiliates</a><br>
<a href='?page=add-new'>Add new affiliate</a><br>";}
if ($page == edit && $id == $request_id){
$result = mysql_query("SELECT * FROM affiliates WHERE id='$request_id'");
while($row = mysql_fetch_array($result)){
echo "
<form page='?page=edit&id=".$row['id']."' method='post' name='form1'>
<strong>ID:</strong>".$row['id']."<br>
<strong>Name:</strong>
<input name='name' type='text' id='name' value='".$row['name']."' size='50'/>
<br>
<strong>Link:
<input name='link' type='text' id='link' value='".$row['link']."' size='50'/>
<br>
Image:
<input name='image' type='text' id='image' value='".$row['image']."' size='50'/>
<br>
Views:</strong> ".$row['views']." <br>
<input name='submit' type='submit' id='submit' value='Edit'>
</form>";}
if ($_POST['submit']){
$name = $_POST['name'];
$link = $_POST['link'];
$image = $_POST['image'];
mysql_query("UPDATE affiliates SET name='$name' WHERE id='$request_id'");
mysql_query("UPDATE affiliates SET link='$link' WHERE id='$request_id'");
mysql_query("UPDATE affiliates SET image='$image' WHERE id='$request_id'");
echo "<strong>Thanks, your information has been updated.</strong> <br><br>What would you like to do? <br> <br>
<a href='?page=view-all'>View all affiliates</a><br>
<a href='?page=add-new'>Add new affiliate</a><br>";
}}
if ($page == delete && $id == $request_id){
$result = mysql_query("SELECT * FROM affiliates WHERE id='$request_id'");
while($row = mysql_fetch_array($result)){
echo "
<form page='?page=delete&id=".$row['id']."' method='post' name='form1'>
Are you sure you want to delete the affiliate: <a href='".$row['link']."' target='blank'>".$row['name']."</a> ?
<br>
<input name='yes' type='checkbox' id='yes' value='checkbox'>
Yes<br>
<input name='no' type='checkbox' id='no' value='checkbox'>
No
<br>
<input name='submit' type='submit' id='submit' value='Submit'>
</form>";}
if ($_POST['submit']){
if ($_POST['yes'] && $_POST['no']){
die('Error! : Are you trying to confuse me?');}
if ($_POST['yes']){
$result = mysql_query("SELECT * FROM affiliates WHERE id='$request_id'");
while($row = mysql_fetch_array($result)){
mysql_query("DELETE FROM affiliates WHERE id='$request_id'");
echo "Thanks, the affiliate <strong>".$row['name'].".</strong> has been deleted. <a href='?'>Click here</a> to continue.";}}
if ($_POST['no']){
die('<a href="?">Click here</a> to continue.');}
if (!$_POST['yes'] || !$_POST['no']){
die('Oops, you forgot to respond to my question.');}
}}
if ($page == "add-new"){
echo "
<form page='?page=add-new' method='post' enctype='multipart/form-data' name='form1'>
<strong> Name:
<input name='name' type='text' id='name' size='50'>
<br>
Link:
<input name='link' type='text' id='link' size='50'>
<br>
Image:</strong>
<input name='image' type='text' id='image' size='50' value='http://' >
<br>
<input name='submit' type='submit' id='submit' value='Submit'>
<input name='reset' type='reset' id='reset' value='Reset'>
</form>";
if ($_POST['submit']){
if (!$_POST['name'] || !$_POST['link'] || !$_POST['image']){
die('Sorry, but there is a field that is left blank.');}
$link = $_POST['link'];
$name = $_POST['name'];
$image = $_POST['image'];
echo "Success!<br><br>What would you like to do? <br> <br>
<a href='?page=view-all'>View all affiliates</a><br>
<a href='?page=add-new'>Add new affiliate</a><br>";
mysql_query("INSERT INTO affiliates(id,views,name,link,image) VALUES('','','$name','$link','$image')");
}}
if ($page == "view-all"){
echo"
<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr>
<td><div align='center'><strong>ID</strong></div></td>
<td><div align='center'><strong>Name</strong></div></td>
<td><div align='center'><strong>Image</strong></div></td>
<td><div align='center'><strong>Link</strong></div></td>
<td><div align='center'><strong>Views</strong></div></td>
<td><div align='center'><strong>Other</strong></div></td>
</tr>";
$result = mysql_query("SELECT * FROM affiliates ORDER BY id");
while($row = mysql_fetch_array($result)){
echo "
<tr>
<td><br><div align='center'>".$row['id']."</div></td>
<td><br><div align='center'>".$row['name']."</div></td>
<td><br><div align='center'><img src='".$row['image']."' width='88' height='31'></div></td>
<td><br><div align='center'><a href='".$row['link']."' target='blank'><font color='#0000CC' size='3'>".$row['link']."</font></a></div></td>
<td><br><div align='center'>".$row['views']."</div></td>
<td><br><div align='center'><a href='?page=edit&id=".$row['id']."'><font color='#0000CC' size='3'>Edit</font></a> // <a href='?page=delete&id=".$row['id']."'><font color='#FF0000' size='3'>Delete</font></a></div></td>
</tr>";}
echo"</table>";}
?>
