$connect = mysqli_connect('localhost', 'root', '', 'blog');
if($connect == false){
echo 'Произошла ошибка подключения к БД';
exit;
}
function get_posts($connect){
$sql = "SELECT * FROM posts";
$result = mysqli_query($connect, $sql);
$posts = mysqli_fetch_all($result, MYSQLI_ASSOC);
return $posts;
}
<?php foreach($posts as $post) { ?>
<h1>
<?=$post["title"]?>
</h1>
<?php } ?>
<?=$post["название столбца в БД"]?>
<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel">Подтверждение удаление записи</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
Вы точно хотите удалить запись?
</div>
<div class="modal-footer">
<button type="button" class="btn btn-primary">Да</button>
<button type="button" class="btn btn-secondary" data-dismiss="modal">Нет</button>
</div>
</div>
</div>
</div>
Warning: Cannot modify header information - headers already sent by (output started at D:\OpenServer\OSPanel\domains\heyoneblog\includes\header.php:7) in D:\OpenServer\OSPanel\domains\heyoneblog\post.php on line 9
$c = add_comment($connect);
if(!empty($c)){
header('Location: post.php');
}
function add_comment($connect){
$name = $_POST['name'];
$text = $_POST['text'];
if(!empty($_POST)){
$sql = "INSERT INTO comments (`name`, `text`) VALUES ('$name', '$text')";
$result = mysqli_query($connect, $sql);
return $result;
}
}
<?php
require_once 'includes/connect.php';
require_once 'includes/function.php';
require_once 'includes/header.php';
add_comment($connect);
$post_id = $_GET['post_id'];
$separate_post = get_post_by_id($post_id);
$categories = get_category($connect);
?>
<!-- Comments Form -->
<div class="card my-4">
<h5 class="card-header">Оставить комментарий:</h5>
<div class="card-body">
<form method="post">
<div class="form-group">
<input type="text" class="form-control" placeholder="Ваше Имя:" name="name"><br>
<textarea class="form-control" rows="3" name="text"></textarea>
</div>
<button type="submit" class="btn btn-primary">Отправить</button>
</form>
</div>
</div>
function add_comment ($connect){
$name = $_POST['name'];
$text = $_POST['text'];
if(!empty($_POST)){
$sql = "INSERT INTO comments (`name`, `text`) VALUES ('$name', '$text')";
$result = mysqli_query($connect, $sql);
return $result;
header("Location: {$_SERVER['PHP_SELF']}");
exit;
}
}
function add_comment ($connect){
$name = $_POST['name'];
$text = $_POST['text'];
if(!empty($_POST)){
$sql = "INSERT INTO comments (`name`, `text`) VALUES ('$name', '$text')";
$result = mysqli_query($connect, $sql);
return $result;
}
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on null in D:\OpenServer\OSPanel\domains\lesson\function.php:26 Stack trace: #0 D:\OpenServer\OSPanel\domains\lesson\category.php(8): get_post_by_category(Object(mysqli), '1') #1 {main} thrown in D:\OpenServer\OSPanel\domains\lesson\function.php on line 26
while($art = mysqli_fetch_assoc($articles)){
<div class="text">
<div class="article">
<h2><?php echo $art[0]['title']; ?></h2>
<p><?php echo $art[0]['text']; ?></p>
</div>
</div>
}