html - Data not going into my sql database from php code on webpage -
html - Data not going into my sql database from php code on webpage -
guys want submit info text boxes ect database .. have kept pop box submitted ..into database .. , when execute says entered database database empty..
<?php include('airlinedb2.php'); $nameb1 = @$_post['nameb1']; $ageb1 = @$_post['ageb1']; $genderb1 = @$_post['genderb1']; $prefb1 = @$_post['prefb1']; $planeno = @$_post['planeno']; $pdate = @$_post['pdate']; if (isset($_post['book'])) { //the info entered database here between $insert = mysql_query("insert ticketbook (planeno,nameb,ageb,genderb,preferenceb,date) values('$planeno','$nameb1','$ageb1','$genderb1','$prefb1','$pdate')"); echo '<script type="text/javascript">alert("your ticket booked check email farther details!")</script>'; //the info entered database here between } ?>
there error query, can alter logic this:
$insert = mysql_query("insert ticketbook (planeno,nameb,ageb,genderb,preferenceb,date) values('$planeno','$nameb1','$ageb1','$genderb1','$prefb1','$pdate')"); if ( !$insert ) { die('invalid query: ' . mysql_error()); } else if ( mysql_affected_rows()!=1 ) { die('error inserting row'); } else { echo '<script type="text/javascript">alert("your ticket booked check email farther details!")</script>'; }; php html mysql
Comments
Post a Comment