PHP - Trying To Remove Duplicate Values While Entering It Into A Database

Hi everyone, I need a little bit of help finishing off my code. Ive managed to get this far.

Code: [Select]
<?php
mysql_connect("") or die ("Not Connected to MYSQL");
echo "</br>";
mysql_select_db("") or die ("Not Connected to DB");
// Database Connection stuff

$partialNumber = $_POST['partialNumber']; // Post the Partial number
$partialNumber = strtoupper($partialNumber);
$numberSearch = mysql_query("SELECT * FROM product_option_value_description WHERE name LIKE '%$partialNumber%'") or die (mysql_error()); // Query to select the key number

//Query to get product ID //

$productId = "SELECT product_id FROM product_option_value_description";

//Query to get product ID //

while ($keyNumber = mysql_fetch_array($numberSearch)) {
$id = $keyNumber['product_id'];
// Query for the images // 
$query = "SELECT image FROM product WHERE product_id = '$id'";
$result = mysql_query($query);
$row = mysql_fetch_array($result) or die(mysql_error());

$query2 = "SELECT product_option_id FROM product_option_value WHERE product_id = '$id'";
$result2 = mysql_query($query2);
$row2 = mysql_fetch_array($result2) or die(mysql_error());

$query3 = "SELECT product_option_value_id FROM product_option_value WHERE product_id = '$id'";
$result3 = mysql_query($query3);
$row3 = mysql_fetch_array($result3) or die(mysql_error());
?>
    <div>
   
    <br /><br />
    Key Number: <? echo $keyNumber['name']; ?></a>
   
    <form action="http://www.co.uk/teststore/index.php?route=checkout/cart" method="post" enctype="multipart/form-data" id="product">
<br />
<table style="width: 100%;">
<tr>
<td>
Colour:
<select name="option[<? echo $row2['product_option_id']; ?>]">
<option value="<? echo $row3['product_option_value_id']; ?>"></option>
</select></td>
</tr>
</table>
<div class="content"> Qty: <input type="text" name="quantity" size="3" value="1" />
    <input type="hidden" name="product_id" value="<? echo $id; ?>" />
    <input name="submit" type="submit" value="Add to Cart" />

</div>
</form>
<? echo $row3['product_option_value_id']; ?>
</div>
<br />
<img height="150" width="150" src='http://www.co.uk/teststore/image/<? echo $row['0']; ?>'/>
<? }
 ?>

And here is my SQL Table code.

Code: [Select]
product_option_value_id product_option_id product_id
599                302                49
598                302                49
589                297                42
588                297                42

So as you can probably tell, it is a search program that looks for products on a shopping cart. The products will have different option values, and the php script will grab the option values and echo them in a form to post back to the cart to add the product to the basket.

The problem is that the "product_option_value_id" can have lots of different values, but my code echos only the first one it finds. So when I click the add to cart button, it will only add the first option value for the product it finds.

For some reason I am having a hard time explaining this, so I hope someone can help me.

Thanks for looking.

I have created an input field on a website for people to subscribe by their email address. The email address is stored in a database. I am using PHPMyAdmin.

The email address is successfully working, but I want to prevent duplicate email address to be stored, however, I am having an error. Here are my codes:

HTML codes:

Code: [Select]
<form action="index.php" method="post">
<input type="text" size="25" placeholder="Your email address..." name="enter"/>
<input class="submit" type="submit" value="Subscribe" name="subscribe"/>
<br/>
PHP with Query codes:

Code: [Select]
<?php
if ( $_SERVER['REQUEST_METHOD'] == "POST" ) {
$ee = htmlentities($_POST['enter']);
if (!preg_match('/^[^0-9][a-zA-Z0-9_]+([.][a-zA-Z0-9_]+)*[@][a-zA-Z0-9_]+([.][a-zA-Z0-9_]+)*[.][a-zA-Z]{2,4}$/',$ee) || empty($ee)){
echo '<p class="fail">Failed...Try again!</p>';
} else {
@mysql_connect ('localhost', 'root', '') or die ('A problem has occurred, refresh the page and try again!');
@mysql_select_db ('links') or die ('A problem has occurred, refresh the page and try again!');
$duplicate = "SELECT * FROM `email` WHERE `emailaadress` = '{$ee}'";
$query = "INSERT INTO email (id, emailaddress) VALUES('NULL', '.$ee')";
$result = mysql_query($duplicate);
if ( mysql_num_rows ( $result ) > 1) {
/* Username already exists */
echo 'Username already exists';
} else {
mysql_query($query);
echo '<p class="success">Successfully subscribed!</p>';
}
}
}
?>

Error I am having:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\softwareportfolio\index.php on line 68

Can someone help me? Thank

I am quite new so I am sure this is an easy fix for some of the experts around here.

