PHP - Combining Duplicate Entires.

Hi there,

I'm a beginner at php and mysql. I know a few basics, but i'm stuck. I'm trying to make something for my wifes company that will be as simple as i can make it.
The files i have:
login/register script (register.php / regcheck.php)
member / profile script
and a image upload script. (upload.php: which is now in register.php and process.php)
What i want to do is:
at register i've added a file upload form, but the reg.php points to regcheck.php
and the upload.php points to process.php
I want to combine those 2 files: regcheck.php and process.php to one file. Now i've been breakin my head over this for 2 day's and i cant find a solution and i'm not that experienced.


what i've done so far is the following, but it does'nt fill my database:

databas.sql:
CREATE TABLE `klanten` (
  `id` int(4) unsigned NOT NULL auto_increment,
  `username` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  `level` int(4) default '1',
  `filename` varchar(255) not null,
  `mime_type` varchar(255) not null,
  `file_size` int          not null,
  `file_data` mediumblob     not null,
 
  primary key (image_id),
  index (filename)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


<?php
ob_start();

function assertValidUpload($code)
    {
        if ($code == UPLOAD_ERR_OK) {
            return;
        }
 
        switch ($code) {
            case UPLOAD_ERR_INI_SIZE:
            case UPLOAD_ERR_FORM_SIZE:
                $msg = 'Image is too large';
                break;
 
            case UPLOAD_ERR_PARTIAL:
                $msg = 'Image was only partially uploaded';
                break;
 
            case UPLOAD_ERR_NO_FILE:
                $msg = 'No image was uploaded';
                break;
 
            case UPLOAD_ERR_NO_TMP_DIR:
                $msg = 'Upload folder not found';
                break;
 
            case UPLOAD_ERR_CANT_WRITE:
                $msg = 'Unable to write uploaded file';
                break;
 
            case UPLOAD_ERR_EXTENSION:
                $msg = 'Upload failed due to extension';
                break;
 
            default:
                $msg = 'Unknown error';
        }
 
        throw new Exception($msg);
    }

$errors = array();
 
    try {
        if (!array_key_exists('image', $_FILES)) {
            throw new Exception('Image not found in uploaded data');
        }
 
        $image = $_FILES['image'];
 
        // ensure the file was successfully uploaded
        assertValidUpload($image['error']);
 
        if (!is_uploaded_file($image['tmp_name'])) {
            throw new Exception('File is not an uploaded file');
        }
 
        $info = getImageSize($image['tmp_name']);
 
        if (!$info) {
            throw new Exception('File is not an image');
        }
    }
    catch (Exception $ex) {
        $errors[] = $ex->getMessage();
    }


if(
    isset( $_POST['user'] ) &&
    isset( $_POST['pass'] ) 
)
{
    if( strlen( $_POST['user'] ) < 4 )
    {
        echo "Username Must Be More Than 4 Characters.";
    }
    elseif( strlen( $_POST['pass'] ) < 4 )
    {
        echo "Passwrod Must Be More Than 4 Characters.";
    }
    elseif( $_POST['pass'] == $_POST['user'] )
    {
        echo"Username And Password Can Not Be The Same.";
    }
    else
    {
        
include( 'database.php' );

        $username = mysql_real_escape_string( $_POST['user'] );
        $password = md5( $_POST['pass'] );
$filename = mysql_real_escape_string($image['name']);
        $mime_type = mysql_real_escape_string($info['mime']);
        $file_size = $image['size'];
        $file_data = mysql_real_escape_string(file_get_contents($image['tmp_name'])

        $sqlCheckForDuplicate = "SELECT username FROM klanten WHERE username = '". $username ."'";

        if (count($errors) == 0) {
        // no errors, so insert the image

        if( mysql_num_rows( mysql_query( $sqlCheckForDuplicate ) ) == 0 )
        {
            $sqlRegUser =     "INSERT INTO
                        klanten( username, password, filename, mime_type, file_size, file_data )
                    VALUES(
                        '". $username ."',
                        '". $password ."',
'". $filename ."',
'". $mime_type ."',
'". $file_size ."',
'". $file_data ."',
                        )";

            if( !mysql_query( $sqlRegUser ) )
            {
                echo "You Could Not Register Because Of An Unexpected Error.";
            }
            else
            {
                echo "You Are Registered And Can Now Login";
                $formUsername = $username;
                
               header('Location: view.php?id=' . $id);
       
            }
        }
        else
        {
            echo "The Username You Have Chosen Is Already Being Used By Another User. Please Try Another One.";
            $formUsername = $username;
        }
    }
}
else
{
    echo "You Could Not Be Registered Because Of Missing Data.";
}
ob_end_clean();
?>
<html>
    <head>
        <title>Error</title>
    </head>
    <body>
        <div>
            <p>
                The following errors occurred:
            </p>
 
            <ul>
                <?php foreach ($errors as $error) { ?>
                    <li>
                        <?php echo htmlSpecialChars($error) ?>
                    </li>
                <?php } ?>
            </ul>
 
            <p>
                <a href="upload.php">Try again</a>
            </p>
        </div>
    </body>
</html>

I guess i've mixed up things pretty badly right?

Hi there everyone!

I've got a problem combining two queries. The situation is this. I've got a list of links and I want to allow the user to get a result list of all, only unread, all in a particular category and then only unread in a particular category.

My query for all:
 

/* No filtering and no unread */
$q_urls = "SELECT * FROM shortenified_urls WHERE is_social = '1' AND active = '1' ORDER BY date_added DESC";

My query for in a particular category:
 

/* All links in a particular category */
$q_urls = "
SELECT * FROM shortenified_urls
WHERE shortenified_urls.primary_cat = $vu_cat_view
OR EXISTS (
SELECT link_id FROM linkcats
WHERE link_id = shortenified_urls.id AND cat_id = $vu_cat_view
)
AND shortenified_urls.is_social = '1' AND shortenified_urls.active = '1'
ORDER BY date_added DESC"
;

My query for Unread in all cats:
 

/* Unread only for all categories */
$q_urls = "SELECT * FROM shortenified_urls
WHERE shortenified_urls.date_added > $vu_mark_as_read
AND NOT EXISTS (
SELECT lid FROM linkviews
WHERE lid = shortenified_urls.id AND uid = $viewing_user_id
)
AND shortenified_urls.is_social = '1' AND shortenified_urls.active = '1'
ORDER BY date_added DESC"
;

These seem to be working well. It's the next one that isn't working for me. I tried to combine the "All in a particular category" and "Unread in all categories" using the two above as starting points. The result, however, seems to be that I'm getting all in a particular category. It seems to be ignoring the unread status.
 

/* Unread links in a particular category */
$q_urls = "
SELECT * FROM shortenified_urls
WHERE shortenified_urls.primary_cat = $vu_cat_view AND shortenified_urls.date_added > $vu_mark_as_read
OR EXISTS (
SELECT link_id FROM linkcats
WHERE link_id = shortenified_urls.id AND cat_id = $vu_cat_view
)
AND NOT EXISTS (
SELECT lid FROM linkviews
WHERE lid = shortenified_urls.id AND uid = $viewing_user_id
)
AND shortenified_urls.is_social = '1' AND shortenified_urls.active = '1'
ORDER BY date_added DESC"
;

I'm not smart enough to know why it's not working, but it seems to me like I need to somehow bracket the first two parts containing the category retrieval to make this work right. The only problem is I don't know how to do that.

Any help on how to get this to work would be greatly appreciated!

Hi, 

I'm so close to having this work how I want but one last thing! 

I have a form with a drop down box with the numbers 1 - 60 in.  I have created a view that returns any numbers people have submitted with their login names, e.g. 

1 - Laurie 

4 - Craig 

What I need to happen is it to list all the empty numbers too, so like this: 

1 - Laurie

2 - 

3 - 

4 - Craig 

5 - 

etc

This code removes numbers that have already been selected from the drop down box (so after Laurie and Craig had chosen 1 & 4 the drop down box would now show 2, 3, 5, 6 etc) 

https://pastebin.com/dAps0kqJ

and this code subtotals the rider numbers (I was just trying to get a custom view to work so am pleased this returns something) 

https://pastebin.com/A7MwSQ2S

Using the first code how do I edit the second code so that it displays every number whether a user has chosen it or not? 

Thank you!! 

 

Hey,

I have the following two arrays, of which I want to use bits of each from to get another array.
Array 1:
Array
(
    [0] => Array
        (
            [shop_id] => 1
            [shop_name] => Aldi
            [shop_district] => 6
        )

    [1] => Array
        (
            [shop_id] => 2
            [shop_name] => Greggs
            [shop_district] => 6
        )

    [2] => Array
        (
            [shop_id] => 3
            [shop_name] => Tesco
            [shop_district] => 6
        )

    [3] => Array
        (
            [shop_id] => 4
            [shop_name] => Morrisons
            [shop_district] => 6
        )

    [4] => Array
        (
            [shop_id] => 5
            [shop_name] => Ryman
            [shop_district] => 6
        )

    [5] => Array
        (
            [shop_id] => 6
            [shop_name] => Boots
            [shop_district] => 6
        )

    [6] => Array
        (
            [shop_id] => 7
            [shop_name] => Superdrug
            [shop_district] => 6
        )

    [7] => Array
        (
            [shop_id] => 8
            [shop_name] => City
            [shop_district] => 2
        )

    [8] => Array
        (
            [shop_id] => 9
            [shop_name] => Lizard
            [shop_district] => 6
        )

    [9] => Array
        (
            [shop_id] => 10
            [shop_name] => Asda
            [shop_district] => 8
        )

    [10] => Array
        (
            [shop_id] => 11
            [shop_name] => Tesco
            [shop_district] => 2
        )

    [11] => Array
        (
            [shop_id] => 12
            [shop_name] => Tesco
            [shop_district] => 8
        )

)

Array
(
    [0] => Array
        (
            [shop_id] => 1
            [shop_name] => Aldi
            [shop_district] => 6
        )

    [1] => Array
        (
            [shop_id] => 2
            [shop_name] => Greggs
            [shop_district] => 6
        )

    [2] => Array
        (
            [shop_id] => 3
            [shop_name] => Tesco
            [shop_district] => 6
        )

    [3] => Array
        (
            [shop_id] => 4
            [shop_name] => Morrisons
            [shop_district] => 6
        )

    [4] => Array
        (
            [shop_id] => 5
            [shop_name] => Ryman
            [shop_district] => 6
        )

    [5] => Array
        (
            [shop_id] => 6
            [shop_name] => Boots
            [shop_district] => 6
        )

    [6] => Array
        (
            [shop_id] => 7
            [shop_name] => Superdrug
            [shop_district] => 6
        )

    [7] => Array
        (
            [shop_id] => 8
            [shop_name] => City
            [shop_district] => 2
        )

    [8] => Array
        (
            [shop_id] => 9
            [shop_name] => Lizard
            [shop_district] => 6
        )

    [9] => Array
        (
            [shop_id] => 10
            [shop_name] => Asda
            [shop_district] => 8
        )

    [10] => Array
        (
            [shop_id] => 11
            [shop_name] => Tesco
            [shop_district] => 2
        )

    [11] => Array
        (
            [shop_id] => 12
            [shop_name] => Tesco
            [shop_district] => 8
        )

)

Array 2:
Array
(
    [0] => Array
        (
            [SUM(item_price)] => 31.23
            [item_shop] => 1
        )

    [1] => Array
        (
            [SUM(item_price)] => 1.65
            [item_shop] => 2
        )

    [2] => Array
        (
            [SUM(item_price)] => 41.23
            [item_shop] => 3
        )

    [3] => Array
        (
            [SUM(item_price)] => 7.98
            [item_shop] => 4
        )

    [4] => Array
        (
            [SUM(item_price)] => 4.49
            [item_shop] => 7
        )

)


I'd love if anyone could tell me how I can generate an array that will combine bits of these two arrays, so that using the first array I can get a shop_name and shop_district for each item_shop (aka shop_id).  Then I want to get an array with entries that look something like this:
    [0] => Array
        (
            [SUM(item_price)] => 31.23
            [shop_name] => Aldi
            [shop_district] => 6
        )

Thanks so much for your help, it means a lot to me.

I'm trying to combine 3 tables (attacks, spells, skills) where it brings in all the information from attacks and spells into the table skills.

The common row between all 3 is "name".

Here is what I have so far.

$query = "SELECT * FROM `skills`,`attacks`,`spells` WHERE (`attacks.name`=`skills.name` OR `spells.name`=`skills.name`) AND `user_id`='".$_SESSION['userid']."'";

Thanks!

In a simple text field in a form....

the browser automatically offers a list, when either when you click in or start typing in the field, of previous entries.

My question is: Does anyone know how to control this? Is it possible to give a list of values to the browser, sort of like a ajax search, but all sent before.

For example; in one field the user must enter a name, i want the text box to offer name possibilities even before the user has entered any on the form previously... sort of combining the <text> with a <select> menu... with all the name possibilities coming from a mysql table

I need some help please.  I have a project that has a login script that is required before moving to a shopping cart and each use a session.  I have a login script that i know works separate of the cart and vice versa.  The problem is that when i access the cart i get the session errors and it quits working.  So i need help with getting the 2 combined so i can run the cart script while a user is logged in.  Here is the code i have.

This is the login script session:
<? ob_start(); session_start();include_once"config.php";

if(!isset($_SESSION['username']) || !isset($_SESSION['password'])){

header("Location: login.php");
}else{
$user_data = "".$_SESSION['username']."";
$fetch_users_data = mysql_fetch_object(mysql_query("SELECT * FROM `members` WHERE `username`='".$user_data."'"));
}
?>



This is the script session for the shopping cart:
<?php
require_once 'library/config.php';
require_once 'library/category-functions.php';
require_once 'library/product-functions.php';
require_once 'library/cart-functions.php';

$_SESSION['shop_return_url'] = $_SERVER['REQUEST_URI'];

$catId  = (isset($_GET['c']) && $_GET['c'] != '1') ? $_GET['c'] : 0;
$pdId   = (isset($_GET['p']) && $_GET['p'] != '') ? $_GET['p'] : 0;

require_once 'include/header.php';
?>  

and any help is very much appreciated.

Hi all

I need to combine URL parameters using the following forms:

<form id="type_filter" name="type_filter" method="get" action="">
<label for="type_filter"></label>
<select name="type" id="type_filter" style="width: 160px" onchange="this.form.submit();" >
<option value="" selected class="meter-calc-text">Product Type</option>
<?php
$fetchtypes=mysql_query("SELECT * FROM `product_types` ORDER BY id ASC");
while($returnedtypes=mysql_fetch_array($fetchtypes)) {
echo "<option value=\"".$returnedtypes['id']."\"".(($returnedtypes['id']==$_GET['type']) ? ' selected="selected"':'')." >".$returnedtypes['name']."</option>";
}
?>
</select>
</form>

<form id="colour_filter" name="colour_filter" method="get" action="">
<label for="colour_filter"></label>
<select name="colour" id="colour_filter" style="width: 160px" onchange="this.form.submit();" >
<option value="" selected class="meter-calc-text">Colour / Finish</option>
<?php
$fetchcolours=mysql_query("SELECT * FROM `product_colours` ORDER BY id ASC");
while($returnedcolours=mysql_fetch_array($fetchcolours)) {
echo "<option value=\"".$returnedcolours['id']."\"".(($returnedcolours['id']==$_GET['colour']) ? ' selected="selected"':'')." >".$returnedcolours['name']."</option>";
}
?>
</select>
</form>

At the moment they only send one parameter each. How do I drop down on one and add it to the parameter already on there to give this URL:

../stone.php?type=1&colour=1

Many thanks

Pete

Hello,

Right now I am learning about Header.. and i asked myself, Can i add a transition to it.

 

I have the below header. Accompanied my JS/CSS to create this page redirects

 

header("location: welcome.php");

The transition CSS/JS works by

 

<a href="#" class="btn js-trigger-transition">Begin Transition</a>

 

I Can't seem to find many materials about this combination.

 

Thanks for being there!

Hi everyone

I have 2 queries which are pulling out results into arrays
I think they are right
I then insert a new column into each array one with [typeofdonation] as "cash" and one as "card" this is to be used later when outputting the results

I then need to combine the 2 arrays into 1 array and then sort the combined array by date showing the latest ones first
I then need to output the top 3 results
The way the results are outputted is dependant on what [typeofdonation] is as they are outputting and styled differently

Here is my code below I have got upto the combining the 2 arrays but am having difficulty doing this
Once I have done this I then need to sort the results but I think my code I have tested on each array works ok and so will work once I have the combined array.
Final part I am not sure on how to find and use what is in [typeofdonation] to determine the styling and way each of the 3 results is outputted

Thankyou in advance for everyone who can hopefully help me in the right direction
Peter

Code: [Select]
<b>Card Donations</b><br><br>
<?php 
$getcarddonations =  $wpdb->get_results("SELECT wp_supporters_donations.SFMemberNumber, wp_supporters_donations.KickbackAmount, wp_supporters_donations.MerchantName, wp_supporters_donations.SpendDate from supporter_2_cause RIGHT JOIN wp_supporters_donations ON supporter_2_cause.supp_id=wp_supporters_donations.SFMemberNumber WHERE supporter_2_cause.caus_id = '54' ORDER BY wp_supporters_donations.SpendDate");
//UNION SELECT id, amout, cause, date FROM cashdepo WHERE cause='Lisas charity' AND status='2' ORDER BY id DESC
foreach($getcarddonations as $getcarddonations){
$i = 0;
while($i < 100) {
$data[$i]['member'] = $getcarddonations->SFMemberNumber;
$data[$i]['ammount'] = $getcarddonations->KickbackAmount;
$data[$i]['merchant'] = $getcarddonations->MerchantName;
$data[$i]['date'] = $getcarddonations->SpendDate;
$data[$i]['typeofdonation'] = 'card';
$i++;
}
}

function compareItems($a, $b)
{
if ( $a->date < $b->date ) return -1;
if ( $a->date > $b->date ) return 1;
return 0; // equality
}

uasort($data, "compareItems");
print_r( $data );
?>
<br><br><br><b>Cash Donations</b><br><br>
<?php
$getcashdonationsdb = $wpdb->get_results("SELECT * FROM cashdepo WHERE cause='Lisas charity' AND status='2' ORDER BY id DESC");
foreach($getcashdonationsdb as $getcashdonationsdb){
$i = 0;
while($i < 11) {
$dataa[$i]['member'] = $getcashdonationsdb->id;
$dataa[$i]['ammount'] = $getcashdonationsdb->amout;
$dataa[$i]['merchant'] = $getcashdonationsdb->cause;
$dataa[$i]['date'] = $getcashdonationsdb->date;
$dataa[$i]['typeofdonation'] = 'cash';
$i++;
}
}

uasort($dataa, "compareItems");
print_r( $dataa );

?>
<br><br><br>
<b>Combined</b><br><br>
<?php 
$datar1 = ($data);
$datar2 = ($dataa);
$finalarray = array_combine($datar1, $datar2);

//sort
uasort($finalarray, "date");

//Print the output
print_r($finalarray);
?>

I have 5 tables.

1 is which a user specifies another partner id.

The other 4 are different attributes of the partner id, with times for each.

Now what I want to do is pull the data from ALL 4 different tables and then 'mix' them together and order by their respective times (and only choose the values matching the partner id).

I'm getting mighty confused trying left joins, wheres and anything else I know. It seems too complex to be done :s

Hi All,

Below is my code to add the two different query results into one. This is working fine when both the queries have same no.of rows.

eg: row1 = 1 2 3 (Query1)

       row2 = 3 5 5 (Query2)

         o/p:    4 7 8

Let's say, I have few rows which are not exactly matched with first query.

eg: row1 = 1     2       3       2   (Query1)

      row2 = 3 empty empty  5   (Query2)

o/p :           4      2       3       7   (I want the o/p to be like this)

empty means there is no data from the second query.

In my while, && working fine when the 2 queries have same no.of rows.


while (($row1 = mysql_fetch_assoc($rs1)) && ($row2 = mysql_fetch_assoc($rs2)))
{


$strHtml .= "<tr>";

$strHtml .= "<td align=center colspan=3>".($row1['Calls']+$row2['Calls'])."</td>";
$strHtml .= "<td align=center colspan=3>".($row1['actual_duration(min)A']+$row2['actual_duration(min)A'])."</td>";
$strHtml .= "<td align=center colspan=3>".($row1['call_usage']+$row2['call_usage'])."</td>";
$strHtml .= "<td align=center colspan=3>".($row1['disconnection_charge']+$row2['disconnection_charge'])."</td>";
$strHtml .= "<td align=center colspan=3>".($row1['total_revenue']+$row2['total_revenue'])."</td>";

$strHtml .= "</tr>";

}

Is the while loop i am using correct or there is any other better solution for this?

please help me, Thanks in advance.

I have to make a mail form (which is already coded) that will pull peoples names and email address from a database based on certain form parameters. I have the form done and am so close on finishing it up but am stuck on some mail() issues.

I have the form set up to use:
mail($sendTo, $theSubject, $theMessage, $headers);

Using this format, I know that I can send this email to multiple recipients at once doing the following:
mail('Name1 <email1@na.com>, Name2 <email2@na.com>', $theSubject, $theMessage, $headers);

So I have my mySQL query all set up and it looks like so:
$query="SELECT * FROM operations_forms WHERE department='$initiatedBy'";
$result=mysql_query($query);

while( $row = mysql_fetch_assoc( $result ) ) {

$name = $row["name"]; 
$email = $row["email"];

$recip = $name . " <" . $email .">, ";
$sendTo = $recip;

}

The problem I am having is that my $sendTo variable only is passing on one record, not a combination of all of them. I am at a loss here on how to spit out all the variables and then combine them into one. I can use the above and produce an echo call that looks correct... but it doesn't function correctly on the back end.

Any help? 

Thanks!

hi guys,

i just finished highschool starting to do webdesign at uni, and for one of my major project i want to make a search engine as simple as google that searches for example 10 websites and with the keyword given it brings out the results.

im doing a website on jetski sales results so if someone want to buy a jetski they come to this website and just choose the choose one from those 10 website without going to them individually. so it brings out all search resuts in a nice results format, and when you click on each results it take you to the website but i wanna be able to show their photo and price so just like brings their results into your site but combing 10 website results.

and i need to have an advance search option where they can search year price age of jetski, and all these variables are also in the 10 websites that im getting the results from.

i have been doing some searching and i cant get my head around i need some help LOL i dont wanna fail...

cheers guys