《PHP實戰:YII Framework框架使用YIIC快速創建YII應用之migrate用法實例詳解》要點:
本文介紹了PHP實戰:YII Framework框架使用YIIC快速創建YII應用之migrate用法實例詳解,希望對您有用。如果有疑問,可以聯系我們。
相關主題:YII框架
PHP學習本文實例講述了YII Framework框架使用YIIC快速創建YII應用之migrate用法.分享給大家供大家參考,具體如下:
PHP學習yii migrate
PHP學習查看贊助
PHP學習
/*
/www/yii_dev/yii/framework# php yiic migrate help
Error: Unknown action: help
USAGE
yiic migrate [action] [parameter]
DESCRIPTION
This command provides support for database migrations. The optional
'action' parameter specifies which specific migration task to perform.
It can take these values: up, down, to, create, history, new, mark.
If the 'action' parameter is not given, it defaults to 'up'.
Each action takes different parameters. Their usage can be found in
the following examples.
EXAMPLES
* yiic migrate
Applies ALL new migrations. This is equivalent to 'yiic migrate to'.
* yiic migrate create create_user_table
Creates a new migration named 'create_user_table'.
* yiic migrate up 3
Applies the next 3 new migrations.
* yiic migrate down
Reverts the last applied migration.
* yiic migrate down 3
Reverts the last 3 applied migrations.
* yiic migrate to 101129_185401
Migrates up or down to version 101129_185401.
* yiic migrate mark 101129_185401
Modifies the migration history up or down to version 101129_185401.
No actual migration will be performed.
* yiic migrate history
Shows all previously applied migration information.
* yiic migrate history 10
Shows the last 10 applied migrations.
* yiic migrate new
Shows all new migrations.
* yiic migrate new 10
Shows the next 10 migrations that have not been applied.
*/
PHP學習在我們開發程序的過程中,數據庫的結構也是不斷調整的.我們的開發中要保證代碼和數據庫庫的同步.因為我們的應用離不開數據庫.例如: 在開發過程中,我們經常需要增加一個新的表,或者我們后期投入運營的產品,可能需要為某一列添加索引.我們必須保持數據結構和代碼的一致性.如果代碼和數據庫不同步,可能整個系統將無法正常運行.出于這個原因.yii提供了一個數據庫遷移工具,可以保持代碼和數據庫是同步.方便數據庫的回滾和更新.
PHP學習功能正如描述.主要提供了數據庫遷移功能.
PHP學習命令格式
PHP學習yiic migrate [action] [parameter]
PHP學習action參數用來制定執行哪一個遷移任務.可以一使用
PHP學習up, down, to, create, history, new, mark.這些命令
PHP學習如果沒有action參數,默認為up
PHP學習parameter根據action的不同而有所變化.
PHP學習上述例子中給出了說明.
PHP學習官方也給出了詳細的例子.
PHP學習http://www.yiiframework.com/doc/guide/1.1/zh_cn/database.migration#creating-migrations
PHP學習這里不再詳細累述.用到的時候參考使用就可以了.
PHP學習補充:yii2.0使用migrate創建后臺登陸
PHP學習重新創建一張數據表來完成后臺登陸驗證
PHP學習為了大家看得明白,直接貼代碼
PHP學習一、使用Migration創建表admin
PHP學習console\migrations\m130524_201442_init.php
PHP學習
use yii\db\Schema;
use yii\db\Migration;
class m130524_201442_init extends Migration
{
const TBL_NAME = '{{%admin}}';
public function safeUp()
{
$tableOptions = null;
if ($this->db->driverName === 'mysql') {
// http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
$tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
}
$this->createTable(self::TBL_NAME, [
'id' => Schema::TYPE_PK,
'username' => Schema::TYPE_STRING . ' NOT NULL',
'auth_key' => Schema::TYPE_STRING . '(32) NOT NULL',
'password_hash' => Schema::TYPE_STRING . ' NOT NULL', //暗碼
'password_reset_token' => Schema::TYPE_STRING,
'email' => Schema::TYPE_STRING . ' NOT NULL',
'role' => Schema::TYPE_SMALLINT . ' NOT NULL DEFAULT 10',
'status' => Schema::TYPE_SMALLINT . ' NOT NULL DEFAULT 10',
'created_at' => Schema::TYPE_INTEGER . ' NOT NULL',
'updated_at' => Schema::TYPE_INTEGER . ' NOT NULL',
], $tableOptions);
$this->createIndex('username', self::TBL_NAME, ['username'],true);
$this->createIndex('email', self::TBL_NAME, ['email'],true);
}
public function safeDown()
{
$this->dropTable(self::TBL_NAME);
}
}
PHP學習使用命令行來創建admin數據庫
PHP學習1、win7下使用命令:
PHP學習在項目根目下,右鍵選擇User composer here(前提是安裝了全局的composer),
yii migrate
PHP學習即創建數據表 admin成功
PHP學習
PHP學習2、linux下命令一樣(此處略)
PHP學習二、使用gii創建模型
PHP學習此處略,很簡單的步聚.
PHP學習注:把admin模型創在 backend/models下面 (放哪里看個人愛好)
代碼如下
PHP學習
namespace backend\models;
use Yii;
use yii\base\NotSupportedException;
use yii\behaviors\TimestampBehavior;
use yii\db\ActiveRecord;
use yii\web\IdentityInterface;
/**
* This is the model class for table "{{%admin}}".
*
* @property integer $id
* @property string $username
* @property string $auth_key
* @property string $password_hash
* @property string $password_reset_token
* @property string $email
* @property integer $role
* @property integer $status
* @property integer $created_at
* @property integer $updated_at
*/
class AgAdmin extends ActiveRecord implements IdentityInterface
{
const STATUS_DELETED = 0;
const STATUS_ACTIVE = 10;
const ROLE_USER = 10;
const AUTH_KEY = '123456';
/**
* @inheritdoc
*/
public static function tableName()
{
return '{{%admin}}';
}
/**
* @inheritdoc
*/
public function behaviors()
{
return [
TimestampBehavior::className(),
];
}
/**
* @inheritdoc
*/
public function rules()
{
return [
[['username', 'email',], 'required'],
[['username', 'email'], 'string', 'max' => 255],
[['username'], 'unique'],
[['username'], 'match', 'pattern'=>'/^[a-z]\w*$/i'],
[['email'], 'unique'],
[['email'], 'email'],
['status', 'default', 'value' => self::STATUS_ACTIVE],
['status', 'in', 'range' => [self::STATUS_ACTIVE, self::STATUS_DELETED]],
['role', 'default', 'value' => self::ROLE_USER],
['auth_key', 'default', 'value' => self::AUTH_KEY],
['role', 'in', 'range' => [self::ROLE_USER]],
];
}
/**
* @inheritdoc
*/
public static function findIdentity($id)
{
return static::findOne(['id' => $id, 'status' => self::STATUS_ACTIVE]);
}
/**
* @inheritdoc
*/
public static function findIdentityByAccessToken($token, $type = null)
{
return static::findOne(['access_token' => $token]);
//throw new NotSupportedException('"findIdentityByAccessToken" is not implemented.');
}
/**
* Finds user by username
*
* @param string $username
* @return static|null
*/
public static function findByUsername($username)
{
return static::findOne(['username' => $username, 'status' => self::STATUS_ACTIVE]);
}
/**
* Finds user by password reset token
*
* @param string $token password reset token
* @return static|null
*/
public static function findByPasswordResetToken($token)
{
if (!static::isPasswordResetTokenValid($token)) {
return null;
}
return static::findOne([
'password_reset_token' => $token,
'status' => self::STATUS_ACTIVE,
]);
}
/**
* Finds out if password reset token is valid
*
* @param string $token password reset token
* @return boolean
*/
public static function isPasswordResetTokenValid($token)
{
if (empty($token)) {
return false;
}
$expire = Yii::$app->params['user.passwordResetTokenExpire'];
$parts = explode('_', $token);
$timestamp = (int) end($parts);
return $timestamp + $expire >= time();
}
/**
* @inheritdoc
*/
public function getId()
{
return $this->getPrimaryKey();
}
/**
* @inheritdoc
*/
public function getAuthKey()
{
return $this->auth_key;
}
/**
* @inheritdoc
*/
public function validateAuthKey($authKey)
{
return $this->getAuthKey() === $authKey;
}
/**
* Validates password
*
* @param string $password password to validate
* @return boolean if password provided is valid for current user
*/
public function validatePassword($password)
{
return Yii::$app->security->validatePassword($password, $this->password_hash);
}
/**
* Generates password hash from password and sets it to the model
*
* @param string $password
*/
public function setPassword($password)
{
$this->password_hash = Yii::$app->security->generatePasswordHash($password);
}
/**
* Generates "remember me" authentication key
*/
public function generateAuthKey()
{
$this->auth_key = Yii::$app->security->generateRandomString();
}
/**
* Generates new password reset token
*/
public function generatePasswordResetToken()
{
$this->password_reset_token = Yii::$app->security->generateRandomString() . '_' . time();
}
/**
* Removes password reset token
*/
public function removePasswordResetToken()
{
$this->password_reset_token = null;
}
}
PHP學習三、使用migrate 為后如初使化一個登陸帳號
PHP學習1、console\controllers創建InitController.php
PHP學習
/**
*
* @author chan <maclechan@qq.com>
*/
namespace console\controllers;
use backend\models\Admin ;
class InitController extends \yii\console\Controller
{
/**
* Create init user
*/
public function actionAdmin()
{
echo "創建一個新用戶 ...\n"; // 提示當前操作
$username = $this->prompt('User Name:'); // 接收用戶名
$email = $this->prompt('Email:'); // 接收Email
$password = $this->prompt('Password:'); // 接收暗碼
$model = new AgAdmin(); // 創建一個新用戶
$model->username = $username; // 完成賦值
$model->email = $email;
$model->password = $password;
if (!$model->save()) // 保存新的用戶
{
foreach ($model->getErrors() as $error) // 如果保存失敗,說明有錯誤,那就輸出錯誤信息.
{
foreach ($error as $e)
{
echo "$e\n";
}
}
return 1; // 命令行返回1表示有異常
}
return 0; // 返回0表示一切OK
}
}
PHP學習2、使用命令:
PHP學習在項目根目下,右鍵選擇User composer here(前提是安裝了全局的composer),
yii init/admin
PHP學習
PHP學習到此,打開數據表看下,己經有了數據.
PHP學習四、后臺登陸驗證
PHP學習1、backend\controllers\SiteController.php 里actionLogin辦法不用變
PHP學習2、把common\models\LoginForm.php復制到backend\models只要把LoginForm.php里面的辦法getUser()修改一個單詞即可,如下
PHP學習
public function getUser()
{
if ($this->_user === false) {
$this->_user = Admin::findByUsername($this->username);
}
return $this->_user;
}
PHP學習3、backend\config\main.php 只要修改
PHP學習
'user' => [
'identityClass' => 'backend\models\Admin',
'enableAutoLogin' => true,
],
PHP學習此外,在作修改時,請注意下命令空不要搞亂了.
PHP學習到此,結束.
PHP學習更多關于Yii相關內容感興趣的讀者可查看本站專題:《Yii框架入門及常用技巧總結》、《php優秀開發框架總結》、《smarty模板入門基礎教程》、《php日期與時間用法總結》、《php面向對象程序設計入門教程》、《php字符串(string)用法總結》、《php+mysql數據庫操作入門教程》及《php常見數據庫操作技巧匯總》
PHP學習希望本文所述對大家基于Yii框架的PHP程序設計有所贊助.
維易PHP培訓學院每天發布《PHP實戰:YII Framework框架使用YIIC快速創建YII應用之migrate用法實例詳解》等實戰技能,PHP、MYSQL、LINUX、APP、JS,CSS全面培養人才。
轉載請注明本頁網址:
http://www.snjht.com/jiaocheng/7362.html