PDO - query working on wamp but on web server

Question

This is my login.php

<?php
error_reporting(E_ALL);
ini_set('display_errors',1);
include("config.php");
include("userClass.php");
$userClass = new userClass();

$errorMsgReg = '';
$errorMsgLogin = '';
/ * Login Form */

if (!empty($_POST['loginSubmit'])) {
    $usernameEmail = $_POST['usernameEmail'];
    $password = $_POST['password'];

    if (strlen(trim($usernameEmail)) > 1 && strlen(trim($password)) > 1) {

        $id = $userClass->userLogin($usernameEmail, $password);
        if(!$id)
        {
        echo "Not entering in userClass->Login";
        }

        if ($id) {
            // Not entering here
            $url = BASE_URL . 'welcome.php';          
            header("Location: $url");
        } else {
            echo "$id";
            $errorMsgLogin = "Please check login details.";

        }
     }
 }

And this is my userClass.php

<?php
error_reporting(E_ALL);
ini_set('display_errors',1);
class userClass
{
    /* User Login */
    public function userLogin($usernameEmail,$password)
    {
        try{
            $db = getDB();

            $hash_password= hash('sha256', $password); //Password encryption
            $stmt = $db->prepare("SELECT id FROM doctorlocation WHERE (doctorusername=:usernameEmail or doctoremail=:usernameEmail) AND doctorpassword=:hash_password"); 

            $stmt->bindParam("usernameEmail", $usernameEmail,PDO::PARAM_STR) ;
            $stmt->bindParam("hash_password", $hash_password,PDO::PARAM_STR) ;
            $stmt->execute();
            $count=$stmt->rowCount();
            $data=$stmt->fetch(PDO::FETCH_OBJ);
            $db = null;
            if($count)
            {
                $_SESSION['usernameEmail']=$usernameEmail; 
                $_SESSION['id']=$data->id; // Storing user session value
                return true;
            }   
            else
            {   
                return false;
                } 
            }
            catch(PDOException $e) {
                echo '{"error":{"text":'. $e->getMessage() .'}}';
            }

        }

My connection file, config.php

<?php
error_reporting(E_ALL);
ini_set('display_errors',1);
session_start();
/* DATABASE CONFIGURATION */
define('DB_SERVER', '******');
define('DB_USERNAME', '******');
define('DB_PASSWORD', '******');
define('DB_DATABASE', '*******');
define("BASE_URL", "******");



function getDB() 
{
$dbhost=DB_SERVER;
$dbuser=DB_USERNAME;
$dbpass=DB_PASSWORD;
$dbname=DB_DATABASE;
try {
$dbConnection = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass); 
$dbConnection->exec("set names utf8");
$dbConnection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

return $dbConnection;
}
catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();
}

}
?>

The error seems to be here $id = $userClass->userLogin($usernameEmail, $password);

It should be a small problem, cant seem to wrap my head around it. Any guidance would be helpful.

Thanks

@Fred-ii- actually you can use the same named placeholder, you just have to use emulated prepares. PDO::ATTR_EMULATE_PREPARES http://php.net/manual/en/pdo.setattribute.php — bassxzero, Feb 17 '17 at 18:02
@bassxzero You have a point there and probably why it only works on their local system and not on the live server — Funk Forty Niner, Feb 17 '17 at 18:03
@ais what kind of answer you are looking for here, showing us a *working* code? — Your Common Sense, Feb 17 '17 at 18:04
Same code is working on Wamp. Not on WebServer though. Checked db settings etc. — AIS, Feb 17 '17 at 18:05
@bassxzero Probably has the reason it works on localhost and not on server — RiggsFolly, Feb 17 '17 at 18:08
Your problem is lack of error reporting. Were you had errors reported to you, the problem would be apparent — Your Common Sense, Feb 17 '17 at 18:11
@AIS join my room https://chat.stackoverflow.com/rooms/135992/temp — bassxzero, Feb 17 '17 at 18:41
This error you are getting now is not from your original code but from your attempts to fix it. Make it original, same as it was on wamp — Your Common Sense, Feb 17 '17 at 20:06
@YourCommonSense added error_reporting(E_ALL); ini_set('display_errors',1); to all files infact..now im not getting any error. The login page does nothing on submit and only echo "Not enterin in userClass->Login"; is displayed — AIS, Feb 17 '17 at 20:17
Now I am getting the error object(PDO)#2 (0) { } with $db = getDB(); var_dump($db); — AIS, Feb 17 '17 at 21:03

score -1 · Answer 1 · answered Feb 17 '17 at 18:11

-1

Try creating your connection like this. Be sure to replace $json['MYSQL'][blah] with your connection info.

    $this->PDOMYSQL = new PDO(
        'mysql:host='. $json['MYSQL']['HOST'] .';dbname='.$json['MYSQL']['DATABASE'].';charset=utf8mb4',
        $json['MYSQL']['USER'],
        $json['MYSQL']['PASS'],
        [
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
            PDO::ATTR_EMULATE_PREPARES   => TRUE
        ]
    );

Edit

NVM I just noticed that :usernameEmail != usernameEmail.

Change

    $stmt->bindParam("usernameEmail", $usernameEmail,PDO::PARAM_STR) ;
    $stmt->bindParam("hash_password", $hash_password,PDO::PARAM_STR) ;

To

    $stmt->bindParam(":usernameEmail", $usernameEmail,PDO::PARAM_STR) ;
    $stmt->bindParam(":hash_password", $hash_password,PDO::PARAM_STR) ;

You are missing the :.

answered Feb 17 '17 at 18:11

bassxzero

4,838
22
34

Whats the problem in my connection? – AIS Feb 17 '17 at 18:16
Your answer helps absolutely nothing. Let me suggest you to refrain from answering pdo questions for a time being – Your Common Sense Feb 17 '17 at 18:17
@YourCommonSense so binding the correct parameter name means nothing? – bassxzero Feb 17 '17 at 18:20
@AIS the problem isn't with the connection. It's with the placeholder name, which is why I said see my EDIT. – bassxzero Feb 17 '17 at 18:21
Okay guys, let me try @bassxzero solution of adding : – AIS Feb 17 '17 at 18:22
His parameter is correct already. You need more experience with pdo. – Your Common Sense Feb 17 '17 at 18:24
@AIS add this line `$dbConnection->setAttribute(PDO::ATTR_EMULATE_PREPARES, TRUE);` – bassxzero Feb 17 '17 at 18:31
I have tried @YourCommonSense 's suggestion and link, this is the error now {"error":{"text":SQLSTATE[IM001]: Driver does not support this function: This driver doesn't support setting attributes}} – AIS Feb 17 '17 at 19:44

PDO - query working on wamp but on web server

1 Answers1