Re: [PHP] Access
> Anyone know of any classes or files for a way to write > an Access readable file from PHP and MySQL? Google produced http://www.phpfreaks.com/tutorials/61/0.php on a search for "Microsoft Access" php. Haven't read it. Looks like what you need. - Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] eliminating dupes from MySQL query results
On Sat, 2003-11-01 at 16:29, Robb Kerr wrote: > It's not exactly a Php problem, but MySQL and Php seem to be so intertwined > and this newsgroup has been so unbelievably helpful that I thought I'd post > the question here. > > I've got a query which returns a group of records. the field which I want > to display in a list contains many duplicates. I need to remove all > duplicates so that each entry is only displayed once. Another query based > upon a selection from this list will display all of the appropriate > records. > > Can anybody help with the syntax? Do I need a loop or is there a MySQL > command/function which I am overlooking? > > Thanx, > -- > Robb Kerr > Digital IGUANA > Helping Digital Artists Achieve their Dreams > http://www.digitaliguana.com > http://www.cancerreallysucks.org You'll want to do a SELECT DISTINCT rather than simply a SELECT for your SQL query. SELECT DISTINCT filters out duplicate results from a query. Hope this helps. - Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Session hijacking
Lots of great information in this thread as far as solutions go, but what I'm wondering is the concept behind how someone actually can hijack a session if register_globals is off. Should all this encryption and added protection be added to scripts with register_globals off and when steps are made to ensure (in a shared environment) that only your script can access the session files/db information? I seem to recall reading somewhere that a malicious user can manipulate cookies in a certain way to pass data directly into session variables, but the location I read this information escapes me. Any links or explanations would be much appreciated for designing security in future scripts. Thanks in advance. - Chris Wanstrath -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Login system
Bas, I think a suggested reading would be www.php.net/man. It's the PHP manual and can answer many, if not all, of your questions related to sessions. Yes, even questions like "what are the basic functions to make a session." I am usually not one of the people that get uptight about certain types of questions this list, but it is unbelievably easy to find the answer to your question. For instance, simply typing something like http://www.php.net/session will bring up a page titled "Session handling functions." You don't even need to know if that's a real website because the PHP site will automatically help you find what you're looking for, to a certain extent, when you enter keywords in after the /. Over the past few days there was an e-mail sent around with helpful PHP links. It probably wouldn't hurt to check there as well, as I'm guessing all the sites cover the very basic concepts and code you are requesting. - Chris Wanstrath On Fri, 2003-10-17 at 13:21, Bas wrote: > Okay, what are the very very basic functions to make a session? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Weird results for 2 lines of damn code
Hey Ryan, Just did a straight copy and paste of your code into a php page on my server. CODE: $ryan=strtotime ("now"); echo $ryan.""; echo strftime("%G-%m-%a %H:%M:%S", $ryan).""; RESULT: 1066353488 2003-10-Thu 21:18:08 Seems to work fine for me...This seems to be a deeper problem than your code itself, probably having something to do with your computer or its libraries. Reading through www.php.net/strftime there were a few warnings about systems not conforming to ISO standards and doing quirky things. On Thu, 2003-10-16 at 21:11, Ryan A wrote: > Hi everyone, > This "very simple" program is driving me nuts, heres what i am doing: > 1.making a timestamp with the current time. > 2.reading from the timestamp and trying to "render" the date again > > $ryan=strtotime ("now"); echo $ryan.""; > echo strftime( "%G-%m-%a %H:%M:%S", $ryan).""; > > This is the result: > -10-Fri 02:29:33 > > the month part,friday part and the time is correctwhy no year? > Where am i going wrong? > > Cheers, > -Ryan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Sessions
You probably have transparent sessions turned on in your config. Turn that off and the session ID will disappear from the url. On Tue, 2003-10-07 at 08:09, Webmaster wrote: > Hi! > > I started to use the php own session functions today. > > Now I am getting such lines in the address bar: > > /pages/news.php?option=1015&PHPSESSID=PHPSESSID=d117dba208d4b205cd4e521f606b > b44e#result > > Why do I get "PHPSESSID=PHPSESSID=" ? > > Thank you. > > Webmaster - Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php