PHP - Combining Two Tables

This topic has been moved to MySQL Help.

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

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!

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.

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.

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

Hello all,

I have an online script that counts the online registered users, guests and bots.

The script displays the users names that are online, and the bots names that are online.
Since a user can only be logged in at one time on one machine, I have no issues with duplicates here.

My issue is that bots appear depending how many are online, it'll say for example:
Users Online
Matt, Frank, Taylor, Google[bot], Google[bot], Google[bot].

I want to combine the bots, so it'll say:
Matt, Frank, Taylor, Google[bot][3].

I've tried doing this with if statements alone, but it seems maybe I'll  need a php function to do this with, how would I go about doing this?

Thanks in advance, Matt.

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

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);
?>

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 everybody!

This is just basic script, where i try to modify for the needs. I try to play with it. i want to parse some data. The whole script has  three parts:

1. Fetching
2. parsing
3. storing

i want to put all into one script: Two are allready put together - there all seems to be clear...
So  this thread is one that asks for  the combining two parts of a script - how to invoke a variable between them


What has happened untill now:
1st i need to have a connection to database lets say MySQL. I will suggest to use mysqli instead of mysql.
Well - okay i safe this db.php




$host="localhost"; //database hostname
$username="******"; //database username
$password="******"; //database password
$database="******"; //database name
?>

Now i am going to take a new script and  save this config.php
<?php
require_once('db.php'); //call db.php
$connect=mysqli_connect($host,$username,$password); //connect to mysql through mysqli
if(!$connect){
die("Cannot connect to host, please try later."); //throw error if any problem
}
else
{
$select_db=mysqli_select_db($database); //select database
if(!$select_db){
die("Site Database is down at the moment, Please check later. We will be back shortly."); // error if cannot connect to database or db does not exist
}
}
?>


Now i have to take care for the script, that takes the files (note this is very basic - it is only a proof of concept.
In the real situation i will take cURL since cURL is much much nicer and more elegant and faster etc.


<?php
require_once('config.php'); // call config.php for db connection
$content = file_get_contents("<-here the path to the file goes in-> Position XY! an URL is here ");

var_dump($content);

$pattern = '/<td>(.*?)<\/td>/si';
preg_match_all($pattern,$content,$matches);

foreach ($matches[1] as $match) {
    $match = strip_tags($match);
    $match = trim($match);
    var_dump($match);
$sql = mysqli_query("insert into tablename(contents) values ('$match')");
}

?> 


Note: This is just basic script, where you can modify it for your taste and can play with it.

Question:  If i have stored the URLs that i want to parse in a local file - how do i "call" them in the script.
How do i do the call to file where the URLs (there are more than 2500 URLs that have to be parsed) at the
following position: $content = file_get_contents("<-here the path to the file goes in-> Position XY! an URL is here ");


The folder with the URLs is stored in the same folder as the scripts reside!

Many thanks for all hints and for a starting point!

if i have to write more - or if you need more infos - or if i have to be more concrete, just let me know!


i love to hear from you!
db1

hello dear community, good day


i have  a problem -  a parser that does not parse. IT does not work! It gives not back anything!



Code: [Select]
<?PHP // Original PHP code by Chirp Internet: http://www.chirp.com.au
// Please acknowledge use of this code by including this header.

$url = "http://www.edi.admin.ch/esv/00475/00698/index.html?lang=de";

//$input = @file_get_contents($url) or die("Could not access file: $url");

$input = file_get_contents($url) or die("Could not access file: $url");

$regexp = "<a\s[^>]*href=(\"??)([^\" >]*?)\\1[^>]*>(.*)<\/a>";
if(preg_match_all("/$regexp/siU", $input, $matches, PREG_SET_ORDER)) { foreach($matches as $match) {

// $match[2] = all the data i want to collect...
// $match[3] = text that i need to collect - see a detail-page

}
} ?>


well - it goes a bit over my head:  "what - i have did" - it does not give back any results!?


i look forward to hear from you!

regards