MHaris
08-19-2007, 01:23 PM
<?php
// Last Modified 18th August 2007
ob_start();
session_start();
include('templates/header.php'); // Header template
include('../config/config.php'); // Includes configuration files
include('../lib/functions.php'); // Load all functions from Library
if(!session_is_registered("username")){
header('Location: index.php');
exit();
}
else {
$submit_delete = $_POST['delete'];
if(isset($submit_delete)){
$sql = mysql_query('SELECT * FROM candidates ORDER BY id') or die(mysql_error());
$selected_candidate = $_POST['selected_candidate_array'];
foreach ($selected_candidate as $cID){
mysql_query("DELETE FROM candidates WHERE id='$cID'") or die(mysql_error());
mysql_query("DELETE FROM answers WHERE candidate_id='$cID'") or die(mysql_error());
echo "Candidate <b>".$cID."</b> deleted!<br/>";
}
}
else {
echo "<form method=\"POST\">";
echo "Enter new name: <input type=\"text\" name=\"new_name\">";
echo "<input type=\"submit\" name=\"submit_new_name\" value=\"Edit\">";
echo "</form>";
$submit_new_name = $_POST['submit_new_name'];
$new_name = sql_safe($_POST['new_name']);
$edit_cID = $_POST['selected_edit_candidate'];
echo $edit_cID;
if(isset($submit_new_name)){
echo $edit_cID;
mysql_query("UPDATE candidates SET name='$new_name' WHERE id='$edit_cID'") or die(mysql_error());
echo $new_name;
echo "Name successfully changed to ".$new_name;
}
}
include('templates/footer.php'); // Footer Template
}
?>
$edit_cID is posted from another form. The $edit_cID echo's out corectly before if(isset($submit_new_name)) but not after it has been submitted.
Why and how can I fix it?
// Last Modified 18th August 2007
ob_start();
session_start();
include('templates/header.php'); // Header template
include('../config/config.php'); // Includes configuration files
include('../lib/functions.php'); // Load all functions from Library
if(!session_is_registered("username")){
header('Location: index.php');
exit();
}
else {
$submit_delete = $_POST['delete'];
if(isset($submit_delete)){
$sql = mysql_query('SELECT * FROM candidates ORDER BY id') or die(mysql_error());
$selected_candidate = $_POST['selected_candidate_array'];
foreach ($selected_candidate as $cID){
mysql_query("DELETE FROM candidates WHERE id='$cID'") or die(mysql_error());
mysql_query("DELETE FROM answers WHERE candidate_id='$cID'") or die(mysql_error());
echo "Candidate <b>".$cID."</b> deleted!<br/>";
}
}
else {
echo "<form method=\"POST\">";
echo "Enter new name: <input type=\"text\" name=\"new_name\">";
echo "<input type=\"submit\" name=\"submit_new_name\" value=\"Edit\">";
echo "</form>";
$submit_new_name = $_POST['submit_new_name'];
$new_name = sql_safe($_POST['new_name']);
$edit_cID = $_POST['selected_edit_candidate'];
echo $edit_cID;
if(isset($submit_new_name)){
echo $edit_cID;
mysql_query("UPDATE candidates SET name='$new_name' WHERE id='$edit_cID'") or die(mysql_error());
echo $new_name;
echo "Name successfully changed to ".$new_name;
}
}
include('templates/footer.php'); // Footer Template
}
?>
$edit_cID is posted from another form. The $edit_cID echo's out corectly before if(isset($submit_new_name)) but not after it has been submitted.
Why and how can I fix it?