Jump to content

Archived

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

brincobb

My dropdown date of birth does not insert to db

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;
 
}

 

Share this post


Link to post
Share on other sites
My dropdown date of birth does not insert to db

 

 

ummm. what INSERT statement? what db are you using? what have you done to pin down where your code and data are doing what you expect and where they are not?

Share this post


Link to post
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);
}
}

Share this post


Link to post
Share on other sites

nothing you have posted in this thread shows the code where the problem might be. the first post was for your dropdown. the second post shows some very old code for the start of a class.

 

just exactly what sort of help were you expecting to get?

Share this post


Link to post
Share on other sites

×
×
  • 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.