How Can i copy a mysql record and save with different id using PHP?
Sunny’s Question:
I am new in PHP. I have an idea. Can i copy a recoed of table and save it with different id in same table?
For example i have a web form with different fields. I use that form to store data in database. Now i have a page where i display that record and use CRUD operations. When user click on Edit Button it goes on Form where he see a Button of Create copy. When user click on Create Copy button it just begin to start making a copy of selected data and store same data with different id?
Here is a simple way. You can have multiple submit buttons. Like
<input type="submit" name="submit" value="Edit" />
<input type="submit" name="submit" value="Make a copy" />
When this forms get submitted, you can check which submit button was pressed by asserting with $_POST['submit'] or $_GET['submit'] if you method is GET.
For example:
if($_POST['submit'] == 'Make a copy') {
$action = "copy";
} elseif($_POST['submit'] == 'Edit') {
$action = "edit";
}
Using that you can know what the user wanted to do. Since you already have the data, just pass those to your function which creates a new record without the primary key.
