本文整理匯總了PHP中Conexao::prepare方法的典型用法代碼示例。如果您正苦於以下問題：PHP Conexao::prepare方法的具體用法？PHP Conexao::prepare怎麽用？PHP Conexao::prepare使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Conexao的用法示例。
在下文中一共展示了Conexao::prepare方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: delete
function delete($id = null)
{
$sql = "DELETE FROM `user` WHERE id = :id";
$query = Conexao::prepare($sql);
$query->bindValue(":id", $id);
$query->execute();
}示例2: limpaTexto
$query = "UPDATE " . MYSQL_BASE_WORK_FLOW_FLUXO . " SET download = 'S' WHERE id = ?";
$stmt = $conexao->prepare($query);
$stmt->bindValue(1, $id);
if ($stmt->execute()) {
echo '<script language= "JavaScript">close();</script>';
} else {
echo '<script language= "JavaScript">close();</script>';
}
} else {
$documento = limpaTexto($_GET['documento']);
$conexao = new Conexao();
$stmt = $conexao->query("SELECT a.*, a.versao as revisao FROM " . MYSQL_BASE_ARQUIVOS . " a, " . MYSQL_BASE_DOCUMENTOS . " d\r\n\t\t\tWHERE d.id = a.id_documento AND a.principal = 'S' AND a.id_documento=" . $documento . " LIMIT 1");
foreach ($stmt as $item) {
$idDocumento = $item['id_documento'];
$versaoDocumento = $item['versao'];
$file = $item['file'];
$revisao = $item['revisao'];
}
$conexao->__destruct();
//Insrir registro no log de donwloads
$query = "INSERT INTO " . MYSQL_BASE_LOG_DOWNLOAD . " (id, id_usuario, data, revisao, arquivo, ip)";
$query .= "VALUES (NULL, ?, NOW(), ?, ?, ?)";
$stmt = $conexao->prepare($query);
$stmt->bindValue(1, userId());
$stmt->bindValue(2, $revisao);
$stmt->bindValue(3, $file);
$stmt->bindValue(4, getIP());
if ($stmt->execute()) {
echo '<script language= "JavaScript">close();</script>';
}
}