SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2011
    Posts
    73
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Cool Problems redirecting to next pages

    I have recently tried this coding to update to my database it works differently in two browsers IE and Chrome. In chrome it just goes to the next page (before it was adding data to DB) and not going to next page. Now IE just adds data to DB and does not go to next page. Can someone take a look and let me know what I have to do to fix this. thanks

    PHP Code:
    <?php

      
    @include('Connections/connect_to_mysql.php');


      
    $err='';

      if(
    $_POST["submit"]){
      
        
    // Validate form data

        
    if($_POST["firstname"]==''$err.='Please enter First Name<br>';
        if(
    $_POST["email"]==''$err.='Please enter Email<br>';



        if(
    $err==''){ 

          
    // Check if there are duplicate entries in the 'contacts' table

          
    $r=mysql_query("SELECT ID FROM Members WHERE firstname='".addslashes($_POST["firstname"])."' and Email='".addslashes($_POST["email"])."'");
          if(
    mysql_num_rows($r)){
            
    $err.='Can not add duplicate entry<br>';
          }
          else{

            
    // adding new record to 'contacts' table

            
    mysql_query("INSERT INTO Members (firstname,lastname,country,Email) 
                        values ('"
    .addslashes($_POST["firstname"])."','".addslashes($_POST["lastname"])."','".addslashes($_POST["country"])."','".addslashes($_POST["email"])."')");

            
    // redirecting to success screen

            
    exit;

          }
        }
      }

    ?>
    <html>
    <head>
    <title>Add New Contact</title>
    </head>

    <body>

    <h2>Register with us</h2>

    <?php echo $err==''?'''<p style="color:red;">'.$err.'</p>'?>

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

    <table border="0">
    <tr>
    <td valign="middle">First Name:</td>
    <td><input type="text" name="firstname" size="30" value="<?php echo htmlspecialchars($firstname?>"></td>
    </tr>
    <tr>
    <td valign="middle">Last Name:</td>
    <td><input type="text" name="lastname" size="30" value="<?php echo htmlspecialchars($lastname?>"></td>
    </tr>
    <tr>
    <td valign="middle">Country:</td>
    <td><input type="text" name="country" size="30" value="<?php echo htmlspecialchars($country?>"></td>
    </tr>
    <tr>
    <td valign="middle">Email:</td>
    <td><input type="text" name="email" size="30" value="<?php echo htmlspecialchars($email?>"></td>
    </tr>
    </table><br>

    <a href="http://www.ebermylove.com/login.php"><input type="submit" name="submit" value=" Submit! "></a>

    </form>

    </body>
    </html>
    login.php

    PHP Code:
    <?php
    session_id
    (); 
    session_start();
    ?>
          
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Welcome</title>
    </head>

    <body>
    <?php
    /* Program: New_member.php
     * Desc:   Displays the new member welcome page. Greets
     *         member by name and gives a choice to enter
     *         restricted section or go back to main page.
     */
    if (@$_SESSION['auth'] != "yes")

     @include(
    'Connections/connect_to_mysql.php');   
     
    $link mysql_connect("$db_host","$db_username","$db_pass") or die ("could not connect to mysql");
     
    $link mysql_select_db("$db_name") or die ("Query died:");
     
    $query "SELECT firstName, lastName FROM `Members`
              WHERE email='
    {$_SESSION['id']}'";            
     
    $result = @mysql_result($query,$link)
                 or die(
    "Could not execute query");
     echo 
    "<html>
           <head><title>New Member Welcome</title></head>
          <body>
          <h2 style='margin-top: .7in; text-align: center'>
          Welcome 
    $firstName </h2>\n";
    ?>
    <p>Your new Member accounts lets you enter the members only section
    of our web site. You'll find special discounts, a profile of matches,
    live advise for experts, and much more.</p>
    <p>Your new Member ID and password were emailed to you. Store them
    carefully for future use.</p>
    <div style="text-align: center">
    <p style="margin-top: .5in; font-weight: bold">
    Glad you could join us!</p>
    <form action="profile.php" method="post">
       <input type="submit"
          value="Enter the Members Only Section">
          </form>
    <form action="index.php" method="post">
       <input type="submit" value="Go to eBermylove Main Page">
       </form>      
          </div>
    </body>
    </html>
    Last edited by Mittineague; May 1, 2011 at 22:53. Reason: reformatting bbcode tags

  2. #2
    SitePoint Enthusiast LSC-Rob's Avatar
    Join Date
    Jul 2005
    Location
    Sydney, NSW Australia
    Posts
    91
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm not sure if the forum has removed some code (best to use the [ php ] tags around your code), but I don't see anywhere that would redirect the browser.

    You need either a php header() or meta header function.
    Rob G.
    ShopManager - Sales & Repair Business Management Software

  3. #3
    SitePoint Evangelist smftre's Avatar
    Join Date
    Dec 2008
    Location
    London
    Posts
    436
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I agree, from the code pasted above I don't see what is redirecting anything!
    I don't think you have pasted all the necessary code...
    Statvoo.com The Website Traffic Monitor
    The best way to monitor traffic to your sites for free!


    Web Development London UK We make web 3.0 applications


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •