将数据存入数据库PHP:
<?PHP
header("Content-Type: text/html; charset=utf-8");
include('conn.php');//链接数据库
//1、设置变量来接收表单提交过来的值
$article_name = $_POST['art_name'];
$checkbox = $_POST['checkbox'];
$content = $_POST['content'];
$input_name = $_POST['input_name'];
$input_number = $_POST['input_number'];
$input_ewm = $_POST['input_ewm'];
$input_title = $_POST['input_title'];
$input_describe = $_POST['input_describe'];
$input_image = $_POST['input_image'];
//2、将数组转为字符串
$check_box=implode(',',$checkbox);
//3、插入到数据库
$sql="insert into article(id,article_name,check_box,radio_box,content,input_name,input_number,input_ewm,input_title,input_describe,input_image) values(null,'$article_name','".$check_box."','$_POST[radio_box]','$content','$input_name','$input_number','$input_ewm','$input_title','$input_describe','$input_image')";
$result = mysqli_query($conn,$sql);
echo $sql;
?>
PHP:
<?PHP
header("Content-Type: text/html; charset=utf-8");
include('conn.php');//链接数据库
$sql = "select * from article";
$res = mysqli_query($conn,$sql);
$arr = [];
while ($row = mysqli_fetch_array($res)) {
$arr[] = $row['article_name'];
$arr[] = $row['check_box'];
$arr[] = $row['radio_box'];
$arr[] = $row['content'];
$arr[] = $row['input_name'];
$arr[] = $row['input_number'];
$arr[] = $row['input_ewm'];
$arr[] = $row['input_title'];
$arr[] = $row['input_describe'];
$arr[] = $row['input_image'];
}
echo json_encode($arr);
?>
HTML:
<textarea id="editor_id" name="content" style="width:1200px;height:430px;"></textarea>
<div class="div_imgall">
<input type="file" class="input_flie" name="input_ewm" rel="file" id="input_ewm"/>
<div class="jiahao">
<div class="div_shuline"></div>
<div class="div_hengline"></div>
</div>
<img src="" alt="" id="preview" style="position: absolute;width: 120px;height: 120px;padding: 8px 12px 12px 9px;z-index: 6;"/>
</div>
<script>
//编辑获取数据库数据
$(document).ready(function(){
$.ajax({
url : "./php/edit.php",//后台请求的数据,用的是PHP
type : "post",//请求方式
async : false,//是否异步请求
success : function(msg) { //如果请求成功,返回数据。
var data = JSON.parse(msg);
$("#art_name").val(data[0]);
$("#editor_id").val(data[3]);
$("#show").append(data[3]);
$("#preview").append(data[6]);
$("#img_ewm").append(data[6]);
console.log(data[3]);
console.log(data[6]);
},
})
})
</script>
编辑页想要获取数据库中的名称,AJAX已经获取到了返回值:
撒谎关键是杰哥看杀戮光环埃利斯能隔扣那可就能干
xigua.jpg
textarea内容输入框里面没有显示,呈空白状态,同时图片也能获取到,input上传区域输出图片prview也是空白的,怎么样能让textarea内容输入框和input上传框中的prview显示获取到的内容与图片?