Help with coding and warnings

[rdkd1970]

Okay I have been trying to work out this problem for 3 months I am not the type of person to give up but I have tried everything. I was first not able to connect to my database live with my form but I did a change from ($cxn,$sql) to ($sql,$link) since then I was able to download to phpmyadmin in Google Chrome and no other site. But in Google Chrome I get a message about global registry Warning: Unknown on line 0. all other sites give me a Warning line 116 MySql Link is

 

Here is my coding can someone help I have only been using PHP and I know someone is out there with much more knowledge than I have. This is the first page with the codes but it does not go to the second page which I will paste after this one. Any help would make my year better.

<php
@session_start();
switch (@$_POST['Button'])
{
   case "Login1":
   include "Connections/connect_to_mysql.php";
   $sql = "SELECT id FROM Members
            WHERE id=   '$_POST[fusername]'";
   $result = mysql_query($sql)
            or die("Query died: fusername");
   $num = mysql_num_rows($result);
   if($num > 0)   //login name was found
   {
      $sql = "SELECT id FROM Members
            WHERE id='$_POST[fusername]'
            AND password=md5('$_POST[fpassword])'";
      $result2 = mysql_query($sql)
               or die("Query died: fpassword");
      $num2 = mysql_num_rows($result2);
      if($num2 > 0)   //password matches
      {
         $_SESSION['email1']="yes";
         $_SESSION['id'] = $_POST['fusername'];
         $sql = "INSERT INTO Members (id,loginTime)
               VALUES ('$_SESSION[id]',NOW())";
         $result = mysql_query($sql)
                  or die("Query died: insert");
         header("Location: New_member.php");               
      }
      else   //password does not match
      {
         $message_1="The username, '$_POST[fusername]' exists, but you have not entered
                  the correct password! Please try again.";
         $fusername=strip_tags(trim($_POST['fusername']));
         include("login_form.php");         
      }
   }
   else   //username not found
   {
      $message_1 = "The username you entered does not exist! Please try again.";
      include("login_form.php");
   }
break;

case "Register":
   /* Check for blanks */
   foreach($_POST as $field => $value)
   {
      if($field != "fax")
      {
         if(empty($value))
         {
            $blanks[] = $field;
         }
         else
         {
            $good_data[$field] = strip_tags(trim($value));
         }
      }
   }
   if(isset($blanks))
   {
      $message_2 = "The following fields are blank. Please enter the required information:   ";
      foreach($blanks as $value)
      {
         $message_2 .="$value,   ";
      }
      extract($good_data);
      include("login_form.php");
      exit();
   }
/* validate data */
   foreach($_POST as $field => $value)
   {
      if(preg_match("/name/i",$field) and
        !preg_match("/user/i",$field) and
        !preg_match("/log/i",$field))
      {
         if (!preg_match("/^[A-Za-z' -]{1,50}$/",$value))
         {
            $errors[] = "$value is not a valid name.   ";
         }
      }
      if(preg_match("/email/i",$field))
      {
         if(!preg_match("/^.+@.+\\..+$/",$value))
         {
            $errors[]="$value is not a valid email addr.";
         }
      }
   }   //end if not empty
   foreach($_POST as $field => $value)
   {
      $$field = strip_tags(trim($value));
   }
   if(@is_array($errors))
   {
      $message_2 = "";
      foreach($errors as $value)
      {
         $message_2 .= $value." Please try again<br />";
      }
      include("login_form.php");
      exit();
   } // end if errors are found
   
   /* check to see if username already exists */
   include_once"Connections/connect_to_mysql.php";
   $link = @mysql_connect("$db_host","$db_username","$db_pass") or die ("could not connect to mysql");
   @mysql_select_db("$db_name") or die ("Query died:");
   $sql = "SELECT id FROM Members
            WHERE id='$id'";
   $result = mysql_query($sql)
            or die("Query died: id.");
   $num = mysql_num_rows($result);
   if($num > 0)
   {
      $message_2 = "$id already used. Select
                  another User Name.";
      include("login_form.php");
      exit();            
   } // end if username already exists
   else // Add new member to database
   {
      $sql = "INSERT INTO Members (id,sign_up_date,username
               password,firstName,lastName,email) VALUES
               ('$id',NOW(),,md5('$password'),
               '$username','$firstName','$lastName','$email')";
      mysql_query($sql);
      $_SESSION['email1']="yes";
      $_SESSION['id'] = $username;
      /* send email to new Customer */
      $emess = "You have successfully registered.   ";
      $emess .= "Your new username and password are:   ";
      $emess .= "\n\n\t$username\n\t";
      $emess .= "$password\n\n";
      $emess .= "We appreciate your interest. \n\n";
      $emess .= "If you have any questions or problems,";
      $emess .= " email ebermylove@gmail.com";
      $subj = "Your new customer registration";
      # $mailsend=mail ("$email","$subj","$emess");
               
   }
   break;
   
   default:
      include("login_form.php");
}
?>
<php
session_start();

if (@$_SESSION['auth'] != "yes")
{
    header("Location: login.php");
   exit();
include("dogs.inc");
$link = mysqli_connect($host,$user,$password,$dbname)
       or die("Couldn't connect to server.");   
$sql = "SELECT firstName, lastName FROM `Members`
          WHERE id='{$_SESSION['id']}'";            
$result = mysqli_query($sql,$link)
       or die("Couldn't execute query");
$row = mysqli_fetch_assoc($result);
extract($row);
}
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="member_page.php" method="post">
   <input type="submit"
      value="Enter the Members Only Section">
      </form>
<form action="profile.php" method="post">
   <input type="submit" value="Go to Main Page">
   </form>      
      </div>                           
</body>
</html>

[fugix]

firstly, please remember to always encase your php code in code tags...helps with neatness and legibility.

[cyberRobot]

Not sure if this is causing the problem, but you need to change <php to <?php

[fugix]

yes i just noticed that too..you are not using the proper php starting tag (<?php)....after you have done this...let us know if your problems persist

[rdkd1970]

I was not able to get the browsers to download only in Google Chrome and the others is giving an error message of Mysql Link already sent line ().

In Google Chrome it downloads to the database but does not go to the next page it will show an error warning Unknown register global bugs....Unknown line 0

[fugix]

I think that the link error is happening because you are connecting to mysql multiple times

[rdkd1970]

Okay thanks will this help to change to the new page like welcoming the customer