Click here to Skip to main content
15,886,258 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
PinnedForum Guidelines - PLEASE READ PinPopular
Chris Maunder28-Jul-09 2:39
cofounderChris Maunder28-Jul-09 2:39 
Questionexample paypal payments Pin
vic5321-Mar-24 10:18
professionalvic5321-Mar-24 10:18 
Questionphp Pin
Dancane Odiwuor18-Dec-23 3:49
Dancane Odiwuor18-Dec-23 3:49 
AnswerRe: php Pin
Richard MacCutchan18-Dec-23 5:01
mveRichard MacCutchan18-Dec-23 5:01 
QuestionPHP 8.2 - Unsupported operand types: string * int Pin
Aruna KN13-Jun-23 19:48
Aruna KN13-Jun-23 19:48 
AnswerRe: PHP 8.2 - Unsupported operand types: string * int Pin
Richard MacCutchan13-Jun-23 21:10
mveRichard MacCutchan13-Jun-23 21:10 
AnswerRe: PHP 8.2 - Unsupported operand types: string * int Pin
Member 102471327-Mar-24 23:38
Member 102471327-Mar-24 23:38 
QuestionChoosing an editor Pin
jpaxtons9-Jun-23 9:48
jpaxtons9-Jun-23 9:48 
AnswerRe: Choosing an editor Pin
Deepak Vasudevan23-Aug-23 1:57
Deepak Vasudevan23-Aug-23 1:57 
QuestionFatal error: Uncaught Error: Call to a member function prepare() on null in Pin
Nicolas Veloso25-Apr-23 9:47
Nicolas Veloso25-Apr-23 9:47 
AnswerRe: Fatal error: Uncaught Error: Call to a member function prepare() on null in Pin
Richard MacCutchan25-Apr-23 9:58
mveRichard MacCutchan25-Apr-23 9:58 
Question.htaccess Query String Redirect Pin
Aruna KN20-Apr-23 5:05
Aruna KN20-Apr-23 5:05 
QuestionPHP Warning: Attempt to read property "post_content" on null Pin
Aruna KN17-Apr-23 23:09
Aruna KN17-Apr-23 23:09 
AnswerRe: PHP Warning: Attempt to read property "post_content" on null Pin
Richard MacCutchan17-Apr-23 23:59
mveRichard MacCutchan17-Apr-23 23:59 
QuestionProper parameterised queries for database access Pin
Aruna KN11-Apr-23 6:35
Aruna KN11-Apr-23 6:35 
AnswerRe: Proper parameterised queries for database access Pin
Afzaal Ahmad Zeeshan11-Apr-23 10:11
professionalAfzaal Ahmad Zeeshan11-Apr-23 10:11 
GeneralRe: Proper parameterised queries for database access Pin
Aruna KN11-Apr-23 18:25
Aruna KN11-Apr-23 18:25 
GeneralRe: Proper parameterised queries for database access Pin
Richard MacCutchan11-Apr-23 21:52
mveRichard MacCutchan11-Apr-23 21:52 
GeneralRe: Proper parameterised queries for database access Pin
Aruna KN11-Apr-23 22:13
Aruna KN11-Apr-23 22:13 
GeneralRe: Proper parameterised queries for database access Pin
Richard MacCutchan11-Apr-23 22:29
mveRichard MacCutchan11-Apr-23 22:29 
GeneralRe: Proper parameterised queries for database access Pin
Aruna KN12-Apr-23 1:34
Aruna KN12-Apr-23 1:34 
QuestionPHP Fatal error: Uncaught mysqli_sql_exception Pin
Aruna KN10-Apr-23 4:47
Aruna KN10-Apr-23 4:47 
I was using a PHP script for a simple message service without any issue upto PHP 7.4, but when I upgrade the PHP version into 8.1, it gives following error_log when trying to send a new message containing "'" eg: I'm ok brother

PHP Fatal error:  Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'm ok brother
')' at line 1 in send_message.php:9


Full code of send_message.php

PHP
<?php
include_once 'include/config.inc.php';
include_once 'include/options.inc.php';
include_once 'include/security.inc.php';
include_once 'include/functions.inc.php';
include_once 'templates/'.C_TEMP.'/config.php';
 if( isset($_POST['message']) && isset($_POST['sender_id']) && isset($_POST['receiver_id']) && $_POST['message'] != "" && $_POST['sender_id'] != "" && $_POST['receiver_id'] != "")
 {
	mysqli_query($conn,"INSERT INTO ".C_MYSQL_MESSAGES."(`sender_id`,`receiver_id`,`message`) VALUES (".$_POST['sender_id'].",".$_POST['receiver_id'].",'".$_POST['message']."')");
	
	echo 1;
 }
 else
 {   
    echo 0;
 }
 ?>


Please suggest me a solution
AnswerRe: PHP Fatal error: Uncaught mysqli_sql_exception Pin
Richard MacCutchan10-Apr-23 6:04
mveRichard MacCutchan10-Apr-23 6:04 
GeneralRe: PHP Fatal error: Uncaught mysqli_sql_exception Pin
Aruna KN10-Apr-23 6:41
Aruna KN10-Apr-23 6:41 
GeneralRe: PHP Fatal error: Uncaught mysqli_sql_exception Pin
Richard MacCutchan10-Apr-23 6:56
mveRichard MacCutchan10-Apr-23 6:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.