PHP Basics

[bala kan]

Hi Friends,

Good morning to you,

I have been creating simple index page in which i use one text box and submit button and i use php smarty also..

requirements are:
when i click after entering some text in text box, it should be posted into the another php ("companyinfo.php") ..

for instance, if i enter some company name in text box , it should fetch the corresponding row from the table.. and those records should be displayed in the "companyinfo.php"..




index.php codings are

<?php

<table border="0" style="padding:50px 0 0 300px;">
 <form name="companyinfo" method="post" action="chang_page('14');">// javascript is used for this function "chang_page('14')"
     <tr>
	 <td >
		<input type="text" name="search" id="find"/>
		</td>
	 <td >
		<input type="submit" value="searchme" name="clkme" />
		</td>
		</tr>
		
		</form>
		</table>
?>

javascript codings are:
chang_page.js

function chang_page(val) { if(val == '12'){ /*request.open('get', 'index.php');*/ request.open('get', 'index.php'); } else if(val == '13'){ request.open('get', 'templates/companyinfo1.tpl'); } else if(val == '14'){ request.open('get', 'companyinfo.php'); } request.onreadystatechange = display_location; request.send('null') return false; }

companyinfo.php coding are

<?php
$host='localhost';
$user='root';
$password='';
$database='test';
$conn=mysql_connect($host,$user,$password) or die('server information is wrong');
mysql_select_db($database,$conn) or die('database information is wrong');
$searchitem=($_POST['search']);
//$searchitem='adroit';
if(isset($_POST['clkme']))
{
 $sql="SELECT companyname,address FROM companydetail WHERE companyname LIKE '%$searchitem%'";
 $retval=mysql_query($sql);
 if(!$retval)
 {
   die('could not get data:'.mysql_error());
 }
while($row=mysql_fetch_row($retval))
{
  echo "company Name:$row[0]  <br>",
  "Address: $row[1] <br>";
}
echo "fetched data successfully\n";


}
?>

it shows the following error

Notice: Undefined index: search in C:\wamp\www\phpdemo\companyinfo.php on line 8

please rectify me..

Thanks in advance



Regards,
Bala

[Nick Charles]

Why are you using javascript? Why not simply define the form on index.php as follows:

<form name="companyinfo" method="post" action="companyinfo.php" >

This will be sure to send a POST request to the server. You javascript on the other hand simply use a GET, which doesn't pass any form data.