php-general Digest 8 Jun 2012 06:20:41 -0000 Issue 7845
Topics (messages 318179 through 318191):
Re: A Question of SESSION
318179 by: Daniel P. Brown
318180 by: Daniel P. Brown
318185 by: Matijn Woudt
help with query
318181 by: Jack
318186 by: Ashley Sheridan
318187 by: Jim Lucas
318188 by: Jack Sasportas
test
318182 by: Sven Kowalski
318183 by: Camilo Sperberg
318184 by: Jay Blanchard
A problem about sessions
318189 by: Tazio Ceri
318190 by: Stuart Dallas
318191 by: As'ad Djamalilleil
Administrivia:
To subscribe to the digest, e-mail:
php-general-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-general-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-gene...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
On Thu, Jun 7, 2012 at 11:15 AM, Tedd Sperling <t...@sperling.com> wrote:
>
> 3. Looking for an explanation, I came across Daniel's post to the PHP manual,
> which follows:
>
> http://www.webbytedd.com/b/sessions3
>
> Now I am totally bonkers.
>
> What am I not getting?
Anything. Because that page 404's. ;-P
Chances are, what you may be seeing as a post I made is, in fact,
just someone else's user note submission which I edited.
--
</Daniel P. Brown>
Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting
(866-) 725-4321
http://www.parasane.net/
--- End Message ---
--- Begin Message ---
On Thu, Jun 7, 2012 at 11:20 AM, Daniel P. Brown
<daniel.br...@parasane.net> wrote:
> On Thu, Jun 7, 2012 at 11:15 AM, Tedd Sperling <t...@sperling.com> wrote:
>>
>> 3. Looking for an explanation, I came across Daniel's post to the PHP
>> manual, which follows:
>>
>> http://www.webbytedd.com/b/sessions3
I see: http://www.webbytedd.com/b/sessions2/ (not 3).
And yes, I edited the note, I didn't submit it.
>> Now I am totally bonkers.
>>
>> What am I not getting?
>
> Anything. Because that page 404's. ;-P
>
> Chances are, what you may be seeing as a post I made is, in fact,
> just someone else's user note submission which I edited.
>
> --
> </Daniel P. Brown>
> Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting
> (866-) 725-4321
> http://www.parasane.net/
--
</Daniel P. Brown>
Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting
(866-) 725-4321
http://www.parasane.net/
--- End Message ---
--- Begin Message ---
On Thu, Jun 7, 2012 at 5:15 PM, Tedd Sperling <t...@sperling.com> wrote:
> Hi Daniel and gang:
>
> Considering I'm never afraid to show my ignorance, please review the
> following example.
>
> Because of the way I normally use sessions and considering this way works for
> me, I thought I knew what sessions were about -- but my faith is eroding.
>
> Cases in point
>
> 1. The following is the way I normally use sessions (with COOKIES turned ON):
>
> http://www.webbytedd.com/b/sessions
>
> It works.
>
> 2. Considering that people may have their COOKIES turned OFF, I tried this:
>
> http://www.webbytedd.com/b/sessions1/
>
> It works when COOKIES are turned ON, but the SID does not appear in the URL
> -- I find that odd.
>
> However, if COOKIES are turned OFF, then SID does appear in the URL, but the
> process of passing session variables doesn't work -- I find that confusing.
> What's the point of passing the SID if it isn't going to be used?
>
> 3. Looking for an explanation, I came across Daniel's post to the PHP manual,
> which follows:
>
> http://www.webbytedd.com/b/sessions3
>
> Now I am totally bonkers.
>
> What am I not getting?
>
> Cheers,
>
> tedd
Hi Tedd,
I assume you're running PHP 5.3 or later, then
session.use_only_cookies in php.ini is default set to 1, which means
it doesn't accept PHPSESSID. Change that to 0, and it will probably
work.
- Matijn
--- End Message ---
--- Begin Message ---
Hello All,
I have this string defined for my query and it shows the different types of
categories fine, but when I change a.categoryid = c.categoryid to
a.categoryid = 1 which is only one of the categories
It shows me the same record twice.
$query = "select a.startdate, a.articleid, c.name, a.title, a.intro,
a.datecreated from articles as a, categories as c where (a.startdate = -1 or
a.startdate <= {$now}) and (a.enddate = -1 or a.enddate >= {$now}) and
a.categoryid = c.categoryid order by a.startdate DESC";
while ( $row = mysql_fetch_array($res) ) {
$tpldata['articles'][] = array(
'title' => $row['title'],
'intro' => makeLinks($row['intro']),
'id' => $row['articleid'],
'categoryname' => $row['name'],
'created' => date('n/j/Y',
$row['datecreated'])
);
//echo $row['datecreated'];
}
Any Ideas???
Thanks!
--- End Message ---
--- Begin Message ---
Jack <jacklistm...@gmail.com> wrote:
>Hello All,
>
>
>
>I have this string defined for my query and it shows the different
>types of
>categories fine, but when I change a.categoryid = c.categoryid to
>a.categoryid = 1 which is only one of the categories
>
>It shows me the same record twice.
>
>
>
>$query = "select a.startdate, a.articleid, c.name, a.title, a.intro,
>a.datecreated from articles as a, categories as c where (a.startdate =
>-1 or
>a.startdate <= {$now}) and (a.enddate = -1 or a.enddate >= {$now}) and
>a.categoryid = c.categoryid order by a.startdate DESC";
>
>
>
>
>
> while ( $row = mysql_fetch_array($res) ) {
>
> $tpldata['articles'][] = array(
>
> 'title' => $row['title'],
>
> 'intro' => makeLinks($row['intro']),
>
> 'id' => $row['articleid'],
>
> 'categoryname' => $row['name'],
>
> 'created' => date('n/j/Y',
>$row['datecreated'])
>
> );
>
> //echo $row['datecreated'];
>
> }
>
>
>
>Any Ideas???
>
>
>
>
>
>Thanks!
>
>
How many entries in total are in your categories table? You're joining the
table but not putting any kind of constraint on the joined tables, so its doing
a join on all the rows. You can either add an extra clause on the join, leave
the original join and limit with a where clause, or use a group by on that
field.
Thanks,
Ash
http://ashleysheridan.co.uk
--- End Message ---
--- Begin Message ---
On 06/07/2012 09:37 AM, Jack wrote:
$query = "select a.startdate, a.articleid, c.name, a.title, a.intro,
a.datecreated from articles as a, categories as c where (a.startdate = -1 or
a.startdate<= {$now}) and (a.enddate = -1 or a.enddate>= {$now}) and
a.categoryid = c.categoryid order by a.startdate DESC";
$query = "
SELECT a.startdate,
a.articleid,
c.name,
a.title,
a.intro,
a.datecreated
FROM articles as a,
categories as c
WHERE (
a.startdate = -1
OR
a.startdate <= {$now}
)
AND (
a.enddate = -1
OR
a.enddate >= {$now}
)
-- This line must stay, it is limiting the combination of the data from
-- both tables
AND a.categoryid = c.categoryid
-- You need to add this line to make it work, but keep the previous line
AND a.categoryid = 1
ORDER BY a.startdate DESC
";
--
Jim Lucas
http://www.cmsws.com/
http://www.cmsws.com/examples/
http://www.bendsource.com/
--- End Message ---
--- Begin Message ---
Thanks Jim, worked like a charm.
> -----Original Message-----
> From: Jim Lucas [mailto:li...@cmsws.com]
> Sent: Thursday, June 07, 2012 4:08 PM
> To: Jack
> Cc: PHP
> Subject: Re: [PHP] help with query
>
> On 06/07/2012 09:37 AM, Jack wrote:
> > $query = "select a.startdate, a.articleid, c.name, a.title, a.intro,
> > a.datecreated from articles as a, categories as c where (a.startdate =
> > -1 or a.startdate<= {$now}) and (a.enddate = -1 or a.enddate>= {$now})
> > and a.categoryid = c.categoryid order by a.startdate DESC";
>
> $query = "
> SELECT a.startdate,
> a.articleid,
> c.name,
> a.title,
> a.intro,
> a.datecreated
> FROM articles as a,
> categories as c
> WHERE (
> a.startdate = -1
> OR
> a.startdate <= {$now}
> )
> AND (
> a.enddate = -1
> OR
> a.enddate >= {$now}
> )
> -- This line must stay, it is limiting the combination of the data from
> -- both tables
> AND a.categoryid = c.categoryid
> -- You need to add this line to make it work, but keep the previous line
> AND a.categoryid = 1
>
> ORDER BY a.startdate DESC
> ";
>
> --
> Jim Lucas
>
> http://www.cmsws.com/
> http://www.cmsws.com/examples/
> http://www.bendsource.com/
--- End Message ---
--- Begin Message ---
does it work now?
--- End Message ---
--- Begin Message ---
It seems so
Sent from my iPhone 5 Beta [Confidential use only]
On 7 jun. 2012, at 20:07, Sven Kowalski <sven-kowal...@gmx.de> wrote:
> does it work now?
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
On 6/7/12 1:07 PM, Sven Kowalski wrote:
does it work now?
It pretty much always did.
--- End Message ---
--- Begin Message ---
Hi all,
I have a PHP script that takes very long time to execute. I manage it using the
following structure:
ob_start();
// some code
session_start();
// some code
header("Content-length: ".ob_get_length());
ob_end_flush();
// some other, very long, code!
The problem I am facing is that, after having set up a session, often I have
error as
I don't find any simple variable that I wrote in $_SESSION.
Correct my if I am wrong, but I think that $_SESSION get saved to disk only
at the end of the script, after the "very long code" has been executed.
There is a way to save the session manually just after ob_end_flush()?
I can find a different solution, but I think it could be nice to have this
working as is
(if I am correct hunting this problem).
Cheers,
Tazio
--- End Message ---
--- Begin Message ---
On 8 Jun 2012, at 00:39, Tazio Ceri wrote:
> I have a PHP script that takes very long time to execute. I manage it using
> the following structure:
>
> ob_start();
>
> // some code
> session_start();
> // some code
>
> header("Content-length: ".ob_get_length());
> ob_end_flush();
>
> // some other, very long, code!
>
> The problem I am facing is that, after having set up a session, often I have
> error as
> I don't find any simple variable that I wrote in $_SESSION.
> Correct my if I am wrong, but I think that $_SESSION get saved to disk only
> at the end of the script, after the "very long code" has been executed.
> There is a way to save the session manually just after ob_end_flush()?
http://php.net/session_write_close
-Stuart
--
Stuart Dallas
3ft9 Ltd
http://3ft9.com/
--- End Message ---
--- Begin Message ---
i can't undersans much of your question,, but i think you supposed to write
the statement to set the variable's value after the "session_start()"
called, like this ...
session_start();
..... some codes
$_SESSION['some_var']; <--- don't put it before the session_start()
On Thu, Jun 7, 2012 at 5:51 PM, Stuart Dallas <stu...@3ft9.com> wrote:
> On 8 Jun 2012, at 00:39, Tazio Ceri wrote:
>
> > I have a PHP script that takes very long time to execute. I manage it
> using the following structure:
> >
> > ob_start();
> >
> > // some code
> > session_start();
> > // some code
> >
> > header("Content-length: ".ob_get_length());
> > ob_end_flush();
> >
> > // some other, very long, code!
> >
> > The problem I am facing is that, after having set up a session, often I
> have error as
> > I don't find any simple variable that I wrote in $_SESSION.
> > Correct my if I am wrong, but I think that $_SESSION get saved to disk
> only
> > at the end of the script, after the "very long code" has been executed.
> > There is a way to save the session manually just after ob_end_flush()?
>
>
> http://php.net/session_write_close
>
> -Stuart
>
> --
> Stuart Dallas
> 3ft9 Ltd
> http://3ft9.com/
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---