Jump to content


Photo

My dropdown date of birth does not insert to db


  • Please log in to reply
3 replies to this topic

#1 brincobb

brincobb

    Newbie

  • New Members
  • Pip
  • 2 posts

Posted 25 October 2013 - 05:56 AM

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

 



#2 mac_gyver

mac_gyver

    Advanced Member

  • Administrators
  • 2,481 posts

Posted 25 October 2013 - 09:47 AM

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?


multi-purpose programming fool. well written source-code should be self-documenting. well written code should be self-troubleshooting. 


#3 brincobb

brincobb

    Newbie

  • New Members
  • Pip
  • 2 posts

Posted 28 October 2013 - 01:53 AM

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


#4 mac_gyver

mac_gyver

    Advanced Member

  • Administrators
  • 2,481 posts

Posted 28 October 2013 - 08:10 AM

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?


multi-purpose programming fool. well written source-code should be self-documenting. well written code should be self-troubleshooting. 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com