$data_miss[] = "vapros";
} else {
$id_vapros = trim($_POST['vapros']);
}
if (empty($_POST['avtor'])) {
$data_miss[] = "avtor";
} else {
$avtor = trim($_POST['avtor']);
}
if (empty($_POST['text'])) {
$data_miss[] = "text";
} else {
$text = trim($_POST['text']);
}
if (empty($data_miss)) {
$conn = mysqli_connect($servername, $username, $password, "asktues");
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
$query = "INSERT INTO otgovori1 (vapros, avtor, text) VALUES (?, ?, ?)";
$STATE = MYSQLI_PREPARE($conn, $query);
mysqli_stmt_bind_param($STATE, "iss", $id_vapros, $avtor, $text);
if (mysqli_STMT_EXECUTE($STATE)) {
echo "New record created successfully";
} else {
echo "Error: " . $query . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
}
}
} else {
$avtor = trim($_POST['avtor']);
}
if (empty($_POST['tema'])) {
$data_miss[] = "tema";
} else {
$tema = trim($_POST['tema']);
}
if (empty($_POST['vapros'])) {
$data_miss[] = "vapros";
} else {
$vapros = trim($_POST['vapros']);
}
if (empty($data_miss)) {
$dbc = mysqli_connect("127.0.0.1", "user_web", "", "asktues");
$query = "INSERT INTO vaprosi(zaglavie,avtor,text)\n\t\t\tVALUES (?, ?, ?)";
$STATE = MYSQLI_PREPARE($dbc, $query);
mysqli_stmt_bind_param($STATE, "sss", $tema, $avtor, $vapros);
mysqli_STMT_EXECUTE($STATE);
$affected_rows = mysqli_stmt_affected_rows($STATE);
if ($affected_rows == 1) {
mysqli_close($dbc);
} else {
mysqli_close($dbc);
}
} else {
foreach ($data_miss as $cow) {
echo $cow;
}
}
}
