Fill out the fields you want in your form, with field types, database type, and your validation rules and FormIgniter will output the code...
Saturday, March 28, 2015
Friday, March 20, 2015
Datatype supported by mysql
mysql datatypes are mainly divided into 3 different types: string number date & time string datatypes char varchar text blob...
mysql date and time functions with example
By using these mysql functions you can query the current time, current date, current time_stamp The Below is the examples: curdate() or ...
cudate(), mysql query to get current date
curdate() or current_date() :- To get the current date information of server. SELECT current_date(); Output: current_date 20...
concat in mysql
Concat in mysql, by using this function we can join two or more than two string values.. mysql>SELECT concat("scott","s...
Ajax File image upload with out refresh
<!doctype html> <head> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7/jquery.js"></script...
Wednesday, March 18, 2015
SQL query to get the last 7days or week data
SELECT * FROM tablename WHERE time_stamp BETWEEN CURDATE()-INTERVAL 1 WEEK AND CURDATE() ORDER BY `time_stamp` DESC
Tuesday, March 17, 2015
Javascript Beautifier
http://www.jspretty.com/ http://jsbeautifier.org/
Saturday, March 14, 2015
Text to ASCII Generator
http://patorjk.com/software/taag/#p=display&f=Doh&t=Manikanta%20Kunisetty
Friday, March 13, 2015
Facebook style time ago function in codeigniter
time_helper.php - save in the helpers folder <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed')...
PHP Data and time comparision
function sqlArray($date, $trim=true) { $result = array(); $result['day'] = ($trim==true) ? ltrim(substr($date,8,2),'0...
Tuesday, March 10, 2015
query strings in codeigniter
$this->input->post('name'); $this->input->get('name'); $this->input->get_post('name');
Thursday, March 5, 2015
Codeigniter upload image and store the path in database
<?php class Profile extends CI_Controller{ function __construct(){ parent::__construct(); $this->load->model('profile_...
Wednesday, March 4, 2015
Codeigniter Example to update profile
Profile_view.php --------------- <?php echo form_open('profile/update_data')?>" Firstname: <input name="fir...
Bootstrap Screen methods
/* Custom, iPhone Retina */ @media only screen and (min-width : 320px) {} /* Extra Small Devices, Phones */ @media only screen and (mi...
Tuesday, March 3, 2015
Codeigniter function to check user exists or not
public function user_exists($user_id) { $this->db->where('user_id', $user_id); $query = $this->db->get('s...
CodeIgniter Username available or not..
Model Page ( My_model.php ) <?php class My_model extends CI_Model{ function check(){ $v=$this->input->post('username...
Codeigniter username is mobile number or email
function validate_credentials(){ if(is_numeric($this->input->post('username'))) { $this->form_validation->set...
Monday, March 2, 2015
How can I access the MySQL command line with XAMPP for Windows?
Open the XAMPP control panel. Click Shell . Type mysql --user=your_user_name --password=your_password .
Codeigniter data of birth generation and validation
User friendly date with Codeigniter and MySQL When we deal with the date in Codeigniter and MySQL, there is a little problem that MySQ...
Subscribe to:
Posts (Atom)