[Mapbender-commits] r1971 - branches/2.5/http/classes
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Wed Jan 16 06:36:47 EST 2008
Author: christoph
Date: 2008-01-16 06:36:47 -0500 (Wed, 16 Jan 2008)
New Revision: 1971
Modified:
branches/2.5/http/classes/class_wfs_conf.php
Log:
prepared statements
Modified: branches/2.5/http/classes/class_wfs_conf.php
===================================================================
--- branches/2.5/http/classes/class_wfs_conf.php 2008-01-16 11:16:19 UTC (rev 1970)
+++ branches/2.5/http/classes/class_wfs_conf.php 2008-01-16 11:36:47 UTC (rev 1971)
@@ -281,8 +281,10 @@
global $DBSERVER,$DB,$OWNER,$PW;
$con = db_connect($DBSERVER,$OWNER,$PW);
db_select_db($DB,$con);
- $sql = "SELECT * FROM wfs_featuretype WHERE fkey_wfs_id = ".$id;
- $res = db_query($sql);
+ $sql = "SELECT * FROM wfs_featuretype WHERE fkey_wfs_id = $1";
+ $v = array($id);
+ $t = array("i");
+ $res = db_prep_query($sql, $v, $t);
$cnt = 0;
while ($row = db_fetch_array($res)){
$this->featuretype_id[$cnt] = $row["featuretype_id"];
@@ -308,8 +310,10 @@
global $DBSERVER,$DB,$OWNER,$PW;
$con = db_connect($DBSERVER,$OWNER,$PW);
db_select_db($DB,$con);
- $sql = "SELECT * FROM wfs_element WHERE fkey_featuretype_id = ".$fid;
- $res = db_query($sql);
+ $sql = "SELECT * FROM wfs_element WHERE fkey_featuretype_id = $1";
+ $v = array($fid);
+ $t = array("s");
+ $res = db_prep_query($sql, $v, $t);
$cnt = 0;
while ($row = db_fetch_array($res)){
$this->element_id[$cnt] = $row["element_id"];
@@ -332,8 +336,10 @@
global $DBSERVER,$DB,$OWNER,$PW;
$con = db_connect($DBSERVER,$OWNER,$PW);
db_select_db($DB,$con);
- $sql = "SELECT * FROM wfs_featuretype_namespace WHERE fkey_featuretype_id = ".$fid;
- $res = db_query($sql);
+ $sql = "SELECT * FROM wfs_featuretype_namespace WHERE fkey_featuretype_id = $1";
+ $v = array($fid);
+ $t = array("s");
+ $res = db_prep_query($sql, $v, $t);
$cnt = 0;
while ($row = db_fetch_array($res)){
$this->namespace_name[$cnt] = $row["namespace"];
More information about the Mapbender_commits
mailing list