本文整理汇总了PHP中Database::escapeString方法的典型用法代码示例。如果您正苦于以下问题:PHP Database::escapeString方法的具体用法?PHP Database::escapeString怎么用?PHP Database::escapeString使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Database
的用法示例。
在下文中一共展示了Database::escapeString方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: update
public function update()
{
$db = new Database();
$db->connect();
$returnValue;
//if($this->isCreated()){
$where = 'id=' . $this->getId();
$updateInformation = array();
$updateInformation["name"] = $db->escapeString($this->getName());
$updateInformation["description"] = $db->escapeString($this->getDescription());
$updateInformation["display"] = $db->escapeString($this->getDisplay());
date_default_timezone_set('America/Chicago');
$updateInformation["last_updated_timestamp"] = $db->escapeString(date('Y-m-d G:i:s'));
$result = $db->update(static::$tableName, $updateInformation, $where);
if ($result) {
$returnValue = true;
} else {
$returnValue = false;
}
$db->disconnect();
//}else{
// $returnValue = false;
//}
return $returnValue;
}
示例2: update
public function update()
{
$db = new Database();
$db->connect();
$where = 'id=' . $this->getId();
$updateInformation = array();
$updateInformation['name'] = $db->escapeString($this->getName());
$updateInformation['description'] = $db->escapeString($this->getDescription());
$updateInformation["last_updated_timestamp"] = $db->escapeString(date('Y-m-d G:i:s'));
$result = $db->update(static::$tableName, $updateInformation, $where);
$db->disconnect();
if ($result) {
$this->setId($result);
return $result;
} else {
return false;
}
}
示例3: Session
<?php
require_once '../model/paths.php';
$session = new Session();
if (!$session->isLogin) {
redirect("../login.php");
}
$database = new Database();
$user = new User();
if (isset($_POST['submit'])) {
$newPass = $database->escapeString($_POST['newPass']);
$confPass = $database->escapeString($_POST['confPass']);
$code = $database->escapeString($_POST['code']);
$hash = password_hash($newPass, PASSWORD_BCRYPT);
if ($newPass != $confPass) {
redirect($_SERVER['HTTP_REFERER'] . "&error=equals");
} else {
if (strlen($newPass) < 6) {
redirect($_SERVER['HTTP_REFERER'] . "&error=length");
} else {
$user->setId($code);
$user->setPassword($hash);
if ($user->updatePassword()) {
$path = "../logs";
$dateTime = strftime("%Y-%m-%d %H:%M:%S");
$text = "Password changed for user with ID:";
$content = $dateTime . " " . $_SESSION['USNM'] . ": " . $text;
$user->setId($_SESSION['USID']);
$user->storeLog($content, $path);
redirect("../users.php?users=1&pass=succeed");
} else {
示例4: config
<?php
require_once 'db/config.php';
$con = new config(DB_HOST, DB_USER, DB_PASS, DB_NAME);
$db = new Database($con);
$db->openConnection();
$postdata = file_get_contents("php://input");
$jsonHandle = new jsonHandler();
$requestData = $jsonHandle->decode($postdata);
$data = array();
$page = $db->escapeString($requestData->page);
$innerPage = $db->escapeString($requestData->innerPage);
if ($page == "dashboard") {
$query = $db->query("SELECT * FROM tbl_hashtag");
/*Overview Page*/
if ($innerPage == "overview") {
/*Check whether it contains tha hashtag data or not*/
if ($db->hasRows($query)) {
$data['hashtagArray'] = array();
$i = 0;
while ($row = $db->fetchAssoc($query)) {
$hashtagName = $row['hashtagName'];
/*Total Tweet Count*/
$totTweetsQuery = $db->query("SELECT COUNT(DISTINCT tweet_id) FROM tweet_tags WHERE tag = '{$hashtagName}'");
$totalTweets = $db->fetchArray($totTweetsQuery);
$data['hashtagArray'][$i]['hashtagName'] = $hashtagName;
$data['hashtagArray'][$i]['tweets'] = array();
//$tweetQuery = "SELECT * FROM tweet_tags LEFT JOIN"
$data['hashtagArray'][$i]['totalTweets'] = $totalTweets[0];
$data['hashtagArray'][$i]['totalImpressions'] = $i + 2000;
$data['hashtagArray'][$i]['profileVisits'] = 3000;
示例5: array
echo $d['id'];
?>
" class="btn btn-primary btn-xs">Tindak</a></td>
</tr>
<?php
}
?>
</tbody>
</table>
<div class="alert alert-info" role="alert">Klik pada nama siswa atau NIS untuk melihat daftar peringatan.</div>
<?php
} else {
if (isset($_POST['idtindak'])) {
$idtindak = $db->escapeString($_POST['idtindak']);
$status = $db->escapeString($_POST['status']);
$db->update('tindak', array('tindak' => $status, 'ubah' => wkt(), 'idguru' => $_SESSION['userid']), "id='{$idtindak}'");
echo "Processing...";
eksyen('Data berhasil diubah', '?hal=penindakan');
}
$id = mysql_real_escape_string($_GET['detail']);
$db->select('tindak', '*', null, "id='{$id}'");
$res = $db->getResult();
foreach ($res as $d) {
?>
<div class="col-lg-12">
<h1 class="page-header">Detail Tindakan <small>| <a href="?hal=penindakan">Kembali</a></small></h1>
</div>
<form action="" method="post">
示例6: eksyen
if (isset($_GET['id'])) {
echo '<h1 class="page-header">Ubah Data Sanksi <small>| <a href="?hal=sanksi">Kembali</a></small></h1>';
$id = $_GET['id'];
$db->select('sanksi', '*', NULL, "id='{$id}'", null);
// Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions
$jum = $db->numRows();
if ($jum < 1) {
eksyen('Data tidak ditemukan', '?hal=sanksi');
}
$d = $db->getResult();
} else {
echo '<h1 class="page-header">Tambah Data Sanksi <small>| <a href="?hal=sanksi">Kembali</a></small></h1>';
}
if (isset($_POST['nama'])) {
echo "Processing...";
$nama = $db->escapeString($_POST['nama']);
$minimal = $db->escapeString($_POST['minimal']);
$maksimal = $db->escapeString($_POST['maksimal']);
if (isset($_POST['id'])) {
$id = mysql_real_escape_string($_POST['id']);
$db->update('sanksi', array('nama' => $nama, 'minimal' => $minimal, 'maksimal' => $maksimal, 'ubah' => wkt()), 'id="' . $id . '"');
eksyen('Data berhasil diubah', '?hal=sanksi');
} else {
$db->insert('sanksi', array('nama' => $nama, 'minimal' => $minimal, 'maksimal' => $maksimal, 'ubah' => wkt()));
$res = $db->getResult();
eksyen('Data berhasil diinput', '?hal=sanksi');
}
}
?>
<form action="" method="POST" class="form-horizontal" role="form">
<?php
示例7: Database
<?php
include 'class/mysql_crud.php';
$db = new Database();
$db->connect();
$data = $db->escapeString("name5@email.com");
// Escape any input before insert
$db->insert('CRUDClass', array('name' => 'Name 5', 'email' => $data));
// Table name, column names and respective values
$res = $db->getResult();
print_r($res);
示例8: config
<?php
//header('Access-Control-Allow-Origin: *');
//header('Content-Type: application/json; charset = UTF-8');
//session_start();
require_once 'db/config.php';
$con = new config(DB_HOST, DB_USER, DB_PASS, DB_NAME);
$db = new Database($con);
$db->openConnection();
$postdata = file_get_contents("php://input");
$jsonHandle = new jsonHandler();
$requestdata = $jsonHandle->decode($postdata);
//$requestdata = json_decode($postdata);
$userName = $db->escapeString($requestdata->userName);
$userPass = $db->escapeString($requestdata->userPass);
$data = array();
if (!empty($userName) && !empty($userPass)) {
$query = $db->query("SELECT * FROM tbl_admin WHERE admin_user= '{$userName}' AND admin_pass = '{$userPass}'");
if ($db->hasRows($query) > 0) {
while ($row = $db->fetchAssoc($query)) {
if ($row['admin_status'] == 1) {
$_SESSION['user'] = $row['admin_user'];
$_SESSION['loggedIn'] = true;
$data['adminUser'] = $row['admin_user'];
$data['adminType'] = $row['admin_type'];
$data['adminMail'] = $row['admin_mail'];
$data['adminContactMail'] = $row['admin_contactmail'];
$data['loggedIn'] = true;
/*Super admin*/
if ($row['admin_type'] == "sadmin") {
$data['message'] = "You have successfully connected and too have full access over the data";
示例9: escapeString
/**
* Wrapper for the db.
*
* @param string $string
* @return string
*/
public function escapeString($string)
{
return $this->db->escapeString($string);
}
示例10: Session
<?php
require_once '../model/paths.php';
$session = new Session();
if (!$session->isLogin) {
redirect("../login.php");
}
$database = new Database();
$user = new User();
$menu = new Menu();
$links = new Links();
$pages = new Page();
if (isset($_POST['addMenuBtn'])) {
$menuName = $database->escapeString($_POST['menuName']);
$description = $database->escapeString($_POST['description']);
// check if parent is set
if (isset($_POST['parent']) && $_POST['parent'] != "" && $_POST['parent'] != null) {
$parentLinkId = $database->escapeString($_POST['parent']);
$links->setLinkId($parentLinkId);
$language = $links->getSubMenusLangId($database);
} else {
$language = $database->escapeString($_POST['language']);
$parentLinkId = 0;
}
// set values
$menu->setLangId($language);
$menu->setIsMain(0);
$menu->setDescription($description);
$menu->setParentLinkId($parentLinkId);
$menu->setTitle($menuName);
// do not allove a link to have two sub menus
示例11: Session
<?php
require_once '../model/paths.php';
$session = new Session();
if (!$session->isLogin) {
redirect("../login.php");
}
$database = new Database();
$user = new User();
$hotel = new Hotel();
$location = new Location();
$media = new Media();
if (isset($_POST['submit'])) {
$name = $database->escapeString($_POST['name']);
$address = $database->escapeString($_POST['address']);
$stars = $database->escapeString($_POST['stars']);
$destination = $database->escapeString($_POST['location']);
$description = $database->escapeString($_POST['description']);
$hotel->setHotelName($name);
$hotel->setAddress($address);
$hotel->setStars($stars);
$hotel->setDescription($description);
$hotel->setCityId($destination);
if (isset($_POST['hotelId'])) {
$hotelId = $database->escapeString($_POST['hotelId']);
$hotel->setHotelId($hotelId);
$hotel->update($database);
} else {
$hotelId = $hotel->create($database);
}
if (count($_FILES) != 0) {
示例12: Session
<?php
require_once '../model/paths.php';
$session = new Session();
if (!$session->isLogin) {
redirect("../login.php");
}
$user = new User();
$database = new Database();
$pageLayout = new PageLayout();
if (isset($_POST['pageLayoutList']) && $_POST['pageLayoutList'] != null) {
foreach ($_POST['pageLayoutList'] as $pageLayoutId) {
$pageLayout->setPageLayoutId($database->escapeString($pageLayoutId));
$pageLayout->getById($database);
unlink("../" . $pageLayout->getImage());
$pageLayout->delete($database);
$path = "../logs";
$dateTime = strftime("%Y-%m-%d %H:%M:%S");
$text = "Deleted page layout with id:" . $pageLayoutId . " and name: " . $pageLayout->getName();
$content = $dateTime . " " . $_SESSION['USNM'] . ": " . $text;
$user->setId($_SESSION['USID']);
$user->storeLog($content, $path);
echo "true";
}
} else {
echo "false";
}
示例13: foreach
}
$db->select('tipoarticulo', 'idtipoart, descripcion');
// Table name, Column Names, WHERE conditions, ORDER BY conditions
$res = $db->getResult();
$ltipoart = '';
foreach ($res as $key => $value) {
$ltipoart .= '<option value="' . $value['idtipoart'] . '">' . $value['descripcion'] . '</option>';
}
if (isset($_POST['btnguardar'])) {
$db->select('articulo', 'max(idarticulo) as id');
// Table name, Column Names, WHERE conditions, ORDER BY conditions
$res = $db->getResult();
foreach ($res as $key => $value) {
$id = $value['id'] + 1;
}
$vcodint = $db->escapeString("{$_POST['txtcodint']}");
// Escape any input before insert
$vmodelo = $db->escapeString("{$_POST['txtmodelo']}");
$vdescripcion = $db->escapeString("{$_POST['txtdescripcion']}");
$vdesetiqueta = $db->escapeString("{$_POST['txtdesetiqueta']}");
$vdesticket = $db->escapeString("{$_POST['txtdesticket']}");
$vdeslarga = $db->escapeString("{$_POST['txtdeslarga']}");
$vidfotoart = $db->escapeString("{$_POST['txtidfotoart']}");
$vcodbarra = $db->escapeString("{$_POST['txtcodbarra']}");
$vidimpuestos = $db->escapeString("{$_POST['idimpuestos']}");
$vidproveedor = $db->escapeString("{$_POST['txtidproveedor']}");
$vidmarca = $db->escapeString("{$_POST['txtidmarca']}");
$vpreciocosto = $db->escapeString("{$_POST['txtpreciocosto']}");
$vpvp = $db->escapeString("{$_POST['txtpvp']}");
$vmpcosto = $db->escapeString("{$_POST['txtmpcosto']}");
$vfechact = $db->escapeString("{$_POST['txtfechact']}");
示例14: Session
<?php
require_once '../model/paths.php';
$session = new Session();
if (!$session->isLogin) {
redirect("../login.php");
}
$user = new User();
$database = new Database();
if (isset($_GET['user']) && isset($_GET['active']) && $_GET['user'] != null && $_GET['active'] != null) {
$id = $database->escapeString($_GET['user']);
$active = $database->escapeString($_GET['active']);
$user->setId($id);
$user->setActive($active);
if ($user->changeActive($database)) {
$path = "../logs";
$dateTime = strftime("%Y-%m-%d %H:%M:%S");
$text = "Enabled/Disabled user with id :" . $id;
$content = $dateTime . " " . $_SESSION['USNM'] . ": " . $text;
$user->setId($_SESSION['USID']);
$user->storeLog($content, $path);
redirect("../users.php");
} else {
}
} else {
echo "User not set";
}
示例15: eksyen
if (isset($_GET['id'])) {
echo '<h1 class="page-header">Ubah Data Tata Tertib <small>| <a href="?hal=tatatertib">Kembali</a></small></h1>';
$id = $_GET['id'];
$db->select('tata_tertib', '*', NULL, "id='{$id}'", null);
// Table name, Column Names, JOIN, WHERE conditions, ORDER BY conditions
$jum = $db->numRows();
if ($jum < 1) {
eksyen('Data tidak ditemukan', '?hal=tatatertib');
}
$d = $db->getResult();
} else {
echo '<h1 class="page-header">Tambah Data Tata Tertib <small>| <a href="?hal=tatatertib">Kembali</a></small></h1>';
}
if (isset($_POST['nama'])) {
echo "Processing...";
$nama = $db->escapeString($_POST['nama']);
$poin = $db->escapeString($_POST['poin']);
$jenis = $db->escapeString($_POST['jenis']);
if (isset($_POST['id'])) {
$id = mysql_real_escape_string($_POST['id']);
$db->update('tata_tertib', array('nama' => $nama, 'poin' => $poin, 'jenis' => $jenis, 'ubah' => wkt()), 'id="' . $id . '"');
eksyen('Data berhasil diubah', '?hal=tatatertib');
} else {
$db->insert('tata_tertib', array('nama' => $nama, 'poin' => $poin, 'jenis' => $jenis, 'ubah' => wkt()));
$res = $db->getResult();
eksyen('Data berhasil diinput', '?hal=tatatertib');
}
}
?>
<form action="" method="POST" class="form-horizontal" role="form">
<?php