Why is my insert not working in php?

Answer 1

Try

$notes_result = $conn->query($notes_sql) or die(mysqli_error($conn)); 

To get an updated error.

If the echoed SQL works fine you have to guess it's a connection or permissions issue. Are you doing an insert anywhere else?

Edit: So it's a permissions issue, run this:

GRANT INSERT PRIVILEGES ON *.* TO 'ideapale_amquery'@'localhost' 

However, if you don't believe you need to, try this first:

SHOW GRANTS FOR 'ideapale_amquery'@'localhost'

Answer 2

You should check and see what the error being returned is.

Change: die(mysqli_error())
To: die(mysqli_error($conn))

Answer 3

You claim to be connecting with the ideapale_amadmin user, but the error message INSERT command denied to user 'ideapale_amquery'@'localhost' for table 'notes' clearly shows that you are not. You are using the wrong MySQLi object (i.e. a connection you created earlier on in the script) or are passing the wrong parameter to dbConnect().