Can anyone help to debug php code for signup

Can anyone help to debug php code for signup
0

#1
<?php

	$con='petstore';
	// Connect to the database

		$con = mysqli_connect("localhost","root","",$con);
		if(! $con)
		{
			die('Connection Failed'.mysqli_error());
			
		}
		// Make sure we connected successfully

			if(isset($_POST['register'])){	
			  session_start();
		      $s = "select (max(id)+1) from reg";
			 
			  $result = mysqli_query($con,$s);
			  $row = mysqli_fetch_row($result);
			  
			  
			  
				
				$uname = $_POST['username'];
				$email = $_POST['email'];
				$pass = $_POST['password'];
				$pass1 = $_POST['password1'];
				
		  		if($pass == $pass1){
					
					$s1= "insert into 'reg' (id , username , password , email) values($result,'$uname','$pass','$email')";
					mysqli_query($con,$s1);
					echo $_SESSION['message']="You are now Registered";
					$_SESSION['username']=$uname;
					echo "hello";
					//header("location: ."); //redirect to home page
			}
				else{
					$_SESSION['message']="Paaswords do not match";
			}
		
			  }
			
  
 
?>

#2

Are you getting an error message? If not, have you checked your error logs? Does it print “hello” to the screen?


#3

no errors. It just reloads the same page. Database is not getting updated. @RandellDawson


#4

When you say it reloads the same page? Is this code the only thing on the page or do you have an html for on the page? I was thinking you called this code from a different page. Please provide all code (html, php) from any pages involved with the signup process.


#5
<?php

	$con='petstore';
	// Connect to the database

		$con = mysqli_connect("localhost","root","",$con);
		if(! $con)
		{
			die('Connection Failed'.mysqli_error());
			
		}
		// Make sure we connected successfully

			if(isset($_POST['register'])){	
			  session_start();
		      $s = "select (max(id)+1) from reg";
			 
			  $result = mysqli_query($con,$s);
			  $row = mysqli_fetch_row($result);
			  
			  
			  
				
				$uname = $_POST['username'];
				$email = $_POST['email'];
				$pass = $_POST['password'];
				$pass1 = $_POST['password1'];
				
		  		if($pass == $pass1){
					
					$s1= "insert into reg values($result,'$uname','$pass','$email')";
					mysqli_query($con,$s1);
					echo $_SESSION['message']="You are now Registered";
					$_SESSION['username']=$uname;
					echo "hello";
					//header("location: ."); //redirect to home page
			}
				else{
					$_SESSION['message']="Paaswords do not match";
			}
		
			  }
			
  
 
?>
  
<html>
    <head>
        <title>CLASSES | LOGIN</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
        <script src="https://use.fontawesome.com/5ceac9acce.js"></script>
        <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
        <link rel="stylesheet" href="css/bootstrap.min.css">
       <!-- <link rel="stylesheet" href="responsive.css" media="screen and (max-width:900px)">-->
        <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Varela+Round"/>
        <link href="https://fonts.googleapis.com/css?family=Lobster" rel="stylesheet" type="text/css">
		
		<!-- Bootstrap core CSS -->
    <link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom fonts for this template -->
    <link href="vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
    <link href="https://fonts.googleapis.com/css?family=Lora:400,700,400italic,700italic" rel="stylesheet" type="text/css">
    <link href='https://fonts.googleapis.com/css?family=Cabin:700' rel='stylesheet' type='text/css'>

    <!-- Custom styles for this template -->
    <link href="css/grayscale.min.css" rel="stylesheet">
	
        <style>
            
            .btn{
                  font-size:20px;
                  margin-top:5.5px;
                  border: none;
                  color:white;
                  margin-bottom: 5px;
                  font-size:15px;
                  height: 45px;
                  background: dimgrey;
                  border-radius: 5px;                              
                                            } 
			.form-control {
				  font-size:20px;
}
                   </style>
    <body>
       <!-- Navigation -->
   <nav class="navbar navbar-expand-lg navbar-light" id="mainNav">
      <div class="container">
		
        <a class="navbar-brand js-scroll-trigger" href="index.html"><img src="img\logo.jpg" style="height:50px;width:70px;margin-right:20px;border-radius:50px"></a>
        <button class="navbar-toggler navbar-toggler-right" type="button" data-toggle="collapse" data-target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false" aria-label="Toggle navigation">
          Menu
          <i class="fa fa-bars"></i>
        </button>
        <div class="collapse navbar-collapse" id="navbarResponsive">
          <ul class="navbar-nav ml-auto">
            <li class="nav-item">
              <a class="nav-link js-scroll-trigger" href="index.html#about">About</a>
            </li>
            <li class="nav-item">
              <a class="nav-link js-scroll-trigger" href="login2.php">Login</a>
            </li>
            <li class="nav-item">
              <a class="nav-link js-scroll-trigger" href="store.html">Store</a>
            </li>
            <li class="nav-item">
              <a class="nav-link js-scroll-trigger" href="notice.html">Notices</a>
            </li>
            <li class="nav-item">
              <a class="nav-link js-scroll-trigger" href="contact.html">Contact</a>
            </li>
          </ul>
        </div>
      </div>
    </nav>          
        
       
