RE: [PHP] phpMyAdmin problem...
A couple of things: does mysql accept remote locations? iow, is your host set? further: always flush privileges :) But first, add a user, host: webserver, user foo, pass bar (whatever ;)) flush it and try again. - Kees -Original Message- From: Philip Jeffs [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 2:43 PM To: [EMAIL PROTECTED] Subject: [PHP] phpMyAdmin problem... Hi, I've got a MySQL problem. I'm running MySQL on my local machine and my web server (housed elsewhere). I need to use phpMyAdmin to administer the databases on my local machine and my remote server. I've set the config in phpMyAdmin to connect to both servers, but when i try to administer the remote server, i get an accessed denied message. I've tried using my root username and password and i have also created a new user with full privileges. Neither of these user/pass combinations allows me to get in. The remote machine is running 2000 server with IIS 5. The local machine is windows 2000 with IIS 5. Any help would be good. Thanks, Phil. - Philip Jeffs The Tickle Group The Gate House Summerseat Bury Lancashire BL9 5PE United Kingdom W: http://www.tickle.co.uk T: 01706 823456 F: 01706 829500 E: [EMAIL PROTECTED] (daytime) [EMAIL PROTECTED] (evening) - - Philip Jeffs The Tickle Group The Gate House Summerseat Bury Lancashire BL9 5PE United Kingdom W: http://www.tickle.co.uk T: 01706 823456 F: 01706 829500 E: [EMAIL PROTECTED] (daytime) [EMAIL PROTECTED] (evening) - -- PHP General 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] php switch() problem
hey use exit; instead of break; break breaks the switch statement and continues with the code below, exit exits the script (en doesnt execute any code below the switch statement) Kees -Original Message- From: Ann Jamison [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 1:44 PM To: [EMAIL PROTECTED] Subject: [PHP] php switch() problem -- PHP General 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] String breaking up
Strings are arrays, so you can print out a string by doing something like
this:
Yups, this is possible, but i think he wants to have a newline for each
character,
you can doe this excelent with a small addition to your example:
$string = hey there!;
for ($i=0; $icount($string); $i++) {
echo strtoupper($string[$i]);
}
becomes:
$string = hey there!;
for ($i=0; $icount($string); $i++) {
echo $string[$i]\n; // or br if you want to use HTML
}
Kees
--
PHP General 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] Apache, FreeBSD PHP
Lectori Salutem, I have apache 1.3.20 running with php 4.0.6 on an freebsd 4.3 server. It is a busy server, serving more than 400k PHP-pages daily. I have a few troubles with it; first Apache is generating large errorlog files filled with httpd in free(): warning: recursive call. and httpd in free(): warning: chunk is already free.. (more than 25M errors per week) I searched the internet and several mailinglist archives but didn't find an useable solution. Does anyone know what is causing this, or does anyone has a solution to it, because the server is at the moment a bit unstable. Tia, Kees Hoekzema -- PHP General 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] MySQL query length
You can alter the packetsize mysql will accept, you can find out the current setting with a show variables query, look for the max_allowed_packet var. You can alter it in your my.cnf file. (i have it on 25M atm). - Kees -Original Message- From: Niklas Lampén [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 8:51 AM To: Php-General Subject: [PHP] MySQL query length Can it cause any problems if mySQL query is very long? I have to compare many words to many fields in my DB and I've done it like Field LIKE '%searchword%' || Field LIKE '%searchword%' || Field LIKE '%searchword%'.. Query is build by a function, so I don't know the exact length but it is VERY long. I also have to compare several words to one field so I've done many of those Field LIKE '%blah%' for those too. Is there any smarter way to do this? Niklas Lampén Internet Developer PubliCo Oy Ruoholahdenkatu 8 A FIN-00180 HELSINKI P. +358 - 9 - 6866 2541 F. +358 - 9 - 685 2940 E. [EMAIL PROTECTED] W. www.finlandexports.com -- PHP General 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] 2 NEWBIE QUESTIONS
hey, 1) Is there any PHP command that'll convert a MySQL database timestamp into a format that humans can read?!! For example, I want to change 20010822001245 into 00:12.45 on the 22-08-2001? take a look at: http://www.php.net/manual/en/function.date.php 2) This is the hard question. I have a script that gets values from a database and then includes a php page which contains echo $variable code to get the values from the database onto the page. What I want to do is have the PHP page code in the main script instead of being included externally. So i tried putting the code into a variable and then including, but it didnt work. Then I tried echoing the variable but the PHP code isnt executed. and take a look at: http://www.php.net/manual/en/function.eval.php sincerly, - Kees Hoekzema -- PHP General 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] converting numeric to a string
hey, this function does not exists. An interger can be treated as string without any problems, see also: http://www.php.net/manual/en/language.types.string.php#language.types.string .conversion Kees -Original Message- From: Don [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 6:35 PM To: php list Subject: [PHP] converting numeric to a string Hi, I'm looking at the 'String' section of the online documentation. I cannot find a function that converts a numeric to a string, e.g., 1 -- 1. Am I blind or does this not exist? Thanks, Don -- PHP General 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 General 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] PHP.... i suck at it
I think you want this: ?php echo IP ADDRESS \n; echo $remote_admin; ? \n is the newline code. so a double newline will look like: echo IP ADDRESS \n\n; Kees Hoekzema -Original Message- From: Kyle Smith [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 2:47 AM To: [EMAIL PROTECTED] Subject: [PHP] PHP i suck at it -- PHP General 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] PHP shell scripting..
Hello Ryan, You can use environment variables for that, like: echo $HOME; /* Shows the HOME environment variable, if set. */ You can also use getenv() en putenv() see also: http://nl.php.net/manual/en/language.variables.external.php hope it works :) - Kees -Original Message- From: Ryan Christensen [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 22, 2001 8:19 PM To: [EMAIL PROTECTED] Subject: [PHP] PHP shell scripting.. I have some questions about using PHP as a shell scripting language... mainly how you pass arguments to a script on the command line. Say I'm using: -- #!/usr/local/bin/php -q ? print I am: $name\n; ? -- How do I define test from the command line (as an argument while executing the script)? Thanks in advance for the help! - Ryan Christensen -- PHP General 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 General 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] Automatic survey
Hey Ryan Look at this :) http://nl.php.net/manual/en/function.mail.php so a thing like: mail([EMAIL PROTECTED], My Own Subject, \ IP:\n$REMOTE_ADDR\n \ Port Number:\n$REMOTE_PORT\n \ System info:\n$HTTP_USER_AGENT\n \ Last page visited in this window\nHTTP_REFERER\n); should do the trick :) Hope it helps, -Kees -Original Message- From: Kyle Smith [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 3:44 AM To: [EMAIL PROTECTED] Subject: [PHP] Automatic survey I have made a small page containing the following PHP ?php echo Ip addressBR; echo $REMOTE_ADDR; echo BRBRPort numberBR; echo $REMOTE_PORT; echo BRBRSystem infoBR; echo $HTTP_USER_AGENT; echo BRBRLast page visited in this windowBR; echo $HTTP_REFERER; ? is there any way i can make the PHP file email me the info above without revealing the users address, if so, what should i add to the code? (dont worry im only using the code above as a tester, as you can tell im not a hacker) -legokiller666- http://www.StupeedStudios.f2s.com New address new site ICQ: 115852509 MSN: [EMAIL PROTECTED] AIM: legokiller666 -- PHP General 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] PHP shell scripting..
Hello Ryan, Let me give you an example :) Lets use your script, #!/usr/local/bin/php -q ? print I am: $name\n; ? i called it echo-name.php and chmod 755 it. Next, im going to call it: -- Athena:~$ name=kees Athena:~$ ./echo-naam I am: kees -- So the trick is to set the variable BEFORE you call the script you can see all variables already used by linux with set you'll get something like this: -- Athena:~$ set BASH=/bin/bash BASH_VERSINFO=([0]=2 [1]=03 [2]=0 [3]=1 [4]=release [5]=i386-slackware-linux-gnu) BASH_VERSION='2.03.0(1)-release' COLUMNS=80 DIRSTACK=() (...snip...) TERM=xterm UID=1034 USER=kees _=./echo-naam file=/etc/profile.d/tetex.sh ignoreeof=10 name=kees - As you can see, our variable name is there, and it is set. to set a variable, simply type this at the commandline (or script) - variable=value --- where variable is your variable and value your value :) Good luck :) -Kees -Original Message- From: Ryan Christensen [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 22, 2001 8:30 PM To: 'Kees Hoekzema' Subject: RE: [PHP] PHP shell scripting.. I'm slightly confused as to how I would run this from a shell though.. what would I enter in the command line then? - Ryan Christensen (mail) [EMAIL PROTECTED] (cell) 360-808-1506 -Original Message- From: Kees Hoekzema [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 22, 2001 11:27 AM To: Ryan Christensen; [EMAIL PROTECTED] Subject: RE: [PHP] PHP shell scripting.. Hello Ryan, You can use environment variables for that, like: echo $HOME; /* Shows the HOME environment variable, if set. */ You can also use getenv() en putenv() see also: http://nl.php.net/manual/en/language.variables.external.php hope it works :) - Kees -Original Message- From: Ryan Christensen [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 22, 2001 8:19 PM To: [EMAIL PROTECTED] Subject: [PHP] PHP shell scripting.. I have some questions about using PHP as a shell scripting language... mainly how you pass arguments to a script on the command line. Say I'm using: -- #!/usr/local/bin/php -q ? print I am: $name\n; ? -- How do I define test from the command line (as an argument while executing the script)? Thanks in advance for the help! - Ryan Christensen -- PHP General 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 General 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] php-4.0.6, zlib, gd problem
Lectori Salutem, I downloaded php-4.0.6 yesterday, and i was trying to compile it, I used to compile previous versions with: ./configure --with-apache=../apache --enable-track-vars --enable-magic-quote s --with-gd=/usr/local --with-mysql=../mysql --with-zlib=../zlib but when i try it with php-406, i'll get this error: checking if the location of ZLIB install directory is defined... no checking whether to include ZLIB support... yes configure: error: Cannot find libz This isn't a big problem, using --with-zlib it wil configure compile, but i found it strange anyway. Next problem is with gd, i'm using it to create .png's, which worked fine with previous php's, but this time it won't compile with built-in .png support, ./configure says: checking for gdImageString16 in -lgd... yes checking for gdImagePaletteCopy in -lgd... yes checking for gdImageCreateFromPng in -lgd... no checking for gdImageCreateFromGif in -lgd... no this is bad ;) So i recompiled gd-1.3.8, and zlib-1.1.3, with libpng-1.0.10 and jpeg-6b, still it is a no-go, so i have to stick with php-405 until this is solved, i hope someone has a solution, or otherwise i have to keep trying ;-) tia, Kees Hoekzema Serveradmin http://www.webmagix.net http://www.tweakers.net http://www.fokzine.net -- PHP General 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] php-4.0.6, zlib, gd problem
LS, -Original Message- From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 24, 2001 5:01 PM To: Kees Hoekzema Cc: [EMAIL PROTECTED] Subject: Re: [PHP] php-4.0.6, zlib, gd problem First, use absolute dirs, not relative dirs. ok, that solved the first problem, next one :) I'm trying to use gd-2.0.1, because of the better features, so i compile with: ./configure --with-apache=/usr/src/apache --enable-track-vars --enable-magic-quotes --with-gd=/usr/src/gd2 --with-mysql=/usr/src/mysql --with-zlib=/usr/local --with-jpeg-dir=/usr/src/jpeg --with-png-dir=/usr/src/libpng which configures compiles fine, after i link: ln /usr/src/gd2/libgd.so.2.0.0 /usr/src/gd2/libgd.so But.. i'll get a nice error when using gd-2.x functions.. Fatal error: imagecopyresampled(): requires GD 2.0 or later in /www/test/pwchart.dsp on line 213 it isn't an urgent question, but i hate it when it can't compile the way it should be ;) - Kees -- PHP General 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] back again!!!
yeah, the 5000 emails in my inbox monthly ;) thanks for fixing it Rasmuss :) - Kees -Original Message- From: Jochen Kaechelin [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 10:14 PM To: PHP General Subject: [PHP] back again!!! great - something is missing without this mailing list! -- phpArbeitsgruppe in Gruendung - Jochen Kaechelin Stuttgarter Str.3, D-73033 Goeppingen Tel. 07161-92 95 94, Fax 07161-92 95 98 http://www.php-arbeitsgruppe.de, mailto:[EMAIL PROTECTED]
RE: [PHP] converting int to char
Hey, take a look at: http://www.php.net/manual/en/function.chr.php :) Kees -Original Message- From: Christian Dechery [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 19, 2001 9:47 PM To: [EMAIL PROTECTED] Subject: [PHP] converting int to char how do I convert and integer value to its ASCII correspondent? in C I would go something like: int i = 90; char c; c = i + '0'; // now c would be 'Z' in PHP I'm simply clueless since there's no (char) type... . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer -- PHP General 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 General 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] Re: WELCOME to php-general@lists.php.net
http://hotwired.lycos.com/webmonkey/programming/php/index.html and, for general use: http://www.php.net/manual And this one can be usefull too. http://marc.theaimsgroup.com/?l=php-general http://marc.theaimsgroup.com/?l=php-generalw=2r=1s=tutorialsq=b Kees - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 3:45 PM Subject: [PHP] Re: WELCOME to [EMAIL PROTECTED] Dear sir, I am new to php.kindly recommend me tutorials tp get started. thanks asif -- PHP General 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 General 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] PHP + GD + FreeBSD
Hmm, i had the same problem here, running FreeBSD and php-4.0.x + GD. Here is what i did, and it worked: make sure there is only 1 static gd-library on the system (search for libgd). second, install GD (make install after the compilation) make also sure that libpng is correctly installed and configured. This will install gd by default in /usr/local/lib. The compile PHP with: ./configure --with-jpeg-dir=/usr/local/src/jpeg --with-gd=/usr/local PHP will search for the libgd in /usr/local now, and will find it in /usr/local/lib. make, install and good luck :-) Kees Note, make sure gd is compiled right. - Original Message - From: Kasper Kristiansson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 10, 2001 10:33 AM Subject: [PHP] PHP + GD + FreeBSD When i compile PHP on my FreeBSD with the following confgoptions, i don't get png support. Whats wrong? ./configure --with-jpeg-dir=/usr/local/src/jpeg --with-png-dir=/usr/local/sr c/libpng --with-gd=/usr/local/src/gd checking whether to include GD support... yes (static) checking for compress in -lz... (cached) yes checking for png_info_init in -lpng... (cached) no checking for gdImageString16 in -lgd... (cached) yes checking for gdImagePaletteCopy in -lgd... (cached) yes checking for gdImageColorClosestHWB in -lgd... (cached) yes checking for gdImageColorResolve in -lgd... (cached) yes checking for gdImageCreateFromPng in -lgd... (cached) no checking for gdImageCreateFromGif in -lgd... (cached) no checking for gdImageWBMP in -lgd... (cached) yes checking for gdImageCreateFromJpeg in -lgd... (cached) no checking for gdImageCreateFromXpm in -lgd... (cached) yes checking for gdImageCreateTrueColor in -lgd... (cached) no checking for gdImageSetTile in -lgd... (cached) yes checking for gdImageSetBrush in -lgd... (cached) yes checking for gdImageStringFTEx in -lgd... (cached) no checking whether to include FreeType 1.x support... no -- Med vänlig hälsning Kasper Kristiansson 042-162000, Fax 042-162009 Mobil 070-8995989 -- PHP General 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 General 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] zlib problem
hi Jeroen, first, try to compile zlib like this: gunzip -c zlib-1.1.3.tar.gz | tar xf -; \ mv zlib-1.1.3/ zlib; \ cd zlib; \ ./configure --static ; \ make; \ cd .. then compile php 4.0.5 with the --with-zlib=../zlib directive in the ./configure that worked for me :) Kees Hoekzema [EMAIL PROTECTED] Sysadmin of www.tweakers.net www.fokzine.net www.realgamer.nl -Oorspronkelijk bericht- Van: Jeroen Geusebroek [mailto:[EMAIL PROTECTED]] Verzonden: zaterdag 5 mei 2001 2:33 Aan: [EMAIL PROTECTED] Onderwerp: [PHP] zlib problem Hi there, I'm trying to compile php 4.0.5 with zlib support, but i can't get it to work. I'm using Mandrake Linux version 8, and tried to use their zlib packages, but i also tried to compile the zlib packege myself (which went well). Php always says: Configure: error: Zlib module requires zlib = 1.0.9. Needless to say, i am using a version higher then 1.0.9. I would appreciate it if someone good give me some help. I did not have this problem with PHP 4.04. Thanks, Jeroen Geusebroek P.s. please CC me in your reply, because at the moment i'm not subscribed to the list. -- PHP General 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 General 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] MySQL, PHP low-load problems
Hi all,
Live is strange sometimes, and so is this error we have here.
I have a large forum (more then 300.000 pageviews a day) running.
We are using php-4.04pl1 (with the Zend/zend_list.c file patched)
and we are using MySQL 3.23.36-log.
We are using the following piece of code to connect to the dbase:
if(!mysql_pconnect($db[$no]["host"],$db[$no]["user"],$db[$no]["pass"])){
if(!mysql_connect($db[$no]["host"],$db[$no]["user"],$db[$no]["pass"])){
die(error(55));
under normal circumstances this is running normal, not to much
error #55's. But, when the load on the forum is lowering, the ammount of
errors is increasing. This is very annoying (i mean, under high-load it is
working perfect, but at nights when the load is low you'll get error after
error.
as example:
hour#errors
19 56
20 45
21 60
22 49
23 41
0 65
1 105
2 146
3 304
4 277 (4:00 ~ 4:50)
error we receive:
2006: MySQL server has gone away
The configuration i use:
http://gathering.tweakers.net:
FreeBSD Arshia.webmagix.net 4.3-BETA FreeBSD 4.3-BETA #0:
running on an Tbird 1GHz with 512MB ram
MySQL 3.23.36 server is running on an dual PIII-1 GHz with 1.5G ram
php-config:
./configure --with-apache=../apache_1.3.19 --enable-track-vars \
--enable-magic-quotes --with-gd=/usr/local --with-mysql --with-zlib=../zlib-
1.1.3
I still don't know who is wrong, PHP or MySQL, i hope some of you
can give me more clarity in this strange behauvior.
tia,
Kees Hoekzema
[EMAIL PROTECTED]
http://gathering.tweakers.net
--
PHP General 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] mssql_pconnect issues?
Have you already tried to patch the Zend/zend_list.c file and recompile it? there is a known problem with persistent connections, read this: http://groups.google.com/groups?hl=enlr=safe=offic=1th=8810708445e328bb; seekd=939114469#939114469 and this: http://marc.theaimsgroup.com/?l=php-devm=97858730928909w=2 it sure helped here, from the more than 40k errors with mysql we went down to approx 1000 errors/daily. Kees -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Namens Michael Kimsal Verzonden: Friday, April 06, 2001 3:40 PM Aan: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Onderwerp: [PHP] mssql_pconnect issues? Very strange. I've noticed some integrity issues using mssql_pconnect, but we don't explicitly use transactions in any case, so it may not even go that deep. I wonder if the odbc functions have this issue - anyone have any ideas? [EMAIL PROTECTED] wrote: Hello Michael Some people have reported with the ADODB database class library that they were having problems with inserts and updates when using mssql_pconnect. Switching to regular mssql_connect the problems disappeared. I suspect it has something to do with persistent connections having inconsistent transaction handling settings. Eg. - Connection A is setup by user 1 to use transactions. - Connection B is setup by user 2 not to use transactions. - Connection A is reused by user 2, who thinks he doesn't need transactions, but connection A actually requires a commit to work because of user 1's previous setting... People using Interbase have reported this problem also. Regards, john -- PHP General 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 General 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] mssql_pconnect issues?
maybe, but fact is that it isn't in php404pl1, and it usefull if you use persistent connections :) Kees -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Namens Michael Kimsal Verzonden: Friday, April 06, 2001 5:12 PM Aan: [EMAIL PROTECTED] Onderwerp: Re: [PHP] mssql_pconnect issues? Wouldn't this have made it in PHP 4.0.4 by now? Or am I reading 2001-01-04 wrong? (january 4?) Kees Hoekzema wrote: Have you already tried to patch the Zend/zend_list.c file and recompile it? there is a known problem with persistent connections, read this: http://groups.google.com/groups?hl=enlr=safe=offic=1th=8810708445e328bb; seekd=939114469#939114469 and this: http://marc.theaimsgroup.com/?l=php-devm=97858730928909w=2 it sure helped here, from the more than 40k errors with mysql we went down to approx 1000 errors/daily. Kees -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Namens Michael Kimsal Verzonden: Friday, April 06, 2001 3:40 PM Aan: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Onderwerp: [PHP] mssql_pconnect issues? Very strange. I've noticed some integrity issues using mssql_pconnect, but we don't explicitly use transactions in any case, so it may not even go that deep. I wonder if the odbc functions have this issue - anyone have any ideas? [EMAIL PROTECTED] wrote: Hello Michael Some people have reported with the ADODB database class library that they were having problems with inserts and updates when using mssql_pconnect. Switching to regular mssql_connect the problems disappeared. I suspect it has something to do with persistent connections having inconsistent transaction handling settings. Eg. - Connection A is setup by user 1 to use transactions. - Connection B is setup by user 2 not to use transactions. - Connection A is reused by user 2, who thinks he doesn't need transactions, but connection A actually requires a commit to work because of user 1's previous setting... People using Interbase have reported this problem also. Regards, john -- PHP General 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 General 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 General 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] whats the message count ?
hi, 1. http://marc.theaimsgroup.com/?l=php-general 2. will be there too i think Kees -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Namens Markus H. Maussner Verzonden: Thursday, March 01, 2001 12:52 PM Aan: [EMAIL PROTECTED] Onderwerp: [PHP] whats the message count ? hi.. i have 2 small questions 1. is there somehting like an archive since the verry first mail here ? 2. i can order "old" mails from the script who managed this folder right ? but i need to say what number i want.. like i want number 499-550 .. so my question what number do we have actually ? (i suppose it started with one, but where are we right now?) markus -- PHP General 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 General 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] help!!! (PHP)
Hey Bruno, Information to generally setup a cron tab : How do I set up a cron job on Linux? --- http://www.faqts.com/knowledge_base/view.phtml/aid/1005/fid/436 In regards to php : How can I make a PHP script be called from the cron daemon? --- http://www.faqts.com/knowledge_base/view.phtml/aid/80/fid/32 Also, search mailing list for word 'cron' and many results will come about. Here's a link to such a search : http://marc.theaimsgroup.com/?l=php-generalw=2r=1s=cronq=b Good luck! (this is a quote for Philip Olson) -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Namens Bruno Freire Verzonden: Tuesday, January 23, 2001 1:53 PM Aan: '[EMAIL PROTECTED]' CC: '[EMAIL PROTECTED]' Onderwerp: [PHP] help!!! (PHP) Hi ... I'm having some problem's here I'm need to know if my apache server is able to run scripts in a specific date and hour. For example: Every month, in the 15th day, I need to run a script PHP that check my Mysql database for some cause. Is that possible??? I'm realy thanks!!! Bruno de F. F City: Belo Horizonte Estate: Minas Gerais Country: Brazil -- PHP General 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]GD, PHP and Apache troubles
Hi all, I've some strange problems. I compiled apache PHP from fresh .tar.gz, as static. (and fresh GD, libpng, jpeg-6b, zlib compilations) PHP adn GD aren't giving any troubles at all, but the compilation of apache gives some errors when trying to compile the PHP4 module... here are they: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- gcc -DLINUX=2 -I/root/source/php-4.0.4 -I/root/source/php-4.0.4/main -I/roo t/source/php-4.0.4/main -I/root/source/php-4.0.4/Zend -I/root/source/php-4.0 .4/Zend -I/root/source/php-4.0.4/TSRM -I/root/source/php-4.0.4/TSRM -I/root/ source/php-4.0.4 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` \ -o httpd buildmark.o modules.o modules/standard/libstandard.a modules/php4/libphp4.a main/libmain.a ./os/unix/libos.a ap/libap.a lib/expat-lite/libexpat.a -rdynamic -Lmodules/php4 -L../modules/php4 -L../. ./modules/php4 -lmodphp4 -ldl -lz -lpng -lgd -lresolv -lm -ldl -lcrypt -ln sl -lresolv -lm -lcrypt /usr/local/lib/libgd.a(gd_png.o): In function `gdPngErrorHandler': gd_png.o(.text+0x37): undefined reference to `png_get_error_ptr' /usr/local/lib/libgd.a(gd_png.o): In function `gdPngReadData': gd_png.o(.text+0x95): undefined reference to `png_get_io_ptr' /usr/local/lib/libgd.a(gd_png.o): In function `gdPngWriteData': gd_png.o(.text+0xc5): undefined reference to `png_get_io_ptr' /usr/local/lib/libgd.a(gd_png.o): In function `gdImageCreateFromPngCtx': gd_png.o(.text+0x155): undefined reference to `png_check_sig' ... /usr/local/lib/libgd.a(gd_png.o): In function `gdImagePngCtx': gd_png.o(.text+0x975): undefined reference to `png_create_write_struct' gd_png.o(.text+0x9ab): undefined reference to `png_create_info_struct' ... gd_png.o(.text+0xefd): undefined reference to `png_write_end' gd_png.o(.text+0xf16): undefined reference to `png_destroy_write_struct' collect2: ld returned 1 exit status make[3]: *** [target_static] Error 1 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- My commands to compile: ~/source/php-4.0.4# ./configure --with-apache=/root/source/apache_1.3.14 --with-mysql=/usr/local /mysql --with-gd=/root/source/gd-1.8.3 --with-postgres=/usr/src/postgresql-7 .0.3 --with-ftp --without-ttf --with-jpeg-dir=/root/source/jpeg-6b ~/source/php-4.0.4# cd ../apache_1.3.14 ; make ; make install ~/source/apache_1.3.14# ./configure --prefix=/www --activate-module=src/modules/php4/libphp4.a ; make ; make install I have/try: PHP 4.0.4 Apache 1.3.114 GD 1.3.8 libpng 1.0.8 zlib1.1.3 Linux 2.2.17 Original distro Slackware 7.0 Does anyone know a solution? please let me know :) Kees Hoekzema, [EMAIL PROTECTED] -- PHP General 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]Windows 2000 program execution fails
Hi all,
I want to retrieve the contents of a dir, so i use C:/WINNT/system32/cmd.exe
/C dir /b e:\logs1\ to do that.
the command works on the cli of win2k.
The server is running win2k + Apache 1.3.14 + PHP-4.0.4pl1
I receive the following error:
Warning: Unable to fork [C:/WINNT/system32/cmd.exe /C dir /b e:\logs1\] in
c:/www/apache/htdocs/counter-stats/test.php on line 3
The complete script is:
?
?
//include("config.inc");
exec("C:/WINNT/system32/cmd.exe /C dir /b e:\\logs1\\", $arr);
print_r($arr);
?
tia,
Kees Hoekzema
--
PHP General 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] Apache 1.3.14 - PHP-404 - GD-1.3.8 problems
Hi all, I've some strange problems. First i tried to update PHP-403pl1 with PHP-404. PHP was running smoothly on my Apache-1.3.14 but after the upgrade (no compile errors, ./configure okay and no errors at all when compiling PHP-404) i wanted to restart Apache.. it said something like: crc32; undefined reference. and, the /www/libexec/php4lib.so gave a seg. fault when I tried to run it. So, i compiled apache PHP from fresh .tar.gz, but this time, not as DSO, but static. This time, PHP isn't giving any troubles at all, but the compilation of apache gives some errors when trying to compile the PHP4 module... here are they: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- gcc -DLINUX=2 -I/root/source/php-4.0.4 -I/root/source/php-4.0.4/main -I/roo t/source/php-4.0.4/main -I/root/source/php-4.0.4/Zend -I/root/source/php-4.0 .4/Zend -I/root/source/php-4.0.4/TSRM -I/root/source/php-4.0.4/TSRM -I/root/ source/php-4.0.4 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` \ -o httpd buildmark.o modules.o modules/standard/libstandard.a modules/php4/libphp4.a main/libmain.a ./os/unix/libos.a ap/libap.a lib/expat-lite/libexpat.a -rdynamic -Lmodules/php4 -L../modules/php4 -L../. ./modules/php4 -lmodphp4 -ldl -lz -lpng -lgd -lresolv -lm -ldl -lcrypt -ln sl -lresolv -lm -lcrypt /usr/local/lib/libgd.a(gd_png.o): In function `gdPngErrorHandler': gd_png.o(.text+0x37): undefined reference to `png_get_error_ptr' /usr/local/lib/libgd.a(gd_png.o): In function `gdPngReadData': gd_png.o(.text+0x95): undefined reference to `png_get_io_ptr' /usr/local/lib/libgd.a(gd_png.o): In function `gdPngWriteData': gd_png.o(.text+0xc5): undefined reference to `png_get_io_ptr' /usr/local/lib/libgd.a(gd_png.o): In function `gdImageCreateFromPngCtx': gd_png.o(.text+0x155): undefined reference to `png_check_sig' ... /usr/local/lib/libgd.a(gd_png.o): In function `gdImagePngCtx': gd_png.o(.text+0x975): undefined reference to `png_create_write_struct' gd_png.o(.text+0x9ab): undefined reference to `png_create_info_struct' ... gd_png.o(.text+0xefd): undefined reference to `png_write_end' gd_png.o(.text+0xf16): undefined reference to `png_destroy_write_struct' collect2: ld returned 1 exit status make[3]: *** [target_static] Error 1 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Does anyone know a solution? please let me know :) My commands to compile: ~/source/php-4.0.4# ./configure --with-apache=../apache_1.3.14 --with-mysql --with-gd --without- ttf -with-ftp ; make ; make install ~/source/php-4.0.4# cd ../apache_1.3.14 ~/source/apache_1.3.14# ./configure --prefix=/www --activate-module=src/modules/php4/libphp4.a ; make ; make install I have/try: PHP 4.0.4 Apache 1.3.114 GD 1.3.8 libpng 1.0.8 zlib1.1.3 Linux 2.2.17 Original distro Slackware 7.0 Kees Hoekzema, [EMAIL PROTECTED] -- PHP General 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]
