$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; } } }