- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
我向数据库发出了请求,但出现问题
这是我的数据库
if (!empty(unserialize($data['copy-passport'])) && !empty(unserialize($data['photo']))) {
$stmt = $this->connect->prepare("UPDATE requests SET status=:status, date=:date, firstname=:firstname, firstname-lat=:firstname-lat, lastname=:lastname, lastname-lat=:lastname-lat, middlename=:middlename, date-birth=:date-birth, phone=:phone, email=:email, region-home=:region-home, city=:city, street=:street, house=:house, apartment=:apartment, post-index=:post-index, photo=:photo, copy-passport=:copy-passport, delivery=:delivery, office=:office, region=:region WHERE id=:id");
if ($stmt->execute(array(':status' => $data['status'], ':date' => strtotime($data['date']), ':firstname' => htmlspecialchars($data['firstname'], ENT_QUOTES), ':firstname-lat' => htmlspecialchars($data['firstname-lat'], ENT_QUOTES), ':lastname' => htmlspecialchars($data['lastname'], ENT_QUOTES), ':lastname-lat' => htmlspecialchars($data['lastname-lat'], ENT_QUOTES), ':middlename' => htmlspecialchars($data['middlename'], ENT_QUOTES), ':date-birth' => htmlspecialchars($data['date-birth'], ENT_QUOTES), ':email' => htmlspecialchars($data['email'], ENT_QUOTES), ':phone' => htmlspecialchars($data['phone'], ENT_QUOTES), ':region' => htmlspecialchars($data['region'], ENT_QUOTES), ':region-home' => htmlspecialchars($data['region-home'], ENT_QUOTES), ':street' => htmlspecialchars($data['street'], ENT_QUOTES), ':city' => htmlspecialchars($data['city'], ENT_QUOTES), ':house' => htmlspecialchars($data['house'], ENT_QUOTES), ':apartment' => htmlspecialchars($data['apartment'], ENT_QUOTES), ':post-index' => htmlspecialchars($data['post-index'], ENT_QUOTES), ':photo' => $data['photo'], ':copy-passport' => $data['copy-passport'], ':delivery' => htmlspecialchars($data['delivery'], ENT_QUOTES), ':office' => htmlspecialchars($data['office'], ENT_QUOTES), ':id' => $id))) {
return true;
} else {
return $stmt->errorInfo();
}
并在此处请求页面
<?php
if ($session->levelAccess() != 2) {
$session->deleteSession();
} else {
if (isset($_POST['abc'])) {$request1->updateRequest1($_GET['id'] ,$_POST, $_FILES);
print_r($_POST);
print_r($_FILES);
// $engine->switchPartnerStatus($_GET['id'], $_POST['status']);
}
$request1_id = $_GET['id'];
$stmt = $request1->connect->prepare("SELECT * FROM `requests` WHERE id=:request1_id");
if ($stmt->execute(array(':request1_id' => $request1_id))) {
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
?>
<!-- begin content -->
<main class="main">
<div class="main__wrapper">
<div class="main__title">
<span class="main__title-text">Управление заявкой партнера</span>
</div>
<!-- begin content -->
<div class="content">
<div class="content__status">
<span class="content__info-text"></span>
<div class="content__order-block bg-yellow">
<span class="content__info-order">№ заявки: <span class="content__order-number"><?php echo $row['id'] ?></span></span>
</div>
</div>
<form class="edit" method="POST" enctype="multipart/form-data">
<div class="edit__block">
<input value="<?php echo $_GET['id'] ?>"type="text" id="id" class="edit__input" name="id" style="display:none;">
<div class="request__line">
<p class="request__title-photo">Введите имя на английском языке/in english *</p>
<p for="firstname-lat" class="request__title">Имя (на английском языке/in english)</p>
<input type="text" class="request__info" id="firstname-lat" name="firstname-lat" value="<?php echo htmlspecialchars_decode($row['firstname-lat'], ENT_QUOTES);; ?>" readonly="readonly">
<div class="btn__group">
<span class="btn__edit btn__edit-main">Редактировать</span>
<span class="btn__edit btn__edit-yes">Сохранить</span>
</div>
</div>
<div class="request__line">
<p class="request__title-photo">Введите имя на русском языке/in russian *</p>
<p for="firstname"class="request__title">Имя (на русском языке/in russian)</p>
<input type="text" class="request__info" id="firstname" name="firstname" value="<?php echo htmlspecialchars_decode($row['firstname'], ENT_QUOTES); ?>" readonly="readonly" >
<div class="btn__group">
<span class="btn__edit btn__edit-main">Редактировать</span>
<span class="btn__edit btn__edit-yes">Сохранить</span>
</div>
</div>
<div class="request__line">
<p class="request__title-photo">Введите фамилию на английском языке/in english *</p>
<p for="lastname-lat" class="request__title">Фамилия (на английском языке/in english)</p>
<input type="text" class="request__info" id="lastname-lat" name="lastname-lat" value="<?php echo htmlspecialchars_decode($row['lastname-lat'], ENT_QUOTES);; ?>" readonly="readonly">
<div class="btn__group">
<span class="btn__edit btn__edit-main">Редактировать</span>
<span class="btn__edit btn__edit-yes">Сохранить</span>
</div>
</div>
<div class="request__line">
<p class="request__title-photo">Введите фамилию на русском языке/in russian *</p>
<p for="lastname" class="request__title">Фамилия (на русском языке/in russian)</p>
<input type="text" class="request__info" id="lastname" name="lastname" value="<?php echo htmlspecialchars_decode($row['lastname'], ENT_QUOTES); ?>" readonly="readonly" >
<div class="btn__group">
<span class="btn__edit btn__edit-main">Редактировать</span>
<span class="btn__edit btn__edit-yes">Сохранить</span>
</div>
</div>
<div class="request__line">
<p class="request__title-photo">Введите отчество на русском языке/in russian *</p>
<p for="middlename" class="request__title">Отчество (на русском языке/in russian)</p>
<input type="text" class="request__info" id="middlename" name="middlename" value="<?php echo htmlspecialchars_decode($row['middlename'], ENT_QUOTES); ?>" readonly="readonly" >
<div class="btn__group">
<span class="btn__edit btn__edit-main">Редактировать</span>
<span class="btn__edit btn__edit-yes">Сохранить</span>
</div>
</div>
<div class="request__line">
<p class="request__title-photo">Введите дату рождения *</p>
<p for="date-birth" class="request__title">Дата рождения</p>
<input type="text" class="request__info" id="date-birth" name="date-birth" value="<?php echo htmlspecialchars_decode($row['date-birth'], ENT_QUOTES); ?>" readonly="readonly" >
<div class="btn__group">
<span class="btn__edit btn__edit-main">Редактировать</span>
<span class="btn__edit btn__edit-yes">Сохранить</span>
</div>
</div>
<div class="request__line">
<p class="request__title-photo">Введите ваш телефон, пример: +70123456789 *</p>
<p for="phone" class="request__title">Телефон</p>
<input type="text" class="request__info" id="phone" name="phone" value="<?php echo $row['phone']; ?>" readonly="readonly">
<div class="btn__group">
<span class="btn__edit btn__edit-main">Редактировать</span>
<span class="btn__edit btn__edit-yes">Сохранить</span>
</div>
</div>
<div class="request__line">
<p class="request__title-photo">Введите ваш email, пример: example@mail.com *</p>
<p for="email" class="request__title">E-mail</p>
<input type="text" class="request__info" id="email" name="email" value="<?php echo $row['email']; ?>" readonly="readonly">
<div class="btn__group">
<span class="btn__edit btn__edit-main">Редактировать</span>
<span class="btn__edit btn__edit-yes">Сохранить</span>
</div>
</div>
<div class="request__line">
<p class="request__title-photo">Выберите название вашего региона проживания *</p>
<p for="region-home" class="request__title">Регион проживания</p>
<select name="region-home" id="region-home" class="form__region" >
<option name="region-home" id="region-home" value="<?php echo $row['region-home'];?>" class="form__region-option" selected><?php echo $geo->getRegionNameById($row['region-home']);?></option>
<?php
$geo = new Geo;
$regions = $geo->getAllRegions();
foreach ($regions as $key => $value) {
echo '<option name="region-home" id="region-home" value="'.$value['region_id'].'" class="form__region-option">'.$value['name'].'</option>';
}
?>
</select>
</div>
<!--<script>
function activatePostInfo(value){
switch(value) {
case "1":
document.getElementById("selfDelivery").setAttribute("class", "delivery-blockd");
document.getElementById("nonSelfDelivery").setAttribute("class", "delivery-blockh");
break;
case "2":
document.getElementById("selfDelivery").setAttribute("class", "delivery-blockh");
document.getElementById("nonSelfDelivery").setAttribute("class", "delivery-blockd");
break;
}
}
</script>-->
<div class="request__line">
<p class="request__title-photo">Выберите тип и адрес доставки *</p>
<p for="delivery" lass="request__title">Доставка</p>
<div class="form__input ">
<select name="delivery" id="delivery" class="form__delivery" >.
<?php if ($row['delivery'] == '1') {
echo '<option name="delivery" id="delivery" value="1" selected>Самовывоз</option>';
echo '<option name="delivery" id="delivery" value="2">Доставка почтой</option>';
} elseif ($row['delivery'] == '2') {
echo '<option name="delivery" id="delivery" value="1">Самовывоз</option>';
echo '<option name="delivery" id="delivery" value="2" selected>Доставка почтой</option>';
}
?>
</select>
</div>
</div>
<div class="request__line">
<p for="office"><label>Город для самовывоза:</label></p>
<select name="office" id="office" class="form__delivery">
<option name="office" id="office" value="1" class="form__region-option">Выберете город</option>
<option name="office" id="office" value="Москва" class="form__region-option">Москва</option>
</select>
</div>
<div class="request__line">
<p for="region"><label for="sip_buy_city">Регион</label></p>
<div class="form__input ">
<select name="region" id="sip_buy_region" class="sip_buy_region">
<option name="region" id="region" value="0" selected="selected">Выберите регион..</option>
<?php
$regions = $geo->getAllRegions();
foreach ($regions as $key => $value) {
echo '<option name="region" id="region" value="'.$value['region_id'].'" class="form__region-option">'.$value['name'].'</option>';
}
?>
</select>
</div>
</div>
<div class="request__line">
<p for="city"><label for="sip_buy_city">Город (населенный пункт)</label></p>
<div name="city" id="city" class="form__input ">
<select name="city" id="sip_buy_city" class="sip_buy_city">
<option name="city" id="city" value="0" selected="selected">Нет данных..</option>
</select>
</div>
</div>
<div class="request__line">
<p class="request__title-photo">Введите название вашей улицы *</p>
<p for="street" class="request__title">Улица</p>
<input type="text" class="request__info" name="street" id="street" value="<?php echo $row['street']; ?>" readonly="readonly">
<div class="btn__group">
<span class="btn__edit btn__edit-main">Редактировать</span>
<span class="btn__edit btn__edit-yes">Сохранить</span>
</div>
</div>
<div class="request__line">
<p class="request__title-photo">Введите цифру вашего дома *</p>
<p for="house" class="request__title">Дом</p>
<input type="text" class="request__info" name="house" id="house" value="<?php echo $row['house']; ?>" readonly="readonly">
<div class="btn__group">
<span class="btn__edit btn__edit-main">Редактировать</span>
<span class="btn__edit btn__edit-yes">Сохранить</span>
</div>
</div>
<div class="request__line">
<p class="request__title-photo">Введите номер вашей квартиры *</p>
<p for="apartment"class="request__title">Квартира</p>
<input type="text" class="request__info" name="apartment" id="apartment" value="<?php echo $row['apartment']; ?>" readonly="readonly">
<div class="btn__group">
<span class="btn__edit btn__edit-main">Редактировать</span>
<span class="btn__edit btn__edit-yes">Сохранить</span>
</div>
</div>
<div class="request__line">
<p class="request__title-photo">Введите ваш индекс *</p>
<p for="post-index" class="request__title">Индекс</p>
<input type="text" class="request__info" name="post-index" id="post-index" value="<?php echo $row['post-index']; ?>" readonly="readonly">
<div class="btn__group">
<span class="btn__edit btn__edit-main">Редактировать</span>
<span class="btn__edit btn__edit-yes">Сохранить</span>
</div>
</div>
<div class="request__line">
<p class="request__title-photo">При добавлении новых фотографий старые фото будут удалены. Допускаются файлы в формате .jpg, .jpeg, .gif, .png, размером не более 3 мегабайт*</p>
<p class="request__title-photo">Максимальный размер фотографии не должен превышать 400 x 400 пикселей*</p>
<p for="photo" class="request__title">Фотография</p>
<label for="photo" class="file-uploader__title">Загрузить</label>
<input type="file" id="photo" name="photo" class="file__input">
<div class="file-pre">
<?php echo $image->showImages($row['photo'], 'photo/'.$row['id']) ?>
</div>
</div>
<div class="request__line">
<p class="request__title-photo">При добавлении новых фотографий старые фото будут удалены. Допускаются файлы в формате .jpg, .jpeg, .gif, .png, размером не более 3 мегабайт*</p>
<p class="request__title-photo">Максимальный размер фотографии не должен превышать 400 x 400 пикселей*</p>
<p for="copy-passport" class="request__title">Фотографии паспорта</p>
<label for="copy-passport" class="file-uploader__title">Загрузить</label>
<input type="file" id="copy-passport" name="copy-passport" class="file__input">
<div class="file-pre">
<?php echo $image->showImages($row['copy-passport'], 'passport/'.$row['id']) ?>
</div>
</div>
<div class="request__line">
<p class="request__title-photo">Выберите один из статусов заявки *</p>
<p for="status" class="request__title">Статус заявки</p>
<select name="status" id="status" class="request__select">
<option name="status" id="status" value="1" class="request__option" <?php if($row['status'] == '1') {echo 'selected';}?>>Новая заявка</option>
<option name="status" id="status" value="2" class="request__option" <?php if($row['status'] == '2') {echo 'selected';}?>>В обработке</option>
<option name="status" id="status" value="3" class="request__option" <?php if($row['status'] == '3') {echo 'selected';}?>>Завершенная</option>
</select>
</div>
<div class="request__line">
<p class="request__title-photo">Введите дату заявки *</p>
<p for="date" class="request__title">Дата</p>
<input type="text" class="request__info" name="date" id="date" value="<?php echo $row['date']; ?>" readonly="readonly">
<div class="btn__group">
<span class="btn__edit btn__edit-main">Редактировать</span>
<span class="btn__edit btn__edit-yes">Сохранить</span>
</div>
</div>
<div class="request__line">
<input type="submit" name="submit2" class="btn__edit btn__final bg-grey" value="вернуться назад">
<input type="submit" name="abc" class="btn__edit btn__final bg-green-1" value="Сохранить">
</div>
</div>
</form>
</div>
我似乎在某些 POST 请求选项中出现了错误。不知道我的错误在哪里。我更改了提交按钮名称,它解决了问题,但错误仍然出现。不知道错误在哪里。请解释一下我哪里错了。
这是一个错误代码:
数组 ( [0] => HY093 1 => [2] => )
最佳答案
通过更改一些破折号和减号来修复它,在必要的地方添加一些 ',
感谢@u-mulder
关于javascript - 如何修复我的 [HY093] 错误。当我发送表格时就会发生这种情况,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/56097665/
我正在创建一个 sql server 存储过程,它将输入作为逗号分隔的 productid 或选项“全部”。当用户传入逗号分隔的产品 ID 时,查询应输出所有产品 ID 的数据。我使用“IN”语句执行
我有一个自动生成的 Web 服务客户端。我有很多复杂的类,我必须对其进行模式匹配。现在我的结构如下所示: val response = client.getResponse response matc
关闭。这个问题是opinion-based .它目前不接受答案。 想改进这个问题?更新问题,以便 editing this post 可以用事实和引用来回答它. 7年前关闭。 Improve this
我需要正确的 tsql 语法来解决这个问题: Select * from table where var_A='10' select * from table where var_B='10' 何时使
我遇到了这个问题。每当我运行程序并在需要时键入字母 m 时,我的 if 语句都不会识别它。有人知道为什么吗?我已经这样做了一个小时,但没有结果。 #include #include #includ
我从数据库列名称“你有护照”创建了一个表,用户回答是或否我如何将 css 应用到这个动态工作的表。 table, th, td { border: 1px solid black;
我对 LocationListener 类的 onStatusChanged 有一些疑问。 它知道它可以呈现三种状态:AVAILABLE、TEMPORARILY_UNAVAILABLE 和 OUT_O
当引入新的异常类型时,我总是不确定如何正确地做到这一点。有共同约定吗?你怎么做呢? 我对您组织它们的范围感兴趣(将它们保留在它们所使用的单元中?在组件级别有一个单元?包级别?应用程序?) 这也会影响命
我使用以下内容创建了日期维度: https://www.codeproject.com/Articles/647950/Create-and-Populate-Date-Dimension-for-D
您好,我正在使用 Android 完全 Kiosk 浏览器,该浏览器使用 chrome Webview。但是 javascript 中的某些方法或函数无法正常工作,例如 window.print()。
我有以下代码: public void OpenFile(string FileName) { if (FileName == null)
获取索引越界异常 for (int recordData = 0; recordData < recordDataList.size(); recordData++) {
我使用它在发生错误时在登录中显示一条消息: × Invalid user or password
这是我的场景,我有一个异常列表,其中包含来自不同层次结构的任意异常,下面的代码快照将解释我需要做什么 private List connectionExceptions; try { // tryin
我尝试动态更新 Jtextpane 中的左缩进。但我不能!这是我尝试过的! DefaultStyledDocument document = (DefaultStyledDocument) textp
我不知道为什么这个异常不起作用...... import java.util.*; public class a { public static void main(String[] args
我目前在 case 中使用多个 when 时遇到问题。当我删除第二个当时,它就起作用了。这是什么问题? 报告的MYSQL错误为: #1064 - You have an error in your S
例如,我有一个表记录用户查看和下载文件的事件, file_id user activity 2 Tim view 1 Ron
这是一个非常愚蠢的问题,但我需要一点安慰/帮助。我有当前的“递归”情况: void add( int value ) { // do something ... // if ( conditi
我尝试使用以下代码在按钮数组上注册回调。但我似乎无法理解如何绑定(bind)回调中需要的字符串。任何建议将不胜感激! for (var i = 0; i < this.car_types.length
我是一名优秀的程序员,十分优秀!