# \[Solved\] Help in php / mysql

**URL:** <https://forum.freecodecamp.org/t/solved-help-in-php-mysql/55348>\
**Category:** General\
**Created:** [November 14, 2016, 7:35pm UTC](https://forum.freecodecamp.org/t/solved-help-in-php-mysql/55348 "2016-11-14T19:35:44Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ahmed-Baqader](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/ahmed-baqader/32/162111_2.png) [@Ahmed-Baqader](https://forum.freecodecamp.org/u/Ahmed-Baqader)\
**Post date:** [November 14, 2016, 7:35pm UTC](https://forum.freecodecamp.org/t/solved-help-in-php-mysql/55348/1 "2016-11-14T19:35:44Z")

</div>

```auto
<?php
if(isset($_POST['submit'])){
	if(!$_POST['email']){
	$error.="<br/>please Enter Your Email";	
	} 
		
	 else {
		 if (!filter_var($_POST['email'],FILTER_VALIDATE_EMAIL )){
			$error.="<br/>Please Enter a Valid Email"; 
		 } 
		 }
		
		if(!$_POST['password']){
			$error.="<br/>please Enter Your Password";
		}
					
		
	else {
		if (strlen($_POST['password'])<8){
			$error.="<br/>please Enter long Password";
		} 
		if (!preg_match("#[a-z]+#",$_POST['password'])){
			$error.="<br/>please Enter strong Password";
		} 
	}
	if (isset($error)) {
	echo "There Were error(s) In Your Signup Details :" .$error;	
	} 
	else {
		$link = mysqli_connect("localhost","root","password","test");
        $email=$_POST['email'];
	    $query ="SELECT * FROM users WHERE email ='".mysqli_real_escape_string($link,$email)."'";
        $result = mysqli_query($link,$query);
        $results = mysqli_num_rows($result);
		
		if($results) echo "Email is already registered ,, Do you want log In ";
		else {
			$email = $_POST['email'];
		//	md5(md5($_POST['email']).
			$password = $_POST['password'];
			$query ="INSERT INTO users ('email','password') VALUES ('".mysqli_real_escape_string($link,$email)."',$password)";
			
if (mysqli_query($link, $query)) {
    echo "You have been succesfully signed up!";
} else {
    echo "Something went wrong";
}
		}
	
	}
}

?>

<form method="post">
<input type="email" name="email" id="name"/>
<input type="password" name = "password"/>
<input type ="submit" name="submit" value="LogIn"/>
</form>

```

the mistake in this part in this code because the message show is the user been singed up but his email and password not added to the database

```auto
    if($results) echo "Email is already registered ,, Do you want log In ";
		else {
			$email = $_POST['email'];
		//	md5(md5($_POST['email']).
			$password = $_POST['password'];
			$query ="INSERT INTO users ('email','password') VALUES ('".mysqli_real_escape_string($link,$email)."',$password)";
			if (mysqli_query($link, $query)) {
    echo "You have been succesfully signed up!";
} else {
    echo "Something went wrong";
}
		}
	
	}
}

?>

```

---

<div class="post-metadata">

**Author:** ![JacksonBates](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/jacksonbates/32/123402_2.png) [@JacksonBates](https://forum.freecodecamp.org/u/JacksonBates)\
**Post date:** [November 14, 2016, 8:25pm UTC](https://forum.freecodecamp.org/t/solved-help-in-php-mysql/55348/2 "2016-11-14T20:25:16Z")

</div>

I cleaned up your code.  
You need to use triple backticks to post code to the forum.  
See [this post for details](http://forum.freecodecamp.com/t/forum-code-formatting/25574?u=jacksonbates).

---

<div class="post-metadata">

**Author:** ![BenGitter](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/bengitter/32/12192_2.png) [@BenGitter](https://forum.freecodecamp.org/u/BenGitter)\
**Post date:** [November 14, 2016, 8:27pm UTC](https://forum.freecodecamp.org/t/solved-help-in-php-mysql/55348/3 "2016-11-14T20:27:38Z")

</div>

Echo is reached whether the mysqli\_query does anything or not.

If you haven’t fixed it, I will have a look at it when I’m home.

---

<div class="post-metadata">

**Author:** ![Ahmed-Baqader](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/ahmed-baqader/32/162111_2.png) [@Ahmed-Baqader](https://forum.freecodecamp.org/u/Ahmed-Baqader)\
**Post date:** [November 14, 2016, 8:37pm UTC](https://forum.freecodecamp.org/t/solved-help-in-php-mysql/55348/4 "2016-11-14T20:37:50Z")

</div>

i post the rest of code , see it

---

<div class="post-metadata">

**Author:** ![BenGitter](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/bengitter/32/12192_2.png) [@BenGitter](https://forum.freecodecamp.org/u/BenGitter)\
**Post date:** [November 14, 2016, 9:34pm UTC](https://forum.freecodecamp.org/t/solved-help-in-php-mysql/55348/5 "2016-11-14T21:34:29Z")

</div>

Change:

```auto
mysqli_query($link,$query);
echo "You been SignUp";

```

To:

```auto
if (mysqli_query($link, $query)) {
    echo "You have been succesfully signed up!";
} else {
    echo "Something went wrong";
}

```

I suppose that should work.

---

<div class="post-metadata">

**Author:** ![Ahmed-Baqader](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/ahmed-baqader/32/162111_2.png) [@Ahmed-Baqader](https://forum.freecodecamp.org/u/Ahmed-Baqader)\
**Post date:** [November 15, 2016, 1:00pm UTC](https://forum.freecodecamp.org/t/solved-help-in-php-mysql/55348/6 "2016-11-15T13:00:09Z")

</div>

> [@BenGitter](#):
>
> if (mysqli\_query($link, $query)) {  
> echo “You have been succesfully signed up!”;  
> } else {  
> echo “Something went wrong”;  
> }

yes something went wrong

---

<div class="post-metadata">

**Author:** ![Ahmed-Baqader](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/ahmed-baqader/32/162111_2.png) [@Ahmed-Baqader](https://forum.freecodecamp.org/u/Ahmed-Baqader)\
**Post date:** [November 15, 2016, 1:25pm UTC](https://forum.freecodecamp.org/t/solved-help-in-php-mysql/55348/7 "2016-11-15T13:25:50Z")

</div>

Done , Thank you ,

---

<div class="post-metadata">

**Author:** ![Ahmed-Baqader](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/ahmed-baqader/32/162111_2.png) [@Ahmed-Baqader](https://forum.freecodecamp.org/u/Ahmed-Baqader)\
**Post date:** [November 15, 2016, 2:24pm UTC](https://forum.freecodecamp.org/t/solved-help-in-php-mysql/55348/8 "2016-11-15T14:24:18Z")

</div>

Thanks all , The problem solved

Change

```auto
$query ="INSERT INTO users ('email','password') VALUES

```

To

```auto
$query = "INSERT INTO users (email,password) VALUES

```

---

<div class="post-metadata">

**Author:** ![jwilkins.oboe](https://sea3.discourse-cdn.com/freecodecamp/user_avatar/forum.freecodecamp.org/jwilkins.oboe/32/179497_2.png) [@jwilkins.oboe](https://forum.freecodecamp.org/u/jwilkins.oboe)\
**Post date:** [January 16, 2021, 5:31am UTC](https://forum.freecodecamp.org/t/solved-help-in-php-mysql/55348/9 "2021-01-16T05:31:38Z")

</div>

Closed on January 16, 2021, 5:31am UTC