[PHP-DB] mysqldump

2003-05-31 Thread buttoz
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 M

[PHP-DB] Re: PHP 4.2.1 and Oracle9i

2003-05-31 Thread John Lim
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 Ora

[PHP-DB] Make postnuke connect to two databases

2003-05-31 Thread Louai
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] PHP 4.2.1 and Oracle9i

2003-05-31 Thread Robert Varner
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

Re: [PHP-DB] formatting a timestamp

2003-05-31 Thread Rolf Brusletto
*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 wr

[PHP-DB] formatting a timestamp

2003-05-31 Thread Rick Dahl
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 __

Re: [PHP-DB] functions IN the database.

2003-05-31 Thread Rolf Brusletto
*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 overlooki

Re: [PHP-DB] functions IN the database.

2003-05-31 Thread Becoming Digital
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 datab

[PHP-DB] functions IN the database.

2003-05-31 Thread Rolf Brusletto
*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 `

RE: [PHP-DB] hotornot functionality [resolved]

2003-05-31 Thread Matthew Horn
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 pos

RE: [PHP-DB] MD5 hash problem

2003-05-31 Thread Jennifer Goodie
> 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

[PHP-DB] MD5 hash problem

2003-05-31 Thread mike
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 n

Re: [PHP-DB] another redirecting question

2003-05-31 Thread Grant Rutherford
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-0

Re: [PHP-DB] another redirecting question

2003-05-31 Thread Metin Kale
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 1

Re: [PHP-DB] another redirecting question

2003-05-31 Thread Grant Rutherford
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 out

[PHP-DB] to all the people that lended a hand

2003-05-31 Thread Rick Dahl
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

2003-05-31 Thread Ovaltine
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 m

RE: [PHP-DB] Optimize following Mysql-Query

2003-05-31 Thread Vaughn, Paul
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

RE: [PHP-DB] another redirecting question

2003-05-31 Thread Metin Kale
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 i

RE: [PHP-DB] another redirecting question

2003-05-31 Thread Griffiths, Daniel
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, Ri

Re: [PHP-DB] another redirecting question

2003-05-31 Thread CPT John W. Holmes
> 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.n

RE: [PHP-DB] another redirecting question

2003-05-31 Thread Hutchins, Richard
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 >

RE: [PHP-DB] another redirecting question

2003-05-31 Thread Griffiths, Daniel
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 out

[PHP-DB] another redirecting question

2003-05-31 Thread Rick Dahl
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] redirecting to a page

2003-05-31 Thread Ronan Chilvers
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 Chilv

RE: [PHP-DB] redirecting to a page

2003-05-31 Thread Matthew Horn
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);

RE: [PHP-DB] redirecting to a page

2003-05-31 Thread Hutchins, Richard
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. > >

[PHP-DB] redirecting to a page

2003-05-31 Thread Rick Dahl
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