PHP - Filtering Out Duplicate Entries From A While Loop

Hello,

i am inserting some form data into my mysql db, i happen to get some duplicates so i want to check first if the entry exists already before i insert.

my current code:

Code: [Select]
<?php

if(isset($_POST['submit']))  { ?>
<?php 
if (strlen($_POST['code']) == 19 && substr($_POST['code'],0,7) == '5541258')  { 
     mysql_query("INSERT INTO table(code,secret,ip,date) VALUES('$_POST[code]','$_POST[secret]','$_SERVER[REMOTE_ADDR]',CURDATE())");
Print "<font color='green'>The code will be checked now</font>"; 
} else { 
    
Print "<font color='red'>The code is invalid</font>"; 
}
?><?php } ?>
I would like to use the value 'code' to check if the entry exists, that one is unique for each entry. How would i do that ?

Thanks !

Hi all,   Its been a long time since last help request from real professional from here but I'm again in trouble with a much more spectacular plan I'm working on.

For those who are interested in the plan then here it is:
My Idea was to make a new build starting from scratch and make it as dynamical as possible. So my goal is not to make almost anything fixed in the code. I have made a decision to make a one supper large table for multiple different entries so no more joining and no more views for me.! In this help request I'm having trouble with Posting values to a page processing page lets call it record_changer.php The sole purpose of this file is to get form posts and decide what to do. Either update, delete, or insert.

record_changer.php
 

<?php

include '../../config/config.inc.php';

if(is_ajax()){
# Checks if action value exists
  if(isset($_POST["action"]) && !empty($_POST["action"])){
    $action = $_POST["action"];
# Switch case for value of action
    switch($action){
			case "insert": datatable_insert_function();
			break;
			case "update": datatable_update_function();
			break;
			case "delete": datatable_delete_function();
			break;
    }
  }
}

