PHP - How To Get An Array Value By: 1) Unique Key And 2) Numerical Index (row Number)

Hey guys,
I m not yet an experienced coder. SO faced alot of problems. Here, I'm trying to generate a UNIQUE RANDOM NUMBER set between two numbers. Repetative occurance must be avoided by all means as I want every number so generated bears a unique value. In other words, every values that made entry into the field of my database should be differant from each others.


<?php
$conN=mysql_connect("localhost","root","");
if(!$conN)
{
die('error'.mysql_error());
}
mysql_select_db("freebie_allusers",$conN);
$UIN=mt_rand(1,5);
$locateUIN="SELECT UIN FROM user_info WHERE UIN='".$UIN."'";
$fetchUIN=mysql_query($locateUIN);
$resultUIN=mysql_num_rows($fetchUIN);
if($resultUIN>0)
{



WHAT CODE IS REQUIRED HERE SO AS TO GENERATE UNIQUE RANDOM NUMBER?






}

else 
echo $UIN;
?>

Thanx in advance

Hi all,

I'm trying to create a PHP script for user's profile to display the amount of times they've been viewed. I'm looking to have this script increase on a unique view, and it should update the variable in the database.

Profiles are accessed by the following link: userprofile.php?userid=X (where X is the ID, e.g. 1, 2, 1001, 345982, etc.).

The database variable I'm looking to update is called ProfileViews.

I began developing the script, which is as follows:

Code: [Select]
$_SESSION['Viewed'] = 0;

if ($_SESSION['Viewed'] == 0) {

$profileViewsQuery = mysql_query("SELECT ProfileViews FROM Users WHERE UserID='????'");

$getProfileViews = mysql_fetch_array($profileViewsQuery);

$profileViews = $getProfileViews['ProfileViews'];

$profileViews = $profileViews + 1;

mysql_query("UPDATE Users SET ProfileViews='$profileViews' WHERE UserID='????'");

$_SESSION['Viewed'] = 1;

}

However, I'm stumped on a couple things. Could you possibly help me out?

1. How can I get the script to recognize the link accessed's ID? E.g. when a user goes to userprofile.php?userid=1001, how can I get the script to identify the ID to update should be 1001? This is where the "????" would be replaced in the code.
2. On page load, the variable is always going to be $_SESSION['Viewed'] = 0, which isn't going to produce unique hits. Do you have any recommendations how I could achieve unique hits using this method?

Thanks very much for reading.

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.

Hi guys,

How would I write a small script in php to count the unique values in the below array :

the below code if part of cubecart 3.20 shopping cart, I need to count the unique number of  Seller_ID fields within this array in the basket
to be able to calculate shipping according to the number of sellers. How would I to this ? please any help is appreciated.


Code: [Select]
if(isset($_GET['act']) && $_GET['act']=="step4"){
// set live vars for order inv and its the last step
$view_cart->assign("QUAN_DISABLED","disabled");
$view_cart->assign("TEXT_BOX_CLASS","textboxDisabled");
$basket = $cart->setVar($productId,"productId","invArray",$i);
$basket = $cart->setVar($product[0]['name'],"name","invArray",$i);
$basket = $cart->setVar($product[0]['productCode'],"productCode","invArray",$i);
$basket = $cart->setVar($plainOpts,"prodOptions","invArray",$i);
$basket = $cart->setVar(sprintf("%.2f",$price*$quantity),"price","invArray",$i);
$basket = $cart->setVar($quantity,"quantity","invArray",$i);
$basket = $cart->setVar($product[0]['digital'],"digital","invArray",$i);
$basket = $cart->setVar($product[0]['Prod_Seller'],"Prod_Seller","invArray",$i);
$basket = $cart->setVar($product[0]['Seller_ID'],"Seller_ID","invArray",$i);

}  else {
$basket = $cart->unsetVar("invArray");
}

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.

Right now I have an array of zipcodes with open invitations; I want to loop over the array of zipcodes, query the database and get the name of each zipcode and then remove duplicate names.

So if 90210, 90211 and 90212 are in the array with the first 2 being City A and the last one being City B, I just want City A and City B, not City A, City A, City B.

Right now I'm doing this:
Code: (php) [Select]
foreach($invitation_Zipcodes as $key => $value){
echo 'Key: '.$key.' Value: '.$value.'<br/>';

$csaname_sql = "SELECT CBSA_Name FROM ZIPCodes WHERE ZipCode = '$value'";
$csaname_result = mysql_query($csaname_sql);
$csaname_array[] = mysql_fetch_assoc($csaname_result);

}

