PHP - Combining Session Details Help

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 am trying to combine two tables into one query. This is what I tried but it wont work:

Code: [Select]
<?php
include ('includes/db.php');
include ('includes/functions.php');
include ('includes/global.php');
session_start();


echo '<table width="100%">';
$statsql="SELECT * from `wall`,`feed` WHERE ORDER BY `id` DESC LIMIT 0,10";
$statres=mysql_query($statsql) or die(mysql_error());

while($statrow=mysql_fetch_array($statres)){
$vmessage=clean_up($statrow[message]);
$date=clean_up($statrow[date]);
$time=clean_up($statrow[time]);
$by=clean_up($statrow[by]);
$type=clean_up($statrow[type]);


if($vmessage){
$usersql="SELECT * from `users` WHERE `id`='$by'";
$useres=mysql_query($usersql) or die(mysql_error());

while($row=mysql_fetch_array($useres)){
$avatar=clean_up($row[avatar]);
$first=clean_up($row[first]);

echo "<tr class='content'><td valign='top'>
<img src='pic.php?w=50&amp;h=50&amp;constrain=1&amp;img=photos/$avatar' /><br>$first"; } echo "</td><td valign='top'>
$vmessage</td></tr>";
}else{
echo "$type<br>";
}


}

echo "</table>";
?>

Could someone help me out? Thanks!

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?

This topic has been moved to MySQL Help.

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

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

 

i'm having trouble in combining the 2 preg_replace into 1.
basically i have a string witch strange chars, first i remove all except alphanumeric chars and the remaining string has 1 or 2 spaces and i replace them with dash.
Code: [Select]
strtolower(preg_replace('/\s+/', '-', preg_replace("/[^0-9a-zA-Z]/i", ' ',$a['item'])));

Hello all,

I have a simple form which ends in

      header( "Location: thankyou.php" );

What I have done on the site so far is to use Ajax to load content into a specific Div which uses the following code

     <a href="javascript:ajaxpage('home.php', 'content-index');"></a>

Is there a way to effectively combine the two together to load the thankyou page (upon pressing submit) into the content-index div?

Thank you in advance

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.

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

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 making a simple login system with MySQL and PHP (very simple, I'm just starting with PHP). The MySQL portion is done, but I need to ensure only people who are logged in can see certain content.

To check if people are logged in, my website checks that they have the $_SESSION['user'] variable set. If it is set, then it lets them continue through the website, if not, it tells them to login. Is that enough security, or can people simply inject a session cookie into their browser to spoof that they are logged in?

My idea was to generate a session key cookie when they login (just a random string of letters and numbers) and store that in the database, then on every page, check to make sure their session key is the same thing that's in the database. Is this necessary? It seems expensive.

hi everyone.

i'm wondering what the best way is to create a session variable and pass it to an iframe.
i need to do something along these lines, but it doesn't seem to pass the ID. Any hints on how i should accomplish this?

Code: [Select]
session_start();
  $_SESSION['ID']=$_GET['ID']; // id from previous page
$ID=session_id();

 <iframe src="iframepage.php?ID=<?php echo $ID; ?>" style="width:680px; height:200px;" noresize="noresize" frameborder="0" border="0" scrolling="Yes" allowtransparency="true" /> </iframe>

hi all
I have a table which i have got results from a database. My question If i want to display the details of a particular row. How do I do that?

Thanks Rgds