hello iam using core php for a system and i have two tables ( current_job , current_quotes )
each table has different columns but they have things in common i desire to move some data from a table to another using button i applied the code below but didn’t work
<code><a href="scripts/transfer.php?id=<?php echo $data['id']?>"
name="current_quote" class="text-success content-link" id="<?php echo $data['id']; ?>"> <i style="margin-left: 5px;" class="fa-solid fa-lg fa-circle-plus"></i> </a> </td>
<a class="btn btn-primary">
</code>
<code><a href="scripts/transfer.php?id=<?php echo $data['id']?>"
name="current_quote" class="text-success content-link" id="<?php echo $data['id']; ?>"> <i style="margin-left: 5px;" class="fa-solid fa-lg fa-circle-plus"></i> </a> </td>
<a class="btn btn-primary">
</code>
<a href="scripts/transfer.php?id=<?php echo $data['id']?>"
name="current_quote" class="text-success content-link" id="<?php echo $data['id']; ?>"> <i style="margin-left: 5px;" class="fa-solid fa-lg fa-circle-plus"></i> </a> </td>
<a class="btn btn-primary">
and here is the code for transfer.php
<code>
<?php
include('../config/database.php');
if(ISSET($_REQUEST['id'])){
$id=$_REQUEST['id'];
$query=mysqli_query($conn, "SELECT * FROM `current_quote` WHERE `id`='$id'") or die(mysqli_error());
$data=mysqli_fetch_array($query);
$quote_number=$data['quote_number'];
$quote_weight=$data['quote_weight'];
mysqli_query($conn, "INSERT INTO current_job (job_number,quote_number,quote_weight) VALUES( '1569', '$quote_number', '$quote_weight')") or die(mysqli_error());
echo"<script>alert('Data successfully transfer')</script>";
}
?>
</code>
<code>
<?php
include('../config/database.php');
if(ISSET($_REQUEST['id'])){
$id=$_REQUEST['id'];
$query=mysqli_query($conn, "SELECT * FROM `current_quote` WHERE `id`='$id'") or die(mysqli_error());
$data=mysqli_fetch_array($query);
$quote_number=$data['quote_number'];
$quote_weight=$data['quote_weight'];
mysqli_query($conn, "INSERT INTO current_job (job_number,quote_number,quote_weight) VALUES( '1569', '$quote_number', '$quote_weight')") or die(mysqli_error());
echo"<script>alert('Data successfully transfer')</script>";
}
?>
</code>
<?php
include('../config/database.php');
if(ISSET($_REQUEST['id'])){
$id=$_REQUEST['id'];
$query=mysqli_query($conn, "SELECT * FROM `current_quote` WHERE `id`='$id'") or die(mysqli_error());
$data=mysqli_fetch_array($query);
$quote_number=$data['quote_number'];
$quote_weight=$data['quote_weight'];
mysqli_query($conn, "INSERT INTO current_job (job_number,quote_number,quote_weight) VALUES( '1569', '$quote_number', '$quote_weight')") or die(mysqli_error());
echo"<script>alert('Data successfully transfer')</script>";
}
?>
New contributor
slim uzi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.