How to use Codeigniter captcha plug in Part 2
Category:Plugin::Tutorials::captcha
In the previous post I wrote a basic method how to use captcha plug-in with Codeigniter. Today I am going to write a simple but practical newsletter subsciption page using captcha. We will use CI's form_validation class.
Please read the previous post to customize it. You need to create a folder called captcha as the same level as system. We need two tables, captcha and subscribers.
CREATE TABLE IF NOT EXISTS captcha (
captcha_id bigint(13) unsigned NOT NULL AUTO_INCREMENT,
captcha_time int(10) unsigned NOT NULL,
ip_address varchar(16) NOT NULL DEFAULT '0',
word varchar(20) NOT NULL,
PRIMARY KEY (captcha_id),
KEY word (word)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
CREATE TABLE IF NOT EXISTS subscribers (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL,
email varchar(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
config/autoload.php
$autoload['libraries'] = array('database', 'session');
$autoload['helper'] = array('url');
You can autoload library(form_validation) here as well.
The code is from a Codeigniter book Professional CodeIgniter by Thomas Myer.
models/msubscribers.php
<?php
class MSubscribers extends Model{
function MSubscribers(){
parent::Model();
}
function getSubscriber($id){ $this->db->where('id',id_clean($id)); $this->db->limit(1); $Q = $this->db->getwhere('subscribers'); if ($Q->num_rows() > 0){ $data = $Q->row_array(); }
$Q->free_result();
return $data;
}
function getAllSubscribers(){
$data = array();
$Q = $this->db->get('subscribers');
if ($Q->num_rows() > 0){
foreach ($Q->result_array() as $row){
$data[] = $row;
}
}
$Q->free_result();
return $data;
}
function createSubscriber(){ $this->db->where('email', $_POST['email']); $this->db->from('subscribers'); $ct = $this->db->count_all_results();
if ($ct == 0){
$data = array(
'name' => db_clean($_POST['name']),
'email' => db_clean($_POST['email'])
);
$this->db->insert('subscribers', $data);
}
}
function updateSubscriber(){ $data = array( 'name' => db_clean($_POST['name']), 'email' => db_clean($_POST['email'])
);
$this->db->where('id', id_clean($_POST['id']));
$this->db->update('subscribers', $data);
}
function removeSubscriber($id){ $this->db->where('id', id_clean($id)); $this->db->delete('subscribers');
}
}//end class ?>
controllers/welcome.php
<?php
class Welcome extends Controller {
function __construct(){
parent::Controller();
$this->load->model('MSubscribers');
$this->load->helper(array('form', 'url'));
$this->load->library('form_validation');
session_start();
$this->output->enable_profiler(FALSE);
}
function index(){
$captcha_result = '';
$data['cap_img'] = $this -> _make_captcha();
$this->load->view('subscribe', $data);
}
function subscribe(){
/**
* form_validation
/
$this->form_validation->set_rules('name', 'Name', 'required');
$this->form_validation->set_rules('email', 'Email', 'required|valid_email');
$this->form_validation->set_rules('captcha', 'Captcha', 'required');
if ( $this -> _check_capthca() ) {
if ($this->form_validation->run() == FALSE)
{
$this->session->set_flashdata('subscribe_msg', 'All fields are required . Please try again!');
redirect('welcome/index');
}
else
{
$this->MSubscribers->createSubscriber();
$this->session->set_flashdata('subscribe_msg', 'Thanks for subscribing!');
redirect('welcome/index','refresh');
}
}else {
$this->session->set_flashdata('subscribe_msg', 'Enter captcha . Please try again!');
redirect('welcome/index');
}
}
/*
- For captcha
-
*/
function _make_captcha()
{
$this -> load -> plugin( 'captcha' );
$vals = array(
'img_path' => './captcha/', // PATH for captcha ( *Must mkdir (htdocs)/captcha )
'img_url' => 'captcha/', // URL for captcha img
'img_width' => 200, // width
'img_height' => 60, // height
// 'font_path' => '../system/fonts/2.ttf',
'expiration' => 7200 ,
);
// Create captcha
$cap = create_captcha( $vals );
// Write to DB
if ( $cap ) {
$data = array(
'captcha_id' => '',
'captcha_time' => $cap['time'],
'ip_address' => $this -> input -> ip_address(),
'word' => $cap['word'] ,
);
$query = $this -> db -> insert_string( 'captcha', $data );
$this -> db -> query( $query );
}else {
return "Umm captcha not work" ;
}
return $cap['image'] ;
}
function _check_capthca()
{
// Delete old data ( 2hours)
$expiration = time()-7200 ;
$sql = " DELETE FROM captcha WHERE captcha_time < ? ";
$binds = array($expiration);
$query = $this->db->query($sql, $binds);
//checking input
$sql = "SELECT COUNT(*) AS count FROM captcha WHERE word = ? AND ip_address = ? AND captcha_time > ?";
$binds = array($_POST['captcha'], $this->input->ip_address(), $expiration);
$query = $this->db->query($sql, $binds);
$row = $query->row();
if ( $row -> count > 0 )
{
return true;
}
return false;
}
/**
- End of captcha
*/
}//end controller class
?>
views/subscribe.php
<html >
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Using captcha with Codeigniter</title>
<base href="<?=base_url();?>">
</head>
<body>
<?php
if ($this->session->flashdata('subscribe_msg')){
echo "
";
echo $this->session->flashdata('subscribe_msg');
echo "";
}
?>
<?php echo form_open("welcome/subscribe"); ?>
<?php echo form_fieldset('Subscribe To Our Newsletter'); ?>
<input type="text" name="name" id="name" value="<?php echo set_value('name'); ?>" size="40" />
<input type="text" name="email" id="email" value="<?php echo set_value('email'); ?>" size="40" />
<?php echo "$cap_img
" ;?>
<input type="text" name="captcha" value="" size="40" />
<input type="submit" value="Subscribe" /></div>
<?php echo form_fieldset_close(); ?>
</form>
</body>
</html>
http://www.okadadesign.no/blog/?p=384
