[PHP-DB] Oracle - PHP

Hi: I have PHP with mySQL compiled in. We are about to attempt to connect to Oracle. Of course we have to rebuild PHP with the added Oracle support, but I was just wondering if anyone has done this and if so, could you offer any noteworthies or comments about using PHP with Oracle. Thanks!

Re: [PHP-DB] number formatting bug?

I was thinking again , if you are for instance using winxxx check in start settings/control panel/regional settings decimal after point... this might be affecting, there must be something similar on unix. Check out in the help "set_locale" that should do the trick. Lennin Arriola [EMAIL PROTECT

[PHP-DB] Can PHP read View in stead of Table?

Dear all, I have install PHP on Linux and use Openlink ODBC Driver to link to MS SQL server on Windows NT. Just now I can read data from Table on SQL server. However, when I make View on the same database, I can't use PHP to extract data from this View. When I do query on the View, error messag

[PHP-DB] Problem with IB's LEN

I have in my Interbase6 table a column defined as NUMERIC(18,2), but PHP shows it as integer value. During tests i discovered, that largest precision allowed for large exact numeric is 9 (NUMERIC(9,2)). Is there any switch that allows use larger precisions? Cheers Jarek Zgoda -- PHP Database

Re: [PHP-DB] Oracle - PHP

Waht platforms are PHP and Oracle on? What version of Oracle? On Thu, 22 Feb 2001 09:34, Hise, Jeremy wrote: > Hi: > > I have PHP with mySQL compiled in. We are about to attempt to connect to > Oracle. Of course we have to rebuild PHP with the added Oracle support, but > I was just wondering if a

Re: [PHP-DB] MySQL database transfer

At 03:24 AM 2/22/01 -, Sridhar Ranganathan wrote: >Hi > >I have mysql on linux and windows on the same machine. How do i transfer >data between them?? use mysql dump to create a script, .sql file, and execute it on the other one. = "To dwell within Samsara, howe

[PHP-DB] Re: Is there a PHP equivalent of DATE_FORMAT ?

Timothy Wright wrote: >... so echo date("Y-n-j") would give me the output in the right format, but >I need to convert the input to a valid timestamp first. You can use parse out the year, month and day and then use the mktime function - the dates I use are dd/mm/yy format: /*Make an array of t

[PHP-DB] cancel <3A943D4B.8B7974E9@evermeet.cx>

This message was cancelled from within Mozilla. -- 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] retrieval of NEXT, PREV records

I'm sorry I haven't noticed that. I couldn't believe, then I tried to create and make some delete-insert operations and the primary key order has gone away. Thanks a lot. One more lesson I learned. Jayme. -Mensagem Original- De: Sweep the Net <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]

Re: [PHP-DB] Data input

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("Matthew Cothier") wrote: > How can they input the data into the database as they typ eit in without > them having to add html <.br.> tags? nl2br() -- CC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PRO

RE: [PHP-DB] retrieval of NEXT, PREV records

It would only be ordered that way if you had not deleted any records and added new ones. IF there are ones deleted, the next ones frill in the space. Bob At 05:00 PM 2/21/01 -0500, you wrote: >Perhaps it is ordered that way, perhaps not, but live by the creed "Expect >nothing and you will nev

[PHP-DB] MySQL database transfer

Hi I have mysql on linux and windows on the same machine. How do i transfer data between them?? Thanks in advance _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (

[PHP-DB] authentication in a browsing directory

Hi, I've got some directories that should be accessed via the browser. This works fine. To secure a directory I always used the directives in the .htaccess file. This works aswell. Now I wrote a little PHP script that looks in a table of a database if the user is allowed to access the page or not

RE: [PHP-DB] retrieval of NEXT, PREV records

Perhaps it is ordered that way, perhaps not, but live by the creed "Expect nothing and you will never be disappointed." Go ahead and specify the order you demand. > -Original Message- > From: JJeffman [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 21, 2001 4:40 PM > To: [EMAIL P

Re: [PHP-DB] retrieval of NEXT, PREV records

As far as I know, if you do not set any special order, the table is ordered by primary key, isn't it ? Jayme. -Mensagem Original- De: Chris Book <[EMAIL PROTECTED]> Para: JJeffman <[EMAIL PROTECTED]>; Adv. Systems Design <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Enviada em: quarta-feira,

[PHP-DB] authentication in a browsing directory

Hi, I've got some directories that should be accessed via the browser. This works fine. To secure a directory I always used the directives in the .htaccess file. This works aswell. Now I wrote a little PHP script that looks in a table of a database if the user is allowed to access the page or not

[PHP-DB] nl2br()

Where exactly do I need to insert this? _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

RE: [PHP-DB] while loop driving me crazy

Richard, What can one say? Too late? Too long looking at it? Reading too quickly? or in the immortal wordsof Charlie Brow " AUUGH!" Thanks a million and love your signature. Miles Thompson At 03:30 PM 2/21/01 +, [EMAIL PROTECTED] wrote: > while( $row = mysql_fetch_array( $result ) )

RE: [PHP-DB] nl2br()

If you have a bunch of text that is properly formatted with carriage returns/linefeeds between the paragraphs and you then try to send this to a browser, the carriage returns/linefeeds will be ignored and you wind up with one big paragraph. You could surround the whole thing with and , but the n

[PHP-DB] php/mysql

i have this code. function create_mysqltable($db_name,$table_name){ mysql_select_db($db_name); $sql_query = "CREATE TABLE IF NOT EXISTS $table_name " . "( id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT, " . " soort char(20), " . " aantal varchar(20) DEFAULT '0', " . " str_men varch

[PHP-DB] delete a row by a column of type date

i have a mysql field called expired of type date in a table that holds the date that the record needs to be expired. what php code would i need to delete all records that if the date in the expire column for each row was older than current date. -- PHP Database Mailing List (http://www.php.n

Re: [PHP-DB] php.mysql

perhaps the version of mysql you have installed? it's got to be >3.22 -- 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]

[PHP-DB] Data input

I have set up a database so that users can submit news to my website. The only problem is they input their news article into the database through a form but it comes out as a continuous string of text. (a) shows what it looks like now, and (b) shows how its supposed to look. How can they input

RE: [PHP-DB] while loop driving me crazy

Remove the semi-colon after your while() statement. > -Original Message- > From: Miles Thompson [mailto:[EMAIL PROTECTED]] > Sent: 21 February 2001 15:01 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] while loop driving me crazy > > > I've used a similar structure hundreds of times, but th

RE: [PHP-DB] while loop driving me crazy

BDY.RTF -- 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]

[PHP-DB] while loop driving me crazy

I've used a similar structure hundreds of times, but the following isn't working: $result = mysql_query($sql, $db); if( !$result ) { echo "No result code in SQL send. "; } if( mysql_num_rows( $result ) >= 1 ) { echo "Rows fetched: ", mysql_num_rows( $result ), ""; while( $row = m

RE: [PHP-DB] retrieval of NEXT, PREV records

you have to make sure you order by Rec_id all the time too. -Original Message- From: JJeffman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 4:39 PM To: Adv. Systems Design; [EMAIL PROTECTED] Subject: Re: [PHP-DB] retrieval of NEXT, PREV records "SELECT * FROM Table WHERE R

[PHP-DB] php.mysql

i have this code. function create_mysqltable($db_name,$table_name){ mysql_select_db($db_name); $sql_query = "CREATE TABLE IF NOT EXISTS $table_name " . "( id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT, " . " soort char(20), " . " aantal varchar(20) DEFAULT '0', " . " str_men varc

RE: [PHP-DB] Excel to Mysql

I've also had great results simply saving my Excel in a *.csv format, then importing it directly into mySQL. -Original Message- From: dmalcolm [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 4:04 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Excel to Mysql Gabriel Adame w

RE: [PHP-DB] PHP security

Addressed to: "s.budd" <[EMAIL PROTECTED]> [EMAIL PROTECTED] ** Reply to note from "s.budd" <[EMAIL PROTECTED]> Wed, 21 Feb 2001 10:03:33 - > > > But if the database is on another machine then the password is sent as plain > text over the internet, no? No. MySQL encrypts the p

RE: [PHP-DB] Is there a PHP equivalent of DATE_FORMAT ?

Addressed to: "Timothy Wright" <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> > I need to convert the input to a valid timestamp first. > > Any ideas?? Am I missing something really obvious...it's late and my brain > is tired.. Read the MySQL manual, section 7.4.11 Date and Time Functi

RE: [PHP-DB] PHP security

But if the database is on another machine then the password is sent as plain text over the internet, no? -Original Message- From: Ben Cairns [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 10:06 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP security Anything conta

[PHP-DB] automatic execution

I need a programme which would execute itself after a particular interval of time or at a predefined time (like scheduling tasks in windows environment). Any suggestions ??? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-m

RE: [PHP-DB] PHP security

Anything contained within the PHP open & close Tags ( ) is parsed out server side. In order for them to read the source of the file, they must have console access. Try and get a password from www.mywapfone.net/index.php That page does a DB connect using your script. You cannot see my Passwor

RE: [PHP-DB] PHP security

moreover , even if they cant see the text of the page, Your password is going over the internet in plain text. -Original Message- From: Don [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 7:24 PM To: php-db list Subject: [PHP-DB] PHP security I am writing aome PHP scripts

Re: [PHP-DB] Is there a PHP equivalent of DATE_FORMAT ?

["Timothy Wright" <[EMAIL PROTECTED]>] > The only problem is I'm not starting with a Unix timestamp. The > variable is passed from a form as md (or 2001223... no leading zeros in > the month or day). The PHP date function allows these characters in the > string... > > "Y" - 4-digit yea

[PHP-DB] Setting cookies that are valid for two or more domains

Hey there... I need to set a cookie with variables that will be valid for two domains with different names. In reality these two domains are on the same server, and even in the same dir we use: php4, apache, Linux -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [

[PHP-DB] number formatting bug?

I call: the output is "13,00" !! any idea? Is it a bug? Thanks == Valerio FerrucciTabasoft Sas [EMAIL PROTECTED] http://tabasoft.ancitel.it [EM

Re: [PHP-DB] Array element as object.

""JJeffman"" <[EMAIL PROTECTED]> wrote in message 000701c09ba2$3b2bb020$f0d4d7c8@jjeffman">news:000701c09ba2$3b2bb020$f0d4d7c8@jjeffman... > I've already made an object which had a property that was an array. Now I > need to have an array that can hold objects as its elements is It possible ? >

RE: [PHP-DB] password / email

BDY.RTF -- 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]