Jump to content

Search the Community

Showing results for tags 'php mysql registration'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Welcome to PHP Freaks
    • Announcements
    • Introductions
  • PHP Coding
    • PHP Coding Help
    • Regex Help
    • Third Party Scripts
    • FAQ/Code Snippet Repository
  • SQL / Database
    • MySQL Help
    • PostgreSQL
    • Microsoft SQL - MSSQL
    • Other RDBMS and SQL dialects
  • Client Side
    • HTML Help
    • CSS Help
    • Javascript Help
    • Other
  • Applications and Frameworks
    • Applications
    • Frameworks
    • Other Libraries
  • Web Server Administration
    • PHP Installation and Configuration
    • Linux
    • Apache HTTP Server
    • Microsoft IIS
    • Other Web Server Software
  • Other
    • Application Design
    • Other Programming Languages
    • Editor Help (PhpStorm, VS Code, etc)
    • Website Critique
    • Beta Test Your Stuff!
  • Freelance, Contracts, Employment, etc.
    • Services Offered
    • Job Offerings
  • General Discussion
    • PHPFreaks.com Website Feedback
    • Miscellaneous

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


Age


Donation Link

Found 1 result

  1. Hi guys, I am trying to create registration form and record the registration to the database, however, I have problem with the part for the 'member name' validation. I try to register myself properly and there shouldn't be an error however it say "Member name must contain only letters, space and hypen". It shouldn't as i put the member name properly, maybe I did something wrong with the validation and especially the regex? My apology for my bad English. <?phpsession_start(); require_once('sqlconnect.inc.php'); session_start(); if (isset($_POST["Register"])) { $email = $_POST['email']; $memberName = $_POST['membername']; $passw = $_POST['password']; $conPassw = $_POST['conpassword']; if($email=='') { echo "<p>Please enter the Email address</p>"; echo "<a href=\"signup.php\">Back to Registration Page!</a>"; exit(); } if($memberName=='') { echo "<p>Please enter the Member Name</p>"; echo "<a href=\"signup.php\">Back to Registration Page!</a>"; exit(); } if($passw=='') { echo "<p>Please enter Password</p>"; echo "<a href=\"signup.php\">Back to Registration Page!</a>"; exit(); } if($conPassw=='') { echo "<p>Please enter Confirm Password</p>"; echo "<a href=\"signup.php\">Back to Registration Page!</a>"; exit(); } else { if (!filter_var($email, FILTER_VALIDATE_EMAIL)) { echo "Invalid email address"; } else{ $_SESSION['name'] = $_POST['membername']; $pattern1 = '/^[a-z-]+$/'; if (preg_match($pattern1, $memberName)) { echo "<p>Member name must contain only letters, space and hypen</p>"; } else{ $pattern2 = '^[a-zA-Z0-9]+$'; if (preg_match($pattern2, $passw)) { echo "<p>Password must only contain numbers and letters!</p>"; } else{ if($passw<>$conPassw) { echo "<p>Passwords does not match!</p>"; $passw=""; $conPassw=""; } else{ $conn = @mysqli_connect($host, $user, $pswd, $dbnm); if (!$conn) die ("<p>Couldn't connect to the server!<p>"); $SelectDatabase = @mysqli_select_db($conn,"s7259476_db") or die("<p>The database is not available.</p>"); $insertDatabase = "INSERT INTO team VALUES('NULL','$email','$password','$memberName',CURDATE(),0)"; $queryResult = @mysqli_query($conn, $insertDatabase) or die ("<p>Email already exists.Please enter another email id</p>"); echo"<p>Data entered into friends table successfully</p>"; echo "<p>Welcome"." ".$_SESSION['name']."</p>"; } } } } } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/chtml-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en" > <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <meta name="description" content="Web Programming :: Assignment 2" /> <meta name="Keywords" content="Web, programming" /> <title>Register Page</title> </head> <body> <form id='register' action='signup.php' method='POST'> <fieldset > <legend><h1>My Team System Registration Page</h1></legend> <?php $email = isset($_POST['email']) ? filter_var($_POST['email'], FILTER_SANITIZE_STRING) : ''; ?> <?php $memberName = isset($_POST['membername']) ? filter_var($_POST['membername'], FILTER_SANITIZE_STRING) : ''; ?> <div class="elements"> <label for='email' >Email:</label> <input type='text' name='email' id='email' maxlength="50" value="<?php echo $email; ?>" /> </div> <br /> <div class="elements"> <label for='membername' >Member Name:</label> <input type='text' name='membername' id='membername' maxlength="50" value="<?php echo $memberName; ?>" /> </div> <br /> <div class="elements"> <label for='password' >Password:</label> <input type='password' name='password' id='password' maxlength="50" /> </div> <br /> <div class="elements"> <label for='conpassword' >Confirm Password:</label> <input type='password' name='conpassword' id='conpassword' maxlength="50" /> </div> <br /> <div class="submit"> <input type='submit' name='Register' value='Register' /> <input type='reset' name='Submit' value='Clear' /> <br /> <div class="elements"> <a href="index.php">Home</a> </fieldset> </form> </body> </html>
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.