title: Inserting data in oracle database using php
body: <p>The following code is generating this </p>
  
  <pre><code>Warning: oci_execute() [function.oci-execute]: 
  ORA-00911: invalid character in F:\wamp\www\SEarch Engine\done.php  on line 17
  </code></pre>
  
  <p>the code is...</p>
  
  <pre><code>&lt;?php
  include_once('config.php');
  $db = oci_new_connect(ORAUSER,ORAPASS,"localhost/XE");
  
  $url_name=$_POST['textfield'];
  $keyword_name=$_POST['textarea'];
  $cat_news=$_POST['checkbox'];
  $cat_sports=$_POST['checkbox2'];
  $anchor_text=$_POST['textfield2'];
  $description=$_POST['textarea2'];
  
  $sql1="insert into URL(Url_ID,Url_Name,Anchor_Text,Description) 
      VALUES( 9,".'{$url_name}'.",".'{$anchor_text}'.",".'{$description}'.")";
  
  
  
  $result=oci_parse($db,$sql1);
  oci_execute($result);
  
  
  
  
  
  ?&gt;
  </code></pre>