Inserting Data into MySQL Database with PHP problem

#1064 - 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 's neck. It is strong and rust-resistant Buy Trixie Long Link Choke chain, stainl' at line 1

If you are working with PHP, Mysql and you are getting error by single quote in string. It is possible to escape the apostrophe so that string is correctly inserted into the database table.

Before:

$conn = mysqli_connect('localhost','root','','dbname') or die('Error connecting to MySQL server.');

$cust_name = $_POST['cust_name'];

If you are using above syntax for getting data from form elements then you are getting the above error.

Here, Try your query again after replacing the PHP code with mysql_real_escape_string PHP function that collects the form element value and inserted into database without any error.

Now:

$conn = mysqli_connect('localhost','root','','dbname') or die('Error connecting to MySQL server.');

$cust_name  = mysqli_real_escape_string($conn, $_POST['cust_name']);

For more details, You can visit on below mention link

mysqli real escape string