RE: [PHP] MySQL connection
Hey Youri,
Could you let us know what file extension you use for
you php files? And give us the exact code/error
message you get on screen. Of course you can hide your
username/pass with x.
Thanks
Bjorn Van Simaeys
www.bvsenterprises.com
--- Matthew Loff [EMAIL PROTECTED] wrote:
How exactly is the username/password from the
mysql_connect() call shown
to the browser?
I normally just get a PHP error when the db
connection can't be made.
No code is shown, just a line number. If, in your
case, PHP dumps the
source code to the browser window when the db
connection won't work,
then something has to be wrong. :)
--Matt
-Original Message-
From: BRACK [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 09, 2001 5:57 AM
To: Attila Strauss
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL connection
I have tested again what I said yesterday and found
that if I have
problems in PHP support in Apache then all my
information
(username and password) are seing simly on the
screen, so it's not
about dead SQL server but PHP.
However, I went through all docs that I have on this
topic and found
that the only solution of this is to put included
connect.php/inc
outside of htdocs directory and configure your
php.ini such a way
that one outsider directory would be accepted and
only by php call.
Hope I didn't mess up this time so you are able to
understand what
I mean... =))
Thank you for the help anyway, just be aware of
this PHP prob
when you pick up provider.
Youri
On 8 Aug 2001, at 19:33, Attila Strauss wrote:
hi,
there are 2 ways.
1. you hardcore the user/password in the php.ini
file.
2. u do a simply error checking like :
?php
$connect = mysql_connect($host, $user, $pass);
if(!$connect)
{
print connection failed;
}
?
of course you could also do like kinda
header(Location:
http://host;); instead of print connection
failed.
i hope i could help you.
best regards
attila strauss
Hey Jouri,
I don't agree with this one. I tested it out on
my localhost and got
the two error messages I told you I was going to
get:
Warning: Unknown MySQL Server Host...
Warning: MySQL Connection Failed...
No usernames/passwords. I have to say however
that I
always include my connect.php file. Maybe that's
a
secure way to connect without anyone seeing your
password in case of sqlserver problems.
Greetz,
Bjorn Van Simaeys
www.bvsenterprises.com
--- BRACK [EMAIL PROTECTED] wrote:
If you have Apache and MySQL servers make this
experiment -
start Apache but forget to start SQL and go
to
your site
http://localhost/... you will see yourself all
the
information on the
screen.
Youri
On 7 Aug 2001, at 12:53, Ryan Christensen
wrote:
I'm curious as to how the hacker would see
all
this information (the
username.. password, etc..) just by going to
a
site where the SQL backend
was down?
Ryan
-Original Message-
From: BRACK [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 12:36 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL connection
I just wanned to bring the issue of
security of
MySQL connection:
Let us imagine that SQL server was down
for some
hours (of
course without us knowing it) and at the
same
hours our SQL site
was visited by some kind of hacker, he can
s
ee
on his screen all
our SQL connection info like username,
password, and database
name. You may hide this information in
different
file than the file
that your users open then the hacker will
see
something like
include(connect.inc); or
require(connect.inc); (of course IF
server is down). So you may only imagine
the
consequences of
this visit of the hacker. What can we do
to
protect our sensitive
information if SQL server is down?
Youri
--
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]
=== message truncated ===
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
Re: [PHP] Bug?
Hello, I remember there was a warning in the PHP Manual about this. This is it: ** Never cast an unknown fraction to integer, as this can sometimes lead to unexpected results. ** echo (int) ( (0.1+0.7) * 10 ); // echoes 7! So do your calculations first, and then echo the results. This way you get good habits in programming. And your code will be easier to read as well! Greetz, Bjorn Van Simaeys www.bvsenterprises.com --- [Intent A/S] Tais M. Hansen [EMAIL PROTECTED] wrote: Hi! I just came across this weird thing. Bug? You tell me! print (int)((8.85-8)*100); I would think the line above would print 85. But for some reason, it prints 84?? Can anyone tell me why that is? -- Intent A/S Tais M. Hansen Web Developer -- 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] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- 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] checking for null form fields fails
Hey Renze, Don't you think that checking too much is useless and takes a bite out of your performance too? Don't waste your time. Greetz, Bjorn Van Simaeys www.bvsenterprises.com --- Renze Munnik [EMAIL PROTECTED] wrote: On Tue, Aug 07, 2001 at 09:26:48AM -0700, Mark Maggelet wrote: This isn't right, empty() won't give an error if $input isn't set. That's true. Empty() doesn't return an error when $input isn't defined. I didn't RT(F)M on this one. I always use (!isset($something) empty($something)) to check whether or not $something is empty/not set. It's realy more of a feeling. Empty() actualy only checks for a value in $something. It's basicaly the same as (!$something) except that empty() doesn't return a warning if $something isn't set (...look, this time I did RTM :). So... basicaly, with empty() you don't check if $something is set. You just don't get to know it. So that's why I use isset() with it. I know the result is the same, but hey... I'm the same guy that checks the returnvalue of printf() and stuff (another thread in this list). So... well... Let's just say I have a 'checking-fetish' of some kind :p -- * RzE: -- -- Renze Munnik -- DataLink BV -- -- E: [EMAIL PROTECTED] -- W: +31 23 5326162 -- F: +31 23 5322144 -- M: +31 6 21811143 -- H: +31 23 5516190 -- -- Stationsplein 82 -- 2011 LM HAARLEM -- -- http://www.datalink.nl -- -- 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] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- 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: blank form
Hi David, This is indeed not a php problem, but a browser feature. The browser forces a reload whenever you have a '?' in your code! (unless you use some proxy..). I would also like to know how to overcome this - if possible. Greetz, Bjorn Van Simaeys --- David Ovens [EMAIL PROTECTED] wrote: oops sorry, dont think it was a php problem but a problem with my browser !! - Original Message - From: David Ovens To: php Sent: Wednesday, August 08, 2001 10:56 AM Subject: blank form in my php scripts I am using forms which are posted to itself, each time fields are submitted the php scripts checks the syntax before moving onto the next part of the form, if there is an error the script will tell the user that there is an error and to use the back button to correct the form, problem is when you press the back button the form is blank. how do I overcome this by keeping the original details in the form especially when using drop down menu options ?? __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- 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 connection
Hey Jouri, I don't agree with this one. I tested it out on my localhost and got the two error messages I told you I was going to get: Warning: Unknown MySQL Server Host... Warning: MySQL Connection Failed... No usernames/passwords. I have to say however that I always include my connect.php file. Maybe that's a secure way to connect without anyone seeing your password in case of sqlserver problems. Greetz, Bjorn Van Simaeys www.bvsenterprises.com --- BRACK [EMAIL PROTECTED] wrote: If you have Apache and MySQL servers make this experiment - start Apache but forget to start SQL and go to your site http://localhost/... you will see yourself all the information on the screen. Youri On 7 Aug 2001, at 12:53, Ryan Christensen wrote: I'm curious as to how the hacker would see all this information (the username.. password, etc..) just by going to a site where the SQL backend was down? Ryan -Original Message- From: BRACK [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 12:36 PM To: [EMAIL PROTECTED] Subject: [PHP] MySQL connection I just wanned to bring the issue of security of MySQL connection: Let us imagine that SQL server was down for some hours (of course without us knowing it) and at the same hours our SQL site was visited by some kind of hacker, he can see on his screen all our SQL connection info like username, password, and database name. You may hide this information in different file than the file that your users open then the hacker will see something like include(connect.inc); or require(connect.inc); (of course IF server is down). So you may only imagine the consequences of this visit of the hacker. What can we do to protect our sensitive information if SQL server is down? Youri -- 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] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- 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] Session problem
Maybe you have your cookies turned off in your browser? Something that is easily forgotten.. Greetz, Bjorn Van Simaeys www.bvsenterprises.com --- Chad Day [EMAIL PROTECTED] wrote: Nope. Same problem. I'm seriously thinking there's a bug in the version of PHP I am running at this point, but I searched php.net and found no mention of anything .. Chad -Original Message- From: Brian Dunworth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 10:37 AM To: [EMAIL PROTECTED] Cc: 'Chad Day' Subject: RE: [PHP] Session problem On Wednesday, August 08, 2001 at 9:16 AM, Chad Day said: I wish it did. Still the same problem. ?php session_start(); global $count; session_register (count); $count++; ? Hello visitor, you have seen this page ?php echo $HTTP_SESSION_VARS[count]; ? times.p You're asking the session to remember a value ( session_register() ), then changing that value ( $count++ ) and not re-registering it, then complaining when the session returns the value you asked it to remember. What if you did: ?php session_start(); $count++; session_register (count); ? - Brian --- Brian S. Dunworth Sr. Software Development Engineer Oracle Database Administrator The Printing House, Ltd. (850) 875-1500 x225 --- -- 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] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- 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] array + checkbox
Hey Colin,
You will need some javascript to handle the checkbox'
onchange event because when the user clicks the
checkbox off and back on, the value will be 'on' - and
your if-condition will not work!
Greetz,
Bjorn Van Simaeys
www.bvsenterprises.com
--- Colin Viebrock [EMAIL PROTECTED] wrote:
If( strcmp($voorraad[1],'on') == 0 )
// it's checked
else
// it's not
Alternatively, fix your HTML by using quotes and a
value attribute:
INPUT TYPE=checkbox name=voorraad
value=something checked
Then:
if ($voorraad=='something') {
// checked
}
- Colin
--
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]
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
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] last modification time
Hey, This is not what BRACK a.k.a. Youri meant (it seems that Youri is being misunderstood daily...) He meant that if you can see when the remote server pages have been updated by their respective webmaster. I personally don't think that there is a way you can get this information from *ANOTHER SERVER*. But I hope I have clarified Youri's question once again. Greetz, Bjorn Van Simaeys www.bvsenterprises.com *** Efficient Communication starts by LISTENING! *** --- Matt Kaufman [EMAIL PROTECTED] wrote: What I do is put a timestamp in the database, using the time(); function, select it and format it. Matt Kaufman - Original Message - From: BRACK [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 1:40 PM Subject: [PHP] last modification time Is there any function that can fetch a time of last modification of the remote document. For example I have a links based on the MySQL database, and I want to know what linked site was most resently renewed. Thank you Youri -- 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] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- 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: PHP in corporate settings?
That's right. I have been working for a large computer company (2800 people), and my project manager had never even heard about PHP and such. Bjorn Van Simaeys --- Inércia Sensorial [EMAIL PROTECTED] wrote: I don't think the problem is the open source nature. Corporate people usually do not see flaws on it. But they do not see the advantages too because there is little advertising. -- Julio Nobrega. 2B||!BB - That's the question. Jeff Lewis [EMAIL PROTECTED] wrote in message 00dd01c1203b$60d62210$76a1a8c0@LEWISJCIT">news:00dd01c1203b$60d62210$76a1a8c0@LEWISJCIT... I still rarely ever see PHP mentioned in job listings and the like. Especially here in Canada I find it very hard to find any kinds of contacts for companies using PHP. My previous employer that I was with for 3+ years insisted on Micro$oft products and wanted to go with ASP. My current employer, a HUGE media/newspaper in Ontario goes with strictly Java. Is it that people still are hesitant to go wth open source based technology? Jeff Lewis -- 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] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- 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] last modification time
For your information... --- The http header contains the modification date: Last-Modified: Tue, 26 Jun 2001 03:46:20 GMT do this, telnet www.somehost.com 80 wait till it does this: Trying 203.52.23.1... Connected to www.somehost.com. then type this: HEAD /path/to/file/or/directory/ HTTP/1.0 (hit enter twice) enjoy Twigman... On 2001.08.09 08:01 Bjorn Van Simaeys wrote: Hey, This is not what BRACK a.k.a. Youri meant (it seems that Youri is being misunderstood daily...) He meant that if you can see when the remote server pages have been updated by their respective webmaster. I personally don't think that there is a way you can get this information from *ANOTHER SERVER*. But I hope I have clarified Youri's question once again. Greetz, Bjorn Van Simaeys www.bvsenterprises.com *** Efficient Communication starts by LISTENING! *** --- Matt Kaufman [EMAIL PROTECTED] wrote: What I do is put a timestamp in the database, using the time(); function, select it and format it. Matt Kaufman - Original Message - From: BRACK [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 1:40 PM Subject: [PHP] last modification time Is there any function that can fetch a time of last modification of the remote document. For example I have a links based on the MySQL database, and I want to know what linked site was most resently renewed. Thank you Youri __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- 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] Upper or Lower Case
I must agree with Don that strcasecmp is the best way
to go. Combined with the 'trim' function this is
completely foolproof.
Thanks, Don!
Bjorn Van Simaeys
www.bvsenterprises.com
--- Don Read [EMAIL PROTECTED] wrote:
On 07-Aug-2001 Bjorn Van Simaeys wrote:
Hi,
I have run accross this problem too, and I solve
it
this way:
if(strtolower($name1) == strtolower($name2))
I compare both variables in lower case, this way
capitals don't matter at all.
if (0 == strcasecmp('neo', $name)) // why didn't
the call this stricmp ?
echo 'matched';
if eregi('^neo$', $name)
echo 'matched also';
Regards,
--
Don Read
[EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you
are going to
steal the neighbor's newspaper, that's the time
to do it.
--
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]
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
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] WDDX recordset data
You can find nice documentation for all WDDX functions on php.net: http://www.php.net/manual/en/ref.wddx.php Greetz, Bjorn Van Simaeys www.bvsenterprises.com --- Vikram Vaswani [EMAIL PROTECTED] wrote: Can anyone point me to a resource which explains how to iterate through WDDX recordsets with PHP? Thanks! Vikram -- I wouldn't recommend sex, drugs, and insanity for everyone, but it works for me. -- 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] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- 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] Help me please.(Running stand-alone php)
Miguel, I see that your script has the extension .html Rename that file to .php and it normally should work. Greetz, Bjorn Van Simaeys www.bvsenterprises.com --- miguel valero [EMAIL PROTECTED] wrote: Unfortunately the -q parameter didn't fix the problem. Is anybody in the PHP mailing list that is familiar with this kind of problem and can tell me how to get rid of the path line in the browser output? Any help will be greatly appreciated. Thanks. --- mike cullerton [EMAIL PROTECTED] wrote: try the -q parameter. i'm guessing here, since i don't run windows nor the cgi version of php. :) on 8/7/01 8:27 AM, miguel valero at [EMAIL PROTECTED] wrote: Mike, I running the scrip from the browser (http://localhost/cgi-bin/test.html) When I comment the first line in the script (#-#!c:\php\php.exe) I get the following error message: Tue Aug 07 09:56:13 2001] [error] [client 127.0.0.1] c:/program files/apache group/apache/cgi-bin/test.php is not executable; ensure interpreted scripts have #! first line I can not run the script w/o the line #!c:\php\php.exe at the top of the script. How can I get rid of the path line on the browser output ? Thanks --- mike cullerton [EMAIL PROTECTED] wrote: i'm not sure i understand how you are running this... if it is a file you are running at the command line, try -q after the php.exe statement. if this is a web page, comment that line out. hope this helps, mike on 8/6/01 1:16 PM, miguel valero at [EMAIL PROTECTED] wrote: When I run the following script under an stand-alone php 4.0.6 and Apache 1.3 (Win95/98), the path to PHP (#!c:\php\php.exe) will show up on the first line of the browser output. #!c:\php\php.exe ?php phpinfo(); ? Is there a way to fix this? How can I get rid of the path line, on the top of the page, on the browser output? Any help will be greatly appreciated. My apologies if this has been covered before, or if this is in the manual, but I couldn't see it thanks. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- 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] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- 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] close browser
Hi, Yes, Javascript can do this. Look at this: script type=text/javascript this.window.close(); /script You can wrap this in a A HREF... tag as well. Greetz, Bjorn Van Simaeys www.bvsenterprises.com --- Jeremy Morano [EMAIL PROTECTED] wrote: Hi, Can anybody tell me what the code to close the browser is? -- 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] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- 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 date converting
Hi, You could write a PHP script to get all the current values (I presume that you've put varchar as datatype), parse them with string functions and convert it in the way you'd like them to be. All this is not so difficult to make. I prefer to store my date/times in the UNIX timestamp form. I use an int(10) field in mySQL database (int(10) means an integer with 10 digits, this way I can store more than 331 years!). This is easy to sort and to calculate with too. In your development you can use this timestamp and format it in any way you want it using the date() function. You'll find all references in the php.net manual. Greetz, Bjorn Van Simaeys www.bvsenterprises.com --- Christopher CM Allen [EMAIL PROTECTED] wrote: Greetings: I have a field entry in a MYQSL table that stores the date as: August 02, 2001 :( Is there anyway to convert this to 08-02-2001 outside of the table via php? Better yet is there ayway I can go back into my table and change these dates into a better format for computation? -- 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] __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- 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]
