本文整理汇总了PHP中get_connection函数的典型用法代码示例。如果您正苦于以下问题:PHP get_connection函数的具体用法?PHP get_connection怎么用?PHP get_connection使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了get_connection函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: update_product
function update_product($name, $type, $price, $description, $logo, $id)
{
$db_connection = get_connection();
$query = "UPDATE products SET name='{$name}', type='{$type}', price='{$price}', description='{$description}', logo='{$logo}' WHERE id='{$id}'";
mysqli_query($db_connection, $query);
mysqli_close($db_connection);
}
开发者ID:serhiynikolskiy,项目名称:dvsoft,代码行数:7,代码来源:db.php
示例2: db_query
/**
* Выполняет SQL-запрос (INSERT/UPDATE/DELETE/REPLACE/ALTER/...).
*
* @param string $query SQL-запрос
* @param array $params Список именованных параметров и их значений, например: array(':email' => '[email protected]')
*
* @return int Количество затронутых строк (сколько строк было вставлено или изменено или удалено в таблице)
*/
function db_query($query, $params = array())
{
/** @var PDO $pdo */
$pdo = get_connection();
$statement = $pdo->prepare($query);
$statement->execute($params);
return $statement->rowCount();
}
开发者ID:alpharder,项目名称:learn-ecommerce,代码行数:16,代码来源:db.php
示例3: data_edit_setting
function data_edit_setting($config, $name, $value)
{
// get connection
$conn = get_connection($config);
// create the SQL statement
$sql = "UPDATE setting \n\t\t\tSET Value = '{$value}'\n\t\t\tWHERE name = '{$name}'";
// execute the SQL statement
return mysql_query($sql, $conn) or die(mysql_error());
}
开发者ID:NguyenThanhDung,项目名称:Finance,代码行数:9,代码来源:data_setting.php
示例4: __construct
/**
* PersonaModel constructor.
* @param $persona
*/
public function __construct(Persona $persona = null)
{
if ($persona) {
$this->persona = $persona;
}
$this->connecion = get_connection();
$this->connecion->selectDB("test");
$this->CPersona = $this->connecion->selectCollection("test", "persona");
//selecciona la coleccion
}
开发者ID:jdla1990,项目名称:PhpAngularMongo,代码行数:14,代码来源:persona_model.inc.php
示例5: store_on_temp_table
public function store_on_temp_table()
{
$id_last_trajectory = get_last_id_trajectory();
$connection = get_connection();
$sql_insert_fix = sprintf($this->sql_insert_fix_temp_table, $id_last_trajectory, $this->latitude, $this->longitude, $this->timestamp, $this->accuracy);
$connection->query($sql_insert_fix);
if ($connection->error) {
die('Could not store fix' . $connection->error);
}
$connection->close();
}
开发者ID:s0lver,项目名称:ServerSide-LocalPOI-Experiment,代码行数:11,代码来源:GpsFix.php
示例6: store
public function store()
{
$id_last_trajectory = get_last_id_trajectory();
$sql_insert_staypoint = sprintf($this->sql_insert_staypoint, $id_last_trajectory, $this->latitude, $this->longitude, $this->arrival_time, $this->departure_time, $this->fixes_involved);
$connection = get_connection();
$connection->query($sql_insert_staypoint);
if ($connection->error) {
die('Could not store staypoint' . $connection->error);
}
$connection->close();
}
开发者ID:s0lver,项目名称:ServerSide-LocalPOI-Experiment,代码行数:11,代码来源:Staypoint.php
示例7: dump_query
function dump_query($q, $array = NULL, $tableclass = NULL)
{
$Connection = get_connection();
$s = $Connection->prepare($q);
if (is_null($array)) {
$s->execute();
} else {
$s->execute($array);
}
return dump_result($s, $tableclass);
}
开发者ID:amoschou,项目名称:acet,代码行数:11,代码来源:sqlinteraction.php
示例8: del_user
function del_user($user_id)
{
if (!($db_link = get_connection())) {
return -1;
}
$sql = 'delete from user where id=' . $user_id;
if (mysqli_query($db_link, $sql)) {
mysqli_close($db_link);
return 1;
} else {
mysqli_close($db_link);
return -2;
}
}
开发者ID:EVECP,项目名称:sailing,代码行数:14,代码来源:register.php
示例9: handle_put
function handle_put($conversation)
{
// Note: You can only "consume" the entity once, so if we want it
// as text, and want to refer to it more than once, we should keep
// a reference to that text.
$text = $conversation->entity->getText();
$note = json_decode($text, true);
$connection = get_connection();
try {
add_note($note, $connection);
update_board_timestamp($note, $connection);
} catch (Exception $x) {
$connection->close();
throw $x;
}
$connection->close();
return handle_get($conversation);
}
开发者ID:alanpaulin,项目名称:prudence,代码行数:18,代码来源:default.m.php
示例10: list_users
function list_users()
{
$dbh = get_connection($GLOBALS['db_access_info_daityo']);
if ($dbh == false) {
error_exit("データベースに接続できません。理由: {$php_errormsg}");
} else {
//error_exit("データベースに接続できました。");
}
$sql = "select employeecode, employeenamekana, employeenamekanji, password, categorycode, inoutflag, email" . " from employee" . " where (status <> " . bind_param(1, PRAM_STRING) . ")" . " and categorycode in ('005', '007')" . " and (employeecode <> '998' and employeecode <> '999')" . " order by employeecode";
$res = pg_query($dbh, $sql);
if ($res == false) {
error_exit("SQLの実行に失敗しました。理由: {$php_errormsg}");
} else {
$list = pg_fetch_all($res);
//$list = array();
//while($rc = pg_fetch_array($res)) {
// array_push($list, $rc);
//}
return $list;
}
}
开发者ID:kaoru-t,项目名称:sample,代码行数:21,代码来源:sql_daityo.php
示例11: get_user_data
function get_user_data($id)
{
$year = date('Y', strtotime("+3 months", strtotime(date('Y-m-d'))));
$conn = get_connection();
$r = $conn->query('select u.name name, u.email email, u.year year, un.name universe, u.first_time first_time, u.ready ready, u.admin admin,
l.list list, e.excluded exclusion
from zolken_invisiblefriend.users u
inner join zolken_invisiblefriend.universes un on un.id = u.universe
left join zolken_invisiblefriend.lists l on u.id = l.user and l.year=' . $year . '
left join zolken_invisiblefriend.exclusions e on u.id = e.user and e.year=' . $year . '
where u.id=' . $id . ';');
$json = null;
if ($r && $r->num_rows > 0) {
$row = $r->fetch_array(MYSQLI_ASSOC);
$row['name'] = base64_decode($row['name']);
$row['email'] = base64_decode($row['email']);
$json = json_encode($row);
}
$conn->close();
return $json;
}
开发者ID:zolken,项目名称:InvisibleFriend,代码行数:21,代码来源:mysql_connection.php
示例12: select_from
function select_from($What, $Where, $Array = NULL)
{
$Connection = get_connection();
if (is_null($Array)) {
$Query = "SELECT {$What} FROM {$Where}";
$Statement = $Connection->prepare($Query);
// $Statement->bindValue(':a',$What,PDO::PARAM_STR);
// $Statement->bindValue(':b',$Where,PDO::PARAM_STR);
$Statement->execute();
} else {
$Query = "SELECT {$What} FROM {$Where}";
$Statement = $Connection->prepare($Query);
$Statement->execute($Array);
}
$Row = $Statement->fetch();
$Statement->closeCursor();
if ($Row !== FALSE) {
return $Row[0];
} else {
return NULL;
}
}
开发者ID:amoschou,项目名称:acet,代码行数:22,代码来源:functions.php
示例13: send_welcome_mail
function send_welcome_mail($id)
{
$boundary = "__imafuckinggodbaby";
$eencoded = "";
$epass = "";
$uu = "";
$name = "";
include_once '../mysql_connection.php';
$conn = get_connection();
$res = $conn->query("select u.name,u.email,u.password,un.name uname from zolken_invisiblefriend.users u inner join zolken_invisiblefriend.universes un on un.id = u.universe where u.id=" . $id . ";");
if ($res && $res->num_rows > 0) {
$row = $res->fetch_array(MYSQLI_ASSOC);
$name = base64_decode($row['name']);
$eencoded = $row['email'];
$epass = $row['password'];
$uu = $row['uname'];
} else {
return false;
}
$conn->close();
$header = "From:[email protected]\r\nX-PHP-Script: PHP ztools.tk\r\nContent-Type:multipart/alternative; boundary={$boundary}\r\n\r\n";
$plain = "--{$boundary}\r\nContent-Type:text/plain; charset=\"UTF-8\"\r\nContent-Transfer-Encoding: 8bit\r\n\r\n" . file_get_contents('../../pages/welcome_mail.txt') . "\r\n";
$plain = str_replace('#user#', $name, $plain);
$html = "--{$boundary}\r\nContent-Type:text/html; charset=\"UTF-8\"\r\nContent-Transfer-Encoding: 8bit\r\n\r\n" . file_get_contents('../../pages/welcome_mail.html') . "\r\n";
$html = str_replace('#user#', $name, $html);
$link = "http://www.ztools.tk/php/users/active_user.php?id=" . $id . "&hash=" . md5($eencoded . $epass);
$unsub = "http://www.ztools.tk/php/users/unsub_user.php?id=" . $id . "&hash=" . md5($eencoded . $epass);
$plain = str_replace('#universe#', $uu, $plain);
$plain = str_replace('#link#', $link, $plain);
$plain = str_replace('#unsub#', $unsub, $plain);
$html = str_replace('#universe#', $uu, $html);
$html = str_replace('#link#', $link, $html);
$html = str_replace('#unsub#', $unsub, $html);
$rew = 5;
while (!mail(base64_decode($eencoded), "Correu de confirmació", $plain . $html, $header) && $rew > 0) {
$rew--;
}
return $rew > 0;
}
开发者ID:zolken,项目名称:InvisibleFriend,代码行数:39,代码来源:transactional_mail.php
示例14: send_mail
function send_mail($rem, $rew)
{
global $year;
$conn = get_connection();
if ($conn->multi_query("select u.name name1, u.email email\n\t\t\t\t\t from zolken_invisiblefriend.users u\n where u.id=" . $rem . ";\n\t\t\t\t\t select u.id id2, u.name name2,l.list\n\t\t\t\t\t from zolken_invisiblefriend.users u\n\t\t\t\t\t left join zolken_invisiblefriend.lists l on l.user = u.id\n\t\t\t\t\t where u.id=" . $rew . ";")) {
if ($result = $conn->store_result()) {
$info1 = $result->fetch_array(MYSQLI_ASSOC);
} else {
return false;
}
$conn->next_result();
if ($result = $conn->store_result()) {
$info2 = $result->fetch_array(MYSQLI_ASSOC);
} else {
return false;
}
} else {
return false;
}
send_raffle_mail(base64_decode($info1['email']), base64_decode($info1['name1']), base64_decode($info2['name2']), $info2['id2'], str_replace(';', '\\n', $info2['list']));
$conn->close();
return true;
}
开发者ID:zolken,项目名称:InvisibleFriend,代码行数:23,代码来源:raffle.php
示例15: define
<?php
define("ROOT", "../..");
require ROOT . "/libs/lib_list.php";
$f = array('deletar_cliente' => function () {
$dao = new ClienteDAO(get_connection());
$dao->deletar_cliente($_GET['cod_cliente']);
Header("Location: listar.php?alert=success");
});
$f[$_GET['f']]();
开发者ID:ATSDevelopment,项目名称:ats_system,代码行数:10,代码来源:dao.php
示例16: dirname
require_once dirname(__FILE__) . '/helpers.php';
// Params
$map = get_map_path(@$_REQUEST['map']);
// Name of the layer to query
$layername = @$_REQUEST['layer'];
// Field name from where unique values are read
$field = @$_REQUEST['field'];
if (!$field) {
err500('field parameter missing');
}
// Get project
$project = get_project($map);
// Get layer
$layer = get_layer($layername, $project);
try {
$dbh = get_connection($layer, $project, $map);
$ds_parms = get_layer_info($layer, $project);
$_field = preg_replace('/[^A-z0-9_-]]/', '', $field);
$stmt = $dbh->prepare("SELECT DISTINCT {$_field} FROM {$ds_parms['table']} ORDER BY {$_field}");
$stmt->execute();
while ($row = $stmt->fetchColumn()) {
$result[] = $row;
}
$json_result = json_encode($result);
header('Content-type: application/json');
header('Content-length: ' . strlen($json_result));
echo $json_result;
exit;
} catch (PDOException $e) {
err500('db error: ' . $e->getMessage());
}
开发者ID:cseresznye,项目名称:QGIS-Web-Client,代码行数:31,代码来源:unique_list.php
示例17: session_start
session_start();
if (isset($_SESSION['login_user'])) {
# echo 'You are Logged as '.$_SESSION['login_user'].'<br/>';
include 'header1.php';
} else {
include 'header.php';
}
if (isset($_GET['action'])) {
$action = $_GET['action'];
} else {
$action = 'list';
}
if (!isset($db)) {
require 'dbconnect.php';
$db = get_connection();
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Movies</title>
<link rel="stylesheet" href="main.css">
</head>
<body>
开发者ID:bgmop,项目名称:Archive5,代码行数:28,代码来源:movies.php
示例18: check_authentification
function check_authentification()
{
global $query, $db, $logged_in, $user_id, $user_email, $user_row;
$userdata = (string) base64_decode($query[0]);
$logged_in = false;
$found = false;
if (!$found) {
if ($userdata[7] == ":") {
foreach ($query as $i => $value) {
if ($i > 0) {
$query[$i - 1] = $value;
}
}
unset($query[count($query) - 1]);
$user = substr($userdata, 0, 7);
$password = substr($userdata, 8);
$found = true;
}
}
if (!$found) {
if (isset($_SERVER['PHP_AUTH_USER'])) {
$user = $_SERVER["PHP_AUTH_USER"];
$password = $_SERVER["PHP_AUTH_PW"];
$found = true;
}
}
if (!$found) {
return false;
}
get_connection();
$slt_user_a = "SELECT * FROM user WHERE id_string = '{$user}'";
$rlt_user_a = mysql_query($slt_user_a);
if (mysql_num_rows($rlt_user_a) == 1) {
$row_user_a = mysql_fetch_assoc($rlt_user_a);
$hash = "";
if ($row_user_a["actu"] == "") {
if ($row_user_a["hash_mode"] == "a") {
$iterations = 100000;
$salt = $row_user_a["hash_salt"];
$hash = $password . $salt;
for ($i = 0; $i < $iterations; $i++) {
$hash = sha1($password . $salt);
}
}
if ($row_user_a["hash_mode"] == "b") {
$iterations = 100000;
$salt = $row_user_a["hash_salt"];
$hash = $password . $salt;
for ($i = 0; $i < $iterations; $i++) {
$hash = sha1($hash . $password . $salt);
}
}
if ($row_user_a["hashed_password"] == $hash) {
$logged_in = true;
$user_id = $row_user_a["id"];
$user_email = $row_user_a["email"];
$user_row = $row_user_a;
return true;
}
}
}
return false;
}
开发者ID:rhartness,项目名称:slc24,代码行数:63,代码来源:api.php
示例19: mysqli_fetch_assoc
if ($res = mysqli_query($link['link'], "SELECT * FROM test_mysqli_poll_mixing_insert_select_table_1 WHERE id = 100")) {
$row = mysqli_fetch_assoc($res);
var_dumtest_mysqli_poll_mixing_insert_select_procedure_1($row);
mysqli_free_result($res);
}
if ($have_proc && ($res = mysqli_query($link['link'], "SELECT @version as _version"))) {
$row = mysqli_fetch_assoc($res);
if ($row['_version'] != 'myversion') {
printf("[007] Check procedures\n");
}
mysqli_free_result($res);
}
foreach ($links as $link) {
mysqli_close($link['link']);
}
$link = get_connection();
if (!mysqli_query($link, 'SELECT 1', MYSQLI_ASYNC)) {
printf("[008] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
if (!mysqli_query($link, 'SELECT 1', MYSQLI_ASYNC)) {
printf("[009] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
mysqli_close($link);
print "done!";
require_once "connect.inc";
if (!($link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))) {
printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
}
if (!mysqli_query($link, "DROP TABLE IF EXISTS test_mysqli_poll_mixing_insert_select_table_1")) {
printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
开发者ID:badlamer,项目名称:hhvm,代码行数:31,代码来源:mysqli_poll_mixing_insert_select.php
示例20: count
//some code...
exit;
}
$sql_comment = 'select count(id) from comment where subject_id=' . $subject['id'];
if ($res_comment = mysqli_query($db_link_comment, $sql_comment)) {
if ($datarow_comment = mysqli_fetch_array($res_comment)) {
$subject['comments_count'] = $datarow_comment[0];
}
mysqli_free_result($res_comment);
mysqli_close($db_link_comment);
} else {
//some code...
mysqli_close($db_link_comment);
}
if (isset($_SESSION['user'])) {
if (!($db_link_subject_vote = get_connection())) {
//some code...
exit;
}
$sql_subject_vote = 'select vote from subject_vote where subject_id=' . $subject['id'] . ' and user_id=' . $_SESSION['user'];
if ($res_subject_vote = mysqli_query($db_link_subject_vote, $sql_subject_vote)) {
if ($datarow_subject_vote = mysqli_fetch_array($res_subject_vote)) {
$subject['vote'] = $datarow_subject_vote['vote'];
}
mysqli_free_result($res_subject_vote);
mysqli_close($db_link_subject_vote);
} else {
mysqli_close($db_link_subject_vote);
//some code...
exit;
}
开发者ID:EVECP,项目名称:sailing,代码行数:31,代码来源:index.php
注:本文中的get_connection函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论