DB_dataobject problems.
| From: | Daniel Testa | Date: | Tue, 12 Jul 2005 00:00:24 +0000 |
| Subject: | DB_dataobject problems. | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-19942@lists.php.net to get a copy of this message | ||
I got all my classes out generated and configure but for some strange
reason fetches and finds are not working correctly. I can use an object
to insert a record but not find or delete the newly created record. I'm
am very green to php and DB_dataobjects, heres output from the script in
question with debug set to 3.
/* Script Start */
<?php
require_once('/home/crazyl2/include/set_env.php');
// put full path to Smarty.class.php
//require('smarty/Smarty.class.php');
$t->assign('title', "Welcome To Crazy Like A Moose");
$t->assign('name', "Vistor");
$t->display('index.tpl');
DB_DataObject::debugLevel(3);
$person = DB_DataObject::factory('chr_characters');
if ($person->get(1)) {
// print_r($person);
echo "<br> Character name is " . $person->chr_name . "<BR>";
} else {
echo "NO person 1 exists";
}
$person = DB_DataObject::factory('chr_characters');
$person->chr_name = 'Frag New';
$person->find();
print_r($person);
$person = DB_DataObject::factory('usr_users');
if ($person->get(1)) {
print_r($person);
} else {
echo "NO person 1 exists";
}
//$character = DB_DataObject::Factory('Chr_characters');
//$character3 = DB_DataObject::Factory('DataObjects_Chr_characters');
//$character->chr_id =1 ;//chr_id ;
$character = DB_DataObject::Factory('chr_characters');
$db= &$character->getDatabaseConnection();
echo "Php type " . $db->phptype . "<br>";
$character->get("chr_id","1");
//print_r($character);
$images = DB_DataObject::factory('chr_images');
print_r($images);
$person = new DataObjects_chr_characters;
$number_of_rows = $person->find();
echo "<br>Number of row: " . $number_of_rows . "<br>";
$people = array();
echo "Starting loop <br>";
while ($person->fetch())
{ /* store the results in an array */
echo "Going through all my records";
echo "GOT {$person->chr_name}<BR>";
}
echo "ending loop <br> ";
$person3 = DB_DataObject::Factory('chr_characters');
$person3->chr_name='Miky';
$person3->chr_page='www.deleteme.com';
$id = $person3->insert();
$person3 = DB_DataObject::Factory('chr_characters');
$person3->whereAdd("chr_name = '%Miky%' ");
$person3->delete(DB_DATAOBJECT_WHEREADD_ONLY);
echo "delete called <br>";
// Instantiate the DataObject_Articles class
$characters= DB_DataObject::Factory('chr_characters');
// Assign a value to use to search the 'Author' column
//$characters->chr_id = 1;
// Perform the query
//
echo 'Dose super dan Exist:<br />';
$characters->find();
// Loop through the articles
while ($characters->fetch()) {
echo ' - ' . $characters->chr_name . ', published: ' .
$characters->chr_page; //date('jS M Y', $articles->published) . '<br
/>';
}
?>
/* Script End */
/* Screen output Start */
Welcome To Crazy Like a Moose
Hello, Vistor!
Footer
dataobjects_chr_characters: CONNECT: NEW CONNECTION
dataobjects_chr_characters: CONNECT:
mysql://crazyl2_crazycon:a53xc56g@localhost/crazyl2_cmsite
1d715709138226b00653f53a686c29ea
dataobjects_chr_characters: databaseStructure: Loaded ini file:
/home/crazyl2/include/DataObjects/schema/crazyl2_cmsite.ini
dataobjects_chr_characters: databaseStructure: Missing links.ini file:
/home/crazyl2/include/DataObjects/schema/crazyl2_cmsite.links.ini
dataobjects_chr_characters: GET: chr_id 1 Array ( [0] => chr_id )
dataobjects_chr_characters: __find: 1
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: QUERY: SELECT * FROM chr_characters WHERE
chr_characters.chr_id = 1
dataobjects_chr_characters: query: QUERY DONE IN 0.13059210777283
seconds
dataobjects_chr_characters: __find: CHECK autofetchd 1
dataobjects_chr_characters: __find: ABOUT TO AUTOFETCH
dataobjects_chr_characters: FETCH:
a:3:{s:6:"chr_id";s:1:"1";s:8:"chr_name";s:11:"Dan The
Man";s:8:"chr_page";s:37:"www.crazylikeamoose.com/dantheman.com";}
dataobjects_chr_characters: fetchrow LINE: chr_id = 1
dataobjects_chr_characters: fetchrow LINE: chr_name = Dan The Man
dataobjects_chr_characters: fetchrow LINE: chr_page =
www.crazylikeamoose.com/dantheman.com
dataobjects_chr_characters: fetchrow: chr_characters DONE
dataobjects_chr_characters: __find: DONE
Character name is
dataobjects_chr_characters: __find:
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: QUERY: SELECT * FROM chr_characters WHERE
chr_characters.chr_name = 'Frag New'
dataobjects_chr_characters: query: QUERY DONE IN 0.0011179447174072
seconds
dataobjects_chr_characters: __find: CHECK autofetchd
dataobjects_chr_characters: __find: DONE
dataobjects_chr_characters Object ( [_DB_DataObject_version] =>
@version@ [__table] => chr_characters [N] => 0 [_database_dsn] =>
[_database_dsn_md5] => [_database] => [_query] => Array ( [condition] =>
[group_by] => [order_by] => [having] => [limit_start] => [limit_count]
=> [data_select] => * ) [_DB_resultid] => [_link_loaded] => [_join] =>
[_lastError] => [chr_id] => [chr_name] => Frag New [chr_page] => )
dataobjects_usr_users: CONNECT: USING CACHED CONNECTION
dataobjects_usr_users: GET: user_id 1 Array ( [0] => user_id )
dataobjects_usr_users: __find: 1
dataobjects_usr_users: CONNECT: USING CACHED CONNECTION
dataobjects_usr_users: CONNECT: USING CACHED CONNECTION
dataobjects_usr_users: CONNECT: USING CACHED CONNECTION
dataobjects_usr_users: QUERY: SELECT * FROM usr_users WHERE
usr_users.user_id = 1
dataobjects_usr_users: query: QUERY DONE IN 0.15879821777344 seconds
dataobjects_usr_users: __find: CHECK autofetchd 1
dataobjects_usr_users: __find: DONE
NO person 1 existsdataobjects_chr_characters: CONNECT: USING CACHED
CONNECTION
Php type mysql
dataobjects_chr_characters: GET: chr_id 1 Array ( )
dataobjects_chr_characters: __find: 1
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: QUERY: SELECT * FROM chr_characters WHERE
chr_characters.chr_id = 1
dataobjects_chr_characters: query: QUERY DONE IN 0.00032711029052734
seconds
dataobjects_chr_characters: __find: CHECK autofetchd 1
dataobjects_chr_characters: __find: ABOUT TO AUTOFETCH
dataobjects_chr_characters: FETCH:
a:3:{s:6:"chr_id";s:1:"1";s:8:"chr_name";s:11:"Dan The
Man";s:8:"chr_page";s:37:"www.crazylikeamoose.com/dantheman.com";}
dataobjects_chr_characters: fetchrow LINE: chr_id = 1
dataobjects_chr_characters: fetchrow LINE: chr_name = Dan The Man
dataobjects_chr_characters: fetchrow LINE: chr_page =
www.crazylikeamoose.com/dantheman.com
dataobjects_chr_characters: fetchrow: chr_characters DONE
dataobjects_chr_characters: __find: DONE
dataobjects_chr_images Object ( [_DB_DataObject_version] => @version@
[__table] => chr_images [N] => 0 [_database_dsn] => [_database_dsn_md5]
=> [_database] => [_query] => Array ( [condition] => [group_by] =>
[order_by] => [having] => [limit_start] => [limit_count] =>
[data_select] => * ) [_DB_resultid] => [_link_loaded] => [_join] =>
[_lastError] => [chr_id] => [image_id] => [image_type] => [rec_id] => )
dataobjects_chr_characters: __find:
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: QUERY: SELECT * FROM chr_characters
dataobjects_chr_characters: query: QUERY DONE IN 0.00075793266296387
seconds
dataobjects_chr_characters: __find: CHECK autofetchd
dataobjects_chr_characters: __find: DONE
Number of row: 57
Starting loop
dataobjects_chr_characters: FETCH: No data returned from FIND (eg. N is
0)
ending loop
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: QUERY: INSERT INTO chr_characters (chr_name
, chr_page ) VALUES ('Miky' , 'www.deleteme.com' )
dataobjects_chr_characters: query: QUERY DONE IN 0.00085997581481934
seconds
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: ERROR: delete: No condition specifed for
query
delete called
Dose super dan Exist:
dataobjects_chr_characters: __find:
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: CONNECT: USING CACHED CONNECTION
dataobjects_chr_characters: QUERY: SELECT * FROM chr_characters
dataobjects_chr_characters: query: QUERY DONE IN 0.0009009838104248
seconds
dataobjects_chr_characters: __find: CHECK autofetchd
dataobjects_chr_characters: __find: DONE
dataobjects_chr_characters: FETCH: No data returned from FIND (eg. N is
0)
/* Screen output End */
Please any help would be greatly appreciated oh mighty code gods!