Joomla Sharing

Convert Joomla 1.5 Module into Joomla 1.7

2012-01-10T19:57:00.005+05:30

Joomla 1.5 AJAX Syntax

var a =new Ajax( url, {

method: 'get',onComplete: function(){

alert("AJAX is Working in Joomla 1.5")},

update: element

}).request();

Joomla 1.6/1.7 AJAX Syntax

var a = newRequest.HTML({

url:url,

method: 'get',onComplete: function(){

alert("AJAX is Working in Joomla 1.7")},

update: element

}).send();

Joomla 1.5 above AJAX syntax is not working in Joomla 1.7 because in Joomla 1.7 AJAX is not defined in mootools. so this perticular Joomla 1.6/1.7 AJAX syntax is properly working in Joomla 1.7 and in Joomla 1.6 also.

Convert BBCode to HTML in PHP

2012-01-10T19:39:00.000+05:30

function bb2html($message)
        {
            $preg = array(
                '/(?<!\\\\)\[COLOR(?::\w+)?=(.*?)\](.*?)\[\/COLOR(?::\w+)?\]/si'   => "<span style=\"color:\\1\">\\2</span>",
                '/(?<!\\\\)\[SIZE(?::\w+)?=(.*?)\](.*?)\[\/SIZE(?::\w+)?\]/si'     => "<span style=\"font-size:\\1\">\\2</span>",
                '/(?<!\\\\)\[FONT(?::\w+)?=(.*?)\](.*?)\[\/FONT(?::\w+)?\]/si'     => "<span style=\"font-family:\\1\">\\2</span>",
                '/(?<!\\\\)\[ALIGN(?::\w+)?=(.*?)\](.*?)\[\/ALIGN(?::\w+)?\]/si'   => "<div style=\"text-align:\\1\">\\2</div>",
                '/(?<!\\\\)\[B(?::\w+)?\](.*?)\[\/B(?::\w+)?\]/si'                 => "<span style=\"font-weight:bold\">\\1</span>",
                '/(?<!\\\\)\[I(?::\w+)?\](.*?)\[\/I(?::\w+)?\]/si'                 => "<span style=\"font-style:italic\">\\1</span>",
                '/(?<!\\\\)\[U(?::\w+)?\](.*?)\[\/U(?::\w+)?\]/si'                 => "<span style=\"text-decoration:underline\">\\1</span>",
                '/(?<!\\\\)\[CENTER(?::\w+)?\](.*?)\[\/CENTER(?::\w+)?\]/si'       => "<div style=\"text-align:center\">\\1</div>",

                // [email]
                '/(?<!\\\\)\[EMAIL(?::\w+)?\](.*?)\[\/EMAIL(?::\w+)?\]/si'         => "<a href=\"mailto:\\1\" class=\"bb-email\">\\1</a>",
                '/(?<!\\\\)\[EMAIL(?::\w+)?=(.*?)\](.*?)\[\/EMAIL(?::\w+)?\]/si'   => "<a href=\"mailto:\\1\" class=\"bb-email\">\\2</a>",
                // [url]
                '/(?<!\\\\)\[URL(?::\w+)?\]www\.(.*?)\[\/URL(?::\w+)?\]/si'        => "<a href=\"http://www.\\1\" target=\"_blank\" class=\"bb-url\">\\1</a>",
                '/(?<!\\\\)\[URL(?::\w+)?\](.*?)\[\/URL(?::\w+)?\]/si'             => "<a href=\"\\1\" target=\"_blank\" class=\"bb-url\">\\1</a>",
                '/(?<!\\\\)\[URL(?::\w+)?=(.*?)?\](.*?)\[\/URL(?::\w+)?\]/si'      => "<a href=\"\\1\" target=\"_blank\" class=\"bb-url\">\\2</a>",
                // [img]
                '/(?<!\\\\)\[IMG(?::\w+)?\](.*?)\[\/IMG(?::\w+)?\]/si'             => "<img src=\"\\1\" alt=\"\\1\" class=\"bb-image\" />",
                '/(?<!\\\\)\[IMG(?::\w+)?=(.*?)x(.*?)\](.*?)\[\/IMG(?::\w+)?\]/si' => "<img width=\"\\1\" height=\"\\2\" src=\"\\3\" alt=\"\\3\" class=\"bb-image\" />",

                // [list]
                '/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[\*(?::\w+)?\](.*?)(?=(?:\s*<br\s*\/?>\s*)?\[\*|(?:\s*<br\s*\/?>\s*)?\[\/?LIST)/si' => "\n<li class=\"bb-listitem\">\\1</li>",
                '/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[\/LIST(:(?!u|o)\w+)?\](?:<br\s*\/?>)?/si'    => "\n</ul>",
                '/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[\/LIST:u(:\w+)?\](?:<br\s*\/?>)?/si'         => "\n</ul>",
                '/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[\/LIST:o(:\w+)?\](?:<br\s*\/?>)?/si'         => "\n</ol>",
                '/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[LIST(:(?!u|o)\w+)?\]\s*(?:<br\s*\/?>)?/si'   => "\n<ul class=\"bb-list-unordered\">",
                '/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[LIST:u(:\w+)?\]\s*(?:<br\s*\/?>)?/si'        => "\n<ul class=\"bb-list-unordered\">",
                '/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[LIST:o(:\w+)?\]\s*(?:<br\s*\/?>)?/si'        => "\n<ol class=\"bb-list-ordered\">",
                '/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[LIST(?::o)?(:\w+)?=1\]\s*(?:<br\s*\/?>)?/si' => "\n<ol class=\"bb-list-ordered,bb-list-ordered-d\">",
                '/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[LIST(?::o)?(:\w+)?=i\]\s*(?:<br\s*\/?>)?/s' => "\n<ol class=\"bb-list-ordered,bb-list-ordered-lr\">",
                '/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[LIST(?::o)?(:\w+)?=I\]\s*(?:<br\s*\/?>)?/s' => "\n<ol class=\"bb-list-ordered,bb-list-ordered-ur\">",
                '/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[LIST(?::o)?(:\w+)?=a\]\s*(?:<br\s*\/?>)?/s' => "\n<ol class=\"bb-list-ordered,bb-list-ordered-la\">",
                '/(?<!\\\\)(?:\s*<br\s*\/?>\s*)?\[LIST(?::o)?(:\w+)?=A\]\s*(?:<br\s*\/?>)?/s' => "\n<ol class=\"bb-list-ordered,bb-list-ordered-ua\">",

                //line breaks
                '/\n/'                                                               => "<br>",
                // escaped tags like \[b], \[color], \[url], ...
                '/\\\\(\[\/?\w+(?::\w+)*\])/'                                      => "\\1"

            );

            $message = preg_replace(array_keys($preg), array_values($preg), $message);
            return $message;
        }

