Use PDO when scripting in PHP?

[Tryah85]

PDO that connects, but INSERT(ing) data does not work:

Code: Select all

<?php

include 'include/connect.php';

try {
    $dbh = new PDO("mysql:host=$hostname;dbname=animals", $username, $password);
    /*** echo a message saying we have connected ***/
    echo 'Connected to database<br />';

    /*** INSERT data ***/
    $count = $dbh->exec("INSERT INTO animals(animal_type, animal_name) VALUES ('kiwi', 'troy')");

    /*** echo the number of affected rows ***/
    echo $count;

    /*** close the database connection ***/
    $dbh = null;
    }
catch(PDOException $e)
    {
    echo $e->getMessage();
    }
?>

The includes file sucessfully connects to the database with the PDO code, but does not add specific data into the animals table. I get the Error:

SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'localhost' (111)

I have done some research and all I could find is that either the mysqld.sock file is in the wrong location (which it isn't) or a PDO field is disabled in php.ini (isn't either).

ugh. I could go on forever. If no one has a solution please feel free to explain what the mysld.sock file does, or why using PDOs is prefered. I assume PDOs help developers avoid making PHP queries/field that are vunerable towards SQL Injection??

[Tryah85]

I discovered a few things today. For starters the mysqld.sock file is meta data of how databases are read locally on the machine (that is not readable as sudo in gedit or pico btw). There is an option to use TCP/IP (in my.cnf LAMP/my.ini XAMP)... so the fact using TCP/IP allows a developer to have a test enviroment outside of the local machine and mimics the loading time of a live site.

In other words I don't understand why any web developer would work with sock files.

Good resource here:
http://dev.mysql.com/doc/refman/5.1/en/ ... erver.html

PDOs are new concepts introduced in PHP5. Data objects are just another type of variable data stored as a list. I am sticking to learn old school PHP. I can't jump ahead or I get fusterated and get lost.

[johnj]

This may help you -
http://phillipnb.wordpress.com/2011/05/ ... jects-pdo/