hi i am new to php and mysql, i am experimenting with a script for saving data to mysql database. and fetch the data on other page, i managed to get both of them without any trouble.
But Here is the one problem. I added a additional input function to save the input data, but other input functions are working except the one i modified.!!
i added the value through phpmyadmin and it works for fetching that data, but can not added value through this script.(see below, i have put down the code)
i am using the latest wampserver.and the modified input is "$compny_name". i wanted to add a field to add company names, but it just dont save the value.
This script is a little big, maybe too big but any help would be appreciate. :(
<?php
session_start();
error_reporting(0);
define('ADMIN_PASS', 'password');
define('MAIN_SCRIPT', basename(__FILE__));
$session_timeout = 3600*24*30;
$mysql_server = 'localhost';
$mysql_username = 'test@localhost';
$mysql_password = '';
$mysql_database = 'test';
$username = 'admin';
$labelHome = 'Home';
$labelName = 'Product Name';
$labelCompanyName = 'Company Name';
$labelCreatedBy = 'Created by';
$labelLastUpdate = 'Last update';
$labelVisible = 'Visible';
$labelHomePage = 'Home page';
$labelViews = 'Views';
$labelOrder = 'Order';
$labelContent = 'Product Description';
$labelURL = 'External URL';
$labelExtraData = 'Supported OS';
$labelTitle = 'Title';
$labelDescription = 'Description';
$labelKeywords = 'Keywords';
$labelAction = 'Action';
$labelNewPage = 'Add a Download';
$labelCaption = 'Content Management System';
$labelLogin = 'Login';
$labelLogout = 'Logout';
$labelEdit = 'Edit';
$labelCopy = 'Copy';
$labelDelete = 'Delete';
$labelYes = 'Yes';
$labelNo = 'No';
$labelSave = 'Save';
$labelCancel = 'Cancel';
$labelUp = 'Up';
$labelDown = 'Down';
$labelOwner = 'Owner';
$labelPlugins = 'Plugins';
$labelUserName = 'Username:';
$labelPassword = 'Password:';
$admin_password = isset($_COOKIE['cmsadmin_pwd']) ? $_COOKIE['cmsadmin_pwd'] : '';
if (empty($admin_password))
{
if (isset($_POST['admin_password']))
{
$admin_password = md5($_POST['admin_password']);
if ($admin_password == md5(ADMIN_PASS))
{
setcookie('cmsadmin_pwd', $admin_password, time() + $session_timeout);
}
}
}
else
if ($admin_password == md5(ADMIN_PASS))
{
setcookie('cmsadmin_pwd', $admin_password, time() + $session_timeout);
}
$authorized = ($admin_password == md5(ADMIN_PASS));
if (!$authorized)
{
if (isset($_SESSION['cms_user']))
{
$authorized = true;
$username = $_SESSION['cms_user'];
}
}
$id = isset($_REQUEST['id']) ? $_REQUEST['id'] : '';
$action = isset($_REQUEST['action']) ? $_REQUEST['action'] : '';
$name = isset($_POST['name']) ? $_POST['name'] : '';
$compny_name = isset($_POST['compny_name']) ? $_POST['compny_name'] : '';
$content = isset($_POST['content']) ? $_POST['content'] : '';
$url = isset($_POST['url']) ? $_POST['url'] : '';
$extra_data = isset($_POST['extra_data']) ? $_POST['extra_data'] : '';
$title = isset($_POST['title']) ? $_POST['title'] : '';
$description = isset($_POST['description']) ? $_POST['description'] : '';
$keywords = isset($_POST['keywords']) ? $_POST['keywords'] : '';
$created_by = isset($_POST['created_by']) ? $_POST['created_by'] : '';
$visible = isset($_POST['visible']) ? $_POST['visible'] : 0;
$timestamp = date("y-m-d H:i:s", time());
$plugins = array();
if (file_exists('./plugins/'))
{
$handle = opendir('./plugins/');
while ($item = readdir($handle))
{
if ($item != "." && $item != ".." && is_dir('./plugins/'.$item) && substr($item, 0, 1) != '_')
{
require_once('./plugins/'.$item.'/plugin.php');
$plugins[$item] = $plugin;
}
}
closedir($handle);
}
$db = mysql_connect($mysql_server, $mysql_username, $mysql_password);
if (!$db)
{
die('Failed to connect to database server!<br>'.mysql_error());
}
mysql_select_db($mysql_database, $db) or die('Failed to select database<br>'.mysql_error());
if ($action == 'login')
{
if (!$authorized && function_exists('usermanager_login'))
{
usermanager_login();
}
$action = '';
}
if ($authorized)
{
if (get_magic_quotes_gpc())
{
$content = stripslashes($content);
$url = stripslashes($url);
$name = stripslashes($name);
$cname = stripslashes($cname);
$extra_data = stripslashes($extra_data);
$title = stripslashes($title);
$description = stripslashes($description);
$keywords = stripslashes($keywords);
$created_by = stripslashes($created_by);
}
$content = mysql_real_escape_string($content);
$url = mysql_real_escape_string($url);
$name = mysql_real_escape_string($name);
$cname = mysql_real_escape_string($cname);
$extra_data = mysql_real_escape_string($extra_data);
$title = mysql_real_escape_string($title);
$description = mysql_real_escape_string($description);
$keywords = mysql_real_escape_string($keywords);
$created_by = mysql_real_escape_string($created_by);
$sql = "CREATE TABLE IF NOT EXISTS CMS_PAGES (id INT UNSIGNED NOT NULL AUTO_INCREMENT,
category_id INT NOT NULL,
name VARCHAR(255) NOT NULL,
content TEXT NOT NULL,
home tinyint(1) NOT NULL,
visible tinyint(1) NOT NULL,
create_date TIMESTAMP NOT NULL,
created_by VARCHAR(255) NOT NULL,
last_update_date TIMESTAMP NOT NULL,
last_update_by VARCHAR(255) NOT NULL,
views INT NOT NULL,
menu_index INT NOT NULL,
url VARCHAR(255),
cname VARCHAR(255),
extra_data VARCHAR(255),
title VARCHAR(100),
description VARCHAR(255),
keywords VARCHAR(255),
seo_friendly_url VARCHAR(100),
PRIMARY KEY(id));";
$result = mysql_query($sql, $db);
if (!$result)
{
die('Invalid query: ' . mysql_error());
}
$sql = "CREATE TABLE IF NOT EXISTS CMS_SEARCH_WORDS (id INT UNSIGNED NOT NULL AUTO_INCREMENT,
word VARCHAR(50) NOT NULL,
PRIMARY KEY (id));";
$result = mysql_query($sql, $db);
if (!$result)
{
die('Invalid query: ' . mysql_error());
}
$sql = "CREATE TABLE IF NOT EXISTS CMS_SEARCH_WORDMATCH (page_id INT UNSIGNED NOT NULL,
word_id INT UNSIGNED NOT NULL,
PRIMARY KEY(page_id, word_id));";
$result = mysql_query($sql, $db);
if (!$result)
{
die('Invalid query: ' . mysql_error());
}
$upgrade = true;
$result = mysql_query("show columns from CMS_PAGES");
while ($data = mysql_fetch_assoc($result))
{
if ($data['Field'] == 'keywords')
{
$upgrade = false;
break;
}
}
if ($upgrade)
{
$sql = "ALTER TABLE CMS_PAGES ADD (title varchar(100),
description varchar(255),
keywords varchar(255),
seo_friendly_url varchar(100));";
$result = mysql_query($sql, $db);
if (!$result)
{
die('Invalid query: ' . mysql_error());
}
}
foreach($plugins as $pluginname=>$p)
{
if (isset($p['admin']['init']))
{
$fn_init = $p['admin']['init']['function'];
$fn_init();
}
}
if (!empty($action))
{
if ($action == 'delete')
{
$menu_index = 0;
$sql = "SELECT * FROM CMS_PAGES WHERE `id` = '$id'";
$result = mysql_query($sql, $db);
if ($data = mysql_fetch_array($result))
{
$menu_index = $data['menu_index'];
}
$sql = "DELETE FROM CMS_PAGES WHERE `id` = '$id'";
mysql_query($sql, $db);
$sql = "DELETE FROM CMS_SEARCH_WORDMATCH WHERE `page_id` = '$id'";
mysql_query($sql, $db);
$sql = "UPDATE CMS_PAGES SET menu_index=menu_index-1 WHERE menu_index > '$menu_index'";
mysql_query($sql, $db);
mysql_close($db);
header('Location: '.basename(__FILE__));
exit;
}
else
if ($action == 'update')
{
$seo_friendly_url = strtolower($title);
$seo_friendly_url = preg_replace("/[^a-z0-9_\s-]/", "", $seo_friendly_url);
$seo_friendly_url = preg_replace("/[\s-]+/", " ", $seo_friendly_url);
$seo_friendly_url = preg_replace("/[\s_]/", "-", $seo_friendly_url);
$sql = "UPDATE CMS_PAGES SET `name` = '$name', `cname` = '$cname', `content` = '$content', `url` = '$url', `extra_data` = '$extra_data', `title` = '$title', `description` = '$description', `keywords` = '$keywords', `seo_friendly_url` = '$seo_friendly_url', `visible` = $visible, `last_update_date` = '$timestamp', ";
if ($username == 'admin' && $created_by != '')
{
$sql .= "`created_by` = '$created_by', ";
}
$sql .= "`last_update_by` = '$username' WHERE `id` = '$id'";
mysql_query($sql, $db);
addToSearchIndex($id, $content);
foreach($plugins as $pluginname=>$p)
{
if (isset($p['admin']['update']))
{
$fn_update = $p['admin']['update']['function'];
$fn_update($id);
}
}
mysql_close($db);
header('Location: '.basename(__FILE__));
exit;
}
else
if ($action == 'create')
{
if ($username != 'admin' || $created_by == '')
{
$created_by = $username;
}
$sql = "SELECT * FROM CMS_PAGES";
$result = mysql_query($sql, $db);
$menu_index = mysql_num_rows($result);
$menu_index = $menu_index + 1;
$sql = "INSERT CMS_PAGES (`category_id`, `name`, `cname`, `content`, `url`, `extra_data`, `title`, `description`, `keywords`, `visible`, `create_date`, `created_by`, `last_update_date`, `last_update_by`, `menu_index`) VALUES (0, '$name', '$cname', '$content', '$url', '$extra_data', '$title', '$description', '$keywords', $visible, '$timestamp', '$created_by', '$timestamp', '$username', $menu_index)";
mysql_query($sql, $db);
$id = mysql_insert_id();
addToSearchIndex($id, $content);
foreach($plugins as $pluginname=>$p)
{
if (isset($p['admin']['update']))
{
$fn_update = $p['admin']['update']['function'];
$fn_update($id);
}
}
mysql_close($db);
header('Location: '.basename(__FILE__));
exit;
}
else
if ($action == 'home')
{
$sql = "UPDATE CMS_PAGES SET `home` = 0";
mysql_query($sql, $db);
$sql = "UPDATE CMS_PAGES SET `home` = 1 WHERE `id` = '$id'";
mysql_query($sql, $db);
mysql_close($db);
header('Location: '.basename(__FILE__));
exit;
}
else
if ($action == 'moveup' || $action == 'movedown')
{
$sql = "SELECT * FROM CMS_PAGES WHERE `id` = '$id'";
$result = mysql_query($sql, $db);
$menu_index = 0;
if ($data = mysql_fetch_array($result))
{
$menu_index = $data['menu_index'];
}
if ($action == 'moveup')
$new_index = $menu_index - 1;
else
$new_index = $menu_index + 1;
$sql = "UPDATE CMS_PAGES SET menu_index = $menu_index WHERE menu_index = '$new_index'";
mysql_query($sql, $db);
$sql = "UPDATE CMS_PAGES SET menu_index = $new_index WHERE id = '$id'";
mysql_query($sql, $db);
mysql_close($db);
header('Location: '.basename(__FILE__));
exit;
}
else
if ($action == 'logout')
{
session_unset();
session_destroy();
setcookie('cmsadmin_pwd', '', time() - 3600);
header('Location: '.basename(__FILE__));
exit;
}
else
{
if (isset($_REQUEST['plugin']))
{
require('./plugins/'.$_REQUEST['plugin'].'/'.$action.'.php');
exit;
}
}
}
}
function addToSearchIndex($page_id, $content)
{
$sql = "DELETE FROM CMS_SEARCH_WORDMATCH WHERE page_id = '$page_id'";
mysql_query($sql);
$content = strtolower(html_entity_decode($content));
$content = preg_replace('/&#?\w+;/', ' ', $content);
if (!get_magic_quotes_runtime())
$content = addslashes($content);
$content = preg_replace('/\s+/', ' ', $content);
$content = strip_tags($content);
$content = preg_replace('/\W+/', ' ', $content);
$words = preg_split('/\s+/', trim($content));
$id_array = array();
$index = 0;
foreach ($words as $word)
{
if (strlen($word) < 2) continue;
if (is_numeric($word)) continue;
$sql = "SELECT id FROM CMS_SEARCH_WORDS WHERE word = '$word';";
$result = mysql_query($sql);
if (!$result)
{
die('Invalid query: ' . mysql_error());
}
$record = mysql_fetch_object($result);
if (!$record || !$word_id = $record->id)
{
$sql = "INSERT INTO CMS_SEARCH_WORDS (word) VALUES ('$word');";
mysql_query($sql);
$word_id = mysql_insert_id();
}
$id_array[$index] = $word_id;
$index++;
}
foreach ($id_array as $word_id)
{
$sql = "INSERT INTO CMS_SEARCH_WORDMATCH (`word_id`, `page_id`) VALUES ('$word_id', '$page_id');";
mysql_query($sql);
}
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Aro Download manager</title>
<link href="../aro.ico" rel="shortcut icon">
<link rel="stylesheet" href="../cmsadmin.css" type="text/css">
<script type="text/javascript" src="../jquery-1.7.2.min.js"></script>
<script type="text/javascript" src="../ckeditor/ckeditor.js"></script>
<script type="text/javascript" src="../ckeditor/adapters/jquery.js"></script>
<script type="text/javascript">
$(document).ready(function()
{
$('#editor').ckeditor({});
$('ul.tabs').each(function()
{
var $active, $content, $links = $(this).find('a');
$active = $($links.filter('[href="'+location.hash+'"]')[0] || $links[0]);
$active.addClass('active');
$content = $($active.attr('href'));
$links.not($active).each(function ()
{
$($(this).attr('href')).hide();
});
$(this).on('click', 'a', function(e)
{
$active.removeClass('active');
$content.hide();
$active = $(this);
$content = $($(this).attr('href'));
$active.addClass('active');
$content.show();
e.preventDefault();
});
});
});
</script>
<style>
p
{
font-size: 11px;
font-family: Verdana;
font-weight: bold;
text-decoration: none;
color: #666666;
}
th
{
font-size: 11px;
font-family: Verdana;
font-weight: bold;
text-decoration: none;
background-color: #21211E;
color: #FFFFFF;
text-align: left;
height:20px;
padding-left:15px;
padding-top:5px;
padding-bottom:5px;
padding-right:5px;
}
a
{
text-decoration:none;
}
a:hover
{
text-decoration: none;
}
body
{
margin: 0;
background-color: black;
background-image: url(../images/welcome_bkgrnd.png);
background-repeat: repeat-x;
color: #000000;
}
</style>
</head>
<body>
<?php
if (!$authorized)
{
echo "<center><div style='position:relative; top:20px; width:700px; padding:10px; height:300px; background:#333; box-shadow:1px 1px 2px #333; text-align:left;'><font color='#939393' face='calibri' size='3em'>Note: enter password and username</font>\n";
echo "<center><div style='position:relative; width:300px; height:150px; top:50px;'><form method=\"post\" action=\"" .basename(__FILE__) . "\" >\n";
echo "<font color='white' face='calibri'><span style='position:absolute; left:0px;'>$labelUserName </span><input type=\"text\" class='signupform_text' style='position:absolute; right:0px;' name=\"admin_username\" size=\"20\"><br><br>\n";
echo "<span style='position:absolute; left:0px;'>$labelPassword </span><input type=\"password\" class='signupform_text' name=\"admin_password\" style='position:absolute; right:0px;' size=\"20\"></font><br><br>\n";
echo "<input type=\"submit\" class='g-button g-button-submit' value=\"$labelLogin\" style='width:100px;position:absolute; right:0px;' name=\"submit\">\n";
echo "<input type=\"hidden\" name=\"action\" value=\"login\" >\n";
echo "</form>\n";
echo "</div></center></div></center>\n";
}
else
{
echo "<div id=\"nav\" style='position:relative; top:0px; left:0px; height:30px;margin:0px; background:#333;'>\n";
echo "<div style='position:relative; left:0px top:0px; padding10px; margin:0px;'>\n";
echo " <li><a href=\"" . basename(__FILE__) . "\">$labelHome</a></li>\n";
echo " <li><a href=\"" . basename(__FILE__) . "?action=new\">$labelNewPage</a></li>\n";
if (sizeof($plugins) > 0)
{
echo " <li><a>$labelPlugins</a>\n";
echo " <ul>\n";
foreach($plugins as $pluginname=>$p)
{
if (isset($p['admin']['menu']))
{
foreach ($p['admin']['menu'] as $text=>$page)
{
echo " <li><a href=\"cmsadmin_plugin.php?_plugin=".$pluginname."&_page=".$page."\">".$text."</a></li>\n";
}
}
}
echo " </ul>\n";
echo " </li>\n";
}
echo " <li style='position:absolute; right:0px; '><a href=\"" . basename(__FILE__) . "?action=logout\">$labelLogout from download manager</a></li>\n";
echo "</div></div>\n";
if (!empty($action))
{
if ($action == 'edit' || $action == 'new' || $action == 'copy')
{
$sql = "SELECT * FROM CMS_PAGES WHERE id = '".$id."'";
$result = mysql_query($sql, $db);
$name_value = '';
$cname_value = '';
$content_value = '';
$visible_value = '';
$url_value = '';
$extra_data_value = '';
$title_value = '';
$description_value = '';
$keywords_value = '';
$created_by_value = '';
if ($data = mysql_fetch_array($result))
{
$name_value = htmlspecialchars($data['name']);
$cname_value = htmlspecialchars($data['cname']);
$content_value = $data['content'];
$visible_value = $data['visible'];
$url_value = htmlspecialchars($data['url']);
$extra_data_value = htmlspecialchars($data['extra_data']);
$title_value = htmlspecialchars($data['title']);
$description_value = htmlspecialchars($data['description']);
$keywords_value = htmlspecialchars($data['keywords']);
$created_by_value = htmlspecialchars($data['created_by']);
}
$extra_tabs = array();
foreach($plugins as $pluginname=>$p)
{
if (isset($p['admin']['tab']))
{
$extra_tabs[$p['admin']['tab']['name']] = $p['admin']['tab']['function'];
}
}
echo "<form action=\"" . basename(__FILE__) . "\" method=\"post\">\n";
echo "<div class=\"tab\" id=\"tab-general\">\n";
if ($action == 'new' || $action == 'copy')
{
echo "<input type=\"hidden\" name=\"action\" value=\"create\">\n";
}
else
{
echo "<input type=\"hidden\" name=\"action\" value=\"update\">\n";
}
echo "<input type=\"hidden\" name=\"id\" value=\"". $id . "\">\n";
echo "<table width=\"100%\" border=\"0\">\n";
echo "<tr><td style=\"width:10%;white-space:nowrap;\">$labelName:</td>\n";
echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"name\" value=\"" . $name_value . "\"></td></tr>\n";
echo "<tr><td style=\"width:10%;white-space:nowrap;\">$labelCompanyName:</td>\n";
echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"cname\" value=\"" . $cname_value . "\"></td></tr>\n";
echo "<tr><td>$labelContent:</td>\n";
echo "<td><textarea id=\"editor\" style=\"width:100%;height:500px\" name=\"content\">" . $content_value . "</textarea></td></tr>\n";
echo "<tr><td>$labelURL:</td>\n";
echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"url\" value=\"" . $url_value . "\"></td></tr>\n";
echo "<tr><td>$labelExtraData:</td>\n";
echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"extra_data\" value=\"" . $extra_data_value . "\"></td></tr>\n";
echo "<tr><td>$labelTitle:</td>\n";
echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"title\" value=\"" . $title_value . "\"></td></tr>\n";
echo "<tr><td>$labelDescription:</td>\n";
echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"description\" value=\"" . $description_value . "\"></td></tr>\n";
echo "<tr><td>$labelKeywords:</td>\n";
echo "<td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"keywords\" value=\"" . $keywords_value . "\"></td></tr>\n";
echo "<tr><td>$labelVisible:</td>\n";
echo "<td><select name=\"visible\" size=\"1\"><option " . ($visible_value == "0" ? "selected " : "") . "value=\"0\">Hidden</option><option " . ($visible_value != "0" ? "selected " : "") . "value=\"1\">Visible</option></select></td></tr>\n";
if ($username == 'admin')
{
echo "<tr><td>$labelOwner:</td><td><input type=\"text\" style=\"width:80%;\" class='signupform_text' name=\"created_by\" value=\"" . $created_by_value . "\"></td></tr>\n";
}
echo "</table>\n";
echo "</div>\n";
foreach($extra_tabs as $name=>$fn)
{
echo "<div class=\"tab\" id=\"tab-".preg_replace('/[^a-z0-9A-Z]/', '', $name)."\">\n";
echo $fn();
echo "</div>\n";
}
echo "<br><br><input style=\"position:absolute; right:10px;margin-bottom:50px;width:100px;\" type=\"submit\" class='g-button g-button-submit' name=\"save\" value=\"$labelSave\"><br><br>\n";
echo "</form>\n";
}
}
else
{
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"2\">\n";
echo "<tr><th>$labelName</th>\n";
echo "<th>$labelCreatedBy</th>\n";
echo "<th>$labelLastUpdate</th>\n";
echo "<th>$labelVisible</th>\n";
echo "<th>$labelHomePage</th>\n";
echo "<th>$labelViews</th>\n";
echo "<th>$labelOrder</th>\n";
echo "<th>$labelAction</th></tr>\n";
$sql = "SELECT * FROM CMS_PAGES";
if ($username != 'admin')
{
$sql = $sql . " WHERE created_by = '".$username."'";
}
$sql = $sql . " ORDER BY menu_index ASC";
$result = mysql_query($sql, $db);
$num_rows = mysql_num_rows($result);
while ($data = mysql_fetch_array($result))
{
echo "<tr class='infoadmin'>\n";
echo "<td><a href=\"store.php" . "?page=" . $data['seo_friendly_url'] . "\" id=\"" . $data['id'] . "\" target='new'>" . $data['name'] . "</a></td>\n";
echo "<td>" . $data['created_by'] . "</td>\n";
echo "<td>" . $data['last_update_date'] . "</td>\n";
echo "<td>" . ($data['visible'] == "0" ? $labelNo : $labelYes) . "</td>\n";
echo "<td>";
if ($data['home'] == "1")
echo $labelYes;
else
echo " <a href=\"" . basename(__FILE__) . "?action=home&id=" . $data['id'] . "\">$labelNo</a>";
echo "</td>\n";
echo "<td>" . $data['views'] . "</td>\n";
echo "<td>";
if ($data['menu_index'] <= 1)
{
echo " <a href=\"" . basename(__FILE__) . "?action=movedown&id=" . $data['id'] . "\">$labelDown</a>";
}
elseif ($data['menu_index'] >= $num_rows)
{
echo " <a href=\"" . basename(__FILE__) . "?action=moveup&id=" . $data['id'] . "\">$labelUp</a>";
}
else
{
echo " <a href=\"" . basename(__FILE__) . "?action=moveup&id=" . $data['id'] . "\">$labelUp</a> ";
echo " <a href=\"" . basename(__FILE__) . "?action=movedown&id=" . $data['id'] . "\">$labelDown</a>";
}
echo "</td>\n";
echo "<td>\n";
echo " <a href=\"" . basename(__FILE__) . "?action=edit&id=" . $data['id'] . "\">$labelEdit</a> | \n";
echo " <a href=\"" . basename(__FILE__) . "?action=copy&id=" . $data['id'] . "\">$labelCopy</a> | \n";
echo " <a href=\"" . basename(__FILE__) . "?action=delete&id=" . $data['id'] . "\">$labelDelete</a>\n";
echo "</td>\n";
echo "</tr>\n";
}
echo "</table>\n";
}
}
?>
</body>
</html>
