php - 表单突然停止插入数据 - 这段代码有什么问题?
问题描述
我有一个工作正常的 php 表单,但突然停止工作。我似乎无法弄清楚问题出在哪里。它不会抛出任何特定的错误,它只是刷新提交页面并清除输入表单的数据。没有任何东西被插入到数据库中。关于这里可能存在问题的任何想法?在此先感谢您的帮助。
更新:我已经剥离了代码并且它在提交时没有显示任何错误。它只是重置表单,就好像什么都没发生一样。它正在连接到数据库,因为它将显示任何具有可用数据的字段。我要疯了,试图弄清楚这一点。我不明白为什么它不起作用,我似乎无法获得任何有意义的错误数据。
<?php
session_start();
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
include('includes/config.php');
if(strlen($_SESSION['alogin'])==0)
{
header('location:index.php');
}
else{
if(isset($_GET['edit']))
{
$editid=$_GET['edit'];
}
if(isset($_POST['submit']))
{
$file = $_FILES['image']['name'];
$file_loc = $_FILES['image']['tmp_name'];
$folder="../images/";
$new_file_name = strtolower($file);
$final_file=str_replace(' ','-',$new_file_name);
$name=$_POST['name'];
$email=$_POST['email'];
$category=$_POST['category'];
$mobileno=$_POST['mobileno'];
$description=$_POST['description'];
$website=$_POST['website'];
$address=$_POST['address'];
$city=$_POST['city'];
$state=$_POST['state'];
$zip=$_POST['zip'];
$idedit=$_POST['idedit'];
$image=$_POST['image'];
if(move_uploaded_file($file_loc,$folder.$final_file))
{
$image=$final_file;
}
$sql="UPDATE users SET name=(:name), email=(:email), category=(:category), mobile=(:mobileno), description=(:description), website=(:website), address=(:address), city=(:city), state=(:state), zip=(:zip), image=(:image) WHERE id=(:idedit)";
$query = $dbh->prepare($sql);
$query-> bindParam(':name', $name, PDO::PARAM_STR);
$query-> bindParam(':email', $email, PDO::PARAM_STR);
$query-> bindParam(':category', $category, PDO::PARAM_STR);
$query-> bindParam(':mobileno', $mobileno, PDO::PARAM_STR);
$query-> bindParam(':description', $description, PDO::PARAM_STR);
$query-> bindParam(':website', $website, PDO::PARAM_STR);
$query-> bindParam(':address', $address, PDO::PARAM_STR);
$query-> bindParam(':city', $city, PDO::PARAM_STR);
$query-> bindParam(':state', $state, PDO::PARAM_STR);
$query-> bindParam(':zip', $zip, PDO::PARAM_STR);
$query-> bindParam(':image', $image, PDO::PARAM_STR);
$query-> bindParam(':idedit', $idedit, PDO::PARAM_STR);
$query->execute();
$msg="Information Updated Successfully";
}
?>
<!doctype html>
<html lang="en" class="no-js">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1, maximum-scale=1">
<title>Edit</title>
</head>
<body>
<?php
$sql = "SELECT * from users where id = :editid";
$query = $dbh -> prepare($sql);
$query->bindParam(':editid',$editid,PDO::PARAM_INT);
$query->execute();
$result=$query->fetch(PDO::FETCH_OBJ);
$cnt=1;
?>
<h3 class="page-title">Edit Marker : <?php echo htmlentities($result->name); ?></h3>
<form method="post" class="form-horizontal" enctype="multipart/form-data" name="imgform">
<img class="profileimage" src="../images/<?php echo htmlentities($result->image);?>" >
<input type="file" name="image" class="form-control">
<input type="hidden" name="image" class="form-control" value="<?php echo htmlentities($result->image);?>">
<label class="col-sm-2 control-label">Title</label>
<input type="text" name="name" class="form-control" value="<?php echo htmlentities($result->name);?>">
<label class="col-sm-2 control-label">Category</label>
<select name="category" class="form-control">
<option value="">Select</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select>
<label class="col-sm-2 control-label">Phone</label>
<input type="text" name="mobileno" class="form-control" value="<?php echo htmlentities($result->mobile);?>">
<label class="col-sm-2 control-label">Website</label>
<input type="text" name="website" class="form-control" value="<?php echo htmlentities($result->website);?>">
<label class="col-sm-2 control-label">Address</label>
<input type="text" name="address" class="form-control" value="<?php echo htmlentities($result->address);?>">
<label class="col-sm-2 control-label">City</label>
<input type="text" name="city" class="form-control" value="<?php echo htmlentities($result->city);?>">
<label class="col-sm-2 control-label">State</label>
<select name="state" class="form-control">
<option value="">Select</option>
<option value="AL">Alabama</option>
<option value="AK">Alaska</option>
<option value="AZ">Arizona</option>
<option value="AR">Arkansas</option>
<option value="CA">California</option>
<option value="CO">Colorado</option>
<option value="CT">Connecticut</option>
<option value="DE">Delaware</option>
<option value="DC">District of Columbia</option>
<option value="FL">Florida</option>
<option value="GA">Georgia</option>
<option value="HI">Hawaii</option>
<option value="ID">Idaho</option>
<option value="IL">Illinois</option>
<option value="IN">Indiana</option>
<option value="IA">Iowa</option>
<option value="KS">Kansas</option>
<option value="KY">Kentucky</option>
<option value="LA">Louisiana</option>
<option value="ME">Maine</option>
<option value="MD">Maryland</option>
<option value="MA">Massachusetts</option>
<option value="MI">Michigan</option>
<option value="MN">Minnesota</option>
<option value="MS">Mississippi</option>
<option value="MO">Missouri</option>
<option value="MT">Montana</option>
<option value="NE">Nebraska</option>
<option value="NV">Nevada</option>
<option value="NH">New Hampshire</option>
<option value="NJ">New Jersey</option>
<option value="NM">New Mexico</option>
<option value="NY">New York</option>
<option value="NC">North Carolina</option>
<option value="ND">North Dakota</option>
<option value="OH">Ohio</option>
<option value="OK">Oklahoma</option>
<option value="OR">Oregon</option>
<option value="PA">Pennsylvania</option>
<option value="RI">Rhode Island</option>
<option value="SC">South Carolina</option>
<option value="SD">South Dakota</option>
<option value="TN">Tennessee</option>
<option value="TX">Texas</option>
<option value="UT">Utah</option>
<option value="VT">Vermont</option>
<option value="VA">Virginia</option>
<option value="WA">Washington</option>
<option value="WV">West Virginia</option>
<option value="WI">Wisconsin</option>
<option value="WY">Wyoming</option>
</select>
<label class="col-sm-2 control-label">Zip</label>
<input type="text" name="zip" class="form-control" value="<?php echo htmlentities($result->zip);?>">
<label class="col-sm-2 control-label">Description</label>
<textarea style="height:100px" wrap="soft" name="description" class="form-control" ><?php echo htmlentities($result->description);?></textarea>
<input type="hidden" name="image" value="<?php echo htmlentities($result->image);?>" >
<input type="hidden" name="idedit" value="<?php echo htmlentities($result->id);?>" >
<button class="btn btn-primary" name="submit" type="submit">SAVE CHANGES</button>
</form>
</body>
</html>
<?php } ?>
解决方案
推荐阅读
- odata - Excel Power Query:将参数传递给 oDataFeed URL 会引发错误
- c# - NodaTime - 我可以更改 Instant 的默认 xml 序列化吗?
- excel - Excel 将从 csv 数字导入的文本转换为文本
- google-cloud-platform - 无服务器框架中的谷歌云平台 API 网关?
- java - 如何重构在 Java 中有重复模式的代码?
- git - 无法将更改从我的终端推送到 GitHub
- unix - 如何删除文件中某些行中的特定字符?
- php - 在对 2 个或多个整数执行加法时获取所有进位数字的总和
- php - 预期类型“可迭代|对象”。找到“字符串”但不明白为什么
- python - 如何编辑此代码以便输入 GIF 文件?它允许我使用 JPG 和 PNG,但不能使用 GIF