PHP網站安裝實現程序

2024-05-04 21:48:23

字體：大中小

來源：轉載

供稿：網友

網站安裝過程我們需要幾處非常簡單,一個是我們要讓用戶輸入用戶名密碼然后連接數據庫之后再把我們以前準備好.sql文件利用php讀取并執行,最后簡單配置一下站點,這樣一個完整的php網站安裝過程就完美的搞定了.

這次順便做了一個install.php才發現難度其實并不大.還是文件寫入操作而已.安裝其實主要操作的還是數據庫里的內容.先來看看文件里怎么寫:還是用的Codeigiter,對于使用其他框架或者手寫而言,僅思路可參考,用了挺多CI自帶的helper或者是library的,代碼如下:

$content = "<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');n";

$content .= '$active_group'. "= 'default';n";

$content .= '$active_record'." = TRUE;n";

$content .= '$db'."['default']['hostname'] = '".$this->input->post('hostname')."';n";

$content .= '$db'."['default']['username'] = '".$this->input->post('rootname')."';n";

$content .= '$db'."['default']['password'] = '".$this->input->post('pass')."';n";

$content .= '$db'."['default']['database'] = '".$this->input->post('book')."';n";//開源代碼Vevb.com

$content .= '$db'."['default']['dbdriver'] = 'mysql';n";

$content .= '$db'."['default']['dbprefix'] = '';n";

$content .= '$db'."['default']['pconnect'] = TRUE;n";

$content .= '$db'."['default']['db_debug'] = TRUE;n";

$content .= '$db'."['default']['cache_on'] = FALSE;n";

$content .= '$db'."['default']['cachedir'] = '';n";

$content .= '$db'."['default']['char_set'] = 'utf8';n";

$content .= '$db'."['default']['dbcollat'] = 'utf8_general_ci';n";

$content .= '$db'."['default']['swap_pre'] = '';n";

$content .= '$db'."['default']['autoinit'] = TRUE;n";

$content .= '$db'."['default']['stricton'] = FALSE;";

在文件里用n來換行,因為里面包括了PHP的代碼,這導致了我們只能用雙引號避免沖突,否則的話就得用了,感覺工作量更大,針對$db,直接顯示必須要用單引號,于是就出現了這個.

寫入文件之后,接著我們需要做的是執行一系列安裝操作,也就是CREATE TABLE,以及創建一個新用戶用于登陸,在model里,我這么寫,代碼如下:

function install() {

if (mysql_num_rows(mysql_query("SHOW TABLES LIKE 'pr_category'")) == 0)

$this->db->query("CREATE TABLE pr_category(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, category VARCHAR(100) NOT NULL UNIQUE, deadline INT NOT NULL)");

if (mysql_num_rows(mysql_query("SHOW TABLES LIKE 'pr_college'")) == 0)

$this->db->query("CREATE TABLE pr_college(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) NOT NULL UNIQUE)");

if (mysql_num_rows(mysql_query("SHOW TABLES LIKE 'pr_level'")) == 0)

$this->db->query("CREATE TABLE pr_level(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, level INT NOT NULL, name VARCHAR(20) NOT NULL)");

if (mysql_num_rows(mysql_query("SHOW TABLES LIKE 'pr_rates'")) == 0)

$this->db->query("CREATE TABLE pr_rates(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, pid INT NOT NULL, ip VARCHAR(40) NOT NULL, category INT NOT NULL)");

if (mysql_num_rows(mysql_query("SHOW TABLES LIKE 'pr_users'")) == 0)

$this->db->query("CREATE TABLE pr_users(uid INT NOT NULL PRIMARY KEY AUTO_INCREMENT, username VARCHAR(45) NOT NULL UNIQUE, password VARCHAR(50) NOT NULL, level INT NOT NULL )");

if (mysql_num_rows(mysql_query("SHOW TABLES LIKE 'pr_works'")) == 0)

$this->db->query("CREATE TABLE pr_works(pid INT NOT NULL PRIMARY KEY AUTO_INCREMENT, title VARCHAR(100) NOT NULL, content TEXT, realname VARCHAR(20) NOT NULL, studentnum VARCHAR(20) NOT NULL, college INT NOT NULL, filename TEXT NOT NULL, category INT NOT NULL)");

$query1 = $this->db->get_where('pr_level',array('level' => 1, 'name' => '普通用戶'));

$query2 = $this->db->get_where('pr_level',array('level' => 5, 'name' => '管理員'));

$query3 = $this->db->get_where('pr_level',array('level' => 99, 'name' => '超級管理員'));

if ($query1->num_rows() == 0)

$this->db->query("INSERT INTO pr_level(level, name) VALUES (1, '普通用戶')");

if ($query2->num_rows() == 0)

$this->db->query("INSERT INTO pr_level(level, name) VALUES (5, '管理員')");

if ($query3->num_rows() == 0)

$this->db->query("INSERT INTO pr_level(level, name) VALUES (99, '超級管理員')");

$this->username = $this->input->post('username');

$this->password = $this->input->post('password');

$this->level = 99;

$query4 = $this->db->get_where('pr_users',array('username' => $this->input->post('username')));

if ($query4->num_rows() == 0) {

$this->db->insert('pr_users', $this);

return TRUE;

} else {

return FALSE;

}

}

