Jump to content

help with inserting data to multiple mysql table based on user selection

arjang

By arjang
in PHP Coding Help

Recommended Posts

arjang Newbie

arjang

Posted
Posted

Hi guys:)

 

i have two tables in my mysql db, english_articles and persian_articles. i want to be able to insert data into each table using only one from with dropdown menu for table names. for example, if i select persian_articles, data should go to persian_articles table and vice versa.

i would really appreciate if you helped me solve my problem and give me a code for it. i am new to php and mysql so please dnt be too technical.

TeNDoLLA Newbie

TeNDoLLA

Posted
Posted

Something like this?

 

<?php
if (isset($_POST['table']))
{
if (intval($_POST['table']) === 1)
{
	// Insert data into english table
}
else if (intval($_POST['table']) === 2)
{
	// Insert data into persian table
}
else
{
	// Error selecting table.
}
}
?>

<html>
<head>
	<body>
		<form action="test.php" method="POST">
			<select name="table">
				<option value="1">english</option>
				<option value="2">persian</option>
			</select>
		</form>
	</body>
</head>
</html>

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.