[RESOLVED] Passing array from script to script

cmp241

Hello everyone,

I am new to this PHP world, so please bear with my ignorance.
I am trying to create a user interface to allow a user to insert data into a form that will be placed in a MySql database.
The problem is when I go to pass my array from file to file nothing is passed. Also, I would like to know how to pass variables from one file to another file to another file.

My code is below:

In this file I ask the user for the name of the database and table they would like to insert the record (the else part of the code). Then the if part(the begging of the code) connects to the database open up the database and table and print the fields in the form. Now I am attempting to store the user input in this part of the code $fname=$_POST['fname'];and echo "$meta->name:<input type=\"text\" name=\"fname[]\"
. this maybe the problem

<?php

if (isset($_POST['action'])	&& $_POST['action']	== 'submitted')
{
	$dname = $_POST[dname];
	$tname = $_POST[tname];
	//connect to mysql
        $con = mysql_connect("localhost","root","password");
	if (!$con)
  	{
  		die('Could not connect: ' . mysql_error());
  	}
        //choose database and table
	mysql_select_db($dname, $con);
	$result	= mysql_query("select *	from $tname");
	$i = 0;
	$fname=$_POST['fname'];
//setting up form with fields taken from table
	echo "<form action=\"insertrecord.php\" method=\"post\">";
	while ($i <	mysql_num_fields($result))
	{
		$meta =  mysql_fetch_field($result, $i);
		echo "$meta->name:<input type=\"text\" name=\"fname[]\" /><br>";//echo "$meta->name<br>";
		$i++;
	}
	echo "<input type=\"submit\" name=\"submit\" value=\"Show Field(s)\" />
		</form>";
}
else
{

echo <<< HERE
<form action="addrecord.php" method="post">
Database Name: <input type="text" name="dname" />
Table Name: <input type="text" name="tname" /><br>
 <input type="hidden" name="action" value="submitted" />
   <input type="submit" name="submit" value="Create Table" />
   </form>

HERE;


}
?>

When the user press show field, insertrecord.php is open (code below) and it should display the user input and I also want to transfer the content of $dname and $tname, but its not working. I tried to serialize but don't know how to use it. So can someone give me a simple example or show the error in my code. Thanks in advance

<?php
$fname1=$_POST($fname);

$dname = $_POST[dname];
$tname = $_POST[tname];
echo $fname1[0];
echo $dname;
echo $tname;
//mysql_query("INSERT INTO $tname VALUES   "); 


?>

big_nerd

I could just be mistaken, however

I believe the correct $_POST syntax is as follows:


<?php
$tname = "one";
$dname = "two";
?>
<html><head><title>Pass it Along Form!</title</head><body>
<form name="fNameForm" method="POST" action="insertrecord.php">
<input type="text" name="fname">
<input type="hidden" name="dname" value="<?php echo $dname; ?>">
<input type="hidden" name="tname" value="<?php echo $tname; ?>">
<input type="submit" name="submit" value="Insert Record">
</form>
</body>
</html>

And in the file: insertrecord.php

<?php

$fname = $_POST['fname'];
$dname = $_POST['dname'];
$tname = $_POST['tname'];

echo "Hello $fname.. Its a nice day outside, $tname, $dname, three.";
?>

This should pass from one file (even HTML) to the PHP file.

You can then do what you like with the variables.

Remember you have to use $_POST for every variable you wish to pass. And in HTML forms, even if you have the variable set, you will have to re-send it with the form.

This is most common done with <input type="hidden">.

If you need clarification, don't hesitate to ask.

big.nerd

cmp241

thanks for the advice big.nerd, I kinda did what you did, but, I got it working