Can We Use Core Php Functions In Yii Framework?

Yii 1.1 General Discussion
1

down vote favorite

Can we use core PHP functions in Yii framework?

Here, I have a core php function




function abc_function(){

$query=mysql_query("select employee_id, holidays from employee_work where company_id='$company_id' AND emp_active=1");

$count=mysql_num_rows($query);

if ($count) {

    $del_existing=mysql_query("DELETE from temp_timeoff_balances where company_id='$company_id'");

    $row=mysql_fetch_array($query);

    while ($row) {

        $employee_id=$row['employee_id'];

        $array=display_timeoff_balances ($employee_id,$company_id);

        $starting_balance=$array[0];

        $taken=$array[1];

        $company_holidays=$array[2];

        $remaining_balance=$array[3];

        $booked=$array[4];

        $true_balance=$array[5];

        $all_days=$array[6];

        $insert_balances=mysql_query("INSERT into temp_timeoff_balances values ('','$company_id','$employee_id','$starting_balance','$taken','$remaining_balance','$booked','$true_balance')");

        $row=mysql_fetch_array($query);

    }

}

}

Is this possible? Thanks in advance

2

Yes you can! :)

3

Can you please show me coding view for the function i have posted above?

4

For Select Query :

$rawData = Yii::app()->db->createCommand()

		  ->select('usr_name,usr_pwd')


		  ->from('user')


		  ->where('login_id=:id1', array(':id1'=>$usr_login_id))


		  ->queryAll();

For Update Query :

Yii::app()->db->createCommand()->update(‘user’, array(

					'user_name'=>"xyz",


					), 'usr_id=:id', array(':id'=>$usr_id));

For Insert Query :

Yii::app()->db->createCommand()->insert(‘user’, array(

					    'user_name'=>$uname,


					    'adm_password'=>$pwd,


					));

For Delete :

Yii::app()->db->createCommand()->delete(‘user’, ‘usr_id=:id’, array(’:id’=>$id));

5

For custom query, this link can be very much useful.

http://www.yiiframework.com/doc/guide/1.1/en/database.query-builder