inserting data to mysql database from droplist
i have code to insert values into mysql database. but the problem doesn't
insert anything.
what i want is if user select from droplist table1. value inserting into
table1 and son for table2.
my html code
<html>
<body>
<form method="post" action="update.php">
<input type="txt" name="name"/>
<select name="tables">
<option value="table1">table1</option>
<option value="table2">table2</option>
<option value="table3">table3</option>
<option value="table4">table4</option>
</select>
<input type="submit" value="Submit Pick" />
</body>
</html>
my php code
<?php
$table =$_POST['tables'];
$name =$_POST['name'];
$con=mysqli_connect("localhost","sqldata","sqldata","accounts");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql="INSERT INTO $table (name)
VALUES
('$_POST[name]')";
echo ".$table.$name";
?>
No comments:
Post a Comment