Help
Search
Login
Register
Home
Forum: web design and graphics community
Celestial Star Forum
>
Web Development
>
Coding
>
Problem with submitting
Pages: [
1
]
« previous
next »
Print
Author
Topic: Problem with submitting (Read 446 times)
Vlad
Incubus
Posts: 60
Problem with submitting
«
on:
June 10, 2008, 03:23:56 PM »
When submitting delete button (name = delete), it does not delete marked rows from data base.
Code:
<?
$query2 = "SELECT * FROM test WHERE (stat = 'Ученик' OR stat = 'Префект') AND points = '0' ORDER by faculty";
$result2 = mysql_query($query2) or die ("ERROR: $query2.".mysql_error());
if (mysql_num_rows($result2) > 0) {
// yes
// print them one after another
echo "<p><b>Списки учеников </b><br>
<form method=\"post\" action=\"user_del.php\">
<table id=\"journal\">
<tr>
<td><b>Имя</b></td>
<td><b>Факультет</b></td>
<td><b>Курс</b></td>
<td><b>Баллы</b></td>
<td><b>Дата регистрации</b></td>
<td><b>Удалить?</b></td>
</tr>";
$num = $start;
$classnames = array(
"Префект" => "prf",
"Ученик" => "stu",
);
while($row2 = mysql_fetch_assoc($result2)) {
echo "<tr class='" . $classnames[$row2['stat']] . "'>";
echo " <td><a href=\"javascript:void(0);\" onClick=\"openwin('inform.php?id=".$row2['id']."');return false\">".$row2['nick']."</a></td>";
echo " <td>".$row2['faculty']."</td>";
echo " <td>".$row2['course']."</td>";
echo " <td>".$row2['points']."</td>";
echo " <td>".$row2['date']."</td>";
echo " <td><input type=\"checkbox\" name=\"id\" value=\"".$row2['id']."\" /></td>";
echo "</tr>";
}
echo "</table>";
echo "<input type=\"submit\" name=\"submit\" value=\"Отправить предупреждение\"> <input type=\"submit\" name=\"delete\" value=\"Удалить\">
Вернуться в <a href=\"menu.php\">главное меню</a></div>";
echo "</form></p>";
}
else {
echo '<div id="contenido"><center>Учеников с количеством баллов > 0 нет!<br>Вернуться в <a href=menu.php>глваное меню</a></center></div>';
}?>
user_del.php
Code:
<?php
include(
'connection.php'
);
$id
= (isset(
$_POST
[
'id'
])) ?
$_POST
[
'id'
] :
''
;
if (isset(
$_POST
[
'submit'
])) {
$querysub
=
"SELECT * FROM test WHERE id='$id'"
;
$resultsub
=
mysql_query
(
$querysub
) or die(
"ERROR: $query."
.
mysql_error
());
$row2
=
mysql_fetch_assoc
(
$resultsub
);
$passward
=
$row2
[
'passward'
];
$name
=
$row2
[
'nick'
];
$faculta
=
$row2
[
'faculty'
];
$email
=
$row2
[
'email'
];
include(
'emails/sending_details4.php'
);
mail
(
$email
,
$subject
,
$message
,
$headers
);
} elseif (isset(
$POST
[
'delete'
])) {
$querysub
=
"SELECT email, nick, faculty FROM test WHERE id='$id'"
;
$resultsub
=
mysql_query
(
$querysub
) or die(
"ERROR: $query."
.
mysql_error
());
$row2
=
mysql_fetch_assoc
(
$resultsub
);
$name
=
$row2
[
'nick'
];
$faculta
=
$row2
[
'faculty'
];
$email
=
$row2
[
'email'
];
include(
'emails/sending_details5.php'
);
mail
(
$email
,
$subject
,
$message
,
$headers
);
mysql_query
(
"DELETE FROM test WHERE id=$id LIMIT 1"
);
if (
$faculta
==
'Элквуд'
) {
mysql_query
(
"DELETE FROM ElwUsers WHERE `Name`='$name'"
);
} elseif (
$faculta
==
'Аквилмар'
) {
mysql_query
(
"DELETE FROM AqmUsers WHERE `Name`='$name'"
);
} elseif (
$faculta
==
'Фокстейн'
) {
mysql_query
(
"DELETE FROM FxtUsers WHERE `Name`='$name'"
);
}
}
mysql_close
(
$connection
);
// print success message
include (
'header.php'
);
echo
"<center><div id=\"contenido\">Заклинание сработало<br><br><a href=\"menu.php\">Вернуться в главное меню</a><br />Вернуться к <a href=\"delete.php\">удалению<a/></div></center>"
;
include (
'footer.php'
);
?>
Could somebody help me?
Logged
Pages: [
1
]
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General
-----------------------------
=> General
=> New Members
=> Announcements
=> Support / Suggestions
-----------------------------
Contests
-----------------------------
=> Archive
===> Contests
===> Blend Challenges
===> SOTW
-----------------------------
Art Boards
-----------------------------
=> Creative mediums
=> Requests & offers
=> Tutorials
===> Celestial Star Tutorials
-----------------------------
Web Development
-----------------------------
=> Coding
=> Web Design
=> Advertisements / Affiliation
-----------------------------
Off-topic
-----------------------------
=> Entertainment
-----------------------------
Español (Spanish Only)
-----------------------------
=> General / Bienvenida
=> Anuncios / Ayuda
=> Código / Desarrollo web
Welcome,
Guest
Members login
Register for free
General
General
New members
Announcements
Support / Suggestions
Art boards
Creative mediums
Requests and offers
Tutorials
Celestial Star tutorials
Web development
Coding
Web design
Advertisements / affiliation
Off-topic
The non-sense
Ententainment
Loading...