RecordHelpers Chap 6

rhchp-6

<?php
  
namespace common\models;

use yii;

class RecordHelpers
{
    
    public static function userHas($model_name)
    {
        $connection = \Yii::$app->db;
        $userid = Yii::$app->user->identity->id;
        $sql = "SELECT id FROM $model_name WHERE user_id=:userid";
        $command = $connection->createCommand($sql);
        $command->bindValue(":userid", $userid);
        $result = $command->queryOne();
    
        if ($result == null) {
                             
            return false;
    
        } else {
                         
            return $result['id'];
                      
        }
  
     } 
    
}

$userid = Yii::$app->user->identity->id;

Maybe:
$userid = \Yii::$app->user->identity->id;

Forgot backslash before Yii

Hi Bill,
thank you for your amazing book.

I am a beginner, so probably I am wrong, but, for security purpose ("quoting"), is it possible to replace:
$sql = "SELECT id FROM $model_name WHERE user_id=:userid";
by
$sql = "SELECT id FROM {{%" . $model_name . "}} WHERE user_id=:userid";

Thanks