Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Drupal 7 database API

    @naveen.kumar
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 152
    Comment on it

    Drupal database abstraction layer allow's the use of different database servers using the same code base i.e it provides with the ability to support multiple database servers easily. The system is built a top PHP's PHP Data Objects database API and inherits much of its syntax.

    with select query we can use: 

    1.     execute($arg=array(), $option = array())
    2.     fetchAllAssoc($key, fetch=null)
    3.     fetchAllKeyed($keyindex=0, $valueindex=1)
    4.     fetchAssoc()
    5.     fetchCol($inde=0)
    6.     fetchField($inde=0)
    7.     getQueryString()
    8.     rowCount()

    Some very basic example are as under:

    Basis SQL Select query:

    1.     Select n.name, n.decription, created FROM node n WHERE n.uid = $uid
    2.       ORDER BY n.created DESC LIMIT 0, 5;

    Select in Drupal 7 way :

    1. <?php 
    2.  
    3.     $query = db_select('node', 'n');
    4.     $query->fields('n', array('name', 'n.description','created'));
    5.     $query->condition('n.uid', $uid, '=');
    6.     $result = $query->execute();
    7.  
    8.     //count the result
    9.     $datacount = $result->rowCount();
    10.  
    11.     if($datacount > 0){
    12.         //Fetch the data as object from database
    13.         $data = $result->fetchAll();
    14.     }
    15. ?>

    Basis SQL Insert query:

    1.     insert into mytable(intvar1, intvar2, floatvar, strinvar) values (10, 90, 67.9, 'myapp');

    Insert in Drupal 7 way :

    1. <?php
    2.     $nid = db_insert('mytable')
    3.     ->fields(array(
    4.     'intvar1', => 10,
    5.     'intvar2' => 90,
    6.     'stringvar' => 'myapp',
    7.     'floatvar' => 3.14
    8.     ))->execute();
    9.     ?>

    Basis SQL Update query:

    1. update myapp SET stringvar = 'yourapp' where intvar1 = 10;

    Update in Drupal 7 way :

    1. <?php 
    2.  
    3.     $nidupdate = db_update('mytable')
    4.      ->fields(array(
    5.         'stringvar' => 'yourapp'
    6.     ))
    7.     ->condition('invar1', 10 ,'=')
    8.     ->execute();
    9.     ?>

    Basis SQL Delete query:

    1.  Delete from myapp where intvar1 = 10;

    Drupal 7 Way :

    1. <?php
    2. delete('myapp')->condition('invar1', 5, '=')->execute();
    3. ?>
    Drupal 7 database API Database access drupal 7
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: