Modify a PHP login script by adding PHP PDO - repost

This project received 19 bids from talented freelancers with an average bid price of $44 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
Total Bids
Project Description

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_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
$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);
3. After modification, the scrip will be working smoothly.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online