PHP Client::query方法代码示例

 /**
  * {@inheritdoc}
  */
 public function query($query)
 {
     $res = parent::query($query);
     // TODO: Change the autogenerated stub
     $res->setSfToPhpConverter($this->getSfToPhpConverter());
     return $res;
 }

function checkMatch()
{
    $email = $_POST['email'] ?: '';
    $prenom = $_POST['prenom'] ?: '';
    $nom = $_POST['nom'] ?: '';
    $ref = $_POST['ref'] ?: '';
    $max_accepted = $_POST['max_accepted'] ?: 5;
    if (strlen($email) == 0 && strlen($prenom) == 0 && strlen($nom) == 0 && strlen($ref) == 0) {
        die('KO');
    }
    $client = new Client();
    $q = "SELECT * FROM {$client->table} WHERE\n            email LIKE '{$email}%'\n            AND prenom LIKE '{$prenom}%'\n            AND nom LIKE '{$nom}%'\n            AND ref LIKE '{$ref}%'\n        ";
    $r = $client->query($q);
    if ($client->num_rows($r) == 0) {
        die('KO');
    }
    if ($client->num_rows($r) > $max_accepted) {
        die('TOO_MUCH:' . $client->num_rows($r));
    }
    $retour = array();
    while ($r && ($a = $client->fetch_object($r, 'Client'))) {
        $retour[] = array("ref" => $a->ref, "email" => $a->email, "raison" => $a->raison, "entreprise" => $a->entreprise, "nom" => $a->nom, "prenom" => $a->prenom, "adresse1" => $a->adresse1, "adresse2" => $a->adresse2, "adresse3" => $a->adresse3, "cpostal" => $a->cpostal, "ville" => $a->ville, "pays" => $a->pays, "tel" => $a->tel, "pourcentage" => $a->pourcentage);
    }
    die(json_encode($retour));
}

 public function createWalletUser($username, $password, $email, $token)
 {
     $walletClient = new Client(null, null, $this->walletApiUrl);
     $keys = $this->getUserKeys($username, $password, array('wallet', 'api', 'key'));
     $account = array('token' => $token, 'username' => $username, 'email' => $email, 'country' => '', 'timezone' => '', 'keys' => array('wallet' => $keys['wallet']['private'], 'api' => Crypto::signData($keys['api']['private']), 'key' => Crypto::signData($keys['key']['private'])));
     $result = $walletClient->query('user/create', 'POST', $account, false);
     return $result;
 }

 function multiquery()
 {
     $result = array();
     if (count($this->calls)) {
         $result = parent::query('system.multicall', $this->calls);
         $this->calls = array();
         // reset for next calls
     }
     return $result;
 }

function liste_clients($order, $critere, $debut)
{
    $i = 0;
    $client = new Client();
    $query = "select * from {$client->table} order by {$critere} {$order} limit {$debut},20";
    $resul = $client->query($query);
    while ($resul && ($row = $client->fetch_object($resul))) {
        $fond = "ligne_" . ($i++ % 2 ? "claire" : "fonce") . "_rub";
        $commande = new Commande();
        $devise = new Devise();
        $querycom = "select id from {$commande->table} where client={$row->id} and statut not in(" . Commande::NONPAYE . "," . Commande::ANNULE . ") order by date DESC limit 0,1";
        $resulcom = $commande->query($querycom);
        $existe = 0;
        if ($commande->num_rows($resulcom) > 0) {
            $existe = 1;
            $idcom = $commande->get_result($resulcom, 0, "id");
            $commande->charger($idcom);
            $devise->charger($commande->devise);
            $date = strftime("%d/%m/%y %H:%M:%S", strtotime($commande->date));
        }
        $creation = strftime("%d/%m/%y %H:%M:%S", strtotime($row->datecrea));
        ?>
<ul class="<?php 
        echo $fond;
        ?>
">
	<li style="width:122px;"><?php 
        echo $row->ref;
        ?>
</li>
	<li style="width:110px;"><?php 
        echo $creation;
        ?>
</li>
	<li style="width:143px;"><?php 
        echo $row->entreprise;
        ?>
</li>
	<li style="width:243px;"><?php 
        echo $row->nom;
        ?>
 <?php 
        echo $row->prenom;
        ?>
</li>
	<li style="width:110px;"><?php 
        if ($existe) {
            echo $date;
        }
        ?>
</li>
	<li style="width:63px;"><?php 
        if ($existe) {
            echo formatter_somme($commande->total(true, true)) . ' ' . $devise->symbole;
        }
        ?>
</li>
	<li style="width:40px;"><a href="client_visualiser.php?ref=<?php 
        echo $row->ref;
        ?>
" class="txt_vert_11"><?php 
        echo trad('editer', 'admin');
        ?>
</a></li>
	<li style="width:25px; text-align:center;"><a href="#" onclick="confirmSupp('<?php 
        echo $row->ref;
        ?>
')"><img src="gfx/supprimer.gif" width="9" height="9" border="0" /></a></li>
</ul>
<?php 
    }
}

                                <th><?php 
echo trad('PRENOM', 'admin');
?>
</th>
                                <th><?php 
echo trad('EMAIL', 'admin');
?>
</th>
                                <td></td>
                            </tr>
                        </thead>
                        <tbody>
<?php 
$listepar = new Client();
$query = "SELECT * FROM " . Client::TABLE . " WHERE parrain='" . $client->id . "' ORDER BY id ASC";
$resul = $listepar->query($query);
while ($resul && ($filleul = $listepar->fetch_object($resul, 'Client'))) {
    ?>
                            <tr>
                                <td><?php 
    echo $filleul->nom;
    ?>
</td>
                                <td><?php 
    echo $filleul->prenom;
    ?>
</td>
                                <td><?php 
    echo $filleul->email;
    ?>
</td>

 public function query()
 {
     // Prepare multicall, then call the parent::query() method
     return parent::query('system.multicall', $this->calls);
 }