php script

[andrewjs18]

It doesn't actually matter where you put it, but let's say you have created another field called, "record", and you have placed it in the database under the field "price"...

The query would look like this.

PHP Code:

$edit_id = (int) $_POST['id'];
    $sql = "UPDATE `coin_info` SET `date` = '{$_POST['date']}',";
    $sql .= "`price` = '{$_POST['price']}', `record` = '{$_POST['record']}',`condition` = '{$_POST['condition']}',`year` = '{$_POST['year']}',";
    $sql .= "`silver` = '{$_POST['silver']}',`gold` = '{$_POST['gold']}',`weight` = '{$_POST['weight']}' ";
    $sql .= "WHERE `id` = '{$edit_id}' LIMIT 1 ;"; 


You will also need to add the input field in the HTML code, with the name "record"...

Code:

<input type="text" name="record" />

For you other problem, that's how PHP works, but you can change these lines;

PHP Code:

echo "Coin added!", "<br />";
# and
echo "Edited {$edit_id}!", "<br />";
# and
echo "Deleted ID ", $id, "<br />"; 


To this;

PHP Code:

header("Location: coin.php"); 


The will refresh your page, but note that the header function needs to be called before any output has been made, echo or print...
Other wise it will return an error.

please tell me what I'm doing wrong-

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`description` = 'description' WHERE `id` = '7' LIMIT 1' at line 1
Edit failed!

description is the new line I added.

Code:

$edit_id = (int) $_POST['id'];
    $sql = "UPDATE `coin_info` SET `date` = '{$_POST['date']}',";
    $sql .= "`price` = '{$_POST['price']}',`condition` = '{$_POST['condition']}',`year` = '{$_POST['year']}',";
    $sql .= "`silver` = '{$_POST['silver']}',`gold` = '{$_POST['gold']}',`weight` = '{$_POST['weight']}' ";
    $sql .="`description` = '{$_POST['description']}' ";
    $sql .= "WHERE `id` = '{$edit_id}' LIMIT 1 ;";