Modify a PHP login script by adding PHP PDO - repost
$30-50 USD
Paid on delivery
We need help for a small project from PHP expert who can handle PHP POD very well. If it goes well, there will be more projects coming.
We got a PHP login script that works very well but we need to add some security features to make it more secure. We want the script to have following modification and but maintain largely original code:
1. Use PHP PDO to connect mysql database. Please see the example:
try {
$db = new PDO("mysql:host=".DBHOST.";dbname=".DBNAME, DBUSER, DBPASS);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
}catch (Exception $e){
die('Cannot connect to mySQL server.');
}
2. Use PHP PDO to interact with mysql database. See the example:
function create_account(){
//Create new account
$this->hash($this->pass);
$sql = 'INSERT into users (username, password, email) VALUES (:username, :password, :email)';
$statement = $this->db->prepare($sql);
$statement->bindParam(':username', $this->user, PDO::PARAM_STR);
$statement->bindParam(':password', $this->pass, PDO::PARAM_STR);
$statement->bindParam(':email', $this->email, PDO::PARAM_STR);
$statement->execute();
}
3. After modification, the scrip will be working smoothly.
Project ID: #4352358
About the project
14 freelancers are bidding on average $40 for this job
We have 8+ years experience in web development in php, we are ready to work with you, please check my "PMB".
Hi I'm a PHP expert with more than 12 years of experience... I'm a responsable, honest hard working professional.... I'm here to serve you... thanks for considering my proposal.
Hi there, web programmer expert ready to start right away. It's a simple project for me, looking forward working with you, regards
