PHP - Date Of Birth Validation In Codeigniter

I need to add date of birth field to registration form and then save it to databse. I cannot figure out what might be best way of storing the date in the table. I could convert it to unix epoch time, or I could do YYYYMMDD.   Thoughts? What would be the easiest method of saving the DOB? I am not asking on how to do it, just the format. Thanks

Hi there,

I'm new to PHP so sorry if this is a really basic question.

How do i post date of birth collected from a form, into a database?

I have the fields in the form set up as 'day' 'month' 'year' all of which are drop-down boxes.

I tried doing it one way which i saw on a different website, but it didn't work. Here is what i tried: Code: [Select]
'$_POST[day] . - . $_POST[month]' . - . $_POST[year]',
More info: In the database table this information is going to, the "date of birth" field is set to "DATE" type. Don't know if that makes any difference

$username = $_POST['username'];
$password = $_POST['password'];
$month = $_POST['month'];
$day = $_POST['day'];
$year = $_POST['year'];

$query = mysql_query("INSERT INTO users VALUES ('','$username','$password','$month','$day','$year')
mysql_query($query);


The code above is a sample of what I have but what I want is to store an entire birthdate in ONE SQL cell. More like this...


$username = $_POST['username'];
$password = $_POST['password'];
$month = $_POST['month'];
$day = $_POST['day'];
$year = $_POST['year'];

$query = mysql_query("INSERT INTO users VALUES ('','$username','$password','$birthdate')
mysql_query($query);


How is this possible? Can I do this and actually use it efficiently in the future?

Since I didn't want to type it out myself I wrote a small Date of Birth drop down menu generator.

Now I'm wondering how I can make the code copy-able in a text area?

The script should be inserting all the code ready and finished into a textarea so you can copy and go.

How is it done?


Here's the script:


<?php
echo "<center>";
?>
<form action='' method='POST'>
<input type='submit' name='submit' />
</form>
<?php
$submit = $_POST['submit'];


if ($submit) {

echo "<form action='' method='POST'>";
echo "<select name='month'>";

for ($m = 01; $m <= 12; $m++) {

echo " <option value='" . $m . "'>" . $m . "</option> ";

}

echo "</select>";
echo "<select name='day'>";

for ($d = 01; $d <= 31; $d++) {

echo " <option value='" . $d . "'>" . $d . "</option> ";

}

echo "</select>";
echo "<select name='year'>";

for ($y = 1900; $y <= 2010; $y++) {

echo " <option value='" . $y . "'>" . $y . "</option> ";

}

echo "</select>";
echo "</form>";
echo "</center>";
}

?>

Im curently using below code to check so that the date is entered (DATE1 required field) I also have another date form (DATE2) but its not required, however i want the user IF he starts entering DATE2 - fill out the whole date and not just partial (month or day or year) can someone sugest how i can do that?

thank you.

Code: [Select]
if( empty($_POST['year'])){
header("Location:Messages.php?msg=18");
exit();
}
if( empty($_POST['day'])){
header("Location:Messages.php?msg=18");
exit();
}
if( empty($_POST['month'])){
header("Location:Messages.php?msg=18");
exit();
}

Hi,

Hi need help with pagination of my page where the advertiser is showing. here is my website. photoagahi.com

search.php controller looks like this:

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Search extends Application
{
public function __construct()
{
parent::__construct();
$this->load->model('meta_model');
$this->load->helper('url');
$this->load->model('category_model');
$this->load->model('advert_model');
$this->load->helper('Fdate');
$this->load->helper('form');
$this->load->library('table');
$this->load->helper('advert');
$this->load->library('form_validation');
$this->load->helper('security');
$this->config->add_to_item(KCI_LANG, 'search');
 
      
     $this->load->library('pagination');

 
      $config['base_url'] = base_url();
      $config['total_rows'] = '50';
      $config['per_page'] = '30';
      $config['full_tag_open'] = '<p>';
      $config['full_tag_close'] = '</p>';
      $config['last_link'] = 'Last';
      $config['uri_segment'] = '4';
   
     $this->pagination->initialize($config); 

}

/**
 * Returns the search with based on the requested county.
 * If the county was recently visited, the municipality and locality aren't updated.
 * 
 * The primary search is also made to determine the latest search.
 *
 * @param unknown_type $slug
 */
public function index($county, $target = ADVERT_TARGET_ALL_SLUG, $sort = null, $type = null, $category = null, $municipality = null, $text = null)
{

$county = $this->meta_model->county(xss_clean($county));
if(!$county)
redirect('');
$this->load_banner(array($county->county_id,BANNER_SECTION_SEARCH));
if(!get_county() || get_county()->county_id != $county->county_id)
set_county($county);

$this->form_validation->set_rules('text', lang('advert_freetext'), 'max_length[100]');

$adverts = array();
$count = array();
if($this->form_validation->run())
{
$url = array();
$url[] = $county->county_slug;
$url[] = $this->input->post('advert_target') ? $this->input->post('advert_target') : ADVERT_TARGET_ALL_SLUG;
$url[] = $this->input->post('advert_sort') ? $this->input->post('advert_sort') : ADVERT_SORT_TIME;
$url[] = $this->input->post('advert_type') ? implode('-',$this->input->post('advert_type')) : ADVERT_TYPE_SALE;
$url[] = $this->input->post('category_id') ? $this->input->post('category_id', true) : 0;
$url[] = $this->input->post('municipality_id') ? $this->input->post('municipality_id', true) : 0;

if($this->input->post('text'))
$url[] = urlencode($this->input->post('text', true));

$slug = '/'.implode('/', $url);
redirect($slug);
}
else 
{
$params = array();

//Convert to objects
if($type)
{
$type = explode('-', xss_clean($type));
if($type)
{
$params['advert_type'] = $type;

foreach($type as $t)
populate('advert_type['.$t.']', true);
}
}
else 
{
$params['advert_type'] = array(ADVERT_TYPE_SALE);
populate('advert_type['.ADVERT_TYPE_SALE.']', true);
}


if($category)
$category = $this->category_model->get(xss_clean($category));
populate('category_id', $category ? $category->category_id : null);
$params['category_id'] = $category ? $category->category_id : null;

if($municipality == ADVERT_CODE_ENTIRE_COUNTY)
{
$params['county_id'] = $county->county_id;
populate('municipality_id', ADVERT_CODE_ENTIRE_COUNTY);
}
else if($municipality == ADVERT_CODE_ENTIRE_COUNTRY)
populate('municipality_id', ADVERT_CODE_ENTIRE_COUNTRY);
else if($municipality)
{
$municipality = $this->meta_model->municipality(xss_clean($municipality));
if($municipality)
{
$params['municipality_id'] = $municipality->municipality_id;
populate('municipality_id', $municipality->municipality_id);
}
}
else 
$params['county_id'] = $county->county_id;

if($target && $target != ADVERT_TARGET_ALL_SLUG)
{
$target = $this->advert_model->slug_target(xss_clean($target));
if($target)
{
populate('advert_target',  $target->target_slug);
$params['advert_target'] = $target->target_id;
}
}
else 
populate('advert_target', ADVERT_TARGET_ALL_SLUG);

$params['advert_sort'] = $sort ? $sort : ADVERT_SORT_TIME;
populate('advert_sort', $params['advert_sort']);
$params['text'] = $text ? xss_clean($text) : null;
populate('text', $text ? xss_clean($text) : null);

$adverts = $this->advert_model->search($params, $count);
}

$months = months();
$advert_types = $this->advert_model->types();
$municipalities = $this->meta_model->municipalities($county);
$categories = $this->category_model->all();
$this->_view('search_view', array(
  'months' => $months,
  'municipalities' => $municipalities, 
  'categories'=>$categories,
  'county' => $county,
  'adverts' => $adverts,
  'advert_types'=>$advert_types,
  'count' => $count));
}

/**
 * Returns the municipalities as JSON for a specified county
 * This is used by the AJAX request on the search filter
 *
 */
public function municipalities()
{
$result = array();
$county_id = $this->input->post('id', true);

if($county_id == 0)
{
$result['message'] = lang('ar_county_not_choosen');
set_county(null);
}
else 
{
$county = $this->meta_model->county_by_id($county_id);

if(!$county)
{
$result['error'] = lang('ar_county_not_found');
}
else 
{
set_county($county);

$result['county_name'] = utf8_encode($county->county_name);

foreach($this->meta_model->municipalities_for_json($county) as $municipality)
$result['municipalities'][] = array_map('utf8_encode', $municipality);
}
}

echo json_encode($result);
die();
}

/**
 * Returns the localities as JSON for a specified municipality
 * This is used by the AJAX request on the search filter
 *
 */
public function localities()
{
$result = array();
$municipality_id = $this->input->post('id', true);

if($municipality_id == 0)
{
$result['message'] = lang('ar_municipality_not_choosen');
set_municipality(null);
}
else 
{
$municipality = $this->meta_model->municipality($municipality_id);

if(!$municipality)
{
$result['error'] = lang('ar_municipality_not_found');
}
else 
{
set_municipality($municipality);

$result['municipality_name'] = utf8_encode($municipality->municipality_name);

foreach($this->meta_model->localities_for_json($municipality) as $locality)
$result['localities'][] = array_map('utf8_encode', $locality);
}
}

echo json_encode($result);
die();
}

/**
 * Updates the session container with the 
 * latest requested locality. Used by 
 * the AJAX request in the search filter
 * 
 *
 */
public function locality_set()
{
$locality_id = $this->input->post('id', true);

if($locality_id == 0 || !is_numeric($locality_id))
set_locality(null);

$locality = $this->meta_model->locality($locality_id);

if(!$locality)
set_locality(null);
else 
set_locality($locality);
}

/**
 * Updates the session container with the 
 * latest requested category. Used by 
 * the AJAX request in the search filter
 * 
 *
 */
public function category_set()
{
$category_id = $this->input->post('id', true);

if($category_id == 0 || !is_numeric($category_id))
set_category(null);

$category = $this->category_model->get($category_id);

if(!$category)
set_category(null);
else 
set_category($category);
}

/**
 * Lodge search that returns the info as JSON.
 * Used by the AJAX request in the search filter.
 *
 */
public function process_search()
{
$text = utf8_decode($this->input->post('text', true));
$offset = utf8_decode($this->input->post('offset', true));

if(!is_numeric($offset))
$offset = 0;

$result = array();
$result_count = 0;
$lodges = $this->lodge_model->search($text, 10, $offset, true, $result_count);

$result['result_count'] = $result_count;

foreach($lodges as $lodge)
{
$tmp = array_map('utf8_encode', get_object_vars($lodge));

foreach($this->lodge_model->facilities($lodge) as $facility)
$tmp['facilities'][] = array_map('utf8_encode', get_object_vars($facility));

foreach($this->lodge_model->distances($lodge) as $distance)
$tmp['distances'][] = array_map('utf8_encode', get_object_vars($distance));

foreach($this->lodge_model->prices($lodge) as $price)
$tmp['prices'][] = array_map('utf8_encode', get_object_vars($price));

$image = $this->lodge_model->image($lodge);
if($image)
$tmp['image'] = array_map('utf8_encode', get_object_vars($image));

$result['lodges'][] = $tmp;
}

echo json_encode($result);
}

}

and the model Meta_model:

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');


class Meta_model extends KCI_Model
{
public function counties_with_coordinates()
{
$this->db->join(TBL_COUNTY_COORDINATE, TBL_COUNTY_COORDINATE.'.county_id = '.TBL_COUNTY.'.county_id');
$this->db->order_by('map_index', 'ASC');
return $this->db->get(TBL_COUNTY)->result();
}

public function county($slug)
{
if(!$slug)
return false;

$this->db->where('county_slug', $slug);

$this->db->join(TBL_COUNTY_COORDINATE, TBL_COUNTY_COORDINATE.'.county_id = '.TBL_COUNTY.'.county_id');
return $this->db->get(TBL_COUNTY, 1)->row();

}
public function county_by_id($id)
{
$this->db->where('county_id', $id);
return $this->db->get(TBL_COUNTY, 1)->row();
}

public function county_by_lodge($lodge)
{
$this->db->where('lodge_id', $lodge->lodge_id);
$this->db->join(TBL_LOCALITY, TBL_LOCALITY.'.locality_id = '.TBL_LODGE.'.locality_id');
$this->db->join(TBL_MUNICIPALITY, TBL_MUNICIPALITY.'.municipality_id = '.TBL_LOCALITY.'.municipality_id');
$this->db->join(TBL_COUNTY, TBL_COUNTY.'.county_id = '.TBL_MUNICIPALITY.'.county_id');
$this->db->join(TBL_COUNTY_COORDINATE, TBL_COUNTY_COORDINATE.'.county_id = '.TBL_COUNTY.'.county_id');
return $this->db->get(TBL_LODGE, 1)->row();
}

public function municipality_by_lodge($lodge)
{
$this->db->where('lodge_id', $lodge->lodge_id);
$this->db->join(TBL_LOCALITY, TBL_LOCALITY.'.locality_id = '.TBL_LODGE.'.locality_id');
$this->db->join(TBL_MUNICIPALITY, TBL_MUNICIPALITY.'.municipality_id = '.TBL_LOCALITY.'.municipality_id');
return $this->db->get(TBL_LODGE, 1)->row();
}

public function locality_by_lodge($lodge)
{
$this->db->where('lodge_id', $lodge->lodge_id);
$this->db->join(TBL_LOCALITY, TBL_LOCALITY.'.locality_id = '.TBL_LODGE.'.locality_id');
return $this->db->get(TBL_LODGE, 1)->row();
}

public function municipalities_for_json($county = null)
{
if($county)
$this->db->where('county_id', $county->county_id);

$this->db->select('municipality_id, municipality_name');
$this->db->order_by('municipality_name', 'ASC');

return $this->db->get(TBL_MUNICIPALITY)->result_array();
}

public function municipalities($county = null)
{
if(is_numeric($county))
$this->db->where('county_id', $county);
elseif($county)
$this->db->where('county_id', $county->county_id);

$this->db->order_by('municipality_name', 'ASC');

return $this->db->get(TBL_MUNICIPALITY)->result();
}

public function municipality($id)
{
$this->db->where('municipality_id', $id);
return $this->db->get(TBL_MUNICIPALITY, 1)->row();
}

public function localities_for_json($municipality = null)
{
if($municipality)
$this->db->where('municipality_id', $municipality->municipality_id);

$this->db->where('locality_type', 'T');
$this->db->select('locality_id, locality_name');
$this->db->order_by('locality_name', 'ASC');

return $this->db->get(TBL_LOCALITY)->result_array();
}

public function localities($municipality = null)
{
if($municipality)
$this->db->where('municipality_id', $municipality->municipality_id);

$this->db->where('locality_type', 'T');
$this->db->order_by('locality_name', 'ASC');

return $this->db->get(TBL_LOCALITY)->result();
}

public function locality($id)
{
$this->db->where('locality_id', $id);
$this->db->where('locality_type', 'T');
$this->db->order_by('locality_name', 'ASC');

return $this->db->get(TBL_LOCALITY, 1)->row();
}

public function locality_parameters_by_municipality($municipality)
{
$this->db->where('municipality_id', $municipality->municipality_id);
$this->db->select('locality_id');
$municipalities = $this->db->get(TBL_LOCALITY)->result();
$result = array();

if($municipalities)
foreach($municipalities as $municipality)
$result[] = $municipality->municipality_id;

return $result;
}
}

hello....   I am a  new bee to PHP...can any one please let me know...why OOPs PHP...what make difference...between procedural(Generic) PHP  and OOPs PHP...if possible provide me any referal links...   and i have gone through Codeigniter user guide....it was quite good...but can any one let me know how to develop an entire web-application...in Codeigniter....if possible provide me any referal links...     Thanks & Regards Shankaar

I have PHP code that generates a long list of Birth Years in a Drop-down list, and I want to make the control "sticky".

I know how to make something like this sticky - thanks to help from you guys...
Code: [Select]
<!-- Gender -->
<label for="gender">Gender:</label>
<select id="gender" name="gender">
<option value="">--</option>
<option value="F"<?php echo (isset($gender) && $gender == "F") ? 'selected="selected"' : ''; ?>>Female</option>
<option value="M"<?php echo (isset($gender) && $gender == "M") ? 'selected="selected"' : ''; ?>>Male</option>
</select>


But my Birth Year code is a little more complex and I'm racking me brain how to do it...
Code: [Select]
<!-- Birth Year -->
<label for="birthYear">Year Born:</label>
<select id="birthYear" name="birthYear">
<option value="">--</option>
<?php
// Display dates for Users between 18 and 100.
for($i = $newestYear; $i >= $oldestYear; $i--){
echo '<option value="' . $i . '">' . $i . '</option>';
}
?>
</select>

How do I make this second set of code "sticky"??   

Thanks,


Debbie

I'm a bit new to PHP and I'm getting my feet wet with mvc with code igniter. I'm having a bit of trouble with my view accessing a function from my controller. If anyone has seen CodeIgniter from Scratch Day 4, it's that tutorial - i've created an email newsletter signup.   In my my view (newsletter.php), my submit button is not working and isn't able to access a function from my controller (email.php). The inaccessible function is called function send(). Instead, I get a 404 error. I'll post the code from both the view and controller, but I highly suspect the error is contained within the view because my controller loads the view, but my view can't call a function from the controller. Any help you can provide would be greatly appreciated. Thanks.   Here's the code from my view (newsletter.php):   <html lang='en'>

Hi - My app is built with Codeigniter and so if I turn on CSRF on CI inside the config I get the token being created on my page - good.    But I have 1 page ( "shopping cart") which uses Scriptaculous Ajax.Updater function :  http://api.prototype...x/Ajax/Updater/   When I turn on CSRF my shopping cart page refuses to function in terms of updating the cart or deleting any items from the cart. These are both js functions.   I am really stuck - any help would be a God send. Thank You !!    Here is the code:    UpDate JS Function: 

function jsUpdateCart(){
  var parameter_string = '';
  allNodes = document.getElementsByClassName("process");
  for(i = 0; i < allNodes.length; i++) {
  	var tempid = allNodes[i].id;
    var temp = new Array;
    temp = tempid.split("_");
 	var real_id = temp[2];
 	var real_value = allNodes[i].value;
    parameter_string += real_id +':'+real_value+',';
  }

  var params = 'ids='+parameter_string;
  var ajax = new Ajax.Updater(
    'ajax_msg','http://localhost/mysite/index.php/welcome/ajax_cart', {method:'post',parameters:params,onComplete:showMessage}
    );

}

   

Hi all Its my first project in CodeIgniter and I tried to make it live from local   Issue is, In local server, site URI is running without index.php, but live it is giving error.   e.g http://localhost/ci_basic/site/about   folder name -  ci_basic Controller name - site Function name - about   In .htaccess file   RewriteEngine On
RewriteBase /ci_basic/   Now i uploaded the file in a folder named - chikabana ( folder in my root directory assigned to the chikabana.com )   In .htaccess file   RewriteEngine On
RewriteBase /chikabana/   I also changed the base url to - chikabana.com in config file and also removed index.php from config file.   But this URL not working - http://chikabana.com/site/about   this is working - http://chikabana.com....php/site/about       Also my second question is  - how i remove the controller name from url?  

Hi,     any body can help, i got 404 message and i dont know the exact way on how to resolve it.   i have url login page like this :

http://localhost/prok/run32.php 

 and now if the user get correct username and password, page will load or redirect in this but in this link i get 404 message

http://localhost/prok/index.php/dashboard/catalog

please take a look my way of coding.

#routes.php

$route['default_controller'] = 'Login';
$route['404_override'] = '';
$route['dashboard/(:any)'] = 'dashboard/Catalog';

#controllers/login.php

<?php 
	if ( ! defined('BASEPATH')) exit('No direct script access allowed');

		class Login extends CI_Controller 
			{

				function __construct()
					{
						parent::__construct();
						$this->load->helper('url');
					}
				public function index()
				{
					$this->load->view('login');
					
								$array = array();
								
										
								if(isset($_POST['submit']))
									{	
										$username = $this->security->xss_clean($this->input->post('username'));
										$password = $this->security->xss_clean($this->input->post('password'));
										
										if(empty($username))
											{ 
												$array[] = "<p>Please fill-in required field!</p>"; 
											}
										else 
											{ 
												$username = mysql_real_escape_string($username);
											}
										if(empty($password))
												{ 
													$array[] = "<p>Please fill-in required field!</p>";
												}
											else 
												{ 
													$password = mysql_real_escape_string($password);
												}
												if(sizeof($array) > 0)
													{
														foreach($array as $val);
															{ echo "<p>$val</p>";
															}
													}
											else
												{ 
													$this->load->model('login_process');
													$result = $this->login_process->validated();
												if(!$result)
													{
														echo "<p> Invalid usernamessssss and password.</p><br />";
													}
												else
													{
														#$this->load->view('dashboard/catalog','refresh');
														redirect('dashboard/catalog','refresh');
													}
												}
									}
				}
			}

#controllers/dashboard/catalog.php

<?php 
	if ( ! defined('BASEPATH')) exit('No direct script access allowed');

		class Catalog extends CI_Controller 
			{
				public function index()
					{
							$this->load->view('dashboard/catalog');
							
					}

			}

please advise, what im doing wrong.     Thanks advance

Hi coders,   code below are running good, but my problem is i did not get the line echo $row->pof_num + 1; into view "generate_po.php".   since i want that line to get the value and put into input text like below. how and kindly assist.

<input type = "text" name = "num" value = "<?php echo $row->pof_num + 1; ?>">

		public function generate_po()
			{
				$po_id = $this->input->post('selector');
				
				$data['result'] =  $this->public_base_model->generate_po($po_id);
		
					if($this->session->userdata('logged_in'))
						{
						  $session_data = $this->session->userdata('logged_in');
							$data['username'] = $session_data['username'];
								$data['fname'] = $session_data['fname'];
									$data['userid'] = $session_data['userid'];
										$this->load->view('generate_po', $data,$this->get_max());
						}
					else
						{
						 $this->load->view('login');
						}
			}
		public function get_max()
			{
				$query2 = $this->db->query("SELECT pof_num FROM pull_out where pof_num = '8800000582'");

				$row = $query2->row();
				
					echo $row->pof_num + 1; // i want this line to put into view.
					
				$query2->free_result();			
					
			}

This topic has been moved to mod_rewrite.

http://www.phpfreaks.com/forums/index.php?topic=355043.0