Thunder_Wolf
-
Posts
28 -
Joined
-
Last visited
Posts posted by Thunder_Wolf
-
-
I did catch the typo and have corrected it, I was thinking about shortining the amp_20_ var in the script and the data base, which I have done now as well as shorting the part num var as well, will test and see if it changes the input to where it will add to the data base.
-
I have created a form that i can see the form input info in to the form boxes but once submitted it is not updating or adding new input to the database. I am trying to keep it as simple as possible. I am also new at PHP.
Here is my code:
<?php
// define variables and set to empty values
$amp_20_parts_idErr = $part_numberErr = $locationErr = $quantityErr = "";
$amp_20_parts_id = $part_number = $discription = $location = $quantity = "";if ($_SERVER["REQUEST_METHOD"] == "POST") {
if (empty($_POST["amp_20_parts_id"])) {
$amp_20_parts_idErr = "ID is required.";
} else {
$amp_20_parts_id= test_input($_POST["amp_20_parts_id"]);
}
if (empty($_POST["part_number"])) {
$part_numberErr = "Part number is required.";
} else {
$email = test_input($_POST["part_number"]);
}
if (empty($_POST["description"])) {
$descriptionErr = "";
} else {
$description = test_input($_POST["description"]);
}
if (empty($_POST["location"])) {
$locationErr = "A location is required.";
} else {
$location = test_input($_POST["location"]);
}if (empty($_POST["quantity"])) {
$quantityErr = "Quantity is required";
} else {
$quantity = test_input($_POST["quantity"]);
}
}function test_input($data) {
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
?>
<div id="update_form">
Please follow instructions for updating the data base.<br>instructional text goes here.<br/><br/>
<table><tr><form method="POST" action="new path">
<td>ID: <input name="amp_20_parts_id" type="text"><span><?php echo
$amp_20_parts_idErr; ?></span><br/><br/></td>
<td>Part Number: <input name="part_number" type="text"><span><?php echo
$part_numberErr; ?></span><br/><br/></td>
<td><label>Discription: <textarea name="description" rows="3" col="20"></textarea>
<br/><br/></td>
<td>Location: <input name="location" type="text"><span><?php echo $locationErr;?>
</span><br/><br/></td>
<td>Quantity: <input name="quantity" type="text"><span><?php echo $quantityErr; ?>
</span><br/><br/></td><br/>
<td><input type="submit"></td>
</form></tr></table>
<?php
$con=mysqli_connect("server","user","password","db");// Check connection
if (mysqli_connect_errno()) {
echo("Connect failed: %s\n", mysqli_connect_error());// escape variables for security
$amp_20_parts_id = mysqli_real_escape_string($con, $_POST['amp_20_parts_id']);
$part_number = mysqli_real_escape_string($con, $_POST['part_number']);
$discription = mysqli_real_escape_string($con, $_POST['description']);
$location = mysqli_real_escape_string($con, $_POST['location']);
$quantity = mysqli_real_escape_string($con, $_POST['quantity']);$sql="INSERT INTO amp_20 (amp_20_parts_id, part_number, description, location,
quantity)
VALUES ('$amp_20_parts_id', '$part_number', '$description', '$location',
'$quantity')";if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
echo "1 record added";
mysqli_close($con);
}
?>
Database is not updating with new info
in PHP Coding Help
Posted
Ginerjm, could you give an example of the value clause, I think I know what i am missing but not sure, it would help out a lot thanks