PHP 2 Form output problem

ashz

Hi,

During the last days I wrote this little script with the help of the users of this forum, it works and read the database field into form but when I call another php file (select1.php) in otder to print the selected item from the form it does not work.

Can any one explain me why and how to fix it.

Thanks again.

Mysql2form.html

<HTML>
<HEAD>
<TITLE>mysql2form</TITLE>
</HEAD>
<BODY>
<?
$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'p';
$table = 'l';

$connection = mysql_connect($host,$user,$pass) or die("Couldn't make
connection.");
$datab = mysql_select_db($db, $connection) or die("Couldn't select database.");
$sql = "SELECT name FROM $table";
$sql_result = mysql_query($sql,$connection) or die("Couldn't execute query.");
while ($row = mysql_fetch_array($sql_result)) {
$line = $row["name"];
$block .= "<OPTION value=\"$line\">$line</OPTION>";
}
?>

<FORM action="http://localhost/print1.php" method="GET" >
search:<br>
<select name=vari>
<? echo "$block";?>
</select>
<P><INPUT type="submit" value="submit"></p>
</FORM>
</BODY>
</HTML>

print1.php

rIkLuNd

Well, if the first file is a html file, then it's quite obvious why it isn't working... 😉

rIkLuNd

Otherwise, try this code:

mysql2form.php

<HTML>
<HEAD>
<TITLE>mysql2form</TITLE>
</HEAD>
<BODY>
<FORM action="http://localhost/print1.php" method="GET" >
search:<br>
<select name="vari">
<?
$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'p';
$table = 'l';

$connection = mysql_connect($host,$user,$pass) or die("Couldn't make
connection.");
$datab = mysql_select_db($db, $connection) or die("Couldn't select database.");
$sql = "SELECT name FROM $table";
$sql_result = mysql_query($sql,$connection) or die("Couldn't execute query.");
while ($row = mysql_fetch_array($sql_result))
{
print "<OPTION value=\"$row['name']\">$row['name']</OPTION>";
}
?>
</select>
<P><INPUT type="submit" value="submit"></p>
</FORM>
</BODY>
</HTML>

print1.php

ashz

Hi,

Copy and Paste your lines and it generate an empty drop down menu.
The PHP Version is 4.2.3.
Ashz.

rIkLuNd

is the table named l...

rIkLuNd

This is how I would have done it:

mysql2form.php:

<?php

$host = "localhost";
$user = "YourUserName";
$pass = "YourPassword";
$db = "YourDatabase";

$link = mysql_connect($host,$user,$pass);
if(!$link)
die(mysql_error());

$select = mysql_select_db($db);
if(!$select)
die(mysql_error());

$query = "SELECT * FROM YourTable";
$result = mysql_query($query);
if(!$result)
die(mysql_error());

print "<HTML>\n";
print "<HEAD>\n";
print "<TITLE>mysql2form</TITLE>\n";
print "</HEAD>\n\n";
print "<BODY>\n";
print "<form action=\"http://localhost/print1.php\" method=\"GET\">\n";
print "search:<br>\n";
print "<select name=\"vari\">\n";

while($row = mysql_fetch_array($result))
{
print "<option value=\"$row[name]\">$row[name]</option>\n";
}

print "</select>\n";
print "<P><input type=\"submit\" value=\"submit\"></p>\n";
print "</FORM>\n";
print "</BODY>\n";
print "</HTML>\n";
?>

print1.php:

<html>
<head>
<title>Results</title>
</head>

<body>
<?php
print "Your choice was $vari"; // You might have to use $_GET['vari'] here...
?>
</body>
</html>

Let me know if it's working!

ashz

Hi,

Thanks for the script it work excellent in the editor I am using (SSEditor - http://skyweb2k.com/sseditor/), but in IE I get only a the file content(like you see in windows editor) and in netscape I get some junk (a lot of /n) on the screen. How can I solve this issue.

I will also thank you if you can show me how to combine 3 dynamic drop-down menu (content of different fields from the same database) in one PHP file.

You have a fast and smooth forum site.

Thanks a lot.

rIkLuNd

Do you think you could upload the script to somewhere, and then give me the address?

ashz

I do not have a site to upload it but I can email it.

rIkLuNd

ok! my email is:

erik_riklund@hotmail.com

ashz

Hi,

Files sent.

Thnaks a lot.