其實這么寫查詢量很大效率又低,不過這有效的避免了上一次安裝被打斷之后重新安裝遇到的麻煩,檢測是否已經創建了某個表,是否已經有新用戶了之類的,代碼如下:

mysql_num_rows(mysql_query("SHOW TABLES LIKE 'pr_category'"))

這句可以查詢數據庫中是否存在這個表,執行完如果順利的話,將install.php改個名字,代碼如下:

rename('application/controllers/install.php', 'application/controllers/install.lock');

在其他文件里加入檢測install.php是否存在,如果存在的話就跳轉到install.php,這樣就做好了簡單的安裝流程了,必須放在model前,否則會提示沒有數據庫而不會跳轉,代碼如下:

if (file_exists('application/controllers/install.php'))

redirect('install');

至于什么是否存在表之類的,因為CI會check而且優先級也高于我們自己寫的錯誤提示,所以這里就不加了,完整源碼(MVC),Controller代碼如下:

<?php

class Install extends CI_Controller {

function __construct() {

parent::__construct();

$this->load->helper('url');

$this->load->helper('file');

}

function index() {

$data['title'] = '安裝向導';

$this->load->helper('form');

$this->load->library('form_validation');

$this->form_validation->set_rules('hostname', '主機名', 'trim|required|xss_clean');

$this->form_validation->set_rules('rootname', '數據庫用戶名', 'trim|required|xss_clean');

$this->form_validation->set_rules('username', '用戶名', 'trim|required|xss_clean');

$this->form_validation->set_rules('password', '密碼', 'trim|required|xss_clean|md5');

$data['error'] = '';

if ($this->form_validation->run() == FALSE) {

$this->load->view('install', $data);

} else {

$config['hostname'] = $this->input->post('hostname');

$config['username'] = $this->input->post('rootname');

$config['password'] = $this->input->post('pass');

$config['database'] = $this->input->post('book');

$config['dbdriver'] = 'mysql';

$config['dbprefix'] = '';

$config['pconnect'] = TRUE;

$config['db_debug'] = TRUE;

$config['cache_on'] = FALSE;

$config['cachedir'] = '';

$config['char_set'] = 'utf8';

$config['dbcollat'] = 'utf8_general_ci';

$config['swap_pre'] = '';

$config['autoinit'] = TRUE;

$config['stricton'] = FALSE;

if ($this->load->database($config, TRUE)) {

$content = "<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');n";

$content .= '$active_group'. "= 'default';n";

$content .= '$active_record'." = TRUE;n";

$content .= '$db'."['default']['hostname'] = '".$this->input->post('hostname')."';n";

$content .= '$db'."['default']['username'] = '".$this->input->post('rootname')."';n";

$content .= '$db'."['default']['password'] = '".$this->input->post('pass')."';n";

$content .= '$db'."['default']['database'] = '".$this->input->post('book')."';n";

$content .= '$db'."['default']['dbdriver'] = 'mysql';n";

$content .= '$db'."['default']['dbprefix'] = '';n";

$content .= '$db'."['default']['pconnect'] = TRUE;n";

$content .= '$db'."['default']['db_debug'] = TRUE;n";

$content .= '$db'."['default']['cache_on'] = FALSE;n";

$content .= '$db'."['default']['cachedir'] = '';n";

$content .= '$db'."['default']['char_set'] = 'utf8';n";

$content .= '$db'."['default']['dbcollat'] = 'utf8_general_ci';n";

$content .= '$db'."['default']['swap_pre'] = '';n";

$content .= '$db'."['default']['autoinit'] = TRUE;n";

$content .= '$db'."['default']['stricton'] = FALSE;";

if (write_file('application/config/database.php', $content)) {

$this->load->model('install_model');

if ($this->install_model->install()) {

rename('application/controllers/install.php', 'application/controllers/install.lock');

$this->load->library('session');

if (!emptyempty($this->session->userdata['login'])) {

$this->session->sess_destroy(); // destroy the session

}

redirect('poster_admin/login', 'refresh');

} else {

$data['error'] = '超級管理員用戶名已存在';

$this->load->view('install', $data);

}

} else {

$data['error'] = '安裝失敗，無法寫入文件';

$this->load->view('install', $data);

}

}

}

}

}

