PHP - Is There A Way To Ensure Unique Entries Added To Db

Hello.

How can I have a single form which has a number of standard fields in it, say date and name.... but for that same date and name I want to add multiple additional entries for say phone calls recieved... (silly example I know)

How can I enter the standard data once and an undefined amount of phone calls received ? without having to put a maximum number of possible entry fields on the page.... ?

So, say my Form is :


<form action="myform.php" method="post">
<p>Date: <input type="text" date="date" /><br />
Name: <input type="text" name="name" /></br>


Call From: <input type="text" call_from="call_from" /></br>

<p><input type="submit" value="Send it!"></p>
</form>


If I have 50 calls for  that person I only want to enter their name and the date once and then add as many calls as needed...


How can I do it?

Thanks

Hello,

For starters I'm not sure if what I want to do is possible, but if it is I would like your input. I have a script that will show a number of fields to fill out in a second form based on the number the user puts into the first from. the problem is that only the last one saves into the database and not all of them.

Code: [Select]
<form auction="index.php" method="post">
System Name: <input type="text" name="systemname">
Number of E-sites: <input type="text" name="events">
Number of Sigs: <input type="text" name="sigs"><br>
<input type="reset" name="reset" value="Reset">
<input type="submit" name="start" value="Start">
</form>
<form auction="index.php" method="post">
<?php
$events = $_POST['events'];
$system = $POST['systemname'];

if (isset($_POST['start'])) {
$num = $_POST['sigs'];
$i = 0;
While ($i < $num)
{
echo "Sig ID: <input type=text name=sigid>";
echo "Type: <input type=text name=type>";
echo "Name: <input type=text name=name>";
echo "Notes: <input type=text name=notes>";
echo "<br>";
$i++;
}
}
?>
<input type="submit" name="enter" value="Enter">
</form>
<?php
$sigid = $_POST['sigid'];
$type = $_POST['type'];
$name = $_POST['name'];
$notes = $_POST['notes'];
mysql_connect('xt', 'x', 'x');
mysql_select_db('wormhole');
if (isset($_POST['enter'])) {

$query = "INSERT INTO sites VALUES ('$system','$events','$sigid','$type','$name','$notes')";
mysql_query($query);

}
?>
How do I get it so all the data saves, lets say that $num = 5, I want all 5 to save not just the last one.

Code: [Select]
$query = mysql_query("SELECT a.*, b.*
         FROM friendlist a
INNER JOIN friendlist b
ON (a.friendemail=b.friendemail)
INNER JOIN users c
ON (b.friendemail = c.EmailAddress)
WHERE a.email = 'asdf@gmail.com'
AND c.Username LIKE '%carol%'
GROUP BY a.id
ORDER BY count(*) DESC");
Code: [Select]
while ($showfriends = mysql_fetch_array($query)) {
     echo $showfriends['Username'];
}
and I would get nothing. It produces the correct number of <div> so i know it's getting through, but it's having trouble displaying the entries?

Hello...
I have a .txt database with ~100 records.  I only want to show the 15 records that are at the top (referring to reading order of the file).
Here is my php code to display the records.
http://www.flcbranson.org/mobile.php?content=mobile-freedownloads.php if you want to see the results of the code, below.
Code: [Select]
<?php
$index_file = 'services/series/Index-Date.txt';
$fd = fopen($index_file, 'r');
if ($fd) {
        while (!feof ($fd)) {
                $seriestitle = trim(fgets($fd, 1024)); // Series Title
                if(feof ($fd))
                break;
                $seriessubtitle = trim(fgets($fd, 1024)); // Series subtitle
                $seriesinfo  = trim(fgets($fd, 1024)); // Series Info (Church name)
                $serieslocation = trim(fgets($fd, 1024)); // City, State
                $seriesindex = trim(fgets($fd, 1024)); // Series index file
                $seriesstatus = trim(fgets($fd, 1024)); //Online Only?
                $divider     = trim(fgets($fd, 1024)); // Divider
                $seriestitle2 = $seriestitle;
                $seriestitle3 = str_replace("'", "%27", $seriestitle); // Kind of makes the alt= below work "God's Will" ends up being "God%27s Will" but without is "God"
                if(strstr($seriestitle,"<")) {
                        $seriestitle2 = strip_tags($seriestitle);
                }
                $seriestitle2 = urlencode($seriestitle2);
                if(file_exists("images/ProductCovers/".substr($seriesindex,0,-4).".jpg")) {
                        echo "<img src='images/ProductCovers/".substr($seriesindex,0,-4).".jpg' width='115' height='150' border='0' alt='".substr($seriestitle3,7)."'><br />";
                }
        }
        fclose ($fd);
}
?>
I'm assuming that "for" would do the trick, but when I tried I got 10 copies of every record.
Hehehe...
I'm guessing that it's a quick fix.
Thanks...
JJ

Hi guys 

Im trying to delete multiple images from  a page with the code below, I have retirieved the images successfully but i can not delete the with checkbox,

wht it does is just refereshing the page and thats it, what im trying to do is to delete the image from the database but it wont.

can u help me please?

<?php
session_start();

include ("../../global.php");
//welcome messaage
$username=$_SESSION['username'];
echo "$username";

$query=mysql_query("SELECT id FROM users WHERE username='$username'");
while($row = mysql_fetch_assoc($query))
{
$user_id = $row['id'];
}

$ref=$_GET['reference'];


$images=mysql_query("SELECT * FROM img WHERE refimage='$ref'");

while($row = mysql_fetch_array($images))
{
$image=$row['image'];
$thumb=$row['thumb'];





?>

<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="" method="post" action=''>
<tr>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
<td bgcolor="#FFFFFF"><? echo "<a href='$image' rel='lightbox[roadtrip]'><img src= '$thumb' width='60' height='40' alt='$title'>";?></td>
<?
}
?>


<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>


<?php

// Check if delete button active, start this
$delete = $_REQUEST['delete'];
if( $delete != '' ){
$checkbox = $_REQUEST['checkbox'];
$count = count($_REQUEST['checkbox']);
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$del = mysql_query("DELETE FROM img WHERE id = '$del_id'");

}
}