I am using the canned script below to add urls to the database as text.  The problem is if you update one of the form text boxes it loads all the urls into the database again resulting in a lot of duplicates.

My question is, How do I get the form to only post the new changes and not re-post the existing urls?


<?php
session_start();

   if(isset($_SESSION['userSession']) && !empty($_SESSION['userSession']))
   {
        include_once("dbc.php");

        if($_POST)
        {
            $c = 0;
            
            $errMssg = "";

            for($i=0;$i<count($_POST['url']);$i++)
            {
                if($_POST['url'][$i]=="")
                {
                    $c++;
                }
            }
            if($c==5)
            {
                $errMssg = "Submission error . Please fill at least 1 url.";
            }
            else
            {
                for($j=0;$j<count($_POST['url']);$j++)
                {
                    if(!empty($_POST['url'][$j]))
                    {
                        $sql = mysql_query("INSERT INTO images (id ,url ,user_id)VALUES (NULL , '".$_POST['url'][$j]."',".$_SESSION['userId'].")");    

                     }
                                    
                }
                
            }
        }    

        
        

        $sqlresult = mysql_query("SELECT * FROM images WHERE user_id =".$_SESSION['userId']);
        
        $count = 0;
            
        while($data = mysql_fetch_array($sqlresult))
        {
            $image[$count] = $data['url'];

            $count++;

        }
         
?>

hello every body... two I'm creating an IPN in paypal for my membership site but the problem I'm facing is that on successfull verification of the purchase, four rows are getting inserted in the database...   The code is

<?php   
    require '../db.php';
    $paypalmode     =   '.sandbox';        
    $req = 'cmd=' . urlencode('_notify-validate');
    foreach ($_POST as $key => $value) {
        $value = urlencode(stripslashes($value));
        $req .= "&$key=$value";
    }
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, 'https://www'.$paypalmode.'.paypal.com/cgi-bin/webscr');
    curl_setopt($ch, CURLOPT_HEADER, 0);
    curl_setopt($ch, CURLOPT_POST, 1);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $req);
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 1);
    curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2);
    curl_setopt($ch, CURLOPT_HTTPHEADER, array('Host: www'.$paypalmode.'.paypal.com'));
    $res = curl_exec($ch);
    curl_close($ch);

    if (strcmp ($res, "VERIFIED") == 0)
    {
        $transaction_id = $_POST['txn_id'];
        $payerid = $_POST['payer_id'];
        $firstname = $_POST['first_name'];
        $lastname = $_POST['last_name'];
        $payeremail = $_POST['payer_email'];
        $paymentdate = $_POST['payment_date'];
        $paymentstatus = $_POST['payment_status'];
        $mdate= date('Y-m-d h:i:s',strtotime($paymentdate));
        $otherstuff = json_encode($_POST);
        $date = date("y-m-d");
        
            $q = $pdo->connect()->query("INSERT INTO payment (mid,username,amount,paypal_id,txn_id,received_date)   VALUES('{$_SESSION['user_id']}','{$_SESSION['uname']}','{$_POST['mc_gross']}','{$_POST['payer_email']}','{$_POST['txn_id']}','$date')");
            $q->execute();
            $q1 = $pdo->connect()->query("UPDATE members SET amount_loaded = amount_loaded + {$_SESSION['amount']} WHERE mid = '{$_SESSION['user_id']}'");
            $q1->execute();
            //header("Location: funds.php");
            echo "verified";
        
        
}



?>

two for the payment and in the members table, the amount is getting doubled. (i.e if anybody purchases For $2, it shows $4 in the database....)   Any help will be really appreciated...

hey guys, I'm getting a problem uploading my csv file to mysql database, the code on the top half just makes sure that I don't import data that I don't want into the database, numbers that are too high or too low on certain rows, and the second half is importing the array that I create from the csv file into the database however I'm getting the following error       Duplicate entry 'Array' for key 'strProductCode'   Now I've never had this error before and I'm not sure what's causing it so any help would be very much appreciated

