<?php require_once('Connections/cnxvincentdistant.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
}if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "analyse")) {
  $insertSQL = sprintf("INSERT INTO analyserosvin (nom, telephone, adresse, ville, anneeconst, revenusmens, taxes, electricite, chauffage, assurances, remarques, courriel) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['nom'], "text"),
                       GetSQLValueString($_POST['telephone'], "text"),
                       GetSQLValueString($_POST['adresse'], "text"),
                       GetSQLValueString($_POST['ville'], "text"),
                       GetSQLValueString($_POST['anneeconst'], "int"),
                       GetSQLValueString($_POST['revenusmens'], "int"),
                       GetSQLValueString($_POST['taxes'], "int"),
                       GetSQLValueString($_POST['electricite'], "int"),
                       GetSQLValueString($_POST['chauffage'], "int"),
                       GetSQLValueString($_POST['assurances'], "int"),
                       GetSQLValueString($_POST['remarques'], "text"),
                       GetSQLValueString($_POST['courriel'], "text"));

  mysql_select_db($database_cnxvincentdistant, $cnxvincentdistant);
  $Result1 = mysql_query($insertSQL, $cnxvincentdistant) or die(mysql_error());

  $insertGoTo = "index.html";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_cnxvincentdistant, $cnxvincentdistant);
$query_rqanalyse = "SELECT * FROM analyserosvin";
$rqanalyse = mysql_query($query_rqanalyse, $cnxvincentdistant) or die(mysql_error());
$row_rqanalyse = mysql_fetch_assoc($rqanalyse);
$totalRows_rqanalyse = mysql_num_rows($rqanalyse);
$query_rqanalyse = "SELECT * FROM analyserosvin";
$rqanalyse = mysql_query($query_rqanalyse, $cnxvincentdistant) or die(mysql_error());
$row_rqanalyse = mysql_fetch_assoc($rqanalyse);
$totalRows_rqanalyse = mysql_num_rows($rqanalyse);
$query_rqanalyse = "SELECT * FROM analyserosvin";
$rqanalyse = mysql_query($query_rqanalyse, $cnxvincentdistant) or die(mysql_error());
$row_rqanalyse = mysql_fetch_assoc($rqanalyse);
$totalRows_rqanalyse = mysql_num_rows($rqanalyse);

$query_rqanalyse = "SELECT * FROM analyserosvin";
$rqanalyse = mysql_query($query_rqanalyse, $cnxvincentdistant) or die(mysql_error());
$row_rqanalyse = mysql_fetch_assoc($rqanalyse);
$totalRows_rqanalyse = mysql_num_rows($rqanalyse);
$query_rqanalyse = "SELECT * FROM analyserosvin";
$rqanalyse = mysql_query($query_rqanalyse, $cnxvincentdistant) or die(mysql_error());
$row_rqanalyse = mysql_fetch_assoc($rqanalyse);
$totalRows_rqanalyse = mysql_num_rows($rqanalyse);

$query_rqanalyse = "SELECT * FROM analyserosvin";
$rqanalyse = mysql_query($query_rqanalyse, $cnxvincentdistant) or die(mysql_error());
$row_rqanalyse = mysql_fetch_assoc($rqanalyse);
$totalRows_rqanalyse = mysql_num_rows($rqanalyse);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><link href="images/favicon.ico" rel="shortcut icon" />
<meta name="description" content="Ce site vous présente les avantages que vous aurez à consulter un courtier immobilier pour acheter ou vendre votre propriété. Voyez les services que peut vous rendre VINCENT ROSELLI." />
<meta name="keywords" content="propriété à revenus, résidentiel, commercial, industriel, investissement," />

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Lac Magog</title>
<link href="styles.css" rel="stylesheet" type="text/css" /><!--[if IE]>
<style type="text/css"> 
/* placer les corrections pour toutes les version d'IE dans ce commentaire conditionnel */
#sidebar1, #sidebar2 { padding-top: 30px; }
#mainContent { zoom: 1; padding-top: 15px; }
/* la propriété propriétaire zoom ci-dessus transmet à IE l'attribut hasLayout nécessaire pour éviter plusieurs bogues */
</style>
<![endif]-->
<script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<script src="SpryAssets/SpryValidationRadio.js" type="text/javascript"></script>
<script src="Scripts/swfobject_modified.js" type="text/javascript"></script>
<link href="SpryAssets/SpryMenuBarVertical.css" rel="stylesheet" type="text/css" />
<link href="SpryAssets/SpryValidationRadio.css" rel="stylesheet" type="text/css" />
<script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-38261126-1']);
  _gaq.push(['_setDomainName', 'vincentroselli.com']);
  _gaq.push(['_setAllowLinker', true]);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>
