嗨,我有一个工作门户网站页面,我将在其中显示作业列表,用户可以通过单击" apply现在"按钮申请发布的作业,将是他们的位置。需要填写他们的详细信息等。表格包含他们申请的职位,姓名,电子邮件,手机号码等...单击"应用"按钮时,将自动获取位置。在这里,我需要在下拉列表中显示全部,然后在下拉列表中显示作业列表,而我选择的应该是文本框中的第一个。
显示AppPlyNow按钮(视图):
<div class="applynow"><a href="<?php echo base_url();?>career/apply/<?php echo $r->jobs_id;?>" class="applyforjob">Apply Now</a></div>
<div class="moreinfo" id="music" >More Info</div>
控制器(职业/申请):
function apply($job_id)
{
$this->load->model('career_model');
$this->load->model('apply_model');
$data['joblist']=$this->apply_model->jobs_dropdown();
$data['records2']= $this->career_model->getcareerdatas($job_id);
$data['mainpage']='apply';
$this->load->view('templates/template',$data);
}
查看:
<form name="applynow" id="applynow" enctype="multipart/form-data" method="post" action="<?php echo base_url();?>apply/applynow" >
<div class ="applyus">
<?php if(isset($records2) && is_array($records2)):?>
<?php foreach ($records2 as $r):?>
<div class="applyposition ">
<input type="text" class="form-control positionapplied" name="positionapplied" id="positionapplied " value="<?php echo $r->job_name ;?>" readonly>
<?php
$joblist['']='--Select Category --';
$jobs_id="id='jobs_id' ";
echo form_dropdown('jobs_id',$joblist,$r->jobs_id,$jobs_id);
?>
</div>
<?php endforeach;endif;?>
<button type="submit" class="btn btn-success successss" id="sub" >Submit</button>
<a class="button cancel cancels" href="<?php echo site_url()?>career">Cancel</a>
<input type="reset" value="Reset" class="reset">
</div>
</form>
模型(apply_model):
function jobs_dropdown()
{
$this->table = 'jobs_list';
$this->where('status',1);
$joblist=$this->dropdown('jobs_id','job_name');
return $joblist;
}
在error_log中获取此错误:
PHP Fatal error: Call to undefined method Apply_model::where() in /home/website/public_html/staging/application/models/apply_model.php on line 99
来自Codeigniter文档:
<?php
class News_model extends CI_Model {
public function __construct()
{
$this->load->database();
}
}
这将使数据库类可通过$ this-> db对象提供。
因此,在模型中,您访问where()子句,例如:
$this->db->where($blahblah);
在此处查看他们的教程:https://www.codeigniter.com/userguide3/tutorial/news_section.html
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Apply_model extends CI_Model
{
function __construct()
{
// Call the Model constructor
parent::__construct();
$this->db = $this->load->database('default', true);
}
function jobs_dropdown()
{
$this->table = 'jobs_list';
$this->where('status',1);
$joblist=$this->dropdown('jobs_id','job_name');
return $joblist;
}
}
在应用程序/模型文件夹中保存为apply_model.php