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
Seperate team from score
I am writing a site that does a NFL Pick 'em type application and I have a feed that gives me the scores of the NFL games every week I have it split apart down to each game two teams and a score
preg-match with a string and numbers
Hi, I can't get the expression to work for my preg_match, what I'd like is for it to match the string, but only if it is accompanied by a letter, not a number. So if a string was found with a number
post to self
Trying to get my form to submit to itself. However I am also trying to use an image for my submit button, when I set the type='image' it will not submit to itself. Can someone help me figure out
session checking in page load
hai all
Could Someone Please Debug This?
I was wondering if someone could debug this script for me. I realize it's not the tidest script (and probably not the most efficiant in the world) but it was quite late when I wrote it and I can't be
How could I do this?
Ive got a simple lottery game, and am using an sql database to keep track of the numbers bought. But, when the person comes to buy the ticket, I have to replay to my process page which ticket they
Production of mango in processing industry
Hi,
New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understand simple arrays, associative arrays, and multidimensional arrays also. The book I am reading
Strange Oracle Query problem
Ok So I have this PHP class that talks to a Javascript class that basically creates a table of information from a database query and puts it in a sortable, filterable table. This all works fine and
Must be a string? Huh, what? HELP?
with the following script, I get Fatal error: Property name must be a string in /home/content/e/s/o/esone/html/test/123.php on line 24Anyone maybe know what is causing it?Code: <?phpfunction