<div class="container">
        <div class="row">
            <div class="col-xs-12 col-sm-8 col-md-6 col-sm-offset-2 col-md-offset-3">
                <form role="form" method="post" action="signup1.php">


          <fieldset>
            <!-- <hr class="colorgraph"> -->
            <div class="form-top">
              <h1>Sign Up...</h1>
            </div>
            <hr class="colorgraph">
            <div class="form-bottom">
              <div class="form-group">
                <label><h4><strong>NAME:</strong></h4></label>
                <div class="form-group">
                              <input type="text" name="un" class="form-control input-lg" placeholder="Enter Name" required="true">
                        </div>
                        
                </div>
				
				<label><h4><strong>EMAIL ID:</strong></h4></label>
                <div class="form-group">            
                            <input type="text" name="mail" class="form-control input-lg" placeholder="Enter an email-id" required="true">
                </div>
                <label><h4><strong>PASSWORD:</strong></h4></label>
                <div class="form-group">            
                            <input type="password" name="pwd" class="form-control input-lg" placeholder="Enter a password" required="true">
                </div>
               <label><h4><strong>Retype PASSWORD:</strong></h4></label>
                <div class="form-group">            
                            <input type="password" name="pwd1" class="form-control input-lg" placeholder="Enter a password" required="true">
                </div>
                
                
              </div>
              <div class="row">
                <div class="col-xs-12">
                  <center>
                                <input type="submit" name="register" class="btn btn-lg btn-primary btn-block" value="Register!" href="">
                              </center>
                </div>                
              </div>
            </div>
            
          </fieldset>
            
        </form>
      </div>
    </div>
  </div>
        
        
    </body>
</html>

@RandellDawson here


#6

Can I assume that all of the above code is in a file named “signup1.php”?


#7

yes it’s named as signup1.php @RandellDawson


#8

OK, because I do not have access to your database, you need to try some debugging by putting various echo statements in. For example, try putting the following in to see what gets printed to the screen:

 $s = "select (max(id)+1) from reg";
 $result = mysqli_query($con,$s);
 $row = mysqli_fetch_row($result);
 echo "row is $row";
 .  
 .
 .
 .
 
 if($pass == $pass1){
   $s1= "insert into reg values($result,'$uname','$pass','$email')"; 
   echo $s1;

Let me know what the above echo statements yield.


#9

i tried doing this before.Echo is not working. I’m using xampp for db . Is there any setting in xampp needed to be set for echo to work. @RandellDawson


#10

One more question. When you are viewing this page, what exactly shows in the browser address bar?


#11

Browser has the complete path.Even after reloading path is the same. I’m using firefox.
$_SESSION is also not working. @RandellDawson


#12

What is the complete path showing in the browser address bar?

Does it start with c:\ or localhost?


#13

file:///C:/Users/vit1234/Downloads/petopia_imp-20171025T050148Z-001/petopia_imp/signup1.php

this is the path


#14

Notice: Array to string conversion in C:\xampp\htdocs\signup1.php on line 27
row is Array
Notice: Undefined index: username in C:\xampp\htdocs\signup1.php on line 31

Notice: Undefined index: email in C:\xampp\htdocs\signup1.php on line 32

Notice: Undefined index: password in C:\xampp\htdocs\signup1.php on line 33

Notice: Undefined index: password1 in C:\xampp\htdocs\signup1.php on line 34

Recoverable fatal error: Object of class mysqli_result could not be converted to string in C:\xampp\htdocs\signup1.php on line 38

i added the folder in htdocs and executed it using path localhost/signup1.php @RandellDawson i got all these errors


#15

I corrected the mistakes. I got the required output. Thanx a lot for ur help @RandellDawson :slight_smile: