RE: [PHP-DB] Query help
This doesn't work either. SELECT count(freerooms.room), WEEK(MAX(booking.date),1), WEEK(MIN(booking.date),1) as total FROM freerooms LEFT JOIN booking USING(room); All good so far now if I run this SELECT count(f.room),WEEK(MAX(b.date),1), WEEK(MIN(b.date),1) FROM freero oms f, booking b; -+---+-+-+ | count(f.room) | WEEK(MAX(b.date),1) | WEEK(MIN(b.date),1) | +---+-+-+ | 24817 | 48 | 40 | +---+-+-+ What I have found is freerooms.room has 83 rows and booking has 299. The value returned for count(f.room) is these two figures multiplied.??? Why would it do this? And how can I get it to return the real value only Regards M: -- 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] MS SQL Server support
I got this error message when using PHP 4.06 with MSSQL. PHP ERROR: PHP build incomplete: the prerequisite MS SQL Server support required to read the alert database was not built into PHP. Please recompile PHP with the necessary library (--enable-mssql). Is there anyone who knows what's wrong? /Daniel -- 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] MS SQL Server support
You need to recompile PHP with --enable-mssql=path/to/some/files or something like that as php does not come with support for mssql default. Read the INSTALL file that came with the sources or run, in the php source directory, ./configure -help for all the switches. //Richard -Original Message- From: Daniel Persson [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 2:35 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MS SQL Server support I got this error message when using PHP 4.06 with MSSQL. PHP ERROR: PHP build incomplete: the prerequisite MS SQL Server support required to read the alert database was not built into PHP. Please recompile PHP with the necessary library (--enable-mssql). Is there anyone who knows what's wrong? /Daniel -- 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] ORA-24365
I have following problem when I moved my PHP scripts from Windows IIS hosting to Linux Apache. Scripts are unchanged, all connections to database are working but when I try to execute simple StoreProcedure on Oracle, I'm getting this error: Warning: OCIStmtExecute: ORA-24365: error in character conversion in /usr/local/apache-novi/htdocs/broadcast.php on line 32 This is what I'm trying to execute. begin :ret_val := PKAccount.AlterAccount( 1, '|LOGIN|avarga|PASSWORD|b|', :outstr ); end; Thnx, Alex -- 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] ORA-24365
This might help... 24365, 0, error in character conversion // *Cause: This usually occurs during conversion of a multibyte // character data when the source data is abnormally terminated // in the middle of a multibyte character. // *Action: Make sure that all multibyte character data is properly terminated. From: Alex [EMAIL PROTECTED] Reply-To: Alex [EMAIL PROTECTED] Date: Mon, 19 Nov 2001 15:37:01 +0100 To: [EMAIL PROTECTED] Subject: [PHP-DB] ORA-24365 I have following problem when I moved my PHP scripts from Windows IIS hosting to Linux Apache. Scripts are unchanged, all connections to database are working but when I try to execute simple StoreProcedure on Oracle, I'm getting this error: Warning: OCIStmtExecute: ORA-24365: error in character conversion in /usr/local/apache-novi/htdocs/broadcast.php on line 32 This is what I'm trying to execute. begin :ret_val := PKAccount.AlterAccount( 1, '|LOGIN|avarga|PASSWORD|b|', :outstr ); end; Thnx, Alex -- 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] Query help
Hi, I haven't seen the previous posts so I'm not sure want you want to do, but it looks like that you need to specify a join condition. If freerooms.room and booking.room are the corresponding fields from your table the query should look something like this SELECT count(freerooms.room), WEEK(MAX(booking.date),1), WEEK(MIN(booking.date),1) as total FROM freerooms LEFT JOIN booking ON freerooms.room=booking.room USING(room); or SELECT count(f.room),WEEK(MAX(b.date),1), WEEK(MIN(b.date),1) FROM freerooms f, booking b WHERE f.room=b.room Hope this helps Dobromir Velev -Original Message- From: Matt Williams [EMAIL PROTECTED] To: Andrey Hristov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Monday, November 19, 2001 10:26 Subject: RE: [PHP-DB] Query help This doesn't work either. SELECT count(freerooms.room), WEEK(MAX(booking.date),1), WEEK(MIN(booking.date),1) as total FROM freerooms LEFT JOIN booking USING(room); All good so far now if I run this SELECT count(f.room),WEEK(MAX(b.date),1), WEEK(MIN(b.date),1) FROM freero oms f, booking b; -+---+-+-+ | count(f.room) | WEEK(MAX(b.date),1) | WEEK(MIN(b.date),1) | +---+-+-+ | 24817 | 48 | 40 | +---+-+-+ What I have found is freerooms.room has 83 rows and booking has 299. The value returned for count(f.room) is these two figures multiplied.??? Why would it do this? And how can I get it to return the real value only Regards M: -- 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] ORA-24365
Very strange, as I'm just submitting this data trough HTML form tag. Coud it be encoding of PHP? Alex Anthony Carlos [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... This might help... 24365, 0, error in character conversion // *Cause: This usually occurs during conversion of a multibyte // character data when the source data is abnormally terminated // in the middle of a multibyte character. // *Action: Make sure that all multibyte character data is properly terminated. From: Alex [EMAIL PROTECTED] Reply-To: Alex [EMAIL PROTECTED] Date: Mon, 19 Nov 2001 15:37:01 +0100 To: [EMAIL PROTECTED] Subject: [PHP-DB] ORA-24365 I have following problem when I moved my PHP scripts from Windows IIS hosting to Linux Apache. Scripts are unchanged, all connections to database are working but when I try to execute simple StoreProcedure on Oracle, I'm getting this error: Warning: OCIStmtExecute: ORA-24365: error in character conversion in /usr/local/apache-novi/htdocs/broadcast.php on line 32 This is what I'm trying to execute. begin :ret_val := PKAccount.AlterAccount( 1, '|LOGIN|avarga|PASSWORD|b|', :outstr ); end; Thnx, Alex -- 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] PHP and MS SQL 2000 Performance
We're running W2K, IIS 5, PHP 4, and SQL Server 2000 and performance seems to be really slow. We're using a simple connect PHP script to query a table that has only 1 record in it, and it takes approximately 20 seconds to load. This seems to be very slow. Is this normal or does anyone have suggestions how to speed things up? Thanks! -- 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] PHP and MS SQL 2000 Performance
I run SQL Server on my Pentium III 800mhz laptop which also runs IIS 5 and a variety of other services (including the PHP cgi) and have not seen any type of performance problems. First, are you using the mssql.dll to connect or ODBC? Second, are you running PHP as a cgi or ISAPI plug-in? Third, is performance from an ODBC client and/or remote Query Analyzer client slow performing the same queries? Fourth, did you check your SQL Server box and look at the activity on it? Is SQL Server or some other service hogging resources? Thanks, Joshua Hoover We're only running one database on the system. The sample databases that come with the software are still on there, but they're not being used at all - this system is still in the testing stage. We're running an Athlon 1.2 GHz processor with 512 MB RAM. Gadam [EMAIL PROTECTED] wrote in message 001c01c170b4$266aeb50$0100a8c0@fintani">news:001c01c170b4$266aeb50$0100a8c0@fintani... MS SQL has generally very slow performance and is consuming a lot of system resources. Are you running any other databases on the SQL server, apart from the one you are querying? Could it be that your system has very small processing power? In any case, these possibilities wouldn't justify suck a long delay, unless you SQL server is overcrowded with other huge databases that you use... George -- 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] PHP and MS SQL 2000 Performance
Are you using ODBC? We recently had similar problems, and it turned out that we had SQL tracing enabled, and every single ODBC function call was being written to SQL.LOG, slowing things down, so a simple query took 7 minutes. Joshua Hoover [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I run SQL Server on my Pentium III 800mhz laptop which also runs IIS 5 and a variety of other services (including the PHP cgi) and have not seen any type of performance problems. First, are you using the mssql.dll to connect or ODBC? Second, are you running PHP as a cgi or ISAPI plug-in? Third, is performance from an ODBC client and/or remote Query Analyzer client slow performing the same queries? Fourth, did you check your SQL Server box and look at the activity on it? Is SQL Server or some other service hogging resources? Thanks, Joshua Hoover We're only running one database on the system. The sample databases that come with the software are still on there, but they're not being used at all - this system is still in the testing stage. We're running an Athlon 1.2 GHz processor with 512 MB RAM. Gadam [EMAIL PROTECTED] wrote in message 001c01c170b4$266aeb50$0100a8c0@fintani">news:001c01c170b4$266aeb50$0100a8c0@fintani... MS SQL has generally very slow performance and is consuming a lot of system resources. Are you running any other databases on the SQL server, apart from the one you are querying? Could it be that your system has very small processing power? In any case, these possibilities wouldn't justify suck a long delay, unless you SQL server is overcrowded with other huge databases that you use... George -- 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] fopen ; fstat
Hi everybody!!
Does anybody know how to use fopen and fstat!
I used it on local files and refered files on the own server, but it doesn't
show (e.g. the filesize) of my server with the downloadfiles, which is not
the same server the php files are on!
I've also added the source code, so please help me if you can!!
Thanx!!
Mister16
?php
$file = fopen (http://www.ganymede.spaceports.com/~mister16/2inseln.exe;,
r); echo Datei geladen!!br;
$t=fstat($file); echo Array über Funktion zugewiesenbr;
print $t[size]; echo Info ausgegeben!br;
fclose ($file); echo Datei geschlossen!br;
/*if ($t = 100) {
$t = $t / 100;
$t = round($t,3);
echo $t MB;
}
elseif ($t = 1000) {
$t = $t / 1000;
$t = round($t,3);
echo $t KB;
}
else {
$t = round($t,3);
echo $t Byte(s);
};*/
?
--
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] PHP and MS SQL 2000 Performance
First, are you using the mssql.dll to connect or ODBC? Using mssql.dll Second, are you running PHP as a cgi or ISAPI plug-in? As a CGI under the Home Directory tab Third, is performance from an ODBC client and/or remote Query Analyzer client slow performing the same queries? Performance from the Query Analyzer is extremely fast - pulls up 2000 records in like 3 seconds. Fourth, did you check your SQL Server box and look at the activity on it? Is SQL Server or some other service hogging resources? SQL Server is taking up about 40MB of memory, but not much of anything else going on. Thanks, Michael Thanks, Joshua Hoover We're only running one database on the system. The sample databases that come with the software are still on there, but they're not being used at all - this system is still in the testing stage. We're running an Athlon 1.2 GHz processor with 512 MB RAM. Gadam [EMAIL PROTECTED] wrote in message 001c01c170b4$266aeb50$0100a8c0@fintani">news:001c01c170b4$266aeb50$0100a8c0@fintani... MS SQL has generally very slow performance and is consuming a lot of system resources. Are you running any other databases on the SQL server, apart from the one you are querying? Could it be that your system has very small processing power? In any case, these possibilities wouldn't justify suck a long delay, unless you SQL server is overcrowded with other huge databases that you use... George -- 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] PHP and MS SQL 2000 Performance
I'm using the php_mssql.dll extension/connection. John Lim [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Are you using ODBC? We recently had similar problems, and it turned out that we had SQL tracing enabled, and every single ODBC function call was being written to SQL.LOG, slowing things down, so a simple query took 7 minutes. Joshua Hoover [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I run SQL Server on my Pentium III 800mhz laptop which also runs IIS 5 and a variety of other services (including the PHP cgi) and have not seen any type of performance problems. First, are you using the mssql.dll to connect or ODBC? Second, are you running PHP as a cgi or ISAPI plug-in? Third, is performance from an ODBC client and/or remote Query Analyzer client slow performing the same queries? Fourth, did you check your SQL Server box and look at the activity on it? Is SQL Server or some other service hogging resources? Thanks, Joshua Hoover We're only running one database on the system. The sample databases that come with the software are still on there, but they're not being used at all - this system is still in the testing stage. We're running an Athlon 1.2 GHz processor with 512 MB RAM. Gadam [EMAIL PROTECTED] wrote in message 001c01c170b4$266aeb50$0100a8c0@fintani">news:001c01c170b4$266aeb50$0100a8c0@fintani... MS SQL has generally very slow performance and is consuming a lot of system resources. Are you running any other databases on the SQL server, apart from the one you are querying? Could it be that your system has very small processing power? In any case, these possibilities wouldn't justify suck a long delay, unless you SQL server is overcrowded with other huge databases that you use... George -- 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] Counting Instances of Pattern Within Single Cell
Is there a way to count the number of instances of a pattern within a single cell? This would then allow me to rank the results of my searches. Thanks Chris Busch -- 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] Re: PHP and MS SQL 2000 Performance
I figured out what the problem was. I'm behind a Linksys router. The IP address put in the script was for what comes into the one port, which then goes into the router. Instead of using that address I changed it to 127.0.0.1 since the script is on the db server. Now everything works extremely fast! Thanks everyone for your help/suggestions! Michael Kroiss [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... We're running W2K, IIS 5, PHP 4, and SQL Server 2000 and performance seems to be really slow. We're using a simple connect PHP script to query a table that has only 1 record in it, and it takes approximately 20 seconds to load. This seems to be very slow. Is this normal or does anyone have suggestions how to speed things up? Thanks! -- 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] MSSQL 2000 and PHP on Linux..
Hello, From the PHP site I read that I may use the Sybase libraries to connect to a MS SQL server using PHP. Then reading over the Sybase documentation I got lost. Do I have to install/configure Sybase in order to compile PHP with sybase support? Or are there some basic libraries that I can install just to compile PHP? Or is there an alternative on how to connect to a MsSQL 2000 from Linux? Thanks Marcelo -- 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] MSSQL 2000 and PHP on Linux..
Marcelo, You can use the sybase or free tds libraries, per the configuration options, e.g. --with-option. Check the install docs for the libraries you will need (e.g. ct-lib, tds). Another option is ODBC. Here you can link --with-iodbc using the SDK from www.iodbc.org, and drivers from www.openlinksw.com. You will get better support for SQLServer2000 (e.g. datatypes) via ODBC than if you use either option above. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Marcelo [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 3:33 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MSSQL 2000 and PHP on Linux.. Hello, From the PHP site I read that I may use the Sybase libraries to connect to a MS SQL server using PHP. Then reading over the Sybase documentation I got lost. Do I have to install/configure Sybase in order to compile PHP with sybase support? Or are there some basic libraries that I can install just to compile PHP? Or is there an alternative on how to connect to a MsSQL 2000 from Linux? Thanks Marcelo -- 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] PostgreSql query help....
Hi everybody:
I would like to ask why the error occur when retrieve current sequence
number. Eg. select currval('student_id_seq') is not working, and warning
prompt student_id_seq.currval is not yet defined in this session.
However, this is work for the select nextval();
do anyone know how to get current sequence number, in php. Thank for your
help
Vincent Ma
--
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]
[Fwd: [PHP-DB] PHP Binaries for Solaris 8]
In this case, if there aren't any binaries for Solaris 8, how do you compile it under Solaris 8? ---BeginMessage--- How can you download PHP binaries for Solaris 8? Can't seem to find it on php.net, and some other sites. -- 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] ---End Message--- -- 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] Re: No Caching (Reloading Fresh Content)
http://php.weblogs.com/stories/storyReader$550 Jonathan Hilgeman [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... How can I ensure that a specific page is never cached and ALWAYS gets processed every time it is viewed? Sometimes a viewer can hit his/her browser's Back button (such a hateful button), and get a cached version of a dynamic page. I want this page's PHP code to be executed even if the visitor uses their Back button to get to the page. Any thoughts on how to do this? - Jonathan -- 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] Re: PHP and MSSQL using APACHE
www.iodbc.org Adv. Systems Design [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hello all: Just have been tasked to port an app created on (linux)php/mysql/apache to run (on Win2K) php/mssql/apache. Any links with info on setting up mssql to work with php and apache (all on win2k) appreciated! Luis __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.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]
