pcbguy Posted December 5, 2007 Share Posted December 5, 2007 I have the below form that calls the below php script. The 'position' entry is the primary key and is what I use to call each record. How can I input another record with the same 2 digit position number and have it over write the previous entry? Thanks. <html> <head> <title>Form to Add Car For Sale</title> </head> <body> <form enctype="multipart/form-data" method="post" action="add.php"> Position<br> <input type="Text" name="position" size="2"><br> Year<br> <input type="Text" name="year" size="25"><br> Make<br> <input type="Text" name="make" size="25"><br> Model<br> <input type="Text" name="model" size="40"><br> Price<br> <input type="Text" name="price" size="25"><br> Description<br> <input type="text" name="description" size="200"><br> Picture<br> <input type="File" name="picture" size="40"><br><br> <input type="hidden" name="MAX_FILE_SIZE" value="30000"> <input type="submit" name="submit" value="Upload"> </form> </body> </html> <?php //This is the directory where the images will be saved $target="images/"; $target=$target.basename($_FILES['picture']['name']); //This gets all the other information from the form $position=$_POST['position']; $year=$_POST['year']; $make=$_POST['make']; $model=$_POST['model']; $price=$_POST['price']; $description=$_POST['description']; $picture=($_FILES['picture']['name']); //Connects to Database include "connect.php"; //Writes the information to the database mysql_query("INSERT INTO for_sale (position,year,make,model,price,description,picture) VALUES ('$position','$year','$make','$model','$price','$description','$picture')"); //Writes photo to the server if(move_uploaded_file($_FILES['picture']['tmp_name'],$target)) { //Tells you if its all okay echo "The file" .basename($_FILES['uploadedfile']['name']). "has been uploaded, and your information has been added to the directory"; } else{ //Gives and error if its not echo "Sorry, there was a problem uploading your file."; } ?> Link to comment https://forums.phpfreaks.com/topic/80336-solved-how-can-i-delete-and-replace-database-entry/ Share on other sites More sharing options...
revraz Posted December 5, 2007 Share Posted December 5, 2007 Use the MySQL UPDATE statement. Link to comment https://forums.phpfreaks.com/topic/80336-solved-how-can-i-delete-and-replace-database-entry/#findComment-407150 Share on other sites More sharing options...
pcbguy Posted December 5, 2007 Author Share Posted December 5, 2007 Can it be written into the same script so that it will automatically delete the old entry if someone puts in the same 'position'? Link to comment https://forums.phpfreaks.com/topic/80336-solved-how-can-i-delete-and-replace-database-entry/#findComment-407155 Share on other sites More sharing options...
pcbguy Posted December 5, 2007 Author Share Posted December 5, 2007 Maybe some sort of If statement that says if position=? then it replaced all the other columns with the current information. Link to comment https://forums.phpfreaks.com/topic/80336-solved-how-can-i-delete-and-replace-database-entry/#findComment-407159 Share on other sites More sharing options...
runnerjp Posted December 5, 2007 Share Posted December 5, 2007 $sql = "DELETE FROM `table` WHERE `cell`={$Clean['cell']}"; $q = mysql_query($sql); if($q === FALSE){ dbg_out('ERROR: ' . mysql_error()); }else{ dbg_out('Database delete successful'); Link to comment https://forums.phpfreaks.com/topic/80336-solved-how-can-i-delete-and-replace-database-entry/#findComment-407163 Share on other sites More sharing options...
pcbguy Posted December 5, 2007 Author Share Posted December 5, 2007 That will delete it? I put that at the beginning of the script? Link to comment https://forums.phpfreaks.com/topic/80336-solved-how-can-i-delete-and-replace-database-entry/#findComment-407175 Share on other sites More sharing options...
runnerjp Posted December 5, 2007 Share Posted December 5, 2007 yer it will obviusly chnage ur table name ect Link to comment https://forums.phpfreaks.com/topic/80336-solved-how-can-i-delete-and-replace-database-entry/#findComment-407186 Share on other sites More sharing options...
revraz Posted December 5, 2007 Share Posted December 5, 2007 Why do you want to make 2 statements, one to delete and one to insert when you can just update? Its easy to check to see if it exists and then update, if not, insert. Link to comment https://forums.phpfreaks.com/topic/80336-solved-how-can-i-delete-and-replace-database-entry/#findComment-407188 Share on other sites More sharing options...
pcbguy Posted December 5, 2007 Author Share Posted December 5, 2007 That is what I want to do. I just started another thread. Link to comment https://forums.phpfreaks.com/topic/80336-solved-how-can-i-delete-and-replace-database-entry/#findComment-407307 Share on other sites More sharing options...
runnerjp Posted December 5, 2007 Share Posted December 5, 2007 sorry just gave a delete one Link to comment https://forums.phpfreaks.com/topic/80336-solved-how-can-i-delete-and-replace-database-entry/#findComment-407310 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.