Using text boxes in a form

tjbarr

I am trying to pull inv_no from a database and print it in a text box. I use this code on other pages that just display on a page, but never used it on a form with text boxes. What am I doing wrong. This is php with mysql.

<form name="sv_t4.php" method="post" action=<?php echo $PHP_SELF;?>>
<?php

if (isset($_POST['cbovessel']))
  {
     $inv_ch=$_POST['cbovessel'];
  } 

      $query="Select * from tbl_vessel where inv_no=$inv_ch;"; 	   
      $result_set = pg_Exec ($conn, $query);
      $rows = pg_NumRows($result_set);					 
for($i=0;$i<$rows;$i++)
              {
      $_POST['invno']=pg_result($result_set, $i,"inv_no"); 
 }   
?>

<table width="100%" border="0">
<tr>
<td width="17%">Inventory Number </td>
<td width="27%"><input name="inv_no" type="text" value="<?=$_POST['invno'];?>" size="10" />
</font> </p>

tjbarr

I printed the wrong database

tjbarr

I know that I am getting the $inv_ch from the other form because I echo it out but how can I print out the query results?

stolzyboy

instead of:

<?=$_POST['invno'];?>

try:

<?php echo $_POST['invno']; ?>

tjbarr

Thanks, but I am still getting blank. I know I am connected to the database.

tjbarr

resource(4) of type (pgsql result) I get this when I do a var_dump($result_set); So this means that I am getting stuff from the query right?

tjbarr

How can I print out an element that I pulled out of the database with the query?

stolzyboy

you have a result set... now you need to "fetch" the results

tjbarr

What is the syntax?

stolzyboy

http://us2.php.net/manual/en/function.pg-fetch-array.php

tjbarr

Is this for use with postgreSQL

stolzyboy

read and find out... and yes, it is... i wouldn't post a link for mysql since you are using postgresql, it is the pg_fetch_array() function

tjbarr

I tried this but it still doesn't work. Am I getting closer?

<form name="sv_t4.php" method="post" action=<?php echo $PHP_SELF;?>>		
 <?php  

 if (isset($_POST['cbovessel']))
 {
    $inv_ch=$_POST['cbovessel'];
 }
          		echo $inv_ch;

          $query="Select inv_no from tbl_vessel where inv_no=$inv_ch;"; 	   
          $result_set = pg_Exec ($conn, $query);
    	 $row = pg_fetch_row($result_set);

 	                $_POST['qinvno']=pg_result("inv_no"); 
					$_POST['svtype']=pg_result("sv_type"); 

				?>

<table width="100%" border="0">
<tr>
<td width="17%">Inventory Number</td>
<td width="27%"><input name="inv_no" type="text" value="<? echo $_POST['qinvno']; ?>" size="10" />
</font> </p>

Roger_Ramjet

the syntax for your query, you should not have a ; inside the string

$query="Select inv_no from tbl_vessel where inv_no=$inv_ch";

PS. are you sure pg_exec will work, in the manual it is pg_execute