?>

Model:

class Install_model extends CI_Model {

function __construct() {

parent::__construct();

$this->load->database();

$this->load->dbforge();

}

function install() {

if (mysql_num_rows(mysql_query("SHOW TABLES LIKE 'pr_category'")) == 0)

$this->db->query("CREATE TABLE pr_category(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, category VARCHAR(100) NOT NULL UNIQUE, deadline INT NOT NULL)");

if (mysql_num_rows(mysql_query("SHOW TABLES LIKE 'pr_college'")) == 0)

$this->db->query("CREATE TABLE pr_college(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) NOT NULL UNIQUE)");

if (mysql_num_rows(mysql_query("SHOW TABLES LIKE 'pr_level'")) == 0)

$this->db->query("CREATE TABLE pr_level(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, level INT NOT NULL, name VARCHAR(20) NOT NULL)");

if (mysql_num_rows(mysql_query("SHOW TABLES LIKE 'pr_rates'")) == 0)

$this->db->query("CREATE TABLE pr_rates(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, pid INT NOT NULL, ip VARCHAR(40) NOT NULL, category INT NOT NULL)");

if (mysql_num_rows(mysql_query("SHOW TABLES LIKE 'pr_users'")) == 0)

$this->db->query("CREATE TABLE pr_users(uid INT NOT NULL PRIMARY KEY AUTO_INCREMENT, username VARCHAR(45) NOT NULL UNIQUE, password VARCHAR(50) NOT NULL, level INT NOT NULL )");

if (mysql_num_rows(mysql_query("SHOW TABLES LIKE 'pr_works'")) == 0)

$this->db->query("CREATE TABLE pr_works(pid INT NOT NULL PRIMARY KEY AUTO_INCREMENT, title VARCHAR(100) NOT NULL, content TEXT, realname VARCHAR(20) NOT NULL, studentnum VARCHAR(20) NOT NULL, college INT NOT NULL, filename TEXT NOT NULL, category INT NOT NULL)");

$query1 = $this->db->get_where('pr_level',array('level' => 1, 'name' => '普通用戶'));

$query2 = $this->db->get_where('pr_level',array('level' => 5, 'name' => '管理員'));

$query3 = $this->db->get_where('pr_level',array('level' => 99, 'name' => '超級管理員'));

if ($query1->num_rows() == 0)

$this->db->query("INSERT INTO pr_level(level, name) VALUES (1, '普通用戶')");

if ($query2->num_rows() == 0)

$this->db->query("INSERT INTO pr_level(level, name) VALUES (5, '管理員')");

if ($query3->num_rows() == 0)

$this->db->query("INSERT INTO pr_level(level, name) VALUES (99, '超級管理員')");

$this->username = $this->input->post('username');

$this->password = $this->input->post('password');

$this->level = 99;

$query4 = $this->db->get_where('pr_users',array('username' => $this->input->post('username')));

if ($query4->num_rows() == 0) {

$this->db->insert('pr_users', $this);

return TRUE;

} else {

return FALSE;

}

}

}

View:

<!DOCTYPE html>

