[PHP-DB] Re: Header, Directory, and SESSIONs

2003-06-23 Thread Cristian MARIN
What don't you use a session var like $HTTP_SESSION_VARS['folder'] = 'folder1' or = 'folder2'. If the user switch the directories after the login you verify if the $HTTP_SESSION_VARS['folder'] is good for any of the two session, if not session_destroy() and go to the login page. You may do that by

[PHP-DB] strange query problem

2003-06-23 Thread Jamie Saunders
Hi, I'm having a problem with a database query, where the script is simply inserting some data into an empty table. The following code creates the query string to be used, the values are all gathered from an html form: $query = INSERT INTO $lcstage (id, .$fieldNames.) VALUES

Re: [PHP-DB] strange query problem

2003-06-23 Thread Becoming Digital
$query = INSERT INTO $lcstage (id, .$fieldNames.) VALUES (.$clientID.,.$values.); The finishing querystring, if printed lookks like this: [snip] Have you actually tested the output of each variable? If $clientID and $values are equivalents of $_POST['clientID'] and $_POST['values'], it's no

[PHP-DB] Page Use

2003-06-23 Thread Tim Winters
Hello, I'm interested in setting up a system whereby I can track a users movements through a site. I particularly I am interested in recording both that the user actually hit the page but also the time he spent on that page. Is this possible using PHP and if so how? Thx Tim Winters

RE: [PHP-DB] Page Use

2003-06-23 Thread Peter Lovatt
use sessions and a database table enter page name and timestamp it for each page request Analyse from the timestamp order and the time difference. Let me know if you want more details HTH Peter -Original Message- From: Tim Winters [mailto:[EMAIL PROTECTED] Sent: 23 June 2003 13:06

RE: [PHP-DB] Page Use

2003-06-23 Thread Mike
I'm sure an application like this has already been written, but here are some considerations if you'd like to build your own: -You need to start a session or have some other functionality that identifies each user uniquely as they browse your pages. -For EVERY page the user visits, you're going

RE: [PHP-DB] Page Use

2003-06-23 Thread Matthew Horn
So yes, it's possible with PHP. Is it worthwhile? Eh, maybe. But just realize the overhead that you'll be putting on a busy site with a DB entry for EVERY page view - even for pages with no dynamic content (not to mention any pages that might require real DB querying). Why not use

Re: [PHP-DB] Page Use

2003-06-23 Thread Pierre-Alain Joye
Hello, something really good: http://www.phpopentracker.de/ hth pierre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Page Use

2003-06-23 Thread Tim Winters
Thanks Mike, You make some good points. From a volume point of view I don't think making the writes to the DB will have much effect as it's a low traffic site. I guess I'm going to have to do some reading on SESSION() Thanks!! Tim Winters Creative Development Manager Sampling Technologies

RE: [PHP-DB] Page Use

2003-06-23 Thread Tim Winters
Interesting Pierre, Is this something you have ever used? Thanks for the reply Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902

Re: [PHP-DB] Page Use

2003-06-23 Thread Pierre-Alain Joye
On Mon, 23 Jun 2003 10:33:59 -0300 Tim Winters [EMAIL PROTECTED] wrote: Interesting Pierre, Is this something you have ever used? I have tested it for a few weeks ago (and starting to translate the doc to fr ;). I use it in a current project. However be sure this is really something good and

RE: [PHP-DB] Page Use

2003-06-23 Thread Edward Peloke
If it is a low traffic site, then the db writes should not be bad at all. You can simply have the user log in then set their username or something in a session variable, then you can use that to keep track of them in the db. Eddie -Original Message- From: Tim Winters [mailto:[EMAIL

RE: [PHP-DB] Session error?

2003-06-23 Thread Edward Peloke
you need to look in your php.ini file to see where it is dumping the session data, then make sure that directory exits... -Original Message- From: Tim Winters [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 10:21 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Session error? Ok, Tried

RE: [PHP-DB] Session error?

2003-06-23 Thread Edward Peloke
some of the other errors occurred ( such as the headers already sent) because you probably have white space before your php code. Eddie -Original Message- From: Tim Winters [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 10:21 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Session

Re: [PHP-DB] Session error?

2003-06-23 Thread CPT John W. Holmes
Warning: session_start() [ http://www.php.net/function.session-start function.session-start]: open(/tmp\sess_bf0c0a0a020087aa573e357a2553f828, O_RDWR) failed: No such file or directory (2) in C:\Program Files\Apache Group\Apache2\htdocs\MailOrderDynamic\c.php on line 6 The default

[PHP-DB] Having trouble with this SQL query

2003-06-23 Thread Christopher McCourt
Hi to all: First of all, I'm a newbie to PHP and MYSQL and started working on a create table query in PHP to execute on MYSQL. Can someone take a quick look at the following code to see if there are any problems? Can you also advise some tips on debugging? Thank you in advance for your

Re: [PHP-DB] Having trouble with this SQL query

2003-06-23 Thread CPT John W. Holmes
First of all, I'm a newbie to PHP and MYSQL and started working on a create table query in PHP to execute on MYSQL. Can someone take a quick look at the following code to see if there are any problems? Can you also advise some tips on debugging? Print out your SQL queries when debugging.

RE: [PHP-DB] Session error?

2003-06-23 Thread Tim Winters
Thanks John, So is that address relative to the physical machine or is it relative to the directory where the php files are contained. Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8

RE: [PHP-DB] Session error?

2003-06-23 Thread Mike Brum
Just put the full path of the dir. For instance I placed mine at C:\php\session to keep things separated. -M -Original Message- From: Tim Winters [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 12:31 PM To: 'CPT John W. Holmes'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Session

RE: [PHP-DB] Having trouble with this SQL query

2003-06-23 Thread Christopher McCourt
Thank you John. -Original Message- From: CPT John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 12:10 PM To: Christopher McCourt; PHP Lists Subject: Re: [PHP-DB] Having trouble with this SQL query First of all, I'm a newbie to PHP and MYSQL and started working on a

RE: [PHP-DB] Session error?

2003-06-23 Thread Tim Winters
Thanks Mike!! Ok, been doing dome more reading on sessions. Is there any sort of consensus on whether to use cookies or not for sessions? Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8

RE: [PHP-DB] Having trouble with this SQL query

2003-06-23 Thread Edward Peloke
I think you are getting an error because you are using User as the table name which I believe is a reserved keyword. If you change the name to users it would probably work fine. -Original Message- From: Christopher McCourt [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 1:28 PM To:

[PHP-DB] Image upload get file dimensions

2003-06-23 Thread Chris Payne
Hi there everyone, In short, I use the following to upload an image to the server: $max_size = 40; if (is_uploaded_file($userfile)) { all works great, but what I want to do is store the file details in my MySQL DB, how can I easily find out the image width and height etc from the

Re: [PHP-DB] Image upload get file dimensions

2003-06-23 Thread bbonkosk
http://us4.php.net/manual/en/function.getimagesize.php Hi there everyone, In short, I use the following to upload an image to the server: $max_size = 40; if (is_uploaded_file($userfile)) { all works great, but what I want to do is store the file details in my MySQL DB, how can I

Re: [PHP-DB] Image upload get file dimensions

2003-06-23 Thread Chris Payne
Hi there, Thanks just found this page as your email arrived :-) Appreciate the pointer though. Chris http://us4.php.net/manual/en/function.getimagesize.php Hi there everyone, In short, I use the following to upload an image to the server: $max_size = 40; if