[PHP-DB] automatic logout

hello, i use session for user authentication in php/mysql. how to logout the session automatically if: there is no activity for a period of time (user forgot to click logout), or user just close the browser without logout ? thanks, rudy -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Problem with datetime using php4 on mssql7

when I try to query a datetime field using php4(4.0.6, on Win2000/Apache/MSSQL) I could not get the datetime. Does anyone have any suggestions for how to solve this problem? Thanks Elman -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

[PHP-DB] putting MySql database on server

what do i need to change in my MySql databse when i upload it to server to work correctly -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

[PHP-DB] Are u using phpmyadmin to create your database?

Are u using phpmyadmin to create your database? or u do it from command prompt ,and do i have a databse driver so my database works when i upload it to server? -- PHP

[PHP-DB] how to enter cgi-bin folder?

i want to access the file: test.php and its located in cgi-bin folder. and my form file is :form.html and its in htdocs folder. how can i access test.php? i tried: method= ../cgi-bin/test.php

[PHP-DB] does MySql needs driver

i didn't use a driver just inserted data directly throw phpmyadmin. do i need a driver?if yes from where can i get it? -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] Grant statement

do i need to write thr Grant statement to allow users to a have access to database(mysql)? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

SV: [PHP-DB] automatic logout

As far as I know, the only way to get timeout of session data is to store a timestamp with last access time and check this each time the session data is referenced.. If the user close the browser window, the session data will timeout and you don't have to worry. -Ursprungligt

[PHP-DB] oci8 and arrays as parameter

hi list, I'm using PHP 4.0.6 and i want to give an array as parameter from a php script to an oracle pl/sql - procedure... We had an older asp - site, witch used the same stored procedure, so that it's clear, the procedure works... In asp it calls AddTable to bind the parameter as array call

RE: [PHP-DB] Grant statement

yes, you do. Set-up a generic account, with password, for all users. Then use it in the mysql_connect() statement. You need to set-up this account only once; not when accessing the database each time. -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Monday, September

RE: [PHP-DB] does MySql needs driver

what did you try to do? Need specifics. -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 6:53 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] does MySql needs driver i didn't use a driver just inserted data directly throw phpmyadmin. do i need a

RE: [PHP-DB] Parsing of db results by PHP

use this PHP function: eval() As quoted from the PHP manual: eval() evaluates the string given in code_str as PHP code. Among other things, this can be useful for storing code in a database text field for later execution Further info is in the manual under the Miscellaneous Functions chapter

[PHP-DB] oci8 and arrays as parameter

hi list, I'm using PHP 4.0.6 and i want to give an array as parameter from a php script to an oracle pl/sql - procedure... We had an older asp - site, witch used the same stored procedure, so that it's clear, the procedure works... In asp it calls AddTable to bind the parameter as array call

RE: [PHP-DB] Parsing of db results by PHP

Hrm, yup... that does what I want... thanks :) It might be a little bit messy... because it'll most likely be embedded in text :) I'm making a weblog system for myself, so the full field might be blah blah blah ? ... ? blah blah which will most likely get messy... Ahh well... Rob At 11:52

[PHP-DB] Using PHP with filemaker?

I am trying to get php to write the data stored in some variables directly to a filemaker pro 5.5 database. So far I have got the PHP to write to a .txt file as tab delineated text, but I then have to manually import this data into filemaker. I have not been able to find any specific function

Re: [PHP-DB] oci8 and arrays as parameter

On Mon, Sep 10, 2001 at 03:50:08PM +0200, Ez-Berlin, E2boxb wrote: hi list, read my paper from conf.php.net/oci - it should explain all that! tc I'm using PHP 4.0.6 and i want to give an array as parameter from a php script to an oracle pl/sql - procedure... We had an older

[PHP-DB] Oracle connectivity from Linux

Hi guys, I am currently looking into a reliable connectivity for Linux to Oracle on NT 4.0. Coding would be in PHP 4. I have read somewhat about iODBC, how does it performs under production use? Which connection methods do you prefer or recommend. Thanks in advance, Danny N.

RE: [PHP-DB] Oracle connectivity from Linux

Danny, iODBC and appropriate ODBC drivers are certainly a production-quality solution. If you like, you may download our Multi-Tier drivers for testing free from our site. They come with a non-expiring 2-user license and we will provide free support if you run into problems. Best regards,

[PHP-DB] update low_priority

I suppose this is more of a mysql question but if I have a lot of people viewing a page that the admin is in the process of updating, should I use UPDATE LOW_PRIORITY? Just wondering if that would rule out any potential problems. Thanks. __ Jason Dulberg Extreme MTB

[PHP-DB] Oracle8i connecting to database problem

Hi, I've configured php as follows, './configure' '--with-mysql' '--with-apxs=/usr/local/apache/bin/apxs' '--with-config-file-path=/megsoc3/' '--enable-trans-sid' '--with-sablot' '--with-zlib' '--with-oracle' '--with-oci8' '--enable-sigchild' '--enable-track-vars' '--enable-sockets' and it

RE: [PHP-DB] Oracle connectivity from Linux

Thanks Andrew! I'll check it out. Danny N. Andrew Hill [EMAIL PROTECTED] wrote: Danny, iODBC and appropriate ODBC drivers are certainly a production-quality solution. If you like, you may download our Multi-Tier drivers for testing free from our site. They come with a non-expiring 2-user

