本文整理汇总了PHP中pg_escape_literal函数的典型用法代码示例。如果您正苦于以下问题:PHP pg_escape_literal函数的具体用法?PHP pg_escape_literal怎么用?PHP pg_escape_literal使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了pg_escape_literal函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: escapeString
function escapeString($string)
{
self::connect();
if (version_compare(PHP_VERSION, "5.2", "<")) {
return "'" . pg_escape_string($string) . "'";
} else {
if (version_compare(PHP_VERSION, "5.4", "<")) {
return "'" . pg_escape_string($this->connection, $string) . "'";
} else {
return pg_escape_literal($this->connection, $string);
}
}
}
开发者ID:rgigger,项目名称:zinc,代码行数:13,代码来源:DbPgsql.php
示例2: addItemToDB
function addItemToDB($name, $description, $price, $picture = "", $seller = "", $status = 'For sale')
{
$name = pg_escape_literal($name);
$description = pg_escape_literal($description);
$picture = pg_escape_literal($picture);
$seller = pg_escape_literal($seller);
$status = pg_escape_literal($status);
$price = floatval($price);
$query = 'INSERT INTO "items" (name,description,picture,seller,status,price) VALUES (' . "{$name},{$description},{$picture},{$seller},{$status},{$price}) RETURNING id;";
$id = runQuery($query);
runQuery('UPDATE "items" SET postlink = \'/item.php?id=' . $id[0]['id'] . '\' WHERE id = ' . $id[0]['id']);
return $id;
}
开发者ID:mjparangot,项目名称:GTthriftshop,代码行数:13,代码来源:__database.php
示例3: esc
public function esc($data, $mode = self::STRING)
{
switch ($mode) {
case "literal":
$data = pg_escape_literal($this->connection, $data);
break;
case "bytea":
$data = pg_escape_bytea($this->connection, $data);
break;
default:
$data = pg_escape_string($this->connection, $data);
break;
}
return $data;
}
开发者ID:jankovacs,项目名称:php-legs,代码行数:15,代码来源:PostgreSQL.php
示例4: setPassword
private function setPassword($password)
{
# Check dependencies
self::dependencies(isset($this->albumIDs));
if (strlen($password) > 0) {
# Get hashed password
$password = getHashedString($password);
# Set hashed password
# Do not prepare $password because it is hashed and save
# Preparing (escaping) the password would destroy the hash
$sql = "UPDATE albums SET password = " . pg_escape_literal($password) . " WHERE id = " . intval($this->albumIDs);
pg_query($db, $sql);
} else {
$sql = "UPDATE albums SET password = NULL WHERE id = " . intval($this->albumIDs);
pg_query($db, $sql);
}
return true;
}
开发者ID:waitman,项目名称:Lychee,代码行数:18,代码来源:Album.php
示例5: escape_literal
function escape_literal($value)
{
if ($value === NULL) {
return "NULL";
}
if ($value === FALSE) {
return "FALSE";
}
if ($value === TRUE) {
return "TRUE";
}
return pg_escape_literal($value);
}
开发者ID:Chiru,项目名称:RADE,代码行数:13,代码来源:Server.php
示例6: pg_fetch_row
$regmsg = "An error occurred with the database.\n";
} else {
$insrow = pg_fetch_row($insert);
$_SESSION["managerID"] = $insrow[0];
smartRedirect("tasks.php");
}
}
} else {
$regmsg = "One or more of your inputs were incorrect!";
}
}
if (isset($_POST["signin"])) {
$emailsign = $_POST["emailsign"];
$passsign = $_POST["passsign"];
if (filter_var($emailsign, FILTER_VALIDATE_EMAIL) !== false && preg_match("[a-zA-Z0-9@#\$%^&*_-!?<>]", $passsign) !== false) {
$filtemailsign = pg_escape_literal($emailsign);
$select = pg_query($db, "SELECT id,email,password FROM managers where email={$filtemailsign}");
if (!$select) {
$signmsg = "An error occurred with the database.";
}
if ($row = pg_fetch_row($select)) {
if (password_verify($passsign, $row[2]) !== false) {
$_SESSION["managerID"] = $row[0];
smartRedirect("tasks.php");
} else {
$signmsg = "Wrong password of manager!";
}
} else {
$signmsg = "No manager with such name exists!";
}
} else {
开发者ID:BartekJan,项目名称:Tasker,代码行数:31,代码来源:index.php
示例7: elseif
if ($data === pg_unescape_bytea($row['bin'])) {
echo "pg_escape_bytea() actually works with database\n";
break;
} elseif (!$i) {
// Force bytea escaping and retry
@pg_query($db, "SET bytea_output = 'escape'");
} else {
$result = pg_query($db, $sql);
echo "pg_escape_bytea() is broken\n";
break;
}
}
// pg_escape_literal/pg_escape_identifier
$before = "ABC\\ABC\\'";
$expect = " E'ABC\\\\ABC\\\\'''";
$after = pg_escape_literal($before);
if ($expect === $after) {
echo "pg_escape_literal() is Ok\n";
} else {
echo "pg_escape_literal() is NOT Ok\n";
var_dump($before);
var_dump($after);
var_dump($expect);
}
$before = "ABC\\ABC\\'";
$expect = "\"ABC\\ABC\\'\"";
$after = pg_escape_identifier($before);
if ($expect === $after) {
echo "pg_escape_identifier() is Ok\n";
} else {
echo "pg_escape_identifier() is NOT Ok\n";
开发者ID:badlamer,项目名称:hhvm,代码行数:31,代码来源:08escape.php
示例8: escape
/**
* "Smart" Escape String
*
* Escapes data based on type
*
* @param string $str
* @return mixed
*/
public function escape($str)
{
if (is_php('5.4.4') && (is_string($str) or is_object($str) && method_exists($str, '__toString'))) {
return pg_escape_literal($this->conn_id, $str);
} elseif (is_bool($str)) {
return $str ? 'TRUE' : 'FALSE';
}
return parent::escape($str);
}
开发者ID:jimok82,项目名称:CIOpenReview,代码行数:17,代码来源:postgre_driver.php
示例9: escapeLiteral
/**
* @param string $literal
*
* @return string
*/
public function escapeLiteral($literal)
{
return pg_escape_literal($this->handler, $literal);
}
开发者ID:phn-io,项目名称:dal,代码行数:9,代码来源:Connection.php
示例10: instr
/**
* Escape strings array
* @param array $array
* @return string
*/
public function instr(array $array)
{
$array = array_map(function ($value) {
return pg_escape_literal((string) $value);
}, $array);
return sprintf('(%s)', implode(',', $array));
}
开发者ID:un0topface,项目名称:Connection,代码行数:12,代码来源:QueryTemplate.php
示例11: insert
public function insert($tablename, array $record)
{
assert(is_string($tablename));
assert(strlen($tablename) > 0);
$columns = "";
$values = "";
// Early exit when creating a row with all default values
if (count($record) == 0) {
return $this->query('INSERT INTO ' . pg_escape_identifier($tablename) . ' DEFAULT VALUES');
}
foreach ($record as $key => $field) {
$columns .= ',' . pg_escape_identifier($key);
if (is_null($field)) {
$values .= ',NULL';
} else {
//if (is_string($field))
//{
// $values .= ',' . pg_escape_literal($field);
//}
//else
if (is_bool($field)) {
// Check for boolean and convert to SQL true or false
if ($field) {
$values .= ',true';
} else {
$values .= ',false';
}
} else {
if (is_array($field)) {
throw new DatabaseException('Insert can not handle array types');
} else {
$values .= ',' . pg_escape_literal($field);
}
}
}
}
$columns = substr($columns, 1);
// chop first ','
$values = substr($values, 1);
$result = $this->query('INSERT INTO ' . pg_escape_identifier($tablename) . ' (' . $columns . ') VALUES (' . $values . ')');
if ($result->affected_rows() != 1) {
throw new DatabaseException('Expected a single row inserted');
}
return $result;
}
开发者ID:sandyman,项目名称:postgres-dbal,代码行数:45,代码来源:DatabaseRawConnection.php
示例12: escape
function escape($string)
{
return pg_escape_literal($string);
}
开发者ID:snowjobgit,项目名称:limb,代码行数:4,代码来源:lmbPgsqlConnection.class.php
示例13: pg_escape_literal
} else {
$editmsg = "One or more of your inputs were incorrect!";
}
}
// Code to add a task
if (isset($_POST["addLink"])) {
$addcheck = 0;
$addtitle = $_POST["addtitle"];
$addmember = $_POST["addmem"];
$addstart = $_POST["addstart"];
$addend = $_POST["addend"];
if (preg_match("[a-zA-Z- ]", $addtitle) !== false && $_POST["addend"] > $_POST["addstart"]) {
$filttitle = pg_escape_literal($addtitle);
$filtstart = pg_escape_literal($addstart);
$filtend = pg_escape_literal($addend);
$filtmem = pg_escape_literal($addmember);
$select = pg_query($db, "SELECT title FROM tasks where title={$filttitle}");
if ($row = pg_fetch_row($select)) {
$addmsg = "Task with that title already exists";
} else {
$addcheck = 1;
$insert = pg_query($db, "INSERT into tasks (title,startdate,enddate,status) \n\t\t\t\tVALUES ({$filttitle},{$filtstart},{$filtend}, 1) RETURNING id");
$insrow = pg_fetch_row($insert);
$insert = pg_query($db, "INSERT into taskmembers (task_id,member_id) \n\t\t\t\tVALUES ('{$insrow['0']}',{$filtmem})");
$addmsg = "Task added successfully";
}
} else {
$addmsg = "One or more of your inputs were incorrect!";
}
}
echo '<div class="mid">';
开发者ID:BartekJan,项目名称:Tasker,代码行数:31,代码来源:tasks.php
示例14: pg_escape_literal
<?php
include 'assets/class.php';
$news_id = pg_escape_literal($_GET['news_id']);
// Not yet implemented in Cobol back-end
// pg_query("DELETE FROM tbl_news WHERE news_id = $news_id LIMIT 1");
$Success->set("Emma, Jessica, Peter och Bertil");
header('location: index.php');
开发者ID:hanselmahlaola,项目名称:openjensen,代码行数:8,代码来源:index.delete.php
示例15: prepareQuery
protected function prepareQuery($query, $params)
{
if (!is_array($params)) {
return $query;
}
reset($params);
$this->modifyQuery($query, function ($part) use(&$params) {
$newPart = "";
while ($pos = strpos($part, "?")) {
$newPart .= substr($part, 0, $pos);
$part = substr($part, $pos + 1);
$value = current($params);
next($params);
switch (gettype($value)) {
case "boolean":
$value = (int) $value;
break;
case "integer":
case "double":
break;
case "NULL":
$value = "NULL";
break;
default:
switch ($this->mode) {
case "mysql":
$value = $this->server->real_escape_string($value);
break;
case "postgres":
case "redshift":
$value = pg_escape_literal($this->server, $value);
break;
case "sqlite":
$value = $this->server->escapeString($value);
break;
case "mssql":
case "odbc":
$value = str_replace("'", "''", $value);
break;
}
# Postgres does it's own quoting
if (!in_array($this->mode, ["postgres", "redshift"], true)) {
$value = "'" . $value . "'";
}
break;
}
$newPart .= $value;
}
return $newPart . $part;
});
return $query;
}
开发者ID:duncan3dc,项目名称:sql-class,代码行数:52,代码来源:Sql.php
示例16: delete
public function delete()
{
# Functions deletes a photo with all its data and files
# Returns the following:
# (boolean) true = Success
# (boolean) false = Failure
# Check dependencies
self::dependencies(isset($this->photoIDs));
# Get photos
$sql = "SELECT id, url, thumbUrl, checksum FROM photos WHERE id IN (" . $this->photoIDs . ")";
$res = pg_query($db, $sql);
while ($photo = pg_fetch_array($res)) {
if ($this->exists($photo['checksum'], $photo['id']) === false) {
# Get retina thumb url
$thumbUrl2x = explode(".", $photo['thumbUrl']);
$thumbUrl2x = $thumbUrl2x[0] . '@2x.' . $thumbUrl2x[1];
# Delete big
if (file_exists(LYCHEE_UPLOADS_BIG . $photo['url']) && !unlink(LYCHEE_UPLOADS_BIG . $photo['url'])) {
return false;
}
# Delete medium
if (file_exists(LYCHEE_UPLOADS_MEDIUM . $photo['url']) && !unlink(LYCHEE_UPLOADS_MEDIUM . $photo['url'])) {
return false;
}
# Delete thumb
if (file_exists(LYCHEE_UPLOADS_THUMB . $photo['thumbUrl']) && !unlink(LYCHEE_UPLOADS_THUMB . $photo['thumbUrl'])) {
return false;
}
# Delete thumb@2x
if (file_exists(LYCHEE_UPLOADS_THUMB . $thumbUrl2x) && !unlink(LYCHEE_UPLOADS_THUMB . $thumbUrl2x)) {
return false;
}
}
# Delete db entry
$sql = "DELETE FROM photos WHERE id = " . pg_escape_literal($photo->id);
pg_query($db, $sql);
}
pg_free_result($res);
return true;
}
开发者ID:waitman,项目名称:Lychee,代码行数:40,代码来源:Photo.php
示例17: curl_setopt
curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
//execute post
$result = curl_exec($ch);
if ($result === false) {
$Error->set("Kan ej kontakta servern: {$url}");
}
// We dont really know status (TODO implement)
$Success->set("Betyget har nu ändrats.");
//close connection
curl_close($ch);
// move back to main course page to re-read change
header('location: course.php');
}
}
} elseif ($function == "addNews") {
$news_title = pg_escape_literal($_POST['news_title']);
$news_content = pg_escape_literal($_POST['news_content']);
$news_author = pg_escape_literal($_SESSION['user_id']);
if (empty($news_author) or empty($news_content) or empty($news_title)) {
$Error->set("Fyll i alla fält.");
header('location: index.create.php');
} else {
// Not yet converted to Cobol back-end
$date = date('Y-m-d');
// pg_query("INSERT INTO tbl_news (news_title, news_content, news_author, news_date) VALUES ('".$news_title."', '".$news_content."', '".$news_author."', '".$date."')") or die(pg_last_error());
// $Success->set("Nyheten har skapats.");
header('location: index.php');
}
} else {
header('location: /index.php');
}
开发者ID:hanselmahlaola,项目名称:openjensen,代码行数:31,代码来源:process.php
示例18: quoteString
public function quoteString($value)
{
if (function_exists('pg_escape_literal')) {
return pg_escape_literal($this->dbConn, $value);
} else {
return "'" . $this->escapeString($value) . "'";
}
}
开发者ID:helpfulrobot,项目名称:silverstripe-postgresql,代码行数:8,代码来源:PostgreSQLConnector.php
示例19: pg_escape_literal
<?php
include "assets/_header.php";
?>
<a href="users.php"><span class="label label-default">Tillbaka</span></a>
<?php
// $user_id = mysql_escape_string($_GET['user_id']);
// $user_result = mysql_query("SELECT * FROM tbl_user WHERE user_id='".$user_id."' LIMIT 1");
// $user_row = mysql_fetch_assoc($user_result);
$user_id = pg_escape_literal($_GET[user_id]);
$user_result = pg_query("SELECT * FROM tbl_user WHERE user_id=" . $user_id . " LIMIT 1");
$user_row = pg_fetch_assoc($user_result);
?>
<h1><?php
echo $user_row['user_firstname'] . " " . $user_row['user_lastname'];
?>
</h1>
<form method="POST" action="./process.php?function=editUser&user_id=<?php
echo $user_row['user_id'];
?>
">
<?php
$Error->show();
$Success->show();
?>
<input type="text" name="firstname" class="form-control" placeholder="Förnamn" value="<?php
echo $user_row['user_firstname'];
?>
">
<br>
<input type="text" name="lastname" class="form-control" placeholder="Efternamn" value="<?php
开发者ID:hanselmahlaola,项目名称:openjensen,代码行数:31,代码来源:users.edit.php
示例20: convertStringToSql
public function convertStringToSql($value)
{
return pg_escape_literal($this->connection, $value);
}
开发者ID:insekticid,项目名称:dbal,代码行数:4,代码来源:PgsqlDriver.php
注:本文中的pg_escape_literal函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论