i want to transfer data from column to another table column using PHP

Question

i want to transfer data from column to another table column using PHP for example table1 has a column "amount" and table 2 column "total". how can i transfer/copy the value in "amount" to "total"?

sory for my bad english

edit: i use MySql db

Use UPDATE sir.. http://dev.mysql.com/doc/refman/5.7/en/update.html — VishalParkash, Dec 20 '16 at 09:09
By table do you mean HTML table or SQL table? This question is currently too vague. Please add more details. Thank you. — Pang, Dec 20 '16 at 09:10

score 0 · Answer 1 · answered Dec 20 '16 at 09:12

0

You can simple use below query if you are looking to update MySQL table from PHP.

UPDATE `table` SET amount=total;

answered Dec 20 '16 at 09:12

TIGER

2,864
5
35
45

the column total is in different table – ronell Dec 20 '16 at 09:30
@ronell: fetch the value first and then update the table. – VishalParkash Dec 20 '16 at 09:38

score 0 · Answer 2 · answered Dec 20 '16 at 09:12

0

$update = mysqli_query('your_connection', 'UPDATE $tablename SET column1 = '$value1', column2 = '$value2' WHERE Condition');

For details: http://dev.mysql.com/doc/refman/5.7/en/update.html

answered Dec 20 '16 at 09:12

VishalParkash

490
3
15

score -1 · Accepted Answer · answered Dec 20 '16 at 09:13

Use this. here I use userId to select a particular row. you can alter it or not use it according to your requirement.

$query = "SELECT amount  FROM table1 WHERE userId='{$id}'";
$result = mysqli_query($con,$query);

$sql = "UPDATE table2 SET total='{$result}' WHERE userId='{$id}'";
mysqli_query($con,$sql);

i want to transfer data from column to another table column using PHP

3 Answers3