title: Error when inserting data to postgresql with php
body: <p>I am trying to insert some data into a table in a PostgreSQL database. I use prepared statements for this purpose like:</p>
  
  <pre><code>$db = new PDO('pgsql:dbname=wind;user=postgres;password=1249;host=localhost;port=5432');
  $db-&gt;setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
  $db-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  
  for ($x = 0; $x &lt; sizeof($arrayAddress); $x++) {
     $stmt = $db-&gt;prepare("INSERT INTO geocoding_test (address,googlemaps) VALUES (address=:address, sucUn=:sucUn ) ");
     $stmt-&gt;execute(array(address =&gt; $arrayAddress[$x], sucUn =&gt; $arraySucUnsuc[$x] ));
  } 
  </code></pre>
  
  <p>...where <code>arrayAddress</code> is an array containing all the addresses and <code>arraySucUnsuc</code> is an array containing some string.</p>
  
  <p>When I execute this I get the following error:</p>
  
  <pre><code>Fatal error: Uncaught exception 'PDOException' with message 
      SQLSTATE[42703]: Undefined column: 7 ERROR: column 'address' does not exist 
      LINE 1: ... INTO geocoding_test (address,googlemaps) VALUES (address=$1... ^
      HINT: There is a column named 'address' in table 'geocoding_test', but it cannot be
      referenced from this part of the query.' in C:\MAMP\htdocs\Wind\predictVdslEligibilityWSLog-20150614\myWebCrawler.php:98
      Stack trace:
      #0 C:\MAMP\htdocs\Wind\predictVdslEligibilityWSLog-20150614\myWebCrawler.php(98): PDOStatement-&amp;gt;execute(Array)
      #1 {main} thrown in C:\MAMP\htdocs\Wind\predictVdslEligibilityWSLog-20150614\myWebCrawler.php on line98
  </code></pre>
  
  <p>What am I doing wrong? </p>
  
  <p>Also this is the definition of my table in the database:</p>
  
  <pre><code>CREATE TABLE geocoding_test
  (
      id serial NOT NULL,
      address character varying(600),
      googlemaps character varying(50)
  )
  </code></pre>