Scripts for Sanitizing Strings
Create a file and call it index.php and insert the following code or download it here.
[code]<!DOCTYPE html>
<html>
<head>
<title>SANITIZE STRINGS BEFORE INSERTING INTO DATABASE PHP MYSQL AJAX JQUERY </title>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
</head>
<body>
<input id="name" type="text" placeholder="Username">
<input id="email" type="text" placeholder="Email">
<input id="pass" type="password" placeholder="Password">
<input id="submit" type="button" value="Submit">
<div id="display"></div>
<script>
$(document).ready(function(){
$("#submit").click(function(){
var name = $("#name").val();
var email = $("#email").val();
var pass = $("#pass").val()
var dataString = ‘name1=’+ name + ‘&email1=’+ email+ ‘&pass1=’+ pass;
if(name==”||email==”||pass==”)
{
$("#display").html("Please Fill All Fields");
}
else
{
$.ajax({
type: "POST",
url: "processor.php",
data: dataString,
cache: false,
success: function(result){
$("#display").html(result);
}
});
}
return false;
});
});
</script>
</body>
</html>[/code]
Now create a script and call it processor.php and insert the following code. Optionally you can download it here.
[php]<?php
include_once(‘config.php’);
$name=mysqli_real_escape_string($con, $_POST[‘name1′]);
$nameclean = filter_var($name, FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_HIGH);
$email=mysqli_real_escape_string($con, $_POST[’email1′]);
$emailclean = filter_var($email, FILTER_SANITIZE_EMAIL, FILTER_FLAG_STRIP_HIGH);
$pass=mysqli_real_escape_string($con, $_POST[‘pass1’]);
$passclean = filter_var($pass, FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_HIGH);
$hash=sha1(md5($passclean));
mysqli_query($con,"INSERT INTO users(`username`, `email`, `password`)VALUES(‘$name’,’$email’,’$hash’)");
echo ‘<strong>’.$name.'</strong><br/>’;
echo ‘<strong>’.$email.'</strong><br/>’;
echo ‘This is the password:<strong>’.$pass.'</strong><br/>’;
echo ‘This is the encrypted password: <strong>’.$hash.'</strong><br/>test’;
$con->close();
?>[/php]
You will also need a config.php to connect to your database.
[php]<?php
$con = mysqli_connect("localhost","dbusername","dbpass","dbname");
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}else{
echo "";
}
?>[/php]
A1WEBSITEPRO Social Media Pages
Here are my social media pages, lets hook up!