my code stock.com

Update data if found in database else create new one

Snippet options

Download: Download snippet as create-else-update.php.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

$queryText = 'sounder';

if (!empty($queryText)) {
	$catalogSearchQuery = Mage::getModel('catalogsearch/query');

	$searchText = $catalogSearchQuery
		->getCollection()
		->addFieldToFilter(
			'query_text', 
			array(
				'eq' => $queryText
			)
		)
		->getFirstItem();

	if ($searchText->getId()) {
		$searchText
			->setPopularity($searchText->getPopularity() + 1)			
			->setUpdatedAt(now())
			->save();

	} else {
		$catalogSearchQuery
			->setData(
				array(
					'query_text'  => $queryText,
					'num_results' => 1,
					'popularity'  => 1,
				)
			)
			->save();
	}
}

Create a free my code stock.com account now.

my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.