PHP db_connect::close Examples

Example #1

File: Absence.php Project: roger-jb/edeip

	public static function getById ($id) {
		if (!is_numeric($id)) {
			return false;
		}

		$query = "SELECT * FROM ABSENCE WHERE idAbsence = $id ORDER BY dateDebutAbsence DESC";

		$result = db_connect::query($query);
		if ($result->num_rows ==1) {
			$return = $result->fetch_object('Absence');
			db_connect::close();
			return $return;
		}
		else {
			$result->close();
			return new Absence();
		}
	}

Example #2

File: affectMatiere.php Project: roger-jb/edeip

                                <option value=""></option>
                            </select>
                        </td>
                    </tr>
                    <tr>
                        <td colspan="2">
                            <input type="button" class="submit" id="btAdd" name="ajouter" value="Ajouter">&nbsp;&nbsp;
                            <input type="button" class="submit" id="btDel" name="retirer" value="Retirer">
                        </td>
                    </tr>
                </table>

            </fieldset>
            <fieldset>
                <legend>Liste des matieres de l'&eacute;l&egrave;ve</legend>
                <div id="listeMatiere">

                </div>
            </fieldset>
            <br>
        </div>
        <div style="clear: both"></div>
    </div>
    <?php
    include '../Include/include_footer.php';
    db_connect::close();
    ?>
</div>
<script src="affectMatiere.js"></script>
</body>
</html>