CODEWITHSUNDEEP
joomlajoomla1.5joomla1.7
Sara
Sara

Reputation: 14628

How to write query using JDatabaseQuery in Joomla 1.7?

I have a following table and I want to know how to write the inset query using JDatabaseQuery in Joomla.

jos_esolutions_movies - table name
id, name, description, status - field names
1 , 'ABC' , 'ABC description', 0 - example values

Upvotes: 2

Views: 3569

Answers (3)

Gaurav
Gaurav

Reputation: 28755

$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->insert('#__tablename');
$query->set("field1='values1', field2='values2'");
$db->setQuery($query);
$db->query();

Upvotes: 5

user1119130
user1119130

Reputation: 

$db =& JFactory::getDBO();
$query = "insert into #__esolutions_movies (id, name, description, status) values(1 , 'ABC' , 'ABC description', 0)";
$db->setQuery($query);
$db->query();

Upvotes: 0

jogesh_pi
jogesh_pi

Reputation: 9782

the following link will help you to create a joomla database query http://docs.joomla.org/How_to_use_the_database_classes_in_your_script

Upvotes: 0

Related Questions