Jump to content

Getting information from Database

Recommended Posts

Hello everyone,

I am running into an issue now to where I am trying to get information from a database but it is only happening when there is an apostrophe in the text. Meaning things, getting the data from the database, there is a word with an apostrophe in it. I get all the information from the start up to the point where the apostrophe is at. For example:

The cat can't jump over water.

What I will get is this:

The can can 

Then I don't get the rest of my data.


Here is the code I am dealing with. Any help would be great.

$id = $_POST['id'];
$title = $_POST['title'];
$writer = $_POST['writer'];
$description = $_POST['description'];
$date_created = $_POST['date_created'];
$message = $_POST['message'];

echo "By: ".$writer;
echo "Title: ".$title;
echo "Description: ".$description;
echo "Message: ".nl2br($message);


Link to post
Share on other sites

That code doesn't contain any database interaction, but if you're having problems with single quotes then it sounds like you're not using prepared statements to insert data into your database, which would mean that your site is open to SQL injection, which has been the #1 attack vector against web sites for quite a while.  You really need to use prepared statements whenever you're trying to move data to your database.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...