[PHP-DB] Re: Date formats from Postgres

2001-05-10 Thread Micah Woods
Sean, here's a php function that returns a formatted date. This currently returns a US formatted date but you can easily change it to Australian. // convert timestamp to date for display. function displayDate($timeStamp, $separator="/", $leading="f") { $arr = explode("-", $timeStamp); if

Re: [PHP-DB] connection to Oracle 7.3 with ora_logon()

2001-05-10 Thread Sheeta
Dear, Sorry, I also have the same probelm... On my php.ini, I can't find the php_oci8.dll and php_oracle.dll... where I can find it?? Please help?! Sheeta ""Philippe Saladin"" <[EMAIL PROTECTED]> wrote in message 9darfc$fvs$[EMAIL PROTECTED]">news:9darfc$fvs$[EMAIL PROTECTED]... > Thanks to Ra

[PHP-DB] Backup Database

2001-05-10 Thread Jennifer Arcino Demeterio
hello all, what will i do to have a realtime backup of my database? thanks :)

Re: [PHP-DB] Passing Objects

2001-05-10 Thread Joe Brown
Nope. something like this may get you where you want to go though include("myObjectClassDeclaration"); $myInstance=new myObject; echo "http://blahblah.com/?passedClass=".urlencode(serialize($myInstance)); Then in subsequent pages this should work: include("myObjectClassDeclaration");

[PHP-DB] Mysql log

2001-05-10 Thread Mike
I have a php/mysql website hosted by a "megahost" .Since I cant have access to the log files,does anyone have a script that writes database info(connections,sql statements...) to a file? Thanks Mike [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

[PHP-DB] just testing

2001-05-10 Thread Nickolas Heyde
hi -- PHP Database 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-DB] mysql-php

2001-05-10 Thread Nickolas Heyde
If I were U I would convert it to UNIX date first subtract and then restore to normal format what do U think !?!?! ""Mikail"" <[EMAIL PROTECTED]> escreveu na mensagem 008c01c0d2f2$2e0df880$bb02a8c0@maz">news:008c01c0d2f2$2e0df880$bb02a8c0@maz... > hi, > I'm a newbie from Italy > I use php wi

RE: [PHP-DB] exit code generation, php shell script/standalone

