• 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


View Profile WWW
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 == '&#1069;&#1083;&#1082;&#1074;&#1091;&#1076;') {  
        
mysql_query("DELETE FROM ElwUsers WHERE `Name`='$name'");  
    } elseif (
$faculta == '&#1040;&#1082;&#1074;&#1080;&#1083;&#1084;&#1072;&#1088;') {  
        
mysql_query("DELETE FROM AqmUsers WHERE `Name`='$name'");  
    } elseif (
$faculta == '&#1060;&#1086;&#1082;&#1089;&#1090;&#1077;&#1081;&#1085;') {  
        
mysql_query("DELETE FROM FxtUsers WHERE `Name`='$name'");  
    }  
}  

mysql_close($connection);  

 
// print success message     
include ('header.php');   
echo 
"<center><div id=\"contenido\">&#1047;&#1072;&#1082;&#1083;&#1080;&#1085;&#1072;&#1085;&#1080;&#1077; &#1089;&#1088;&#1072;&#1073;&#1086;&#1090;&#1072;&#1083;&#1086;<br><br><a href=\"menu.php\">&#1042;&#1077;&#1088;&#1085;&#1091;&#1090;&#1100;&#1089;&#1103; &#1074; &#1075;&#1083;&#1072;&#1074;&#1085;&#1086;&#1077; &#1084;&#1077;&#1085;&#1102;</a><br />&#1042;&#1077;&#1088;&#1085;&#1091;&#1090;&#1100;&#1089;&#1103; &#1082; <a href=\"delete.php\">&#1091;&#1076;&#1072;&#1083;&#1077;&#1085;&#1080;&#1102;<a/></div></center>";  
include (
'footer.php');  

?>


Could somebody help me?
Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

  • 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

Go up
eXTReMe Tracker
  • Valid XHTML
  • Valid CSS
Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC | Seo4Smf v0.2 © Webmaster's Talks
Loading...