Sandbox

Pentacle wrote:

Code: Select all

$rows = $database->loadObjectList();

instead of mysql_fetch_assoc() use this above line and then do a var_dump for $rows variable to see what it has.

   $query = "SHOW TABLE STATUS LIKE 'jos_content'";
   $newid = $database->setQuery($query);
   $rows = $database->loadObjectList();
   echo var_dump($rows); 

array(1) {
  [0]=>
  object(stdClass)(18) {
    ["Name"]=>
    string(11) "jos_content"
    ["Engine"]=>
    string(6) "MyISAM"
    ["Version"]=>
    string(1) "9"
    ["Row_format"]=>
    string(7) "Dynamic"
    ["Rows"]=>
    string(2) "22"
    ["Avg_row_length"]=>
    string(4) "1042"
    ["Data_length"]=>
    string(5) "48532"
    ["Max_data_length"]=>
    string(10) "4294967295"
    ["Index_length"]=>
    string(4) "8192"
    ["Data_free"]=>
    string(5) "25592"
    ["Auto_increment"]=>
    string(2) "65"
    ["Create_time"]=>
    string(19) "2007-12-13 20:04:17"
    ["Update_time"]=>
    string(19) "2007-12-13 23:29:06"
    ["Check_time"]=>
    NULL
    ["Collation"]=>
    string(17) "latin1_swedish_ci"
    ["Checksum"]=>
    NULL
    ["Create_options"]=>
    string(0) ""
    ["Comment"]=>
    string(0) ""
  }
}

CirTap wrote:Hi,
in 1.0.x it's called loadAssocList()

As the name loadObjectList() may imply, it returns a list of objects, however in this case the list ( = array) contains a single entry (object(stdClass)) only:
  $rows[0]->Auto_increment
You should be able to use "#__content" with setQuery(). No idea why it does not work in your case.

   $query = "SHOW TABLE STATUS LIKE 'jos_content'";
   $newid = $database->setQuery($query);
   $rows = $database->loadAssocList($newid);
   foreach($rows as $row) {         
      $newid = $row['Auto_increment'];
   }

CirTap wrote:just saw loadRow(), loadResultArray() and many others. Use the one that suits your need -- I suppose loadRow() is more appropriate for this particular statement.

ddmobley wrote:Why it won't work with #__content is beyond me, but it won't.  Some weird stuff here.

   $query = "SHOW TABLE STATUS LIKE '%_content'";

   $query = "SHOW TABLE STATUS LIKE '" . $mosConfig_dbprefix . "content'";

   $query = "SHOW TABLE STATUS LIKE '" . $mosConfig_dbprefix . "content'";
   $database->setQuery($query);
   $rows = $database->loadAssocList();
   foreach($rows as $row) {         
      $newid = $row['Auto_increment'];
   }

$object = new stdClass; // simple value object
$object->field1 = "foo"; // each property represents a table column
$object->field2 = "bar";
// creates INSERT INTO jos_mytable (field1,field2) VALUES ("foo","bar")
$database->insertObject("#__mytable", $object, "id");
echo $object->id;

CirTap wrote:so all you need is the incremented record id?
Try $database->insertid() right after you run the INSERT query, and you should receive the last auto_increment of that table.
You also get the last insert id using the 3rd argument of:
  $database->insertObject( $table, &$object, $keyName)

CirTap wrote:The reason why %_content works is that "%" is a wildcard character for LIKE, the equivalent of "*"

bao_jiffy wrote:Not sure that I followed all of the steps in this thread but I have to ask 3 questions.  One for my benefit and another 2 hopefully for your benefit.

Would a query of select max(id) from `#__my_table` not get you the last inserted auto_increment value prior to your insert?  You may have this all ready covered but I thought that I would ask any how.

bao_jiffy wrote:Also, I found that I had to through the ` quote marks around my table names to make them inherit the database prefix using the #_.  Not sure if that helps your cause any but thought that I would put in my 2 cents there.

bao_jiffy wrote:Now to MY question.  Is there a simple example somewhere of reading a list of data into a simple form, edit a record or multiple records, then update the data without having to go through several php files?  I am guessing that I just need to recall the same php when I complete my edits but I just can't seem to figure it out.  I can create a basic form but if multiple records are returning, what is the proper way of editing a record and storing the results?

Thanks for any pointers, even if it is to a manual or sample component.

If (the page has no form values being submitted) {
   Display the form code;
} else {
   Save the form values being submitted;
}