I am currently reading Professional PHP 5 and I have only used MySQL and was wondering if anyone could help me figure out the connection line. I did it the way I thought would work but its not working.

Here is my code:

<?php

class Widget
{

    private $id;
    private $name;
    private $description;
    private $db;
    private $needsUpdating = false;

    public function _construct($widgetID)
    {
        //The widgetID parameter is the primary key of a record in the database
        //containing the information for this object

        //Create a connection handle and store it in a private member variable
        $this->db = @mysql_connect('localhost', 'root', '');
        //$this->db = mysql_connect('localhost', stgres password=root ");

        if (! is_resource($this->db))
        {
            exit('<p>Unable to connect to the ' . 'database server at this time.</p>');
          }

        if (!@mysql_select_db('practicephpdb'))
        {
            exit('<p>Unable to locate the content ' . 'database at this time.</p>');
        }


        $sql = "SELECT \"name\", \"description\" FROM mysql_temp_1.widget WHERE widgetid = $widgetID";

        $rs = mysql_query($this->db, $sql);

        if (! mysql_num_rows($rs))
        {
            throw new Exception("An error occured selecting from the database.");
        }

        $data = mysql_fetch_array($rs);
        $this->id = widgetID;
        $this->name = $data['name'];
        $this->description = $data['description'];
    }

    public function getName()
    {
        return $this->name;
    }

    public function getDescription()
    {
        return $this->description;
    }

    public function setName($name)
    {
        $this->name = $name;
        $this->needsUpdating = true;
    }

    public function setDescription($description)
    {
        $this->description = $description;
        $this->needsUpdating = true;
    }

    public function _destruct()
    {
        if (! $this->needsUpdating)
        {
            return;
        }

        $sql = 'UPDATE "widget" SET ';
        $sql .= "\"name\" = '" . mysql_escape_string($this->name) . "',";
        $sql .= "\"description\" = '" . mysql_escape_string($this->description) . "'";
        $sql .= "WHERE widgetID = " . $this->id;

        $rs = mysql_query($this->db, $sql);
        if (! is_resource($rs))
        {
            throw new Exception('An error occured updating the database.');
        }

        //Your done with the database. Close the connection handle.
        mysql_close($this->db);
    }
}
?>




chad

howdy

if you provided some more examples of how it doesn't work. try removing username and password from mysql_connect(), just have the 'localhost' there....

another thing - don't use mysql_fetch_array() to fetch a single value, instead use mysql_result()

:D

www.campusgrind.com - college portal

Hi,

I have the dump file of the postgresql database. We are switching to another server and also the current database is in postgresql and we need to change to mysql and so I have two questions:
1. Does the postgres database dump file have CREATE statements? My file has only create table, create sequence, alter and data details.
2. I converted from postgresql dump file to mysql and now it has only create table details. Is that how it is suposed to be?
2. Can anyone please explain step by step how to migrate the database to a new server.

I am new with the database stuff an so I would really appreciate any help/

Thanks,
Charmie