//$csaname_array = array_unique($csaname_array);

print_r($csaname_array);
echo '<hr/>';
print_r($invitation_Zipcodes);
exit;
That outputs this:
Quote

Array
(
    => Array
        (
            [CBSA_Name] => Crestview-Fort Walton Beach-Destin, FL
        )

    [1] => Array
        (
            [CBSA_Name] => Crestview-Fort Walton Beach-Destin, FL
        )

    [2] => Array
        (
            [CBSA_Name] => Crestview-Fort Walton Beach-Destin, FL
        )

    [3] => Array
        (
            [CBSA_Name] => Crestview-Fort Walton Beach-Destin, FL
        )

    [4] => Array
        (
            [CBSA_Name] => Pensacola-Ferry Pass-Brent, FL
        )

)
<hr/>Array
(
    => 32548 [1] => 32579
    [2] => 32578
    [3] => 32580
    [7] => 32501
)

If I uncomment the unique call, it outputs this:
Quote

Array
(
    => Array
        (
            [CBSA_Name] => Crestview-Fort Walton Beach-Destin, FL
        )

)
<hr/>Array
(
    => 32548 [1] => 32579
    [2] => 32578
    [3] => 32580
    [7] => 32501
)

What am I doing wrong? Why is it losing "Pensacola-Ferry Pass-Brent, FL" ?

Hi I am new this forum and looking for some much appreciated help with something that has me stumped.

I have extracted regions from image names in a directory.

example: 'edinburgh_castle_(Edinburgh).jpg' (Extracted Edinburgh from in-between the brackets)

So I have a list of Regions, extracted from all the various image names in the directory which I want to populate into a dynamic drop down menu for filtering purposes.

Here's my issue...

I want there to be only one 'Edinburgh' option appearing in my drop down menu. I don't want duplicates.
  Here is my code so far.
  php: [Select]

I have an array that looks like this:

 

array(5642) {

[0]=> string(19) "2021-02-10 09:04:48"

[1]=> string(19) "2021-02-10 09:04:54"

[2]=> string(19) "2021-02-10 09:05:00"

[3]=> string(19) "2021-02-10 09:05:06"

[4]=> string(19) "2021-02-10 09:05:12"

[5]=> string(19) "2021-02-10 09:05:18"

[6]=> string(19) "2021-02-10 09:06:18"

[7]=> string(19) "2021-02-10 09:06:24"

}

 

I need to group the instances any time there is more than a 6 second gap between elements. So 0 =>5 would be one array and 6 and 7 would be a new array.

 

Ive been able to produce the following but its not ideal

 

array(5642) {

[0]=> string(19) "2021-02-10 09:04:48"

[1]=> string(19) "2021-02-10 09:04:54"

[2]=> string(19) "2021-02-10 09:05:00"

[3]=> string(19) "2021-02-10 09:05:06"

[4]=> string(19) "2021-02-10 09:05:12"

[5]=> string(19) "2021-02-10 09:05:18"

[6]=> string(19) "end"

[7]=> string(19) "2021-02-10 09:06:18"

[8]=> string(19) "2021-02-10 09:06:24" }

 

$burner_time = array();

foreach($Burner_Control_Alm as $new_burner){ $burner_time[] = strtotime($new_burner); }

$repl = 'end'; for ($i=1; $i<count($burner_time); $i++) { $value_second = $burner_time[$i]; $value_first = $burner_time[$i-1] === $repl ? $burner_time[$i-2] : $burner_time[$i-1]; if ($value_second > $value_first + 6) {

array_splice($burner_time, $i++, 0, $repl);

}

print_r($burner_time);

}

I wonder whether someone may be able to help me please. I'm fairly new to PHP programming so please bear with me.

I currently have a HTML user input form, where two of the fields are dependable drop down boxes. The user selects text values from these and, along with other pieces of information, the record is saved to a mySQL database. However, rather than saving the text value I save the 'id' field value for each selection made.

On another 'Read Only' form, the user can then go back to have a look at the records they have previously saved.

The problem I have is that rather than the user being able to see the text values selected from the drop down menus, they can only see the id for each of the selections made. I just wondered whether it would be at all possible please that someone could show me what I need to do so that the user can see the 'text' rather than the 'id' value from the selections they have made.

The code that I am using to load the information into the read only form is below.

Code: [Select]
<?php 
require("phpfile.php"); 

