输入法所见即所得编辑器不在mysql数据库中存储值
Input method WYSIWYG editor not storing values in mysql database?
我使用所见即所得编辑器在门户中输入工作描述,但它没有将值存储到databe这是我的代码
<form class="form-horizontal" role="form" action="<?php $_SERVER['PHP_SELF'] ?>" method="POST">
<div class="form-group">
<label class="control-label col-sm-2" for="jtitle">Job Title</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="jtitle" name="jtitle" placeholder="Enter job title">
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="duration">Job Duration</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="duration" name="duration" placeholder="Enter duration">
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="budget">Budget</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="Budget" name="budget" placeholder="Enter Budget">
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="keyskills">Key Skills</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="keyskills" name="keyskills"placeholder="Enter Skills">
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="jobdescription">Job Description</label>
<div class="col-sm-10">
<input type="textarea" rows="1000" class="form-control" id="jobdescription" name="jobdescription" placeholder="Enter Job Description">
<script type="text/javascript">
CKEDITOR.replace( 'jobdescription' );
</script>
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="edate">Expiry Date</label>
<div class="col-sm-10">
<input type="date" class="form-control" id="edate" name="edate" placeholder="Click to enter expiry date">
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="cdexmin">Candidate Experience Minimum</label>
<div class="col-sm-10">
<input type="number" class="form-control" id="cdexmin" name="cdexmin" placeholder="Enter Minimum Experience">
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="cdexmax">Candidate Experience Maximum</label>
<div class="col-sm-10">
<input type="number" class="form-control" id="cdexmax" name="cdexmax" placeholder="Enter Maximum Experience">
</div>
</div>
<div class="form-group">
<div class="col-sm-offset-2 col-sm-10">
<button type="submit" name="submit" class="btn btn-default">Post Job</button>
</div>
</div>
</form>
<?php
if(isset($_POST['submit'])) {
try {
// Establish server connection and select database
$username=$_SESSION['username'];
$stmt = $db->prepare("SELECT * FROM employer
INNER JOIN company ON employer.cid= company.cid
WHERE employer.username='$username' ");
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
$cid=$row['cid'];
$eid=$row['eid'];
$jtitle=$_POST['jtitle'];
$duration=$_POST['duration'];
$budget=$_POST['budget'];
$keyskills=$_POST['keyskills'];
$jobdescription=$_POST['jobdescription'];
$edate=$_POST['edate'];
$cdexmin=$_POST['cdexmin'];
$cdexmax=$_POST['cdexmax'];
$stmt = $db->prepare("INSERT INTO
job(cid,eid,jtitle,duration,budget,
keyskills,jdesc,edate,
cdexmin,cdexmax)
values('$cid','$eid','$jtitle','$duration','$budget',
'$keyskills','$jobdescription','$edate',
'$cdexmin','$cdexmax') ");
$stmt->execute();
$result="Successfully Job Posted to view your Job It should be activated by Admin";
header("Location:/emprdash?success=1");
} catch(PDOException $e){
echo "Error occurs:". $e->getMessage();
}
}
?>
所有值都在输入,但工作描述不仅没有更新我下载了ckeditor,还将文件上传到了服务器,我在页面中附加了javascript ckeditor.js,但没有将值更新到表单中是否存在任何错误,或者我可以对此做些什么
Gowri,输入标签中没有可用的文本区域类型,因此请更改以下代码
<input type="textarea" rows="1000" class="form-control" id="jobdescription" name="jobdescription" placeholder="Enter Job Description">
至
<textarea rows="1000" class="form-control" id="jobdescription" name="jobdescription" placeholder="Enter Job Description"></textarea>
相关文章:
- 如何在本地存储(或其他数据库)上安全地保存敏感访问代码
- Codeigniter:通过Ajax上传图像并存储在数据库中
- 使用node-js上传文件,并将表单信息存储在数据库(mysql)中
- 如何离线存储数据库,在线时共享到服务器
- 我的地图数据's不会使用php存储在mysql数据库中
- 将动态feild数据存储到jquery-mobile和php-mysql中的数据库中
- 将Javascript对象存储在Wordpress用户数据库中
- 为数据库存储设置角度日期格式
- 如何获取所有旅行模式的距离和持续时间,例如驾驶,公交,骑自行车,在我的页面中步行以及将其存储在数据库中
- 我想从网站收集数据并使用PHP将它们存储在数据库中
- 将SQLite数据库存储在IndexedDB中
- 将数据库存储/备份到一个文件中,IndexeDB、WebSQL和SQLlite的区别
- Android WebView 数据库存储返回 null
- 删除 localStorage,Chrome/Chromium 中选项卡的数据库存储
- 如何在事务中创建索引数据库存储
- 是从javascript对象还是后端数据库存储和检索数据
- 在React Native中从Firebase数据库/存储中加载并返回图像
- 网站如何使用cookie或本地存储或数据库存储来存储持久/临时状态?
- 动态填充的图表数据和数据库存储
- 一个Meteor.com托管的应用程序有多少数据库存储空间