Message on successful database entry

Question

I'm trying to display a message upon a successful user registration however what I have doesn't seem to be working and just submits/refreshes the page. No message pops up even though data has successful been entered into the SQL database. Any tips or ideas?

<?php
    require('php/connect.php');
    if (isset($_POST['username']) && isset($_POST['password'])){
        $username = $_POST['username'];
        $email = $_POST['email'];
        $password = $_POST['password'];
        $query = "INSERT INTO `user` (username, password, email) VALUES ('$username', '$password', '$email')";
        $result = mysql_query($query);
        if($result){
           echo $msg = "Successful Registration!";
        }
    }
?>

Learning PHP currently so sorry if there's a really obvious answer here!

Edit: Forgot to include echo. Just needed a second pair of eyes, sorry guys. Thanks for the tips!

you're not echoing anything. Use echo $msg

René Roth
– René Roth

2014-05-31 06:11:38 +00:00
Commented May 31, 2014 at 6:11 — René Roth
– René Roth, Commented May 31, 2014 at 6:11

CodeTrooper · Accepted Answer · 2014-05-31 06:20:42Z

2

First of all have this on consideration:

If you're getting started on PHP, please stop using mysql. It's deprecated, instead, you can use either PDO or MySQLi

As for your issue, your message is not being printed. Please make sure you echo the $msg variable:

 $msg = "Successful Registration!";
 echo $msg;

In mysqli a standard connection would be:

$DBConnect = new mysqli('serverName', 'userName', 'userPassword', 'dbName');

And that's it, that's all you need to start querying your database using mysqli.

For a mysql connection, try debugging it, see if there's a connection:

$connection = mysql_connect('localhost', 'userName', 'userPassword');
if (!$connection) {
   die('Could not connect: ' . mysql_error());
}

edited May 31, 2014 at 6:20

answered May 31, 2014 at 6:13

CodeTrooper

1,8807 gold badges33 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Pass Over a year ago

Thanks for the tip re: PDO. My school is (stupidly) teaching this though at the moment.

CodeTrooper Over a year ago

Maybe just for the basics, and if they stay with this, I guess you have no choice, just make sure if you'll be a PHP programmer, not to use mysql. mysqli (which I use and strongly encourage you to) has an OO interface that is very easy to use. I'll show you how to create a connection, I'll edit my post

Sadikhasan · Accepted Answer · 2014-05-31 06:12:47Z

1

Try to echo message

if($result)
{
    echo $msg = "Successful Registration!";
}

answered May 31, 2014 at 6:12

Sadikhasan

18.6k23 gold badges84 silver badges126 bronze badges

Comments

blackhawk338 · Accepted Answer · 2014-05-31 06:14:59Z

0

<?php
echo "Successfully registered!";
?>

answered May 31, 2014 at 6:14

blackhawk338

3862 gold badges3 silver badges15 bronze badges

Collectives™ on Stack Overflow

Message on successful database entry

3 Answers 3

2 Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Related