// Start XML file, create parent node 

$dom = new DOMDocument("1.0"); 
$node = $dom->createElement("markers"); 
$parnode = $dom->appendChild($node); 

// Opens a connection to a MySQL server 

$connection=mysql_connect ("hostname", $username, $password); 
if (!$connection) { die('Not connected : ' . mysql_error());} 

// Set the active MySQL database 

$db_selected = mysql_select_db($database, $connection); 
if (!$db_selected) { 
die ('Can\'t use db : ' . mysql_error()); 
} 

// Select all the rows in the table 

$query = "SELECT findid, locationid, detectorid, searchheadid "; 

$result = mysql_query($query); 
if (!$result) { 
die('Invalid query: ' . mysql_error()); 
} 

header("Content-type: text/xml"); 

// Iterate through the rows, adding XML nodes for each 

while ($row = @mysql_fetch_assoc($result)){ 
// ADD TO XML DOCUMENT NODE 
$node = $dom->createElement("marker"); 
$newnode = $parnode->appendChild($node); 
$newnode->setAttribute("findid",$row['findid']); 
$newnode->setAttribute("locationid",$row['locationid']); 
$$newnode->setAttribute("detectorid",$row['detectorid']);
$newnode->setAttribute("searchheadid",$row['searchheadid']);
} 

echo $dom->saveXML(); 

?> 

The two fields concerned are 'detectorid' and 'searchheadid'. The tables holding the 'id' and 'text' values for each are in the following tables 'detectors' and searchheads'.

Many thanks and kind regards

Chris

Hi all,

I have a situation where I need to remember what check boxes where checked over pagination, I have managed to do this via the use of this:

http://jamesfunk.com/wordpress/?p=65

The problem is that as the code stood:

Code: [Select]
<input type="checkbox" name="compare" value="<?php echo $list['jobseeker_id'];?>" class="remember_cb"/>
It was treating one ticked checkbox as them all because they all have the same name and are in the a while loop!

I countered this by changing the code to:

Code: [Select]
<input type="checkbox" name="compare<?php echo $list['jobseeker_id']?>" value="<?php echo $list['jobseeker_id'];?>" class="remember_cb"/>
Which effectively now makes the checkbox name unique... i.e. compare{id}.

The problem with this is that I can now no longer process it. This is my processing code:

$jobseekers = $_POST['compare'];
$i = 0;
for($i; $i<count($jobseekers); $i++){
$query = "SELECT * FROM jobseekers WHERE jobseeker_id = '$jobseekers[$i]'";
$result = mysql_query($query) or die (mysql_error());

while ($row = mysql_fetch_array($result)) {
// Spit out the required data
}
}

As you can see I am trying to get the data from $_POST['compare'], which will obviously now be blank as I have had to make the name unique.... the trouble is I'm not sure how to actually process this.

Can anyone help me out here? any help or advice would be greatly appreciated!

many thanks,

Greens85

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

I have a very simple piece of code to create a grid based gallery. The thumbnails are loaded from a single directory and are name 1.jpg... 2.jpg... 3.jpg etc

At the moment the images appear to be loaded in randomly. I want them to load in numerically in terms of their filename. I know I may need to use 'sort' or 'natsort' but where in the code?

Thanks for any help you can give me

Code: [Select]
<?

$images = "Images/Bag Thumbs/"; # Location of small versions

$big    = "ruxxwomens.php?id="; # Location of big versions (assumed to be a subdir of above)

$cols   = 4; # Number of columns to display

if ($handle = opendir($images)) {
   while (false !== ($file = readdir($handle))) {
       if ($file != "." && $file != ".." && $file != rtrim($big,"/")) {
          $files[] = $file;
       }
   }
   closedir($handle);
}



$colCtr = 0;
echo '<table width="800" cellspacing="0" cellpadding="0" border="0"><tr>';
foreach($files as $file)
{
  if($colCtr %$cols == 0)

    echo '</tr><tr>';

  echo '<td align="center"><a href="' . $big . $file . '"><img src="' . $images . $file . '" cellspacing="0" cellpadding="0" border="0"></a></td>';

  $colCtr++;
}
echo '</table>' . "\r\n";

?>

I tried searching for this but I didn't find anything.  I have some php code that when loaded from a web page draws some numbers from a database and outputs.  Should be no problem I thought

The code involves a mysql query.  This is an edited sample:
$query = "SELECT `count` FROM `uc` WHERE `id` = 17";
$result = mysql_query($query, $dbh) or die(mysql_error());
$row = mysql_fetch_array($result, $dbh);


