parsing html in pgsql using php

From: Clio <clio(at)zgia(dot)zp(dot)ua>
To: pgsql-php(at)postgresql(dot)org
Subject: parsing html in pgsql using php
Date: 2002-08-22 13:59:53
Message-ID: 20020822135952.GD76528@zgia.zp.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php


Subject ... how to?

here is an example:

<?php

$tmp = "

<table width='175' cellSpacing='0' cellPadding='0' border='0' align='right'><tr>
<td align='center' vAlign='middle' style=\"border: 1px solid black; background-color: #f0f0f0;\">
Sample text in table.
</td>
</tr></table>

";

pg_connect("host=localhost dbname=daatabase user=web_user password=password");

pg_query("insert into site_common values ('01','00','".$tmp."')");

?>

Here is an error:

Warning: pg_query() query failed: ERROR: parser: parse error at or near "175" in /w/devel/test/dbinsert.php on line 80

Any ideas?

/ Clio

Responses

Browse pgsql-php by date

  From Date Subject
Next Message David C. Brown 2002-08-22 14:06:27 Re: parsing html in pgsql using php
Previous Message Justin Clift 2002-08-22 12:43:55 Re: Nextval Problems