Advice on how to delete a mysql row using my form
Posted on
16th Feb 2014 07:03 pm by
admin
Hi,
I am very new to php and am struggling to work out how to delete a portfolio item (a row from my database using my form which is here): http://www.spencercarpenter.co.uk/portfolioAppFiles/simpleForm.php
The problem comes I think because I already have one submit button on the page as you can see.
Ideally when pressed the delete button will remove the row from the database with the same name that is showing in the top drop down box and either go to a page with a 'delete successfull' message or the message wil appear next to the button.
Here is the code for the page:
Code: <?php
include('connectToDB.php');
include('populateDropDownList.php');
include('buildFileList5.php');
//include('deleteCurrentItem.php');
?>
<html>
<head>
<script type="text/javascript">
var existingPortfolioItems = new Array();
function chkFrm(el){
if(el.selectedIndex == 0){
alert("Please choose an option");
return false
}
else{
el.form.submit();
}
}
function hello(){
//alert("Hello It works");
var result = "boo";
location.replace("deleteCurrentItem.php?result"+ result);
//location.href = "deleteCurrentItem.php?Result=" + Result;
}
function updateImg(ele, img) { // using arguments makes this function reusable for multiple items
// ele = dropdown object
// img = image object
document.getElementById(img).src = "uploaded/thumbs/" + ele.value;
//document[img].alt = ele.value;
}
</script>
</head>
<body>
<h1>Select Existing Item:
</h1>
<form action"deleteCurrentItem.php" method="POST" >Existing Item:
<select name="name" onChange="chkFrm(this)">
<option value="Choose" <?php if (!(strcmp("Choose", $_POST['name']))) {echo "SELECTED";} ?>>Choose Portfolio Items</option>
<?php do { ?>
<option value="<?php echo $row_PortfolioItems['id']?>"<?php if (!(strcmp($row_PortfolioItems['id'], $_POST['name']))) {echo "SELECTED";} ?>><?php echo $row_PortfolioItems['name']?></option>
<?php
} while ($row_PortfolioItems = mysql_fetch_assoc($PortfolioItems));
$rows = mysql_num_rows($PortfolioItems);
if($rows > 0) {
mysql_data_seek($PortfolioItems, 0);
$row_PortfolioItems = mysql_fetch_assoc($PortfolioItems);
}
?>
</select>
------------>
<input type="button" name="deleteButton" onClick="hello();" value="Delete Current Item">
</form>
<form action="addToPortfolioItems.php" onSubmit="return checkForDuplicateNames("name")" method="post">
<table width="884" height="789" border="1">
<tr>
<td width="417" rowspan="5" valign="top">Name:
<input name="name" type="text" value="<?php echo $row_chosen_pItem['name']; ?>" size="25">
<p>Short Description:</p>
<p>
<textarea name="shortDesc" cols="55" rows="4"><?php echo $row_chosen_pItem['shortDesc']; ?></textarea>
</p>
<p>Long Description:</p>
<p>
<textarea name="longDesc" cols="55" rows="10"><?php echo $row_chosen_pItem['longDesc']; ?></textarea>
</p>
<p>Related Item01
<select name="relatedItem01" >
<option value="" >Choose Item</option>
<?php do { ?>
<option value="<?php echo $row_PortfolioItems['id']?>"<?php if (!(strcmp($row_PortfolioItems['id'], $row_chosen_pItem['relatedItem01']))) {echo "SELECTED";}?>><?php echo $row_PortfolioItems['name']?></option>
<?php
} while ($row_PortfolioItems = mysql_fetch_assoc($PortfolioItems));
$rows = mysql_num_rows($PortfolioItems);
if($rows > 0) {
mysql_data_seek($PortfolioItems, 0);
$row_PortfolioItems = mysql_fetch_assoc($PortfolioItems);
} ?></select>
</p>
<p>Related Item02
<select name="relatedItem02" >
<option value="" >Choose Item</option>
<?php do { ?>
<option value="<?php echo $row_PortfolioItems['id']?>"<?php if (!(strcmp($row_PortfolioItems['id'], $row_chosen_pItem['relatedItem02']))) {echo "SELECTED";}?>><?php echo $row_PortfolioItems['name']?></option>
<?php
} while ($row_PortfolioItems = mysql_fetch_assoc($PortfolioItems));
$rows = mysql_num_rows($PortfolioItems);
if($rows > 0) {
mysql_data_seek($PortfolioItems, 0);
$row_PortfolioItems = mysql_fetch_assoc($PortfolioItems);
} ?></select>
</p>
<p>Related Item03
<select name="relatedItem03" >
<option value="" >Choose Item</option>
<?php do { ?>
<option value="<?php echo $row_PortfolioItems['id']?>"<?php if (!(strcmp($row_PortfolioItems['id'], $row_chosen_pItem['relatedItem03']))) {echo "SELECTED";}?>><?php echo $row_PortfolioItems['name']?></option>
<?php
} while ($row_PortfolioItems = mysql_fetch_assoc($PortfolioItems));
$rows = mysql_num_rows($PortfolioItems);
if($rows > 0) {
mysql_data_seek($PortfolioItems, 0);
$row_PortfolioItems = mysql_fetch_assoc($PortfolioItems);
} ?></select>
</p>
<p>Keywords:
<input name="keywords" type="text" value="<?php echo $row_chosen_pItem['keywords']; ?>" size="50">
<p>Skills:
<input name="skills" type="text" value="<?php echo $row_chosen_pItem['skills']; ?>" size="50">
<p>
<input type="submit"/>
</td>
<td width="451" height="157" align="left"><p>Image01:
<select name="img01" onChange="updateImg(this, 'thumbImg01')">
<?php echo buildFileList5('uploaded',$row_chosen_pItem['img01']); ?>
</select></p>
<table width="24" border="1">
<tr>
<td><img src="uploaded/thumbs/<?php echo $row_chosen_pItem['img01'];?>" alt="hoho" name="thumbImg01" width="100" height="100" id="thumbImg01"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="150" align="left"><p>Image02:
<select name="img02" onChange="updateImg(this, 'thumbImg02')">
<?php echo buildFileList5('uploaded',$row_chosen_pItem['img02']); ?>
</select>
</p>
<table width="24" border="1">
<tr>
<td><img src="uploaded/thumbs/<?php echo $row_chosen_pItem['img04'];?>" alt="hh" name="thumbImg02" width="100" height="100" id="thumbImg02"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="157" align="left"><p>Image03:
<select name="img03" onChange="updateImg(this, 'thumbImg03')">
<?php echo buildFileList5('uploaded',$row_chosen_pItem['img03']); ?>
</select>
</p>
<table width="24" border="1">
<tr>
<td><img src="uploaded/thumbs/<?php echo $row_chosen_pItem['img03'];?>" alt="hh" name="thumbImg03" width="100" height="100" id="thumbImg03"></td>
</tr>
</table></td>
</tr>
<tr>
<td width="451" height="109" align="left"><p>Image04:
<select name="img04" onChange="updateImg(this, 'thumbImg04')">
<?php echo buildFileList5('uploaded',$row_chosen_pItem['img04']); ?>
</select>
</p>
<img src="uploaded/thumbs/<?php echo $row_chosen_pItem['img04'];?>" alt="hh" name="thumbImg04" width="100" height="100" id="thumbImg04"></td>
</tr>
<tr>
<td align="left"><p>Image05:
<select name="img05" onChange="updateImg(this, 'thumbImg05')">
<?php echo buildFileList5('uploaded',$row_chosen_pItem['img05']); ?>
</select>
</p>
<table width="24" border="1">
<tr>
<td><img src="uploaded/thumbs/<?php echo $row_chosen_pItem['img05'];?>" alt="hh" name="thumbImg05" width="100" height="100" id="thumbImg05"></td>
</tr>
</table></td>
</tr>
</table>
<p> </p>
</form>
<h1>Upload an image file</h1>
<form enctype="multipart/form-data" action="uploader.php" method="POST"><input type="file" name="myfile">
<p>
<input name="Submit" type='submit' value="upload" >
</form>
<h1>Upload a movie file</h1>
<form enctype="multipart/form-data" action="uploaderAndResize.php" method="POST"><input type="file" name="myfile">
<p>
<input name="Submit" type='submit' value="upload" >
<?echo $heldVariable?>
</form>
<h1>Upload a download file</h1>
<form enctype="multipart/form-data" action="uploaderAndResize.php" method="POST"><input type="file" name="myfile">
<p>
<input name="Submit" type='submit' value="upload" >
<?echo $heldVariable?>
</form>
</body>
</html>
<?php
?>
Thanks in advance for any help on this
No comments posted yet
Your Answer:
Login to answer
158 
40 
Other forums
present value of sequence?
Hi
Please help me to find out the present value of sequence?
Thanks
Echoing If Function?
A script I am using has If statements in the comments form to basically tell the form what to do. Cu
Calling All PHPFREAKS Blackberry Users
Are you a member of PHPFreaks and have a blackberry? Well RIM just recently released Blackberry Mes
Adding Different Numbers From MySQL
Basically I have a mysql database with a couple prices as the following:
9.99
9.99
9.99
Ignore html and bbcode?
I've created a function to limit the amount of text according to the amount of words.
However
Only add new information from XML to MySQL
What I am doing, is taking a xml file, and adding the values to a database. However, what I want to
PHP error. Need help urgently
Hi,
I am programming a php site and have a problem that i just cant find out how to fix. When
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
what is wrong with this
Code: [Select]<?php
if ($_SERVER['HTTP_REFERER'])
{
Problem in back link
I have page where i have given javascript back link but when i click on it browser give a messagehelp with email script...
hey
I need help with my mail script
when the form on http://www.mcgdesignstudio.com/c
