Phpmyadmin simple question

Question

0.00/5 (No votes)

See more:

I have a very simple PHP program I am working on just to do some refreshing and I cannot get any echos to show up and also the data is not being inserted into the database. Can someone please tell me my error? Also for php debugging do I just add “error_reporting(-1);” in the PHP code?

Here is what I have for simple data.

HTML

<!DOCTYPE html>
<html>
	<head>
		<meta charset="UTF-8">
		<title>login test</title>
		
	</head>
	<body>
		<form action="signup.php" method="POST">
			<input type="text" name="first" id="first" placeholder="first name" /><br>
			<input type="text" name="user" id="user" placeholder="user name" /><br>
			<input type="password" name="pass" id="pass" placeholder="password" /><br>
			<button type="submit">Sign up</button>
		</form>
	</body>
</html>

Conn.php
<?php
		
	$conn = mysqli_connect("localhost", "root", "", "test");
	
	if(!$conn) {
		die("Connection failed: " . mysqli_connect_error());
	}

Signup.php
<?php

	include 'conn.php';
	
	$first = $_POST['first'];
	$user = $_POST['user'];
	$pass = $_POST['pass'];
	
	echo $first;
	echo $user;
	echo $pass;
	
	$sql = "INSERT INTO user (first, user, pass) 
			VALUES ('$first', '$user', '$pass')";
			
	$result = mysqli_query($conn, $sql);
	
	header("Location: register.php");

What I have tried:

php error handling
echoing the data from the textboxes to the screen and the screen stays blank
i am not sure why my echoing is not working.

Posted 24-Feb-17 16:20pm

TheBigBearNow

Updated 24-Feb-17 18:16pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2017-02-24T18:16:00

Quote:
i am not sure why my echoing is not working

that is because it has been redirected to register.php due to

header("Location: register.php");

If you really want to see the echo messages, then comment it out temporarily:

//header("Location: register.php");

Quote:
and also the data is not being inserted into the database

Barring another other errors, one obvious mistake is that you are using a reserved word for mysql[^], i.e. user as table name. Most of the reserved words are forbidden by standard SQL as column or table name. To get around it, surround it with a pair of back ticks, i.e.

`user`

Last but not least, you should adopt PHP Prepared Statements[^] to minimize the risk of SQL injection.