Jump to content

My dropdown date of birth does not insert to db


brincobb

Recommended Posts

Here' my html code

 

 

<tr>
                            <td class="easdwnunder" style="width: 40%;">DATE OF BIRTH:</td>
                            <td class="dwnunder2" style="width: 40%;"><div style="width: 100%;">
                              <?php 
                                                    if($newproblem && !$printing)
                                                    {
                                                        ?>
                                    <?php echo date_dropdown($this->row->date_of_birth); ?>
                               <?php 
                                                    }
                                                    else
                                                    { 
                                                       echo safe_out($this->row->date_of_birth);
                                                    }
                                                ?>
                                        
                            </div></td>
                            
                          </tr>
 
 
 
And here's my dropdown function
 
 
function date_dropdown($year_limit = 0)
{
 
        $html_output = '    <div id="date_select" >'."\n";
 
        $html_output .= '        <label for="date_day"></label>'."\n";
 
 
 
        /*days*/
 
        $html_output .= '           <select name="date_day" id="day_select">'."\n";
 
            for ($day = 1; $day <= 31; $day++) {
 
                $html_output .= '               <option>' . $day . '</option>'."\n";
 
            }
 
        $html_output .= '           </select>'."\n";
 
 
 
        /*months*/
 
        $html_output .= '           <select name="date_month" id="month_select" >'."\n";
 
        $months = array("", "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
 
            for ($month = 1; $month <= 12; $month++) {
 
                $html_output .= '               <option value="' . $month . '">' . $months[$month] . '</option>'."\n";
                
            }
 
        $html_output .= '           </select>'."\n";
 
 
 
        /*years*/
 
        $html_output .= '           <select name="date_year" id="year_select">'."\n";
 
            for ($year = 1900; $year <= (date("Y") - $year_limit); $year++) {
 
                $html_output .= '               <option>' . $year . '</option>'."\n";
 
            }
 
        $html_output .= '           </select>'."\n";
 
 
 
        $html_output .= '   </div>'."\n";
        
        $date_of_birth = $day ."-". $month ."-". $year;
 
    return $html_output;
 
}

 

Link to comment
Share on other sites

im using mysql database and here are fields in the table.

 

CREATE TABLE IF NOT EXISTS `cf360_wanted_persons_problems` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `uid` text NOT NULL,
  `rank` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `fstname` varchar(100) NOT NULL,
  `alias` varchar(100) CHARACTER SET latin1 NOT NULL,
  `idno` varchar(100) NOT NULL,
  `case_no` varchar(100) CHARACTER SET latin1 NOT NULL,
  `aquisition_request` varchar(100) CHARACTER SET latin1 NOT NULL,
  `persal_no` varchar(255) CHARACTER SET latin1 NOT NULL,
  `division` varchar(255) CHARACTER SET latin1 NOT NULL,
  `stationname` varchar(100) NOT NULL,
  `stationadd` text NOT NULL,
  `physicaladd` text NOT NULL,
  `postalcode` varchar(50) NOT NULL,
  `telecntct` varchar(100) NOT NULL,
  `fax` varchar(100) NOT NULL,
  `stationemail` varchar(100) NOT NULL,
  `emailaddress` varchar(100) NOT NULL,
  `afsbjct` varchar(100) NOT NULL,
  `ocomments` text NOT NULL,
  `datecaptured` datetime NOT NULL,
  `officialdate` datetime NOT NULL,
  `uemail` text NOT NULL,
  `ulocation` text NOT NULL,
  `uphone` text NOT NULL,
  `rep` bigint(20) NOT NULL,
  `status` bigint(20) NOT NULL,
  `time_spent` bigint(20) NOT NULL,
  `category` bigint(20) NOT NULL,
  `close_date` datetime NOT NULL,
  `department` bigint(20) NOT NULL,
  `rdescription` bigint(20) NOT NULL,
  `offender_description` bigint(20) NOT NULL,
  `declaration_description` bigint(20) NOT NULL,
  `countries` bigint(20) NOT NULL,
  `provinces` bigint(20) NOT NULL,
  `title` text NOT NULL,
  `description` text NOT NULL,
  `crime_description` text CHARACTER SET latin1 NOT NULL,
  `scars_remarks_description` text CHARACTER SET latin1 NOT NULL,
  `remarks_description` text CHARACTER SET latin1 NOT NULL,
  `caution_description` text CHARACTER SET latin1 NOT NULL,
  `statement_remarks_description` text CHARACTER SET latin1 NOT NULL,
  `reward` text CHARACTER SET latin1 NOT NULL,
  `place_of_birth` varchar(100) CHARACTER SET latin1 NOT NULL,
  `last_known_location` varchar(100) CHARACTER SET latin1 NOT NULL,
  `race` varchar(100) CHARACTER SET latin1 NOT NULL,
  `sex` varchar(100) CHARACTER SET latin1 NOT NULL,
  `eyes` varchar(100) CHARACTER SET latin1 NOT NULL,
  `hair` varchar(100) CHARACTER SET latin1 NOT NULL,
  `weight` bigint(20) NOT NULL,
  `height` bigint(20) NOT NULL,
  `build` varchar(100) CHARACTER SET latin1 NOT NULL,
  `solution` text NOT NULL,
  `start_date` datetime NOT NULL,
  `date_of_birth` varchar(100) NOT NULL,
  `crime_date` varchar(100) CHARACTER SET latin1 NOT NULL,
  `age` smallint(20) NOT NULL,
  `priority` bigint(20) NOT NULL,
  `entered_by` bigint(20) NOT NULL,
  `kb` bigint(20) NOT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `rep` (`rep`,`status`,`category`,`department`,`priority`),
  FULLTEXT KEY `solution` (`solution`),
  FULLTEXT KEY `description` (`description`),
  FULLTEXT KEY `title` (`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;
 
 
 
 
Here's the code to insert.
 
 
<?php
defined('_JEXEC') or die('Restricted access');
//check user auth level
require_once JPATH_COMPONENT.DS.'helpers'.DS.'head.php';
require_once JPATH_COMPONENT.DS.'helpers'.DS.'auth.php';
$mainframe = &JFactory::getApplication();
if(!checkusermin('user') && !config('allowanonymous')) $mainframe->redirect('index.php', JText::_('ALERTNOTAUTH'));
 
/*
NOTE: If we make any changes to this class, we need to make similar changes to helpers/imap.php
because the class is duplicated there.
*/
 
class TableDetail extends JTable
{
var $id = null;
var $uid = null;
var $uemail = null;
var $ulocation = null;
var $uphone = null;
var $rep = null;
/*########################*/
var $name = null;
var $fstname = null;
        var $case_no = null;
var $alias = null;
        var $idno = null;
var $rank = null;
var $fax = null;
        //var $countries = null;
var $stationemail = null;
var $stationname = null;
var $stationadd = null;
var $physicaladd = null;
var $postalcode = null;
var $telecntct = null;
var $emailaddress = null;
var $afsbjct = null;
var $ocomments = null;
var $datecaptured = null;
var $officialdate = null;
/*########################*/
var $status = null;
var $time_spent = null;
var $category = null;
var $close_date = null;
var $department = null;
var $countries = null;
        var $date_of_birth = null;
        var $missing_date = null;
        var $success_date = null;
        var $place_of_birth = null;
        var $last_known_location = null;
        var $race = null;
        var $sex = null;
        var $eyes = null;
        var $hair = null;
        var $weight = null;
        var $height = null;
        var $build = null;
var $title = null;
var $description = null;
        var $crime_description = null;
        var $scars_remarks_description = null;
        var $remarks_description = null;
        var $caution_description = null;
        var $statement_remarks_description = null;
        var $reward = null;
var $solution = null;
var $start_date = null;
var $priority = null;
var $entered_by = null;
var $kb = null;
 
function __construct(&$db)
{
parent::__construct('#__wanted_persons_problems','id',$db);
}
}
Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.