[PHP-DB] To many connections error

2003-07-28 Thread Merlin
Hello everybody, I am running a community portal with LAMP . So far everything was running fine. This night the site went down for a few hours. The error message from mysql was "to many connections". Is there a way to increase the number of allowed connections, or do I have a hardware problem here

Re: [PHP-DB] hi (php-SSH)

2003-07-28 Thread otherguy
On Monday, July 28, 2003, at 10:19 PM, David Smith wrote: Suman Aluru wrote: hi , is there any way to write a PHP program for SSH. I want to establish a SSH connection and work some commands in the remote system and close the connection. Yes, just do this (uses an SSH key file): "; echo `

Re: [PHP-DB] hi (php-SSH)

2003-07-28 Thread David Smith
Suman Aluru wrote: hi , is there any way to write a PHP program for SSH. I want to establish a SSH connection and work some commands in the remote system and close the connection. Yes, just do this (uses an SSH key file): "; echo `ssh -i /path/to/key/file [EMAIL PROTECTED] ls /tmp`; echo

[PHP-DB] Old dbase 2 or 3 conversion

2003-07-28 Thread Bogdan Albei
As I know PHP creates dbase 4 files. How is it possible to create or at least convert to dbase 2 or 3? Also, PHP creates read-only dbase files(read-only from Fox's perspective, not -r) that cannot be modified with Fox. Can I create non read-only files? I know that no normal people use dbase toda

Re: [PHP-DB] Bar codes in PHP

2003-07-28 Thread Norma Ramirez - TECNOSOFT
Thank´s Brad, that sounds simple, I gonna try and later I´ll tell the results. =) Norma Ramirez Area de Desarrollo Web -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PEAR::DB question

2003-07-28 Thread Jacob Marble
Hello- I'm using the fetch method to get a result set. ie- $sql = "select id,name from sr_names order by name"; $result = $db->query($sql); while ( $row = $result->fetchRow(DB_FETCHMODE_ASSOC) ) echo $row['id'] . ' ' . $row['name'] . ""; This works great! Now, I want to _re-use_ thi

Re: [PHP-DB] un-encrypting passwords

2003-07-28 Thread CPT John W. Holmes
From: "Matt Schroebel" <[EMAIL PROTECTED]> > > 1. Make up a random new password, PASSWORD() it, save it to the db while > also setting the password expiration date to 20 minutes in the future, > and setting a 'must change password flag', and mail the un-encrypted > password along with a link to ch

Re: [PHP-DB] un-encrypting passwords

2003-07-28 Thread Sam Folk-Williams
Thank you! These are some great ideas. Sam "Brad Bonkoski" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Typically in these systems you do not send them their password un-encrypted if > they lose it because like you said, it is one way. Normally, you collect > certain information

RE: [PHP-DB] un-encrypting passwords

2003-07-28 Thread Matt Schroebel
1. Make up a random new password, PASSWORD() it, save it to the db while also setting the password expiration date to 20 minutes in the future, and setting a 'must change password flag', and mail the un-encrypted password along with a link to change it. 2. Each time the visitor signons, check the

Re: [PHP-DB] imagetypes( ) function

2003-07-28 Thread dpgirago
thanks, I was gonna repost to let everyone know that I was being a dummy because I hadn't indicated in php.ini where the extensions directory was located. I added the path, and uncommented the <>, and all is ok in php-land. Thanks, again [EMAIL PROTECTED] on 07/28/2003 03:03:41 PM To:

RE: [PHP-DB] un-encrypting passwords

