PHP - A Rather Unique Problem

I have a mysql table which will store users email addresses (each is unique and is the primary field) and a timestamp. 
I have added another column called `'unique_code' (varchar(64), utf8_unicode_ci)`.

What I would very much appreciate assistance with is;

a) Generating a 5 digit alphanumeric code, ie: 5ABH6 
b) Check all rows the 'unique_code' column to ensure it is unique, otherwise re-generate and check again 
c) Insert the uniquely generated 5 digit alphanumeric code into `'unique_code'` column, corresponding to the email address just entered. 
d) display the code on screen.

What code must I put and where?


**My current php is as follows:**

Code: [Select]
    require "includes/connect.php";
   
    $msg = '';
   
    if($_POST['email']){
   
    // Requested with AJAX:
    $ajax = ($_SERVER['HTTP_X_REQUESTED_WITH']  == 'XMLHttpRequest');
   
    try{
    if(!filter_input(INPUT_POST,'email',FILTER_VALIDATE_EMAIL)){
    throw new Exception('Invalid Email!');
    }
   
    $mysqli->query("INSERT INTO coming_soon_emails
    SET email='".$mysqli->real_escape_string($_POST['email'])."'");
   
    if($mysqli->affected_rows != 1){
    throw new Exception('You are already on the notification list.');
    }
   
    if($ajax){
    die('{"status":1}');
    }
   
    $msg = "Thank you!";
   
    }
    catch (Exception $e){
   
    if($ajax){
    die(json_encode(array('error'=>$e->getMessage())));
    }
   
    $msg = $e->getMessage();
    }
    }

Hi,Dear Frnd...........I Hope u r all fine.
I am using php array_unique function.Here is the problem in this function.
This is the code.
Code: [Select]
<?php
$frnd1 = array(
0=> 'arfan',
1=> 'haider',

2=> array(
0=> 'azeem',
1=> 'jeme',
),
3=> array(
0=> 'haider',
1=> 'one'
)
);
// please do not change the above code.
// You can only change below code.
print_r($frnd1);
echo '<hr />';
print_r(array_unique($frnd1)); 
?>
This work fine,But when I am used array_unique then it does not work.
When I am used array_unique.It ignore the [3]=>Array.
As you can see in my array,Here is two time name "haider".
I want to do that in this array all same names are convert into
one unique name.
In this array I want to ignore the "haider" name bcs it is
two time.How can I do that.
Remmber :: This example is very simple.Bcs u can
understand it easily.Suppose if it is dynamically changed array
then what i did do to make it unique.

I've been struggling with being able to send an e-mail via the php mail() function when the body of the e-mail includes a "unique" URL.

The string that will not work is:

"https://p11.secure.hostingprod.com/@www.domain.com/dir/directory/file.ext"


The point within the string that breaks the capability, is the "/" after www.domain.com.  I have tried escaping it like so:

"https://p11.secure.hostingprod.com/@www.domain.com\/dir/directory/file.ext"

This allows the e-mail to successfully send,  however the body of the e-mail contains the backslash as well as the frontslash.

Any ideas?

Hello PHP freaks,   my codes dont allow me to log-in to Student Home with unique id. It says "Invalid Login or Password" this is my form

<tr bgcolor="#E1E1E1" class="stylesmall">
              <td width="35%" align="left" class="style7 style1">Learner Id : </td>
                <td width="65%" align="left"><input name="learner_id" type="text" id="learner_id" action="Student_Home.php" method="post"></td>
              </tr>
            <tr bgcolor="#E1E1E1" class="stylesmall">
              <td align="left" class="style7 style1">Password:</td>
                <td align="left"><input name="student_password" type="password" id="student_password"><
/td>

and this is my handler.

<?php
	session_start();
	include 'Connect.php';
	$flag = "";
	$learner_id = $_POST['learner_id'];
	$student_id = $_POST['student_id'];
	$student_password = $_POST['student_password'];
	$query = "select last_login_date from student_information where student_id='$student_id' and student_password='$student_password'";
	$result = mysql_query($query,$link_id);
	if(mysql_error() != null){
		die(mysql_error());
	}
	if($date = mysql_fetch_array($result))
	{
        $lastdate = $date['last_login_date'];
	$date2 = date("d-m-Y h:i A",strtotime($lastdate));
	$_SESSION["student_id"] = $_POST["student_id"];
        $_SESSION["lastlogin"] =$date2;
	$_SESSION["type"] = "Student";
	mysql_query("UPDATE student_information SET last_login_date=now() where student_id='$student_id'",$link_id);
	if(mysql_error() != null){
	die(mysql_error());
	}
	header("location:  Student_Home.php?id={$student_id}");
		 die();
	}
	else
	{
		$flag = "invalid";
		header("location:Student_login.php?flag=$flag");
		die();		
	} 	
?>

PLease help me PHP friends to correct my codes.