inserting to sql from textfield and textarea doesn't work

Question

please help, inserting datas from my textfields combined with my textareas to db not working,

please help on how to combine my VALUES properly. I cant seem to figure out how to combine the implode for my textareas and the other values from textfields.

below is my PHP code:

$Category2 = $_POST['Category2'];
    $Category3 = $_POST['Category3'];
    $Status = $_POST['Status'];
    $Date = $_POST['Date'];
    $Severity = $_POST['Severity'];
    $BanType = $_POST['BanType'];
    $XiD = $_POST['XiD'];
    $Ticket = $_POST['Ticket'];

    //Process the input textareas into arrays
    $PhoneNumber = array_map('mysql_real_escape_string', explode("
", $_POST['PhoneNumber']));
    $Createdate = array_map('mysql_real_escape_string', explode("
", $_POST['Createdate']));
    $RemedyTicketNo = array_map('mysql_real_escape_string', explode("
", $_POST['PhoneNumber']));

    //Determine the values with the least amoutn of elements
    $min_count = min($PhoneNumber, $Createdate, $RemedyTicketNo);

    //Create array to hold INSERT values
    $values = array();

    //Create the INSERT values
    for($index=0; $index<$min_count; $index++)
    {
    $values[] = "('$RemedyTicketNo[$index]','$PhoneNumber[$index]','$Createdate[$index]',
'$Category2','$Category3','$Status','$Date','$Severity','$BanType','$XiD')";     
    }

    $sql=mysql_query("INSERT into tbl_main
    (ars_no,phone_number,create_date,category_1,category_2,status,resolved_date,trouble_type_priority,ban_type,employee_id_name)
    VALUES " . implode (',',$values));
if (!$sql) {
die('Invalid query: ' . mysql_error());
}
    header("Location: smp_backend_test.php");
    }

here is my html code: this has the textfields,


          //here are my textareas:
            

            
              
               
              
            
            
              Ticket Source:
              
                
            
            
              Date:
              
                
                

            
            
              XiD, Name:
              
                
                
            
            
              Category 2:
                                  
                
            
            
              Category 3:
              
                
            
            
              Status:
              
                  
              
            
            
              Severity:
              
                
                
            
            
              Ban Type:
              
                
                
              
            
            
              Phone No.:
              Create Date:
              RemedyTicketNo

Yadav Chetan · Accepted Answer

try this i edited your code


    
              
                
                  
                   
                  
                
                
                  Ticket Source:
                  
                    
                
                
                  Date:
                  
                    
                    

                
                
                  XiD, Name:
                  
                    
                    
                
                
                  Category 2:
                                      
                    
                
                
                  Category 3:
                  
                    
                
                
                  Status:
                  
                      
                  
                
                
                  Severity:
                  
                    
                    
                
                
                  Ban Type:
                  
                    
                    
                  
                
                
                  Phone No.:
                  Create Date:
                  RemedyTicketNo

for simply checking validation for null follow the code and you should check more it just a sample how you can do with javascript you can do it with Jquery too

 function validateDBLoad () {
        var xid=document.getElementById('XiD').value;
        var PhoneNumber=document.getElementById('PhoneNumber').value;
        var Status=document.getElementById('Status').value;
        var Category2=document.getElementById('Category2').value;
        var Category3=document.getElementById('Category3').value;
        var Createdate=document.getElementById('Createdate').value;
        var Severity=document.getElementById('Severity').value;
        var BanType=document.getElementById('BanType').value;


         if((xid=="Blank") || (PhoneNumber=="") || (Category2) || (Category3=="Blank") || (Status=="") || (Createdate=="") || (Severity=="") || (document.form1.BanType.value=="")) { alert('Please fill up all the fields..'); return false; } else { alert('Ticket upload Successful.'); return true; } }

and make your table as follow

CREATE TABLE IF NOT EXISTS `tbl_main` (
  `ars_no` int(12) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(50) NOT NULL,
  `category_1` varchar(50) NOT NULL,
  `category_2` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `create_date` varchar(50) NOT NULL,
  `trouble_type_priority` varchar(50) NOT NULL,
  `ban_type` varchar(50) NOT NULL,
  `resolved_date` date NOT NULL,
  `employee_id_name` varchar(50) NOT NULL,
  PRIMARY KEY (`ars_no`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

inserting to sql from textfield and textarea doesn't work

Answers (1)

Related Questions

inserting to sql from textfield and textarea doesn&#39;t work

Answers (1)

Related Questions

inserting to sql from textfield and textarea doesn't work