?>

I have an issue with some code I have.  All the code works correctly apart from when submit is clicked not only does it update a the current club but it creates a blank entry in the database!  I cant see whats wrong.  Here is the code.........



//gets
$validation = $_GET['new_club'];
//Querys
    $qGetClub = "SELECT * FROM clubs WHERE validationID = '$validation'"; 
$rGetClub = mysql_query($qGetClub);
$Club = mysql_fetch_array($rGetClub);
//Query for category by name
$qGetCat = "SELECT * FROM club_category WHERE catID = ".$Club['cat']."";
$rGetCat = mysql_query($qGetCat);
$CatName = mysql_fetch_array($rGetCat);
//query for related sub categorys.
$qGetSub = "SELECT * FROM sub_categorys WHERE catID =".$Club['cat']."";
$rSubCat = mysql_query($qGetSub);
// query for groups created
$Groupq = mysql_query("SELECT * FROM groups WHERE memberID = '".$User['memberID']."'");

//end of querys

if(isset($_POST['insert_clubbtn1'])){ 
//Process data for validation     
$subcat     = trim($_POST['subcat']);  
$NewSubCat = trim($_POST['NewSubCat']); 
//Prepare data for db insertion      
$subcat = mysql_real_escape_string($subcat); 
//find the new category 
//insert
$result = mysql_query("UPDATE clubs  SET 
`sub_category` = '$subcat'
WHERE validationID ='$validation'") or die(mysql_error());



if ($result!=="") {
$otherg = trim($_POST['other_groups']);
$newg = trim($_POST['new_group']);
$newg = mysql_real_escape_string($newg);     
//if an item other than none from the list is selected then update the club with an ID relating to the group it belongs to
if ($otherg !=='None') { $groupsq = mysql_query("UPDATE `clubs` SET groupID ='$otherg' WHERE validationID ='$validation'") or die (mysql_error()); }
// If none is selected then $newg must have a value so create a new group in the groups table and then on the next page I will add the group in the club table 
else {
$groupsq = mysql_query("INSERT INTO `groups` (`memberID`, `group`, `clubID`) VALUES ('".$User['memberID']."', '$newg', '".$Club['clubID']."')")or die (mysql_error());
}   }

if ($NewSubCat !="") { mail("mail","New Sub Category Request","Dear Ring Master,
\n\nThe club in the name of $name with a validation code of $validationID would like a new sub category called $new_cat\n\n  
\nTeam Arena\n\n\n\n"); }

$url = "/members/create/create_clubp3.php?new_club=$validation";  
header("Location: $url");     
}

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++;

        }
         
?>

Is there any other way of getting PHP form data into C# any other way besides calling  

www.downloadHandler.text

I am having issues  bringing all the entries into C# and breaking them all up.  I can do one row fine but multiple rows isn't working.  I keep getting an out range error.

This is my PHP echo

echo $row['userName']. '|' .$row['level']. '|' .$row['points']. '|' .$row['killRate']. '/';

And this is my C# code

                string nothing = "Not Placed";
                string Data_string = www.downloadHandler.text;
                string[] DataArray;
                DataArray = Data_string.Split('/');

                int numberOfEntries = DataArray.Length;
                Debug.Log(numberOfEntries);

                if (DataArray[0] == null || numberOfEntries == 1)
                {
                    DataArray[0] = nothing;
                    Debug.Log("Data Array [0] isn't there");
                    High_Points_1.text = DataArray[0];

                }
                else
                {
                    High_Points_1.text = DataArray[0];
                    //Debug.Log(DataArray.Length);
                }
                if (DataArray[1] == null || numberOfEntries == 2)
                {
                    DataArray[1] = nothing;
                    Debug.Log("Data Array [1] isn't there");
                    High_Points_2.text = DataArray[1];
                }
                else
                {
                    High_Points_2.text = DataArray[1];
                    //Debug.Log(DataArray.Length);
                }
                if (DataArray[2] == null || numberOfEntries == 3)
                {
                    DataArray[2] = nothing;
                    Debug.Log("Data Array [2] isn't there");
                    High_Points_3.text = DataArray[2];
                }
                else
                {
                    High_Points_3.text = DataArray[2];
                }
                if (DataArray[3] == null || numberOfEntries == 4)
                {
                    DataArray[3] = nothing;
                    Debug.Log("Data Array [3] isn't there");
                    High_Points_4.text = DataArray[3];
                }
                else
                {
                    High_Points_4.text = DataArray[3];
                }
                if (DataArray[4] == null || numberOfEntries == 5)
                {
                    DataArray[4] = nothing;
                    Debug.Log("Data Array [4] isn't there");
                    High_Points_5.text = DataArray[4];
                }
                else
                {
                    High_Points_5.text = DataArray[4];
                }

I have two entries in the database.  But when I debugged the number int he array I get 3 strings.

I want to show the top five entries in the database.

Hello,
   Hopefully I can ger som help here I have been googling this for months and seem to cant find anything that will help me out.
I am trying to create a form (which is the easy part) but I want this form to send multiple entries at once from what I gather so far I need to use for each and/or loop which i am not familiar with it with my lack of knowledge........
what I have so far is
Table= locations
fields are
id
state
county
city

the form is set up as follows
state
county
city
city
city
city
city
city
city
city
city
city
city
city
The reason for so many cities is so i can update all cities in one county at the same time saving time I am not sure if its % doable in the manner i would like it to be done but i hope so

ok i enter the state and county
then i enter the cities i want
i submit the form i want it to create the state/county and the first city with the next id # then enter the state/county and next city and id#.


please some help me  if u need to see my file let me know and ill post it im just not sure which one you need i believe it will be the save.php file but i also have the create.php file which is the form itself
Thanks anyone for the help i can get

So, I've been trying to get this query working and can't quite get it to work.  I'm trying to get an "array" of distinct browsers from the database, but it's only showing one of them.  There are 3 unique browsers in the table and only "Chrome 30" gets returned.  Here is the query:

SELECT DISTINCT `browser` AS `unique_browsers`,
     COUNT(DISTINCT `ip`) AS `unique_visitors`,
     COUNT(DISTINCT `country`) AS `unique_countries`,
     COUNT(`id`) AS `total_count`,
     (SELECT COUNT(`id`) FROM `table` WHERE `browser` LIKE '%Chrome%') AS `chrome_count`,
     (SELECT COUNT(`id`) FROM `table` WHERE `browser` LIKE '%Internet Explorer%') AS `ie_count`,
     (SELECT COUNT(`id`) FROM `table` WHERE `browser` LIKE '%Firefox%') AS `firefox_count`,
     (SELECT COUNT(`id`) FROM `table` WHERE `browser` LIKE '%Safari%') AS `safari_count`,
     (SELECT COUNT(`id`) FROM `table` WHERE `browser` LIKE '%Opera%') AS `opera_count`,
     (SELECT COUNT(`id`) FROM `table` WHERE `browser` NOT LIKE '%Chrome%' AND `browser` NOT LIKE '%Internet Explorer%' AND `browser` NOT LIKE '%Firefox%' AND `browser` NOT LIKE '%Safari%' AND `browser` NOT LIKE '%Opera%') AS `unknown_count`
FROM `table`
GROUP BY `browser` 

Everything works properly except the line:

For some reason this only allows one SQL to be added...

// SQL Connection
$username="monstert_admin"; $password="admin"; $database="monstert_admin";
$connection = mysql_connect("localhost", $username, $password) 
or die("Connection Failure to Database");
// Select Database
mysql_select_db($database, $connection) or die ($database . "No Database" . $username);

//Select everything from the the table
$MyQuery = "SELECT * FROM photos";
$retrieve = mysql_query($MyQuery) or die(mysql_error());
if(mysql_num_rows($retrieve) != 0):
$row = mysql_fetch_assoc($retrieve);
else:
echo '';
endif;

if(isset($_POST['Submit']) && !$errors)
{
$url = $newname;

   include('img.php');
   $image = new SimpleImage();
   $image->load($url);
   $image->resize(500,315);
   $image->save($newname);

mysql_query("INSERT INTO photos (url) VALUES ('$url')");

echo "File Uploaded Successfully as <i> ";
echo $newname;
echo "</i>";
}

What would the issue be? I only have two columns - ID and url

Thanks in advance!

Hi,
Im building a management web application that can contain sensitive information for people, allow for cheques to be printed, amoung other things. Im wondering what are some extra security features that could be added as some users may not want to have the web application available outside their business. I would preffer doing this without having to run the server locatlly on thier machine. i was thinking something like only allowing certain ip address's to access the sites login.

Anyone have any other/better ideas?

I've run into a little bit of a logistical nightmare on some registration pages I've taken over work on.  On these pages, parents register their kids for classes. The pages have been coded as such:
page one: the user enters name and personal info, and selects one or two classes to register for, on submit, they go to page two.
page two: their info is entered into the mysql database's registration table on a unique id  The user verifies the total, enters a discount and submits
page three: credit card info is added to registration table, and sent to authorize.net.
page four: payment processed, and they enter the data for their kids into the attendees table
page five: confirmation and done.

My issue is that, at first I saw people entering page one data, going to page two, then for some reason, hitting the back button. They could then enter the data again. I'd have two entries in the registration table for the same person. I was going to put some sort of unique key on the name and an email, but then I saw scenario two...

Another person enters data and registers one kid.. then for whatever personal reason goes back and registers a second kid in a completely separate transaction.

So I can't put that key on there, but is there a way to prevent them from going back and reentering twice. I don't want to have to blow up the code to do it at the end of everything. and that would take implementing sessions, wouldn't it? I'm not so versed at that. Any thoughts?

Hey,
I'm writing an application that tracks attendance. There are multiple events ('events' table), in which members that are present will be found. (When an event file is uploaded, it has all members that attended the event, and adds the event entry in 'events', as well as adding each member to the 'attendance' table, with event_id(eid) and the 'did_attend' value as '1'. When the event is edited, it needs to find the other members that AREN'T in the events table, and add them to the 'attendance' table. When I use this code, it apparently keeps adding the same members. Will a LIMIT 1 stop this? I has about 65,000+ entries added before I stopped the execution of the script.

Thanks!


Code: [Select]
$sql2 = mysql_query("SELECT * FROM members WHERE status=1 ORDER BY mid ASC");
while($row = mysql_fetch_assoc($sql2)){
$sql3 = mysql_query("SELECT * FROM attendance WHERE event='$eid' ORDER BY member ASC");
while($row2 = mysql_fetch_assoc($sql3)){
if($row2[mid] == $row[mid]){
// if the member is in the attendance db, skip
}else{
//if member is not in attendance, write zero--- causing multiple entries (50,000+)

$qry = mysql_query("INSERT INTO attendance (member,event,did_attend) VALUES ('$row[mid]','$eid','0')");
if(!$qry){
die("SQL: ".mysql_error());
}else{
$msg = "<br />Member ".$row[mid]." marked as absent.";
}
}
}
}

I'm trying to compare 2 files, each with data separated by ::. I'm trying to make a comparison that if the data to the left of the separator from one file is not found in the same column of the other file, then it is copied to an array.
For example:
file1.txt
abc::def
ggg::hhh
mmm::ppp

file2.txt
abc::def
zzz::aaa
bbb::ccc

So...
ggg::hhh
mmm::ppp
is copied from file1.txt because ggg and mmm was not found on the same side in file2.txt

...but I'm not getting any error message with this. The operation just hangs.
Code: [Select]
<?php
$dic1 = file('file1.txt', FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES); 
$dic2 = file('file2.txt', FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES); 
$titleText = array(); // Storing results into this array.
    
foreach ($dic1 as $dic1line){
    list($dic1field1, $dic1field2) = explode('::', $dic1line);
        foreach ($dic2 as $dic2line){
            list($dic2field1, $dic2field2) = explode('::', $dic2line);
            if ($dic1field1 != $dic2field1) { // Found a non match in DB.
                array_push($titleText, "$dic1field1 :: $dic1field2\n"); // Store all finds in array.  
            }
        }
}

// Finish outputting anything left over.
if (empty($titleText)) { // $value was not found -- array is empty.
    echo 'All matched, or something else.';
} else {
    $arrayOut = implode("", $titleText); // output the results found in the search.
    echo $arrayOut;
}

unset($value);
?>

Anyone know how to do this?
Thanks.