using form to display data

zuessh

I have the following php script that will pull data from a mysql database

$db_name = "php";
$db_user = "testphp";
$db_pass = "test";

$connection = mysql_connect("localhost", "$db_user", "$db_pass") or die("Couldn't");
$db = mysql_select_db($db_name, $connection) or die("Couldn't Select Database");

$query = "select * from phptest where name = 'Test'";
$result = mysql_query($query, $connection)or die ("Couln't execute query.");
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$name = $row['name'];

$text = "$id $name <br>";

echo $text;

I have the following form

<HTML>
<HEAD>
<TITLE>A simple form</TITLE>
</HEAD>
<BODY>
<FORM method="POST" action="form.php">
<INPUT type="text" name="mytextbox" size="20"><BR>
<INPUT type="submit" name="mybutton" value="Click me!">
</FORM>
</BODY>
</HTML>

What is the best way to allow me to enter data into the form and have it display the data?

Also, other than webmonkey tuts, any suggestions on docs or tuts for using forms with php and mysql?

jubripley

This is a good place to start:
http://www.php.net/manual/en/tutorial.forms.php

kevinsequeira

reg
kevin

zuessh

Thanks, here is what I have

<HTML>
<HEAD>
<TITLE>A simple form</TITLE>
</HEAD>
<BODY>
<FORM method="POST" action="form.php">
<INPUT type="text" name="mytextbox" size="20" value="<?php print($text);?>">
<INPUT type="submit" name="mybutton" value="Click me!">
</FORM>
</BODY>
</HTML>

what needs to be changed in the php script form.php to allow it to read the value from the form box? Below is the form.php

$db_name = "php";
$db_user = "testphp";
$db_pass = "test";

$connection = mysql_connect("localhost", "$db_user", "$db_pass") or die("Couldn't");
$db = mysql_select_db($db_name, $connection) or die("Couldn't Select Database");

$query = "select * from phptest";
$result = mysql_query($query, $connection)or die ("Couln't execute query.");
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$name = $row['name'];

$text = "$id $name <br>";

echo $text;

}
?>

Thanks again...

kevinsequeira

do u want to enter the data in the form and have it display on the posted page ??

on the form have this

on form.php

$entered_data = $_POST['mytextbox'];

echo $entered_data;

reg
kevin

zuessh

I apologize for not clearly stating what i am attempting. I have a mysql database with name and address data. I would like to have a form that an address can be entered (just street add) and it pull back all the names from the database that go along with that address. Basically company A serves one address, company B also serves the same address, when that address is entered into the form both company A and B are returned. If company C serves a different address only it would be returned. Sorry any confusion. thanks for the help.

kevinsequeira

<HTML>
<HEAD>
<TITLE>A simple form</TITLE>
</HEAD>
<BODY>
<FORM name="search" method="POST" action="form.php">
enter address : <INPUT type="text" name="address" size="20">
<INPUT type="submit" name="mybutton" value="Click me!">
</FORM>
</BODY>
</HTML>

<?
//form.php
$db_name = "php";
$db_user = "testphp";
$db_pass = "test";

$address = $_POST['address'];

$connection = mysql_connect("localhost", "$db_user", "$db_pass") or die("Couldn't");
$db = mysql_select_db($db_name, $connection) or die("Couldn't Select Database");

$query = "select * from phptest where address like '%".$address."%'";
echo $query;

$result = mysql_query($query, $connection)or die ("Couln't execute query.");
while ($row = mysql_fetch_array($result)) {
		echo $row['name']."<BR>";
}
?>

reg
kevin

zuessh

🙂 Thanks, that did the trick and has helped tremendously. One more thing while we're here; if no results are found, what would be best way to have it return a message such as 'nothing was found please contact...'

kevinsequeira

$result = mysql_query($query, $connection)or die ("Couln't execute query.");
if(mysql_num_rows($result)<1){
 echo "no results";
}else{
    while ($row = mysql_fetch_array($result)) {

    echo $row['name']."<BR>";

 }
}

look up some php tutorials and you will learn quite a bit, just do a search in google and u will find quite a few of them

reg
kevin