Scaffolding PHP: Add an edit function

I've been trying to add an edit function to this tutorials i've got from dot Net magazine which is a scaffolding PHP system, how can i achive edit and delete for this system, I've add the full code below:


<?php
	mysql_connect("localhost", "netusah", "blabla");
	mysql_select_db("mydb");
 
	function print_header() {
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<title>Instaform!</title>
<style>
input.warn	{ border: 1px solid red; }
p.warn	{ color: red; font-weight: bold; }
</style>
</head>
 
<body>
 
<?php
	}
 
	function print_footer() {
?>
</body>
</html>
 
<?php
	}
 
	function pretty_print($string) {
		return ucfirst(str_replace("_", " ", $string));
	}
 
	function make_safe($array) {
		foreach($array as $var => $val) {
			$array[$var] = mysql_real_escape_string($val);
		}
 
		return $array;
	}
 
	function get_table_fields($table) {
		$result = mysql_query("SHOW FIELDS FROM $table;");
 
		$rows = array();
 
		while ($row = mysql_fetch_assoc($result)) {
			// if we're reading the primary key, skip it
			if ($row["Extra"] == "auto_increment") continue;
 
			$this_row = $row;
 
			if (stripos($row["Type"], "char") !== false) {
				$this_row["Type"] = "char";
			} else if (stripos($row["Type"], "text") !== false) {
				$this_row["Type"] = "text";
			} else if (stripos($row["Type"], "int") !== false) {
				$this_row["Type"] = "int";
			}
 
			$rows[$row["Field"]] = $this_row;
		}
 
		return $rows;
	}
 
	function validate_form($form, $table) {
		$problems = array();
 
		$fields = get_table_fields($table);
 
		if (count($form) != count($fields)) {
			$problems[] = "Fatal error.";
			return $problems;
		}
 
		foreach($fields as $name => $info) {
			if (!isset($form[$name])) {
				$problems[] = "Fatal error with $name.";
				return $problems;
			}
 
			if ($info["Null"] == "NO") {
				// this field must be provided!
				if (trim($form[$name]) == "") {
					$problems[$name] = "This field must be completed.";
				}
			}
		}
 
		return $problems;
	}
 
	function show_table_links($table) {
		$name = pretty_print($table);
 
		echo "<h1>$name</h1>";
		echo "<p><a href=\"create.php?type=$table\">New</a> | <a href=\"edit.php?type=$table\">Edit</a></p>";
 
		$fields = get_table_fields($table);
		$fields_query = implode(", ", array_keys($fields));
 
		echo "<table width=\"100%\">";
 
		echo "<tr>";
		foreach($fields as $field) {
			$field = pretty_print($field["Field"]);
			echo "<th>$field</th>";
		}
		echo "</tr>";
 
 
		$result = mysql_query("SELECT $fields_query FROM $table;");
 
		while ($row = mysql_fetch_assoc($result)) {
			echo "<tr>";
			foreach($row as $field) echo "<td>$field</td>";
			echo "</tr>";
		}
 
 
		echo "</table>";
	}
 
	function create_new($table) {
		echo "<h1>Create new item</h1>";
 
		$fields = get_table_fields($table);
 
		if (isset($_POST["save"])) {
			if (!isset($_POST[$table])) {
				echo "<p>Fatal error.</p>";
			} else {
				$form = make_safe($_POST[$table]);
 
				$error_list = validate_form($form, $table);
 
				if ($error_list == array()) {
					$query = "INSERT INTO $table (ID, " .
							implode(", ", array_keys($form)) .
							") VALUES ('', '" .
							implode("', '", array_values($form)) .
							"');";
 
					mysql_query($query);
 
					header("location: index.php");
					exit;
				}
			}
		}
 
		echo "<form method=\"post\">";
 
		foreach($fields as $field) {
			$pretty_name = pretty_print($field["Field"]);
 
			if (isset($_POST[$table][$field["Field"]])) {
				// value submitted already!
				$value = $_POST[$table][$field["Field"]];
			} else {
				if ($field["Default"] != "") {
					// got a default value!
					$value = $field["Default"];
				} else {
					// empty...
					$value = "";
				}
			}
 
			if (isset($error_list)) {
				if (isset($error_list[$field["Field"]])) {
					$error_class = "warn";
					$error_text = " - " . $error_list[$field["Field"]];
				} else {
					$error_class = "normal";
					$error_text = "";
				}
			} else {
				$error_class = "normal";
				$error_text = "";
			}
 
			echo "<p>$pretty_name: </p>";
 
			switch ($field["Type"]) {
				case "text":
					echo "<p class=\"$error_class\"><textarea class=\"$error_class\" name=\"{$table}[{$field["Field"]}]\">$value</textarea> $error_text</p>";
					break;
 
				default:
					echo "<p class=\"$error_class\"><input class=\"$error_class\" type=\"text\" name=\"{$table}[{$field["Field"]}]\" value=\"$value\" /> $error_text</p>";
			}
		}
 
		echo "<p><input type=\"hidden\" name=\"save\" value=\"true\" /></p>";
		echo "<p><input type=\"submit\" value=\"Create\" /></p>";
		echo "<p><a href=\"index.php\">Cancel</a></p>";
	}
?>

Open in new window

ostroxAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NerdsOfTechTechnology ScientistCommented:
UPDATE $table SET $field = $value

DELETE from $table WHERE $where_condition
0
ostroxAuthor Commented:
Where do I add this?
0
NerdsOfTechTechnology ScientistCommented:
Basically you'll need to create a process page for deleting a row by the ID;
therefore, on your output function you will need a new link to delete.php.
looks like you are linking to edit.php already.

Did you add the edit.php link?
                echo "<h1>$name</h1>";
                echo "<p><a href=\"create.php?type=$table\">New</a> | <a href=\"edit.php?type=$table\">Edit</a></p>";

Open in new window

0
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

NerdsOfTechTechnology ScientistCommented:

                echo "<h1>$name</h1>";
                echo "<p><a href=\"create.php?type=$table\">New</a> | <a href=\"edit.php?type=$table\">Edit</a><a href=\"delete.php?type=$table\">Delete</a></p>";

Open in new window

0
NerdsOfTechTechnology ScientistCommented:
With your edit.php
READ the current roq and PREFILL the inputs with this data
Then,
You will need to run the SQL after sumbiting the new input information from edit.php
UPDATE table_name SET column_name = value [, column_name = value ...] [WHERE condition]

===

With your delete.php
You will need to run the SQL code on opening delete.php
DELETE FROM table_name [WHERE condition]
SQL Statement Syntax:
 
UPDATE table_name SET column_name = value [, column_name = value ...] [WHERE condition]
 
DELETE FROM table_name [WHERE condition]

Open in new window

0
NerdsOfTechTechnology ScientistCommented:
With your edit.php
READ the current roq and PREFILL the inputs with this data
Then,
You will need to run the SQL after sumbiting the new input information from edit.php
UPDATE table_name SET column_name = value [, column_name = value ...] [WHERE condition]

===

With your delete.php
You will need to run the SQL code on opening delete.php
DELETE FROM table_name [WHERE condition]
0
NerdsOfTechTechnology ScientistCommented:
With your edit.php
READ the current ROW and PREFILL the inputs with this data
Then,
You will need to run the SQL after sumbiting the new input information from edit.php
UPDATE table_name SET column_name = value [, column_name = value ...] [WHERE condition]

===

With your delete.php
You will need to run the SQL code on opening delete.php
DELETE FROM table_name [WHERE condition]
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ostroxAuthor Commented:
thanks for the replys ill get back to you soon if all worked
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.