[PHP-DB] RE: Subject: Hitcounter works on production server but not on localhost
hey niel. thanks man... thats wierd, why does it need to be full? how would i have been able to figure that out? appreciate it.. -Original Message- From: Neil Smth [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 12:53 PM To: Cc: [EMAIL PROTECTED] Subject: Re: Subject: Hitcounter works on production server but not on localhost Its not a permissions thing. You need to ensure that you provide PHP with a full path to the hit counter file : countrerlog.txt is a relative path. c:\\Inetpub\\wwwroot\\WCBE\\countrterlog.txt is a full path. You need to do the same with the relative path to FX_DataCounter/wcbecounter.txt as well Cheers - Neil. At 13:25 20/11/2003 +, you wrote: From: Paul Ihrig [EMAIL PROTECTED] Date: Wed, 19 Nov 2003 07:16:11 -0500 Subject: works on production server but not on localhost hey guys.. just getting back in to using a little php. have 2 simple hit counters that work fine on the production server. but on my localhost it throughs several errors. looks like a permissions thing? i am not sure if there is a setting in my php.ini file that needs to be tweaked. kind of blind to the errors. looks like a permissions thing? hit counter: Warning: fopen(counterlog.txt, w) - Permission denied in C:\Inetpub\wwwroot\WCBE\counter.php on line 4 Warning: fwrite(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\counter.php on line 5 Warning: fclose(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\counter.php on line 6 12 hit counter2: 1 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] works on production server but not on localhost
hey guys.. just getting back in to using a little php. have 2 simple hit counters that work fine on the production server. but on my localhost it throughs several errors. looks like a permissions thing? i am not sure if there is a setting in my php.ini file that needs to be tweaked. kind of blind to the errors. looks like a permissions thing? hit counter: Warning: fopen(counterlog.txt, w) - Permission denied in C:\Inetpub\wwwroot\WCBE\counter.php on line 4 Warning: fwrite(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\counter.php on line 5 Warning: fclose(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\counter.php on line 6 12 hit counter2: 1 Warning: fopen(FX_DataCounter/wcbecounter.txt, r+) - Permission denied in C:\Inetpub\wwwroot\WCBE\nav.php on line 19 Warning: fgets(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 20 Warning: Cannot send session cookie - headers already sent by (output started at C:\Inetpub\wwwroot\WCBE\nav.php:19) in C:\Inetpub\wwwroot\WCBE\nav.php on line 21 Warning: Cannot send session cache limiter - headers already sent (output started at C:\Inetpub\wwwroot\WCBE\nav.php:19) in C:\Inetpub\wwwroot\WCBE\nav.php on line 21 Warning: fseek(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 23 Warning: flock(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 24 Warning: fputs(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 25 Warning: flock(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 26 Warning: fclose(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 27 any help would be great. thanks -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] works on production server but not on localhost
ok... im on xp running iis win i tried to figure out how to change permissions on files did a few example but it never seemed to work. is there a free chmod tool? or a simple way to do it in windows? again, i am sure i sound noob, and am... thanks for the response. -paul -Original Message- From: mustafa ocak [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 7:32 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] works on production server but not on localhost You are probably right, it looks like a permission problem. What is the OS (win, Linux) of your machine? It's not about PHP.INI, If your operating system is Windows give write permission to the directory these text files reside. You can do it by using Internet Services Manager If it is a unix box (linux included) you can use chmod a+rw filename or chmod 771 filename to give write permission on these files to everybody. Maybe you have to give write permission to the directory too, I'm not sure about it. HTH Mustafa - Original Message - From: Paul Ihrig [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 2:16 PM Subject: [PHP-DB] works on production server but not on localhost hey guys.. just getting back in to using a little php. have 2 simple hit counters that work fine on the production server. but on my localhost it throughs several errors. looks like a permissions thing? i am not sure if there is a setting in my php.ini file that needs to be tweaked. kind of blind to the errors. looks like a permissions thing? hit counter: Warning: fopen(counterlog.txt, w) - Permission denied in C:\Inetpub\wwwroot\WCBE\counter.php on line 4 Warning: fwrite(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\counter.php on line 5 Warning: fclose(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\counter.php on line 6 12 hit counter2: 1 Warning: fopen(FX_DataCounter/wcbecounter.txt, r+) - Permission denied in C:\Inetpub\wwwroot\WCBE\nav.php on line 19 Warning: fgets(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 20 Warning: Cannot send session cookie - headers already sent by (output started at C:\Inetpub\wwwroot\WCBE\nav.php:19) in C:\Inetpub\wwwroot\WCBE\nav.php on line 21 Warning: Cannot send session cache limiter - headers already sent (output started at C:\Inetpub\wwwroot\WCBE\nav.php:19) in C:\Inetpub\wwwroot\WCBE\nav.php on line 21 Warning: fseek(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 23 Warning: flock(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 24 Warning: fputs(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 25 Warning: flock(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 26 Warning: fclose(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 27 any help would be great. thanks -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] works on production server but not on localhost
already tried that read write execute scripts. no go -Original Message- From: mustafa ocak [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 7:54 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] works on production server but not on localhost Settings - Control Panel - Administrative Tools -Internet Services Manager Click the Default Web Site on the list, directories will be shown Right click the directory the files reside and Select Properties You can give write permission to the directory here. HTH Mustafa - Original Message - From: Paul Ihrig [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 2:44 PM Subject: RE: [PHP-DB] works on production server but not on localhost ok... im on xp running iis win i tried to figure out how to change permissions on files did a few example but it never seemed to work. is there a free chmod tool? or a simple way to do it in windows? again, i am sure i sound noob, and am... thanks for the response. -paul -Original Message- From: mustafa ocak [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 7:32 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] works on production server but not on localhost You are probably right, it looks like a permission problem. What is the OS (win, Linux) of your machine? It's not about PHP.INI, If your operating system is Windows give write permission to the directory these text files reside. You can do it by using Internet Services Manager If it is a unix box (linux included) you can use chmod a+rw filename or chmod 771 filename to give write permission on these files to everybody. Maybe you have to give write permission to the directory too, I'm not sure about it. HTH Mustafa - Original Message - From: Paul Ihrig [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 2:16 PM Subject: [PHP-DB] works on production server but not on localhost hey guys.. just getting back in to using a little php. have 2 simple hit counters that work fine on the production server. but on my localhost it throughs several errors. looks like a permissions thing? i am not sure if there is a setting in my php.ini file that needs to be tweaked. kind of blind to the errors. looks like a permissions thing? hit counter: Warning: fopen(counterlog.txt, w) - Permission denied in C:\Inetpub\wwwroot\WCBE\counter.php on line 4 Warning: fwrite(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\counter.php on line 5 Warning: fclose(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\counter.php on line 6 12 hit counter2: 1 Warning: fopen(FX_DataCounter/wcbecounter.txt, r+) - Permission denied in C:\Inetpub\wwwroot\WCBE\nav.php on line 19 Warning: fgets(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 20 Warning: Cannot send session cookie - headers already sent by (output started at C:\Inetpub\wwwroot\WCBE\nav.php:19) in C:\Inetpub\wwwroot\WCBE\nav.php on line 21 Warning: Cannot send session cache limiter - headers already sent (output started at C:\Inetpub\wwwroot\WCBE\nav.php:19) in C:\Inetpub\wwwroot\WCBE\nav.php on line 21 Warning: fseek(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 23 Warning: flock(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 24 Warning: fputs(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 25 Warning: flock(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 26 Warning: fclose(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 27 any help would be great. thanks -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] works on production server but not on localhost
i don't have a security tab under properties when just browsing the directory. i only get a Directory Security tab when i am in the Internet Information Services there i have Anonymous access checked User name IUSR_BAlgh pass * Allow IIS to control password checked also Integrated Windows authentication checked. seems funky... i appreciate the help guys. -paul -Original Message- From: J.Veenhuijsen [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 8:27 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] works on production server but not on localhost Try setting security settings on directory itself eg full control for IUSR_.. to do this right click on directory -propertys- security add a user IUSR_... and give full access Works fine for me Jochem Paul Ihrig wrote: already tried that read write execute scripts. no go -Original Message- From: mustafa ocak [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 7:54 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] works on production server but not on localhost Settings - Control Panel - Administrative Tools -Internet Services Manager Click the Default Web Site on the list, directories will be shown Right click the directory the files reside and Select Properties You can give write permission to the directory here. HTH Mustafa - Original Message - From: Paul Ihrig [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 2:44 PM Subject: RE: [PHP-DB] works on production server but not on localhost ok... im on xp running iis win i tried to figure out how to change permissions on files did a few example but it never seemed to work. is there a free chmod tool? or a simple way to do it in windows? again, i am sure i sound noob, and am... thanks for the response. -paul -Original Message- From: mustafa ocak [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 7:32 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] works on production server but not on localhost You are probably right, it looks like a permission problem. What is the OS (win, Linux) of your machine? It's not about PHP.INI, If your operating system is Windows give write permission to the directory these text files reside. You can do it by using Internet Services Manager If it is a unix box (linux included) you can use chmod a+rw filename or chmod 771 filename to give write permission on these files to everybody. Maybe you have to give write permission to the directory too, I'm not sure about it. HTH Mustafa - Original Message - From: Paul Ihrig [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 19, 2003 2:16 PM Subject: [PHP-DB] works on production server but not on localhost hey guys.. just getting back in to using a little php. have 2 simple hit counters that work fine on the production server. but on my localhost it throughs several errors. looks like a permissions thing? i am not sure if there is a setting in my php.ini file that needs to be tweaked. kind of blind to the errors. looks like a permissions thing? hit counter: Warning: fopen(counterlog.txt, w) - Permission denied in C:\Inetpub\wwwroot\WCBE\counter.php on line 4 Warning: fwrite(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\counter.php on line 5 Warning: fclose(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\counter.php on line 6 12 hit counter2: 1 Warning: fopen(FX_DataCounter/wcbecounter.txt, r+) - Permission denied in C:\Inetpub\wwwroot\WCBE\nav.php on line 19 Warning: fgets(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 20 Warning: Cannot send session cookie - headers already sent by (output started at C:\Inetpub\wwwroot\WCBE\nav.php:19) in C:\Inetpub\wwwroot\WCBE\nav.php on line 21 Warning: Cannot send session cache limiter - headers already sent (output started at C:\Inetpub\wwwroot\WCBE\nav.php:19) in C:\Inetpub\wwwroot\WCBE\nav.php on line 21 Warning: fseek(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 23 Warning: flock(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 24 Warning: fputs(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 25 Warning: flock(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 26 Warning: fclose(): supplied argument is not a valid File-Handle resource in C:\Inetpub\wwwroot\WCBE\nav.php on line 27 any help would be great. thanks -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http
RE: [PHP-DB] works on production server but not on localhost
it's ntfs -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] works on production server but not on localhost :: fix
how weird is this just had to uncheck allow anonymous access. and keep checked Integrated Windows authentication just seems a bit silly... every thing works fine now. thanks for the help! will have better questions for you all in a day or so... -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Forums?
hey guys. a friend want help setting up a forum. what are some good easy to use ones out there? thanks -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] any free php mySql Host's?
Hey guys. i have a host at cfm-resources.com for coldfusion but now that i am getting into php. i would like to find a free host. any ones out there? thanks. -paul Whatever you can do, or dream you can, begin it. Boldness has genius, power, and magic in it. - Goethe web developer, that is looking for work http://www.PaulIhrig.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] date questions in mySql
ok i can parse a date from mySql date field so it displays as: 08/06/1972 but if i insert it into the field in this format then the date gets hosed. do i have to insert as -mm-dd can i have a form field that has mm/dd/ but then change it on insert? how would i do this? thanks. -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Moving mySql db's odbc
hey guys. new to php mySql how would i move a db from a test server to a production sever? would it just be C:\mysql\data\testC:\mysql\data\thisProductionDir would i just copy thisProductionDir or is there a better way? oh i wanted to know about how to set up a odbc data source with mySql, but i guess i don't need it to connect to the mySql server through PHP? thanks -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Order DB through url toggle
Hello All!
i am new to the list to PHP..
So i have a recordset that displays my contacts in a table.
the headers of the columns look like this.
tda href=default2.php?orderBy=priLastNameLast Name/a/td
so when a user clicks on it
It will Re-Sort the rs by priLastName Asc.
what i want to do is make it a toggle
between table name ASC or DESC..
any ideas?
thanks.
-paul
#$orderBy = 'priFirstName';
$orderBy = 'priLastName';
if (isset($HTTP_GET_VARS['orderBy'])) {
$orderBy = $HTTP_GET_VARS['orderBy'];
}
#?orderBy=priFirstName
$maxRows_rsAll = 5;;
$pageNum_rsAll = 0;
if (isset($HTTP_GET_VARS['pageNum_rsAll'])) {
$pageNum_rsAll = $HTTP_GET_VARS['pageNum_rsAll'];
}
$startRow_rsAll = $pageNum_rsAll * $maxRows_rsAll;
mysql_select_db($database_myFirstSql, $myFirstSql);
$query_rsAll = SELECT * FROM userinfo ORDER BY $orderBy ASC;
$query_limit_rsAll = sprintf(%s LIMIT %d, %d, $query_rsAll,
$startRow_rsAll, $maxRows_rsAll);
$rsAll = mysql_query($query_limit_rsAll, $myFirstSql) or die(mysql_error());
$row_rsAll = mysql_fetch_assoc($rsAll);
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Order DB through url toggle
well i tried that..
but it out puts the right number.
but it is not taking that var to switch ACS or DESC...
http://localhost/php/default2.php?orderBy=priLastNamedir=0
http://localhost/php/default2.php?orderBy=priLastNamedir=1
/* here we set up out order by clause */
$orderBy = 'priLastName';
if (isset($HTTP_GET_VARS['orderBy'])) {
$orderBy = $HTTP_GET_VARS['orderBy'];
}
/* and the desc asc */
if $HTTP_GET_VARS['dir'] = 0 {
$diri = 'DESC';
} else {
$diri = 'ASC';
}
mysql_select_db($database_myFirstSql, $myFirstSql);
$query_rsAll = SELECT * FROM userinfo ORDER BY $orderBy $diri;
$query_limit_rsAll = sprintf(%s LIMIT %d, %d, $query_rsAll,
$startRow_rsAll, $maxRows_rsAll);
$rsAll = mysql_query($query_limit_rsAll, $myFirstSql) or die(mysql_error());
$row_rsAll = mysql_fetch_assoc($rsAll);
Then
?
$dir = ((isset ($_GET['dir'])) ? (int) $_GET['dir'] : 1);
if (!$dir)
$direction = 'desc';
$dir = ($dir ? 0 : 1);
?
tda href=default2.php?orderBy=priLastNamedir=?= $dir?Last
Name/a/td
tda href=default2.php?orderBy=priPhonePhone/a/td
tda href=default2.php?orderBy=priEmailEmail/a/td
tda href=default2.php?orderBy=priStreetStreet/a/td
tda href=default2.php?orderBy=priCityCity/a/td
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Order DB through url toggle
Thanks Guys..
This seemed to do the trick
/* and the desc asc */
$dir = ((isset ($_GET['dir'])) ? (int) $_GET['dir'] : 1);
if (!$dir)
$dir = ($dir ? 0 : 1);
if ($HTTP_GET_VARS['dir'] == 0) {
$diri = 'DESC';
}
if ($HTTP_GET_VARS['dir'] == 1) {
$diri = 'ASC';
}
mysql_select_db($database_myFirstSql, $myFirstSql);
$query_rsAll = SELECT * FROM userinfo ORDER BY $orderBy $diri;
-paul
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
