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
Troubles with a spider class
I am building a spider that will crawl through random whitepages (eg. anywho.com, switchboard.com, w
what are '%S%', '%E%'
for example when i see Code: [Select]printf("Hello %srn", $name);
what does %s means
Header is not working in IE
Hi ! header function is not working in IE but it works in FF, Safari, Chrome. any help please. :
Reduce redundancies in switch functions?
Hello all! I somewhat new to PHP, and was wondering if anyone could give some suggestions on a swit
array_combine() trouble w/csv file
I have a problem with a piece of code I wrote to import some records from a csv file into mysql. I h
Option box to change variable
Hello, i need help by making a script!
I need to write a file with option box, so a dropdown
Array becomes unset by itself?
Hi,
I have a bit of experience with PHP but not extensive. It seems I cannot store any items
PHP Include not working
The website is http://www.grlistingservices.com
The code block is as follows:
<
Multiple upload and Resize
I would like some help on my script I have the for my index.php
////
<html&
If a form submits back to same page do you need to use $get
IM trying to pass page number and year that was selected back to the same page.
i have this c