RE: [PHP-DB] Oracle connectivity from Linux

Does the configuration only necessary on the client end or I need cofiguration done on the server side as well for iODBC Oracle Driver to work? Andrew Hill [EMAIL PROTECTED] wrote: Danny, iODBC and appropriate ODBC drivers are certainly a production-quality solution. If you like, you may

[PHP-DB] Oracle Stored Procedures Again - Sorry

I´m getting crazy and I can´t find a solution This is how I execute my procedure on SQL +: SQL var x varchar2(10) SQL exec :x := cpf(26852842819) PL/SQL procedure successfully completed. SQL print x X 1 but I can´t execute the first line whitout having

Re: [PHP-DB] URL checking

You could use fopen() to retreive the HTML of the page, then parse it taking your best guess at a 404 message. Not very robust though. It'd be much better to open up a socket to the site itself, then issue a HEAD /page here request. If the page is not found you'll have a line in the return

[PHP-DB] Mail() function and the php.ini file

I'm attempting to setup the PHP module to allow the mail() function to work. As I understand, I need to edit the php.ini file? I can't locate the file to edit. Can someone point me in the right direction? I'm using OSX Server. Thanks, Jeff Panis [EMAIL PROTECTED] -- PHP Database Mailing List

RE: [PHP-DB] Oracle connectivity from Linux

Danny, OpenLink's current Oracle driver from Unix requires a server-side component. Best regards, Andrew -Original Message- From: Danny Nguyen [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 2:01 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Oracle connectivity from

[PHP-DB] ghost server?

hi. i menage quite popular internet wortal (http://hip-hop.pl) and I use mysql and php 4.0 as the main generator of all webpages. since few months every day i have some problems with the server (AMD Duron 700MHz, 256 Mb RAM, ABIT KT7-RAID, Intel Ether Express 100+). operating system is FreeBSD

Re: [PHP-DB] ghost server?

Hello hex, Monday, September 10, 2001, 8:40:16 PM, you wrote: hPF hi. hPF i menage quite popular internet wortal (http://hip-hop.pl) and I use mysql and hPF php 4.0 as the main generator of all webpages. hPF since few months every day i have some problems with the server (AMD Duron hPF 700MHz,

RE: [PHP-DB] reading arrays within a field from mysql and separating the values

$myarray=explode(,,$DCD['fieldname']); In the above, substitute fieldname for the name of the field which contains name1,name2,name3,name4,... Then, cycle through each $myarray element as you've done below. -Original Message- From: Robert Trembath [mailto:[EMAIL PROTECTED]] Sent:

RE: [PHP-DB] reading arrays within a field from mysql and separating the values

$myarray=explode(,,$DCD['DCD_Access']); Then, cycle through each $myarray element as you've done below. -Original Message- From: Robert Trembath [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 2:55 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] reading arrays within a field from

RE: [PHP-DB] Oracle connectivity from Linux

Do you know of any other Oracle connection method that does not require server side components? Thanks, Danny N. Andrew Hill [EMAIL PROTECTED] wrote: Danny, OpenLink's current Oracle driver from Unix requires a server-side component. Best regards, Andrew

RE: [PHP-DB] Oracle connectivity from Linux

You can use OCI directly - or if you want to still use ODBC, you can piggyback ODBC on the client (Linux) ontop of OCI. That maintains portability for the future and give you some things like better cursor handling and security. Let me know if you want assistance in setting up a 'piggyback'

RE: [PHP-DB] reading arrays within a field from mysql and separating the values

what do you mean by it made no difference? Did you examine each element in $myarray? What were the results? rick FYI...I tried to send directly to you and the message was bounced back -Original Message- From: Robert Trembath [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001

RE: [PHP-DB] reading arrays within a field from mysql and separating the values

Robert, Do a manual SELECT DCD_Access FROM userdb WHERE ID = ### and send the results. I'd like to see exactly what is in that field. The explode() should have provided an array of values rick -Original Message- From: Robert Trembath [mailto:[EMAIL PROTECTED]] Sent: Monday,

Re: [PHP-DB] Locating php.ini file

Jeff, I believe /usr/local/lib is the path for the application. The ini file is typically located in /etc... For example, mine is: /etc/php.ini Hope this helps, cheers! John Pickett http://www.bvstudios.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

Re: [PHP-DB] Locating php.ini file

Jeff, This also worked for me (sorry for the double-post): [root@server johnp]# find / -name php.ini Make sure you're logged in as root just in case although it should work anyway... That'll return filenames of php.ini in every directory (I think, not very literate with CLI yet ;-)). L8R!

[PHP-DB] Problem with datetime using php4 on mssql7

when I try to query a datetime field using php4(4.0.6, on Win2000/Apache/MSSQL) I could not get the datetime. Does anyone have any suggestions for how to solve this problem? Thanks Elman -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [PHP-DB] creating an Oracle variable...

Bona: You're using OCIParse incorrectly. It's used to parse SQL commands. The var statement that you quoted is a SQL*Plus command. That is, you're defining a variable in SQL*Plus. That's why you're getting an Invalid SQL Command error. Use the OCIBindByName to bind a PHP variable (you're using