Stack Overflow
Stack Overflow

Questions tagged [joomla-dbo]

The database object for Joomla. It provides a sophisticated database abstraction layer to simplify the usage for third party developers.

The database object for Joomla. It provides a sophisticated database abstraction layer to simplify the usage for third party developers.

6 questions
9
votes
7 answers

Insert multiple rows using a single query

Can Joomla's DB object add multiple rows at once? MySQL can do this like so: INSERT INTO x (a,b) VALUES ('1', 'one'), ('2', 'two'), ('3', 'three') But can Joomla's own functions achieve the same thing in a single query? Currently I am doing a…
exentric
  • 177
  • 1
  • 4
  • 12
4
votes
2 answers

Find if string is MySQL function in PHP

I have a function that takes an array and creates a SQL statement based on they key/value pairs of the array. For example: name=>SomeKittens It'd turn into (`name`) VALUES ('SomeKittens') The only problem is when I use a MySQL string function…
SomeKittens
  • 38,868
  • 19
  • 114
  • 143
2
votes
1 answer

how I delete a row in a table in Joomla?

I have a table id h_id t_id 1 3 1 2 3 2 3 3 3 4 4 2 5 4 3 id is the primary key. I have not created a JTable for this table. Now I want to delete rows by h_id. Are there any method like which I can use without writing a…
Sara
  • 14,098
  • 13
  • 34
  • 50
1
vote
2 answers

How to use JFactory::getDBO() in public?

I have created new php file in component. I want to get connection to Joomla database but connection unknown. Error message is the following: Fatal error: Class 'JFactory' not found in…
user777692
  • 21
  • 3
  • 6
1
vote
1 answer

realation among jos_category, jos_menu and jos_content in joomla

I have moved a joomla site to wordpress with fg joomla to wordpress (wordpress plugin) free version. Now i want to get the list of all of the content(articles) with their id, link, path and alias. I am new with joomla so i also want to know the…
vipul jain
  • 46
  • 5
0
votes
1 answer

difference b/w &JFactory::getDBO() and JFactory::getDBO()

What is the difference between &JFactory::getDBO() and JFactory::getDBO() in Joomla 1.5?
Maha.8622
  • 35
  • 1
  • 7