www.webdeveloper.com
Results 1 to 2 of 2

Thread: Changing Mysqli to PDO connect

  1. #1
    Join Date
    Apr 2013
    Posts
    23

    Changing Mysqli to PDO connect

    I have been reading and have been told that prepared statements are one way to prevent SQL injections.

    My mysqli conect works, but my new PDO statement doesn't connect

    $username = "root";
    $password = "1212";
    try {
    $conn = new PDO('mysql:host=localhost;dbname=test', $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    } catch(PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
    }

    Can you tell me why this doesn't work?

    Thanks in advance friends

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,408
    Before you go too far, please be aware that the MySQLi extension supports prepared statements with bound parameters, too.

    Anyway, it would help to know exactly what error message you are getting.
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles