Re: Help on objects

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2006/10/4, Deckard <ml@xxxxxxxxxxx>:

Hi,

I'm trying to lay my hands on PHP OOP, but it's not easy :(
I've read several examples in the web, but cannot transpose to may case.

I'm trying to set a class to make SQL inserts in mysql.

I have the class:
---------------------------------------------------------
<?php

  class dBInsert
{
  // global variables
  var $first;

// constructor
function dBInsert($table, $sql)
{
  $this->table = $table;
  $this->sql   = $sql;

  return(TRUE);
}


  // function that constructs the sql and inserts it into the database
  function InsertDB($sql)
   {

    print($sql);
    // connect to MySQL
    $conn->debug=1;
    $conn = &ADONewConnection('mysql');
    $conn->PConnect('localhost', 'deckard', 'ble', 'wordlife');

        if ($conn->Execute($sql) === false)
        print 'error inserting: '.$conn->ErrorMsg().'<BR>';

        return (TRUE);
   }
}
--------------------------------------------------------------------

and the code that calls it:
--------------------------------------------------------------------
<?php

include_once("classes/dBInsert.php");
$sql = "INSERT INTO wl_admins VALUES ('',2)";
$dBInsert = new dBInsert('wl_admins', '$sql');
$dBInsert->InsertDB('$sql');

?>
--------------------------------------------------------------------

but it's not working ?

Can anyone give me a hand here ?

I've read the manuals, examples, etc.

Any help would be appreciated.

Best Regards,
Deckard

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


For database interaction, give PDO a chance: http://php.net/pdo
IMO it's cleaner and more efficient than adodb.

Then, I believe what you're trying to make is a query builder. I would break
down the differente parts of an sql query and create abstractions for each
part (some can be reused on different types of queries), then have builder
create the queries abstractions from the different parts.

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux