Date: 12/31/07 (PHP Community)    Keywords: php

The script should show a list of stuff which could be changed if the checkbox is ticked and button "Edit" is submitted or deleted if button Delete is submitted.

But for some reason it worls very strangely. First of all, it allows to change only last thing on the list. At that if checkboxes of previous stuff in the list are ticked it updates DB with the values of the last one. And if I put tick and submit delete button it doesn't work at all.

What is the reason of such behaviour? How to fix it?

main file


<?php //start session session_start(); if (!$_SESSION['login'] ) { echo"<a href='login.php'>Нужно войти</a>"; } else { ?> <? include('header.htm'); ?> <p align="justify"> Инструкция: . </p> <?include('connection.php'); // Создаем таблицу $query = "SELECT id, course, name, link, subj FROM timetable WHERE nick = '".$_SESSION['login']."'"; $result = mysql_query($query) or die("ERROR: $query.".mysql_error()); // if records are present if(mysql_num_rows($result)) { echo "<form method = post action = 'submit_edit.php'>"; while($row = mysql_fetch_assoc($result)) { echo "Название урока: <input type=text name=name value= {$row['name']}> Ссылка: <input type=text name=link value= {$row['link']}> Курс: <select name=newcourse{$row['id']} size=1> <option value=1>1</option> <option value=2>2</option> <option value=3>3</option> <option value=4>4</option> <option value=5>5</option> <option value=6>6</option> <option value=7>7</option> </select> <input type=checkbox name=modify{$row['id']}><br>"; // Статус и предполагаемый факультет // print answer list as radio buttons } echo "<input type = submit name = send value = Редактировать> <input type = submit name = delete value = Удалить></form>"; } // Если новых уроков нет, выводим else { echo 'Новых обитателей нет'; } // close connection mysql_close($connection); include('footer.htm'); ?> <?php } ?>


edit_submit.php

<? if (isset($_POST['send'])) { include('connection.php'); foreach ($_POST as $k => $v) if (substr($k, 0, 6) == "modify") { $name = $_POST['name']; $link = $_POST['link']; $id = (int) substr($k, 6); mysql_query("UPDATE timetable SET course='" . $_POST["newcourse$id"] . "', name = '$name', link = '$link' WHERE id=$id LIMIT 1"); } if (isset($_POST['delete'])) { include('connection.php'); mysql_query("DELETE FROM timetable WHERE id=$id"); } mysql_close($connection); // print success message echo 'Done'; } else { die('ERROR: Data not correctly submitted'); } ?>



Text files are here:
http://www.helpeks.ru/code.zip

Source: http://community.livejournal.com/php/607403.html