// Call Function bb2html and echo

$htmltext = bb2html($message);
echo $htmltext;

Multiple Left JOIN in One SQL Query

2012-01-06T13:12:00.001+05:30

Two Tables
1. w6h8a_community_favloc
2. w6h8a_csearchm_rides

SELECT CONCAT( (
SELECT statecode
FROM w6h8a_states
WHERE w6h8a_states.state = f1.states
), '|', f1.city, '|', f1.zip, '|', r.event_type, '|', f1.address1, '|', f2.address1, '|', '', '|', (
SELECT statecode
FROM w6h8a_states
WHERE w6h8a_states.state = f2.states
), '|', f2.city, '|', f2.zip, '|', '', '|', f1.name, '|', f2.name, '|', r.ride_name ) AS value, r.ride_name AS text
FROM w6h8a_csearchm_rides AS r
LEFT JOIN w6h8a_community_favloc AS f1 ON f1.name = r.pickup_fav_loc_name
AND f1.userid = r.user_id
LEFT JOIN w6h8a_community_favloc AS f2 ON f2.name = r.dropoff_fav_loc_name
AND f2.userid = r.user_id
WHERE r.user_id =82
GROUP BY r.id

It will not getting right output to generating value string.

Solution :

SELECT CONCAT( (
SELECT statecode
FROM w6h8a_states
WHERE w6h8a_states.state = f1.states
), '|', f1.city, '|', f1.zip, '|', r.event_type, '|', f1.address1, '|', f2.address1, '|', '', '|', (
SELECT statecode
FROM w6h8a_states
WHERE w6h8a_states.state = f2.states
), '|', f2.city, '|', f2.zip, '|', '', '|', f1.name, '|', f2.name, '|', r.ride_name ) AS value, r.ride_name AS text
FROM (
(
w6h8a_csearchm_rides AS r
LEFT JOIN w6h8a_community_favloc AS f1 ON f1.name = r.pickup_fav_loc_name
AND f1.userid = r.user_id
)
LEFT JOIN w6h8a_community_favloc AS f2 ON f2.name = r.dropoff_fav_loc_name
AND f2.userid = r.user_id
)
WHERE r.user_id =82
GROUP BY r.id

