php - Problem with my registration form. Not inserting second query -
first of sorry language. doing shopping cart application assignment college. have problem registration for. problem is inserting first query
$addsql = "insert customers(forename, surname, add1, add2, add3, postcode, phone, email, registered) values('" . strip_tags(addslashes($_post['forenamebox'])) . "', '" . strip_tags(addslashes($_post['surnamebox'])) . "', '" . strip_tags(addslashes($_post['add1box'])) . "', '" . strip_tags(addslashes($_post['add2box'])) . "', '" . strip_tags(addslashes($_post['add3box'])) . "', '" . strip_tags(addslashes($_post['postcodebox'])) . "', '" . strip_tags(addslashes($_post['phonebox'])) . "', '" . strip_tags(addslashes($_post['emailbox'])) . "', 1)"; mysql_query($addsql); and not insert second one.
$customer_id = mysql_insert_id(); // gets id of last mysql insert query $insert_query = 'insert logins ( username, password, customer_id ) values ( "' . $_post['userregbox'] . '", "' . md5($_post['passregbox']) . '", "' . $customer_id . '", )'; mysql_query($insert_query); header("location: " . $basedir . "login.php?ok=1"); i tried different approaches no result. using xammp.
here full code
<?php session_start(); require_once("db.php"); /* checking if user logged in, if not redirecting main page */ if(isset($_session['sess_loggedin']) == true) { header("location: " . $config_basedir); } if($_post['login']) { $loginsql = "select * logins username = '" . $_post['userbox'] . "' , password = '" . $_post['passbox'] . "'"; $loginres = mysql_query($loginsql); $numrows = mysql_num_rows($loginres); if($numrows == 1) { $loginrow = mysql_fetch_assoc($loginres); session_register("sess_loggedin"); session_register("sess_username"); session_register("sess_userid"); $_session['sess_loggedin'] = 1; $_session['sess_username'] = $loginrow['username']; $_session['sess_userid'] = $loginrow['id']; $ordersql = "select id orders customer_id = " . $_session['sess_userid'] . " , status <2"; $orderres = mysql_query($ordersql); $orderrow = mysql_fetch_assoc($orderres); session_register("sess_ordernum"); $_session['sess_ordernum'] = $orderrow['id']; header("location: " . $config_basedir); } else { header("location: http://" . $http_host . $script_name . "?error=1"); } } if($_post['register']) { $loginchecksql = "select * logins username = '" . $_post['userbox'] . "'"; $logincheckres = mysql_query($loginchecksql); $loginchecknumrows = mysql_num_rows($logincheckres); if($loginchecknumrows == 1) { header("location: http://" . $http_host . $script_name . "?error=3"); } else{ if(empty($_post['forenamebox']) || empty($_post['surnamebox']) || empty($_post['add1box']) || empty($_post['add2box']) || empty($_post['add3box']) || empty($_post['postcodebox']) || empty($_post['phonebox']) || empty($_post['userregbox']) || empty($_post['passregbox']) || empty($_post['emailbox'])) { header("location: " . $basedir . "login.php?error=2"); exit; } $addsql = "insert customers(forename, surname, add1, add2, add3, postcode, phone, email, registered) values('" . strip_tags(addslashes($_post['forenamebox'])) . "', '" . strip_tags(addslashes($_post['surnamebox'])) . "', '" . strip_tags(addslashes($_post['add1box'])) . "', '" . strip_tags(addslashes($_post['add2box'])) . "', '" . strip_tags(addslashes($_post['add3box'])) . "', '" . strip_tags(addslashes($_post['postcodebox'])) . "', '" . strip_tags(addslashes($_post['phonebox'])) . "', '" . strip_tags(addslashes($_post['emailbox'])) . "', 1)"; mysql_query($addsql); $customer_id = mysql_insert_id(); // gets id of last mysql insert query $insert_query = 'insert logins ( username, password, customer_id ) values ( "' . $_post['userregbox'] . '", "' . md5($_post['passregbox']) . '", "' . $customer_id . '", )'; mysql_query($insert_query); header("location: " . $basedir . "login.php?ok=1"); } } else { require_once("header.php"); ?> <?php if($_get['ok'] == 1) { echo "<b>your registration succesfull</b><p>start shooping now</p>"; } else { ?> <?php if($_get['error'] == 1) { echo "<b>incorrect details, please try again</b>"; } ?> <?php if($_get['error'] == 2) { echo "<b>please fill fields</b>"; } ?> <?php if($_get['error'] == 3) { echo "<b>user name exist</b>"; } ?> <div style="width:50%;float:left;"> <fieldset style="width:90%;background:#fff; "> <legend>customer login</legend> <form action="<?php echo $script_name; ?>" method="post"> <ul> <li> <fieldset> <legend>username</legend> <div> <input type="textbox" name="userbox" class="text" /> </div> <p class="guidelines">please enter username</p> </fieldset> </li> <li> <fieldset> <legend>password</legend> <div> <input type="password" name="passbox" class="text" /> </div> <p class="guidelines">please enter password</p> </fieldset> </li> <li> <button type="submit" name="login" value="login">log in</button> </li> </ul> </form> </fieldset> </div> <div style="width:50%;float:right;"> <fieldset style="width:95%;background:#fff; "> <legend>register</legend> <form action="<?php echo $script_name; ?>" method="post"> <ul> <li> <fieldset> <legend>username</legend> <div> <input type="textbox" name="userregbox" class="text" /> </div> <p class="guidelines">please enter username</p> </fieldset> </li> <li> <fieldset> <legend>password</legend> <div> <input type="password" name="passregbox" class="text" /> </div> <p class="guidelines">please enter password</p> </fieldset> </li> <li> <fieldset> <legend>delivery details</legend> <table style="width:99%;"> <tr> <td>forename</td> <td><input type="text" name="forenamebox" class="text"></td> </tr> <tr> <td>surname</td> <td><input type="text" name="surnamebox" class="text"></td> </tr> <tr> <td>house number, street</td> <td><input type="text" name="add1box" class="text"></td> </tr> <tr> <td>town/city</td> <td><input type="text" name="add2box" class="text"></td> </tr> <tr> <td>county</td> <td><input type="text" name="add3box" class="text"></td> </tr> <tr> <td>postcode</td> <td><input type="text" name="postcodebox" class="text"></td> </tr> <tr> <td>phone</td> <td><input type="text" name="phonebox" class="text"></td> </tr> <tr> <td>email</td> <td><input type="text" name="emailbox"class="text"></td> </tr> </table> </fieldset> </li> <li> <button type="submit" name="register" value="register">register</button> </li> </ul> </form> </fieldset> </div> <?php } } require_once("footer.php"); ?>
you have comma.
change
"' . $customer_id . '", to
"' . $customer_id . '" in insert logins query.
Comments
Post a Comment