Why still not insert the data into database

[fansa]

Hai everybody...i need help from brilliant person. What wrong with my coding,stilll not function (insert)???

if(isset($_POST['Register']))
{
   $_SESSION['ipa_id']     = $_POST['ipa_id'];
   $_SESSION['ifp_ic_to']  = $_POST['ifp_ic_to'];
       $_SESSION['ifp_ic_from']= $_POST['ifp_ic_from'];
       $_SESSION['ifp_season'] = $_POST['ifp_season'];
       $_SESSION['refno']      = $_POST['refno'];
   $_SESSION['ifp_company']= $_POST['ifp_company'];


   $iph_correction_cnames = array(ic_companyno,
                                  ic_refno,
				                  ic_is_id,
						          ic_org_id_01,
						          ic_din_id_01,
								  ic_org_id_02,
								  ic_din_id_02,
								  ic_created_date,
								  ic_created_by,
								  ic_process_status,
								  ic_status);


    $iph_correction_values = array($_POST['companyno'],
	                               $_POST['refno'],
								   $_POST['is_id'],
								   $_POST['org_id'],
								   $_POST['din_id'],
								   $_POST['org_idto'],
								   $_POST['din_idto'],
								   datetime(),
								   MXPRO_USR_ID,
									  'NEW',
								  'N');

	 $iph_correction_cnames = implode($iph_correction_cnames ,",");
         $iph_correction_values = implode($iph_correction_values,"','");				

  	 $insert01 = new myclass;
     $insert01 = $insert01->insert('iph_correction',$iph_correction_cnames,$iph_correction_values); 


    header("Location: ../../../../public_html/mxpro.master.php?mnd_code=mn_iph_27&ch=6");
    exit;
}

[trq]

Your supplied arguments to implode are around the wrong way for starters.

[trq]

Also, are any of these constants defined?

 

array(ic_companyno,
                                  ic_refno,
				                  ic_is_id,
						          ic_org_id_01,
						          ic_din_id_01,
								  ic_org_id_02,
								  ic_din_id_02,
								  ic_created_date,
								  ic_created_by,
								  ic_process_status,
								  ic_status);

[fansa]

I don't understant what you mean..please help me...

[trq]

Well then, its likely you meant those values to be strings. Change them to....

 

array('ic_companyno',
          'ic_refno', 
          'ic_is_id',

etc etc.

[fansa]

ok..i'll try now

[fansa]

Still not work...this is the edited coding

if(isset($_POST['Register']))

{

    $_SESSION['ipa_id']    = $_POST['ipa_id'];

  $_SESSION['ifp_ic_to']  = $_POST['ifp_ic_to'];

      $_SESSION['ifp_ic_from']= $_POST['ifp_ic_from'];

      $_SESSION['ifp_season'] = $_POST['ifp_season'];

      $_SESSION['refno']      = $_POST['refno'];

  $_SESSION['ifp_company']= $_POST['ifp_company'];

 

 

  $iph_correction_cnames = array('ic_companyno',

                                  'ic_refno',

                  'ic_is_id',

          'ic_org_id_01',

          'ic_din_id_01',

  'ic_org_id_02',

  'ic_din_id_02',

  'ic_created_date',

  'ic_created_by',

  'ic_process_status',

  'ic_status');

 

 

    $iph_correction_values = array($_POST['companyno'],

                              $_POST['refno'],

  $_POST['is_id'],

  $_POST['org_id'],

  $_POST['din_id'],

  $_POST['org_idto'],

  $_POST['din_idto'],

  datetime(),

  MXPRO_USR_ID,

  'NEW',

  'N');

 

$iph_correction_cnames = implode($iph_correction_cnames ,",");

        $iph_correction_values = implode($iph_correction_values,"','");

 

  $insert01 = new myclass;

    $insert01 = $insert01->insert('iph_correction',$iph_correction_cnames,$iph_correction_values);

 

 

    header("Location: ../../../../public_html/mxpro.master.php?mnd_code=mn_iph_27&ch=6");

    exit;

}

[trq]

Still, you have supplied the arguments to implode around the wrong way.

 

$iph_correction_cnames = implode($iph_correction_cnames ,",");
$iph_correction_values = implode($iph_correction_values,"','");

 

should be.....

 

$iph_correction_cnames = implode(',', $iph_correction_cnames);
$iph_correction_values = implode(',' $iph_correction_values);

[fansa]

Still not work :'(

[trq]

Can we see the insert method of myclass ?

[fansa]

This is the class

 

 

if(!empty($refno) && !empty($ifp_season))

{

 

$iph_refno= new myclass;

$iph_refno = $iph_refno->fetchdata("Select * from iph_correction where ic_refno='".$refno."'") ;

                                                       

$refno        = $iph_refno->ic_refno;

$ic_companyno  = $iph_refno->ic_companyno;

 

 

if($refno != $_SESSION['refno'] &&  $_GET['refno'] == '') {

header("Location: ../../../../public_html/mxpro.master.php?mnd_code=mn_iph_27&ch=6");?>

    <script type="text/javascript">alert("You need to register the reference number!!");</script><? }

elseif($ic_companyno== '' && $refno != $_GET['refno']) {

  ?>

    <script type="text/javascript">alert("You need to register the reference number!!");</script><? }

 

 

 

 

 

}

 

[attachment deleted by admin]

[trq]

Um, no its not.

 

And a correction to my earlier code (this is still guess work until we see some relvent code) should be....

 

$iph_correction_cnames = implode("','", $iph_correction_cnames);
$iph_correction_values = implode("','" $iph_correction_values);

[fansa]

owh..i don't know what happen with this coding..still not work..suppose work..arghhhh

[trq]

We need to see the insert method of this myclass class.