<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$dbc = mysqli_connect('127.0.0.1', 'root', '', 'buy_sell_base');
mysqli_set_charset($dbc, $charset);
if(isset($_POST['submit'])){
$username = mysqli_real_escape_string($dbc, trim($_POST['username']));
$password1 = trim($_POST['password1']);
$password2 = trim($_POST['password2']);
if($username && $password1 && $password1 == $password2){
$query = "SELECT * FROM signup WHERE username ='$username'";
$data = mysqli_query($dbc, $query);
if(mysqli_num_rows($data) == 0){
$password = password_hash($password1, PASSWORD_DEFAULT);
$query = "INSERT INTO signup (username, password) VALUES ('$username', '$password')";
mysqli_query($dbc, $query);
echo 'Все готово';
exit();
}
else{
echo 'Пользователь уже зарегистрирован';
}
}
}$result = "SELECT stars_id, round(AVG(val),1) as average FROM stars GROUP BY stars_id";
$data = mysqli_query($connectBD, $result);
while ($row = mysql_fetch_assoc($data)) {
$stars[$row['stars_id']] = $row['average'];
}select g.*, round(AVG(val),1) as stars FROM goods g, stars s WHERE stars_id=g.id GROUP BY g.id<div class=\"col-md-4 col-sm-6 my-3 my-md-0\">
<form action=\"index.php\" method=\"post\">
<div class=\"card shadow\">
<a href='./index.php?product=$productid'><div class="col-md-4 col-sm-6 my-3 my-md-0">
<form action="index.php" method="post">
<div class="card shadow">
<a href="./index.php?product=<?=$productid?>">
<div id="card-top">