I am trying to insert multiple check boxes values(this values comes from 1st database) and I am giving the check boxes in the output(result fetch from 1st database). I want to insert all selected values into to the 2nd database from 1st database using PHP.
for E.g mysql backend:-1st database name:- sss1 Table name: abc fields name: A, B,C and D
2nd database name:- sss2 Table name: abc fields name: A, B,C and D
so i want to insert the selected data to 2nd databse using checkboxes(values fetch from 1st database) in php.
please check the code is given below:-
I dont understand how i make the insert query in check.php
Checkbox.php
<?php
$db=mysql_connect("localhost","root","");
mysql_select_db("sss1",$db);
$qry="select * from abc ,pqr
where abc.company_id ='$c_id' and pqr.c_id=abc.company_id";
$result=mysql_query($qry);
?>
<form action=”check.php” method=”post”>
<table>
<tr><th>A</th>
<th>B</th>
<th>C</th>
<th>D</th>
<th>E</th>
</tr>
<?php
while($row=mysql_fetch_array($result))
{
echo "<tr><td><input type=checkbox name=name[] value='".$row1['s_id']."'>".$row['A']."</td><td>".$row['B']."</td><td>".$row['C']."</td></tr>";
}
?>
<input type="submit" value="save" id="submit>
Check.php
<?php
$db=mysql_connect("localhost","root","");
mysql_select_db("sss2",$db);
foreach($_POST[‘name'] as $x)
{
$qry="INSERT INTO xyz()values()”;
mysql_query($qry);
}
?>
Database name:sss1
Table name: abc
A B C D
1 2 3 4
Database name: sss2
Table name: xyz
A B C D
1 2 3 4
