Jump to content

os.execute mysql escapes


Recommended Posts

Hi, I've got a slight problem. Our ingame report system uses mysql to place it in the database upon which we can respond via the admin panel. upon finishing this system I came into an issue, because of mysql dislikes any special characters (example -/'`!@) I tried using escapes in the mysql query but couldn't make it work

any ideas?

			local cmd="mysql -u root kwix --execute='insert into kwix_tickets (user, mail, title, content) values ('".. name1 .."', '".. mail .."', '".. title .."', '".. msg .."');'"
			os.execute(cmd)
Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.