2003-07-28 Thread Peter Lovatt
mysql has ENCRYPT() which will do the job Peter -Original Message- From: Sam Folk-Williams [mailto:[EMAIL PROTECTED] Sent: 28 July 2003 21:05 To: [EMAIL PROTECTED] Subject: [PHP-DB] un-encrypting passwords Hi, I've got a PHP/MySQL site that uses a simple user table to check for a valid

Re: [PHP-DB] un-encrypting passwords

2003-07-28 Thread Brad Bonkoski
Typically in these systems you do not send them their password un-encrypted if they lose it because like you said, it is one way. Normally, you collect certain information to validate them, and then generate a new password to email them, so they can get it and once again reset their password if th

[PHP-DB] un-encrypting passwords

2003-07-28 Thread Sam Folk-Williams
Hi, I've got a PHP/MySQL site that uses a simple user table to check for a valid username/password match when logging someone in. I encrypted the passwords using mysql's PASSWORD() function. I now realize that was probably not the best choice, because I don't think it's possible to un-encrypt them

Re: [PHP-DB] imagetypes( ) function

2003-07-28 Thread Matthew
php_gd2.dll probably needs to be copied from your php install directory to your windows system directory (so that it is in the path thingy). On my system that translated to : copy c:\php\extensions\php_gd2.dll to c:\WINNT\php_gd2.dll for more information see, http://www.php.net/manual/en/insta

Re: [PHP-DB] hi (php-SSH)

2003-07-28 Thread Brad Bonkoski
Well, SSH has a server which woudl answer your requests and a lient to initiate the session, I'm assuming you wish to emulate the client side to initiate the session, of course PHP is a server side language, so it's not adding up. I have seen a JAVA applet that will open in a web browser on the cl

[PHP-DB] hi (php-SSH)

2003-07-28 Thread Suman Aluru
hi , is there any way to write a PHP program for SSH. I want to establish a SSH connection and work some commands in the remote system and close the connection. Thank You. -- Suman R Aluru System Administrator Bacterial Barcodes Inc. 8080 N.Stadium Dr. Houston TX-77054 713.467.8500 (Off.) 832

RE: [PHP-DB] Bar codes in PHP

2003-07-28 Thread Matt Schroebel
> From: Norma Ramirez - TECNOSOFT > [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2003 3:20 PM > > > Hi all, does someone know how to capture or read bar codes > from php? It will be great if I could do inputs to my > database directly from bar codes in the products. Ideas??? I think yo

Re: [PHP-DB] Bar codes in PHP

2003-07-28 Thread Brad Bonkoski
"CPT John W. Holmes" wrote: > PHP wouldn't have anything to do with it. Your barcode should "fill in" a > text area on a web page, which is the submitted to a PHP file for > processing. You'll need something client site to get the code from the > scanner to the web page. You wouldn't really nee

Re: [PHP-DB] sending data through FTP in PHP

2003-07-28 Thread Colbey
Yea.. mark is right on.. that is NOT FTP RFC compliant.. use socket functions to create a compatible server/client gateway... On Mon, 28 Jul 2003, OpenSource wrote: > I'm given the IP and port to connect to. > I will then send my username and password in this format: > username|version\n >

Re: [PHP-DB] Bar codes in PHP

2003-07-28 Thread CPT John W. Holmes
PHP wouldn't have anything to do with it. Your barcode should "fill in" a text area on a web page, which is the submitted to a PHP file for processing. You'll need something client site to get the code from the scanner to the web page. Unless you're talking about a program that acutally monitors t

[PHP-DB] Bar codes in PHP

2003-07-28 Thread Norma Ramirez - TECNOSOFT
Hi all, does someone know how to capture or read bar codes from php? It will be great if I could do inputs to my database directly from bar codes in the products. Ideas??? Thank´s Norma Ramirez Area de Desarrollo Web [EMAIL PROTECTED]

Re: [PHP-DB] sending data through FTP in PHP

2003-07-28 Thread Mark
In that case, you might want to look into the socket functions of php. --- OpenSource <[EMAIL PROTECTED]> wrote: > I'm given the IP and port to connect to. > I will then send my username and password in this format: > username|version\n > password\ > the version number is just 4 characters

Re: [PHP-DB] sending data through FTP in PHP

2003-07-28 Thread OpenSource
I'm given the IP and port to connect to. I will then send my username and password in this format: username|version\n password\ the version number is just 4 characters of the program eg. "1.00" I must then wait for a byte: '0' - valid '1' - invalid then I am to send the data as eg.

Re: [PHP-DB] sending data through FTP in PHP

2003-07-28 Thread colbey
FTP is used to tranfer files, typically not "an array of data".. Depending what you mean.. From the sounds of things you need a protocol gateway instead of using FTP.. Unless you are loading that array of data into a file on the remote server at which point something will slurp it up and wait f

[PHP-DB] sending data through FTP in PHP

2003-07-28 Thread OpenSource
Hey Guys, I need some assistance on this FTP stuff. I've got an array of data that I need to send via ftp to another server eg. $linea = array($sport.$rot1.$r_vl); This information is gotten from my database and needs to be sent to the other server every 5 seconds. I need to connect to the serv

Re: [PHP-DB] MySQL Date insert

2003-07-28 Thread Andrew D. Luebke
John, thanks, now I feel stupid, it's always the silly little things that get you. You were right, when I added the date to the existing insert I forgot to put the ending parentheses back in. Thanks for the help. Andrew. At 11:26 AM 7/28/2003, CPT John W. Holmes wrote: From: "Andrew D. Luebke

Re: [PHP-DB] MySQL Date insert

2003-07-28 Thread CPT John W. Holmes
From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]> > I actually think I know part of this answer... I don't think you > need to define a variable to insert into your "date" field. Inserting an > empty value into this filed will populate the field in the database with the > current time, which it a

Re: [PHP-DB] MySQL Date insert

2003-07-28 Thread michele.petrovsky
Andrew, try this: $date = date('Y m d H i s'); A similar syntax (with single quotes rather than double, and without intervening dashes) has worked for me in some MySQL-related PHP code I've just written. My code looked like this: $title2 = "\n".date('l F d Y')."\n"; Michele Petrovsky

Re: [PHP-DB] MySQL Date insert

2003-07-28 Thread jeffrey_n_Dyke
i have a feeling oyu're not getting a mysql error but a PHP error??? you have an odd number of parentheses and mysql_error will not have an closing paren. if that is the case, try this mysql_query("INSERT INTO Boats (Make, Model, Serial,Stock, Extension, Cust_Name, Store, Date) VALUES ('$mak

RE: [PHP-DB] MySQL Date insert

2003-07-28 Thread NIPP, SCOTT V (SBCSI)
I actually think I know part of this answer... I don't think you need to define a variable to insert into your "date" field. Inserting an empty value into this filed will populate the field in the database with the current time, which it appears from your code is what you are trying to do

Re: [PHP-DB] MySQL Date insert

2003-07-28 Thread CPT John W. Holmes
From: "Andrew D. Luebke" <[EMAIL PROTECTED]> > $date = date("Y-m-d H:i:s"); > $result = mysql_query("INSERT INTO Boats (Make, Model, Serial, > Stock, Extension, Cust_Name, Store, Date) VALUES > ('$make', '$model', '$serial', '$stock', '$extension', > '$name', '$st

RE: [PHP-DB] MySQL Date insert

2003-07-28 Thread Andrew D. Luebke
Nope, changed the insert to: $result = mysql_query("INSERT INTO Boats (Make, Model, Serial, Stock, Extension, Cust_Name, Store, Insert_Date) VALUES ('$make', '$model', '$serial', '$stock', '$extension', '$name', '$store', '$date'") or die("Invalid query: "

RE: [PHP-DB] MySQL Date insert

2003-07-28 Thread Hutchins, Richard
Don't know about your date format, but you have named your table column DATE which is a reserved keyword in MySQL. Try naming that something different and see if you still get the error. > -Original Message- > From: Andrew D. Luebke [mailto:[EMAIL PROTECTED] > Sent: Monday, July 28, 2003 2

[PHP-DB] MySQL Date insert

2003-07-28 Thread Andrew D. Luebke
Hello, I have the following PHP code: $date = date("Y-m-d H:i:s"); $result = mysql_query("INSERT INTO Boats (Make, Model, Serial, Stock, Extension, Cust_Name, Store, Date) VALUES ('$make', '$model', '$serial', '$stock', '$extension', '$name', '$store', '$date'")

[PHP-DB] PEAR DB

2003-07-28 Thread Jacob Marble
Hey all- Before I ask my question, is there a more appropriate NG for PEAR::DB related questions? It always bugs to have off-topic posts... Thanks, Jake LandEZ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] imagetypes( ) function

2003-07-28 Thread dpgirago
Ah, you know, when I removed the semi-colon and restarted apache, I got an error saying that the module couldn't be found or started... Wonder why it is not available. I downloaded PHP 4.3.2 php.net just last week. BTW, I'm on Win 2k, also. Any ideas? [EMAIL PROTECTED] on 07/28/2003 11:17

Re: [PHP-DB] imagetypes( ) function

2003-07-28 Thread Matthew
I'm running php 4.3.0 on windows 2000. The following code woks : Producing the following output : PNG Support is enabled The manual suggests that the imagetypes() function has been available since php 4.0.2. But, quoting from the manual "This function returns a bit-field corresponding to the i

[PHP-DB] imagetypes( ) function

2003-07-28 Thread dpgirago
Good day all, Anyone have an idea why I receive a "call to undefined function" error message when I use the imagetypes() function on PHP versions 4.2.3 and 4.3.2 ?? The code to test for PNG image handling is right from the manual... David -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC

2003-07-28 Thread Jason Wong
On Monday 28 July 2003 19:46, Nabil wrote: > these are not working because i need to connect ro Micro$oft SQL server 7 > NOT to mysql nor postgresql *sigh* They were meant to be examples of what *I* have. That's why you have to read the docs and see what needs to be done to use MSSQL. -- Jaso

Re: [PHP-DB] ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC

2003-07-28 Thread Nabil
these are not working because i need to connect ro Micro$oft SQL server 7 NOT to mysql nor postgresql "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Monday 28 July 2003 18:13, Nabil wrote: > > > Please Jason help me to do this The sql server is on 192.168.0.10

Re: [PHP-DB] Problem with $_SERVER['HTTP_REFERER']

2003-07-28 Thread jeffrey_n_Dyke
is it possible that there is no referer. what happens if you link to this page from another, ensuring there is a referer, will it display it then? Jeff

[PHP-DB] Problem with $_SERVER['HTTP_REFERER']

2003-07-28 Thread Sugeng Utomo
Dear all, I have just got a problem with $_SERVER['HTTP_REFERER']; , I try to echo this like below : Then I open up in browser , and I got an error : "Notice: Undefined index: HTTP_REFERER in d:\referer.php on line 2" I use Windows 2000 Professional , Apache 1.3.27 and PHP 4.3.2

Re: [PHP-DB] ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC

2003-07-28 Thread Jason Wong
On Monday 28 July 2003 18:13, Nabil wrote: > Please Jason help me to do this The sql server is on 192.168.0.101 IP > address. > > Please give me a sample of how can i config these files : "/etc/odbc.ini" > &"/etc/odbcinst.ini" As an example my /etc/odbc.ini contains: [MySQL-test] Descri

Re: [PHP-DB] ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC

2003-07-28 Thread Nabil
Hi Jason; i appreciate your help always ... Please Jason help me to do this The sql server is on 192.168.0.101 IP address. Please give me a sample of how can i config these files : "/etc/odbc.ini" &"/etc/odbcinst.ini" Should i add any entry to freetds.conf ... and can you tell me what is

Re: [PHP-DB] ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC

2003-07-28 Thread Jason Wong
On Monday 28 July 2003 16:38, Nabil wrote: > I have been trying so hard to get that done.. and i posted many here. but > with no hope.. here is a summury of what i did: > > - I tried FreeTDS as a driver with unixODBC ... > - Tried to remove mysql- apache - php and recomplied them with : iodbc > -

[PHP-DB] ANYONE KNOWS, can help me to link Linux to MS SQLserver 7 by ODBC

2003-07-28 Thread Nabil
Hiya all; I have been trying so hard to get that done.. and i posted many here. but with no hope.. here is a summury of what i did: - I tried FreeTDS as a driver with unixODBC ... - Tried to remove mysql- apache - php and recomplied them with : iodbc - Tried to try openlink driver. - tried to upg