Tag: jdatabase

30 Method for creating a subquery using JDatabase 2014-04-22T17:35:44.280

20 How to combine ANDs and ORs in the WHERE clause using a Query Object? 2014-12-09T18:34:23.660

11 Can multiple records be inserted all at once with the jDatabase? 2014-12-12T14:27:01.723

8 How to use LIMIT in getQuery 2014-12-11T15:32:39.570

7 Is there a way to detect the database changes that were made by third party extensions? 2014-04-23T19:06:12.310

7 Combining 'ANDs' and 'ORs' in a complex WHERE query - Part 2 2016-03-18T00:37:51.347

5 JDatabaseDriver->replacePrefix( ) Allowed memory size of ... bytes exhausted 2014-07-05T19:53:13.617

5 SQL Injections using Jfactory::getDBO and setQuery() 2018-04-18T18:25:35.960

4 Selecting data from multiple JDatabase tables? 2014-06-15T14:05:20.387

4 How to write an Insert Select Statement? 2014-07-02T05:38:31.187

4 Join an existing table with a generated table of dates and count rows for each date? 2015-04-07T12:52:49.337

4 How can I get the names of the columns in an object or table with Joomla's SQL? 2015-07-12T21:31:43.133

4 Jdatabase : Working with comma separated values? 2016-08-18T09:39:34.603

4 Jdatabase : Counting number of elements in a comma separated field 2016-08-21T13:27:48.083

3 Printing query result set as a html table 2014-05-31T15:49:46.223

3 View Users Front End - php code 2014-06-26T09:27:28.807

3 How to write my MySQL query with JOIN logic using JDatabase methods? 2015-05-14T17:59:33.957

3 JDatabase JOIN on multiple values 2015-06-15T11:03:37.423

3 Using JDatabaseQuery::union() causes errors 2016-08-05T19:08:29.797

3 Jdatabase : Sorting two selections? 2016-08-19T10:40:10.423

3 JDatabase, SQL statement template 2017-02-06T00:20:25.713

3 Joomla plugin to override table prefix 2017-10-26T14:26:32.493

3 with insert on duplicate key update - updating multiple rows at once 2018-09-16T12:57:51.017

3 How to write a query with GROUP BY and ORDER BY using Joomla's query methods? 2018-11-06T00:50:14.293

2 Getting data from mutiple JDatabase Tables based on results from first 2014-12-11T09:32:11.047

2 How to combine several sets of 'ANDs' and 'ORs' in a complex WHERE query object? 2015-04-20T06:25:57.230

2 Ordering a UNION 2015-04-20T21:23:41.323

2 Get ID of deleted database-entry 2015-07-10T10:36:03.243

2 JDatabaseQuery quote correctly the items into select 2015-07-29T14:45:05.870

2 How to check whether a specific row exists in a JDatabase table? 2016-04-27T05:47:42.923

2 Jdatabase: Finding part of the string which doesn't match $X string 2016-08-22T15:08:14.643

2 Global PHP functions? 2017-02-09T07:46:50.207

2 Cannot get num rows with the database driver 2017-03-09T05:46:32.263

2 Multiple Count from same table 2017-06-13T15:25:07.567

2 Using JDatabase standalone, ie. without Joomla application bootstrapping 2017-12-19T01:08:26.303

2 Confusion about using two select() method calls in one query 2018-09-26T17:07:57.180

1 How can I select IDs of a category and all its (n levels) subcategories? 2014-05-31T11:24:14.383

1 Select returning only one row with one column 2014-05-31T15:36:47.670

1 I can load data from Joomla database and external database? 2014-10-14T10:54:20.783

1 How to select a blank(dummy) column in a JDatabse UNION query 2015-04-20T20:40:47.747

1 Very slow query using JDatabase vs Manual 2015-06-18T04:14:21.603

1 How to get the generated id after a successful INSERT query? 2015-07-09T12:40:16.990

1 Delete items of database via CLI 2015-07-20T13:40:10.127

1 Transforming a Query for JDATABASE 2015-07-28T09:11:57.413

1 Need some suggestion regarding strategy of scraping article view times from another webpage to use in K2 item 2016-04-26T21:56:58.603

1 JDatabase Like Operator 2016-08-09T05:27:34.563

1 PHP function with JDatabase queries 2016-09-08T07:16:42.257

1 No syntax errors & Query works without one parameter 2016-10-11T19:02:39.187

1 Example form on posting data through JInput class 2016-10-14T18:33:36.143

1 Joomla query for monthly result in a graph 2017-02-27T14:09:58.437

1 Regex in Database query - How can non alphabetic characters be selected? 2017-06-27T08:27:02.023

1 Insert query with ignore of duplicates (without key) 2017-07-13T11:42:31.557

1 Join two similar table SQL 2017-12-15T01:34:40.257

1 What's the proper chaining for WHERE 2018-01-29T18:07:34.007

1 Error when populating a database table while installing a module 2018-02-28T19:43:18.137

1 Query gives a single value when two columns in SELECT clause 2018-04-30T09:12:40.697

1 How to re-write sql for joomla JDatabase 2018-05-15T13:59:12.500

1 Why does the truncateTable() method create an empty string for a query and fail to delete rows? 2018-07-19T12:44:37.830

0 How to use Oracle database for populating a list in a form 2015-01-30T07:04:45.390

0 Select code not working in article Joomla 3 2015-03-18T06:04:44.683

0 Joomla JFactory::getDBO() - Prefix is wrong? 2015-09-17T09:41:09.683

0 JDatabase subQuery not work 2015-09-24T07:59:23.290

0 Get HWD media share video thumbnail url from Joomla database 2016-03-05T16:58:36.993

0 Accessing Jdatabase via JavaScript Or Passing PHP varibles to JavaScript 2016-08-23T09:15:19.240

0 Custom Admin Dashboard: Manual Menu Assignment to Modules 2016-11-04T17:56:54.670

0 Select newly inserted record in JDatabase 2017-01-23T07:16:38.033

0 Cannot query Joomla database as a guest user 2017-02-16T14:04:25.240

0 JDatabase Update +1 2017-06-08T10:23:24.153

0 How to SET a user-defined MySQL variable and increment it to produce ranking values with JDatabaseQuery? 2018-02-04T13:46:42.163

0 Downloading large data sets 2018-02-19T12:09:03.890

-2 Allowing Registered Users To Edit Only Specific JDatabase records? 2014-06-10T19:54:14.740