Hi,
I'm trying to edit some database fields, I have text1, text2, text3, text4, text5, text6 etc..
They are displayed on the index.php page, with an edit link so the user can choose which set to edit
// Extract details from database
$sql = "SELECT * FROM data WHERE id=1";
$stmt = $db->prepare($sql);
$stmt->execute();
$e = $stmt->fetch();
<h1><?php echo $e['text1']) ?></h1>
<p><?php echo ($e['text2']); ?></p>
<p><a href="edit.php">EDIT</a></p>
<h1><?php echo $e['text3']) ?></h1>
<p><?php echo ($e['text4']); ?></p>
<p><a href="edit.php">EDIT</a></p>
<h1><?php echo $e['text5']) ?></h1>
<p><?php echo ($e['text6']); ?></p>
<p><a href="edit.php">EDIT</a></p>
edit.php:
// Extract details from database
$sql = "SELECT * FROM data WHERE id=1";
$stmt = $db->prepare($sql);
$stmt->execute();
$e = $stmt->fetch();
<form method="post" action="process.php" enctype="multipart/form-data">
<label>Page Title
<input type="text" name="text1" maxlength="90" value="<?php echo $e['text1'] ?>" />
</label>
<br>
<label>Title Text</label>
<textarea name="text2"><?php echo $e['text2'] ?></textarea>
<input id="button" type="submit" name="submit" value="Save Changes" />
and then update them: process.php
$sql = "UPDATE data SET text1=?, text2=? WHERE id=1 LIMIT 1";
$stmt = $db->prepare($sql);
$stmt->execute(
array(
$_POST['text1'],
$_POST['text2']
)
);
$stmt->closeCursor();
Question:
How can I pass the form values dynamically from the index.php page so I don't have to hard code text1, text2 etc into the edit.php and process.php page and have a different update & process page for each set of data?
Thanks in advance.
