NLCJ Posted May 3, 2010 Share Posted May 3, 2010 Hello, I've run into another (simple) problem. Lets say I've got this: $variable1 = "12"; $variable2 = "Testin' this system"; mysql_query("INSERT INTO tablename ('id', 'name') VALUES ('".$variable1."', '".$variable2."')"); That will look like this: mysql_query("INSERT INTO tablename ('id', 'name') VALUES ('12', 'Testin' this system'"); So, how do I get this right into the database? Regards, Link to comment https://forums.phpfreaks.com/topic/200553-using-in-a-mysql-command/ Share on other sites More sharing options...
trq Posted May 3, 2010 Share Posted May 3, 2010 mysql_real_escape_string should be used on ALL user inputted data in EVERY query. Link to comment https://forums.phpfreaks.com/topic/200553-using-in-a-mysql-command/#findComment-1052363 Share on other sites More sharing options...
NLCJ Posted May 3, 2010 Author Share Posted May 3, 2010 mysql_real_escape_string should be used on ALL user inputted data in EVERY query. I know, but I don't want that there comes a \'... I trust this source 100% so that will be fine... Link to comment https://forums.phpfreaks.com/topic/200553-using-in-a-mysql-command/#findComment-1052367 Share on other sites More sharing options...
Mchl Posted May 3, 2010 Share Posted May 3, 2010 mysql_real_escape_string should be used on ALL user inputted data in EVERY query. I know, but I don't want that there comes a \'... I trust this source 100% so that will be fine... Well then, there's only magick left for you... A \ will not be saved to database, so I don't know why you might not like it. Link to comment https://forums.phpfreaks.com/topic/200553-using-in-a-mysql-command/#findComment-1052370 Share on other sites More sharing options...
NLCJ Posted May 3, 2010 Author Share Posted May 3, 2010 Thank you! Dumb me... Link to comment https://forums.phpfreaks.com/topic/200553-using-in-a-mysql-command/#findComment-1052379 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.