This is an error after changing to php8.3 and MariaDB 11.3.
Where did I go wrong?
Please take a look.
echo “$_SESSION[Iyagi_Id]’,’$today’,’$img’,’$title’,’$weath’,’$mood1′,’$mood2′,’$happy’,’$love’,’$c[web_edit]’,’$text”;
The input values are as follows.
1111′,’2024-5-15′,”,’This is the title.’,”,”,”,”,”,”,’This is the content.
Maria DB (11.3) Query (line 72)
mysqli_query($connect , "insert into hani_diary (id,day,img,title,weath,mood1,mood2,happy,love,html,text) values('$_SESSION[Iyagi_Id]','$today','$img','$title','$weath','$mood1','$mood2','$happy','$love','$c[web_edit]','".mysqli_real_escape_string($connect, $text)."')") or die("입력 에러");
js_move("./memo_write.php?year=$year&month=$month&day=$day");
Error message
Fatal error: Uncaught mysqli_sql_exception: Incorrect integer value: ” for column gagebu
.hani_diary
.happy
at row 1 in /home/gagebu/www/memo/memo_write.php:72 Stack trace: #0 /home/gagebu/www/memo/memo_write.php(72): mysqli_query() #1 {main} thrown in /home/gagebu/www/memo/memo_write.php on line 72
I am trying to insert data into Maria DB.