erikn68 Posted March 15, 2012 Share Posted March 15, 2012 While doing a website in php using mysql db I get the unable to register error: Below is my code, if anyone can help. ajaxinsert.php file <?php $username=$_POST['username']; $password=$_POST['password']; $mobile=$_POST['mobile']; $email=$_POST['email']; $Fname=$_POST['Fname']; $Lname=$_POST['Lname']; $street=$_POST['street']; $city=$_POST['city']; $state=$_POST['state']; $zip=$_POST['zip']; mysql_connect("localhost","webspace_er5","c6b7s9t1") or die(mysql_error()); $query=mysql_query("INSERT INTO Registration (`username`, `date`, `email`, `password`, `mobile`, `Fname`, `Lname`, `street`, `state`, `zip`, `ip`) VALUES ('', '$username', '$date('d-m-Y')', '$email', '$password', '$mobile', '$Fname', '$Lname','$street', '$city', '$state', '$zip', '".$_SERVER['REMOTE_ADDR']."')"); mysql_select_db("webspace_eriknel1") or die(mysql_error()); if($query) { ?> <div style="color:#008000; font-weight:bold;">Registered successfully..!!</div> <?php }else { ?> <div style="color:#c24f00; font-weight:bold;">unable to register !!</div> <?php } ?> Registration.html file code <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Registration Form</title> <style type="text/css"> <!-- body,td,th { font-family: Trebuchet MS, Arial, Helvetica, sans-serif; font-size: 12px; color: #333; } body { margin-left: 0px; margin-top: 30px; margin-right: 0px; margin-bottom: 0px; } .maindiv{ width:600px; margin:0 auto;} .textbox{ padding:2px 4px; width:200px;} .submit{ border:solid 1px #008000; background:#008000; color:#FFF; font-weight:bold;} --> </style> <script type="text/javascript" src="ajaxjquery.js"></script> <script type="text/javascript"> $(document).ready(function() { $("#register").click(function(){ var element = $(this); var Id = element.attr("id"); var loadplacecomment = $("#message"); var username = $("#username").val(); var password = $("#password").val(); var email = $("#email").val(); var Fname = $("#Fname").val(); var Lname = $("#Lname").val(); var mobile = $("#mobile").val(); var street = $("#street").val(); var city = $("#city").val(); var state = $("#state").val(); var zip = $("#zip").val(); var dataString = 'username='+ username + '&password='+ password + '&email='+ email + '&Fname='+ Fname + '&Lname=' + Lname +'&mobile='+ mobile + '&street='+ street + '&city='+ city + '&state='+ state + '&zip='+ zip; //alert(dataString); if(username==''|| password=='' || email=='' || mobile=='') { alert("Please Enter all the Fields"); } else { $("#flash").show(); $("#flash").fadeIn(400).html('<img src="ajax-loader.gif" align="absmiddle"> loading.....'); $.ajax({ type: "POST", url: "ajaxinsert.php", data: dataString, cache: false, success: function(html){ loadplacecomment.html(''); $("#message").append(html); $("#flash").hide(); } }); } return false;});}); </script> </head> <body> <div style="display:none;"><img src="ajax-loader.gif" /></div> <div style="text-align:center;"> <h1 style="color:#CCC;">Registration Form</h1></div> <div class="maindiv"> <form method="post"> <table width="100%" border="0" cellpadding="2" cellspacing="2"> <tr> <td colspan="3" align="left" valign="middle" bgcolor="#008000"><div style="margin:0px 10px; font-weight:bold; color:#FFF; font-size:16px;">Registration Form</div></td> </tr> <tr> <td colspan="3" align="left" valign="middle"> <div id="flash"></div> <div id="message"></div> </td> </tr> <tr> <td width="13%" align="left" valign="middle"><strong>Userame</strong></td> <td width="2%" align="left" valign="middle">:</td> <td width="85%" align="left" valign="middle"><label> <input name="username" type="text" class="textbox" id="username" /> </label></td> </tr> <tr> <td width="13%" align="left" valign="middle"><strong>Password</strong></td> <td width="2%" align="left" valign="middle">:</td> <td width="85%" align="left" valign="middle"><label> <input name="password" type="password" class="textbox" id="password" /> </label></td> </tr> <tr> <td align="left" valign="middle"><strong>Email</strong></td> <td align="left" valign="middle">:</td> <td align="left" valign="middle"><label> <input name="email" type="text" class="textbox" id="email" /> </label></td> </tr> <tr> <td align="left" valign="middle"><strong>First Name</strong></td> <td align="left" valign="middle">:</td> <td align="left" valign="middle"><label> <input name="Fname" type="text" class="texbox" id="Fname" /> </label></td> </tr> <tr> <td align="left" valign="middle"><strong>Last Name</strong></td> <td align="left" valign="middle">:</td> <td align="left" valign="middle"><label> <input name="Lname" type="text" class="texbox" id="Lname" /> </label></td> </tr> <tr> <td align="left" valign="middle"><strong>Street</strong></td> <td align="left" valign="middle">:</td> <td align="left" valign="middle"><label> <input name="street" type="text" class="texbox" id="street" /> </label></td> </tr> <tr> <td align="left" valign="middle"><strong>City</strong></td> <td align="left" valign="middle">:</td> <td align="left" valign="middle"><label> <input name="city" type="text" class="texbox" id="city" /> </label></td> </tr> <tr> <td align="left" valign="middle"><strong>State</strong></td> <td align="left" valign="middle">:</td> <td align="left" valign="middle"><label> <input name="state" type="text" class="texbox" id="state" /> </label></td> </tr> <tr> <td align="left" valign="middle"><strong>Zipcode</strong></td> <td align="left" valign="middle">:</td> <td align="left" valign="middle"><label> <input name="zip" type="text" class="texbox" id="zip" /> </label></td> </tr> <tr> <td align="left" valign="middle"><strong>Cellphone</strong></td> <td align="left" valign="middle">:</td> <td align="left" valign="middle"><label> <input name="mobile" type="text" class="textbox" id="mobile" /> </label></td> </tr> <tr> <td align="left" valign="middle"> </td> <td align="left" valign="middle"> </td> <td align="left" valign="middle"><label> <input name="register" type="button" class="submit" id="register" value="Register" /> </label></td> </tr> </table> </form> </div> </body> </html> Any suggestions would be nice. Erik Quote Link to comment https://forums.phpfreaks.com/topic/258998-mysql-gets-unable-to-register/ Share on other sites More sharing options...
mikosiko Posted March 15, 2012 Share Posted March 15, 2012 the evident error in your code is that you are trying to execute the query before select the db, therefore your query should be failing... change the position of those 2 lines and check Quote Link to comment https://forums.phpfreaks.com/topic/258998-mysql-gets-unable-to-register/#findComment-1327765 Share on other sites More sharing options...
erikn68 Posted March 15, 2012 Author Share Posted March 15, 2012 I switched the code and I am now getting this error: Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'webspace'@'localhost' (using password: NO) in /home/webspace/public_html/Erik.Nelson/ajaxinsert.php on line 13 Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/webspace/public_html/Erik.Nelson/ajaxinsert.php on line 13 Access denied for user 'webspace'@'localhost' (using password: NO) here is the php file code <?php $username=$_POST['username']; $password=$_POST['password']; $mobile=$_POST['mobile']; $email=$_POST['email']; $Fname=$_POST['Fname']; $Lname=$_POST['Lname']; $street=$_POST['street']; $city=$_POST['city']; $state=$_POST['state']; $zip=$_POST['zip']; mysql_select_db("webspace_eriknel1") or die(mysql_error()); mysql_connect("localhost","webspace_er5","c6b7s9t1") or die(mysql_error()); $query=mysql_query("INSERT INTO Registration (`username`, `date`, `email`, `password`, `mobile`, `Fname`, `Lname`, `street`, `state`, `zip`, `ip`) VALUES ('', '$username', '$date('d-m-Y')', '$email', '$password', '$mobile', '$Fname', '$Lname','$street', '$city', '$state', '$zip', '".$_SERVER['REMOTE_ADDR']."')"); if($query) { ?> <div style="color:#008000; font-weight:bold;">Registered successfully..!!</div> <?php }else { ?> <div style="color:#c24f00; font-weight:bold;">unable to register !!</div> <?php } ?> Quote Link to comment https://forums.phpfreaks.com/topic/258998-mysql-gets-unable-to-register/#findComment-1327789 Share on other sites More sharing options...
fenway Posted March 17, 2012 Share Posted March 17, 2012 Please stop posting your code. And you really shouldn't be posting your DB credentials either -- but as you'll notice from the error message, you're not actually using the password. Quote Link to comment https://forums.phpfreaks.com/topic/258998-mysql-gets-unable-to-register/#findComment-1328412 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.