# Function to check if the request is an AJAX request
function is_ajax(){ return isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest'; }

function datatable_insert_function(){
}

function datatable_update_function(){
}

function datatable_delete_function(){
}

?>

The problem.

The problem is that the $insert places two entries to the DB. I cant seem to understand why.?

	# Test _POST values
	$_POST['UserID'] = '2';
	$_POST['WorkID'] = '22';
	$_POST['Status'] = '1';
	$_POST['Code'] = '1';
	$_POST['Title'] = '1';


	$columns = array();
	foreach(array_keys($_POST) as $name){
		# Exclude Action and ID
		if($name == 'Action' || $name == 'ID' || $name == 'submit' ){ continue; }
		$columns[] = $name;
	}

	print_r($columns);

	echo "<br>";

	$data = array_fill_keys($columns, 'NULL');

	print_r($data);

	foreach($data as $key => $value){
		$data[$key] = empty($_POST[$key]) ? 'NULL' : "'".mysql_real_escape_string($_POST[$key])."'";
	}

	echo "<br>";

	print_r($data);

	$insert = mysql_query('INSERT INTO datatable (ID, '.implode(', ',$columns).')VALUES (null, '.implode(',',$data).')') or die(mysql_error());

No errors no nothing. Just two entries of correct data. 
PS. Sorry for a lot of prints in the code it is work and idea in the progress. The posts at the moment are fixed in the code so it is easier to refresh and debug.

Please help if you spot the problem. Im really out of ideas. Some fresh eyes might make a difference.

And Please for those who want to say it is a bad idea and why and why and so on.. Move a long.!!! Im not interested in whinging i have a great use for this and just having trouble with the two entries.

Thanks.
Edited by ztimer, 14 January 2015 - 03:27 PM.

MySQL returns an error in the form of a number, a state, and a message. Without parsing the message you will not be able to determine what column is duplicated.While parsing the error code, I have also notice that, if you have multiple unique fields as duplicates, only the first duplicate encountered will be returned in the message. This is not very helpful to the end user.   Is there any way to parse the returned error code to reflect all duplicate fields, please see sample code below?

$error=array();
$sql = 'INSERT INTO staff(username, email, phone)
VALUES (?, ?, ?)';
$stmt = $conn->stmt_init();
$stmt = $conn->prepare($sql);
// bind parameters and insert the details into the database
$stmt->bind_param('sss', $username, $email, $phone);
$stmt->execute();
if ($stmt->errno == 1062) {
$errors[] = "One of the fields is already in use.";
}

For some reason my for loop only seems to be storing some data in my fields, most of the time the data is not true but simply duplicating one of the entries. So instead of having a string of 1,2,3,4 for instance it would store all of them as 4. The entires are selected using fields in a multiple select box, in theory of someone choses 10 unique entries from the "Systems" category all 10 should be made into rows in the MySQL table.

Any idea why this is happening?

The form,

if ($type == "games") {

echo "<tr><td>".$name."</td><td><select name='".$name."_".$i."'[] multiple='multiple'><option value='' selected>--------</option>";

$sqla = mysql_query("SELECT * FROM ".$pre."games ORDER BY `name` ASC") or die(mysql_error());

while($row2a = mysql_fetch_array($sqla)) {
$system = mysql_fetch_array(mysql_query("SELECT * FROM ".$pre."systems WHERE id = '".$row2a[system]."'"));
echo "<option value='".$row2a[id]."'>".$row2a[name]." - ".$system[name]."</option>";
}
echo "</select></td></tr>";
}

if ($type == "system") {
echo "<tr><td>".$name."</td><td><select name='".$name."_".$i."'[] multiple='multiple'><option value='' selected>--------</option>";

$sqlb = mysql_query("SELECT * FROM ".$pre."systems ORDER BY `name` ASC") or die(mysql_error());
while($row2b = mysql_fetch_array($sqlb)) {
echo "<option value='".$row2b[id]."'>".$row2b[name]."</option>";
}
echo "</select></td></tr>";
}

The PHP code,

while($row = mysql_fetch_array($query)) {
$name = "$row[name]";

for ($i = 0; $i < count($_POST["systems_$i"]); $i++) {
   mysql_query("INSERT INTO ".$pre."fielddata VALUES (null, 'systems', '".$_POST["systems_$i"]."', '".$fetch[0]."', 'content')");
}

for ($i = 0; $i < count($_POST["games_$i"]); $i++) {
   mysql_query("INSERT INTO ".$pre."fielddata VALUES (null, 'games', '".$_POST["games_$i"]."', '".$fetch[0]."', 'content')");
}

Code: [Select]
foreach ($items as $product ) {
echo $product;
?><input type="text" size="2" value="<?php  
\\display quantity here
  ?>" name="quantity" /><?php
}
$items is an array.  It has multiple values, some duplicate. How do i count the duplicate values in the array and display in this foreach loop?

i know array_count_values($product) but putting that in the foreach loop won't accomplish what i want.

another thing. i can get the foreach loop  to not display duplicates by doing this

Code: [Select]
foreach (array_unique($items) as $product ) {
echo $product;
?><input type="text" size="2" value="<?php  
\\display quantity here
  ?>" name="quantity" /><?php
}

how would i accomplish both.

basically i want it to display the quantity without displaying duplicate rows.  aka shopping cart.

Hi. I'm new to PHP and Wordpress, quite the beginner. I thought I finally had it all done on my site and I've stumbled on another issue.

Basically I post a link and it spits it out. I sometimes post links that have the same domain ($content['host']) but I don't want these to be duplicated.

Here's what I have:

Code: [Select]
<?php query_posts(''); ?>
<?php while (have_posts()) : the_post(); ?>

<li>
<a href="http://<?php $content = parse_url(strip_tags(get_the_content())); echo $content['host']; ?>">

<?php $content = parse_url(strip_tags(get_the_content())); echo $content['host']; ?></a>
</li>

<?php endwhile;?>
I've Googled around for a while, reading posts about how to prevent duplicate posts in multiple loops but can't adapt it to mine. I'd really appreciate any advice.

Cheers,
Craig.

Hi everybody, I have a problem and was wondering if I could pick your brains.

My situation is that I am making a fitness website and one feature is that the user can set themselves targets. Now each target has some fields that are mandatory (for example the date to be completed) and some fields that are unique to each target (for example if the target is weight loss I will need to grab the current weight/target weight fields). Just to make it clear I have all fields in the same database table.

So I have written a script that displays that users current targets they have set. It grabs all the data correctly but it duplicates the display and although I am pretty new to php even I can tell the code if not best practise because I have a query inside a loop and a loop inside another loop. Here is the code I have done so far:

Code: [Select]
//Get target types from database for that particular user
$get_user_targets = mysql_query("SELECT target_type FROM user_targets WHERE user_id='$id'") or die (mysql_error());
while ($row = mysql_fetch_array($get_user_targets)){
$target_type_display = $row['target_type'];

//If the target type is equal to Weight Loss run this script to get all the information and make a display
if($target_type_display == 'Weight Loss'){
//Search the database for all weight loass goals
$weight_loss_display_sql = mysql_query("SELECT current_weight, target_weight, target_date, date_set, extra_info FROM user_targets WHERE user_id='$id' AND target_type='$target_type_display'") or die (mysql_error());

//Put the data from the query into page variables
while($row1 = mysql_fetch_array($weight_loss_display_sql)){
$current_weight_loss_dis = $row1['current_weight'];
$target_weight_loss_dis = $row1['target_weight'];
$weight_loss_date_set_dis = $row1['date_set'];
$weight_loss_target_date_dis = $row1['target_date'];
$weight_loss_extra_info_dis = $row1['extra_info'];
//Convert date_set into ago time
$convertedTime = ($myObject -> convert_datetime($weight_loss_date_set_dis));
    $weight_loss_set = ($myObject -> makeAgo($convertedTime));

//Construst a display out of the collected variables
$weight_loss_display .= '<div class="blackText" style="width: 475px">
<table width="475px" class="blackText">
<tr><td class="profileUsername" colspan="2">'.$target_type_display.'</td></tr>
<tr><td width="250px">Current Weight:</td><td width="225px">'.$current_weight_loss_dis.'</td></tr>
<tr><td>Target Weight:</td><td>'.$target_weight_loss_dis.'</td></tr>
<tr><td>Date for completion:</td><td>'.$weight_loss_target_date_dis.'</td></tr>
<tr><td>'.$weight_loss_extra_info_dis.'</td><td><h6>Date set: '.$weight_loss_set.'</h6></td></tr>
</table>
</div>';
}
}
}


So far it just checks for a weight loss goal and I was going to expand the code with more if statements for each of the other types of target.

So my questions a

1)Can anybody see why the data is displaying twice?
2) Is there a better way of doing this? (NOTE: im not too worried that the code isn't best practise, I just want to get it functioning properly)


Thanks in advance for any help

I have a form and script that is used to collect information from users.
There is one field that is url.
There is one field that is email.

I want to filter out scripts.  I also only want to allow url in the url field and email in the email field.

Is there an easy way to filter?  I have tried several pieces of code to no avail.

Code: [Select]
<?php
$root = $_SERVER['DOCUMENT_ROOT'];
include('/home/arts/public_html/shows/includes/config.db.php');
if ($link)
{
  foreach ($_POST as $k => $v)
  {
    if (($k == "start_date") || ($k == "end_date") || ($k == "application_dead"))
  {
  $varray = explode("/",$v);
  $v = $varray[2] . "-" .  $varray[0] . "-" . $varray[1];  
  }
   
  $v = "'" . addslashes($v) . "'";
  
      
  if($k != "captcha_code") 
{
  
$keys[] = $k;
$vals[] = $v;
} 
  }
  
  $fields = implode(",", $keys);  
  $values = implode(",", $vals);
  //$fields = "id," . $fields;
  //$values = "null," . $values;  

  $sql = "INSERT into craft_shows ($fields) VALUES ($values)";  
  
  $result = mysql_query($sql,$link);
if (!$result) {
    die('There was a problem with your submission. Refresh the page to try again');
}
else
{
  echo "Thank you for your submission.<br>";
  echo "<a href=\"http://www.artsandcraftsnetwork.com/shows/\">Back to shows</a><br>";
  echo "<a href=\"http://www.artsandcraftsnetwork.com/shows/shows_submit.php\">Submit another show</a>";
}

  
}
?>

Hi there

I have the following array .

Code: [Select]
$products = array(   array( Code => "CF1",
                         Items => "Sand Tray",
                         Cat  => 'Tray',
                         ),
                  array( Code => "CF2",
                         Items => "Mobile Computer Table",
                         Cat  => 'Table',
                         ),
                  array( Code => "CF3",
                         Items => "General Service Trolley",
                         Cat  => 'Trolley',
                         ),
                  array( Code => "CF4",
                         Items => "TV Trolley",
                         Cat  => 'Trolley',
                         ),
                  array( Code => "CF5",
                         Items => "Overhead Projector Trolley",
                         Cat  => 'Trolley',
                         ),
                    array( Code => "CF6",
                         Items => "Book Trolley",
                         Cat  => 'Tolley',
                         ),
                         array( Code => "CF7",
                         Items => "Stacking Chairs",
                         Cat  => 'Chairs',
                         ),     
  ); 
What I want to do is select each by 'Cat'. For example I simply want to display all the trolleys. 

I was wondering how I do this? What functions would I use in PHP? 

Thanks a million 

Hi all,

    I am working on a tool to pull data remotely and the data is set to xml format. I want to post items that meet a certain criteria only, essentially there are several layers/tags on the data being brought over. The sStatus is the primary item I am looking for, not only that but only if it has or equals to "Waiting". Any thoughts or suggestions greatly appreciated. Below is the basic code I have in place currently and am working on.

<code>
<?php
$soapclient = new SoapClient("https://secure.logmeinrescue.com/api/api.asmx?wsdl");


$sEmail = "dummy@dum.com";
$sPassword = "dum123";
$iNodeID = "123456";   
$eNodeRef = "NODE";   
$sAuthCode = "";

$loginparams = array (
'sEmail' => $sEmail,
'sPassword' => $sPassword);

$loginResult = $soapclient->login($loginparams);

$output = array(
'eOutput' => "XML"
);

$outputResponse = $soapclient->setOutput($output);
         

$sessionparams = array(
'iNodeID' => $iNodeID,
'eNodeRef' => $eNodeRef,
'sAuthCode' => $sAuthCode
);

//get session(s)
$sessionresult = $soapclient->getSession($sessionparams);
$session = $sessionresult->aSessions;
$sessionnodes = $session->SESSION;
$session_status = $sessionnodes[$isessionNodes]->sStatus;
   
   

print_r($sessionresult);

?>
</code>

First off, i have made a validation class using array_diff() to check if there are invalid characters submitted by a user.
Some extracts:
Code: [Select]
$this->chr_alpha_lower=array('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z');
$this->chr_alpha_upper=array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z');
$this->chr_numeric=array('0','1','2','3','4','5','6','7','8','9');
$this->chr_symbol=array(' ','!','@','#','$','%','&','(',')','[',']','.',',',':',';','\'','"','/','=','\\','-','_','?');

...

// lets say only alpha and numeric characters are allowed
$allowed_characters=array();
$allowed_characters=array_merge($allowed_characters,$this->chr_alpha_lower,$this->chr_alpha_upper);
$allowed_characters=array_merge($allowed_characters,$this->chr_numeric);

$input_split=str_split($this->input);
$invalid=array_diff($input_split,$allowed_characters);

if(empty($invalid)){
return true;
}
return false;

I have two questions.
First, for acsii characters is this method 'full proof' or is there a way for someone to get around this validation script?

Second, a new site im developing is going to be built with UTF-8 in mind so people can use the site in their own language. How do i validate UTF-8 user input? I know about mb_strings and sanitizing UTF-8 input using this:
Code: [Select]
preg_match_all('/([\x09\x0a\x0d\x20-\x7e]'. // ASCII characters
 '|[\xc2-\xdf][\x80-\xbf]'. // 2-byte (except overly longs)
 '|\xe0[\xa0-\xbf][\x80-\xbf]'. // 3 byte (except overly longs)
 '|[\xe1-\xec\xee\xef][\x80-\xbf]{2}'. // 3 byte (except overly longs)
 '|\xed[\x80-\x9f][\x80-\xbf])+/', // 3 byte (except UTF-16 surrogates)
 $input, $clean_pieces );

$clean_output = join('?', $clean_pieces[0] );

But how do i know what to filter?

Example:
a field for the user to input first name
English: only alpha characters
Other language: ?????

Help much appreciated.

I'm pretty sure the problem is starring me in the face, but I can't seem to locate it.


function filter($string)
{
//swear words pulled from bannedwordlist.com
$f = fopen('../badwords.txt', 'r');
$bad_words = fread($f, filesize('../badwords.txt'));
$bad_words = explode('\n', $bad_words);

$input = strtolower($string);

foreach($bad_words as $value)
{
$string = str_replace($value, '****', $input);
}

return $string;
}


UPDATED CODE

function filter($string)
{
//swear words pulled from bannedwordlist.com
$f = fopen('../badwords.txt', 'r');
$bad_words = fread($f, filesize('../badwords.txt'));
$bad_words = explode('\n', $bad_words);

$input = strtolower($string);
$string = str_replace($bad_words, '****', $input);

return $string;
}


I've already echoed out $value in the foreeach loop, and it does correctly retrieve the bad words and put them into an array. My only problem is, the returned string is still in strtolower() form, and the words aren't censored. :/

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=334433.0

I want to create a feature as you see nn this image, where it says 'filter your results' if a user clicks 'Detached Houses' then only detached houses will be displayed. if a user clicks 'Semi-detached' then only semi detached houses will be shown.
Any help is really appreciated, thank you.
Code: [Select]

<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td><div id="filter"><p class="houses" style="font-family:helvetica;color:#0155a1;font-size:14px;background:url(cutouts/forsale/filter.jpg) no-repeat;"><b><u>Houses</u></b>
<br />
<span class="dh"><b><u>Detached Houses</u></b></span><?php
// Make a MySQL Connection
mysql_connect("localhost", "admin", "1admin") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

// Get a specific result from the "example" table
$result = mysql_query("SELECT * FROM example
 WHERE name='Sandy Smith'") or die(mysql_error());  

// get the first (and hopefully only) entry from the result
$row = mysql_fetch_array( $result );
// Print out the contents of each row into a table 
echo $row['name']." - ".$row['age'];
?>
<br />
<span class="dh"><b><u>Semi-detached houses</u></b></span>
<br />
<span class="dh"><b><u>Terraced houses</u></b></span>
<br />
<br />
<b><u>Flats / Apartments</u></b>

</p></div></td>