<table cellpadding="0" cellspacing="0" width='100%'> <tr> <td align="right"> </td> </tr> </table> </div> </form> <?php if (isset($_POST['submit']) || isset($_GET['telefon'])) { if ($telefon != "") { $client = new Client(); $sql = "SELECT * FROM Client WHERE TelefonMobil='{$telefon}' "; $sql = $sql . "OR TelefonFix='{$telefon}' OR TelefonServici='{$telefon}' OR TelefonFax='{$telefon}' "; $clientList = Client::find_by_sql($sql); if (!empty($clientList)) { $client = array_shift($clientList); $agent = User::find_by_id($client->idUtilizator); ?> <div id="DetaliiClient" class="view" onclick="showHide('RandDetalii');" style="cursor:pointer;"> <h3>Detalii client</h3> <table cellspacing="" cellpadding=""> <?php echo put_item($client->full_name(), "Nume"); ?> <?php echo put_item($client->TelefonMobil, "Telefon 1"); ?> <?php echo put_item($client->TelefonFix, "Telefon 2");
/** * this get an auto complete * method on client for the purchase * or orther form */ public function clientID_AutoComplete($id = "") { return Client::find_by_sql("SELECT * FROM tbl_client WHERE name LIKE '%" . $_POST['input'] . "%'"); }
<?php if (isset($_POST['submit'])) { ?> <div class="view" align="center" > <h3>Lista clienti gasiti</h3> <table width="100%"> <tr> <td class="header" style="font-weight:bold" width="15%">Nume</td> <td class="header" style="font-weight:bold" width="20%">Telefoane</td> <td class="header" style="font-weight:bold" width="15%">Email</td> <td class="header" style="font-weight:bold" width="35%">Adresa</td> <td class="header" style="font-weight:bold" width="15%">Agent</td> </tr> <?php $sql = "SELECT * FROM Client WHERE Nume LIKE '%" . $nume . "%' OR Prenume LIKE '%" . $nume . "%'"; $clienti = Client::find_by_sql($sql); if (!empty($clienti)) { $i = 0; foreach ($clienti as $client) { $i++; $class = $i % 2 ? "impar" : "par"; ?> <tr id="<?php echo $client->id; ?> " class="<?php echo $class; ?> " style="cursor:pointer;height:30px;font-weight:bold;" ondblclick="document.location='client_view.php?id=<?php echo $client->id; ?>