get role id from role name in drupal 7?

This is quite straightforward with user_roles() and array_search(). Below is a function which will return the role ID if there is a role matching the name and FALSE otherwise.

function get_role_by_name($name) {
  $roles = user_roles();
  return array_search($name, $roles);
}

// Sample usage
$rid = get_role_by_name('administrator');

One liner would be:

$rid = array_search('administrator', user_roles());

Create new user in drupal 7

public function createNewUser(){
        $result=true;
        try{
            $roles = user_roles();
           
            $selectedRole=array();
            foreach($roles as $key => $value){
                if($key==$this->role_id){
                    $selectedRole[$key]=$value;
                }
            }
           
           
            $newUserData = array(
                    'name' => $this->user_name,
                    'pass' => $this->password, // note: do not md5 the password
                    'mail' => $this->mail,
                    'status' => $this->status,
                    'timezone' => variable_get('date_default_timezone'),
                    'init' => $this->mail,
//                     'roles' => array(
//                             DRUPAL_AUTHENTICATED_RID => 'authenticated user',
//                             $this->role_id='tess',
//                     ),
                    'roles'=>$selectedRole,
                    'data' => '',
            );
            //Step 1 : Save the User Details in Drupal built in function user_save
            //The Data stored in users and user_roles table
            $new_user = user_save(@$account, $newUserData);
           
            //Success
            if($new_user){
                //Step 2 : Save the User Details in user_details Table
                try {
                    $query=db_insert('user_accounts');
                    $query->fields(array(
                            'uid'=>$new_user->uid,
                            'first_name'=>$this->firstname,
                            'last_name'=>$this->last_name,
                            'company_name'=>$this->company_name,
                            'phone'=>$this->phone,
                            'address'=>$this->address,
                    ));
                    $userid=$query->execute();
                   
                    if($userid){
                        $result=$new_user->uid;
                        //return $userid;
                        //success
                    }else{
                        $result=false;
                        //failed
                        watchdog("userdetails", 'userdetails record insertion failed');
                    }
                }catch (Exception $e){
                    $result=false;
                    watchdog("userdetails", $e);
                }
            }
        }catch(Exception $e){
            $result=false;
            watchdog("userdetails", $e);
        }
       
        return $result;
    }

Include files in drupal 7 .info

; $Id$
name = fleet management
description = Fleet Management Back End
core = 7.x
package = LSN Software Services

dependencies[] = ckeditor

files[] = classes/hide_show.inc
files[] = classes/fleetoverview.class.inc
files[] = classes/fleetvirtualtour.class.inc
files[] = classes/fleetmiddlecontain.class.inc
files[] = classes/fleetgallery.class.inc
files[] = classes/fleetnav.class.inc
files[] = classes/fleetdelete.class.inc

Insert delete drupal 7 classs

<?php

class Fooandbarcat{
   
    public static $tableName="foodandbarcat";
    public $catName='';
    public $catId='';
    public $status;
    public $position;
   
    public function insertFoodandBarCategoriesData(){
        try{
        $record = array( 'catName' => $this->catName);
        $results= db_insert(self::$tableName)
                ->fields($record)
->execute();
return $results;
            }catch(Exception $e){

               
            }
}
       
      public  function getFoodandBarategoriesData(){
          try{
$result = db_select(self::$tableName, 'g')
->fields('g')
->condition('catId', $this->catId, '=')
->execute()->fetchObject();
return $result;
          }catch(Exception $e){
              drupal_set_message(t('db_select failed. Message = %message, query= %query',array('%message' => $e->getMessage(), '%query' =>$e->query_string)), 'error');
          }
}
       
        public  function getActiveFoodandbarEvents(){
            try{
$result = db_select(self::$tableName, 'p')
->fields('p')
                ->condition('status',$this->status ,'=')
                ->orderBy('position', 'ASC')      
->execute()->fetchAll();
return $result;
                }catch(Exception $e){
              drupal_set_message(t('db_select failed. Message = %message, query= %query',array('%message' => $e->getMessage(), '%query' =>$e->query_string)), 'error');
            }

}
        public  function getAllFoodandbarEvents()
        {
         try{
            $result=db_select('foodandbarcat','h')
                ->fields('h')
                ->orderBy('h.position')
                ->execute()
                ->fetchAll();
            return $result;
             }catch(Exception $e){
              drupal_set_message(t('db_select failed. Message = %message, query= %query',array('%message' => $e->getMessage(), '%query' =>$e->query_string)), 'error');
            }
        }
       
       
         public  function getFoodandBarUpdateData(){
                  db_update(self::$tableName)
->fields(array('catName' => $this->catName))
->condition('catId', $this->catId, '=')
->execute();

        }
       
         public function deleteDataFromwwcfoodandbarcat(){
                       db_delete(self::$tableName)
                           ->condition('catId', $this->catId)    
                          ->execute();
      }
     
         public function updateFoodandBarStatus(){
                     db_update(self::$tableName)
                            ->fields(array('status' => $this->status))
                            ->condition('catId', $this->catId, '=')
                            ->execute();

}
       
       
        public function orderbyPositionfoodandbar(){
                     $results= db_update('foodandbarcat')
                                ->fields(array('position' => $this->position))
                                ->condition('catId', $this->catId, '=')
                                ->execute();
                       return $results;
        }
     
}

Drupal 7 form for every one

function agentregistration_menu(){
    $items = array();
    $items['agentregistration'] = array(
         'title' => 'Agent Registration',
        'page callback' => 'drupal_get_form',
        'page arguments' => array('agent_registration'),
        'file' => 'inc/agentregistration.inc',
        'access callback' => 'user_access',
'access arguments' => array('access content'),
       
    );
   
     return $items;
}

data base create in drupal 7

CREATE TABLE IF NOT EXISTS  `fleet_overview` (
 `Id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
 `data` LONGTEXT COMMENT  'Data',
 `position` INT( 11 ) DEFAULT NULL ,
 `status` INT( 11 ) DEFAULT 1,
PRIMARY KEY (  `Id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =9


CREATE TABLE IF NOT EXISTS  `fleet_virtual` (
 `Id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
 `mainid`INT(11) NOT NULL,
 `virtualimage` LONGTEXT COMMENT  'virtualimage',
PRIMARY KEY (  `Id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =9


CREATE TABLE IF NOT EXISTS  `fleet_middle_slider` (
 `Id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
 `mainid`INT(11) NOT NULL,
 `middleimage` INT(11) NOT NULL COMMENT  'middleimage',
 `accomodations` LONGTEXT COMMENT  'accomodations',
PRIMARY KEY (  `Id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =9



CREATE TABLE IF NOT EXISTS  `fleet_gallery` (
 `Id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
 `mainid` INT( 11 ) NOT NULL ,
 `galleryType` VARCHAR( 256 ) ,
 `galleryData` VARCHAR( 256 ) ,
 `position` INT( 11 ) NULL ,
PRIMARY KEY (  `Id` )
) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =9

include css in drupal 7

drupal_add_css(drupal_get_path('module', 'affilationbackend') . '/css/affilationbackend.css');