Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- mysql_query("SET NAMES utf8");
- $query = mysql_query("select * from tovar");
- if($query == false) { die("чото не чотко");}
- $row = mysql_fetch_array($query); /* Сразу вытаскиваем массив */
- echo '</table>
- <table class="simple-little-table" cellspacing="0" border="1" style: "min-width: 100%; style: "max-width: 100%;">
- <tr>
- <td>id</td>
- <td>Товар</td>
- <td>Удалить</td>
- <td>Изменить</td>
- <td>Новое назв.</td>
- </tr>';
- while($row = mysql_fetch_row($query))
- { print "<tr>
- <td>{$row['0']}</td>
- <td>{$row['1']}</td>
- <form method='post' action=''>
- <td><input name='del' class='btn btn-primary' type='submit' value='Del'></td>
- <td> <input name='red' class='btn btn-primary' type='submit' value='Ren'></td>
- <td><input name='id' type='hidden' value='". $row['0'] ."'>
- <input name='namered' type='text' value='". $row['1'] ."'></td>
- </form>
- </td>
- </tr>";
- };
- echo "</select>";
- if ( isset ( $_POST['del'] )){$sql1 =mysql_query ("DELETE FROM `tovar` WHERE tovar_id='".$_POST['id']." ' ");}
- elseif ( isset ( $_POST['red'] ))
- {//!!!!САМ ЗАПРОС!!!! В самом запросе указываем переменные $_POST['namered'] и $_POST['rentred']
- $sql2 =mysql_query ("UPDATE tovar SET tovar_name='". $_POST['namered']."' WHERE tovar_id='".$_POST['id']." ' ");
- if($sql2 == false){ echo "неполучилось";}
- else { $url = $_SERVER['REQUEST_URI']; echo "<script>location.href='".$url."'</script>"; /* Перенаправляемся на страницу редактирвоания сбрасывая переменные $_POST['del'] и/или $_POST['red'] */}
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement