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

Popular posts from this blog

assembly - What is the addressing mode for ld, add, and rjmp instructions? -

vowpalwabbit - Interpreting Vowpal Wabbit results: Why are some lines appended by "h"? -

Is there a way to convert an HTML page styled with Bootstrap CSS into email-compatible html? -