How to store single quotes (oppose trophy) in SQL Table

How to store single quote in SQL Table

<?php
$string_codelizar = "Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s";

$output_string = mysqli_real_escape_string($conn,$string_codelizar ); // Here $conn is your database connection
$qry_data = "SELECT * FROM `demo_tbl` WHERE `dummycol` = '$output_string'";
?>

 

2 Replies to “How to store single quotes (oppose trophy) in SQL Table”

Leave a Reply

Your email address will not be published. Required fields are marked *