svn commit: r305 - trunk/mapbender/http/php/mod_createJSObjFromDB.php

[uli at osgeo.org]

Author: uli
Date: 2006-05-16 09:05:04+0000
New Revision: 305

Modified:
   trunk/mapbender/http/php/mod_createJSObjFromDB.php

Log:
db_prep_query included

Modified: trunk/mapbender/http/php/mod_createJSObjFromDB.php
Url: https://mapbender.osgeo.org/source/browse/mapbender/trunk/mapbender/http/php/mod_createJSObjFromDB.php?view=diff&rev=305&p1=trunk/mapbender/http/php/mod_createJSObjFromDB.php&p2=trunk/mapbender/http/php/mod_createJSObjFromDB.php&r1=304&r2=305
==============================================================================
--- trunk/mapbender/http/php/mod_createJSObjFromDB.php	(original)
+++ trunk/mapbender/http/php/mod_createJSObjFromDB.php	2006-05-16 09:05:04+0000
@@ -21,11 +21,13 @@
 require_once("../../conf/mapbender.conf");
 require_once("../classes/class_wms.php");
 
-$con = db_connect($DBSERVER,$OWNER,$PW);
+$con = db_connect(DBSERVER,OWNER,PW);
 db_select_db(DB,$con);
 
-$sql = "SELECT fkey_wms_id FROM gui_wms WHERE fkey_gui_id = '".$_SESSION["mb_user_gui"]."' ORDER BY gui_wms_position";
-$res = db_query($sql);
+$sql = "SELECT fkey_wms_id FROM gui_wms WHERE fkey_gui_id = $1 ORDER BY gui_wms_position";
+$v = array($_SESSION["mb_user_gui"]);
+$t = array('s');
+$res = db_prep_query($sql,$v,$t);
 $cnt = 0;
 while($row = db_fetch_array($res)){
 	$mywms = new wms();