[PHP-DB] redirecting to a page
I need to redirect to another page once some scripts that I can't alter run. I have this function at the top of my page: How do I call the function? Rick
RE: [PHP-DB] redirecting to a page
Redirect(www.mypage.com);
> -Original Message-
> From: Rick Dahl [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 30, 2003 10:23 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] redirecting to a page
>
>
> I need to redirect to another page once some scripts that I
> can't alter run.
>
> I have this function at the top of my page:
>
>function Redirect ($url) {
> Header ("Location: " . $url);
> exit;
> }
> ?>
>
> How do I call the function?
>
> Rick
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] redirecting to a page
Remember, though, you can't set an HTTP header after you've sent output to the client,
so you needc to do your redirecting (assuming there's a condition) before you display
ANYTHING.
BAD:
if (somecondition) { Redirect(www.mypage.com); }
...
GOOD:
} else {
Redirect(www.mypage.com);
}
HTH,
matt
> -Original Message-
> From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 30, 2003 10:26 AM
> To: 'Rick Dahl'; [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] redirecting to a page
>
>
> Redirect(www.mypage.com);
>
> > -Original Message-
> > From: Rick Dahl [mailto:[EMAIL PROTECTED]
> > Sent: Friday, May 30, 2003 10:23 AM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] redirecting to a page
> >
> >
> > I need to redirect to another page once some scripts that I
> > can't alter run.
> >
> > I have this function at the top of my page:
> >
> > > function Redirect ($url) {
> > Header ("Location: " . $url);
> > exit;
> > }
> > ?>
> >
> > How do I call the function?
> >
> > Rick
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] redirecting to a page
Comments inline ...
On 30 May,2003 at 10:25 Hutchins, Richard wrote:
> Redirect(www.mypage.com);
>
You'll need "" around the url I reckon as in
Redirect("www.mypage.com");
;-)
Ronan
e: [EMAIL PROTECTED]
t: 01903 739 997
w: www.thelittledot.com
The Little Dot is a partnership of
Ronan Chilvers and Giles Webberley
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] another redirecting question
The scripts I need to run before I redirect automatically send output to the browser. I cannot alter these scripts. Is there a way around this? Rick
RE: [PHP-DB] another redirecting question
use javascript for your redirects then you wont have these problems -Original Message- From: Rick Dahl [mailto:[EMAIL PROTECTED] Sent: 30 May 2003 15:43 To: [EMAIL PROTECTED] Subject: [PHP-DB] another redirecting question The scripts I need to run before I redirect automatically send output to the browser. I cannot alter these scripts. Is there a way around this? Rick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] another redirecting question
If the user has disabled JavaScript in the browser doesn't that create another problem? > -Original Message- > From: Griffiths, Daniel [mailto:[EMAIL PROTECTED] > Sent: Friday, May 30, 2003 10:44 AM > To: Rick Dahl; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] another redirecting question > > > use javascript for your redirects then you wont have these problems > > -Original Message- > From: Rick Dahl [mailto:[EMAIL PROTECTED] > Sent: 30 May 2003 15:43 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] another redirecting question > > > The scripts I need to run before I redirect automatically > send output to the browser. I cannot alter these scripts. > Is there a way around this? > > Rick > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] another redirecting question
> If the user has disabled JavaScript in the browser doesn't that create > another problem? Yes, it does. You've already said you're not going to rewrite your code so it's correct, though, so why worry about disabled javascript? John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] another redirecting question
good point, you could output a link for the user to click if they have turned it off. Another method would be to do the processing on the same page so that a redirect is not needed, just use a flag in the post or get array to run the nessasry script. -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED] Sent: 30 May 2003 15:47 To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] another redirecting question If the user has disabled JavaScript in the browser doesn't that create another problem? > -Original Message- > From: Griffiths, Daniel [mailto:[EMAIL PROTECTED] > Sent: Friday, May 30, 2003 10:44 AM > To: Rick Dahl; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] another redirecting question > > > use javascript for your redirects then you wont have these problems > > -Original Message- > From: Rick Dahl [mailto:[EMAIL PROTECTED] > Sent: 30 May 2003 15:43 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] another redirecting question > > > The scripts I need to run before I redirect automatically > send output to the browser. I cannot alter these scripts. > Is there a way around this? > > Rick > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] another redirecting question
Rick, The way I "solved" this problem is to have the output sent to a variable, let's say $temp_data, create a session and store $temp_data as a session variable, redirect to another page where I can read $temp_data and have it displayed on that page by calling it. Hopefully my explanation is clear enough and suits your needs.. Metin > -Original Message- > From: Rick Dahl [mailto:[EMAIL PROTECTED] > Sent: 30 May 2003 15:43 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] another redirecting question > > > The scripts I need to run before I redirect automatically > send output to the browser. I cannot alter these scripts. > Is there a way around this? > > Rick > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Optimize following Mysql-Query
Title: RE: [PHP-DB] Optimize following Mysql-Query
Another large performance hit is the use of "like" with the wildcards. If you can avoid wildcard searches do.
WHERE Personen.NAME IN ('$name')"; or "= $name" Obviously this is only valid if the variable is going to match what is in the data exactly.
- Paul
-Original Message-
From: Andr Sannerholt [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 30, 2003 6:49 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Optimize following Mysql-Query
Hi Everyone,
I have the following Mysql-Query that returns correct information, but it
just needs to much time (3-4 Minutes!!) Can you help me to optimize it?
$query=
"SELECT * FROM Firmennamen INNER JOIN Master ON Firmennamen.ID=Master.FN
WHERE Master.FN IN (SELECT Master.FN FROM Master INNER JOIN Personen ON
Master.NN=Personen.ID WHERE Personen.NAME LIKE '%$name%')";
$result = mysql_query($abfrage2) or die("Anfrage results fehlgeschlagen");
Regards
Andre Sannerholt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] another redirecting question
At some point you need to force users to upgrade. As designer/programmer, it's almost impossible to design solutions for every situation. Is it really worth the time and effort to modify code for a user using godforsaken OS with little known limited functionaily browser? I say no as do some other major sites like ESPN. http://devedge.netscape.com/viewsource/2003/espn-interview/01/ Development is a process. At one point, a decision has to be made as to the technical constraints of a site. In today's world it is completely realistic to force users to enable JavaScripting ... //ariel -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED] Sent: Friday, May 30, 2003 10:47 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] another redirecting question If the user has disabled JavaScript in the browser doesn't that create another problem? > -Original Message- > From: Griffiths, Daniel [mailto:[EMAIL PROTECTED] > Sent: Friday, May 30, 2003 10:44 AM > To: Rick Dahl; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] another redirecting question > > > use javascript for your redirects then you wont have these problems > > -Original Message- > From: Rick Dahl [mailto:[EMAIL PROTECTED] > Sent: 30 May 2003 15:43 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] another redirecting question > > > The scripts I need to run before I redirect automatically > send output to the browser. I cannot alter these scripts. > Is there a way around this? > > Rick > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] to all the people that lended a hand
to all the people that tried to lend a hand.
For some reason the javascripts didn't work.
There wasn't a need to get as complicated as session variables.
I ultimately figured out a way to do it by just moving { } around.
Rick
Re: [PHP-DB] another redirecting question
I'm very new to PHP so somebody correct me please if this is a bad idea... I had the same problem and I ended up just including the second page at the end of the first one: Grant On Fri, 2003-05-30 at 09:43, Rick Dahl wrote: > The scripts I need to run before I redirect automatically send output to the > browser. I cannot alter these scripts. Is there a way around this? > > Rick -- Grant Rutherford Iders Incorporated 600A Clifton Street Winnipeg, MB Canada R3G 2X6 http://www.iders.ca tel: 204-779-5400 ext 36 fax: 204-779-5444 This message is intended solely for the use of the designated recipient(s) and their appointed delegates, and may contain confidential information. Any unauthorized disclosure, copying or distribution of its contents is strictly prohibited. If you have received this message in error, please destroy it and advise the sender immediately by phone, email or facsimile. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] another redirecting question
Well, if you're inserting some data into a database and the person refreshes the page, it would re-insert the data again into the database. Including the page like you did at the end wouldn't change that fundamental problem, hence why you'd want to have it redirect to another page. Metin At 10:20 AM 5/30/2003 -0500, Grant Rutherford wrote: I'm very new to PHP so somebody correct me please if this is a bad idea... I had the same problem and I ended up just including the second page at the end of the first one: include 'nextpage.php'; die(); ?> Grant On Fri, 2003-05-30 at 09:43, Rick Dahl wrote: > The scripts I need to run before I redirect automatically send output to the browser. I cannot alter these scripts. Is there a way around this? > > Rick -- Grant Rutherford Iders Incorporated 600A Clifton Street Winnipeg, MB Canada R3G 2X6 http://www.iders.ca tel: 204-779-5400 ext 36 fax: 204-779-5444 This message is intended solely for the use of the designated recipient(s) and their appointed delegates, and may contain confidential information. Any unauthorized disclosure, copying or distribution of its contents is strictly prohibited. If you have received this message in error, please destroy it and advise the sender immediately by phone, email or facsimile. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] another redirecting question
Hi I did actually encounter that problem. However, wouldn't redirecting properly still allow the user to resubmit the information using the back button? I solved this problem a different way by setting and clearing session variables on entry and exit to a series of pages. Grant On Fri, 2003-05-30 at 10:25, Metin Kale wrote: > Well, if you're inserting some data into a database and the person > refreshes the page, it would re-insert the data again into the > database. Including the page like you did at the end wouldn't change that > fundamental problem, hence why you'd want to have it redirect to another page. > > Metin > > At 10:20 AM 5/30/2003 -0500, Grant Rutherford wrote: > >I'm very new to PHP so somebody correct me please if this is a bad > >idea... > > > >I had the same problem and I ended up just including the second page at > >the end of the first one: > > > > >// some stuff (output if necessary) > > > >include 'nextpage.php'; > >die(); > >?> > > > >Grant > > > > > >On Fri, 2003-05-30 at 09:43, Rick Dahl wrote: > > > The scripts I need to run before I redirect automatically send output > > to the browser. I cannot alter these scripts. Is there a way around this? > > > > > > Rick > >-- > >Grant Rutherford > >Iders Incorporated > >600A Clifton Street > >Winnipeg, MB Canada R3G 2X6 > >http://www.iders.ca > >tel: 204-779-5400 ext 36 > >fax: 204-779-5444 > > > >This message is intended solely for the use of the designated > >recipient(s) and their appointed delegates, and may contain > >confidential information. Any unauthorized disclosure, > >copying or distribution of its contents is strictly prohibited. > >If you have received this message in error, please destroy it > >and advise the sender immediately by phone, email or facsimile. > > > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MD5 hash problem
Hello list,
I am having a problem with MD5().
Every time I try to use this function it seems to work, but I get the
same results. Below is what I am trying to do.
$pass = MD5('$password');
For every password that I store in the database I have found it is the
same string of characters no matter what the original $password is.
$pass always = 243e61e9410a9f577d2d662c67025ee9
In other words, it looks like the MD5 function is working but not
correctly because it is calculating the hash, but is finding the same
hash for every string. Any help would be greatly appreciated.
I am new to the whole list process so if I do or say something wrong
please do not hate me.
Thanks,
Mike
Mike Calvelage
Webmaster / Sales Associate
Viper Systems
vipersystems.biz
[EMAIL PROTECTED]
419-224-8344
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MD5 hash problem
> For every password that I store in the database I have found it is the
> same string of characters no matter what the original $password is.
That is because you have single quotes around your variable so it is not
being expanded, so everytime it is the MD5 of the same thing, the string
$password.
> $pass = MD5('$password');
Change it to MD5($password); or MD5("$password");
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] hotornot functionality [resolved]
My apologies for the large email, but I wanted to include all the source code for
interested folks and thank everyone who provided suggestions for implementing "hot or
not"-like functionality.
Here is what I ended up doing. I've stripped out alot of the formatting to make it as
readable as possible, but it's a little messy. Tried to comment it to help you see
what is going on.
Basically, it builds a comma separated list of images that have been rated and using
"NOT IN" in the query, gets a random one that hasn't been seen yet.
Feel free to contact me off list if you want to see the beta page that implements this.
Matt
---
based on votes
You rated it:
';
}
?>
Start Over';
} else {
?>
Rate from 1 through 10 to see the next
picture
1
2
3
4
5
6
7
8
9
10
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] functions IN the database.
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hey all -
I'm curious if anybody has ever setup the logic to put php functions
into a database here is my thinkin on it, hopefully I can get some
suggestions on the benefits, downsides, etc.
(in mysql)
CREATE TABLE `functions` (`functionId` INT (5) UNSIGNED DEFAULT '0' NOT
NULL AUTO_INCREMENT,
`functionData` TEXT NOT
NULL,
`functionDesc` TEXT,
PRIMARY KEY(`functionId`), UNIQUE(`functionId`));
INSERT INTO functions(functionData, functionDesc)
VALUES('function echoNumber($number)
{ echo $number; }',
'This function echos out a given $number');
(in php)
$sql = "SELECT functionData
FROM functions";
$query = mysql_query($sql);
while($functionData = mysql_fetch_assoc($query)) {
eval $functionData[functionData];
};
This in theory **should initiate the given functions listed in the
functions table, has anybody used anything like this? I have a two sites
that I NEED to use the same functions and this is the first thing that
comes to mind, plus it would allow for gui editing of or creating
functions via a secured webpage.
Thanks on advance!
Rolf Brusletto
http://www.phpexamples.net
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] functions IN the database.
Forgive me if I'm overlooking something, but why not just use a class?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Rolf Brusletto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, 30 May, 2003 17:10
Subject: [PHP-DB] functions IN the database.
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hey all -
I'm curious if anybody has ever setup the logic to put php functions
into a database here is my thinkin on it, hopefully I can get some
suggestions on the benefits, downsides, etc.
(in mysql)
CREATE TABLE `functions` (`functionId` INT (5) UNSIGNED DEFAULT '0' NOT
NULL AUTO_INCREMENT,
`functionData` TEXT NOT
NULL,
`functionDesc` TEXT,
PRIMARY KEY(`functionId`), UNIQUE(`functionId`));
INSERT INTO functions(functionData, functionDesc)
VALUES('function echoNumber($number)
{ echo $number; }',
'This function echos out a given $number');
(in php)
$sql = "SELECT functionData
FROM functions";
$query = mysql_query($sql);
while($functionData = mysql_fetch_assoc($query)) {
eval $functionData[functionData];
};
This in theory **should initiate the given functions listed in the
functions table, has anybody used anything like this? I have a two sites
that I NEED to use the same functions and this is the first thing that
comes to mind, plus it would allow for gui editing of or creating
functions via a secured webpage.
Thanks on advance!
Rolf Brusletto
http://www.phpexamples.net
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] functions IN the database.
*This message was transferred with a trial version of CommuniGate(tm) Pro*
the sites will reside on different boxes. Thus needing a way to share
the functions. I'm trying to get away from having two sets of code that
do exactly the same thing.
Becoming Digital wrote:
Forgive me if I'm overlooking something, but why not just use a class?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Rolf Brusletto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, 30 May, 2003 17:10
Subject: [PHP-DB] functions IN the database.
Hey all -
I'm curious if anybody has ever setup the logic to put php functions
into a database here is my thinkin on it, hopefully I can get some
suggestions on the benefits, downsides, etc.
(in mysql)
CREATE TABLE `functions` (`functionId` INT (5) UNSIGNED DEFAULT '0' NOT
NULL AUTO_INCREMENT,
`functionData` TEXT NOT
NULL,
`functionDesc` TEXT,
PRIMARY KEY(`functionId`), UNIQUE(`functionId`));
INSERT INTO functions(functionData, functionDesc)
VALUES('function echoNumber($number)
{ echo $number; }',
'This function echos out a given $number');
(in php)
$sql = "SELECT functionData
FROM functions";
$query = mysql_query($sql);
while($functionData = mysql_fetch_assoc($query)) {
eval $functionData[functionData];
};
This in theory **should initiate the given functions listed in the
functions table, has anybody used anything like this? I have a two sites
that I NEED to use the same functions and this is the first thing that
comes to mind, plus it would allow for gui editing of or creating
functions via a secured webpage.
Thanks on advance!
Rolf Brusletto
http://www.phpexamples.net
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] formatting a timestamp
I want to print out a timestamp of length 14. I want to have it formatted like: mm-dd-yy : hh-mm I have looked but all I can find is how to format a date and I don't want that. I want the time also. Rick "Don't burn the day...away" ~ DJM _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] formatting a timestamp
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Rick,
You can use date() in the following fashion..
$timeStamp = time();
date('m-d-y : h-m', $timeStamp);
where $timestamp is a unix epoch timestamp.
Hope this helps!
Rolf Brusletto
http://www.phpexamples.net
Rick Dahl wrote:
*This message was transferred with a trial version of CommuniGate(tm)
Pro*
I want to print out a timestamp of length 14. I want to have it
formatted like:
mm-dd-yy : hh-mm
I have looked but all I can find is how to format a date and I don't
want that. I want the time also.
Rick
"Don't burn the day...away" ~ DJM
_
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP 4.2.1 and Oracle9i
Can anyone tell me whether PHP 4.x will continue to operate with Oracle9i using the PHP OCI calls? I understand that PHP may have to be recompiled again for Oracle9i. [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Make postnuke connect to two databases
Greeting, I have a postnuke site and I want to connect it to two databases in order to verify users from these databases. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: PHP 4.2.1 and Oracle9i
Hi Robert Yes oci8 functions work fine with Oracle9i. "Robert Varner" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Can anyone tell me whether PHP 4.x will continue to operate with Oracle9i > using the PHP OCI calls? I understand that PHP may have to be recompiled > again for Oracle9i. > > [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysqldump
hi, i want to backup mysql database. i use mysqldump command . when i use this command from server (win2000) , command promt its work fine. but when run this command (mysqldump) from php file, it creat backup file but with zero size. what can i do , help me? thanks, zuhear -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
