[PHP] php and Perl
Hi all, can php call perl scripts? I know nothing of perl, but have found a perl script that will process a MSword document in a way that it seems php cannot. At this stage, my knowledge of perl is limited to it's used in web stuff sometimes isnt it :) but i am sure i will soon find a bit more about perl itself elsewhere from this list. Can i indeed use php to 'call' a perl script/function/app whatever its called? Cheers, Brad Nel vino la verità, nella birra la forza, nell'acqua i bacilli -- In wine there is truth, in beer there is strength, in water there are bacteria -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Using PHP to get a word count of a MSword doc
Thanks for the reply Rene,
Any change of a code sample of how u did this?? Im not at all experienced in
Java.
Thanks again for replying
Cheers,
Brad
Nel vino la verità, nella birra la forza, nell'acqua i bacilli
--
In wine there is truth, in beer there is strength, in water there are
bacteria
From: -{ Rene Brehmer }- [EMAIL PROTECTED]
Organization: www.metalbunny.net
Date: Mon, 17 Mar 2003 21:36:48 +0100
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Using PHP to get a word count of a MSword doc
On Mon, 17 Mar 2003 15:43:07 +1000, Brad Wright wrote about [PHP] Using
PHP to get a word count of a MSword doc what the universal translator
turned into this:
I have a mySQL DB that stores word documents (as a BLOB). I am trying to
find a way of doing a word count on the documents using PHP. Can anyone
help??
In Java I just convert the text to tokens, and then get the token count,
extremely simple, but not sure PHP's tokenizer can do this...
Rene
--
Rene Brehmer
This message was written on 100% recycled spam.
Come see! My brand new site is now online!
http://www.metalbunny.net
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Using PHP to get a word count of a MSword doc
Erik, thanks, are you able to pint me to some good reference sources on tokenizer's... i have never come across them before I have been scouring the web, and am coming up a decided blank. :) Cheers, Brad Nel vino la verità, nella birra la forza, nell'acqua i bacilli -- In wine there is truth, in beer there is strength, in water there are bacteria From: Erik Price [EMAIL PROTECTED] Date: Tue, 18 Mar 2003 16:45:47 -0500 To: Brad Wright [EMAIL PROTECTED] Cc: PHP General List [EMAIL PROTECTED] Subject: Re: [PHP] Using PHP to get a word count of a MSword doc Brad Wright wrote: Thanks for the reply Rene, Any change of a code sample of how u did this?? Im not at all experienced in Java. According to the manual, PHP does have some tokenizer functions: http://www.php.net/manual/en/ref.tokenizer.php However, the documentation appears to be lacking as they are still under development. Using it might be somewhat straightforward if you are accustomed to using a tokenizer in another language (like Java) but if not, it's really a little too difficult to explain in an email. A less elegant but ultimately quicker and probably more reliable solution might be to investigate some kind of external word-counting program that knows how to parse .DOC files (good luck on that part), and call this from your PHP script using system(). Catch-22: the only libraries I am familiar with that can parse .DOC files are the Jakarta POI libraries, which are written in Java. But I am sure that if you scour the web you can find some Perl, Python, or maybe even PHP-based solution. Erik -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Using PHP to get a word count of a MSword doc
Thanks Erik, looking now :) Cheers, Brad Nel vino la verità, nella birra la forza, nell'acqua i bacilli -- In wine there is truth, in beer there is strength, in water there are bacteria From: Erik Price [EMAIL PROTECTED] Date: Tue, 18 Mar 2003 16:57:57 -0500 To: Brad Wright [EMAIL PROTECTED] Cc: PHP General List [EMAIL PROTECTED] Subject: Re: [PHP] Using PHP to get a word count of a MSword doc Brad Wright wrote: Erik, thanks, are you able to pint me to some good reference sources on tokenizer's... i have never come across them before I have been scouring the web, and am coming up a decided blank. :) The only tokenizers I have used are the StringTokenizer and StreamTokenizer classes in Java. If you want to learn about these, go to this web page: http://www.mindview.net/Books/TIJ/ and download the book Thinking in Java. Chapter 9 is the chapter that covers File I/O and discusses how to use them. I have a feeling that the PHP tokenizers work very similarly to the Java one (just judging from the docs on the PHP site). Good luck, Erik -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Using PHP to get a word count of a MSword doc
Hi all, I have a mySQL DB that stores word documents (as a BLOB). I am trying to find a way of doing a word count on the documents using PHP. Can anyone help?? Thanks in advance, Brad -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] php/mySQL time comparison
Hi all, I have been tearing my hair out for weeks with this problem, hope someone can help. I want to pull all data out of a mysql table that falls between two dates (a start-time and end-time). I use PHP to allow the user to specify the time interval, creating 2 variables 'startTime' and 'endTime'. These are formatted thus: 2002-02-25 00:00:00 (-MM-DD HH:mm:ss). I then use the syntax: $query = select * from Job_TB where teamNo = $teamNo AND startTime = $timeFrom AND endTime = $timeTo; $result = mysql_query($query,$db) or die (somethings wrong); to query the mysql DB. But it doesnt work. Is there a glaring error in my syntax? Can anyone help with this as its driving me nuts Hope someone can help, thanks in advance, brad Cheers, Brad Nel vino la verità, nella birra la forza, nell'acqua i bacilli -- In wine there is truth, in beer there is strength, in water there are bacteria -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] php/mySQL time comparison
Thanks people, thank you very very much. the missing quotes were the problem. Can't beleive I kept missing that, everytime I re-read the code. Sorted now, and I've still got some hair!! You people are legends!!! Cheers, Brad Nel vino la verità, nella birra la forza, nell'acqua i bacilli -- In wine there is truth, in beer there is strength, in water there are bacteria From: Brad Wright [EMAIL PROTECTED] Date: Sat, 15 Mar 2003 00:33:15 +1000 To: [EMAIL PROTECTED] Subject: [PHP] php/mySQL time comparison Hi all, I have been tearing my hair out for weeks with this problem, hope someone can help. I want to pull all data out of a mysql table that falls between two dates (a start-time and end-time). I use PHP to allow the user to specify the time interval, creating 2 variables 'startTime' and 'endTime'. These are formatted thus: 2002-02-25 00:00:00 (-MM-DD HH:mm:ss). I then use the syntax: $query = select * from Job_TB where teamNo = $teamNo AND startTime = $timeFrom AND endTime = $timeTo; $result = mysql_query($query,$db) or die (somethings wrong); to query the mysql DB. But it doesnt work. Is there a glaring error in my syntax? Can anyone help with this as its driving me nuts Hope someone can help, thanks in advance, brad Cheers, Brad Nel vino la verità, nella birra la forza, nell'acqua i bacilli -- In wine there is truth, in beer there is strength, in water there are bacteria -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] session_unregister question
Is it possible to somehow do a session unregister of all session variables except for (say) 2 variables. varA and varB So if my session had : varA, varB,varC, varD,varE (etc) I want to unregister all but varA and varB. Is there an 'elegant' way to do this without testing for all the variables in the session? Cheers, Brad Nel vino la verità, nella birra la forza, nell'acqua i bacilli -- In wine there is truth, in beer there is strenght, in water there are bacteria -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] embedded media from DB
Hi all..
well i got the wav files from the mysql database and can get them to play in
a web page using the following code:
IF ($row = mysql_fetch_array($result)) {
$data = $row[wavFile];
$name = $row[wav FileName];
$size = $row[wav FileSize];
$type = $row[wav FileType];
header(Content-type: $type);
header(Content-length: $size);
/header(Content-Disposition: attachment; filename=$name);
header(Content-Description: PHP Generated Data);
echo $data;
*
BUt the problem I am having is that this code gives me a blank age with a
Quicktime control bar in the middle of it. The wav file plays fine. Any
other htm underneath this php script is ignored.
How can i get the (html) code following this to be output to the webpage
All my tags seem correct (ie the ?PHP and ? tags etc are done correctly).
Any help is greatly appreciated
Cheers,
Brad
Nel vino la verità, nella birra la forza, nell'acqua i bacilli
--
In wine there is truth, in beer there is strenght, in water there are
bacteria
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] embeding media from DB
Hi all, I have been able to upload a wav file to a mxSQl db using PHP script. Wanted to be able to get that wav file from the db and embed it into a web page using the default media player to play it. Can anyone help??? Cheers, Brad Nel vino la verità, nella birra la forza, nell'acqua i bacilli -- In wine there is truth, in beer there is strenght, in water there are bacteria -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] embeding media from DB
Sorry... that should be mySQL database Cheers, Brad Nel vino la verità, nella birra la forza, nell'acqua i bacilli -- In wine there is truth, in beer there is strenght, in water there are bacteria From: Brad Wright [EMAIL PROTECTED] Date: Thu, 13 Jun 2002 14:59:37 +1000 To: PHP General List [EMAIL PROTECTED] Subject: [PHP] embeding media from DB Hi all, I have been able to upload a wav file to a mxSQl db using PHP script. Wanted to be able to get that wav file from the db and embed it into a web page using the default media player to play it. Can anyone help??? Cheers, Brad Nel vino la verità, nella birra la forza, nell'acqua i bacilli -- In wine there is truth, in beer there is strenght, in water there are bacteria -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] File download/upload
Hello, Can anyone point me towards a tute (or any info) about using php to upload and download medium size (~500k-1meg) files into a mySQL database (as blob's i assume). Cheers, Brad Nel vino la verità, nella birra la forza, nell'acqua i bacilli -- In wine there is truth, in beer there is strenght, in water there are bacteria -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] email attachments and PHP
Hi all, I was wondering if there is a way to attach files to emails sent via a PHP script. I just checked the 'mail functions' chapter of the php manual, but it doesn't seem to mention attachments. The attached files will come from the same server that php is running on BTW. Thanks in advance. Brad Nel vino la verità, nella birra la forza, nell'acqua i bacilli -- In wine there is truth, in beer there is strenght, in water there are bacteria -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Tracking mail() problems
Hi all, I am running PHP 4.03 on a linux box and am having problems with the mail() function. I use the syntax: ([EMAIL PROTECTED], if this works, ring me and we party, Line 1\nLine 2\nLine 3, From: [EMAIL PROTECTED]) When the script is run, i get no error msg, and the rest of the script works fine, but no mail sent. Mail log shows no record of any event from this script. Is there another way that I can check foir activity from this function/?. Any ideas, this is killing me. Thanks in advance, brad -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP MAIL function...why wont it work????
Yep it is a linux box. From: DL Neil [EMAIL PROTECTED] Reply-To: DL Neil [EMAIL PROTECTED] Date: Thu, 28 Feb 2002 22:55:59 - To: Brad Wright [EMAIL PROTECTED], PHP General List [EMAIL PROTECTED] Subject: Re: [PHP] PHP MAIL function...why wont it work Hi Brad, Hi all... I have a line in a page that should send me an email when the page is loaded. mail([EMAIL PROTECTED], worked, Line 1\nLine 2\nLine 3); when i load the page...i get NO error msgs, but the function does not send the mail. There is no record of any activity in the mail log...any ideas... If your server is not a *nix box you need to separate headers with CRLF (Win) or CR (Mac). What does php.ini say in the mail section? Simplify the msg right down to the barest minimum, get it to work, then start adding... =dn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP MAIL function...why wont it work????
Hi all... I have a line in a page that should send me an email when the page is loaded. Here is the line i am using: mail([EMAIL PROTECTED], worked, Line 1\nLine 2\nLine 3); when i load the page...i get NO error msgs, but the function does not send the mail. There is no record of any activity in the mail log...any ideas... I AM GOING INSANE Thanks in advance, Brad -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] 2 conditions why wont they work??
Hi all, Im was sure you could select a row from a mySQL database based on 2 conditions. My code: $query2 = select * from Table where userNo = $userNo and clientID = $clientID; $result2 = mysql_query($query2,$db); This returns : Warning: Supplied argument is not a valid MySQL result resource b ut if i change the line to: $query2 = select * from Table where userNo = $userNo; $result2 = mysql_query($query2,$db); it works (but get all the rows with userNo = $userNo. HELP Im sure this should work...what am i doing wrong??? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 2 conditions why wont they work??
Thanks, $clientID is a string but is not empty...already tried echo($clientID) and it is not empty. Did you mean that if the value of $cientID is a string it wont work Thanks Brad From: Bogdan Stancescu [EMAIL PROTECTED] Date: Mon, 11 Feb 2002 05:38:31 +0200 To: Brad Wright [EMAIL PROTECTED] Cc: PHP General List [EMAIL PROTECTED] Subject: Re: [PHP] 2 conditions why wont they work?? Do an echo($clientID) before - it most probably is either empty or it's a string and MySQL actually issues errors there. Bogdan Brad Wright wrote: Hi all, Im was sure you could select a row from a mySQL database based on 2 conditions. My code: $query2 = select * from Table where userNo = $userNo and clientID = $clientID; $result2 = mysql_query($query2,$db); This returns : Warning: Supplied argument is not a valid MySQL result resource b ut if i change the line to: $query2 = select * from Table where userNo = $userNo; $result2 = mysql_query($query2,$db); it works (but get all the rows with userNo = $userNo. HELP Im sure this should work...what am i doing wrong??? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 2 conditions why wont they work??
Ahh..that seems to have fixed it. Its now pulling NO data, but is not giving error msg thanks, 1/2 way there now :) brad From: Bogdan Stancescu [EMAIL PROTECTED] Date: Mon, 11 Feb 2002 05:46:46 +0200 To: Brad Wright [EMAIL PROTECTED] Cc: PHP General List [EMAIL PROTECTED] Subject: Re: [PHP] 2 conditions why wont they work?? No, with your syntax it won't. You have to quote it in the query, as in $query2 = select * from Table where userNo = $userNo and clientID = '$clientID'; Bogdan Brad Wright wrote: Thanks, $clientID is a string but is not empty...already tried echo($clientID) and it is not empty. Did you mean that if the value of $cientID is a string it wont work Thanks Brad From: Bogdan Stancescu [EMAIL PROTECTED] Date: Mon, 11 Feb 2002 05:38:31 +0200 To: Brad Wright [EMAIL PROTECTED] Cc: PHP General List [EMAIL PROTECTED] Subject: Re: [PHP] 2 conditions why wont they work?? Do an echo($clientID) before - it most probably is either empty or it's a string and MySQL actually issues errors there. Bogdan Brad Wright wrote: Hi all, Im was sure you could select a row from a mySQL database based on 2 conditions. My code: $query2 = select * from Table where userNo = $userNo and clientID = $clientID; $result2 = mysql_query($query2,$db); This returns : Warning: Supplied argument is not a valid MySQL result resource b ut if i change the line to: $query2 = select * from Table where userNo = $userNo; $result2 = mysql_query($query2,$db); it works (but get all the rows with userNo = $userNo. HELP Im sure this should work...what am i doing wrong??? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 2 conditions why wont they work??
Bogdan, It appears that $clientID is saved with a space at the start .. when i check for its value (using session_encode() ) it gives that value test 3 when it should be test 3. input type=hidden name=XclientID value=?php echo $row[clientID];? this is the extract form the form on the previous page which sets $clientID. I am sure that a space is being added but cant find where. Thanks for yr help, Brad From: Bogdan Stancescu [EMAIL PROTECTED] Date: Mon, 11 Feb 2002 05:53:46 +0200 To: Brad Wright [EMAIL PROTECTED] Cc: PHP General List [EMAIL PROTECTED] Subject: Re: [PHP] 2 conditions why wont they work?? Well, that's probably because of the data - no entries with both conditions satisfied... Use or if that's what you actually want to do. ;-) Bogdan Brad Wright wrote: Ahh..that seems to have fixed it. Its now pulling NO data, but is not giving error msg thanks, 1/2 way there now :) brad From: Bogdan Stancescu [EMAIL PROTECTED] Date: Mon, 11 Feb 2002 05:46:46 +0200 To: Brad Wright [EMAIL PROTECTED] Cc: PHP General List [EMAIL PROTECTED] Subject: Re: [PHP] 2 conditions why wont they work?? No, with your syntax it won't. You have to quote it in the query, as in $query2 = select * from Table where userNo = $userNo and clientID = '$clientID'; Bogdan Brad Wright wrote: Thanks, $clientID is a string but is not empty...already tried echo($clientID) and it is not empty. Did you mean that if the value of $cientID is a string it wont work Thanks Brad From: Bogdan Stancescu [EMAIL PROTECTED] Date: Mon, 11 Feb 2002 05:38:31 +0200 To: Brad Wright [EMAIL PROTECTED] Cc: PHP General List [EMAIL PROTECTED] Subject: Re: [PHP] 2 conditions why wont they work?? Do an echo($clientID) before - it most probably is either empty or it's a string and MySQL actually issues errors there. Bogdan Brad Wright wrote: Hi all, Im was sure you could select a row from a mySQL database based on 2 conditions. My code: $query2 = select * from Table where userNo = $userNo and clientID = $clientID; $result2 = mysql_query($query2,$db); This returns : Warning: Supplied argument is not a valid MySQL result resource b ut if i change the line to: $query2 = select * from Table where userNo = $userNo; $result2 = mysql_query($query2,$db); it works (but get all the rows with userNo = $userNo. HELP Im sure this should work...what am i doing wrong??? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MySql number/string comparing ideas...
I would use something like this: Select * from table where value1 500 AND value2 100 hope this helps, brad From: elias [EMAIL PROTECTED] Date: Fri, 13 Jul 2001 07:06:26 -0700 To: [EMAIL PROTECTED] Subject: [PHP] MySql number/string comparing ideas... Hi! How is it possible to do a MySql query for something like: SELECT value from table WHERE value '500x100' should return all values that part1 must be less than 500 and part2 less than 100? like 499x99 and reject something like: 500x101 please give me suggestions! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] new lines in text fields
use the 'nl2br' fuction Inserts HTML line breaks before all newlines in a string From: Mat Marlow [EMAIL PROTECTED] Date: Fri, 6 Jul 2001 16:06:58 +0100 To: [EMAIL PROTECTED] Subject: [PHP] new lines in text fields Hi all, I am in desperate need for a solution to HTML text fields not storing new lines. I'm storing news articles in a database but all the text just ends up in a big block because it ignores line breaks. Is thre a way around this without having to upload text files? Thanks, Mat -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] session cookies not destroyed
Hi all, I was wondering if anyone has had any problems with sessions and IE 5.0 (mac). As I (limitedly) understand it, the session cookie (kept by IE) should be destroyed when I quit IE. It should, therefor, not be there when I restart IE. HOWEVER.. I seem to get very unpredictable behaviour in that sometimes the cookie is destroyed and sometimes it isn't. The only constant seems to be that if I close IE, then restart the computer, the cookie is always gone. But if i don't restart the computer, the cookie is sometimes destroyed and sometimes not. Has anyone experienced this problem. even better, does anyone know how to solve this problem. :) Thanks in advanced, Brad -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] MySql number/string comparing ideas...
elias, I would have to agree with Lawrence, and recommend re-designing your database, unless there is a specific reason preventing you doing this (ie like months of your life invested in the product ; ) otherwise, only allowing numerical input is a good start tho :) brad From: elias [EMAIL PROTECTED] Date: Wed, 25 Jul 2001 10:22:32 +0200 To: [EMAIL PROTECTED] Subject: Re: [PHP] MySql number/string comparing ideas... well yes, somehow my field has like: field1 -- 1.2 99.123 500x120 561x112 5.5 so as you see this 'field1' have both normal numeric values and sometimes 'YYYxYYY' values... I thought that MySql can somehow compare with another number and compare correctly x with anoter value just like it: x anyway...I just forgot about it and droped the YYYxYYY from my table and only allowed numerical input, The problem is that I'm using the same field for two type of data storage... Brad Wright [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I would use something like this: Select * from table where value1 500 AND value2 100 hope this helps, brad From: elias [EMAIL PROTECTED] Date: Fri, 13 Jul 2001 07:06:26 -0700 To: [EMAIL PROTECTED] Subject: [PHP] MySql number/string comparing ideas... Hi! How is it possible to do a MySql query for something like: SELECT value from table WHERE value '500x100' should return all values that part1 must be less than 500 and part2 less than 100? like 499x99 and reject something like: 500x101 please give me suggestions! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] mysql_query problem (FINALLY FIXED !!!!!!!)
Hi all (he says with a sheepish grin:),
To all of those who tried to help with this thread, I thank you from the
bottom of my heart
Unfortunatly , the problem was not one of syntax, but rather one of gross
stupidity on my behalf. The Field where I had been keeping the (encrypted)
passwords was set to 6 spaces, thus chopping off at least 1/2 of the
encrypted password. So when it was looking for password('a') (which is
60671c896665c3fa BTW), it was only seeing 60671c in the field.therefor
NO MATCH.
What a stupid mistake, delaying me for 1 1/2 days. At least I know I'm not
as crazey as I thought i was going.
I guess the lesson here is to step back once in a while and try looking
'around the edges' of a wall. Its amazing what you may find :).
Once again, thanks to all those kind souls who gave up there own time to try
to help this ol' fool.
Cheers,
Brad
From: Christopher Allen [EMAIL PROTECTED]
Date: Tue, 17 Jul 2001 09:11:05 -0500
To: Brad Wright [EMAIL PROTECTED]
Subject: Re: [PHP] mysql_query problem (more suggestions)
not right because this works in a live system:
$query1 = SELECT * FROM zip_base WHERE '$zip1' = zip '$zip1' =
CONCAT(SUBSTRING(zip, '1', LENGTH(zip)-LENGTH(range)), range)
CONCAT, SUBSTRING and LENGTH are all mysql functions and they work fine in
this query.
the problem is (as i understand it), the password function is a mySQL
function and not a PHP function, therefor it works in the context of a
mysql_query, but not as a PHP function (which your suggested code calls).
Unless i have actually defined a function 'password()', calling 'echo
password('$password') will (...does, i just double checked) causes a Fatal
Error 'Undefined Function'.
Nice try tho :)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Whats wrong with this code?
Hi all, Im getting mighty frustrated with this peice of code. It checks the
first condition no probs, but the second IF statement doesnt work. So it
will stop if it finds a du[plicate login, but cannot find duplicate
passwords. the $num_rows2 variable always gets the value '0' even when there
is an existing password the same as the new user-entered value.
I hope its a really simple syntax problem that i cant see. The slight
syntaxic (is that a word?) differences between the 2 IF statements are due
to 'trying anything' to get it working
I hope someone out there can help.
Thanks in advance,
Brad
// * Check for existing duplicate login
$result = mysql_query(SELECT * FROM Login_TB where Login='$Login',$db) or
die (ouch);
$num_rows = mysql_num_rows($result);
// echo $num_rows;
if ($num_rows != 0)
{
session_register(errorMsg);
$errorMsg = Username taken.;
echo $errorMsg;
exit;
}
// * Check for existing duplicate password
$query2 = select * FROM Team_Login_TB where Pass = password('$Pass');
$result2 = mysql_query($query2,$db) or die (ouch2);
$num_rows2 = mysql_num_rows($result2);
echo $num_rows2;
if ($num_rows2 != 0)
{
session_register(errorMsg);
$errorMsg = Password taken.;
echo $errorMsg;
exit;
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Whats wrong with this code?
Rasmus,
you are dead right, it is returning 0 rows. I checked that before
submiytting the original post. Sorry, i should have mentioned it. I guess
the question is, why is it returning no rows?
From: Rasmus Lerdorf [EMAIL PROTECTED]
Date: Mon, 16 Jul 2001 19:56:29 -0700 (PDT)
To: Brad Wright [EMAIL PROTECTED]
Cc: PHP General List [EMAIL PROTECTED]
Subject: Re: [PHP] Whats wrong with this code?
Hi all, Im getting mighty frustrated with this peice of code. It checks the
first condition no probs, but the second IF statement doesnt work. So it
will stop if it finds a du[plicate login, but cannot find duplicate
passwords. the $num_rows2 variable always gets the value '0' even when there
is an existing password the same as the new user-entered value.
$result = mysql_query(SELECT * FROM Login_TB where Login='$Login',$db) or
die (ouch);
$num_rows = mysql_num_rows($result);
$query2 = select * FROM Team_Login_TB where Pass = password('$Pass');
$result2 = mysql_query($query2,$db) or die (ouch2);
$num_rows2 = mysql_num_rows($result2);
Your second query must not be returning any rows. Print out $query2 and
paste the string you see into the command line mysql tool and execute the
query. I bet it will return 0 rows.
-Rasmus
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Whats wrong with this code?
Yep, I realise there was a discrepancy in the table names. That wasnt the
issue , i reposted the corrected code as soon as i realised.
From: David Robley [EMAIL PROTECTED]
Organization: Centre for Injury Studies
Reply-To: [EMAIL PROTECTED]
Date: Tue, 17 Jul 2001 12:53:57 +0930
To: Brad Wright [EMAIL PROTECTED], PHP General List
[EMAIL PROTECTED]
Subject: Re: [PHP] Whats wrong with this code?
On Tue, 17 Jul 2001 12:37, Brad Wright wrote:
From: Rasmus Lerdorf [EMAIL PROTECTED]
Date: Mon, 16 Jul 2001 19:56:29 -0700 (PDT)
To: Brad Wright [EMAIL PROTECTED]
Cc: PHP General List [EMAIL PROTECTED]
Subject: Re: [PHP] Whats wrong with this code?
Hi all, Im getting mighty frustrated with this peice of code. It
checks the first condition no probs, but the second IF statement
doesnt work. So it will stop if it finds a du[plicate login, but
cannot find duplicate passwords. the $num_rows2 variable always gets
the value '0' even when there is an existing password the same as
the new user-entered value.
$result = mysql_query(SELECT * FROM Login_TB where
Login='$Login',$db) or die (ouch);
$num_rows = mysql_num_rows($result);
$query2 = select * FROM Team_Login_TB where Pass =
password('$Pass'); $result2 = mysql_query($query2,$db) or die
(ouch2);
$num_rows2 = mysql_num_rows($result2);
Your second query must not be returning any rows. Print out $query2
and paste the string you see into the command line mysql tool and
execute the query. I bet it will return 0 rows.
-Rasmus
Rasmus,
you are dead right, it is returning 0 rows. I checked that before
submiytting the original post. Sorry, i should have mentioned it. I
guess the question is, why is it returning no rows?
This might be too obvious, but are you looking in the correct table? Your
second query searches a different table from the first? Alternatively,
you might be getting something you don't expect in $Pass.
--
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
1200 bps used to seem so fast
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Whats wrong with this code?
The only data in the table (Login_TB) is one row:
Login = a, and Pass= password('a').
From: Rasmus Lerdorf [EMAIL PROTECTED]
Date: Mon, 16 Jul 2001 20:24:44 -0700 (PDT)
To: Brad Wright [EMAIL PROTECTED]
Cc: PHP General List [EMAIL PROTECTED]
Subject: Re: [PHP] Whats wrong with this code?
Rasmus,
you are dead right, it is returning 0 rows. I checked that before
submiytting the original post. Sorry, i should have mentioned it. I guess
the question is, why is it returning no rows?
Uh, that is something we can't answer without having access to your actual
data.
-Rasmus
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] mysql_query problem
Hi all',
I have a mysql_query that reads:
$testResult = mysql_query(SELECT * FROM login_table where Pass =
password('$password')) or die (ouch);
$num_rows = mysql_num_rows($testResult);
the problem is that I keep getting a value of 0 for $num_rows when I know
the table has 1 entry for PAss which equals password('$password'). The
password I have used is just 'a' (before pasing throught the password
function in the insert).
I DO have a table named login_table
I KNOW that there is an entry that matches 'password('$password)'.. ( i
checked using phpMyAdmin)
can anyone help??
Thanks in advance,
brad
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] mysql_query problem (more suggestions)
the problem is (as i understand it), the password function is a mySQL
function and not a PHP function, therefor it works in the context of a
mysql_query, but not as a PHP function (which your suggested code calls).
Unless i have actually defined a function 'password()', calling 'echo
password('$password') will (...does, i just double checked) causes a Fatal
Error 'Undefined Function'.
Nice try tho :)
From: Alvin Tan [EMAIL PROTECTED]
Date: Tue, 17 Jul 2001 13:07:45 +0800
To: Brad Wright [EMAIL PROTECTED]
Subject: Re: [PHP] mysql_query problem (more suggestions)
Then,
how about this:
$pw = password($password);
$sql = SELECT * FROM login_table where Pass ='$pw';
$testResult = mysql_query($sql) or die (ouch);
echo $sql;
this way you can see what sql is talking to the db.
@lvin
At 12:59 PM 7/17/01, you wrote:
password('$variable') when used in a mysql_query, uses the mysql function to
convert the contents of $variable to an encrypted form for keeping in the
database.
From: Alvin Tan [EMAIL PROTECTED]
Date: Tue, 17 Jul 2001 12:49:06 +0800
To: Brad Wright [EMAIL PROTECTED]
Subject: Re: [PHP] mysql_query problem
Hi Brad,
Shouldn't it be:
$testResult = mysql_query(SELECT * FROM login_table where Pass =
'$password') or die (ouch);
^^
unless you have a function called password() you don't need to use the
$password variable within password('$password')
HTH,
@lvin
At 12:48 PM 7/17/01, you wrote:
$testResult = mysql_query(SELECT * FROM login_table where Pass =
password('$password')) or die (ouch);
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] mysql_query problem (more suggestions)
Jason,
I have tried what yoiu suggested. result is the same.
From: Jason Murray [EMAIL PROTECTED]
Date: Tue, 17 Jul 2001 15:28:11 +1000
To: 'Brad Wright' [EMAIL PROTECTED], Alvin Tan
[EMAIL PROTECTED], PHP General List [EMAIL PROTECTED]
Subject: RE: [PHP] mysql_query problem (more suggestions)
Unless i have actually defined a function 'password()', calling 'echo
password('$password') will (...does, i just double checked)
causes a Fatal
Error 'Undefined Function'.
Nice try tho :)
the original mail said to echo $query, which will include some
text in it that says password('ifovhfoiuf') ... you should
then paste that entire query into your MySQL interpreter and
see what the reaction is instead of trying to secondguess it :)
Jason
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] encrypting session variables
Hi all, Is there a simple way to encrypt session variables. If so, is there a method to 'decode' the encrypted session variable when required?. Thanks in advance, Brad -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] encrypting session variables
Tyrone, Make an MD5 hash using the session variable. Make it again (with the same seed) before using it, if the hashes don't match, it's been messed with. I'm sorry, I'm not sure what an MD5 hash is. Could you elaborate and/or point me towards some documentation. Thanks, Brad -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] form action problem
Hi all, i want to have a submit button on a page that has a php function (on the same page) as the action. ie. form name=form1 method=post action=?PHP functionA() ? input type=submit name=Submit value=Use functionA /form so when the 'Use functionA' button is pressed, the function 'functionA() ' is called (using php variables already defined before the form.) Thanks Brad -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Re: changing to a different file in browser
it was in fact the mistake that was causing the whole problem. Was there a
reason?...too little sleep and too much caffeine I'd say :)
From: motorpsychkill [EMAIL PROTECTED]
Date: Fri, 6 Jul 2001 20:38:18 -1100
To: Brad Wright [EMAIL PROTECTED]
Subject: RE: [PHP] Re: changing to a different file in browser
Is there a reason why you have close tags to be followed immediately by open
php tags? ie why do you have this:
?PHP session_start();?
?PHP
// Connect to the database
instead of this:
?PHP session_start();
//Connect to the database
.
.
.
just curious ;)
::-Original Message-
::From: Brad Wright [mailto:[EMAIL PROTECTED]]
::Sent: Thursday, July 05, 2001 5:20 PM
::To: PHP General List
::Subject: RE: [PHP] Re: changing to a different file in browser
::
::
::
::
::i'm not sure which file you meant but i took out all whityespace , hence:
::
::
::login.php:
::***
::?PHP session_start();?
::?PHP
::// Connect to the database
:: $db = mysql_connect(localhost, user, pass);
:: if( !$db ) die (Couldnt connect to server, try again soon..);
::// Select Database
::mysql_select_db(LoginDB, $db) or die (Couldn't connect to database);
::// Query Database table
::$query = select * from Admin_Login_TB where teamLogin = '$teamLogin'
::teamPass = '$teamPass' ;
::$result = mysql_query($query,$db);
::// LIst the matching row values
::list ($teamLogin, $teamPass, $teamNo)=mysql_fetch_row($result);
::// Test to see if a match was found
::// If not: the die
::// if match found then continue
::if (!mysql_numrows($result) ) {
::die ( username/password not valid);
::}
::else{
::header(Location: adminMenu.php);
::exit; }
::?
::***
::
::menu.php:
::**
::?PHP session_start();?
::html
::head
::titleUntitled Document/title
::meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
::/head
::body bgcolor=blue
::/body
::/html
::**
::
::I still get the same error..
::
::
::
::any ideas???
::
::
::cheers,
::brad
:: From: Brian White [EMAIL PROTECTED]
:: Date: Fri, 06 Jul 2001 13:59:45 +1000
:: To: Brad Wright [EMAIL PROTECTED], PHP General List
:: [EMAIL PROTECTED]
:: Subject: Re: [PHP] Re: changing to a different file in browser
::
:: At 13:36 6/07/2001 +1000, Brad Wright wrote:
:: I'm sure there is something REALLY simple Im missing here
::below is the
:: ...
::
:: OK. I think your problem is here. Between the first ? and the second
:: ?PHP
:: is a piece of white-space. This is treated by PHP as text,
::which triggers it
:: to
:: send the headers, before sending off the encountered text.
::
:: Try making removing them and see what happens.
::
:: login.php:
:: ?PHP
:: session_start();
:: ?
:: ?PHP
::
:: // Connect to the database
:: $db = mysql_connect(localhost, user, pass);
:: if( !$db )die (Couldnt connect to server, try again soon. );
::
:: // Select Database
::
:: mysql_select_db(LoginDB, $db) or die (Couldn't connect to
::the database,
:: sorry.);
::
:: // Query Database table
:: $query = select * from Admin_Login_TB where teamLogin =
::'$teamLogin'
:: teamPass = '$teamPass' ;
:: $result = mysql_query($query,$db);
::
:: // LIst the matching row values
:: list ($teamLogin, $teamPass, $teamNo)=mysql_fetch_row($result);
::
::
::
::
:: // Test to see if a match was found
:: // If not: then die
:: // if match found then continue
::
:: if (!mysql_numrows($result) ) {
:: die ( username/password not valid);
:: }
:: else{
:: header(Location: menu.php);
:: exit; }
:: ?
::
::
:: *
::
:: menu.php
:: ?PHP session_start();
:: ?
:: test
::
::
:: I hope you can see a glareingly obvious problem that i can't
::
:: Cheers,
:: Brad
::
:: From: ..s.c.o.t.t.. [EMAIL PROTECTED]
:: Date: Thu, 5 Jul 2001 23:13:09 -0700
:: To: Php-General [EMAIL PROTECTED]
:: Subject: RE: [PHP] Re: changing to a different file in browser
::
:: even a blank line at the end of a file that you're
:: include()ing will break header.
::
:: you could use output buffering, but i dont think
:: you really want to go to all that trouble for a simple
:: redirect :)
::
:: -Original Message-
:: From: Chris Anderson [mailto:[EMAIL PROTECTED]]
:: Sent: Thursday, July 05, 2001 19:47
:: To: Brad Wright; PHP General List
:: Subject: Re: [PHP] Re: changing to a different file in browser
::
::
:: If you use Header after ANY page output, even a space, it
::will not work
:: - Original Message -
:: From: Brad Wright [EMAIL PROTECTED]
:: To: PHP General List [EMAIL PROTECTED]
:: Sent: Thursday, July 05, 2001 10:25 PM
:: Subject: Re: [PHP] Re: changing to a different file in browser
::
::
:: tried it, but it didn't work
[PHP] session troubles
Hi all, Im new to this mailing list so im not sure what to expect from 'y'all' but i'm hoping this will be the beginning of a long and beautiful friendship. My question: i have a series of PHP4 pages that if I start a session (session_start()) on the first page (adminLogin.php), all is fine and dandy...all the session_resources get passed to the next page (login2.php) and i can get acccess to those session resources. Te problem is, at the top of the page a warning message is displayed: Warning: Cannot send session cache limiter - headers already sent (output started at /home/e-smith/files/ibays/test/html/login2.php:1) in /home/e-smith/files/ibays/test/html/login2.php on line 1 What does this mean?? If i comment out the session_start() line, i dodnt get this message BUT i also dont get the session variuables i need. Hope Im making some sense, Hope someone can help. Thanks, Brad -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] changing to a different file in browser
Hi all, I know this is probably the most stupid question you'll see on this list for a while, but anyway, In an 'if..else' statement, I want to (if a condition is met) change to a totally new php page in the browser window. I know this is simple (in fact i had it working last night but have now forgotten how i did it). ie (no the following is NOT actual PHPsheesh :) . If a=1 go to required_page.php else do nothing Thanks in advance, Brad -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Re: changing to a different file in browser
ihave tried the header() function as Julio suggested. But I get an error
message in the browser. I am also using session variables in all these pages
(only 2).
My code :
if (!mysql_numrows($result) ) {
die ( username/password not valid);
}
else{
header(Menu.php);
}
the error message in IE:
Warning: Cannot add header information - headers already sent by (output
started at /home/e-smith/files/ibays/bigpool1/html/login.php:1) in
/home/e-smith/files/ibays/bigpool1/html/login.php on line 1
Thanks in advance,
brad
From: Inércia Sensorial [EMAIL PROTECTED]
Date: Thu, 5 Jul 2001 22:26:24 -0300
To: [EMAIL PROTECTED]
Subject: [PHP] Re: changing to a different file in browser
header (http://www.example.com;); // Goes to example.com.
--
Julio Nobrega.
A hora está chegando:
http://sourceforge.net/projects/toca
Brad Wright [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi all,
I know this is probably the most stupid question you'll see on this list
for
a while, but anyway,
In an 'if..else' statement, I want to (if a condition is met) change to a
totally new php page in the browser window. I know this is simple (in fact
i
had it working last night but have now forgotten how i did it).
ie (no the following is NOT actual PHPsheesh :)
If a=1
go to required_page.php
else
do nothing
Thanks in advance,
Brad
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Re: changing to a different file in browser
tried it, but it didn't work... still getting the same message in IE. Am I
missing something? Can I actually use the headr() function to redirect to a
different page while using sesions and session variables??
From: ..s.c.o.t.t.. [EMAIL PROTECTED]
Date: Thu, 5 Jul 2001 22:32:22 -0700
To: Php-General [EMAIL PROTECTED]
Subject: RE: [PHP] Re: changing to a different file in browser
put Location before the URL:
header(Location: http://server.com/file.php;);
or
header(Location: ./file.php);
-Original Message-
From: Brad Wright [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 18:54
To: PHP General List
Subject: Re: [PHP] Re: changing to a different file in browser
ihave tried the header() function as Julio suggested. But I get an error
message in the browser. I am also using session variables in all these pages
(only 2).
My code :
if (!mysql_numrows($result) ) {
die ( username/password not valid);
}
else{
header(Menu.php);
}
the error message in IE:
Warning: Cannot add header information - headers already sent by (output
started at /home/e-smith/files/ibays/bigpool1/html/login.php:1) in
/home/e-smith/files/ibays/bigpool1/html/login.php on line 1
Thanks in advance,
brad
From: Inércia Sensorial [EMAIL PROTECTED]
Date: Thu, 5 Jul 2001 22:26:24 -0300
To: [EMAIL PROTECTED]
Subject: [PHP] Re: changing to a different file in browser
header (http://www.example.com;); // Goes to example.com.
--
Julio Nobrega.
A hora está chegando:
http://sourceforge.net/projects/toca
Brad Wright [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi all,
I know this is probably the most stupid question you'll see on this list
for
a while, but anyway,
In an 'if..else' statement, I want to (if a condition is met) change to a
totally new php page in the browser window. I know this is simple (in fact
i
had it working last night but have now forgotten how i did it).
ie (no the following is NOT actual PHPsheesh :)
If a=1
go to required_page.php
else
do nothing
Thanks in advance,
Brad
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Re: changing to a different file in browser
I'm sure there is something REALLY simple Im missing here below is the
copy of the two files in question. the first file (login.php) queries the
database (using variables supplied in a form in the preceding page) and
authenticates the user. If the user does not exist, it dies, if the user
does exist, te page should redirect to 'menu.php' (which resides in the same
directory. The file contents follow:
login.php:
?PHP
session_start();
?
?PHP
// Connect to the database
$db = mysql_connect(localhost, user, pass);
if( !$db )die (Couldnt connect to server, try again soon. );
// Select Database
mysql_select_db(LoginDB, $db) or die (Couldn't connect to the database,
sorry.);
// Query Database table
$query = select * from Admin_Login_TB where teamLogin = '$teamLogin'
teamPass = '$teamPass' ;
$result = mysql_query($query,$db);
// LIst the matching row values
list ($teamLogin, $teamPass, $teamNo)=mysql_fetch_row($result);
// Test to see if a match was found
// If not: then die
// if match found then continue
if (!mysql_numrows($result) ) {
die ( username/password not valid);
}
else{
header(Location: menu.php);
exit; }
?
*
menu.php
?PHP session_start();
?
html
head
titleUntitled Document/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body bgcolor=#blue
test
/body
/html
I hope you can see a glareingly obvious problem that i can't
Cheers,
Brad
From: ..s.c.o.t.t.. [EMAIL PROTECTED]
Date: Thu, 5 Jul 2001 23:13:09 -0700
To: Php-General [EMAIL PROTECTED]
Subject: RE: [PHP] Re: changing to a different file in browser
even a blank line at the end of a file that you're
include()ing will break header.
you could use output buffering, but i dont think
you really want to go to all that trouble for a simple
redirect :)
-Original Message-
From: Chris Anderson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 19:47
To: Brad Wright; PHP General List
Subject: Re: [PHP] Re: changing to a different file in browser
If you use Header after ANY page output, even a space, it will not work
- Original Message -
From: Brad Wright [EMAIL PROTECTED]
To: PHP General List [EMAIL PROTECTED]
Sent: Thursday, July 05, 2001 10:25 PM
Subject: Re: [PHP] Re: changing to a different file in browser
tried it, but it didn't work... still getting the same message in IE. Am I
missing something? Can I actually use the headr() function to redirect to a
different page while using sesions and session variables??
From: ..s.c.o.t.t.. [EMAIL PROTECTED]
Date: Thu, 5 Jul 2001 22:32:22 -0700
To: Php-General [EMAIL PROTECTED]
Subject: RE: [PHP] Re: changing to a different file in browser
put Location before the URL:
header(Location: http://server.com/file.php;);
or
header(Location: ./file.php);
-Original Message-
From: Brad Wright [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 18:54
To: PHP General List
Subject: Re: [PHP] Re: changing to a different file in browser
ihave tried the header() function as Julio suggested. But I get an error
message in the browser. I am also using session variables in all these
pages
(only 2).
My code :
if (!mysql_numrows($result) ) {
die ( username/password not valid);
}
else{
header(Menu.php);
}
the error message in IE:
Warning: Cannot add header information - headers already sent by (output
started at /home/e-smith/files/ibays/bigpool1/html/login.php:1) in
/home/e-smith/files/ibays/bigpool1/html/login.php on line 1
Thanks in advance,
brad
From: Inércia Sensorial [EMAIL PROTECTED]
Date: Thu, 5 Jul 2001 22:26:24 -0300
To: [EMAIL PROTECTED]
Subject: [PHP] Re: changing to a different file in browser
header (http://www.example.com;); // Goes to example.com.
--
Julio Nobrega.
A hora está chegando:
http://sourceforge.net/projects/toca
Brad Wright [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi all,
I know this is probably the most stupid question you'll see on this
list
for
a while, but anyway,
In an 'if..else' statement, I want to (if a condition is met) change to
a
totally new php page in the browser window. I know this is simple (in
fact
i
had it working last night but have now forgotten how i did it).
ie (no the following is NOT actual PHPsheesh :)
If a=1
go to required_page.php
else
do nothing
Thanks in advance,
Brad
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL P
RE: [PHP] Re: changing to a different file in browser
i'm not sure which file you meant but i took out all whityespace , hence:
login.php:
***
?PHP session_start();?
?PHP
// Connect to the database
$db = mysql_connect(localhost, user, pass);
if( !$db ) die (Couldnt connect to server, try again soon..);
// Select Database
mysql_select_db(LoginDB, $db) or die (Couldn't connect to database);
// Query Database table
$query = select * from Admin_Login_TB where teamLogin = '$teamLogin'
teamPass = '$teamPass' ;
$result = mysql_query($query,$db);
// LIst the matching row values
list ($teamLogin, $teamPass, $teamNo)=mysql_fetch_row($result);
// Test to see if a match was found
// If not: the die
// if match found then continue
if (!mysql_numrows($result) ) {
die ( username/password not valid);
}
else{
header(Location: adminMenu.php);
exit; }
?
***
menu.php:
**
?PHP session_start();?
html
head
titleUntitled Document/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body bgcolor=blue
/body
/html
**
I still get the same error..
any ideas???
cheers,
brad
From: Brian White [EMAIL PROTECTED]
Date: Fri, 06 Jul 2001 13:59:45 +1000
To: Brad Wright [EMAIL PROTECTED], PHP General List
[EMAIL PROTECTED]
Subject: Re: [PHP] Re: changing to a different file in browser
At 13:36 6/07/2001 +1000, Brad Wright wrote:
I'm sure there is something REALLY simple Im missing here below is the
...
OK. I think your problem is here. Between the first ? and the second
?PHP
is a piece of white-space. This is treated by PHP as text, which triggers it
to
send the headers, before sending off the encountered text.
Try making removing them and see what happens.
login.php:
?PHP
session_start();
?
?PHP
// Connect to the database
$db = mysql_connect(localhost, user, pass);
if( !$db )die (Couldnt connect to server, try again soon. );
// Select Database
mysql_select_db(LoginDB, $db) or die (Couldn't connect to the database,
sorry.);
// Query Database table
$query = select * from Admin_Login_TB where teamLogin = '$teamLogin'
teamPass = '$teamPass' ;
$result = mysql_query($query,$db);
// LIst the matching row values
list ($teamLogin, $teamPass, $teamNo)=mysql_fetch_row($result);
// Test to see if a match was found
// If not: then die
// if match found then continue
if (!mysql_numrows($result) ) {
die ( username/password not valid);
}
else{
header(Location: menu.php);
exit; }
?
*
menu.php
?PHP session_start();
?
test
I hope you can see a glareingly obvious problem that i can't
Cheers,
Brad
From: ..s.c.o.t.t.. [EMAIL PROTECTED]
Date: Thu, 5 Jul 2001 23:13:09 -0700
To: Php-General [EMAIL PROTECTED]
Subject: RE: [PHP] Re: changing to a different file in browser
even a blank line at the end of a file that you're
include()ing will break header.
you could use output buffering, but i dont think
you really want to go to all that trouble for a simple
redirect :)
-Original Message-
From: Chris Anderson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 19:47
To: Brad Wright; PHP General List
Subject: Re: [PHP] Re: changing to a different file in browser
If you use Header after ANY page output, even a space, it will not work
- Original Message -
From: Brad Wright [EMAIL PROTECTED]
To: PHP General List [EMAIL PROTECTED]
Sent: Thursday, July 05, 2001 10:25 PM
Subject: Re: [PHP] Re: changing to a different file in browser
tried it, but it didn't work... still getting the same message in IE. Am I
missing something? Can I actually use the headr() function to redirect
to a
different page while using sesions and session variables??
From: ..s.c.o.t.t.. [EMAIL PROTECTED]
Date: Thu, 5 Jul 2001 22:32:22 -0700
To: Php-General [EMAIL PROTECTED]
Subject: RE: [PHP] Re: changing to a different file in browser
put Location before the URL:
header(Location: http://server.com/file.php;);
or
header(Location: ./file.php);
-Original Message-
From: Brad Wright [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 18:54
To: PHP General List
Subject: Re: [PHP] Re: changing to a different file in browser
ihave tried the header() function as Julio suggested. But I get an error
message in the browser. I am also using session variables in all these
pages
(only 2).
My code :
if (!mysql_numrows($result) ) {
die ( username/password not valid);
}
else{
header(Menu.php);
}
the error message in IE:
Warning: Cannot add header information - headers already sent by (output
started at /home/e-smith/files/ibays/bigpool1/html/login.php:1) in
/home/e-smith/files/ibays/bigpool1/html/login.php on line 1
Thanks in advance,
brad
From: Inércia
Re: [PHP] Re: changing to a different file in browser
Brian, Oh Brian, you wonderful person you..
thank you, i still have most of my hair ready for my next encounter with an
annoying error.
Thank you to all who helped, my weekend suddenly is looking much rosier :)
Cheers,
Brad
From: Brian White [EMAIL PROTECTED]
Date: Fri, 06 Jul 2001 14:39:05 +1000
To: Brad Wright [EMAIL PROTECTED], PHP General List
[EMAIL PROTECTED]
Subject: RE: [PHP] Re: changing to a different file in browser
You didn't quite get what I meant - in login.php, you have two lumps
of PHP code ( lump being ?PHP ... ? ) separated by a little bit of white
space. That little bit of white-space BETWEEN the lumps is what is causing
your problems.
Reduce it down to one lump and try again.
Ie:
login.php:
?PHP
session_start();
// ? ... ?PHP removed from here
// Connect to the database
$db = mysql_connect(localhost, user, pass);
if( !$db )die (Couldnt connect to server, try again soon. );
( ... remainder of login.php ...)
At 14:20 6/07/2001 +1000, Brad Wright wrote:
i'm not sure which file you meant but i took out all whityespace , hence:
login.php:
***
?PHP session_start();?
?PHP
// Connect to the database
$db = mysql_connect(localhost, user, pass);
if( !$db ) die (Couldnt connect to server, try again soon..);
// Select Database
mysql_select_db(LoginDB, $db) or die (Couldn't connect to database);
// Query Database table
$query = select * from Admin_Login_TB where teamLogin = '$teamLogin'
teamPass = '$teamPass' ;
$result = mysql_query($query,$db);
// LIst the matching row values
list ($teamLogin, $teamPass, $teamNo)=mysql_fetch_row($result);
// Test to see if a match was found
// If not: the die
// if match found then continue
if (!mysql_numrows($result) ) {
die ( username/password not valid);
}
else{
header(Location: adminMenu.php);
exit; }
?
***
menu.php:
**
?PHP session_start();?
**
I still get the same error..
any ideas???
cheers,
brad
From: Brian White [EMAIL PROTECTED]
Date: Fri, 06 Jul 2001 13:59:45 +1000
To: Brad Wright [EMAIL PROTECTED], PHP General List
[EMAIL PROTECTED]
Subject: Re: [PHP] Re: changing to a different file in browser
At 13:36 6/07/2001 +1000, Brad Wright wrote:
I'm sure there is something REALLY simple Im missing here below is the
...
OK. I think your problem is here. Between the first ? and the second
?PHP
is a piece of white-space. This is treated by PHP as text, which
triggers it
to
send the headers, before sending off the encountered text.
Try making removing them and see what happens.
login.php:
?PHP
session_start();
?
?PHP
// Connect to the database
$db = mysql_connect(localhost, user, pass);
if( !$db )die (Couldnt connect to server, try again soon. );
// Select Database
mysql_select_db(LoginDB, $db) or die (Couldn't connect to the
database,
sorry.);
// Query Database table
$query = select * from Admin_Login_TB where teamLogin = '$teamLogin'
teamPass = '$teamPass' ;
$result = mysql_query($query,$db);
// LIst the matching row values
list ($teamLogin, $teamPass, $teamNo)=mysql_fetch_row($result);
// Test to see if a match was found
// If not: then die
// if match found then continue
if (!mysql_numrows($result) ) {
die ( username/password not valid);
}
else{
header(Location: menu.php);
exit; }
?
*
menu.php
?PHP session_start();
?
test
I hope you can see a glareingly obvious problem that i can't
Cheers,
Brad
From: ..s.c.o.t.t.. [EMAIL PROTECTED]
Date: Thu, 5 Jul 2001 23:13:09 -0700
To: Php-General [EMAIL PROTECTED]
Subject: RE: [PHP] Re: changing to a different file in browser
even a blank line at the end of a file that you're
include()ing will break header.
you could use output buffering, but i dont think
you really want to go to all that trouble for a simple
redirect :)
-Original Message-
From: Chris Anderson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 19:47
To: Brad Wright; PHP General List
Subject: Re: [PHP] Re: changing to a different file in browser
If you use Header after ANY page output, even a space, it will not work
- Original Message -
From: Brad Wright [EMAIL PROTECTED]
To: PHP General List [EMAIL PROTECTED]
Sent: Thursday, July 05, 2001 10:25 PM
Subject: Re: [PHP] Re: changing to a different file in browser
tried it, but it didn't work... still getting the same message in
IE. Am I
missing something? Can I actually use the headr() function to redirect
to a
different page while using sesions and session variables??
From: ..s.c.o.t.t.. [EMAIL PROTECTED]
Date: Thu, 5 Jul 2001 22:32:22 -0700
To: Php-General [EMAIL PROTECTED]
Subject: RE