$data = array();
if (($handle = fopen("stock.csv", "r")) !== FALSE) {
while (($row = fgetcsv($handle, 1000, ",")) !== FALSE) {
// only add rows to the array where the 4th column value is greater than or equal to 10
if(($row[3] >= 10 && $row[4] >= 5) OR ($row[3] >= 0 AND $row[4] > 5)){
if($row[4] < 1000){
$data[] = $row;
}
}
}


foreach ($data as &$value) {


mysql_query("INSERT INTO tblProductData 
(intProductDataId, strProductCode, strProductName, strProductDesc, strProductStock, strProductCost, dtmDiscontinued, dtmAdded, stmTimestamp) 
VALUES(null, '$data[0]', '$data[1]', '$data[2]', '$data[3]', '$data[4]', 'time', 'added', 'time') ") 
or die(mysql_error());  


}
}

I am having a big problem in MySQL and a part in my PHP coding as well.

I created a registration form, where the user will have to fill his names, email address, choose a username and so on. I do not want duplicate email address and username in my database, thus, if a user choose either an email address or a username which has already taken, he will be notified.

To prevent this duplication, I have set both the email address and username fields as UNIQUE KEY in MySQL.

My problems a

Even by setting both the username and email address fields as UNIQUE KEY, it is not working as I can register using the same email address or username. How to solve this?

I have coded also to prevent this problem of duplicate so that the user will be notified to choose another email or username, but I am having a warning.

My PHP codes:
Code: [Select]
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if (isset($_POST['fname']) && isset($_POST['lname'])&& isset($_POST['emailr']) && isset($_POST['user']) && isset($_POST['pass'])) {
//Assignng variables        
$firstname = mysql_real_escape_string($_POST['fname']);
$lastname = mysql_real_escape_string($_POST['lname']);    
$email = mysql_real_escape_string($_POST['emailr']);
$uname = mysql_real_escape_string($_POST['user']);
$pwd = mysql_real_escape_string($_POST['pass']);
$pmd= md5($pwd);
//Database
$connect = mysql_connect('localhost', 'root', '') or die ('Connection Failed');
mysql_select_db('registration', $connect) or die ('Connection Failed');

//Registration codes

if (empty($firstname) || empty($lastname) || empty($email) || empty($uname) || empty($pmd)) {
echo '<p class="error">All fields are required to fill!</p>';
return false;
} elseif (strlen($firstname) && (strlen($lastname) < '2')) {
echo '<p class="error">Invalid first name or last name!</p>';
return false;
} elseif (filter_var($firstname, FILTER_VALIDATE_INT) || (filter_var($lastname, FILTER_VALIDATE_INT))) {
echo '<p class="error">First name or last name cannot be integers!</p>';
return false;
} elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
echo '<p class="error">Email address not valid!</p>';
return false;    
} elseif (strlen($uname) && (strlen($pmd) < '6' )) {
echo '<p class="error">Username or password must be minimum 6 characters!</p>';
return false;
} else {
$query = "INSERT INTO login (id, firstname, lastname, emailaddress, username, password) VALUES('', '$firstname', '$lastname', '$email', '$uname', '$pmd')";
mysql_query($query, $connect);    
if (mysql_num_rows(mysql_query("SELECT * FROM login WHERE emailaddress = '$email' username = '$uname'"))) {
echo '<p class="fail">This email or username is already taken!</p>';
}
}
}
}
?>
The warning message I am getting:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\miniimagehosting\register.php on line 44

First of all excuse me if this topic is inappropriate in this forum. But I think it's rather a PHP problem.

I can't figure out multiple duplicate database records on submitting a form.

The database table have two columns:  the first one 'Id' with AUTO_INCREMENT and the second one 'Name'.

Here's the php code for database insertion and the form:
------------------------------------------------------------------

<?php

if($_GET['add_name']){
    $host = *******;
    $user = *******';
    $pass = *******;
    $db = *******;
    $con = mysql_connect($host,$user,$pass) or die;
    mysql_select_db($db,$con);
   
    $name = $_GET['add_name'];
    $sql = "INSERT INTO names (Name) VALUES ('$name')";
    mysql_query($sql);
}

?>

<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="GET">
Your Name:
<input name="add_name" type="text"  />
<input type="submit" value="Submit" />
</form>

------------------------------------------------------------------

After submitting the form to itself once I have multiple Name entries with different Ids. The curious thing is that with Chrome browser
I get two duplicate records, with Mozilla - three of them.
Seems like mysql_query runs multiple times.

It works fine when submitting the form to a separate script and not to itself.

Do I miss something? It must be very basic.

Hi,

I have an array filled with values like this:

Code: [Select]
string(1) "Acer 1"
string(2) "Acer 2"
string(3) "Dell 1"
string(4) "Dell 2"
string(5) "Dell 3"
string(6) "Dell 4"
string(7) "Acer 3"
string(8) "Acer 4"
Is there a way to successfully remove all array strings that starts with a given value like "Acer"?

I tried with this snippet, does not work:

Code: [Select]
foreach($array as &$value) {

  if(preg_match("/^Acer/", $value)) {
  unset($value);
} }

Any ideas will be appreciated!

after cloasing connection of database i still got the values form database.