Now after this I normally access $row as $row[0] and this works great most of the time.  However about 10% of the time it returns an error: "Notice: Undefined offset: 0"

My investigation using print_r($row); shows that sometimes it returns Array ( => 619 ) and sometimes it returns Array ( [count] => 619 )

Why the inconsistency?  How can I make it always use a numeric index?

I'm getting the dreaded " Invalid parameter number: number of bound variables does not match number of tokens" error and I've looked at this for days.  Here is what my table looks like:

|  id          | int(4)       | NO   | PRI | NULL    | auto_increment |
| user_id     | int(4)       | NO   |     | NULL    |                |
| recipient   | varchar(30)  | NO   |     | NULL    |                |
| subject     | varchar(25)  | YES  |     | NULL    |                |
| cc_email    | varchar(30)  | YES  |     | NULL    |                |
| reply       | varchar(20)  | YES  |     | NULL    |                |
| location    | varchar(50)  | YES  |     | NULL    |                |
| stationery  | varchar(40)  | YES  |     | NULL    |                |
| ink_color   | varchar(12)  | YES  |     | NULL    |                |
| fontchosen  | varchar(30)  | YES  |     | NULL    |                |
| message     | varchar(500) | NO   |     | NULL    |                |
| attachment  | varchar(40)  | YES  |     | NULL    |                |
| messageDate | datetime     | YES  |     | NULL    |        

Here are my params:

            $params = array(                 
               ':user_id' => $userid,                 
               ':recipient' => $this->message_vars['recipient'],                 
               ':subject' => $this->message_vars['subject'],                 
               ':cc_email' => $this->message_vars['cc_email'],                 
               ':reply' => $this->message_vars['reply'],                 
               ':location' => $this->message_vars['location'],                 
               ':stationery' => $this->message_vars['stationery'],                 
               ':ink_color' => $this->message_vars['ink_color'],                 
               ':fontchosen' => $this->message_vars['fontchosen'],                 
               ':message' => $messageInput,                 
               ':attachment' => $this->message_vars['attachment'],                 
               ':messageDate' => $date             );

Here is my sql:

$sql = "INSERT INTO messages (user_id,recipient, subject, cc_email, reply, location,stationery, ink_color, fontchosen, message,attachment) VALUES( $userid, :recipient, :subject, :cc_email, :reply, :location, :stationery, :ink_color, :fontchosen, $messageInput, :attachment, $date);";

And lastly, here is how I am calling it:
            $dbh = parent::$dbh;             
           $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);              
           if (empty($dbh))    return false;             
                  $stmt = $dbh->prepare($sql);             
                 $stmt->execute($params) or die(print_r($stmt->errorInfo(), true));              
           if (!$stmt) {    print_r($dbh->errorInfo());              }

I know my userid is valid and and the date is set above (I've echo'd these out to make sure).  Since the id is auto_increment, I do not put that in my sql (though I've tried that too), nor in my params (tried that too).  What am I missing?  I feel certain it is something small, but I have spent days checking commas, semi-colons and spelling.  Can anyone see what I'm doing wrong?

I've got a multidimensional array that has 2 columns.  The first column is numerical (country_id), and the second column is text (country_name), which may or may not be data that will be turned into an array. 

Looks something like this:

column 1 (index 0) = 42
column 2 (index 1) = Great Britain|England

I use a while loop to create an array of these rows, then a use a foreach loop to go through index[1] of each row.  If there is a single name for a country, it is added to a new array, but if there is more than one name for a country, then both names are added to the new array. So, for example, if we had this data:

row1
column 1 (index 0) = 12
column 2 (index 1) = Algeria

row2
column 1 (index 0) = 22
column 2 (index 1) = Ethiopia

row3
column 1 (index 0) =42
column 2 (index 1) = Great Britain|England

Then the final array would look like this:

index[0] = 12  index[1] = Algeria
index[0] = 22  index[1] = Ethiopia
index[0] = 42  index[1] = Great Britain
index[0] = 42  index[1] = England

Now I would like to sort by index[1] to get the following alphabetical order:

index[0] = 12  index[1] = Algeria
index[0] = 42  index[1] = England
index[0] = 22  index[1] = Ethiopia
index[0] = 42  index[1] = Great Britain

What do I use?  I've fooled around with sort, usort, asort ... can't figure it out.

Thanks in advance.