[PHP-DB] Re: Extremely Urgent: Problem with PHP and Oracle

Charles Morris wrote: Hello all, I have recently been working with OCI and when I use OCILogon [wethere with example scripts or my own code] I get a PAge cannot be displayed (like DNS error) when I naviagte to the page. When I comment out the OCILogon part it works great exept for the oracle part.

Re: [PHP-DB] Re: Extremely Urgent: Problem with PHP and Oracle

Justin Patrin wrote: Charles Morris wrote: putenv(ORACLE_SID=PROJ); putenv(ORACLE_HOME=/home/oracle9); I have tried putenv myself and it doesn't seem to work for Oracle connections. Putting those in your shell environment, then restarting apache. Check to see if the env vars are set

[PHP-DB] Re: Getting data from mysql db for html form

works like a bomb !!! thanx man ! Torsten Roehr [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Gamco - Gawie Marais [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, Could someone help me out here... I have a mysql database with a table that conatains names.

[PHP-DB] Re: Count unique visits in PHP/MySQL

take a look at this: http://otn.oracle.com/oramag/oracle/04-mar/o24asktom.html and search for the Analytics to the Rescue example. Instead of 3 seconds you want 1800 and instead of sum you want count.Don't forget to group by ip,of course... And you're done. No need for an extra table. Hope

[PHP-DB] datetime update

Hi all, i have a datetime field in a mysql database and it's defined with a default of '-00-00 00:00:00:' now, when i add a record to the database, i want to fill that field with the date and current time. can anyone point me ? Thanx, Gawie. -- PHP Database Mailing List

[PHP-DB] Re: datetime update

Hi all, i have a datetime field in a mysql database and it's defined with a default of '-00-00 00:00:00:' now, when i add a record to the database, i want to fill that field with the date and current time. can anyone point me ? Via PHP: $dateTime = date('Y-m-d H:i:s'); mysql_query(INSERT

[PHP-DB] automatic call reference creation

hi all, i need to create an automatic call reference. i though it would work using the date as ccyymmdd and by adding a '001', '002', etc to the end. now, i know how to format the date but how would i increment the 001, 002 at the end... ? i understand that i would have to check back to the

[PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file...

project i'm working with, his host died or something. but, the phpMyadmin (on that host) can NOT do a backup of 200mb table without running out of memory or something weird. so what is the best way to text dump the table? i thought i would (pseudo-code): open DB do while not EOF grab 1000

Re: [PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file...

Hi the Third, have you considered dumping the table into a text file? SELECT * FROM mytable INTO OUTFILE c:/... this (AFAI) does not cause memory issues Ignatius _ - Original Message - From: Leo G. Divinagracia III [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

[PHP-DB] Re: automatic call reference creation

not sure what u want here but have you looked at the identiry field ?? its called auto_increment in mysql and this gives it record in a database a unique number eg Insert into table (date_call)values(now() ) then after the insert do select last_insert_id() pedro Gawie Marais wrote: hi all, i

[PHP-DB] Re: automatic call reference creation

thanx for the replys guys... basically i need a PHP formula to generate a 'call refenrence code' that is unique to give out to clients whenever they log a call. this unique 'call reference code should be inserted into a mysql field within a table. all i need is a formula to get the last entered

[PHP-DB] Re: automatic call reference creation

using the autoincrement you'd have to create the entry first ! otherwise your gonna have problems with concurrent users Gawie Marais wrote: thanx for the replys guys... basically i need a PHP formula to generate a 'call refenrence code' that is unique to give out to clients whenever they log a

[PHP-DB] MySql syntax error using PHPWiki

Greetings, I'm trying to set up a PHPWiki using Apache 2.0.49, PHP 4.3.7, PEAR 4.1.0, and PHPWiki 1.3.10. I get this error when trying to load index.php: C:\Program Files\Apache Group\Apache2\htdocs\lib\WikiDB\backend\PearDB.php:778: Fatal[256]: wikidb_backend_mysql: fatal database error DB

Re: [PHP-DB] MySql syntax error using PHPWiki

Hi! You missed table definition: ... FROM my_table where ... Wednesday, June 9, 2004, 12:57:02 PM, PHPDiscuss wrote: PPNaml Greetings, PPNaml I'm trying to set up a PHPWiki using Apache 2.0.49, PHP 4.3.7, PEAR 4.1.0, PPNaml and PHPWiki 1.3.10. PPNaml I get this error when trying to load

[PHP-DB] Oracle syntax

Hi list. I am a newbie and would like to ask if anyone could give me the proper syntax for connecting with oracle DB. For example with MySQL it is: mysql_connect..., mysql_query... For MS SQL Server: mssql_connect..., mssql_query... What would be for oracle? TIA RS This e-mail, including

RE: [PHP-DB] Oracle syntax

It can be found here: http://us3.php.net/manual/en/ref.oracle.php MAO -Original Message- From: Rafi Sheikh [mailto:[EMAIL PROTECTED] Sent: Thursday, June 10, 2004 9:33 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Oracle syntax Hi list. I am a newbie and would like to ask if anyone

[PHP-DB] HTTP header information

Hi all. I am running a website to where a user needs to login to authenticate themselves to perform certain tasks. So a user logs in, and I start a session (in PHP, of course). Well, the catch is, I am doing this all from one page, 'viewer.php', and I just tack on the specific view/page that I

Re: [PHP-DB] Oracle syntax

Rafi Sheikh wrote: Hi list. I am a newbie and would like to ask if anyone could give me the proper syntax for connecting with oracle DB. For example with MySQL it is: mysql_connect..., mysql_query... For MS SQL Server: mssql_connect..., mssql_query... There are various examples in the PHP

[PHP-DB] Re: HTTP header information

Philip Thompson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi all. I am running a website to where a user needs to login to authenticate themselves to perform certain tasks. So a user logs in, and I start a session (in PHP, of course). Well, the catch is, I am doing this all

RE: [PHP-DB] Re: datetime update

Actually it would be: UPDATE table SET dateTime=NOW() WHERE record_id='$the_one_you_want'; Or INSERT INTO table (record_id,dateTime) VALUES ('$the_one_you_want',NOW()); Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original

RE: [PHP-DB] HTTP header information

Hi Philip, You'll probably want to move your session handling code to the top of the main entry point of your application, rather than starting it in a sub-page. This way all subpages get the benefit of being able to use the session data. Even if not strictly necessary, the option is there in

Re: [PHP-DB] Re: HTTP header information

On Jun 10, 2004, at 9:44 AM, Torsten Roehr wrote: Philip Thompson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi all. I am running a website to where a user needs to login to authenticate themselves to perform certain tasks. So a user logs in, and I start a session (in PHP, of

[PHP-DB] password () function.

Is this function, password() available at PHP Ander Windows? I get an undefinied function error message! Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: James Harrell [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 10 de Junio de 2004 09:50 a.m. Para: Philip

Re: [PHP-DB] password () function.

Is this function, password() available at PHP Ander Windows? I get an undefinied function error message! There is no PASSWORD() function in PHP. There is, however, a PASSWORD() function in MySQL and other database applications. Larry PS It looks like you hijacked someone else's thread, which you

Re: [PHP-DB] Re: HTTP header information

Philip Thompson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Jun 10, 2004, at 9:44 AM, Torsten Roehr wrote: Philip Thompson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi all. I am running a website to where a user needs to login to authenticate

RE: [PHP-DB] password () function.

OK, now I understand why it doesn't works under SQL Server.!! Thanks! P.S. Yes, I do hijacked someone else's thread. I won't do it again! THANKS! Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: Larry E. Ullman [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 10

RE: [PHP-DB] Re: HTTP header information

Make sure that NO output is done before session_start() is called. Can you post some of your code? See, that's the case. Because I'm essentially just changing the content within the page, it never leaves the page 'viewer.php' - it just changes the content by tacking on '?type=login,

RE: [PHP-DB] Re: automatic call reference creation

Here's what you can do: 1. CREATE your table with an autoincrement column as well as a date column. 2. When the customer service rep logs the call, they click on the submit button, which will place the data into the DB 3. Right after you do the insert, (in PHP) do: $suffix =

[PHP-DB] Re: automatic call reference creation

Gawie Marais wrote: thanx for the replys guys... basically i need a PHP formula to generate a 'call refenrence code' that is unique to give out to clients whenever they log a call. this unique 'call reference code should be inserted into a mysql field within a table. all i need is a formula to get

[PHP-DB] Re: HELP: best way to TEXT dump a MySQL table to a local file...

Leo G. Divinagracia III wrote: project i'm working with, his host died or something. but, the phpMyadmin (on that host) can NOT do a backup of 200mb table without running out of memory or something weird. so what is the best way to text dump the table? i thought i would (pseudo-code): open DB do

Re: [PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file...

would be nice... but since this is a hosted site and no shell access or anything, i thought i would write the php script to dump the file to my web path... Ignatius Reilly wrote: Hi the Third, have you considered dumping the table into a text file? SELECT * FROM mytable INTO OUTFILE c:/...

[PHP-DB] PHP/MySQL learning project

Hi everyone! In trying to learn PHP and MySQL, I'm trying to create a web-based database application that will keep track of my movies. I have five tables (shown in the graphic). I'm trying to be able to display the results of the tables with one movie title, all of the actors associated with

[PHP-DB] Re: PHP/MySQL learning project

News.Php.Net wrote: Hi everyone! In trying to learn PHP and MySQL, I'm trying to create a web-based database application that will keep track of my movies. I have five tables (shown in the graphic). I'm trying to be able to display the results of the tables with one movie title, all of the

[PHP-DB] Anyone using MSQL Server with PHP?

Hi!! Anybody here using PHP with SQL Server? I would like to use a similar function to password () from MySQL under SQL Server. Anybody knows of a similar function under SQL Server? Kind Regards, Miguel Guirao Servicios Datacard www.SIASA.com.mx

[PHP-DB] Re: Anyone using MSQL Server with PHP?

Miguel Guirao wrote: Hi!! Anybody here using PHP with SQL Server? I would like to use a similar function to password () from MySQL under SQL Server. Anybody knows of a similar function under SQL Server? Kind Regards, Miguel Guirao Servicios Datacard www.SIASA.com.mx If it's for your app

[PHP-DB] Re: PHP/MySQL learning project

Excellent! That's exactly what I needed to know! Thanks a million! Justin Patrin [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] News.Php.Net wrote: Hi everyone! In trying to learn PHP and MySQL, I'm trying to create a web-based database application that will keep track of

RE: [PHP-DB] Re: Anyone using MSQL Server with PHP?

Thanks!! It Works out pretty nice!! Miguel Guirao Servicios Datacard www.SIASA.com.mx -Mensaje original- De: Justin Patrin [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 10 de Junio de 2004 05:51 p.m. Para: [EMAIL PROTECTED] Asunto: [PHP-DB] Re: Anyone using MSQL Server with PHP?

Re: [PHP-DB] Re: datetime update

[EMAIL PROTECTED] wrote: Hi all, i have a datetime field in a mysql database and it's defined with a default of '-00-00 00:00:00:' now, when i add a record to the database, i want to fill that field with the date and current time. can anyone point me ? Via PHP: $dateTime = date('Y-m-d

RE: [PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file...

I agree to use mysqldump to export the data to a text file. If you want to save time, you could write a php script to ftp the text file from the dead host to the new host. Then load the data back into the new database. I guess if you have broadband connection, then you might not be saving

Re: [PHP-DB] Re: Anyone using MSQL Server with PHP?

Hi Miguel, I would also strongly suggest that you use a salted hash if you are concerned with security -- especially if that md5 could ever be compromised or pass in clear text over an internet connection. The md5() function in PHP produces unsalted hashes, which are fairly easy to crack.