<html lang="Zh-CN">

<html>

<head>

<meta charset="utf-8"/>

<meta name="viewport" content="width=device-width, initial-scale=1.0"/>

<link rel="stylesheet" href="<?php echo base_url() . 'css/bootstrap.css' ?>">

<link rel="stylesheet" href="<?php echo base_url() . 'css/login.css' ?>">

<link rel="icon" type="image/x-icon" href="<?php echo base_url() . 'favicon.ico' ?>"/>

<script src="<?php echo base_url() . 'js/jquery-1.9.0.js' ?>"></script>

<script src="<?php echo base_url() . 'js/bootstrap.js' ?>"></script>

<title><?php echo $title; ?> - SMU Poster</title>

</head>

<body>

<div class="container">

<div class="row">

<div class="col-sm-4 col-sm-offset-4">

<div <?php $err = validation_errors(); echo !(empty($error) && empty($err)) ? 'class="alert alert-danger text-center"' : '' ?>><?php echo validation_errors(); ?>

<?php echo $error ?></div>

<?php echo form_open('install', array('class'=>'form-horizontal','role'=>'form')); ?>

<div class="col-sm-sm-4 col-sm-offset-4"><h2>安裝向導</h2></div>

<div class="form-group">

<div class="col-sm-9 col-sm-offset-2">

<div class="input-group">

<span class="input-group-addon"><span class="glyphicon glyphicon-cloud"></span></span>

<input type="text" class="form-control" onMouseOver="$(this).tooltip('show')" data-toggle="tooltip" title="一般為localhost" id="hostname" name="hostname" placeholder="主機名" value="localhost"/>

</div>

</div>

</div>

<div class="form-group">

<div class="col-sm-9 col-sm-offset-2">

<div class="input-group">

<span class="input-group-addon"><span class="glyphicon glyphicon-book"></span></span>

<input type="text" class="form-control" onMouseOver="$(this).tooltip('show')" data-toggle="tooltip" title="數據庫名如poster，請自行創建" id="book" name="book" placeholder="數據庫名"/>

</div>

</div>

</div>

<div class="form-group">

<div class="col-sm-9 col-sm-offset-2">

<div class="input-group">

<span class="input-group-addon"><span class="glyphicon glyphicon-user"></span></span>

<input type="text" class="form-control" onMouseOver="$(this).tooltip('show')" data-toggle="tooltip" title="連接數據庫的賬號" id="rootname" name="rootname" placeholder="數據庫賬號"/>

</div>

</div>

</div>

<div class="form-group">

<div class="col-sm-9 col-sm-offset-2">

<div class="input-group">

<span class="input-group-addon"><span class="glyphicon glyphicon-lock"></span></span>

<input type="password" class="form-control" onMouseOver="$(this).tooltip('show')" data-toggle="tooltip" title="連接數據庫的密碼" id="pass" name="pass" placeholder="數據庫密碼"/>

</div>

</div>

</div>

<div class="form-group">

<div class="col-sm-9 col-sm-offset-2">

<div class="input-group">

<span class="input-group-addon"><span class="glyphicon glyphicon-user"></span></span>

<input type="text" onMouseOver="$(this).tooltip('show')" data-toggle="tooltip" title="注冊一個后臺超級管理員賬號" class="form-control" id="username" name="username" placeholder="后臺登錄賬號"/>

</div>

</div>

</div>

<div class="form-group">

<div class="col-sm-9 col-sm-offset-2">

<div class="input-group">

<span class="input-group-addon"><span class="glyphicon glyphicon-lock"></span></span>

<input type="password" onMouseOver="$(this).tooltip('show')" data-toggle="tooltip" title="后臺超級管理員密碼" class="form-control" id="password" name="password" placeholder="后臺登陸密碼"/>

</div>

</div>

</div>

<div class="form-group">

<div class="col-sm-offset-3 col-sm-9">

<button type="submit" class="btn btn-default">開始安裝</button>

</div>

</div>

</form>

</div>

</div>

</div>

<div id="footer">

<div class="container">

<p class="text-center copyright text-muted">Designed By <a href="http://m.survivalescaperooms.com/">微軟技術俱樂部</a></p>

</div>

</div>

</body>

</html>