本文整理汇总了PHP中prepare函数的典型用法代码示例。如果您正苦于以下问题:PHP prepare函数的具体用法?PHP prepare怎么用?PHP prepare使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了prepare函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: get_user_info_by_id
function get_user_info_by_id($uid)
{
$sql_pre = "SELECT `username` ,`password` FROM `user` WHERE `id` = ?i AND username = ?s LIMIT 1 ";
$array = array('1', "haixiao");
$sql = prepare($sql_pre, $array);
return get_line($sql);
}
开发者ID:doumaomao,项目名称:Lazy-lawyer,代码行数:7,代码来源:user.function.php
示例2: get_master_info
function get_master_info($username)
{
$sql_pre = "SELECT `username` , `password` FROM `yxy_master` WHERE `username` = ?s";
$array = array($username);
$sql = prepare($sql_pre, $array);
return get_line($sql);
}
开发者ID:doumaomao,项目名称:Lazy-lawyer,代码行数:7,代码来源:app.function.php
示例3: freemed_basic_auth
function freemed_basic_auth()
{
//----- Check for authentication
$headers = getallheaders();
$authed = false;
if (preg_match('/Basic/', $headers['Authorization'])) {
// Parse headers
$tmp = $headers['Authorization'];
$tmp = preg_replace('/ /', '', $tmp);
$tmp = preg_replace('/Basic/', '', $tmp);
$auth = base64_decode(trim($tmp));
list($user, $pass) = explode(':', $auth);
// Check for username/password
$query = "SELECT username, userpassword, userrealphy, id FROM user " . "WHERE username='" . addslashes($user) . "' AND " . "userpassword=MD5('" . addslashes($pass) . "')";
$r = $GLOBALS['sql']->queryRow($query);
if ($r['id']) {
$authed = true;
$GLOBALS['__freemed']['basic_auth_id'] = $r['id'];
$GLOBALS['__freemed']['basic_auth_phy'] = $r['userrealphy'];
} else {
// Clear basic auth id
$authed = false;
$GLOBALS['__freemed']['basic_auth_id'] = 0;
$GLOBALS['__freemed']['basic_auth_phy'] = 0;
}
} else {
// Otherwise return fault for no authorization
Header("WWW-Authenticate: Basic realm=\"" . prepare(PACKAGENAME . " v" . VERSION . " vCalendar") . "\"");
Header("HTTP/1.0 401 Unauthorized");
die;
}
return $authed;
}
开发者ID:rrsc,项目名称:freemed,代码行数:33,代码来源:vcalendar.php
示例4: fetchReplies
/**
* Retrieve all replies to a given thread
*/
private function fetchReplies($board, $thread_id)
{
$query = prepare("SELECT * FROM ``posts_{$board}`` WHERE `thread` = :id");
$query->bindValue(':id', $thread_id, PDO::PARAM_INT);
$query->execute() or error(db_error($query));
return $query->fetchAll(PDO::FETCH_ASSOC);
}
开发者ID:anastiel,项目名称:lainchan,代码行数:10,代码来源:theme.php
示例5: __getWhere
/**
* 过滤条件
*
* @author boxcore
* @date 2014-10-23
* @param array $configs 过滤条件
* @return string
*/
private function __getWhere($configs)
{
$where = 'WHERE TRUE ';
if (isset($configs['need_push'])) {
$where .= prepare('AND `need_push` = ?s ', array($configs['need_push']));
}
if (isset($configs['url'])) {
$where .= prepare('AND `url` = ?s ', array($configs['url']));
}
if (isset($configs['task_list_id'])) {
$where .= prepare('AND `task_list_id` = ?i ', array($configs['task_list_id']));
}
if (isset($configs['type'])) {
$where .= prepare('AND `type` = ?i ', array($configs['type']));
}
if (isset($configs['start_goods_id'])) {
$where .= prepare('AND `goods_id` >= ?i ', array($configs['start_goods_id']));
}
if (isset($configs['price'])) {
if ($configs['price']) {
$where .= 'AND `price` > 0 ';
} else {
$where .= 'AND `price` = 0 ';
}
}
if (isset($configs['date'])) {
$where .= prepare('AND `created_time` >= ?s AND `created_time` <= ?s ', array($configs['date'] . " 00:00:00", $configs['date'] . " 23:59:59"));
}
return $where;
}
开发者ID:boxcore,项目名称:xspider,代码行数:38,代码来源:ContentModel.php
示例6: assignments
function assignments()
{
prepare();
$request = new AssignmentsRequest(ActionType::GET);
$response = $this->roots->assignments($request);
return $response;
}
开发者ID:Bagelllama,项目名称:delphinium,代码行数:7,代码来源:Assignments.php
示例7: get_filecatname
function get_filecatname($catid)
{
$sql_pre = "SELECT `catname` FROM `yxy_filecat` WHERE `id` = ?i";
$array = array($catid);
$sql = prepare($sql_pre, $array);
return get_var($sql);
}
开发者ID:doumaomao,项目名称:Lazy-lawyer,代码行数:7,代码来源:default.function.php
示例8: show_timeSheetItems
function show_timeSheetItems($template_name)
{
global $date_to_view;
$current_user =& singleton("current_user");
global $TPL;
$query = prepare("SELECT * \n FROM timeSheetItem \n LEFT JOIN timeSheet ON timeSheetItem.timeSheetID = timeSheet.timeSheetID\n LEFT JOIN project ON timeSheet.projectID = project.projectID\n WHERE dateTimeSheetItem='%s'\n AND timeSheet.personID=%d", date("Y-m-d", $date_to_view), $current_user->get_id());
$db = new db_alloc();
$db->query($query);
while ($db->next_record()) {
$timeSheetItem = new timeSheetItem();
$timeSheetItem->read_db_record($db);
$timeSheetItem->set_values();
if ($timeSheetItem->get_value("unit") == "Hour") {
$TPL["daily_hours_total"] += $timeSheetItem->get_value("timeSheetItemDuration");
}
$project = new project();
$project->read_db_record($db);
$project->set_values();
if ($project->get_value("projectShortName")) {
$TPL["item_description"] = $project->get_value("projectShortName");
} else {
$TPL["item_description"] = $project->get_value("projectName");
}
include_template($template_name);
}
}
开发者ID:cjbayliss,项目名称:alloc,代码行数:26,代码来源:weeklyTime.php
示例9: choose
function choose()
{
while (list($k, $v) = each($GLOBALS)) {
global ${$k};
}
$collectorid = getcollectorid("advalvas");
$query = "DELETE FROM station " . "WHERE collectorid='" . addslashes($collectorid) . "'";
$sql->query($query);
$query = "DELETE FROM program";
$sql->query($query);
print_header_open();
print_title("Choose Stations for " . $this->MODULE_NAME);
print_header_close();
print "\n <FORM ACTION=\"" . page_name() . "\" METHOD=POST>\n <INPUT TYPE=HIDDEN NAME=\"module\" VALUE=\"" . prepare($module) . "\">\n <TABLE BORDER=0 CELLSPACING=0 CELLPADDING=2>\n <TR BGCOLOR=\"#ccccff\">\n <TD><B>Original Name</B></TD>\n <TD><B>xawtv Name</B></TD>\n <TD><B>Channel</B></TD>\n </TR>\n ";
while (list($name, $value) = each($HTTP_POST_VARS)) {
if ($value == 1) {
$suburl = "?NL&" . $name;
$channel_name = preg_replace("/_/", " ", $name);
$channel_name = preg_replace("/\\|/", "+", $channel_name);
$query = $sql->insert_query("station", array("sname" => $this->transformName($channel_name), "collectorid" => $collectorid, "suburl" => $suburl, "rname" => $this->transformName($channel_name), "channel" => "0"));
$result = $sql->query($query);
$sid = $sql->last_record($result);
print "\n\t\t\t\t<TR>\n\t\t\t\t\t\t<TD>" . prepare($channel_name) . "</TD>\n\t\t\t\t\t\t<TD>\n\t\t\t\t\t\t\t\t<INPUT TYPE=TEXT NAME=\"T" . htmlentities($sid) . "\"\n\t\t\t\t\t\t\t\tVALUE=\"" . prepare($channel_name) . "\">\n\t\t\t\t\t\t</TD>\n\t\t\t\t\t\t<TD>" . html_form::text_widget("C" . htmlentities($sid)) . "</TD>\n\t\t\t\t</TR>\n\t\t\t\t";
}
}
print "</TABLE>\n";
print "<P><INPUT TYPE=SUBMIT NAME=SUBMIT VALUE=\"Update\"></P>\n";
print "</FORM>\n";
print_page_close();
exit;
}
开发者ID:BackupTheBerlios,项目名称:webvcr2,代码行数:31,代码来源:advalvas.collector.module.php
示例10: get_rate
function get_rate($projectID, $personID)
{
// Try to get the person's rate from the following sources:
// project.defaultTimeSheetRate
// person.defaultTimeSheetRate
// config.name == defaultTimeSheetRate
// First check the project for a rate
$project = new project($projectID);
$row = array('rate' => $project->get_value("defaultTimeSheetRate"), 'unit' => $project->get_value("defaultTimeSheetRateUnitID"));
if (imp($row['rate']) && $row['unit']) {
return $row;
}
// Next check person, which is in global currency rather than project currency - conversion required
$db = new db_alloc();
$q = prepare("SELECT defaultTimeSheetRate as rate, defaultTimeSheetRateUnitID as unit FROM person WHERE personID = %d", $personID);
$db->query($q);
$row = $db->row();
if (imp($row['rate']) && $row['unit']) {
if ($project->get_value("currencyTypeID") != config::get_config_item("currency")) {
$row['rate'] = exchangeRate::convert(config::get_config_item("currency"), $row["rate"], $project->get_value("currencyTypeID"));
}
return $row;
}
// Lowest priority: global
$rate = config::get_config_item("defaultTimeSheetRate");
$unit = config::get_config_item("defaultTimeSheetUnit");
if (imp($rate) && $unit) {
if (config::get_config_item("currency") && $project->get_value("currencyTypeID")) {
$rate = exchangeRate::convert(config::get_config_item("currency"), $rate, $project->get_value("currencyTypeID"));
}
return array('rate' => $rate, 'unit' => $unit);
}
}
开发者ID:cjbayliss,项目名称:alloc,代码行数:33,代码来源:projectPerson.inc.php
示例11: show_overdue
function show_overdue($template_name)
{
global $db;
global $TPL;
$current_user =& singleton("current_user");
$db = new db_alloc();
$temp = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
$today = date("Y", $temp) . "-" . date("m", $temp) . "-" . date("d", $temp);
$q = prepare("SELECT itemName,itemType,item.itemID,dateBorrowed,dateToBeReturned,loan.personID \n FROM loan,item \n WHERE dateToBeReturned < '%s' \n\t\t\t\t\t AND dateReturned = '0000-00-00' \n\t\t\t\t\t AND item.itemID = loan.itemID\n ", $today);
if (!have_entity_perm("loan", PERM_READ, $current_user, false)) {
$q .= prepare("AND loan.personID = %d", $current_user->get_id());
}
$db->query($q);
while ($db->next_record()) {
$i++;
$item = new item();
$loan = new loan();
$item->read_db_record($db);
$loan->read_db_record($db);
$item->set_values();
$loan->set_values();
$person = new person();
$person->set_id($loan->get_value("personID"));
$person->select();
$TPL["person"] = $person->get_name();
$TPL["overdue"] = "<a href=\"" . $TPL["url_alloc_item"] . "itemID=" . $item->get_id() . "&return=true\">Overdue!</a>";
include_template($template_name);
}
}
开发者ID:cjbayliss,项目名称:alloc,代码行数:29,代码来源:itemLoan.php
示例12: get_config_item_id
public static function get_config_item_id($name = '')
{
$db = new db_alloc();
$db->query(prepare("SELECT configID FROM config WHERE name = '%s'", $name));
$db->next_record();
return $db->f('configID');
}
开发者ID:cjbayliss,项目名称:alloc,代码行数:7,代码来源:config.inc.php
示例13: show_expenseFormList
function show_expenseFormList($template_name)
{
global $db;
global $TPL;
global $transactionRepeat;
$current_user =& singleton("current_user");
$db = new db_alloc();
$transactionRepeat = new transactionRepeat();
if (!$_GET["tfID"] && !$current_user->have_role("admin")) {
$tfIDs = $current_user->get_tfIDs();
$tfIDs and $sql = prepare("WHERE tfID in (%s)", $tfIDs);
} else {
if ($_GET["tfID"]) {
$sql = prepare("WHERE tfID = %d", $_GET["tfID"]);
}
}
$db->query("select * FROM transactionRepeat " . $sql);
while ($db->next_record()) {
$i++;
$transactionRepeat->read_db_record($db);
$transactionRepeat->set_values();
$TPL["tfName"] = tf::get_name($transactionRepeat->get_value("tfID"));
$TPL["fromTfName"] = tf::get_name($transactionRepeat->get_value("fromTfID"));
include_template($template_name);
}
$TPL["tfID"] = $tfID;
}
开发者ID:cjbayliss,项目名称:alloc,代码行数:27,代码来源:transactionRepeatList.php
示例14: unban
function unban($id)
{
$query = prepare("DELETE FROM `bans` WHERE `id` = :id");
$query->bindValue(':id', $id);
$query->execute() or error(db_error($query));
modLog("Removed ban #{$id}");
}
开发者ID:npfriday,项目名称:Tinyboard,代码行数:7,代码来源:ban.php
示例15: action
public function action()
{
global $board;
switch ($this->action) {
case 'reject':
error(isset($this->message) ? $this->message : 'Posting throttled by flood filter.');
case 'ban':
if (!isset($this->reason)) {
error('The ban action requires a reason.');
}
$reason = $this->reason;
if (isset($this->expires)) {
$expires = time() + $this->expires;
} else {
$expires = 0;
}
// Ban indefinitely
if (isset($this->reject)) {
$reject = $this->reject;
} else {
$reject = true;
}
if (isset($this->all_boards)) {
$all_boards = $this->all_boards;
} else {
$all_boards = false;
}
$query = prepare("INSERT INTO `bans` VALUES (NULL, :ip, :mod, :set, :expires, :reason, :board)");
$query->bindValue(':ip', $_SERVER['REMOTE_ADDR']);
$query->bindValue(':mod', -1);
$query->bindValue(':set', time());
if ($expires) {
$query->bindValue(':expires', $expires);
} else {
$query->bindValue(':expires', null, PDO::PARAM_NULL);
}
if ($reason) {
$query->bindValue(':reason', $reason);
} else {
$query->bindValue(':reason', null, PDO::PARAM_NULL);
}
if ($all_boards) {
$query->bindValue(':board', null, PDO::PARAM_NULL);
} else {
$query->bindValue(':board', $board['uri']);
}
$query->execute() or error(db_error($query));
if ($reject) {
if (isset($this->message)) {
error($message);
}
checkBan($board['uri']);
exit;
}
break;
default:
error('Unknown filter action: ' . $this->action);
}
}
开发者ID:npfriday,项目名称:Tinyboard,代码行数:59,代码来源:filters.php
示例16: nextId
public function nextId($entidade)
{
$query = "SELECT max(id) FROM ? ";
$stmt = prepare($query);
$reg = mysql_fetch_array($this->doSQL($query));
$sequencial = $reg[$max] + 1;
return $sequencial;
}
开发者ID:vagnerbarros,项目名称:anphpf,代码行数:8,代码来源:ConexaoBD.php
示例17: recipients_to_text
function recipients_to_text($recip)
{
$query = "SELECT * FROM user WHERE " . "FIND_IN_SET(id, '" . addslashes($recip) . "')";
$res = $GLOBALS['sql']->queryAll($query);
$a = array();
foreach ($res as $r) {
$a[] = prepare($r['userdescrip']);
}
return join(', ', $a);
}
开发者ID:rrsc,项目名称:freemed,代码行数:10,代码来源:Messages.class.php
示例18: _getWhere
protected function _getWhere($configs)
{
$where = 'WHERE TRUE ';
if (!empty($configs['cid'])) {
$where .= prepare('AND `list_id` = ?i ', array($configs['cid']));
}
if (!empty($configs['date'])) {
$where .= prepare('AND `created_time` >= ?s AND `created_time` <= ?s ', array($configs['date'] . ' 00:00:00', $configs['date'] . ' 23:59:59'));
}
return $where;
}
开发者ID:boxcore,项目名称:xspider,代码行数:11,代码来源:ApiControl.php
示例19: get_roles_array
function get_roles_array($level = "person")
{
$rows = array();
$db = new db_alloc();
$q = prepare("SELECT * FROM role WHERE roleLevel = '%s' ORDER BY roleSequence", $level);
$db->query($q);
while ($row = $db->row()) {
$rows[$row["roleHandle"]] = $row["roleName"];
}
return $rows;
}
开发者ID:cjbayliss,项目名称:alloc,代码行数:11,代码来源:role.inc.php
示例20: sb_thread
function sb_thread($b, $thread, $slugcheck = false)
{
global $config;
$thread = (int) $thread;
if ($thread < 1) {
return false;
}
if (!preg_match('/^' . $config['board_regex'] . '$/u', $b)) {
return false;
}
if (Cache::get("thread_exists_" . $b . "_" . $thread) == "no") {
return false;
}
$query = prepare(sprintf("SELECT MAX(`id`) AS `max` FROM ``posts_%s``", $b));
if (!$query->execute()) {
return false;
}
$s = $query->fetch(PDO::FETCH_ASSOC);
$max = $s['max'];
if ($thread > $max) {
return false;
}
$query = prepare(sprintf("SELECT `id` FROM ``posts_%s`` WHERE `id` = :id AND `thread` IS NULL", $b));
$query->bindValue(':id', $thread);
if (!$query->execute() || !$query->fetch(PDO::FETCH_ASSOC)) {
Cache::set("thread_exists_" . $b . "_" . $thread, "no");
return false;
}
if ($slugcheck && $config['slugify']) {
global $request;
$link = link_for(array("id" => $thread), $slugcheck === 50, array("uri" => $b));
$link = "/" . $b . "/" . $config['dir']['res'] . $link;
if ($link != $request) {
header("Location: {$link}", true, 301);
die;
}
}
if ($slugcheck == 50) {
// Should we really generate +50 page? Maybe there are not enough posts anyway
global $request;
$r = str_replace("+50", "", $request);
$r = substr($r, 1);
// Cut the slash
if (file_exists($r)) {
return false;
}
}
if (!openBoard($b)) {
return false;
}
buildThread($thread);
return true;
}
开发者ID:0151n,项目名称:vichan,代码行数:53,代码来源:smart_build.php
注:本文中的prepare函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论