Untitled

<?php

//------------------------------------------
// GetStoreTable - returns array containing store table
$script_name = "index4.phtml";
function GetStoreTable() {

     // Retrieve store table from MySQL database

      mysql_connect("localhost", "root", "mapserver")
              or die("Could not connect to MySQL server!");

     mysql_select_db("restaurant")
              or die("Could not select database");


     $query = ("SELECT * FROM state4 WHERE (LONG_HI<'".$_POST['Ymax']."')");
     $result = mysql_query($query);

     // save each row of result in an array

     $i = 0;
     while ( $row = mysql_fetch_array($result,MYSQL_NUM) ) {
        $qresult[$i] = $row;
        $i++;
     }

     // return array of results

     return $qresult;

} // end GetStoreTable


//------------------------------------------
// AddPoints - add store locations to 'poi' map layer

function AddPoints ( $map, $qresult ) {

     // Use lat/long info from query results to add points
     // to the points-of-interest layer of the map
     // shape index is set to the store-id
     // (this requires a patched version of Mapscript)

      $this_layer = $map->getLayerByName('poi');

     $i = 0;
     foreach($qresult as $row) {
        $poi[$i] =  ms_newLineObj();
        $shp[$i] = ms_newShapeObj(MS_SHAPE_POLYGON);
        $poi[$i]->addXY($row[5],$row[4]);
		$poi[$i]->addXY($row[3],$row[4]);
		$poi[$i]->addXY($row[3],$row[2]);
		$poi[$i]->addXY($row[5],$row[2]);
		$poi[$i]->addXY($row[5],$row[4]);
        $shp[$i]->add($poi[$i]);
        $shp[$i]->set(index, $row[0]);
        $this_layer->addFeature( $shp[$i] );
		$i++;
     }

     return;
} // end AddPoints


$map = ms_newMapObj("/ms4w/apache/htdocs/india_roads3.map");

// We create the map object based on the mapfile received as parameter


// and set the image size (resolution) based on mapsize parameter
// Update: The map size must be setted before the extent, otherwise the extent
// will be adjusted to the aspect ratio of the map defined on SIZE parameter
// of MAP object in your mapfile

$extent = array(62.786563, 7.392830, 102.765356, 36.151322);

// We get the mapext parameter... split it on its 4 parts using
// the space character as splitter

$qresult = GetStoreTable();
AddPoints( $map, $qresult );


// The next lines are the same as previous mapscript
$img_path = "/ms4w/apache/htdocs";
$image=$map->draw();
$image_url=$image->saveImage("$img_path/test.swf");


?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<link href="style.css" rel="stylesheet" type="text/css" /></head>
<script src="mscross-1.1.8.js" type="text/javascript"></script>
<script type="text/javascript" src="ajaxgold.js"></script>
<script type="text/javascript" src="swfobject.js"></script>
<body>
	<!-- header -->
    <div id="logo"><a href="#">MapServer</div>
    <div id="header">
    	<div id="left_header"></div>
        <div id="right_header"></div>
  </div>

    <!--end header -->
    <!-- main -->
    <div id="content">
    	<div id="content_top">
        	<div id="content_top_left"></div>
            <div id="content_top_right"></div>
        </div>
      <div id="content_body">
       	  <div id="sidebar">
            <div id="sidebar_top"></div>
            <div id="sidebar_body">

  </TD>
              </div>
                <div id="sidebar_bottom"></div>
          </div>
            <div id="text">
            <div id="text_top">
            	<div id="text_top_left"></div>
                <div id="text_top_right"></div>
            </div>
            <div id="text_body">
			<form method=post action="<?php echo $script_name;?>">
<tr><td width="100%" rowspan="6">
        <object id="myId" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" width="640" height="480">

        <param name="movie" value="test.swf" />
        <!--[if !IE]>-->
        <object type="application/x-shockwave-flash" data="test.swf" width="640" height="480" border=7 >
        <!--<![endif]-->
          <p>Alternative content</p>
        <!--[if !IE]>-->
        </object>
        <!--<![endif]-->
      </object>

</td>


 </div>

                <div id="text_bottom">
                	<div id="text_bottom_left"></div>
                    <div id="text_bottom_right"></div>
                </div>
          </div>
      </div>
        <div id="content_bottom">
        	<div id="content_bottom_left"></div>
            <div id="content_bottom_right"></div>
        </div>
    </div>
    <!-- end main -->
    <!-- footer -->
    <div id="footer">
    <div id="left_footer"><table>

		  Xmin<input type="text" name="Xmin" size="15">
	      Ymin<input type="text" name="Ymin" size="15">
		    Xmax<input type="text" name="Xmax" size="15">
			 Ymax<input type="text" name="Ymax" size="15">
	      <input type=SUBMIT name="submit" VALUE="Submit"></td>

</table></div>
    <div id="right_footer">
<img alt="mapserver" title="mapserver" src="images/logo.jpg">
<a onclick="this.target = '_blank';" title="MapServer homepage" href="http://mapserver.org/">
        <img alt="mapserver" title="mapserver" src="images/mapserver.jpg">
		</a>

	<a onclick="this.target = '_blank';" title="mscross homepage" href="http://datacrossing.crs4.it/en_Documentation_mscross.html">
        <img alt="mscross" title="mscross" src="images/logo1.png">
		</a>
    </div>
    </div>
    <!-- end footer -->
	 </form>
</body>
</html>