In this you have to put two braces after FROM and complete first braces after first join and second braces after second join like this it will working perfectly.

Sorting strings and numbers(varchar type column) in SQL query

2011-11-29T12:48:00.001+05:30

Problem :
I have a problem with sorting by a string-column when i use SQL query on MySQLServer. There are both numbers, strings and mixture of both in this column and when i sort it numbers are not looks in sorting. ex. 7.5 6 14 8.5 9. I would like to sort numbers numerically and both strings and mixed alphabetically, 14 6 7.5 8.5 9.

Soluation :

Set your query in sorting by using "order by '0000000000'+rtrim(FEILDNAME)"

Where FEILDNAME is your varchar type column name which you want to sort. This will build up a string for the numbers with leading zeros, so they will get sorted correctly.

Image download using CURL - PHP

2011-08-18T00:17:00.000+05:30

$url = 'IMAGE PATH URL';
//$random_no = rand(10000,99999999); // for random number
//$file_handler = fopen($random_no.'.jpeg', 'w'); // random number image name
$file_handler = fopen('image1.jpeg', 'w'); // static image name as image1
$curl = curl_init($url);
curl_setopt($curl, CURLOPT_FILE, $file_handler);
curl_setopt($curl, CURLOPT_HEADER, false);
curl_exec($curl);
curl_close($curl);
fclose($file_handler);

Using this code you can download image from server where 'IMAGE PATH URL' is the url of image. Image is generated in jpeg file extension named as image1 or you can use random generated name.

Hope its help you.

Noconflict plugins in Joomla

2011-08-18T00:02:00.000+05:30

SC jQuery plugin is used to load jQuery javascript library, and set "no conflict" mode to allow usage with mootools, and other libraries. No conflict mode removes the "$" operator from jQuery, allowing other libraries to use that operator. This plugin is use in joomla 1.5, joomla 1.6 and also in joomla 1.7 .

More usage details for jQuery no conflict mode are available at http://docs.jquery.com/Using_jQuery_with_Other_Libraries

For More detail and download plugin visit @ http://extensions.joomla.org/extensions/core-enhancements/scripts/7230

JQuery and Mootools conflicts in Joomla

2011-08-17T23:50:00.001+05:30

Mootools and jQuery can conflict each other in joomla, when you load both in your joomla site because they can use same method names, therefore one of both could break.So when you create a nice Template for Joomla 1.5 and you decide to use jQuery, the hell breaks open when implementing:

<jdoc:include type="head" />

This, is because Joomla 1.5 uses MooTools and Caption javascript frameworks, for the backend admin panel, but also some components may require it.

So for no-conflict jQuery wrote the following lines in the top of my index.php template:

$headerstuff = $this->getHeadData();
$headerstuff['scripts'] = array();
$this->setHeadData($headerstuff);

XiUS3.0 Beta is now compatible with Joomla 1.7

2011-08-17T00:09:00.000+05:30

JoomlaXi XiUS3.0 Beta is released. which is now compatible with Joomla 1.7 and JomSocial 2.2.3.
Download it now from www.joomlaxi.com.
User will not loss any setting on installing stable version at their site.

Assign Different Menu for Login user and unregistered user

2011-08-08T23:22:00.000+05:30

Sometimes you need to check whether user login or not for assign different condition to both login user and unregistered user in joomla customization. Only you have to write if else condition to check that. For example in joomla site you need to assign different menus for frontend. before login users can see a normal menu but after user login they will see another menu. you can write the code in the template index file and assign different menu.

<?php
   $user =& JFactory::getUser();
   if ($user->get('id') == NULL) {
?>
    <jdoc:include type="modules" name="nonregister_menu">
<?php
   }
elseif ($user->get('id') != NULL) {
?>
   <jdoc:include type="modules" name="loginuser_menu">
<?php
   }