</head>

<body>
  <a name="haut" id="haut"></a>
  <div id="header">
    <h1>Choisissez votre endroit et faites-moi signe!  </h1></div>
  <div id="sidebar1">
  <ul id="MenuBar1" class="MenuBarVertical">
      <li><a href="index.html" target="_blank">Accueil</a></li>
      <li><a href="acheteurs.html" target="_blank">Acheteurs</a></li>
      <li><a href="aide-memoire.html" target="_blank">Aide-m&eacute;moire</a></li>
      <li><a href="panorama_condo.html" target="_blank" class="MenuBarItemSubmenu">Diaporama</a>
        <ul>
<li><a href="diapo_condo.html" target="_blank">Condo Aux Berges des Pins</a></li>
<li><a href="diapo_cmelbourne.html" target="_blank">Atelier d'artiste</a></li>
<li><a href="diapo_haute_rive.html">Haute-Rive</a></li>
<li><a href="panorama_condo.swf">Visite panoramique</a></li>
        </ul>
      </li>
      <li><a href="a_vendre.html" target="_blank">Mes propri&eacute;t&eacute;s</a></li>
      <li><a href="vendeurs.html" target="_blank">Vendeurs</a></li>
      <li><a href="galerie.html" target="_blank" class="MenuBarItemSubmenu">Galerie</a>
        <ul>
          <li><a href="#" class="MenuBarItemSubmenu">Camille Racicot</a>
            <ul>
              <li><a href="tableaux.html" title="Racicot" target="_blank">Tableaux</a></li>
              <li><a href="sculptures.html" title="Racicot">Sculptures</a></li>
            </ul>
          </li>
          <li><a href="labelle.html" title="Labelle" target="_blank">Fernand Labelle</a></li>
          <li><a href="art_inuit.html" title="Art Inuit" target="_blank">Sculptures Inuit</a></li>
        </ul>
      </li>
</ul>
    <p>&nbsp;</p>
    <p>
      <!-- fin de #sidebar1 -->
    </p>
</div>
  <div id="sidebar2">
    <h1>&nbsp;</h1>
    <h3>Fellow en Immobilier </h3>
    <h3>27 années d'expérience</h3>
    <h3>Diplômé en administration des affaires</h3>
    <h3>Spécialiste en investissement</h3>
    <p>&nbsp;</p>
    <p>
      <!-- fin de #sidebar2 -->
    </p>
</div>
  <div id="mainContent">
  
   
    <form id="analyse" name="analyse" method="POST" action="<?php echo $editFormAction; ?>">
    <table width="100%" border="2" cellspacing="3" cellpadding="3">
    <tr>      </tr>
    <tr>      </tr>
    <tr>      </tr>
    <tr>
      </tr>
    <tr>
      </tr><tr>
        </tr><tr>
          </tr><tr>
            </tr>
      <tr>
      </tr>
      <tr>
      </tr>
      <tr>
      </tr>
      <tr>
      </tr></table>
      <div>
      <p>Pour voir la fiche descriptive: <a href="FicheDescriptive/fiche_724AveParc.pdf" target="_blank">cliquez ici!</a>        
      <p>
      <div><iframe width="560" height="315" src="https://www.youtube.com/embed/n0Hl2Avc7NM" frameborder="0" allowfullscreen></iframe>
  
      
  <br />
          </p>
        <p><b>Secteur Nord</b></p>
      </div>

      <p>      <a href="index.html">retour au site </a>    
      </p>
</p>
    <input type="hidden" name="MM_insert" value="analyse" />
</form>
<p>
  <!-- fin de #mainContent -->
</p></div>
	<!-- Cet élément de suppression doit suivre immédiatement l'élément div #mainContent afin de forcer l'élément div #container à contenir tous les éléments flottants enfants --><br class="clearfloat" />
<div id="footer">
    <p><a href="#haut"><img src="images/fl_haut.gif" width="20" height="15" /></a></p>
  <!-- fin de #footer --></div>
<!-- fin de #container --></div>
<script type="text/javascript">
<!--
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});

</body>
</html>
<?php
mysql_free_result($rqanalyse);
?>
<?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?>
<?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?>


<?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);

mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);

mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);

mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);

mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?><?php
mysql_free_result($rqanalyse);
?>