[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 unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 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] 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 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] 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/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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- Från: RSalomo [mailto:[EMAIL PROTECTED]] Skickat: den 10 september 2001 10:27 Till: [EMAIL PROTECTED] Ämne: [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 unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- 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] 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 without typ: OCIbindbyname($stmt, :P13, $arr,-1); - Warning: Array to string conversion in x on line y call with OCI_B_CURSOR: OCIbindbyname($stmt, :P13, $arr,1,OCI_B_CURSOR); - Warning: Supplied argument is not a valid OCI8-Statement resource in x on line y call with OCI_B_TABLE: OCIbindbyname($stmt, :P13, $arr,1,OCI_B_TABLE); - Warning: Use of undefined constant OCI_B_TABLE - assumed 'OCI_B_TABLE' in x on line y I got the same message with parameters: OCI_B_ARRAY, OCI_B_VARRAY and any other typs Is this not possible with the current version? regards Olaf Taesch mailto:[EMAIL PROTECTED] or mailto:[EMAIL PROTECTED] -- 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] 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, 2001 7:38 AM To: [EMAIL PROTECTED] Subject: [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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- 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] 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 driver?if yes from where can i get it? -- 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 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] 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 (XXXVIII). -Original Message- From: Robert Gormley [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 09, 2001 1:18 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Parsing of db results by PHP Hi all, I have a MySQL db which contains table test, field test... one of the entries is ? external($url, $text); ? Where external() is a function i've written which outputs simple text. I want to be able to put calls to this function into the database, and have them parsed on rendering... With the above example, the raw code is just spat to the browser, and doesn't hit the interpreter. Any ideas? Regards, Robert Robert Gormley [EMAIL PROTECTED] http://seabreeze.asn.au/ -- 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 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] 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 without typ: OCIbindbyname($stmt, :P13, $arr,-1); - Warning: Array to string conversion in x on line y call with OCI_B_CURSOR: OCIbindbyname($stmt, :P13, $arr,1,OCI_B_CURSOR); - Warning: Supplied argument is not a valid OCI8-Statement resource in x on line y call with OCI_B_TABLE: OCIbindbyname($stmt, :P13, $arr,1,OCI_B_TABLE); - Warning: Use of undefined constant OCI_B_TABLE - assumed 'OCI_B_TABLE' in x on line y I got the same message with parameters: OCI_B_ARRAY, OCI_B_VARRAY and any other typs Is this not possible with the current version? regards Olaf Taesch mailto:[EMAIL PROTECTED] or mailto:[EMAIL PROTECTED] -- 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] 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/2001, Rick Emery wrote: 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 (XXXVIII). -Original Message- From: Robert Gormley [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 09, 2001 1:18 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Parsing of db results by PHP Hi all, I have a MySQL db which contains table test, field test... one of the entries is ? external($url, $text); ? Where external() is a function i've written which outputs simple text. I want to be able to put calls to this function into the database, and have them parsed on rendering... With the above example, the raw code is just spat to the browser, and doesn't hit the interpreter. Any ideas? Regards, Robert Robert Gormley [EMAIL PROTECTED] http://seabreeze.asn.au/ -- 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] Robert Gormley [EMAIL PROTECTED] http://seabreeze.asn.au/ -- 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] 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 editing filemaker databases using PHP... But the php.net manual states: Chapter 29. Connecting to databases This section holds common questions about relation between PHP and databases : Yes, PHP can acces virtually any database available today. http://www.php.net/manual/en/faq.databases.php Has anyone been able to do this? Or could you point me in the right direction for some tutorials or assistance. Joel Mills Newcastle College -- 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] 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 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 typ: OCIbindbyname($stmt, :P13, $arr,-1); - Warning: Array to string conversion in x on line y call with OCI_B_CURSOR: OCIbindbyname($stmt, :P13, $arr,1,OCI_B_CURSOR); - Warning: Supplied argument is not a valid OCI8-Statement resource in x on line y call with OCI_B_TABLE: OCIbindbyname($stmt, :P13, $arr,1,OCI_B_TABLE); - Warning: Use of undefined constant OCI_B_TABLE - assumed 'OCI_B_TABLE' in x on line y I got the same message with parameters: OCI_B_ARRAY, OCI_B_VARRAY and any other typs Is this not possible with the current version? regards Olaf Taesch mailto:[EMAIL PROTECTED] or mailto:[EMAIL PROTECTED] -- 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 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] 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. - Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger.
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 Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Danny Nguyen [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 1:04 PM To: [EMAIL PROTECTED] Subject: [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. - Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. -- 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] 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://extreme.nas.net -- 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] 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 makes and installs fine. Then I start httpd ok but it won't create a connection to the database. Is this because I'm using apxs? Do I have to do it statically. Can't see anything about it being a problem but I can't think of anything else. Any ideas? (I can create a connection to the database using sqlplus and the variables I've set in php for the password and name etc. so I'm pretty sure my client and server installations are ok). Thanks, Simon. -- 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] 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 license and we will provide free support if you run into problems. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Danny Nguyen [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 1:04 PM To: [EMAIL PROTECTED] Subject: [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. - Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. - Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger.
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 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 Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Danny Nguyen [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 1:04 PM To: [EMAIL PROTECTED] Subject: [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. - Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. - Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger.
[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 an error! any ideas please thanks a lot Bona __ Visite http://www.trama.com.br -- 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] 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 result (should be the first line) which says HTTP/1.0 404 Not Found, then your Content-type: will come across and the actual HTML for the 404 page. You'll have to parse the domain name off the entire URL that's stored in your database which could be done by chopping off a leading http://; if any is provided, then split at the first / mark. Use the experimental socket() function (http://www.php.net/manual/en/function.socket.php) to make your connection and issue the HEAD request. Hope that helps... Justin Buist Trident Technology, Inc. 4700 60th St. SW, Suite 102 Grand Rapids, MI 49512 Ph. 616.554.2700 Fx. 616.554.3331 Mo. 616.291.2612 On Sat, 8 Sep 2001, Larry RedCobra Linthicum wrote: I have a database with lots of urls stored I would like to build a script the retrieves them ... then somehow checks each one to see if the link produces a error 404 and is no longer good, then ideally write a file of bad links for me this seems like it would be possible with PHP, could someone give me some hints on where to start? I know very little about http headers and such any information will be appreciated -- 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 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] 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 (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] 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 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 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 Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Danny Nguyen [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 1:04 PM To: [EMAIL PROTECTED] Subject: [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. - Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. - Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. -- 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] 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.3 the internet provider is checked, fast and good. i know this because on this internet connection is linked another server (rather low traffic) and it works non-stop. this problem grow every day. the problem is that this server disapears for few minutes, and then it apears again. it happens only in hours of main usage (i know it from hourly satistics). when it apears it works rather fast. the problem is growing every month because our statistics go up. when the server stops none of the installed services works. and what is amazing there is no errors nor warnings in the logs. i was wondering if its is because of mysql or other service installed on the server. has anyone the same problem in the past? what is the reason? please help. -- 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] 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, 256 Mb RAM, ABIT KT7-RAID, Intel Ether Express 100+). operating system hPF is FreeBSD 4.3 hPF the internet provider is checked, fast and good. i know this because on this hPF internet connection is linked another server (rather low traffic) and it works hPF non-stop. hPF this problem grow every day. the problem is that this server disapears for few hPF minutes, and then it apears again. it happens only in hours of main usage (i hPF know it from hourly satistics). when it apears it works rather fast. the problem hPF is growing every month because our statistics go up. when the server stops none hPF of the installed services works. and what is amazing there is no errors nor hPF warnings in the logs. It could be a lot of things; just some random things to check mysqladmin extended-status might give you an idea of things going on, doublecheck the uptime value, is it the same as the uptime of the machine? sometimes mysql crashes and restarts itself. It could take minutes before the databaseserver is back. This could be your problem. You can also check processes within myqsl with mysqladmin processlist Further the unix: is it tuned? FreeBSD out of the box is good but it can be tuned quite a bit, I've run sites on similar hardware with 1000+ users hitting the server more or less at the same time with a mysql based web-application. The box was tuned quite a bit but could handle the load without any problems. Doublecheck your application and database design, sometimes adding an index can increase performance 100x. If you need more info let me know... Brgds hPF i was wondering if its is because of mysql or other service installed on the hPF server. has anyone the same problem in the past? what is the reason? please hPF help. -- Paul Jongsma WEBtic Internet Consultancy @ http://www.webtic.nl/ Change is inevitable, except from vending machines. -- 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] 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: Monday, September 10, 2001 2:55 PM To: [EMAIL PROTECTED] Subject: [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 the code I used, but I get the values as a single entry no matter what I try. This query brings a single result row name1, name2, name3, name4. Here's the code: $result4 = mysql_query( SELECT DCD_Access FROM userdb WHERE ID = '$user_ID'); $DCD = mysql_fetch_array ( $result4 ); print td width='6%' valign=top\n div align='center'\n select name='LCompare'\n option value='none'None/option\n option value='within'Within Gel/option\n; foreach ( $DCD as $val ) { print option value='$val'$val/option\n; } print/select/div\n /td\n; This returns HTML like: td width='6%' valign=top div align='center' select name='LCompare' option value='none'None/option option value='within'Within Gel/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option /select /div /td What I need is to get: td width='6%' valign=top div align='center' select name='LCompare' option value='none'None/option option value='within'Within Gel/option option value='name1'name1/option option value='name2'name2/option option value='name3'name3/option option value='name4'name4/option /select /div /td Anyone know how to fix this? Robert -- 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 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] 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 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 the code I used, but I get the values as a single entry no matter what I try. This query brings a single result row name1, name2, name3, name4. Here's the code: $result4 = mysql_query( SELECT DCD_Access FROM userdb WHERE ID = '$user_ID'); $DCD = mysql_fetch_array ( $result4 ); print td width='6%' valign=top\n div align='center'\n select name='LCompare'\n option value='none'None/option\n option value='within'Within Gel/option\n; foreach ( $DCD as $val ) { print option value='$val'$val/option\n; } print/select/div\n /td\n; This returns HTML like: td width='6%' valign=top div align='center' select name='LCompare' option value='none'None/option option value='within'Within Gel/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option /select /div /td What I need is to get: td width='6%' valign=top div align='center' select name='LCompare' option value='none'None/option option value='within'Within Gel/option option value='name1'name1/option option value='name2'name2/option option value='name3'name3/option option value='name4'name4/option /select /div /td Anyone know how to fix this? Robert -- 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 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] 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 - Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger.
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' architecture. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Danny Nguyen [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 4:28 PM To: [EMAIL PROTECTED] Subject: 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 - Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. -- 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] 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:30 PM To: Rick Emery Subject: Re: [PHP-DB] reading arrays within a field from mysql and separating the values Rick, I tried it and it made no difference. Could you give me a more complete example? Thanks for the help. Robert - Original Message - From: Rick Emery [EMAIL PROTECTED] To: 'Robert Trembath' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 10, 2001 3:03 PM Subject: 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 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 the code I used, but I get the values as a single entry no matter what I try. This query brings a single result row name1, name2, name3, name4. Here's the code: $result4 = mysql_query( SELECT DCD_Access FROM userdb WHERE ID = '$user_ID'); $DCD = mysql_fetch_array ( $result4 ); print td width='6%' valign=top\n div align='center'\n select name='LCompare'\n option value='none'None/option\n option value='within'Within Gel/option\n; foreach ( $DCD as $val ) { print option value='$val'$val/option\n; } print/select/div\n /td\n; This returns HTML like: td width='6%' valign=top div align='center' select name='LCompare' option value='none'None/option option value='within'Within Gel/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option /select /div /td What I need is to get: td width='6%' valign=top div align='center' select name='LCompare' option value='none'None/option option value='within'Within Gel/option option value='name1'name1/option option value='name2'name2/option option value='name3'name3/option option value='name4'name4/option /select /div /td Anyone know how to fix this? Robert -- 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 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 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] 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, September 10, 2001 3:53 PM To: Rick Emery Subject: Re: [PHP-DB] reading arrays within a field from mysql and separating the values The same as my original message. - Original Message - From: Rick Emery [EMAIL PROTECTED] Newsgroups: php.db To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 3:40 PM Subject: 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:30 PM To: Rick Emery Subject: Re: [PHP-DB] reading arrays within a field from mysql and separating the values Rick, I tried it and it made no difference. Could you give me a more complete example? Thanks for the help. Robert - Original Message - From: Rick Emery [EMAIL PROTECTED] To: 'Robert Trembath' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 10, 2001 3:03 PM Subject: 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 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 the code I used, but I get the values as a single entry no matter what I try. This query brings a single result row name1, name2, name3, name4. Here's the code: $result4 = mysql_query( SELECT DCD_Access FROM userdb WHERE ID = '$user_ID'); $DCD = mysql_fetch_array ( $result4 ); print td width='6%' valign=top\n div align='center'\n select name='LCompare'\n option value='none'None/option\n option value='within'Within Gel/option\n; foreach ( $DCD as $val ) { print option value='$val'$val/option\n; } print/select/div\n /td\n; This returns HTML like: td width='6%' valign=top div align='center' select name='LCompare' option value='none'None/option option value='within'Within Gel/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option option value='name1, name2, name3, name4'name1, name2, name3, name4/option /select /div /td What I need is to get: td width='6%' valign=top div align='center' select name='LCompare' option value='none'None/option option value='within'Within Gel/option option value='name1'name1/option option value='name2'name2/option option value='name3'name3/option option value='name4'name4/option /select /div /td Anyone know how to fix this? Robert -- 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 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 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] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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! John -- 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] 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 additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 test) to an Oracle placeholder, which is denoted by a preceding colon. e.g., $sql = INSERT INTO emp (ename) VALUES (:ename_placeholder);; $stmt = OCIParse($conn, $sql); OCIBindByName($stmt,:ename_placeholder,$empno,32); $empno = Bona; OCIExecute($stmt, OCI_DEFAULT); Please let me know if this makes sense, Anthony Carlos From: [EMAIL PROTECTED] Date: Mon, 10 Sep 2001 11:10:04 -0800 To: [EMAIL PROTECTED] Subject: [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($controle).BR; } $result1 = OCIExecute ($controle); I tryed $comando1 using begin and without the exec... with and without the ; on the end... but I allways have the same message: Invalid SQL Command... can anybody help me??? thanks Bona __ Visite http://www.trama.com.br -- 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 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]