php error
I am working with xampp and mysql , i have created there a table with columns but when i insert data it says : MySQL returned an empty result set (i.e. zero rows). (Query took 0.0021 seconds.)
<?php
// Include the database connection file
include '../database.php';
if (isset($_POST["submit"])) {
//validimi i te dhenave
$amount = isset($_POST["amount"]) ? mysqli_real_escape_string($conn, $_POST["amount"]) : 0;
$source = isset($_POST["source"]) ? mysqli_real_escape_string($conn, $_POST["source"]) : '';
$date = isset($_POST["date"]) ? mysqli_real_escape_string($conn, $_POST["date"]) : '';
$confirm = isset($_POST["confirm"]) ? 1 : 0;
//Insertimi i te dhenave ne databaz
$query = "INSERT INTO buxheti (amount, source,
if (mysqli_query($conn, $query)) {
echo "<script>alert('Data inserted successfully');</script>";
} else {
echo "<script>alert('Error: " . mysqli_error($conn) . "');</script>";
}
}
$query = "SELECT * FROM buxheti";
$result = mysqli_query($conn, $query);
?>
i am sending data through a form
<?php
// Include the database connection file
include '../database.php';
if (isset($_POST["submit"])) {
//validimi i te dhenave
$amount = isset($_POST["amount"]) ? mysqli_real_escape_string($conn, $_POST["amount"]) : 0;
$source = isset($_POST["source"]) ? mysqli_real_escape_string($conn, $_POST["source"]) : '';
$date = isset($_POST["date"]) ? mysqli_real_escape_string($conn, $_POST["date"]) : '';
$confirm = isset($_POST["confirm"]) ? 1 : 0;
//Insertimi i te dhenave ne databaz
$query = "INSERT INTO buxheti (amount, source,
dateif (mysqli_query($conn, $query)) {
echo "<script>alert('Data inserted successfully');</script>";
} else {
echo "<script>alert('Error: " . mysqli_error($conn) . "');</script>";
}
}
$query = "SELECT * FROM buxheti";
$result = mysqli_query($conn, $query);
?>
i am sending data through a form
A friendly place for developers to meet other devs, ask questions, get help, and just have a good time 🙂.
36,263Members
Resources
Similar Threads
Was this page helpful?
