Select query in typo3


Select query in typo3

PHP-Code:

// SELECT:

$query $GLOBALS['TYPO3_DB']->SELECTquery(
                                           '*',                                    // SELECT ...
                                           'mytable',                              // FROM ...
                                           'uid=143 AND name LIKE "%jainish%"',    // WHERE...
                                           '',                                     // GROUP BY...
                                           'name',                                 // ORDER BY...
                                           '5'                                     // LIMIT ...
                                         );

$res $GLOBALS['TYPO3_DB']->sql(TYPO3_db$query); 

OR

You can use like :

$query $GLOBALS['TYPO3_DB']->exec_SELECTquery(
                                           '*',                                    // SELECT ...
                                           'mytable',                              // FROM ...
                                           'uid=143 AND name LIKE "%jainish%"',    // WHERE...
                                           '',                                     // GROUP BY...
                                           'name',                                 // ORDER BY...
                                           '5'                                     // LIMIT ...
                                         );

$query $GLOBALS['TYPO3_DB']->exec_SELECTquery(
                                                                     $select_fields,
      // SELECT ...
                                                                     $from_table,
         // FROM ...
                                                                     $where_clause
,       // WHERE...
                                                                     $groupBy= '',
        // GROUP BY...
                                                                     $orderBy= '',
        // ORDER BY...
                                                                     $limit=''
            // LIMIT ...
                                                                   );

If you have any query then feel free to contact me at Jainish Senjaliya

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s