CODEWITHSUNDEEP
phpmysql
jpgerb
jpgerb

Reputation: 1120

How do I add a row to mySQL using PHP?

I am trying to add an "admin" section of my website. Right now I am working on a section to add a new row to my MySQL database.

The first file is my admin.php:

<html>
...
<body>
<form action="add.php" method="post">
    <input type="text" name="order" />
    <input type="text" name="newstatus" />
    <input type="submit" value="Add" />

</form>

</body>
</html>

My goal here is to add 2 pieces of data (the table only has 2 columns right now) to the new row.

Then, I have my add.php file:

<?
//declare my connection variables - I'll move these to a secure method later
mysql_connect($servername, $username, $password) or die (mysql_error ());

// Select database
mysql_select_db($dbname) or die(mysql_error());

// The SQL statement is built

$sql="INSERT INTO $tblname(id, status)VALUES('$order', '$newstatus')";
$result=mysql_query($sql);

if($result){
    echo "Successful";
    echo "<BR>";
    echo "<a href='admin.php'>Back to main page</a>";
}

else {
    echo mysqli_errno($this->db_link);
}
?>

<?php
// close connection
mysql_close();
?>

Anytime i input any data (non-duplicate of what is already in the table), it gives me an error. If I clear my table completely of all data, it will input once. I am getting a duplicate key error, but my key should be "orders", which is unique every time I input it.

Suggestions?

Upvotes: 0

Views: 95

Answers (2)

D4V1D
D4V1D

Reputation: 5849

If you are actually inserting a new row, you shouldn't fill the ID yourself but rather set it as AUTO_INCREMENT in your database. And then, have you form as such:

<form action="add.php" method="post">
    <input type="text" name="newstatus" />
    <input type="submit" value="Add" />
</form>

And your PHP code like so: 

$newstatus = mysql_real_escape_string($_POST['newstatus']); // note the usage of $_POST variable
$sql="INSERT INTO `$tbl_name` (`status`) VALUES ('$newstatus')";
$result = mysql_query($sql) or die('Failed executing query: '.mysql_error());

AUTO_INCREMENT can be set up in phpMyAdmin with the following query:

ALTER TABLE `WorkOrders` MODIFY `id` INTEGER NOT NULL AUTO_INCREMENT;

Finally, don't use mysql_* functions, they are deprecated.

Upvotes: 2

christophetd
christophetd

Reputation: 3874

I am guessing the 'id' field of your table is a primary key. If that's the case, you cannot have two rows that have the same identifier.

By your variable name newstatus, it seems to me like you're trying to update the status of an order ; is it the case? If yes, you should use a UPDATE SQL query of the form:

UPDATE table SET status='somestatus' WHERE id=someid

Upvotes: 0

Related Questions