Inserting into the Joomla Database...

jntwebdesigns · **Joined:** Mon Nov 02, 2009 4:22 pm **Posts:** 18

I have some code that is supposed to insert into the joomla db:

Code:

SearchAdvancedHelper::saveSearch( 'test', '1');

Which calls the function:

Code:

function saveSearch( $search_string, $userID )
{
   $db =& JFactory::getDBO();

   $params = &JComponentHelper::getParams( 'com_searchadvanced' );
   $enable_saved_searches = $params->get('enable_save');

   //$search_term = $db->getEscaped( trim( $search_term) );

   if ( @$enable_saved_searches )
   {
      $db =& JFactory::getDBO();
      $query = 'INSERT INTO #__searchadvanced_saved_searches (user_id, search_string) VALUES ( "' . $userID .'", "'.$search_string.'" )';
      $db->setQuery( $query );
      $db->query();
      echo "DB: $query "; print_r($db->query); echo "<BR>";
   }
}

Which is being called because I get the echoed statement above, but nothing is entered into the DB.

ooffick · **Posted:** Wed Nov 04, 2009 5:55 pm

Why don't you use the insertObject method:
http://api.joomla.org/Joomla-Framework/ ... sertObject

Olaf

jntwebdesigns · **Joined:** Mon Nov 02, 2009 4:22 pm **Posts:** 18

I have this now...

Code:

$__data =new stdClass();
$__data->saved_search_id = null;
$__data->user_id = $userID;
$__data->search_string = $search_string;
$db = JFactory::getDBO();
$db->insertObject('#__searchadvanced_saved_searches', $__data, 'saved_search_id') ;
echo "DB: $query "; print_r($db->query); echo "<BR>";

But is still not inserting the information... is there a way to do an inline error check?

jntwebdesigns · **Joined:** Mon Nov 02, 2009 4:22 pm **Posts:** 18

I added this code:

Code:

echo "ERROR: " . $db->getErrorNum() . "<BR>";

which returns an 1146 error. Researching this it means the table name is wrong, or prefixs in general. Adding the actual table name copied from the actual tablename in the insertObject function did not help.

Code:

$db->insertObject('jos_searchadvanced_saved_searches', $__data, 'saved_search_id') ;

And the prefix appears to be coorect in the config file..

var $dbprefix = 'jos_';

becyn · **Joined:** Mon Aug 11, 2008 1:16 am **Posts:** 312

jntwebdesigns wrote:

I added this code:

Code:

echo "ERROR: " . $db->getErrorNum() . "<BR>";

which returns an 1146 error. Researching this it means the table name is wrong, or prefixs in general. Adding the actual table name copied from the actual tablename in the insertObject function did not help.

Code:

$db->insertObject('jos_searchadvanced_saved_searches', $__data, 'saved_search_id') ;

And the prefix appears to be coorect in the config file..

var $dbprefix = 'jos_';

Two things:
You have 2 underscores instead of one on the private variables. I don't know if that may be causing some glitch or not.

Re check the the number of arguments and type that the method requires. You will get odd results if all of this is not done properly. For instance, if the method will take 4 arguments and you use one of the optional ones, you need to put defaults or other optional data in the remaining arguments so they read in correctly.
Been there...

ooffick · **Posted:** Wed Nov 04, 2009 7:06 pm

Did you try to use this instead:

Code:

$db =& JFactory::getDBO();

Olaf

jntwebdesigns · **Joined:** Mon Nov 02, 2009 4:22 pm **Posts:** 18

Changed to :

Code:

$__data =new stdClass();
$__data->saved_search_id = null;
$__data->user_id = $userID;
$__data->search_string = $search_string;
$db =& JFactory::getDBO();
$db->insertObject('#__searchadvanced_saved_searches', $__data, 'saved_search_id') ;
echo "DB: $query "; print_r($db->query); echo "<BR>";

Same result....

ooffick · **Posted:** Wed Nov 04, 2009 8:11 pm

What is your database structure?

Olaf

jntwebdesigns · **Joined:** Mon Nov 02, 2009 4:22 pm **Posts:** 18

What do you mean?
Do you mean the settings in the config, the DB type, or something else????

becyn · **Joined:** Mon Aug 11, 2008 1:16 am **Posts:** 312

jntwebdesigns wrote:

What do you mean?
Do you mean the settings in the config, the DB type, or something else????

He means that the database structure, columms, length, type, etc need to match the $__data object EXACTLY.

jntwebdesigns · **Joined:** Mon Nov 02, 2009 4:22 pm **Posts:** 18

`jos_searchadvanced_saved_searches` (
`saved_search_id` int(15) NOT NULL AUTO_INCREMENT,
`user_id` int(15) NOT NULL,
`search_string` varchar(255) NOT NULL,
PRIMARY KEY (`saved_search_id`)

ooffick · **Posted:** Wed Nov 04, 2009 10:50 pm

did you try this:

Code:

$db->insertObject('#__searchadvanced_saved_searches', $__data);

Olaf

jntwebdesigns · **Joined:** Mon Nov 02, 2009 4:22 pm **Posts:** 18

same result.

ooffick · **Posted:** Thu Nov 05, 2009 9:54 am

and you are sure the jos_searchadvanced_saved_searches table exists in the joomla database?

Olaf

jntwebdesigns · **Joined:** Mon Nov 02, 2009 4:22 pm **Posts:** 18

okay, I feel really stupid. It turns out I had 2 joomla databases. Since I use this as a development site, there were tons of databases. I searched and there were 2 copies of Joomla running.

It works fine now.

Joomla! Discussion Forums

Inserting into the Joomla Database...

Quick reply

Who is online