title: PHP & Oracle database edit/update data
body: <p>I'm using PHP in combination with an Oracle database. What I want is the following: On the first form I want to select a name out of a table in the database and when you push the button open I want the users to see a html form where the fields are filled in with the information from the person you've selected on the first screen. You can edit this information and when you push the update button the table has to be updated. I don't know who to do this whole process in PHP in combination with Oracle. Can someone please help me? This is an important part of a project I'm doing and I can't find any information anywhere!
  I really hope someone can help me.<br>
  PHP &amp; Oracle database edit/update data.
  geting error <code>Undefined variable: objResult</code> on &lt;&lt;&lt;-----here</p>
  
  <pre><code>&lt;?
      $objConnect = oci_connect("myuser", "mypassword", "TCDB");
      $strSQL     = "SELECT * FROM CUSTOMER";
      $objParse   = oci_parse($objConnect, $strSQL);
      oci_execute($objParse, OCI_DEFAULT);
  ?&gt;  
              &lt;table width="600" border="1"&gt;  
              &lt;tr&gt;  
              &lt;th width="91"&gt; &lt;div align="center"&gt;CustomerID  &lt;/div&gt;&lt;/th&gt;  
              &lt;th width="98"&gt; &lt;div align="center"&gt;Name  &lt;/div&gt;&lt;/th&gt;  
              &lt;th width="198"&gt; &lt;div align="center"&gt;Email  &lt;/div&gt;&lt;/th&gt;  
              &lt;th width="97"&gt; &lt;div align="center"&gt;CountryCode  &lt;/div&gt;&lt;/th&gt;  
              &lt;th width="59"&gt; &lt;div align="center"&gt;Budget  &lt;/div&gt;&lt;/th&gt;  
              &lt;th width="71"&gt; &lt;div align="center"&gt;Used  &lt;/div&gt;&lt;/th&gt;  
              &lt;th width="30"&gt; &lt;div align="center"&gt;Edit  &lt;/div&gt;&lt;/th&gt;  
              &lt;/tr&gt;  
  &lt;?
      while ($objResult = oci_fetch_array($objParse, OCI_BOTH))
      {
  ?&gt;  
               &lt;tr&gt;  
               &lt;td&gt;&lt;div  align="center"&gt;&lt;?= $objResult["CUSTOMERID"]; ?&gt;&lt;/div&gt;&lt;/td&gt;  &lt;&lt;---here
               &lt;td&gt;&lt;?= $objResult["NAME"]; ?&gt;&lt;/td&gt;  &lt;&lt;---here
                &lt;td&gt;&lt;?= $objResult["EMAIL"]; ?&gt;&lt;/td&gt;  &lt;&lt;---here
                &lt;td&gt;&lt;div  align="center"&gt;&lt;?= $objResult["COUNTRYCODE"]; ?&gt;&lt;/div&gt;&lt;/td&gt;  
                   &lt;td align="right"&gt;&lt;?= $objResult["BUDGET"]; ?&gt;&lt;/td&gt;  &lt;&lt;---here
                      &lt;td align="right"&gt;&lt;?= $objResult["USED"]; ?&gt;&lt;/td&gt;  
  
               &lt;td align="center"&gt;&lt;a  href="php_oracle_update2.php?CusID=                                                                                  &lt;?=$objResult["CUSTOMERID"];?&gt;"&gt;Edit&lt;/a&gt;&lt;/td&gt;    
                 &lt;/tr&gt; 
                 &lt;?
                  }
                 ?&gt; 
                  &lt;/table&gt;  
  &lt;?
      oci_close($objConnect);
  ?&gt;      
  </code></pre>