PHP: PDO not connect to database

Asked Apr 20 '16 at 06:14

Active Apr 23 '16 at 05:04

Viewed 62 times

I have a problem I think. My PHP PDO code didn't work at all. I've followed everything maybe in the manual but it seem doesn't work, it just returning a blank page and in my database there are no data at all. Below are my codes for php and I am using Xampp. What i've done wrong?

<?php

if(isset($_POST["submit"])){

    $hostname = 'localhost';
    $username = 'root';
    $password = '';

    try{
        $dbh = new PDO ("mysql:host=$hostname;dbname=test", $username, $password);
        $dbh->setAttribute(PDO::ATTR_ERRMODE, ERRMODE_EXCEPTION);

        $create_params_query = "INSERT INTO testingdb (name, email, message)
        VALUES ('".$_POST["name"]."', '".$_POST["email"]."', '".$_POST["message"]."')";

        if($dbh->query($sqlite)){
            echo "<script type= 'text/javascript'>alert('You're data has been sent. Thank you!');</script>";
        }else{
            echo "<script type= 'text/javascript'>alert('Sorry, you're data not being sent. Please try again.');</script>";
        }

    }catch (PDOException $e){
        echo $e->getMessage();
    }

}
$dbh = null;

?>

edited Apr 23 '16 at 05:04

asked Apr 20 '16 at 06:14

ShafiqqAziz

1

Have you got any error?? – Saty Apr 20 '16 at 06:16
1

what error it is showing? – Alive to die - Anant Apr 20 '16 at 06:16
1

Try replacing `$dbname=test` with `dbname=test` – Rainner Apr 20 '16 at 06:16
1

a *blank page* means something is broken. Add these lines `error_reporting(E_ALL); ini_set('display_errors', 1);` at the top of your PHP script and see if it yields any error or not. – Rajdeep Paul Apr 20 '16 at 06:17
Change `$dbh->query($sqlite)` to `$dbh->query($create_params_query)` – Saty Apr 20 '16 at 06:19
ShafiqqAziz please check the answer and if it worked then mark and up-vote the answer for others help. thanks. – Alive to die - Anant Apr 20 '16 at 08:15
People are not interested in checking answers and telling status along with marking and up-vote. Wastage of time and effort. deleting my answer. – Alive to die - Anant Apr 22 '16 at 07:42
Sorry guys for the late respond, kinda busy lately.. I'll try it today – ShafiqqAziz Apr 22 '16 at 08:29
Sorry guys,, none of them working,.. – ShafiqqAziz Apr 22 '16 at 08:57
@RajdeepPaul I've added that line of code,, there are no error at all.. – ShafiqqAziz Apr 22 '16 at 08:58
@Saty changed that line also not working – ShafiqqAziz Apr 22 '16 at 08:59
@Rainner still noting happened – ShafiqqAziz Apr 22 '16 at 08:59
Please show your error message !! – Saty Apr 22 '16 at 09:00
@Saty no error at all,, just a blank page – ShafiqqAziz Apr 22 '16 at 09:01
Use `ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL);` to check error. Write this at top of your page – Saty Apr 22 '16 at 09:02
@Saty why I put the error code but still not getting error? I am putting it on the top of the page – ShafiqqAziz Apr 22 '16 at 09:35

PHP: PDO not connect to database

0 Answers0