Strip Characters ??

[DrTrans]

 

 

$name = "D'Angelo" 

 

ok I'm running a mysql query as

 

$query = " INSERT INTO TEST (ID, NAME) VALUES ('NULL','$NAME')";

 

 

If the name = "D'Angelo" the apostrophe would cause it to fail. Is there a way to do this without striping the characters? 

 

[AyKay47]

mysql_real_escape_string

[scootstah]

Use prepared statements (preferred) or escape it like AyKay said.

[AyKay47]

Use prepared statements (preferred) or escape it like AyKay said.

yes, you will need the PDO driver for prepared statements if you choose to go that route, depending on what PHP version you are running, you may or may not have the driver installed/enabled.

[scootstah]

Use prepared statements (preferred) or escape it like AyKay said.

yes, you will need the PDO driver for prepared statements if you choose to go that route, depending on what PHP version you are running, you may or may not have the driver installed/enabled.

 

Or mysqli.