Привет, всем! Вот я спрашивала в теме о редактирование таблиц БД, решила пойти своим путём.
Не давно мне попался скрипт администрирования списка вакансий, вот его-то я и заиспользовала.
Но не вышло.. всё равно ошибки в скрипте. Поможите чем можете.  Вот мой код, который сама переделывала.| Код |
<?php
require_once('function.php');
print_tovar_admin_links();
if (isset($_POST['submit_add'])) process_add_data();
if (isset($_POST['delete_tovar'])) delete_tovar();
if (isset($_POST['edit_tovar'])) display_edit_form();
if (isset($_POST['update_tovar'])) update_tovarData();
if (isset($_GET['type'])){
$type=addslashes($_GET['type']);
if ($type==1) display_edit_form();
}
else if (!isset($_POST['edit_tovar'])){
print_tovar_list();
}
function display_edit_form(){
$sql = 'SELECT * FROM tovar WHERE id_tovara='.$_POST['id_t'];
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
echo '<form action="edit_tovar.php" method="post">';
echo '<input type="hidden" name="id_t" value="'.$_POST['id_t'].'">';
echo '<textarea name="cat_tovara" value="'.$_POST['cat_tovara'].'"></textarea>';
echo '<textarea name="brend" value="'.$_POST['brend'].'"></textarea>';
echo '<textarea name="type_tovara" value="'.$_POST['type_tovara'].'"></textarea>';
echo '<textarea name="description" value="'.$_POST['description'].'"></textarea>';
echo '<textarea name="file_name" value="'.$_POST['filename'].'"></textarea>';
echo '<textarea name="cena_tovara" value="'.$_POST['cena_tovara'].'"></textarea>';
echo '<input type="submit" name="update_tovar" value="Save"></form>';
}
function update_tovarData(){
$id_t = addslashes($_POST['id_t']);
$cat_tovara = addslashes($_POST['cat_tovara']);
$brend = addslashes($_POST['brend']);
$type_tovara = addslashes($_POST['type_tovara']);
$description = addslashes($_POST['description']);
$file_name = addslashes($_POST['file_name']);
$cena_tovara = addslashes($_POST['cena_tovara']);
$sql = 'UPDATE tovar SET id_tovara="'.$id_t.'", cat_tovara="'.$cat_tovara.'", brend="'.$brend.'" type_tovara="'.$type_tovara.'", description="'.$description.'", file_name="'.$file_name.'", cena_tovara="'.$cena_tovara.'"';
$result = mysql_query($sql) or die($sql);
}
function delete_tovar(){
$sql = 'DELETE FROM tovar WHERE id_tovara='.$_POST['id_tovara'].'';
$result = mysql_query($sql);
}
function print_tovar_list(){
$sql = 'SELECT * FROM tovar ORDER BY id_tovara DESC';
$result = mysql_query($sql);
echo '<TABLE border="1">';
while ($row = mysql_fetch_assoc($result)){
echo '<tr>';
echo '<td valign="top">'.$row['id_tovara'].'</td>';
echo '<td valign="top">'.$row['cat_tovara'].'</td>';
echo '<td valign="top">'.$row['brend'].'</td>';
echo '<td valign="top">'.$row['type_tovara'].'</td>';
echo '<td valign="top">'.$row['description'].'</td>';
echo '<td valign="top">'.$row['file_name'].'</td>';//add image folder path
echo '<td valign="top">'.$row['description'].'</td>';
echo '<td valign="top">'.$row['cena_tovara'].' ???.</td>';
echo '<td valign="top">';
echo '<form acton="edit_tovar.php" method="POST"><input type="hidden" name="id_t" value="'.$row['id_tovara'].'"><input type="button" name="edit_tovar" value="Edit"><input type="button" name="delete_tovar" value="Delele"></form>';
echo '</td>';
echo '</tr>';
}
echo '</TABLE>';
}
function print_tovar_admin_links(){
if (isset($_GET['type'])) $type=addslashes($_GET['type']);
if (!isset($type) or $type!=1) echo '<a href="'.$_SERVER['PHP_SELF'].'?type=1">???????? ?????</a><br>';
if (isset($type)) echo '<a class="blacklink" href="'.$_SERVER['PHP_SELF'].'">?????? ???????</a><br>';
}
function process_add_data(){
//$id_t = addslashes($_POST['id_t']);
$cat_tovara = addslashes($_POST['cat_tovara']);
$brend = addslashes($_POST['brend']);
$type_tovara = addslashes($_POST['type_tovara']);
$description = addslashes($_POST['description']);
$file_name = addslashes($_POST['file_name']);
$cena_tovara = addslashes($_POST['cena_tovara']);
$sql = 'INSERT INTO tovar (cat_tovara, brend, type_tovara, description, file_name, cena_tovara) VALUES("'.$cat_tovara.'", "'.$brend.'", "'.$type_tovara.'","'.$description.'","'.$file_name.'","'.$cena_tovara.'",)';
$result = mysql_query($sql) or die($sql);
}
function add_tovar_form(){
echo '<form action="edit_tovar.php" method="post">';
echo '<pre>';
print_r($_POST);
echo '<textarea name="cat_tovara"></textarea>';
echo '<textarea name="brend"></textarea>';
echo '<textarea name="type_tovara"></textarea>';
echo '<textarea name="description"></textarea>';
echo '<textarea name="file_name"</textarea>';
echo '<textarea name="cena_tovara"</textarea>';
echo '<input type="submit" name="submit_add" value="????????">';
echo '</form>';
}
?>
|
Вот типа БД.| Код |
CREATE TABLE `tovar` (
`id_tovata` int(11) NOT NULL default '0',
`cat_tovata` varchar(60) NOT NULL default '',
`brend` varchar(60) NOT NULL default '',
`type_tovara` varchar(60) NOT NULL default '',
`description` varchar(60) NOT NULL default '',
`file_name` varchar(60) NOT NULL default '',
`cena_tovara` varchar(60) NOT NULL default '',
PRIMARY KEY (`id_tovara`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
|
|
