ello..im a new beginner for pHp script..i have to complete my final project..i used php as my programming language..but,i have a problem rite now..did anybody know,how to insert data from 1 form into multiple tables in MySql Database?..
ok,rite now,i have 2 tables, Client and Client2,k..And from 1 form that i created ,i want to add the information from the form into table Client and Client2..anybody Know?...plz help me..;(
Jump to PostAssuming you already know how to connect to the database and that your form method was post:
$name=$_POST['name']; $age=$_POST['age']; $sql="INSERT INTO Client (name,age) VALUES ('$name','$age')"; $result=mysql_query($sql) or die(mysql_error()); $sql="INSERT INTO Client2 (name,age) VALUES ('$name','$age')"; $result=mysql_query($sql) or die(mysql_error());
Assuming you already know how to connect to the database and that your form method was post:
$name=$_POST['name'];
$age=$_POST['age'];
$sql="INSERT INTO Client (name,age) VALUES ('$name','$age')";
$result=mysql_query($sql) or die(mysql_error());
$sql="INSERT INTO Client2 (name,age) VALUES ('$name','$age')";
$result=mysql_query($sql) or die(mysql_error());Thanx u buddy..;)..i try my bes..tq..
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.