this question has answer here:
sorry shows duplicate, looking @ others, explanation hasn't clicked, have been reading them months, new combatant in web development, please @ code , help.
my html form passes data php script, shows on echo, still errors , not insert msqli database -- gets errors undefined index , undefined variable. have read posts, can't seem find or not understand explanations.
here php echo:
array ( [engineers] => xxxxxx [location] => office [site] => xxxxxxxx [date] => 24-01-2016 [callref] => inc00353 [addcallref] => 0 [adcdrive] => 736547 [adddrive] => 365765 [adedrive] => 756 [admemory] => 7 [lncdrive] => 567 [lnddrive] => 675 [lnedrive] => 65755 [lnfdrive] => 567 [lngdrive] => 65756 [lnmemory] => 7 [scdrive] => 567 [sddrive] => 567 [sedrive] => 567 [smemory] => 567 [gpmsdb] => 567567 [gpmslog] => 567 [gpmsbackups] => array ( [0] => ) [etsdb] => 567567 [etslog] => 567 [etsbackups] => array ( [0] => ) [cmsdb] => 567 [cmslog] => 567 [cmsbackups] => array ( [0] => ) [etsappsetrig] => array ( [0] => running ) [etsappspc] => array ( [0] => running ) [etsappsedtcont] => array ( [0] => running ) [etsappshub] => array ( [0] => running ) [etsappsiesna] => array ( [0] => running ) [etsappsexti] => array ( [0] => running ) [etsappscs] => array ( [0] => running ) [etsappsint] => array ( [0] => running ) [etsappscmssh] => array ( [0] => running ) [gpmsappsgtrig] => array ( [0] => running ) [gpmsappsgsmet] => array ( [0] => running ) [gpmsappsgcinst] => array ( [0] => running ) [gpmsappsgmif] => array ( [0] => running ) [gpmsappsgmcs] => array ( [0] => running ) [gpmsappsghist] => array ( [0] => running ) [gpmsappsgop] => array ( [0] => running ) [gpmsappsgext] => array ( [0] => running ) [gpmsappsngc] => array ( [0] => running ) [gpmsappsedl] => array ( [0] => running ) [etsapps14] => array ( [0] => running ) [etsappsfms] => array ( [0] => running ) [xsecfdin] => array ( [0] => running ) [xsecfdout] => array ( [0] => running ) [xsecfder] => array ( [0] => running ) [xsecfdarc] => array ( [0] => running ) [xsecdfein] => array ( [0] => running ) [xsecfeout] => array ( [0] => running ) [xsecfeer] => array ( [0] => running ) [xsecfearc] => array ( [0] => running ) [xsecfpdi] => array ( [0] => running ) [xsecfpdo] => array ( [0] => running ) [xsecfpder] => array ( [0] => running ) [xsecfpdarc] => array ( [0] => running ) [xsecfpei] => array ( [0] => running ) [xsecfpeo] => array ( [0] => running ) [xsecfpee] => array ( [0] => running ) [xsecfpearc] => array ( [0] => running ) [adappevents] => array ( [0] => ) [adsysevents] => array ( [0] => ) [gpmsappevents] => array ( [0] => ) [gpmssysevents] => array ( [0] => ) [etsappevents] => array ( [0] => ) [etssysevents] => array ( [0] => running ) [gpmsmsmq] => array ( [0] => running ) [etsmsmq] => array ( [0] => running ) [comments] => qreytyteyrtywrtytrywrtywrtywrtywrtyrtwywryyrtyrwywtrywrtywrtywrtywrtyrtywrtytywrywrtywrty ) note, array entries check boxes, date comes datepicker.
here php:
<?php //echo '<pre>'; print_r($_post); echo '</pre>'; exit; if(isset($_post["submit"])) $mysqli = new mysqli("localhost", "xxxxxxx", "xxxxxxxx", "xxxxxxxxxxxx"); /* check connection */ if (mysqli_connect_errno()) { printf("connect failed: %s\n", mysqli_connect_error()); exit(); } $engineers = db_quote ($_post['engineers']); $location = db_quote ($_post['location']); $site = db_quote ($_post['site']); $date = db_quote ($_post['date']); $callref = db_quote ($_post['callref']); $addcallref = db_quote ($_post['addcallref']); $adcdrive = db_quote ($_post['adcdrive']); $adddrive = db_quote ($_post['adddrive']); $adedrive = db_quote ($_post['adedrive']); $admemory = db_quote ($_post['admemory']); $ncdrive = db_quote ($_post['ncdrive']); $nddrive = db_quote ($_post['nddrive']); $nedrive = db_quote ($_post['nedrive']); $nmemory = db_quote ($_post['nmemory']); $scdrive = db_quote ($_post['scdrive']); $sedrive = db_quote ($_post['sedrive']); $smemory = db_quote ($_post['smemory']); $gpmsdb = db_quote ($_post['gpmsdb']); $gpmslog = db_quote ($_post['gpmslog']); $gpmsbackups = db_quote ($_post['gpmsbackups']); $etsdb = db_quote ($_post['etsdb']); $etslog = db_quote ($_post['etslog']); $etsbackups = db_quote ($_post['etsbackups']); $cmsdb = db_quote ($_post['cmsdb']); $cmslog = db_quote ($_post['cmslog']); $cmsbackup = db_quote ($_post['cmsbackup']); $etsappspc = db_quote ($_post['etsappspc']); $etsappsedtcont = db_quote ($_post['etsappsedtcont']); $etsappshub = db_quote ($_post['etsappshub']); $etsappsies = db_quote ($_post['etsappsies']); $etsappsexti = db_quote ($_post['etsappsexti']); $etsappscs = db_quote ($_post['etsappscs']); $etsappsint = db_quote ($_post['etsappsint']); $etsappscmssh = db_quote ($_post['etsappscmssh']); $gpmsappsgtrig = db_quote ($_post['gpmsappsgtrig']); $gpmsappsgcmet = db_quote ($_post['gpmsappsgcmet']); $gpmsappsgcinst = db_quote ($_post['gpmsappsgcinst']); $gpmsappsgmig = db_quote ($_post['gpmsappsgmig']); $gpmsappsgmcs = db_quote ($_post['gpmsappsgmcs']); $gpmsappsghist = db_quote ($_post['gpmsappsghist']); $gpmsappsgop = db_quote ($_post['gpmsappsgop']); $gpmsappsgext = db_quote ($_post['gpmsappsgext']); $gpmsappsngc = db_quote ($_post['gpmsappsngc']); $gpmsappsedl = db_quote ($_post['gpmsappsedl']); $etsapps14 = db_quote ($_post['etsapps14']); $etsappsfms = db_quote ($_post['etsappsfms']); $xsecfdin = db_quote ($_post['xsecfdin']); $xsecfdout = db_quote ($_post['xsecfdout']); $xsecfder = db_quote ($_post['xsecfder']); $xsecfein = db_quote ($_post['xsecfein']); $xsecfeout = db_quote ($_post['xsecfeout']); $xsecfeer = db_quote ($_post['xsecfeer']); $xsecfdarc = db_quote ($_post['xsecfdarc']); $xsecfearc = db_quote ($_post['xsecfearc']); $xsecfpdi = db_quote ($_post['xsecfpdi']); $xsecfpdo = db_quote ($_post['xsecfpdo']); $xsecfpder = db_quote ($_post['xsecfpder']); $xsecfpdarc = db_quote ($_post['xsecfpdarc']); $xsecfpei = db_quote ($_post['xsecfpei']); $xsecfpeo = db_quote ($_post['xsecfpeo']); $xsecfpee = db_quote ($_post['xsecfpee']); $xsecpearc = db_quote ($_post['xsecpearc']); $adappevents = db_quote ($_post['adappevents']); $adsysevents = db_quote ($_post['adsysevents']); $gappevents = db_quote ($_post['gappevents']); $gsysevents = db_quote ($_post['gsysevents']); $eappevents = db_quote ($_post['eappevents']); $etsappstrig = db_quote ($_post['etsappstrig']); $msmq = db_quote ($_post['msmq']); $comments = db_quote ($_post['comments']); // check connection //if($link === false){ // die("error: not connect. " . mysqli_connect_error()); // } if (mysqli_query($link, $sql = "insert `xxxxxxxxxx`(`xxxxxxxxxxxx_id`, `engineers`, `location`, `site`, `date`, `callref`, `addcallref`, `adcdrive`, `adddrive`, `adedrive`, `admemory`, `lncdrive`, `lnddrive`, `lnedrive`, `lnfdrive`, `lngdrive`, `lnmemory`, `scdrive`, `sddrive`, `sedrive`, `smemory`, `gpmsdb`, `gpmslog`, `gpmsbackups`, `etsdb`, `etslog`, `etsbackups`, `cmsdb`, `cmslog`, `cmsbackups`, `etsappsetrig`, `etsappspc`, `etsappsedtcont`, `etsappshub`, `etsappsiesna`, `etsappsexti`, `etsappscs`, `etsappsint`, `etsappscmssh`, `gpmsappsgtrig`, `gpmsappsgsmet`, `gpmsappsgcinst`, `gpmsappsgmif`, `gpmsappsgmcs`, `gpmsappsghist`, `gpmsappsgop`, `gpmsappsgext`, `gpmsappsngc`, `gpmsappsedl`, `etsapps14`, `etsappsfms`, `xsecfdin`, `xsecfdout`, `xsecfder`, `xsecfdarc`, `xsecdfein`, `xsecfeout`, `xsecfeer`, `xsecfearc`, `xsecfpdi`, `xsecfpdo`, `xsecfpder`, `xsecfpdarc`, `xsecfpei`, `xsecfpeo`, `xsecfpee`, `xsecfpearc`, `adappevents`, `adsysevents`, `gpmsappevents`, `gpmssysevents`, `etsappevents`, `etssysevents`, `gpmsmsmq`, `etsmsmq`, `comments`) values (`$engineers`, `$location`, `$site`, `$date`, `$callref`, `$addcallref`, `$adcdrive`, `$adddrive`, `$adedrive`, `$admemory`, ` $ncdrive`, `$nddrive`, `$nedrive`, `$nmemory`, `$scdrive`, `$sedrive`, `$smemory`, `$gpmsdb`, `$gpmslog`, `$gpmsbackups`, `$etsdb`, `$etslog`, `$etsbackups`, `$cmsdb`, `$cmslog`, `$cmsbackup`, `$etsappspc`, `$etsappsedtcont`, ` $etsappshub`, `$etsappsies`, `$etsappsexti`, `$etsappscs`, `$etsappsint`, `$etsappscmssh`, `$gpmsappsgtrig`, `$gpmsappsgcmet`, `$gpmsappsgcinst`, `$gpmsappsgmig`, `$gpmsappsgmcs`, `$gpmsappsghist`, `$gpmsappsgop`, `$gpmsappsgext`, ` $gpmsappsngc`, `$gpmsappsedl`, `$etsapps14`, `$etsappsfms`, `$xsecfdin`, `$xsecfdout`, `$xsecfder`, `$xsecfein`, `$xsecfeout`, `$xsecfeer`, `$xsecfdarc`, `$xsecfearc`, `$xsecfpdi`, `$xsecfpdo`, `$xsecfpder`, `$xsecfpdarc`, `$xsecfpei`, `$xsecfpeo`, `$xsecfpee`, `$xsecpearc`, `$adappevents`, `$adsysevents`, `$gappevents`, `$gsysevents`, `$eappevents`, `$etsappstrig`, `$msmq`, `$comments')")){ printf("%d row inserted.\n", mysqli_affected_rows($link)); } if(mysqli_query($link, $sql)){ echo "records added successfully."; } else{ echo "error: not able execute $sql. " . mysqli_error($link); } // close connection mysqli_close($link); ?> and here errors:
*( ! ) notice: undefined index: date in c:\wamp\www\xxxxxxxx.php on line 15 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: ncdrive in c:\wamp\www\xxxxxxxx.php on line 22 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: nddrive in c:\wamp\www\xxxxxxxx.php on line 23 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: nedrive in c:\wamp\www\xxxxxxxx.php on line 24 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: nmemory in c:\wamp\www\xxxxxxxx.php on line 25 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: cmsbackup in c:\wamp\www\xxxxxxxx.php on line 37 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: etsappsies in c:\wamp\www\xxxxxxxx.php on line 41 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: etsappsint in c:\wamp\www\xxxxxxxx.php on line 44 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: gpmsappsgcmet in c:\wamp\www\xxxxxxxx.php on line 47 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: gpmsappsgmig in c:\wamp\www\xxxxxxxx.php on line 49 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecfdin in c:\wamp\www\xxxxxxxx.php on line 58 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecfdout in c:\wamp\www\xxxxxxxx.php on line 59 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecfder in c:\wamp\www\xxxxxxxx.php on line 60 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecfein in c:\wamp\www\xxxxxxxx.php on line 61 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecfeout in c:\wamp\www\xxxxxxxx.php on line 62 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecfeer in c:\wamp\www\xxxxxxxx.php on line 63 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecfdarc in c:\wamp\www\xxxxxxxx.php on line 64 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecfearc in c:\wamp\www\xxxxxxxx.php on line 65 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecfpdi in c:\wamp\www\xxxxxxxx.php on line 66 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecfpdo in c:\wamp\www\xxxxxxxx.php on line 67 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecfpder in c:\wamp\www\xxxxxxxx.php on line 68 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecfpdarc in c:\wamp\www\xxxxxxxx.php on line 69 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecfpei in c:\wamp\www\xxxxxxxx.php on line 70 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecfpeo in c:\wamp\www\xxxxxxxx.php on line 71 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecfpee in c:\wamp\www\xxxxxxxx.php on line 72 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: xsecpearc in c:\wamp\www\xxxxxxxx.php on line 73 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: gappevents in c:\wamp\www\xxxxxxxx.php on line 76 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: gsysevents in c:\wamp\www\xxxxxxxx.php on line 77 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: eappevents in c:\wamp\www\xxxxxxxx.php on line 78 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: etsappstrig in c:\wamp\www\xxxxxxxx.php on line 79 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: msmq in c:\wamp\www\xxxxxxxx.php on line 80 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined index: comments in c:\wamp\www\xxxxxxxx.php on line 81 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: undefined variable: link in c:\wamp\www\xxxxxxxx.php on line 98 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 108 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 108 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 108 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 110 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 110 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 110 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 110 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 110 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 110 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 110 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 110 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 110 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 110 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 112 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 112 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 112 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 112 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 112 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 114 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) notice: array string conversion in c:\wamp\www\xxxxxxxx.php on line 114 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) warning: mysqli_query() expects parameter 1 mysqli, null given in c:\wamp\www\xxxxxxxx.php on line 114 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 2 0.0312 356368 mysqli_query ( ) ..\xxxxxxxx.php:114 ( ! ) notice: undefined variable: link in c:\wamp\www\xxxxxxxx.php on line 121 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) warning: mysqli_query() expects parameter 1 mysqli, null given in c:\wamp\www\xxxxxxxx.php on line 121 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 2 0.0312 356368 mysqli_query ( ) ..\xxxxxxxx.php:121 ( ! ) notice: undefined variable: link in c:\wamp\www\xxxxxxxx.php on line 127 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) warning: mysqli_error() expects parameter 1 mysqli, null given in c:\wamp\www\xxxxxxxx.php on line 127 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 2 0.0312 357960 mysqli_error ( ) ..\xxxxxxxx.php:127 error: not able execute insert `fellside`(`dailychecks_id`, `engineers`, `location`, `site`, `date`, `callref`, `addcallref`, `adcdrive`, `adddrive`, `adedrive`, `admemory`, `lncdrive`, `lnddrive`, `lnedrive`, `lnfdrive`, `lngdrive`, `lnmemory`, `scdrive`, `sddrive`, `sedrive`, `smemory`, `gpmsdb`, `gpmslog`, `gpmsbackups`, `etsdb`, `etslog`, `etsbackups`, `cmsdb`, `cmslog`, `cmsbackups`, `etsappsetrig`, `etsappspc`, `etsappsedtcont`, `etsappshub`, `etsappsiesna`, `etsappsexti`, `etsappscs`, `etsappsint`, `etsappscmssh`, `gpmsappsgtrig`, `gpmsappsgsmet`, `gpmsappsgcinst`, `gpmsappsgmif`, `gpmsappsgmcs`, `gpmsappsghist`, `gpmsappsgop`, `gpmsappsgext`, `gpmsappsngc`, `gpmsappsedl`, `etsapps14`, `etsappsfms`, `xsecfdin`, `xsecfdout`, `xsecfder`, `xsecfdarc`, `xsecdfein`, `xsecfeout`, `xsecfeer`, `xsecfearc`, `xsecfpdi`, `xsecfpdo`, `xsecfpder`, `xsecfpdarc`, `xsecfpei`, `xsecfpeo`, `xsecfpee`, `xsecfpearc`, `adappevents`, `adsysevents`, `gpmsappevents`, `gpmssysevents`, `etsappevents`, `etssysevents`, `gpmsmsmq`, `etsmsmq`, `comments`) values (`gordon coates`, `office`, `fellside`, ``, `inc00353`, `0`, `736547`, `365765`, `756`, `7`, ` `, ``, ``, ``, `567`, `567`, `567`, `567567`, `567`, `array`, `567567`, `567`, `array`, `567`, `567`, ``, `array`, `array`, ` array`, ``, `array`, `array`, ``, `array`, `array`, ``, `array`, ``, `array`, `array`, `array`, `array`, ` array`, `array`, `array`, `array`, ``, ``, ``, ``, ``, ``, ``, ``, ``, ``, ``, ``, ``, ``, ``, ``, `array`, `array`, ``, ``, ``, ``, ``, `'). ( ! ) notice: undefined variable: link in c:\wamp\www\xxxxxxxx.php on line 135 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 ( ! ) warning: mysqli_close() expects parameter 1 mysqli, null given in c:\wamp\www\xxxxxxxx.php on line 135 call stack # time memory function location 1 0.0000 346912 {main}( ) ..\xxxxxxxx.php:0 2 0.0468 356368 mysqli_close ( ) ..\xxxxxxxx.php:135*
may can try code :)
<?php if(isset($_post["submit"])) $link = mysqli_connect("localhost", "xxxxxxx", "xxxxxxxx", "xxxxxxxxxxxx"); $engineers = $_post['engineers']; $location = $_post['location']; $site = $_post['site']; $date = $_post['date']; $callref = $_post['callref']; $addcallref = $_post['addcallref']; $adcdrive = $_post['adcdrive']; $adddrive = $_post['adddrive']; $adedrive = $_post['adedrive']; $admemory = $_post['admemory']; $ncdrive = $_post['ncdrive']; $nddrive = $_post['nddrive']; $nedrive = $_post['nedrive']; $nmemory = $_post['nmemory']; $scdrive = $_post['scdrive']; $sedrive = $_post['sedrive']; $smemory = $_post['smemory']; $gpmsdb = $_post['gpmsdb']; $gpmslog = $_post['gpmslog']; $gpmsbackups = $_post['gpmsbackups']; $etsdb = $_post['etsdb']; $etslog = $_post['etslog']; $etsbackups = $_post['etsbackups']; $cmsdb = $_post['cmsdb']; $cmslog = $_post['cmslog']; $cmsbackup = $_post['cmsbackup']; $etsappspc = $_post['etsappspc']; $etsappsedtcont = $_post['etsappsedtcont']; $etsappshub = $_post['etsappshub']; $etsappsies = $_post['etsappsies']; $etsappsexti = $_post['etsappsexti']; $etsappscs = $_post['etsappscs']; $etsappsint = $_post['etsappsint']; $etsappscmssh = $_post['etsappscmssh']; $gpmsappsgtrig = $_post['gpmsappsgtrig']; $gpmsappsgcmet = $_post['gpmsappsgcmet']; $gpmsappsgcinst = $_post['gpmsappsgcinst']; $gpmsappsgmig = $_post['gpmsappsgmig']; $gpmsappsgmcs = $_post['gpmsappsgmcs']; $gpmsappsghist = $_post['gpmsappsghist']; $gpmsappsgop = $_post['gpmsappsgop']; $gpmsappsgext = $_post['gpmsappsgext']; $gpmsappsngc = $_post['gpmsappsngc']; $gpmsappsedl = $_post['gpmsappsedl']; $etsapps14 = $_post['etsapps14']; $etsappsfms = $_post['etsappsfms']; $xsecfdin = $_post['xsecfdin']; $xsecfdout = $_post['xsecfdout']; $xsecfder = $_post['xsecfder']; $xsecfein = $_post['xsecfein']; $xsecfeout = $_post['xsecfeout']; $xsecfeer = $_post['xsecfeer']; $xsecfdarc = $_post['xsecfdarc']; $xsecfearc = $_post['xsecfearc']; $xsecfpdi = $_post['xsecfpdi']; $xsecfpdo = $_post['xsecfpdo']; $xsecfpder = $_post['xsecfpder']; $xsecfpdarc = $_post['xsecfpdarc']; $xsecfpei = $_post['xsecfpei']; $xsecfpeo = $_post['xsecfpeo']; $xsecfpee = $_post['xsecfpee']; $xsecpearc = $_post['xsecpearc']; $adappevents = $_post['adappevents']; $adsysevents = $_post['adsysevents']; $gappevents = $_post['gappevents']; $gsysevents = $_post['gsysevents']; $eappevents = $_post['eappevents']; $etsappstrig = $_post['etsappstrig']; $msmq = $_post['msmq']; $comments = $_post['comments']; $sql = "insert `xxxxxxxxxx`(`xxxxxxxxxxxx_id`, `engineers`, `location`, `site`, `date`, `callref`, `addcallref`, `adcdrive`, `adddrive`, `adedrive`, `admemory`, `lncdrive`, `lnddrive`, `lnedrive`, `lnfdrive`, `lngdrive`, `lnmemory`, `scdrive`, `sddrive`, `sedrive`, `smemory`, `gpmsdb`, `gpmslog`, `gpmsbackups`, `etsdb`, `etslog`, `etsbackups`, `cmsdb`, `cmslog`, `cmsbackups`, `etsappsetrig`, `etsappspc`, `etsappsedtcont`, `etsappshub`, `etsappsiesna`, `etsappsexti`, `etsappscs`, `etsappsint`, `etsappscmssh`, `gpmsappsgtrig`, `gpmsappsgsmet`, `gpmsappsgcinst`, `gpmsappsgmif`, `gpmsappsgmcs`, `gpmsappsghist`, `gpmsappsgop`, `gpmsappsgext`, `gpmsappsngc`, `gpmsappsedl`, `etsapps14`, `etsappsfms`, `xsecfdin`, `xsecfdout`, `xsecfder`, `xsecfdarc`, `xsecdfein`, `xsecfeout`, `xsecfeer`, `xsecfearc`, `xsecfpdi`, `xsecfpdo`, `xsecfpder`, `xsecfpdarc`, `xsecfpei`, `xsecfpeo`, `xsecfpee`, `xsecfpearc`, `adappevents`, `adsysevents`, `gpmsappevents`, `gpmssysevents`, `etsappevents`, `etssysevents`, `gpmsmsmq`, `etsmsmq`, `comments`) values (`$engineers`, `$location`, `$site`, `$date`, `$callref`, `$addcallref`, `$adcdrive`, `$adddrive`, `$adedrive`, `$admemory`, ` $ncdrive`, `$nddrive`, `$nedrive`, `$nmemory`, `$scdrive`, `$sedrive`, `$smemory`, `$gpmsdb`, `$gpmslog`, `$gpmsbackups`, `$etsdb`, `$etslog`, `$etsbackups`, `$cmsdb`, `$cmslog`, `$cmsbackup`, `$etsappspc`, `$etsappsedtcont`, ` $etsappshub`, `$etsappsies`, `$etsappsexti`, `$etsappscs`, `$etsappsint`, `$etsappscmssh`, `$gpmsappsgtrig`, `$gpmsappsgcmet`, `$gpmsappsgcinst`, `$gpmsappsgmig`, `$gpmsappsgmcs`, `$gpmsappsghist`, `$gpmsappsgop`, `$gpmsappsgext`, ` $gpmsappsngc`, `$gpmsappsedl`, `$etsapps14`, `$etsappsfms`, `$xsecfdin`, `$xsecfdout`, `$xsecfder`, `$xsecfein`, `$xsecfeout`, `$xsecfeer`, `$xsecfdarc`, `$xsecfearc`, `$xsecfpdi`, `$xsecfpdo`, `$xsecfpder`, `$xsecfpdarc`, `$xsecfpei`, `$xsecfpeo`, `$xsecfpee`, `$xsecpearc`, `$adappevents`, `$adsysevents`, `$gappevents`, `$gsysevents`, `$eappevents`, `$etsappstrig`, `$msmq`, `$comments')" $result = mysqli_query($link, $sql); if ($result){ // $result true printf("%d row inserted.\n", mysqli_affected_rows($link)); echo "records added successfully."; } else{ // $result false echo "error: not able execute $sql. " . mysqli_error($link); } ?> 
Comments
Post a Comment