Code: [Select]
<?php
session_start();
/* 
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
require_once '../database/db_connecting.php';
$dbname="sahansevena";//set database name
 $con=  setConnections();//make connections use implemented methode in db_connectiong.php
 mysql_select_db($dbname, $con);
//update the time and date of the admin table
 $update_time="update admin set last_logged_date =CURDATE(), last_log_time=CURTIME() where username='$uname'limit 3,4";
 //my admin table contain 5 colums they are id, username,password, last_logged_date, last_log_time
 $link= mysql_query($update_time);
 // mysql_select_db($dbname, $link);
//$con=mysql_connect('localhost', 'root','ijts');

       $result="select * from admin where username='a'";

        $result=mysql_query($result);
mysql_close($con);
//here i just check after closing data baseconnection whether i do get reselts but i do, why?
echo "after the cnnection was closed";
if(!$result){
echo "cont fetch data";

}else{

   $row= mysql_fetch_array($result);
   echo "id".$row[0]."usrname".$row[1]."passwped".$row[2]."date".$row[3]."time".$row[4];
}
//  echo "<html>";
//echo "<table border='1' cellspacing='1' cellpadding='2' align='center'>";
//      echo "<thead>";
//           echo"<tr>";
//                   echo "<th>";
//                   echo ID;
//                   echo"</th>";
//                   echo" <th>";echo Username; echo"</th>";
//                    echo"<th>";echo Password; echo"</th>";
//                    echo"<th>";echo Last_logged_date; echo "</th>";
//                   echo "<th>";echo Last_logged_time;  echo "</th>";
//               echo" </tr>";
//           echo" </thead>";
//           echo" <tbody>";
//while($row= mysql_fetch_array($result,MYSQL_BOTH)){
//             echo "<tr>";
//              echo "<td>";
//              echo $row[0];
//               echo "</td>";
//                   echo "<td>";
//              echo $row[1];
//              echo "</td>";
//                  echo "<td>";
//              echo $row[2];
//               echo "</td>";
//                   echo "<td>";
//                echo $row[3];
//              echo "</td>";
//                  echo "<td>";
//              echo $row[4];
//               echo "</td>";
//            echo "</tr>";
//     }
//         echo" </tbody>";
//         echo "</table>";
//         echo "</html>";
     session_destroy();
session_commit();

echo "session and database are closed but i still get values from doatabase session is destroyed".$_SESSION['admin'];
?>

session is destroyed but database connection is not closed.

thanks

(1)

I need to remove the lowest and higest values from an array. I need to actually remove the two lowest and two highest.

I suppose the best thing would be to sort the array and then use a function that just drops the first and last values (twice).

Is this the best way? Which function would drop the lowest / highest values?

(2) I then need to get the remaining first and last (highest and lowest) values. $array[0] would get first, and revesing the order and $array[0] again would get the last. Is this the best way?

This is probably very obvious but i gots stuck.
I want to to display a list of the members then you select the member and it deletes the member.
I do not get a message saying it failed, it just doesn't delete the member.

Removemember.php:
Code: [Select]
<form action='removemember_complete.php' method='POST'>

<label>Name:</label>
<select name="memberid">
<?php
$con = mysql_connect("localhost","slay2day_User","slay2day");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("slay2day_database",$con);
$sqlquery="SELECT * FROM `members` Order By name";
$result=mysql_query($sqlquery,$con);
while($row=mysql_fetch_array($result))
{
echo "<option value='".$row['id']."'>".$row['name']."</option>";
}
?>
</select>
<br>

<input type="submit" value="Remove" />
</form>
removemember_complete.php:
Code: [Select]
<?php
$name=$_POST['name'];

$con = mysql_connect("localhost","slay2day_User","slay2day");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("slay2day_database",$con);

$sql="DELETE FROM members WHERE name = '$name'";
if(mysql_query($sql,$con))
{
echo 'Member Removed.<br /><a href="../index.php">Return To Points List</a><br /><a href="removemember.php">Remove More Members</a>';
}
else
{
die('Could not submit: ' . mysql_error());
}
mysql_close($con);

?>
Thanks in advance.

I have finaly got my removing recods page working, but i do have one problem...

i have a delete button which goes to a new php page which contains the DELETE FROM, this deletes the record automaticaly. There are two paths which i could choose from the problem is i am stuck on both of them.

1. a link that will activate the delete code.
2. once the record has been deleted then it will automaticaly go back the the first page.

can any one help me here please?

This topic has been moved to MySQL Help.

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

this is my coding can anyone see what is wrong with it?


$total = mysql_query("SELECT * FROM comments WHERE id=0");
$temp=0;
while ($array=mysgl_fetch_assoc($total))

{
$temp+=$array[clicks];

}
echo "$total Clicks\n";

Code: [Select]
<?php
include("config.php");
$sql=mysql_query("SELECT * FROM uudised ORDER BY id DESC LIMIT 0,5") or die(mysql_error());
$x=0;
while($row=mysql_fetch_array($sql))
{
echo ($x+1).')&nbsp;'.$row['uudis'].'<br />';
$x++;
}
?>Hey how should i get more data from uudised i want get date_added also but how i should do