Jump to content
UncleStef Mentoring Update: New SEO course!

devdeepto

Member
 View Profile  See their activity

  • Posts

    3

  • Joined

  • Last visited

 Content Type 

Posts posted by devdeepto

  2. Simple Login Non Oob

    in Beginners Web Design

    Posted

    Hello Ben,

     

    I was using your simple login non OOB version. I tried to add first name and last name in the memmber table. The form valodation works fine. But data is not inserted in the table. Here is the code:

     

    HTML:

     

    <form action="" method="post">

    <div>

    <?php if ($error['alert'] != '') {

    echo "<div class='alert'>".$error['alert']."</div>"; } ?>

     

    <label for="username">Username: *</label>

    <input type="text" name="username" value="<?php echo $input['user']; ?>"><div class="error"><?php echo $error['user']; ?></div>

     

    <label for="firstname">First Name: *</label>

    <input type="text" name="firstname" value="<?php echo $input['first']; ?>"><div class="error"><?php echo $error['first']; ?></div>

     

     

     

    PHP: Register.php

    <?php

     

    /*

    * REGISTER.PHP

    * Register New Members

    */

     

    // start session / load configs

    session_start();

    include('includes/config.php');

    include('includes/db.php');

     

    /*

    * This section below checking if user is logged in/checking for inactivity

    * may be best put in a reusable function so it is easily reused/updated

    */

     

    // check that the user is logged in

    if (!isset($_SESSION['username']))

    {

    header("Location: login.php?unauthorized");

    }

    // check that the user is an admin

    else if (!is_admin())

    {

    header("Location: customers.php");

    }

     

    // check for inactivity

    if (time() > $_SESSION['last_active'] + $config['session_timeout'])

    {

    // log out user

    session_destroy();

    header("Location: login.php?timeout");

    }

    else

    {

    // update the session variable

    $_SESSION['last_active'] = time();

    }

     

    // form defaults

    $error['alert'] = '';

    $error['user'] = '';

    $error['first'] = '';

    $error['email'] = '';

    $error['type'] = '';

    $error['pass'] = '';

    $error['pass2'] = '';

     

    $input['user'] = '';

    $input['first'] = '';

    $input['email'] = '';

    $input['type'] = '';

    $input['pass'] = '';

    $input['pass2'] = '';

     

    if (isset($_POST['submit']))

    {

    $input['user'] = htmlentities($_POST['username'], ENT_QUOTES);

    $input['first'] = htmlentities($_POST['firstname'], ENT_QUOTES);

    $input['email'] = htmlentities($_POST['email'], ENT_QUOTES);

    $input['type'] = htmlentities($_POST['type'], ENT_QUOTES);

    $input['pass'] = htmlentities($_POST['password'], ENT_QUOTES);

    $input['pass2'] = htmlentities($_POST['password2'], ENT_QUOTES);

     

    // create select options

    $select = '<option value="">Select an option</option>';

    $stmt = $mysqli->prepare("SELECT id, name FROM customerstype");

    $stmt->execute();

    $stmt->bind_result($id, $name); // for more information, see http://www.php.net/manual/en/mysqli-stmt.bind-result.php

    while ($stmt->fetch())

    {

    $select .= "<option value='" . $id . "'";

    if ($input['type'] == $id) { $select .= "selected='selected'"; }

    $select .= ">" . $name . "</option>";

    }

    $stmt->close();

     

    // process form

    if ($_POST['username'] == '' || $_POST['firstname'] == '' || $_POST['password'] == '' || $_POST['password2'] == '' || $_POST['email'] == '' || $_POST['type'] == '')

    {

    // both fields need to be filled in

    if ($_POST['username'] == '') { $error['user'] = 'required!'; }

    if ($_POST['fisrtname'] == '') { $error['first'] = 'required!'; }

    if ($_POST['email'] == '') { $error['email'] = 'required!'; }

    if ($_POST['type'] == '') { $error['type'] = 'required!'; }

    if ($_POST['password'] == '') { $error['pass'] = 'required!'; }

    if ($_POST['password2'] == '') { $error['pass2'] = 'required!'; }

    $error['alert'] = 'Please fill in required fields!';

     

    // show form

    include('views/v_register.php');

    }

    else if ($_POST['password'] != $_POST['password2'])

    {

    // both password fields need to match

    $error['alert'] = 'Password fields must match!';

     

    // show form

    include('views/v_register.php');

    }

    else if (!preg_match('/^([0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\w]*[0-9a-zA-Z]\.)+[a-zA-Z]{2,9})$/', $input['email']))

    {

    // email is invalid

    $error['email'] = "Please enter a valid email!";

     

    // display form

    include('views/v_register.php');

    }

    else

    {

    // check if the email is taken

    $check = $mysqli->prepare("SELECT email FROM customers WHERE email = ?");

    $check->bind_param("s", $input['email']);

    $check->execute();

    $check->store_result();

    if ($check->num_rows != 0)

    {

    // email is already in use

    $error['alert'] = "This email is already in use. Please choose a different email address.";

    $error['email'] = "Please choose a different email address.";

     

    // show form

    include('views/v_register.php');

    exit;

    }

     

    // check if the username is taken

    $check = $mysqli->prepare("SELECT username FROM customers WHERE username = ?");

    $check->bind_param("s", $input['user']);

    $check->execute();

    $check->store_result();

    if ($check->num_rows != 0)

    {

    // username is already in use

    $error['alert'] = "This username is already in use. Please choose a different username.";

    $error['user'] = "Please choose a different username.";

     

    // show form

    include('views/v_register.php');

    exit;

    }

     

    // insert into database

    if ($stmt = $mysqli->prepare("INSERT customers (username, firstname, email, type, password) VALUES (?,?,?,?,?)"))

    {

    $stmt->bind_param("ssss", $input['user'], $input['firstname'], $input['email'], $input['type'], md5($input['pass'] . $config['salt']));

    $stmt->execute();

    $stmt->close();

     

    // add alert and clear form values

    $error['alert'] = 'Member added successfully!';

    $input['user'] = '';

    $input['first'] = '';

    $input['email'] = '';

    $input['type'] = '';

    $input['pass'] = '';

    $input['pass2'] = '';

     

    // show form

    include('views/v_register.php');

    }

    else

    {

    echo "ERROR: Could not prepare MySQLi statement. in customer insert";

    }

    }

    }

    else

    {

    // create select options

    $select = '<option value="">Select an option</option';

    $stmt = $mysqli->prepare("SELECT id, name FROM customerstype");

    $stmt->execute();

    $stmt->bind_result($id, $name);

    while ($stmt->fetch())

    {

    $select .= "<option value='" . $id . "'>" . $name . "</option>";

    }

    $stmt->close();

     

    // show form

    include('views/v_register.php');

    }

     

    // close db connection

    $mysqli->close();

     

    ?>

     

    I modified the database by adding another field for first name. I can manually insert the first name but it cannot insert the firstname from the form. Any idea. I am with fatcow.com for webhosting.

     

    Thanks,

    Mahfuz

  3. Chrome Anchor Doesnot Work

    in Beginners Web Design

    Posted

    anchor tag does not work in chrome/safari/frefox but works in IE. Here bellow is the HTML portion followed by the CSS code

     

    HTML

     

    <div id="top-nav-search-logo">

    <div id="logo">

    <a href="http://dunga.com"> </a>

    </div>

     

    <div id ="top-social-links" >

    <ul>

    <li> <a href="http://dunga.com"><img'>http://dunga.com"><img'>http://dunga.com"><img src="images/MP_Mid_Bannaer_Image/pintres-log-in.png"></a></li>

    <li> <a href="http://dunga.com"><img src="images/MP_Mid_Bannaer_Image/twitter-small.png"></a></li>

    <li> <a href="http://dunga.com"><img src="images/MP_Mid_Bannaer_Image/facebook-small.png"></a></li>

    <li> get social with us</li>

    </ul>

    </div>

     

    <div id="login-errorfix">

    <ul>

    <li><a href="http://dunga.com/login/login.php">log in</a> </li>

    <li><a href="http://dunga.com/Shop/index.php">shopping cart </a></li>

    <li><a href="http://dunga.com/Shop/index.php">check out</a></li>

    </ul>

    </div>

     

    <div id="search-box">

    <form action="" id="search-form">

    <input type="text" name="search" />

    <input type="submit" value="Search">

    </form>

    </div>

     

    </div>

     

     

     

    CSS

     

    #top-nav-search-logo{

    position:relative;

    overflow:auto;

    height:93px;

    width:1024px;

    background-color:#9C8E75;

    border:none;

    padding-top:0px;

    }

     

    #logo{

    position:relative;

    background: url(../images/missingPieces_logo1.png);

    background-repeat:no-repeat;

    background-color:#9C8E75;

    float:left;

    width:340px;

    height:93px;

    }

    #top-social-links{

    position:relative;

    float:left;

    height:58px;

    width: 384px;

    padding-top:2px;

    color: #FFF;

    }

    #top-social-links li{

    list-style: none;

    float:right;

    height:58px;

    padding-top:2px;

    padding-left:20px;

    color: #FFF;

    font-family:"segoe ui";

    }

     

    #top-social-links li a {

    padding-top:0px;

    display: block;

    font-size: 15px;

    font-weight: bold;

    color: #FFF;

    text-decoration: none;

     

     

    }

     

    #top-social-links li img{

    border: 0px;

    padding-top:0px;

    width:35px;

    height:35px;

    }

     

    #login-errorfix{

    position:relative;

    float:right;

    background-color:#9C8E75;

    width:300px;

    height:19px;

    padding-top:1px;

    padding-bottom: 1px;

     

    }

     

    #login-errorfix li{

    list-style: none;

    float:right;

    }

     

    #login-errorfix li a {

    padding:8px;

    display: block;

    line-height: 0px;

    font-size: 15px;

    font-weight: normal;

    color: #FFF;

    text-decoration: none;

    font-family:"segoe ui";

    }

     

    #search-box{

    padding-top:45px;

    padding-left:367px;

    float:left;

    position:absolute;

    }

     

    #search-box input[type=text]{

    padding-top:0px;

    float:left;

    padding-left:4px;

    width:475px;

    height:43px;

    }

     

    #search-box input[type=submit]{

    width:174px;

    height:47px;

    }

    #third-row{

    width:1024px;

    height:40px;

    position: relative;

    padding-top:0px;

    }

     

     

    Any idea. Thanks a lot for helping me out.

     

    devdeepto

×
×
  • Create New...