Code Snippets

Quick wrapper function to sanitize input before processing with Mysql | php

You always need to sanitize when taking input and posting to your DB. You can do it the long hand way, or wrap it with a short named function like this.

// // change _sanitize to whatever you want
// // assumes mysql*I* not mysql

function _sanitize($input) {

        global $con; // // $con is the name of the connection.  We pull this as a global.
	return mysqli_real_escape_string($con,$input); // // return sanitized input, ready to UPDATE, INSERT, whatever

Published: Sun 24th December 2017
||COMMENTS|| This site proudly uses PrismJS to display code snippets

If you like this page, please share it.

Code Links - PHP, JS, CSS, Bootstrap, Bash, Emmet, IntelliJ, Sublime etc.

My personal list of links which I keep here publicly incase they help someone else one day.

Code Snippets

Snippets of PHP code I have gathered over the years. I keep them here for my own repository but also to share with others. I always link back when I remember the source.

My Github Repos

A work in progress. I am going to make as many modules that I write in my devbox public as possible.

Kit's Homepage

This site was originally intended as a test bed for code. It now includes my blog about business and powerlifting, as well as games for Spanish language learning

© 2018