2001-05-10 Thread Dave VanAuken
this particular instance of call is from a radius server (perl or C), so it is not interacting with the web server at all, no browsers... a shell script for all intents and purposes, which parses the db for the required aiuthentication info and processes the request accordingly (along with other

Re: [PHP-DB] Creating/reading [TAGS]

2001-05-10 Thread Paul Burney
on 5/10/01 3:07 PM, David Balatero ([EMAIL PROTECTED]) wrote: > I am making a content backend for my site, and I need pointers or ideas > on how to implement a formatting system like the one seen in UBB or > phpBB, that uses bracket tags to format content submissions. For > example: > > [b]bold[

[PHP-DB] Creating/reading [TAGS]

2001-05-10 Thread David Balatero
I am making a content backend for my site, and I need pointers or ideas on how to implement a formatting system like the one seen in UBB or phpBB, that uses bracket tags to format content submissions. For example: [b]bold[/b] etc. If anyone could help me on this, that would be great. Thanks!

RE: [PHP-DB] Passing Objects

2001-05-10 Thread Hoover, Josh
I believe you would need to serialize $passedClass (which, I'm assuming here, you've set as a myObject object) and then unserialize it to use it on the following page. http://www.php.net/manual/en/function.serialize.php and http://www.php.net/manual/en/function.unserialize.php Josh Hoover Knowle

[PHP-DB] Passing Objects

2001-05-10 Thread tcuhost
does this make sense? assuming: class myObject { $var1 = "A"; $var2 = "B"; } http://blahblah.com/?passedClass=myObject would passedClass also send with it being an oject both variables and the rest of the class defined? -- PHP Database Mailing List (http://www.php.net/) To unsubscrib

Re: [PHP-DB] Autoincrement Question

2001-05-10 Thread Angie Tollerson
I am also doing it on 3.23.33 with MyISAM recover options off, is that what is happening? like I said...if I delete record one, and add a fourth record, It DOES NOT add it as 1. But as 5. however, if I delete 4, then add a fourth again, it sets it as 4. I'm not sure if that has anything to d

Re: [PHP-DB] Autoincrement Question

2001-05-10 Thread Paul Burney
on 5/10/01 12:59 PM, Angie Tollerson ([EMAIL PROTECTED]) wrote: > That is true if you delete a row in between other records..if you delete 2 the > fourth record added would be 4, not 2. BUT..in the default installation of > mysql, if you delete the last record the auto_increment will fill it's >

Re: [PHP-DB] Autoincrement Question

2001-05-10 Thread CC Zona
[quotes restored to bottom-posting order, for clarity] > > > > If I have a database that has three records and I delete the entire > > > > third record, when another record is then added will the auto increment > > > > number be 3 or 4? Thanks. > > > I will be 3 Jeff :) > > Only if the auto inc

Re: [PHP-DB] Autoincrement Question

2001-05-10 Thread Angie Tollerson
That is true if you delete a row in between other records..if you delete 2 the fourth record added would be 4, not 2. BUT..in the default installation of mysql, if you delete the last record the auto_increment will fill it's place..trust me, I just tried it :) >>> CC Zona <[EMAIL PROTECTED]>

Re: [PHP-DB] Autoincrement Question

2001-05-10 Thread CC Zona
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Angie Tollerson") wrote: > I will be 3 Jeff :) > > > >>> "Jeff Oien" <[EMAIL PROTECTED]> 05/10/01 01:13PM >>> > If I have a database that has three records and I delete the entire > third record, when another record is then added will the aut

RE: [PHP-DB] exit code generation, php shell script/standalone

2001-05-10 Thread Dave VanAuken
did try it, no go. Tried a number of permutations, but it doesn't seem to want to actually return the exit code... just prints it to the screen (in terminal mode) which is pretty and all, but not what I need :) just wondering is a solution exists and i just can't see the forest for the trees.

Re: [PHP-DB] exit code generation, php shell script/standalone

2001-05-10 Thread Miles Thompson
Dave, You can return a value from a function ... function dosomething( para1, para2 ) { code here which depending on success or failure sets $reflag to 0 or 1 return $retflag; } So now the question is "Can we return a value from a script?" Hell, I don't know, why not just try it? M

Re: [PHP-DB] Autoincrement Question

2001-05-10 Thread Miles Thompson
Jeff, That depends - I'm assuming this is a MySql database because of "auto_increment". If the table is declared with "type = MYISAM" when you add the other record the auto_increment number will be 4. If not it will be 3. This is important if you are using the field which is auto_increment (e

[PHP-DB] exit code generation, php shell script/standalone

2001-05-10 Thread Dave
to tie in web based scripts and database updates with some server side authentication issues, we need to have a PHP script be called from another program. The program expects a return or exit value to be transmitted back on completion or termination of the script. 0 indicating success and anythi

Re: [PHP-DB] Autoincrement Question

2001-05-10 Thread Angie Tollerson
I will be 3 Jeff :) >>> "Jeff Oien" <[EMAIL PROTECTED]> 05/10/01 01:13PM >>> If I have a database that has three records and I delete the entire third record, when another record is then added will the auto_increment number be 3 or 4? Thanks. Jeff Oien -- PHP Database Mailing List (http://www.

[PHP-DB] Autoincrement Question

2001-05-10 Thread Jeff Oien
If I have a database that has three records and I delete the entire third record, when another record is then added will the auto_increment number be 3 or 4? Thanks. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-

Re: [PHP-DB] LDAP php_ldap.dll not loaded

2001-05-10 Thread Philippe Saladin
Thanks to all. I tried "regsvr32 php_ldap.dll", and it says that libsasl.dll was needed. Copied it into winnt\system32, and now it works well. Best regards, Philippe ""Philippe Saladin"" <[EMAIL PROTECTED]> a écrit dans le message news: 9ddln5$7rm$[EMAIL PROTECTED] > IIS4, Win NT PHP405 > > Hi,

[PHP-DB] MySQL: CRITICAL problem

2001-05-10 Thread Davor Pleskina
Error message is: - Warning: MySQL Connection Failed: Access denied for user: 'ODBC@localhost' (Using password: NO) in kd_admin.php on line 12 Warning: MySQL: A link to the server could not be established in kd_admin.php on line 12 MySQL Error: - I got upper error trying to execute foll

Re: [PHP-DB] No MySQL-Link resource supplied

2001-05-10 Thread boclair
- Original Message - From: Rankin, Randy <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 10:56 PM Subject: [PHP-DB] No MySQL-Link resource supplied > Is anyone familiar with this error and what causes it (or better, how to fix > it). > Warning: No MySQL-Link res

Re: [PHP-DB] True and Flase in mysql !!

2001-05-10 Thread hassan el forkani
you could also use a char(0) field in which case you can only have two possible records: NULL and ' ' (empty string) regards 09/05/01 22:42:04, "Zak Greant" <[EMAIL PROTECTED]> wrote: >Use an enum field. > >--zak > > >- Original Message - >From: "DesClub.com" <[EMAIL PROTECTED]> >To:

Re: [PHP-DB] No MySQL-Link resource supplied

2001-05-10 Thread Russ Michell
> Is anyone familiar with this error and what causes it (or better, how > to fix it). > Warning: No MySQL-Link resource supplied > in /usr/local/apache/htdocs/sales/login.php on line 46 Go to: http://uk.php.net/manual/en/function.mysql-close.php, it seems as if mysql_close() does take some ar

[PHP-DB] No MySQL-Link resource supplied

2001-05-10 Thread Rankin, Randy
Is anyone familiar with this error and what causes it (or better, how to fix it). Warning: No MySQL-Link resource supplied in /usr/local/apache/htdocs/sales/login.php on line 46 Line 46 = mysql_close(); I cannot seem to find anything regarding this message in the MySQL or PHP manuals.

[PHP-DB] problem with dbase_replace_record()

2001-05-10 Thread Benny
I experienced this problem when I want to replace a record in foxpro database(.dbf). First I was add a record with this syntax and it work : $record[0] = "2628"; $record[1] = "230 10 10003"; $record[2] = "MY NAME"; $record[3] = "30"; $record[4] = "3002 "; $add = dbase_add_record (

Re: [PHP-DB] Date formats from Postgres

2001-05-10 Thread Alexey Borzov
Greetings, Sean! At 10.05.2001, 14:08, you wrote: SW> I am reading a data datatype from a PostgreSQL database, SW> the format sohwing is 2001-01-05 for the 1st of May this year, Isn't it 2001-05-01? SW> I need this date in Australian format i.e. 01/05/2001, SW> I tried using the string d

[PHP-DB] Date formats from Postgres

2001-05-10 Thread Sean Weissensee
I am reading a data datatype from a PostgreSQL database, the format sohwing is 2001-01-05 for the 1st of May this year, I need this date in Australian format i.e. 01/05/2001, I tried using the string date (string format [, int timestamp]) but with no success.I am not sure how to convert the

[PHP-DB] LDAP php_ldap.dll not loaded

2001-05-10 Thread Philippe Saladin
IIS4, Win NT PHP405 Hi, here's my new problem. I've copied php_ldap.dll into c:\Winnt\system32, and in php.ini, I have the line "extension=php_ldap.dll" Nevertheless, i have an error : PHP Warning: Unable to load dynamic library './php_ldap.dll' - Le module spécifié est introuvable. in Unknown

Re: [PHP-DB] mysql newbie

2001-05-10 Thread Russ Michell
>how to set mysql to ask password to any user who try to enter ? If you are using a GUI like phpMyAdmin to administer the MySQL database, you can use it to prompt for a username and password such as would occur with a .htaccess/.htpasswd file combination. If you're on the command line - in Lin

Re: [PHP-DB] True and Flase in mysql !!

2001-05-10 Thread Russ Michell
> What is the best way to create True\Flase field in mysql ?? Use the 'ENUM' Field type. http://www.mysql.com/doc/E/N/ENUM.html Russ On Thu, 10 May 2001 11:43:01 +0300 "DesClub.com" <[EMAIL PROTECTED]> wrote: > hi all .. > What is the best way to create True\Flase field in mysql ?? > > > ---