populating edit form

fontener

Trying to have a form with 6 'highlight' fields (this being the max number of highlights per property)

TABLE highlights
[INDENT]highlight_id
property_id
highlight_desc[/INDENT]

<?php
require("DB.class.php");
$highlightCount = 6;

$sql = ("SELECT * FROM highlights WHERE property_id_ref = '1'");
$DB->Query($sql, 'highlights');
while($row = $DB->Fetch('highlights'))
	$highlights[] = $row;
foreach($highlights as $k => $v){

}
?>

<form name="highlightForm" method="_POST" enctype="text/plain">
<?php
	for($i=1; $i<=$highlightCount; $i++){
		echo '<p><input type="text" placeholder="Highlight '.$i.'" name="highlight[.$i.]"/></p>';
	}
?>
</form>
?>

fontener

I guess there's a few questions:

Say there are 2 highlights currently in the highlight table. I will need to populate the form with the current highlight id, property id, and highlight_desc. But say the user adds 4 more highlights. How do I make the script know which to update and which to insert?

vivek151189

Didn't got your point please try to explain with the help of sample code

fontener

So I have the form with 6 'highlight fields' .. I do a query.. which returns two results .. it populates the first two fields [see below]. Now, if they change highlight 2, for example, AND they add highlights 3 and 4... how do you tell mysql to differentiate what is updatable and what needs to be inserted as new, i.e. UPDATE highlight 2 AND INSERT highlight 3 and 4.

<p><input type="hidden" name="highlightID" value="14"/></p>
<p><input type="text" placeholder="Highlight 1" name="highlight[1]" value="Highlight 1 description"/></p>

<p><input type="hidden" name="highlightID" value="15"/></p>
<p><input type="text" placeholder="Highlight 2" name="highlight[2]" value="highlights 2 description"/></p>

<p><input type="hidden" name="highlightID" value=""/></p>
<p><input type="text" placeholder="Highlight 3" name="highlight[3]" value=""/></p>

<p><input type="hidden" name="highlightID" value=""/></p>
<p><input type="text" placeholder="Highlight 4" name="highlight[4]" value=""/></p>

<p><input type="hidden" name="highlightID" value=""/></p>
<p><input type="text" placeholder="Highlight 5" name="highlight[5]" value=""/></p>

<p><input type="hidden" name="highlightID" value=""/></p>
<p><input type="text" placeholder="Highlight 6" name="highlight[6]" value=""/></p>

fontener

Ok, so I got this to work, however, I feel it's very sloppy and would enjoy suggestions/help..

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
 <html>
 <head>
 <title>Edit Record</title>
 </head>
 <body>

<?php

 // creates the edit record form
 // since this form is used multiple times in this file, I have made it a function that is easily reusable
 function renderForm($id, $highlightID, $highlight, $error)
 {
 ?>

 <?php 
 $highlightCount = 6;
 // if there are any errors, display them
 if ($error != '')
 {
	echo '<div style="padding:4px; border:1px solid red; color:red;">'.$error.'</div>';
 }
 ?> 

 <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
 <input type="hidden" name="id" value="<?php echo $id; ?>"/>
 <div>
 <p><strong>ID:</strong> <?php echo $id; ?></p>
<?php
	for($i=1; $i<=$highlightCount; $i++){
		echo '<p><input type="hidden" name="highlightID['.$i.']" value="'.@$highlightID[$i].'"/></p>';
		echo '<p><input type="text" placeholder="Highlight '.$i.'" name="highlight['.$i.']" value="'.@$highlight[$i].'"/></p>';
	}
?>

 <input type="submit" name="submit" value="Submit">
 </div>
 </form> 
 <?php
 }



 // connect to the database
 include('DB.class.php');
 $highlightCount = 6;
 // check if the form has been submitted. If it has, process the form and save it to the database
 if (isset($_POST['submit']))
 { 
	 // confirm that the 'id' value is a valid integer before getting the form data
	 if (is_numeric($_POST['id']))
	 {
		 // get form data, making sure it is valid
		 $id = $_POST['id'];
		 $highlightID = $DB->clean($_POST['highlightID']);
		 $highlight = $DB->clean($_POST['highlight']);

	 // check that firstname/lastname fields are both filled in
	 if (@$error)
	 {
		 // generate error message
		 $error = 'ERROR: Please fill in all required fields!';

		 //error, display form
		 renderForm($id, $highlightID, $highlight, $error);
	 } else {
		for($i=1; $i<=6; $i++){
		 // save the data to the database
			 if(!empty($highlight[$i])){
				 if(isset($highlightID[$i])){
					$DB->Query("UPDATE highlights SET highlight='$highlight[$i]', property_id_ref='$id' WHERE highlight_id='$highlightID[$i]'", "highlights")
					or die(mysql_error()); 
				 } else {
					$DB->Query("INSERT INTO highlights(property_id_ref, highlight) VALUES ('$id', '$highlight[$i]')", "highlight")
					or die(mysql_error());
				 }
			 }
		 }

		 // once saved, redirect back to the view page
		echo "success!";
		 //header("Location: view.php"); 
	 }
 } else {
	 // if the 'id' isn't valid, display an error
	 echo 'Error!';
 }
// if the form hasn't been submitted, get the data from the db and display the form	 
 } else {

 // get the 'id' value from the URL (if it exists), making sure that it is valid (checing that it is numeric/larger than 0)
 if (isset($_GET['id']) && is_numeric($_GET['id']) && $_GET['id'] > 0)
 {
	 // query db
	 $id = $_GET['id'];
	 $result = $DB->query("SELECT * FROM highlights WHERE property_id_ref=$id", 'highlights')
	 or die(mysql_error()); 
	 while($row = $DB->Fetch('highlights')){

		 // get data from db
		 $highlightID[] = $row['highlight_id'];
		 $highlight[] = $row['highlight'];


	 }
	 // show form
	 renderForm($id, $highlightID, $highlight, '');

 } else {
 // if the 'id' in the URL isn't valid, or if there is no 'id' value, display an error
	echo 'Error!';
 }
 }
?>

 </body>
 </html>