PHP buildOptionsPersonnes Examples

Example #1

File: lieux.php Project: BGCX067/faaa-multifac-svn-to-git

                                            <option value="">Aucun</option>
                                            <?php 
buildOptionsMandataires($_SESSION['values']['box_Mandataire']);
?>
										</select>
									</td>
								</tr>
								<tr>
									<td>
										<!--Locataire-->
										<label for="txt_Locataire">Locataire</label><br />
										<select class="input" name="box_Locataire" id="box_Locataire" onchange="addOption();" data-placeholder="S&eacute;lectionner un locataire" class="chzn-select" tabindex="2">
											<option value=""></option>
                                            <option value="">Aucun</option>
                                            <?php 
buildOptionsPersonnes($_SESSION['values']['box_Locataire']);
?>
										</select>
									</td>
									<td>
										<!--Facturer-->
										<label for="box_Facturer">Facturer<span class="red">*</span></label><br />
										<select class="input" name="box_Facturer" id="box_Facturer" onchange="validate(this.value, this.id);">
										</select><br/>
										<span id="box_FacturerFailed" class="<?php 
echo $_SESSION['errors']['Facturer'];
?>
 red">
											Veuillez choisir une personne &agrave; facturer.
										</span>
									</td>

Example #2

File: validation_required.php Project: BGCX067/faaa-multifac-svn-to-git

		Filtre : <select id="slt_filter" onchange="javascript:filter(this.value);">
			<option value="all">Tout</option>
			<option value="cantine">Cantine</option>
			<option value="etal">Place et Etal</option>
			<option value="amarrage">Amarrage</option>
		</select><br/><br/>
				
				<label for="box_search"><?php 
echo $label;
?>
</label>
				
				<select name="box_search" id="box_search" data-placeholder="S&eacute;lectionner un compte" class="chzn-select" tabindex="2" style="width:450px;">
					<option value=""></option>
					<?php 
buildOptionsPersonnes($_GET['form']);
?>
				</select>
				<button onclick="filter_byclient();">Filtrer par client</button>
		<br/><br/>
		
		<div id="list_validation" style="height:600px;"></div>
		

		
		
<div id="dialog-form" title="Rejeter la facture">
	<p class="validateTips">Le commentaire est obligatoire.</p>

	<form>
	<fieldset>

Example #3

File: conjoint.php Project: BGCX067/faaa-multifac-svn-to-git

<?php

include_once 'config.php';
$id = $_GET["id"];
$output = '<table id="tblconjoint" class="tblform" style="width:100%;">' . '	<thead>' . '		<tr>' . '			<th>Conjoint</th>' . '		</tr>' . '	</thead>' . '	<tbody>' . '		<tr>' . '			<td><label>Sélectionner un conjoint</label><br />' . '<select name="box_conjoint" id="box_conjoint" onchange="validate(this.value, this.id);addOption();" data-placeholder="Affecter &agrave; vide pour supprimer le conjoint" class="chzn-select" tabindex="2">' . '<option value=""></option>';
$output .= buildOptionsPersonnes();
$output .= '</select> <button onclick=affect_conjoint();>Affecter</button>' . '</td>' . '		</tr>' . '		<tr>' . '			<td><label>Conjoint actuel</label><br/>';
$output .= find_conjoint($id);
$output .= '</td>' . '		</tr>' . '	</tbody>' . '</table><br/>';
print $output;
// functions ////////////
function buildOptionsPersonnes()
{
    $mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB);
    $query = "SELECT `clientid`, `clientnom`, `clientprenom`, `clientdatenaissance` FROM `clients` WHERE `clientstatus`='1' ORDER BY `clientnom`";
    $result = $mysqli->query($query);
    while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
        $output .= '<option value="' . $row['clientid'] . '">' . strtoupper($row['clientnom']) . " " . strtoupper($row['clientprenom']) . " - " . date("d/m/Y", strtotime($row['clientdatenaissance'])) . '</option>';
    }
    $mysqli->close();
    return $output;
}
function find_conjoint($id)
{
    $mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB);
    $conjointid = find_conjointid($id);
    $query = "SELECT `clientid`, `clientnom`, `clientprenom`, `clientdatenaissance`,`clientid` FROM `clients` WHERE `clientid`='{$conjointid}'";
    $result = $mysqli->query($query);
    $row = $result->fetch_array(MYSQLI_ASSOC);
    if ($result->num_rows > 0) {
        $output = "<a href='clients.php?hideerrors=1&edit=" . $row['clientid'] . "'>" . strtoupper($row['clientnom']) . " " . strtoupper($row['clientprenom']) . " - " . date("d/m/Y", strtotime($row['clientdatenaissance'])) . "</a>";