ksp22 Posted April 14, 2009 Share Posted April 14, 2009 I dont know why I am not able to insert the values of form inside the table..neither I am not getting any error nor values are getting inserted.. I dont know where I lack.. please help me..i am stucked in this place and not able to proceed further HTML code is <body onload="javascript:start();"> <div></div> <table align="center" border="0"><tr><td> <div id="dlg"> <!--div class="fld" align="center" valign="top"><h3>Free Sweepstakes Form</h3></div--> <div id="regFormOn"> <form name="regForm" method="post" action="login.php" onsubmit="return validation(this);"> <table border="0" cellpadding="5" width="10%"> <tr><td align="center" valign="top" colspan="3"> <h3>Free Sweepstakes Form</h3></td></tr> <tr><td class="fld" nowrap>Email Address</td><td colspan="2"><input type="text" size="50" name="email1" id="email1"></td></tr> <tr><td class="fld" nowrap>Name</td><td colspan="2"><input type="text" size="50" name="nme" id="nme"></td></tr> <tr><td class="fld" nowrap>Address1</td><td colspan="2"><input type="text" size="50" name="address1" id="address1"></td></tr> <tr><td class="fld" nowrap>Address2</td><td colspan="2"><input type="text" size="50" name="address2" id="address2"></td></tr> <tr><td class="fld" nowrap>Town/City/Suburb</td><td colspan="2"><input type="text" size="50" name="city" id="city"></td></tr> <tr><td class="fld" nowrap>State/Province/County</td><td colspan="2"><input type="text" size="50" name="province" id="province"></td></tr> <tr><td class="fld" nowrap>Zip/Postal Code</td><td colspan="2"><input type="text" size="50" name="zip" id="zip"></td></tr> <tr><td class="fld" nowrap>Country</td><td align="left"><select name="ctry" onchange="javascript:setOther();" id="ctry"><option value="0" selected>Select Country</option> <option value="1">Australia</option> <option value="2">Austria</option> <option value="3">Belgium</option> <option value="4">Canada</option> <option value="5">Denmark</option> <option value="6">Finland</option> <option value="7">France</option> <option value="8">Germany</option> <option value="9">Ireland</option> <option value="10">Italy</option> <option value="11">Japan</option> <option value="12">Mexico</option> <option value="13">Netherlands</option> <option value="14">New Zealand</option> <option value="15">Norway</option> <option value="16">Poland</option> <option value="17">Portugal</option> <option value="18">Singapore</option> <option value="19">South Africa</option> <option value="20">Spain</option> <option value="21">Sweden</option> <option value="22">Switzerland</option> <option value="23">United Kingdom</option> <option value="24">United States</option> <option value="25">Other</option> </select> </td> <td><input type="text" id="other_ctry" size="27" style="display:none;"></td></tr> <tr><td class="fld" nowrap>Choose Password</td><td colspan="2"><input type="password" size="50" name="pwd1" id="pwd1"></td></tr> <tr><td class="fld" nowrap>Confirm Password</td><td colspan="2"><input type="password" size="50" name="pwd2" id="pwd2"></td></tr> <tr><td colspan="3" align="center"><input type="submit" name="Submit1" value="Submit" > <input type="button" name="exac" value="Existing User..." onclick="javascript:toggleOnOff('regForm',false)"> <input type="button" name="Cancel1" value="Cancel" onclick="javascript:toggle('dlg')"></td></tr> </table> </form> </div> login.php is $con = mysql_connect('localhost','root',''); if (!$con) { die('Could not connect: ' . mysql_error()); } else { echo 'Connected successfully'; } mysql_select_db("player_information") or die(mysql_error()); $email1 = $_POST['email1']; $nme = $_POST['nme']; $address1 = $_POST['address1']; $address2 = $_POST['address2']; $city = $_POST['city']; $province = $_POST['province']; $zip = $_POST['zip']; $ctry = $_POST['ctry']; $other_ctry = $_POST['other_ctry']; $pwd1 = $_POST['pwd1']; $cash_credit = $_POST['cash_credit'];*/ $q=("INSERT INTO player (email1, nme, address1, address2, city, province, zip, ctry, other_ctry, pwd1, cash_credit) VALUES('$nme','$email1','$address1','$address2','$city','$province','$zip','$ctry','$other_ctry','$pwd1','$cash_credit')"); mysql_query($q,$con) or die(mysql_error()); mysql_close($con) ?> I need help..Please help me Thanx in advance Quote Link to comment Share on other sites More sharing options...
okamosy Posted April 14, 2009 Share Posted April 14, 2009 It might be useful if you could post the error that you are getting. But right off the bat, there's a couple of things you should check: email1 and nme are switched in the insert statement (you list the columns as nme, email1 - but the strings are '$email1', '$nme') you really should be verifying the results from the form to make sure they are what you expect you should be escaping the strings with mysql_real_escape_string() I'm not 100% on this one, but you don't need the parentheses around the query string, off the top of my head, I'm not sure how PHP will handle that['li] Quote Link to comment Share on other sites More sharing options...
ksp22 Posted April 15, 2009 Author Share Posted April 15, 2009 Thanx for the help.. I tried this also but still i am not able to insert the values inside the table and i am not getting any error..its working correctly without any error....but not giving me the desired result and now login.php is <?php $con = mysql_connect('localhost','root',''); if (!$con) { die('Could not connect: ' . mysql_error()); } else { echo 'Connected successfully'; } mysql_select_db("player_information") or die(mysql_error()); $nme = $_POST['nme']; $email1 = $_POST['email1']; $address1 = $_POST['address1']; $address2 = $_POST['address2']; $city = $_POST['city']; $province = $_POST['province']; $zip = $_POST['zip']; $ctry = $_POST['ctry']; $other_ctry = $_POST['other_ctry']; $pwd1 = $_POST['pwd1']; $cash_credit = $_POST['cash_credit']; $q=("INSERT INTO player (email1, nme, address1, address2, city, province, zip, ctry, other_ctry, pwd1, cash_credit) VALUES('$nme','$email1','$address1','$address2','$city','$province','$zip','$ctry','$other_ctry','$pwd1','$cash_credit')"); $sql=sprintf("INSERT INTO player (email1, nme, address1, address2, city, province, zip, ctry, other_ctry, pwd1, cash_credit) VALUES ('%s','%s',%s','%s',%s','%s',%s','%s',%s','%s',%s','%s')", mysql_real_escape_string($_POST['email1']), mysql_real_escape_string($_POST['nme']), mysql_real_escape_string($_POST['address1']), mysql_real_escape_string($_POST['address2']), mysql_real_escape_string($_POST['city']), mysql_real_escape_string($_POST['province']), mysql_real_escape_string($_POST['zip']), mysql_real_escape_string($_POST['ctry']), mysql_real_escape_string($_POST['other_ctry']), mysql_real_escape_string($_POST['pwd1']), mysql_real_escape_string($_POST['cash_credit'])); mysql_query($q , $con) or die(mysql_error()); mysql_close($con) ?> still no output Quote Link to comment Share on other sites More sharing options...
danieliser Posted April 15, 2009 Share Posted April 15, 2009 you dont really need to list the table colums.. not sure that its causing the problem but try this <?php $q=("INSERT INTO player VALUES('$email1','$nme','$address1','$address2','$city','$province','$zip','$ctry','$other_ctry','$pwd1','$cash_credit')"); ?> Quote Link to comment Share on other sites More sharing options...
ksp22 Posted April 15, 2009 Author Share Posted April 15, 2009 But What I know is that it will not create any problem even if i use table elements or not..its still not working I did all the possible things but i dont know why it is not working Quote Link to comment Share on other sites More sharing options...
danieliser Posted April 15, 2009 Share Posted April 15, 2009 Do you get the connection successful echo? Quote Link to comment Share on other sites More sharing options...
mandred Posted April 15, 2009 Share Posted April 15, 2009 replace mysql_close($con) with mysql_close($con); Quote Link to comment Share on other sites More sharing options...
ksp22 Posted April 16, 2009 Author Share Posted April 16, 2009 yes i get connection successful echo whwn i run login.php individually..and when i run newslot.html file then nothing is displayed... not even any error.. if i use $sql=sprintf("INSERT INTO player (email1, nme, address1, address2, city, province, zip, ctry, other_ctry, pwd1, cash_credit) VALUES ('%s','%s',%s','%s',%s','%s',%s','%s',%s','%s',%s','%d')", mysql_real_escape_string($_POST['email1']), mysql_real_escape_string($_POST['nme']), mysql_real_escape_string($_POST['address1']), mysql_real_escape_string($_POST['address2']), mysql_real_escape_string($_POST['city']), mysql_real_escape_string($_POST['province']), mysql_real_escape_string($_POST['zip']), mysql_real_escape_string($_POST['ctry']), mysql_real_escape_string($_POST['other_ctry']), mysql_real_escape_string($_POST['pwd1']), mysql_real_escape_string($_POST['cash_credit'])); this code then one erroe occurs ans that is : Connected successfully Warning: sprintf() [function.sprintf]: Too few arguments in C:\xampp\htdocs\3slot\login.php on line 46 Query was empty and if i use $q=("INSERT INTO player (email1, nme, address1, address2, city, province, zip, ctry, other_ctry, pwd1, cash_credit) VALUES('$email1','$nme','$address1','$address2','$city','$province','$zip','$ctry','$other_ctry','$pwd1','$cash_credit')"); this query then o error occurs it displays : Connected successfully still no result where I am lacking i dont knw Quote Link to comment Share on other sites More sharing options...
danieliser Posted April 16, 2009 Share Posted April 16, 2009 are you using includes in your html? post the html or at least the part in question. Quote Link to comment Share on other sites More sharing options...
ksp22 Posted April 17, 2009 Author Share Posted April 17, 2009 Hey Thanx for replying I had posted my html file in my first post..but anyways..i"ll post my html file again <body onload="javascript:start();"> <div></div> <table align="center" border="0"><tr><td> <div id="dlg"> <!--div class="fld" align="center" valign="top"><h3>Free Sweepstakes Form</h3></div--> <div id="regFormOn"> <form name="regForm" onsubmit="return validation(this);" action="login.php" method="post"> <table border="0" cellpadding="5" width="10%"> <tr><td align="center" valign="top" colspan="3"> <h3>Free Sweepstakes Form</h3></td></tr> <tr><td class="fld" nowrap>Email Address</td><td colspan="2"><input type="text" size="50" name="email1" id="email1"></td></tr> <tr><td class="fld" nowrap>Name</td><td colspan="2"><input type="text" size="50" name="nme" id="nme" value=""></td></tr> <tr><td class="fld" nowrap>Address1</td><td colspan="2"><input type="text" size="50" name="address1" id="address1"></td></tr> <tr><td class="fld" nowrap>Address2</td><td colspan="2"><input type="text" size="50" name="address2" id="address2"></td></tr> <tr><td class="fld" nowrap>Town/City/Suburb</td><td colspan="2"><input type="text" size="50" name="city" id="city"></td></tr> <tr><td class="fld" nowrap>State/Province/County</td><td colspan="2"><input type="text" size="50" name="province" id="province"></td></tr> <tr><td class="fld" nowrap>Zip/Postal Code</td><td colspan="2"><input type="text" size="50" name="zip" id="zip"></td></tr> <tr><td class="fld" nowrap>Country</td><td align="left"><select name="ctry" onchange="javascript:setOther();" id="ctry"><option value="0" selected>Select Country</option> <option value="1">Australia</option> <option value="2">Austria</option> <option value="3">Belgium</option> <option value="4">Canada</option> <option value="5">Denmark</option> <option value="6">Finland</option> <option value="7">France</option> <option value="8">Germany</option> <option value="9">Ireland</option> <option value="10">Italy</option> <option value="11">Japan</option> <option value="12">Mexico</option> <option value="13">Netherlands</option> <option value="14">New Zealand</option> <option value="15">Norway</option> <option value="16">Poland</option> <option value="17">Portugal</option> <option value="18">Singapore</option> <option value="19">South Africa</option> <option value="20">Spain</option> <option value="21">Sweden</option> <option value="22">Switzerland</option> <option value="23">United Kingdom</option> <option value="24">United States</option> <option value="25">Other</option> </select> </td> <td><input type="text" id="other_ctry" size="27" style="display:none;"></td></tr> <tr><td class="fld" nowrap>Choose Password</td><td colspan="2"><input type="password" size="50" name="pwd1" id="pwd1"></td></tr> <tr><td class="fld" nowrap>Confirm Password</td><td colspan="2"><input type="password" size="50" name="pwd2" id="pwd2"></td></tr> <tr><td colspan="3" align="center"><input type="submit" name="Submit1" value="Submit" onclick="sendRequest()"> <input type="button" name="exac" value="Existing User..." onclick="javascript:toggleOnOff('regForm',false)"> <input type="button" name="Cancel1" value="Cancel" onclick="javascript:toggle('dlg')"></td></tr> </table> </form> </div> <div id="regFormOff" style="display:none;"> <table border="0" colspan="2"> <tr><td class="fld">Email Address</td><td><input type="text" name="email2" id="email2"></td></tr> <tr><td class="fld">Choose a Password</td><td><input type="password" name="pwd3" id="pwd3"></td></tr> <tr><td align="center" colspan="2"><input type="button" name="Submit2" value="Login..."> <input type="button" name="newac" value="Create new account" onclick="javascript:toggleOnOff('regForm',true)"> <input type="button" name="Cancel2" value="Cancel" onclick="javascript:toggle('dlg')"></td></tr> </table> </div> </div> Quote Link to comment Share on other sites More sharing options...
Andy-H Posted April 17, 2009 Share Posted April 17, 2009 $cash_credit = $_POST['cash_credit'];*/ Why do you close a comment at that part, is the comment block opened in another part of the script? Also you could use: array_map("mysql_real_escape_string", $_POST); $email1 = $_POST['email1']; $nme = $_POST['nme']; $address1 = $_POST['address1']; $address2 = $_POST['address2']; $city = $_POST['city']; $province = $_POST['province']; $zip = $_POST['zip']; $ctry = $_POST['ctry']; $other_ctry = $_POST['other_ctry']; $pwd1 = $_POST['pwd1']; $cash_credit = $_POST['cash_credit']; As all of the postdata is being used for a query. Quote Link to comment Share on other sites More sharing options...
danieliser Posted April 17, 2009 Share Posted April 17, 2009 Have you tried testing to see if the values are getting sent? test by using echo $email1; that will at least eliminate the variables and the post.. if that works then its in your sql or database.. Quote Link to comment Share on other sites More sharing options...
ksp22 Posted April 17, 2009 Author Share Posted April 17, 2009 When i try to echo $email1; it does not print any thing.. actually what i can understand is that it is not taking values from the form when i try to print $_POST['email1'] it print nothing..but i dont know why its not taking any value from the form Quote Link to comment Share on other sites More sharing options...
ksp22 Posted April 17, 2009 Author Share Posted April 17, 2009 <body onload="javascript:start();"> <div></div> <table align="center" border="0"><tr><td> <div id="dlg"> <!--div class="fld" align="center" valign="top"><h3>Free Sweepstakes Form</h3></div--> <div id="regFormOn"> <form name="regForm" onsubmit="return validation(this);" action="login.php" method="post"> <table border="0" cellpadding="5" width="10%"> <tr><td align="center" valign="top" colspan="3"> <h3>Free Sweepstakes Form</h3></td></tr> <tr><td class="fld" nowrap>Email Address</td><td colspan="2"><input type="text" size="50" name="email1" id="email1"></td></tr> <tr><td class="fld" nowrap>Name</td><td colspan="2"><input type="text" size="50" name="nme" id="nme" value=""></td></tr> <tr><td class="fld" nowrap>Address1</td><td colspan="2"><input type="text" size="50" name="address1" id="address1"></td></tr> <tr><td class="fld" nowrap>Address2</td><td colspan="2"><input type="text" size="50" name="address2" id="address2"></td></tr> <tr><td class="fld" nowrap>Town/City/Suburb</td><td colspan="2"><input type="text" size="50" name="city" id="city"></td></tr> <tr><td class="fld" nowrap>State/Province/County</td><td colspan="2"><input type="text" size="50" name="province" id="province"></td></tr> <tr><td class="fld" nowrap>Zip/Postal Code</td><td colspan="2"><input type="text" size="50" name="zip" id="zip"></td></tr> <tr><td class="fld" nowrap>Country</td><td align="left"><select name="ctry" onchange="javascript:setOther();" id="ctry"><option value="0" selected>Select Country</option> <option value="1">Australia</option> <option value="2">Austria</option> <option value="3">Belgium</option> <option value="4">Canada</option> <option value="5">Denmark</option> <option value="6">Finland</option> <option value="7">France</option> <option value="8">Germany</option> <option value="9">Ireland</option> <option value="10">Italy</option> <option value="11">Japan</option> <option value="12">Mexico</option> <option value="13">Netherlands</option> <option value="14">New Zealand</option> <option value="15">Norway</option> <option value="16">Poland</option> <option value="17">Portugal</option> <option value="18">Singapore</option> <option value="19">South Africa</option> <option value="20">Spain</option> <option value="21">Sweden</option> <option value="22">Switzerland</option> <option value="23">United Kingdom</option> <option value="24">United States</option> <option value="25">Other</option> </select> </td> <td><input type="text" id="other_ctry" size="27" style="display:none;"></td></tr> <tr><td class="fld" nowrap>Choose Password</td><td colspan="2"><input type="password" size="50" name="pwd1" id="pwd1"></td></tr> <tr><td class="fld" nowrap>Confirm Password</td><td colspan="2"><input type="password" size="50" name="pwd2" id="pwd2"></td></tr> <tr><td colspan="3" align="center"><input type="submit" name="Submit1" value="Submit" onclick="sendRequest()"> <input type="button" name="exac" value="Existing User..." onclick="javascript:toggleOnOff('regForm',false)"> <input type="button" name="Cancel1" value="Cancel" onclick="javascript:toggle('dlg')"></td></tr> </table> </form> </div> <div id="regFormOff" style="display:none;"> <table border="0" colspan="2"> <tr><td class="fld">Email Address</td><td><input type="text" name="email2" id="email2"></td></tr> <tr><td class="fld">Choose a Password</td><td><input type="password" name="pwd3" id="pwd3"></td></tr> <tr><td align="center" colspan="2"><input type="button" name="Submit2" value="Login..."> <input type="button" name="newac" value="Create new account" onclick="javascript:toggleOnOff('regForm',true)"> <input type="button" name="Cancel2" value="Cancel" onclick="javascript:toggle('dlg')"></td></tr> </table> </div> </div> <div class="slot-main" align="center"> <div class="slot-main-body"> <div class="slot-well"> <div class="slot-payline"></div> <div id="slot-reel0"><div id="slot00"></div><div id="slot01"></div></div> <div id="slot-reel1"><div id="slot10"></div><div id="slot11"></div></div> <div id="slot-reel2"><div id="slot20"></div><div id="slot21"></div></div> <div class="slot-shadow"></div> </div> <div class="slot-reel-point"> <div id="paid"> <div id="paid0"></div> <div id="paid1"></div> <div id="paid2"></div> <div id="paid3"></div> </div> <div id="credits"> <div id="credits0"></div> <div id="credits1"></div> <div id="credits2"></div> <div id="credits3"></div> </div> <div id="coins"> <div id="coins3"></div> </div> <div id="links"> <table border="0"><tr valign="middle"> <td id="sound" width="50%"></td> <td><a onclick="javascript:addMoreCredits()" id="add_credits" style="display:none;" border="0"><img src="images/addcredits_small.png"></a> </td> </tr></table> </div> </div> <div class="slot-button-body" align="center"> <table border="0"> <tr> <td align="center"> <a class="slot-button-left-on" href="#" id="cashCreditOn" onclick="javascript:toggle('dlg');"> <img src="images/cash_credit_button_text.png" alt="Cash / Credit" class="slot-button-text"> </a> <a class="slot-button-left-off" id="cashCreditOff" style="display:none;"> <img src="images/cash_credit_button_text.png" alt="Cash / Credit" class="slot-button-text"> </a> </td> <!-- --> <td align="center"> <a class="slot-button-left-on" href="#" id="betOneOn" onclick="javascript:betOne()"> <img src="images/bet_one_button_text.png" alt="Bet One" class="slot-button-text"> </a> <a class="slot-button-left-off" id="betOneOff" style="display:none;"> <img src="images/bet_one_button_text.png" alt="Bet One" class="slot-button-text"> </a> </td> <!-- --> <td align="center"> <a class="slot-button-right-on" href="#" id="betMaxOn" onclick="javascript:betMax()"> <img src="images/bet_max_button_text.png" alt="Bet Max" class="slot-button-text"> </a> <a class="slot-button-right-off" id="betMaxOff" style="display:none;"> <img src="images/bet_max_button_text.png" alt="Bet Max" class="slot-button-text"> </a> </td> <!-- --> <td align="center"> <a class="slot-button-right-on" href="#" id="spinReelsOn" onclick="javascript:spinReels();" > <img src="images/spin_reels_button_text.png" alt="Spin Reels" class="slot-button-text"> </a> <a class="slot-button-right-off" id="spinReelsOff" style="display:none;"> <img src="images/spin_reels_button_text.png" alt="Spin Reels" class="slot-button-text"> </a> </td> </tr></table> <!-- --> </div> <div class="slot-paytable"></div> </div> </div></td></tr></table> </body> </html> this is my complete html file... i have used togglr function to display the form after cliking the form button and this form appears like a pop up..is this method is creating problem Quote Link to comment Share on other sites More sharing options...
Andy-H Posted April 17, 2009 Share Posted April 17, 2009 Add this at the top of the page a sec. print_r($_POST); echo '<br><br>'; die("Post data printed."); Then post the form and please post us the results. Quote Link to comment Share on other sites More sharing options...
danieliser Posted April 17, 2009 Share Posted April 17, 2009 so its not loading because the form doesnt load till after the page loads and the variables have been posted because you have to click the button to load the form.. hmm.. not sure if you can work around that.. Quote Link to comment Share on other sites More sharing options...
ksp22 Posted April 17, 2009 Author Share Posted April 17, 2009 @Andy-H i did what you told me ..but its not giving any error..nothing is printed...no error nothing same result Quote Link to comment Share on other sites More sharing options...
ksp22 Posted April 17, 2009 Author Share Posted April 17, 2009 @danieliser so what i need to do for this... can you help me Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.