PHP FoxFWbdd::bdd Examples

Example #1

File: Controller_contacts.php Project: Elrenardo/FoxFWcms-4

    public function search()
    {
        $groupe = '';
        if (isset($_POST['groupe'])) {
            $groupe = 'AND groupe=\'' . $_POST['groupe'] . '\'';
        }
        $search = $_POST['search'];
        //préparation de la structure
        $list = FoxFWbdd::sql('SELECT * FROM contacts WHERE
		(( nom LIKE ?) OR ( prenom LIKE ?) OR ( telfixe LIKE ?) OR ( telportable LIKE ?) OR ( structure LIKE ?) OR ( email LIKE ?)) ' . $groupe, [$search . '%', $search . '%', $search . '%', $search . '%', $search . '%', $search . '%']);
        $list_groupe = FoxFWbdd::bdd('contacts', 'getListValTable', array('table' => 'groupe'));
        if (!isset($list_groupe['groupe'])) {
            $list_groupe['groupe'] = [];
        }
        return $GLOBALS['Twig']->render(FoxFWKernel::getView('contacts_liste'), array('list' => $list, 'groupe' => $list_groupe['groupe']));
    }