如何将默认字符串与表单一起发送?

<?php
require_once 'connection.php';
$slug = '';
if(isset($_POST["create"])){ 
$slug = preg_replace('/[^a-z0-9]+/i', '-', trim(strtolower($_POST["title"])));
$query = "SELECT slug_url FROM bn_publicacao WHERE slug_url LIKE '$slug%'";
$statement = $conn->prepare($query); 
if($statement->execute()){
$total_row = $statement->rowCount();
if($total_row > 0){
$result = $statement->fetchAll();
foreach($result as $row){
$data[] = $row['slug_url'];
}
if(in_array($slug, $data)){
$count = 0;
while( in_array( ($slug . '-' . ++$count ), $data) );
$slug = $slug . '-' . $count;
}
}
}
$insert_data = array(
':title'      => $_POST['title'],
':descricao'  => $_POST['descricao'],
':capa'       => $_POST['capa'],
':alt'        => $_POST['alt'],
':keywords'   => $_POST['keywords'],
':categoria'  => $_POST['categoria'],
':slug_url'   => $slug,
':slug_link'  => $slug,
':entry_type' => $_POST['entry_type'],
);
$query = "INSERT INTO bn_publicacao (title, descricao, capa, alt, keywords, categoria, slug_url, slug_link, entry_type) VALUES (:title, :descricao, :capa, :alt, :keywords, :categoria, :slug_url, :slug_link, :entry_type)";
$statement = $conn->prepare($query);
$statement->execute($insert_data);    
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Form</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />  
<style>
.box
{
max-width:600px;
width:100%;
margin: 0 auto;;
}
</style>
</head>
<body>
<div class="container box">
<br />
<h3 align="center">Gravar post</h3>
<br />
<form method="post">
<div class="form-group">
<label>Title</label>
<input type="text" name="title" class="form-control mb-3" required />
<label>Descicao</label>
<input type="text" name="descricao" class="form-control mb-3" required />
<label>Capa</label>
<input type="text" name="capa" class="form-control mb-3" required />
<label>Alt</label>
<input type="text" name="alt" class="form-control mb-3" required />
<label>Keywords</label>
<input type="text" name="keywords" class="form-control mb-3" required />
<label>Categoria</label>
<input type="text" name="categoria" class="form-control mb-3" required />
<label>Entry_type</label>
<input type="text" name="entry_type" class="form-control mb-3" required />
</div>
<br />
<div class="form-group">
<input type="submit" name="create" class="btn btn-info" value="Enviar" />
</div>
<br />
<h4>Generated Slug - <?php echo $slug; ?></h4>
</form>
</div>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>  
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
</body>
</html>

input"title"自动生成一个 slug 会发送到列slug_url和slug_link，我需要在slug_url上一起发送默认字符串。

我想在列slug_url中添加一个默认网址。

例：

我想将此网址添加为默认生成的"http://example.com/">

这是蛞蝓到列蛞蝓网址

这就是它应该发送到我的专栏slug_url的方式：

http://example.com/this-is-the-slug-gererated-to-the-column-slug-url

你可以添加这样的东西

':slug_url' => "https://example.com/".$slug,

很简单，只需更改这部分代码：

$insert_data = array(
':title'      => $_POST['title'],
':descricao'  => $_POST['descricao'],
':capa'       => $_POST['capa'],
':alt'        => $_POST['alt'],
':keywords'   => $_POST['keywords'],
':categoria'  => $_POST['categoria'],
':slug_url'   => "https://example.com/$slug",
':slug_link'  => $slug,
':entry_type' => $_POST['entry_type'],
);

请注意，我刚刚更改了：slug_url 列的行设置

相关内容

最新更新

热门标签：