PHP - Buttons With Unique Id

I can't figure out why my $_POST['join'] isn't working.  Does my form need to be inside my foreach?

Code: [Select]
<?php

if(is_admin($user_info['uid'], $info['companyid']) === false)
{
if (isset($_POST['join']))
{
echo "works";
die();
}

$companies = fetch_company_by_name($info['cname']);

?>
<table class="feed pts pbl">
<?php

foreach ($companies as $company)
{
?>
<tr class="mbm">
<td>
<form method="post" id="ccreateform" class="man">
<input type="submit" name="join[<?php echo $company['companyid']; ?>]" value="Join" />
</form>
</td>
</tr>
<?php
} 

?>
</table>
<?php
}

?>

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();
    }
    }

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.

Hi:

Not sure if this is where to ask this (maybe it's a mySQL Issue)??

I am working on a zip code locator. The field/column "zip" (which holds the zip codes) is set as a UNIQUE Key in the database.

Problem is:

I want to allow people to enter a new city if there is one they want to add. The only way I can do this is to remove the  UNIQUE Key from the column, or I get an error. Some cities - like Malvern, PA and Frazer, PA - have the same zip code: 19355

This works fine, but the issue that now happens is the zip locator on the frontend will no longer find that zip code.

Does anyone know what a solution might be?

I can post the zip locator code, and maybe there's a chunk of code I can remove or alter to fix this?

Not sure how to address this one.

ok so i have an array which has duplicate values in it.

i used array_unique() to remove duplicate values.

the array had values 1,2,2,3.

after the following code:


$unique = array_unique($suggest);
$size = count($unique);
for ($x=0;$x<=$size;$x++)
{

     echo $unique[$x];
echo "<br>";
}



it prints out 1,2 and then gives an error, "Notice: Undefined offset: 2 in E:\wamp\www\Copy of pro2\Classes.php on line 1074" and then finally 3.

any ideas  how i can solve this.

im assuming that array_unique() assigns the index 0,1,3 of the duplicate value array to unique array at the same indexs 0,1,3. since the index 2 of duplicate array is a duplicate value it is ommited but the unique array does not have an array at index 2.