Cannot insert into mysql database

Community support
#1

Hi, i’m trying to insert some data to my database, but its not working and im not sure why. im fairly new to all this.

chronosadmin.php:

<?php 
if(isset($_POST['sve'])){

$conn = mysqli_connect("localhost", "dbuser", "dbpass","dbname");

if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

mysqli_select_db($conn,"dbname");

$ev_name = $_POST['namev'];
$ev_date =  $_POST['datev'];
$ev_time = $_POST['timev'];
$ev_venue = $_POST['venuev'];
$ev_etc = $_POST['etcv'];	

$sql ="INSERT INTO `event` (`ename`, `edate`, `etime`, `evenue`, `etc`)
	VALUES ('$ev_name','$ev_date','$ev_time', '$ev_venue', '$ev_etc')";
		
if(mysqli_query($conn,$sql)){
	echo 'Data Inserted';
}else{
	echo 'Data Not Inserted';
}	
mysqli_close($conn);		
 }
 ?>

here’s the html part (still under chronosadmin.php):

<input type="submit" class="ad" value="ADD" onclick="openForm()">

<form action="/chronosadmin.php" class="form-container">
  <h1>ADD EVENT</h1>
<label for="namev"><b>Name:</b></label>
<input type="text" id="namev" required>

<label for="datev"><b>Date:</b></label>
<input type="date" id="datev" required>

<label for="timev"><b>Time:</b></label>
<input type="time" id="timev" required>

<label for="venuev"><b>Venue:</b></label>
<input type="text" id="venuev" required>

<label for="etcv"><b>Other:</b></label>
<input type="text" id="etcv">

<button type="submit" class="btn" name="sve">Save</button>
<button type="button" class="btn cancel" onclick="closeForm()">Cancel</button>
 </form>
</div>

I have tried to directly type the INSERT INTRO in my database without the $variables and it does insert it correctly. so im kinda lost as to why it wont.

#2

Hi !

Use this query instead. Note we’re using MariaDB system:

$sql ="INSERT INTO event(ename, edate, etime, evenue, etc)
	VALUES ('$ev_name','$ev_date','$ev_time', '$ev_venue', '$ev_etc')";
#3

Hi!

I tried it but it still doesnt work. There’s also no error showing.

#4

Try this code. It should show the error, if exists.

if(mysqli_query($conn,$sql)){
	echo 'Data Inserted';
}else{
    echo mysqli_error($conn);
}