为什么我的插页给出了我的结果？它试图告诉我什么吗？ [英] Why does my insert giving my this result? Is it trying to tell me something?

问题描述

我正在尝试插入，这是我得到的结果。



它试图插入但是碰到一个snagg。我怎样才能解决这个问题。这是我收到的错误

I am trying to insert and this is the result that i am getting.

has it trying to insert but hitting a snagg instead. how can i fix this. here is the error i am recieving

0){
    echo "";
}
else
{//insert data into table
    $sql = "INSERT INTO membersVALUES('$title', '$firstname', '$lastname', '$username', '$email', '$gender', '$services', '$address', md5('$mypwd'))";
    if(mysqli_query($conn,$sql)){echo "";
    $row=mysqli_fetch_array($result);
    mysqli_close($conn);
}
else
{
    echo "Error inserting values into database";
}//end of line
}
}
*/ ?> 

这就是我拥有的东西试过。第三只眼睛，任何帮助将不胜感激，谢谢



我尝试过：

and here it what i have tried. a third eye and any help will be much appreciated thanks

What I have tried:

<pre><?php<?php

		
		 if(isset($_POST['Enter']))
		{
			
			//Capture values from form and store in php variables
			$title=$_POST['title'];
			$firstname=$_POST['firstname'];
			$lastname=$_POST['lastname'];
			$username=$_POST['username'];
			$email=$_POST['email'];
			$gender =$_POST['gender'];
			$services=join(",", $_POST['services']);                                                                                                                                    
			$address=$_POST['address'];
			$mypwd=$_POST['mypwd'];
			
		

			//Create and check connection to the server
			include'db_server.php';
				
			
				
			//Query the database 
			$sql="SELECT * FROM members WHERE username='$username'";
			
			$result=mysqli_query($conn,$sql) or die("Error:" .mysqli_error());
			
			$rowcount=mysqli_num_rows($result);
			
				if($rowcount>=1)
				{
					echo "<script type=\"text/javascript\">
							alert('Username already exist');
							window.location=\"../xhtml/login_user.html\";
						</script>";
				}
				else
				{
					//insert data into table
					$sql="INSERT INTO members 
						  VALUES('$title', '$firstname', '$lastname', '$username', '$email', '$gender', '$services', '$address', md5('$mypwd'))";
					
					if(mysqli_query($conn, $sql))
					{
						 $row=mysqli_fetch_array($result);
						mysqli_close($conn);
					
						echo "<script type=\"text/javascript\">
								 alert('Welcome!! $firstname $lastname, you are now a member of the Caribbean Nature Seekers Institute TT(CNSITT)');
								window.location=\"../xhtml/congrats.html\";
							</script>";
					}
				
					else
					{
						echo "Error inserting data in the members table";
										
					}
				}	
		}

推荐答案

sql = < span class =code-string> INSERT INTO membersVALUES（'

sql = "INSERT INTO membersVALUES('

title'，'

firstname'，'

firstname', '

这篇关于为什么我的插页给出了我的结果？它试图告诉我什么吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！