?>

How to get current joomla User ID and Username

2011-08-08T22:54:00.000+05:30

For joomla starter, sometime we need to get joomla user ID and username to customize in joomla component, plugins or modules. for that we have to write simple code

<?php
    $user =& JFactory::getUser();
    $usr_id = $user->get('id');
    echo "Current Login User Id : ".$usr_id;  // this is the log-in user ID :-)

    $usr_name = $user->get('username');
    echo "Current Login User Name : ".$usr_name;  // this is the log-in username :-)

    //after getting the user ID and username you can run your custom code
?>

Find string between two strings - PHP

2011-08-05T23:23:00.002+05:30

This is a little function to find a string between two specified pieces of strings. This could be used to find any string between two strings.


function get_string($string, $start, $end){
 $string = " ".$string;
 $pos = strpos($string,$start);
 if ($pos == 0) return "";
 $pos += strlen($start);
 $len = strpos($string,$end,$pos) - $pos;
 return substr($string,$pos,$len);
}

$fullstring = "Find string between two strings in PHP";
$parsed = get_string($fullstring, "between ", " in PHP");

echo $parsed;

(result = two strings)

Assign an smarty variable to a PHP variable

2011-08-04T00:28:00.000+05:30

Developer can use PHP code in smarty(.tpl file code) within a {php} block or an {include_php}.

when developer use a {php} block inside a Smarty template developer are inside the Smarty scope (object)
So when developer need to reference a Smarty method developer would use $this
so when developer assign an smarty variable to a php variable it looks something like this in smarty:

Code:

{php}
$t = $this->get_template_vars( 'foo' );
{/php}

print_r in Smarty development

2011-08-04T00:03:00.000+05:30

{$foo|@print_r}

The @ tells smarty to pass the entire array to the modifier rather than calling the modifier for each element of the array.

Smarty also print array like php print_r() function: {$foo|@debug_print_var}.

Developer may also consider smarty's debug facility (which developer can enable in-template by inserting a {debug} tag).

JoomlaXi is now compatible with Joomla1.7

2011-08-03T23:07:00.000+05:30

JoomlaXi JSPC3.1 Beta is released and JSPT3.2.701 also have been released both are now compatible with Joomla1.7.

Upload Video in JomSocial

2011-08-03T00:17:00.000+05:30

Now, you can upload your video on JomSocial site. Video-related configuration is located under JomSocial Configuration > Media tab.

Enable Videos: Enable or disable the videos functionality in JomSocial.
Enable guest search: Option to disallow guests from searching videos.
Enable profile videos: Allow users to select a video for their profile.
Enable videos upload: Enable or disable the videos uploading feature in JomSocial.
Video creation limit: Set a limit to creation of videos per user.
Delete original videos: If enabled, original videos are deleted once the videos are converted to the appropriate formats.
Videos root folder: Set the path to where videos are stored.
Maximum video upload size: Set the maximum uploaded video size allowed in Megabytes (MB)
FFMPEG Path: Set the absolute path to FFMPEG binary. If the binary is not found, JomSocial will not be able to convert videos into .flv formats.
FLVTool2 Path: Set the absolute path to FLVTool2 binary to enable flash video metadata injections.
Video Quantizer Scale: Select the video quality from a scale of 1 (Excellent) to 31 (Worst). 5, 9 and 11 are recommended settings.
Videos Size: Set the video frame size in width X height format.
Custom Command: Specify additional commands for FFMPEG ( Advanced Users )
Pseudo streaming: Allow users to skip to specific section of the video.

visit : http://www.jomsocial.com/support/docs/item/759-configuring-video-upload-and-linking.html

Second Highest Value SQL query

2011-08-02T22:53:00.000+05:30

select max(FIELDNAME)
from TABLENAME
where FIELDNAME not in
(select max(FIELDNAME)
from TABLENAME);

MVC Structure Basics, MVC Architecture, Joomla

2011-08-02T22:45:00.001+05:30

For starters, MVC stands for Model, View, Controller. It is a programing structure used in developing web apps. This structure isolates the user interface and backend (i.e. database interaction from each other. A successful implementation of this lets developers modify their user interface or backend with out affecting the other. MVC structure also increases the flexibly of an application by being able to resuse models or views over again). Below is a description of MVC structure.

Model: The model deals with the raw data and database interaction and will contain functions like adding records to a database or selecting specific database records.
View: The view deals with displaying the data and interface controls to the user with.
Controller: The controller acts as the in between of view and model and, as the name suggests, it controls what is sent to the view from the model.

An example of a MVC structure approach would be for a contact form.

The user interacts with the view by filling in a form and submitting it.
The controller receives the POST data from the form, the controller sends this data to the model which updates in the database.
The model then sends the result of the database to the controller.
This result is updated in the view and displayed to the user.

This may sound like alot of work to do. But, trust me; when you’re working with a large application, being able to reuse models or views saves a great deal of time.

JSPT 3.2 Stable Release, JomSocial Profile Type Joomlaxi

2011-08-01T23:18:00.001+05:30

JSPT 3.2 stable release comes with the enhanced functionality requested by customers, fixing performance related bugs. The new version is all about the Customers request, loyalty and faith on the product

A major feature are :-

Enhance Access Control Rules: Now you can create more ACL rules to restrict JS Group features. For example, Profiletype users can be restricted on creating group discussion, bulletins as well as sending mails to group members.
Force user avatar: Admin can force profiletype users to upload avatar any time.
Integration with PayPlans: Previously, JSPT was integrated only with AEC for paid subscription system. But now, JSPT is integrated with one more subscription system named as PayPlans. JSPT provide flexibility to choose your subscription system according to your requirement.
JomSocial Toolbar display: JSPT added a new window for JS Toolbar selection. You can assign different JomSocial tabs according to Profiletype.
Profiletype Selection: Completely new page is designed for profiletype selection at registration time. The selection page is more user friendly and looking better in display.

More Detail : http://joomlaxi.com/company/blog/154-jspt-32-stable-release.html

SQL Server - An identity feild can have negative seed value and negative increments also

2011-08-01T23:01:00.002+05:30

Always everyone will start identity value from 1 and increment by 1. However, an identity column can have negative seed value and can be negatively also incremented. Suppose below table will have 4 rows with id values -100,-101,-102,-103

declare @t table

(

Id int identity(-100,-1),

Col1 int

)

insert into @t values (1),(2),(3),(4)

select * from @t

Renew JomSocial and get 10% off

2011-07-27T23:44:00.001+05:30

Is your JomSocial expiring? Jomsocial brought a great deal for users! Renew JomSocial today and get 10% off! Make sure you renew before 29th of July. Hurry up while this offer last!

Has your JomSocial membership expired or it is about to expire? Would you like to download the latest JomSocial release? Post on the forum for technical support or ideas?

If YES, Renew JomSocial and get 10% off

More Detail Visit : http://www.jomsocial.com/newsletters/july/07/

jCarousel: No width/height set for items

2011-07-26T23:38:00.000+05:30

PROBLEM: While loading, jCarousel popup alert with this error message:

"jCarousel: No width/height set for items. This will cause an infinite loop. Aborting..."

I would always get this error message every time the front page loads. I have been searching for a solution for many months and have finally found one.

SOLUTION: Not sure if this is really a solution or workaround, but it does the job of stopping the nagging popup box once and for all (while permitting jCarousel functionality).

Open jquery.jcarousel.pack.js in the ../jcarousel/lib/ directory.
Search for the word "alert" and you should find a snippet of code like this:
_{Aborting|loop|infinite|an|cause|will|This|items|set|No|jCarousel|}_alert_|class|
Replace "alert" with "isNan":
_{Aborting|loop|infinite|an|cause|will|This|items|set|No|jCarousel|}_isNan_|class|
Refresh the webpage that loads jCarousel and you should no longer get the infinite loop popup error!

Joomla logout Button or Link, Joomla1.6 or Joomla1.7

2011-07-26T00:24:00.007+05:30

Joomla 1.5 Logout Link

<a href="index.php?option=com_user&task=logout&return=Lw">Log Out</a>

In Joomla 1.5 make a menu-item type 'url' to
If you want to create a "log out" button or link for users, here is the easiest way. Create a new menu of “External Link” type. Then, set its access level to "Registered" and give it any name you want like “Logout.” In the “Link” text box type the following “index.php?option=com_user&task=logout&return=Lw”.

Joomla 1.6 or Joomla 1.7 Logout Link

