PHP Codeigniter插入不能插入
PHP Codeigniter插入不能插入
提问于 2018-07-28 04:26:27
我是PHP的新手，正在按照教程将数据插入数据库。语法运行正常，只是在表单中键入数据不会向数据库中插入任何数据。我已经创建了表，并检查了插入查询在MySQL中是否正常工作。
控制器: studCredController
class studCredController extends CI_Controller {
public function __construct()
{
parent::__construct();
$this->load->database();
//load Model
$this->load->model('studCredModeller');
}
//Register students
public function registerStud() {
//load registration view form
$this->load->view('Home');
//Check the submit button
if($this->input->post('save'))
{
$username = $this -> input -> post('username');
$email = $this -> input -> post('email');
$password = $this -> input -> post('password');
$admin_no = $this -> input -> post('adminNo');
$phone = $this -> input -> post('phone');
//call method of studCredModeller and pass variable as parameter
$this -> studCredModeller -> saveRecords($username, $email, $password, $admin_no, $phone);
echo "Records Saved Successfully";
}
}
}模型: studCredModeller
class studCredModeller extends CI_Model
{
public function saveRecords($username, $email, $password, $adminNo, $phone);
{
$query="insert into locka.stud_login values('$username','$email','$password','$admin_no','$phone', ' ')";
$this->db->query($query);
}
}视图:主页
<form method="post">
<div class="row">
<div class="col-xs-6 col-sm-6 col-md-6">
<div class="form-group">
<label>Username</label>
<input type="text" class="form-control" name="username" placeholder="Username">
</div>
</div>
<div class="col-xs-6 col-sm-6 col-md-6">
<div class="form-group">
<label>Email</label>
<input type="email" class="form-control" name="email" placeholder="Email">
</div>
</div>
</div>
<div class="row">
<div class="col-xs-6 col-sm-6 col-md-6">
<div class="form-group">
<label>Password</label>
<input type="password" class="form-control" name="password" placeholder="Password">
</div>
</div>
<div class="col-xs-6 col-sm-6 col-md-6">
<div class="form-group">
<label>Admin No</label>
<input type="text" class="form-control" name="adminNo" placeholder="AdminNo">
</div>
</div>
<div class="col-xs-6 col-sm-6 col-md-6">
<div class="form-group">
<label>Phone number</label>
<input type="number" class="form-control" name="phone" placeholder="Phone">
</div>
</div>
</div>
<input type="submit" value="Submit" name="save" class="btn btn-skin btn-block btn-lg">
<p class="lead-footer">* We'll contact you by phone & email later</p>
</form>感谢您查看代码。我已经坚持了几天，尝试了不同的教程。
回答 1
Stack Overflow用户
回答已采纳
发布于 2018-07-28 06:14:53
如果您使用Query Builder，尤其是insert()方法，您会发现这更容易做到。
修改控制器中对提交做出反应的部分
//Check the submit button
if($this->input->post('save'))
{
$data['username'] = $this->input->post('username');
$data['email'] = $this->input->post('email');
$data['password'] = $this->input->post('password');
$data['admin_no'] = $this->input->post('adminNo');
$data['phone'] = $this->input->post('phone');
//call method of studCredModeller and pass variable as parameter
$result = $this->studCredModeller->saveRecords($data);
echo $result === TRUE ? "Records Saved Successfully" : "Records did not save";
}修改模型方法
public function saveRecords($data);
{
//returns true if insert works, otherwise false
return $this->db->insert('stud_login', $data);
}页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/51565090
复制相关文章
相似问题