[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 u

[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 additio

[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 Da

[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/) T

[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: [EM

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 meddelande---

[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 10,

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 dr

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

What does ypur site tree look like? -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 6:51 AM To: [EMAIL PROTECTED] Subject: [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

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 PM 10/09

[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 for

Re: [PHP-DB] Using PHP with filemaker?

You need an odbc driver in order to communicate with a database. I am not familiar with filemaker so I suggest you contact your vendor or go to their website and see if they have an odbc driver. - Original Message - From: "joel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, Se

[PHP-DB] Persistent connections is not persistent (MySQL)

Actually I don't know if this problem is a PHP-, an Apache- or a MySQL-issue, but in this forum probably a lot is using the same combination of servers, so probably someone has an experience to share with me. I'm running a PHP-build website (using PHP 4.0.6) and an Apache-server (1.3.20) on a Win

[PHP-DB] oci8 and arrays as parameter

I am 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 without t

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 o

[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, Andrew

[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 http://extrem

[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 mak

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

Re: [PHP-DB] mail() - is there a limit?

I would doubt there's a limit in any of the mail RFCs -- but I've seen some mailservers limit the number of Cc's or Bcc's you can do on a single message. It's all up to the admin of the mailserver I suppose. Justin Buist Trident Technology, Inc. 4700 60th St. SW, Suite 102 Grand Rapids, MI 4951

[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 /" request. If the page is not found you'll have a line in the return result (s

[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 f

RE: [PHP-DB] Oracle8i connecting to database problem

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 10, 2001 2:02 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Oracle8i connecting to database problem > > (I can create a connection to the database using sqlplus and the > variables I'v

[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 4.

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

Hi, I creat the variable "test" using the sql plus: var test varchar2(10); I´ve been trying to do it wiht PHP: $comando1 = "exec var test varchar2(10);"; $controle = OCIParse ($connection, $comando1); if ($controle == false){ echo OCIError($

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> 700

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

Hello everyone, Ran into a problem trying to get this to work. I have multiple names in a mysql field (DCD_Access) that contains "name1, name2, name3, name4" and I want read this information as an array so I can use these values to populate a pull-down list using a while or foreach loop. Below is

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: Mon

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 fro

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' arch

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 3

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, Septemb

[PHP-DB] Locating php.ini file

I can't seem to locate the php.ini file on my server. Phpinfo() shows it to be in /usr/local/lib but I can't seem to see it (logged as root). I'm on OSX Server 10.0.3 using PHP 4.0.6. Does anybody have have any clues where to locate this file? Thanks, Jeff Panis [EMAIL PROTECTED] PS. I do see a

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: [EMA

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! Jo

[PHP-DB] ODBC connection problem

Windows NT 4.0 workstation Apache PHP 4 I'm using ODBC to connect to dbase tables. the following code works fine and returns the correct results... "; } odbc_close($connect); ?> -

[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 additio

[PHP-DB] cookies

hello all, just wondering if there's a way to delete/unset a previously set cookie. thanks - Original Message - From: Elman Cheng <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 11, 2001 9:49 AM Subject: [PHP-DB] Problem with datetime using php4 on mssql7 > when

Re: [PHP-DB] cookies

> hello all, > > just wondering if there's a way to delete/unset a previously set cookie. > > thanks Yep - have a look here: http://www.php.net/manual/en/function.setcookie.php jason -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additi

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 t

[PHP-DB] sessionid

hello! i have a script below, my question is, will there be a chance that i will get thesame $sessionid. if (!$sessionid) { $sessionid = md5(uniqid(rand())); SetCookie("sessionid","$sessionid",time()+1314000); }