Hello Everyone,
I found a solution, If you want to create a "log out" button in Joomla 1.6 or Joomla 1.7, override the joomla token in get method:

<a href="index.php?option=com_users&task=user.logout&<?php echo JUtility::getToken(); ?>=1&return=<?php echo base64_encode($this->baseurl); ?>">LOGOUT</a>

It's works like a charm.

I hope it's help you. Please comments on it and share it.

Right now Joomlaxi not compatible with Joomla1.7

2011-07-26T00:01:00.003+05:30

Right now I am working with latest Joomla 1.7 and JomSocial 2.2.3 beta. but when i am trying to install Joomlaxi(JSPT and XiUS) it will getting error. When I was searching on that i got that "Right now, JSPT and XiUS is not compatible with Joomla1.7" .

For More Detail : http://www.joomlaxi.com/support/forum/42-pre-sale-questions/13338-joomlaxi-user-search-and-j16-j17-acl-user-groups.html

Set your Joomla Module in Component in Joomla

2011-07-25T23:37:00.004+05:30

jimport('joomla.application.module.helper');

                        // this is where you want to load your module position
                        $modules = JModuleHelper::getModules('MODULE-POSITION');
                        foreach($modules as $module)
                        {
                            echo JModuleHelper::renderModule($module);
                        }

You can set joomla modules in your joomla components by setting this code. only you have to put this code in component where you want to saw you Joomla module and only set position in 'MODULE-POSITION'.

JomSocial 2.2.3 Beta 3 with Joomla 1.7 support Released

2011-07-21T00:28:00.002+05:30

JomSocial have just released JomSocial 2.2.3 Beta 3 which is compatible with Joomla! 1.7 Beta. There are various bugfixes and feature enhancements packed into this release. If you are an active customer and would like to try this out, head over to our release thread.

JomSocial Introduce New Avatar Sets for UDA

There is another latest news from JomSocial! Jomsocial has introduce their new faces on JomSocial. 5 new exciting avatar sets to support all the different kind of communities customers are building. Jomsocial have casual, business/corporate, entertainment, and education. But now jomsocial introduce each set will have its own set of avatars to represent default user, video, photo, event and group. JomSocial has never looked this hip and good before!

Kunena Latest Recent Topics module for Joomla 1.6

2011-07-20T23:58:00.004+05:30

/**
* @version $Id$
* Kunena Latest Module
* @package Kunena Latest / Recent Topics
* @Copyright (C) 2008-2011 Kunena Team. All rights reserved
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
* @link http://www.kunena.org
**/

Kunena Latest / Recent Topics Module README

PLEASE READ THIS ENTIRE FILE BEFORE INSTALLING 
Kunena Latest @kunenaversion@!

INTRODUCTION
============

Kunena Latest Module enables your site visitors to see 
latest posts or recent topics or latest / recent 
messages from a forum.

Requirements: Joomla 1.5, Joomla 1.6, Kunena Forum 1.6

END OF README
=============

For more detail : https://github.com/Kunena/mod_kunenalatest-1.6

Insert, Update and Delete Query in Joomla

2011-07-20T23:38:00.007+05:30

Now its Insert, Update and Delete Query in Joomla,

For INSERT query in Joomla structure
$db = &JFactory::getDBO();
             $insert_query = "INSERT into #__TABLENAME(feild1,feild2) values('value1','value2') ";
             $db->setQuery( $insert_query );
             $db->query();

For UPDATE query in Joomla structure
             $update_query = "UPDATE #__TABLENAME SET feild1 = 'value1' ";
             $db->setQuery( $update_query );
             $db->query();

For DELETE query in Joomla structure
             $delete_query = "DELETE FROM #__TABLENAME WHERE feild1 = 'value1' ";
             $db->setQuery( $delete_query );
             $db->query();

SQL Query in Joomla

2011-07-14T13:17:00.009+05:30

Hi to everyone,

In Joomla you create sql query easy way. Only you have to get DBO connection to start database connection only one time in a page.

$db = &JFactory::getDBO();
       $query = "select * from #__TABLENAME";
       $db->setQuery($query);
       $rows = $db->loadObjectList();

in which "TABLENAME" is your joomla table name and "#__" is behalf of "jos_". "jos_" is predefined value in every jomla table. $rows is an array in which all records has been fetched from database.