|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2010-05-05 17:24 UTC] degeberg@php.net
-Status: Open
+Status: Bogus
[2010-05-05 17:24 UTC] degeberg@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Thu Oct 30 00:00:02 2025 UTC |
Description: ------------ <?php include 'mysql-connect.php'; $username = $_POST['username']; $password = $_POST['password']; $firstname = $_POST['firstname']; $lastname = $_POST['lastname']; $age = $_POST['age']; $ip = $_SERVER['REMOTE_ADDR']; $result = mysql_num_rows(mysql_query("SELECT * FROM te2 WHERE username='$username'")); if($result == 1) { echo "username already exist"; } else { mysql_query("INSERT INTO te2 (username, password, firstname, lastname, age, ip) VALUES ('$username', '$password', '$firstname', '$lastname', '$age', '$ip')"); echo "u are successfully registered"; <p>Click <a href="login.php">here</a> to login.</p>;} ?> Expected result: ---------------- <?php include 'mysql-connect.php'; $username = $_POST['username']; $password = $_POST['password']; $firstname = $_POST['firstname']; $lastname = $_POST['lastname']; $age = $_POST['age']; $ip = $_SERVER['REMOTE_ADDR']; $result = mysql_num_rows(mysql_query("SELECT * FROM te2 WHERE username='$username'")); if($result == 1) { echo "username already exist"; } else { mysql_query("INSERT INTO te2 (username, password, firstname, lastname, age, ip) VALUES ('$username', '$password', '$firstname', '$lastname', '$age', '$ip')"); echo "u are successfully registered"; <p>Click <a href="login.php">here</a> to login.</p>;} ?> Actual result: -------------- in my code insert into values code dont work .pls help me