[PHP] how to update PHP 5.2.6 to 5.2.8 under Fedora Redhat Linux 9

2008-12-27 Thread Fred Silsbee
there are many php related files.

yumex or yum don't seem to be alternatives since there are many files that may 
or may not require updating...which one

yum remove php-5.2.6
yum install php-5.2.8

5.2.8 may not be in the repositories yet

so rpm seems to be an alternative with a remove - reinstall


  


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] errors still being displayed even if variables in php.ini set to off

2008-12-27 Thread Fred Silsbee
on page 1
Notice: Undefined index: in C:\Inetpub\wwwroot\handle_log_book_MySQL.php on 
line 71

Notice: Undefined index: in C:\Inetpub\wwwroot\handle_log_book_MySQL.php on 
line 72

in php.ini:

error_reporting  =  Off

display_errors = Off (in 2 places)

display_startup_errors = Off





  


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] errors still being displayed even if variables in php.ini set to off

2008-12-28 Thread Fred Silsbee



--- On Sun, 12/28/08, Ashley Sheridan  wrote:

> From: Ashley Sheridan 
> Subject: Re: [PHP] errors still being displayed even if variables in php.ini 
> set to off
> To: fredsils...@yahoo.com
> Cc: php-general@lists.php.net
> Date: Sunday, December 28, 2008, 12:01 PM
> On Sat, 2008-12-27 at 16:23 -0800, Fred Silsbee wrote:
> > on page 1
> > Notice: Undefined index: in
> C:\Inetpub\wwwroot\handle_log_book_MySQL.php on
> line 71
> > 
> > Notice: Undefined index: in
> C:\Inetpub\wwwroot\handle_log_book_MySQL.php on
> line 72
> > 
> > in php.ini:
> > 
> > error_reporting  =  Off
> > 
> > display_errors = Off (in 2 places)
> > 
> > display_startup_errors = Off
> > 
> > 
> > 
> > 
> > 
> >   
> > 
> > 
> What does phpinfo() tell you? Don't forget that there
> are several places
> where this can be set; the php.ini file, the .htaccess
> file, and within
> the PHP code itself. If phpinfo() tells you that both
> settings are for
> errors off, then it's most likely that a line in your
> PHP code is
> turning them back on
> 
> 
> Ash
> www.ashleysheridan.co.uk

sincere thanks mate...I'm sure there is a good reason for having flags all over 
the place somewhat mislabelled or ill described in the php.ini

Surely I thought there'd be a "master-turn off all the &&&& errors!"

The php.ini describes good sense security know how in affirming the need for 
!

here in the colonies I have become addicted to "Eastenders" on tonight at 10 pm

Here in Houston...should the program ever get messed up somehow, there are 
hundreds of calls, emails, bottle throwing, diesel locos being overturned

Bennie Hill should have been knighted!!!

sure and you'd be goin for a pint uf the dark


  


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] If I make a mistake logging in, the error shows again even if I enter the right values

2009-01-03 Thread Fred Silsbee
my PHP programs are working great to access Oracle 11g1 and MySQL 5.1

I entered a bad value for user name /passwordand got a message 
Could not connect: Access denied for user 'landon'@'localhost' (using password: 
YES)

I restarted the script under Firefox 3.0.5 and got the same error message 
without a chance to enter username/password 

If I clean the cache, it works OK

This problem only occurs with the MySQL script that is nearly identical to the 
Oracle script that doesn't show the problem.

This must be a familiar problem with you web programmers!


  


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Re: If I make a mistake logging in, the error shows again even if I enter the right values

2009-01-03 Thread Fred Silsbee



--- On Sun, 1/4/09, Fred Silsbee  wrote:

> From: Fred Silsbee 
> Subject: If I make a mistake logging in, the error shows again even if I 
> enter the right values
> To: php...@lists.php.net, php-general@lists.php.net
> Date: Sunday, January 4, 2009, 2:45 AM
> my PHP programs are working great to access Oracle 11g1 and
> MySQL 5.1
> 
> I entered a bad value for user name /passwordand got a
> message 
> Could not connect: Access denied for user
> 'landon'@'localhost' (using password: YES)
> 
> I restarted the script under Firefox 3.0.5 and got the same
> error message without a chance to enter username/password 
> 
> If I clean the cache, it works OK
> 
> This problem only occurs with the MySQL script that is
> nearly identical to the Oracle script that doesn't show
> the problem.
> 
> This must be a familiar problem with you web programmers!

The problem is correctable with ordinary programming logic.


  


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] php beautify downloaded...great how does one run the program???

2009-01-05 Thread Fred Silsbee
I looked at all the downloaded docs


  


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] how does one bind a gui representation and a container object.

2009-01-08 Thread Fred Silsbee
I have a Qt 4.4 C++ SQL offline program that displays an SQL table.

When I change a row-column cell, the change is instantly reflected in the 
database. Under Qt 4.4 I use:

QSqlTableModel

How does one do this in PHP for online use.

I've done this under C#.NET VS2008 using "binding" between a gui representation 
and the container object.


  


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] Re: how does one bind a gui representation and a container object.

2009-01-08 Thread Fred Silsbee



--- On Thu, 1/8/09, Fred Silsbee  wrote:

> From: Fred Silsbee 
> Subject: how does one bind a gui representation and a container object.
> To: php...@lists.php.net, php-general@lists.php.net
> Date: Thursday, January 8, 2009, 10:41 PM
> I have a Qt 4.4 C++ SQL offline program that displays an SQL
> table.
> 
> When I change a row-column cell, the change is instantly
> reflected in the database. Under Qt 4.4 I use:
> 
> QSqlTableModel
> 
> How does one do this in PHP for online use.
> 
> I've done this under C#.NET VS2008 using
> "binding" between a gui representation and the
> container object.





error I get under Firefox 3.0.5 under Fedora 9 PHP 5.2.6
Unknown Renderer driver. Please specify an existing driver. 

Code:
 'mysql://landon4:pwpwpwp...@localhost/landonx');

// Bind a basic SQL statement as datasource
$test = $datagrid->bind('SELECT * FROM log_book', $options);

// Print binding error if any
if (PEAR::isError($test)) {
echo $test->getMessage();
}

// Print the DataGrid with the default renderer (HTML Table)
$test = $datagrid->render(Structures_DataGrid_Renderer_HTMLTable);

// Print rendering error if any
if (PEAR::isError($test)) {
echo $test->getMessage();
}

?>




  


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] pronlem with yum update and oci8

2009-04-17 Thread Fred Silsbee

 Fedora 9
 (1) all programs using oci8 working 100%
 (2) oci8 NOT installed using yum
 yumex not showing any reference to oci8
 
 php-pear installed using yumex(yum)
 (3) yum update errors below
 
 
 Loaded plugins: refresh-packagekit
 Setting up Update Process 
 Resolving Dependencies
 --> Running transaction check
 ---> Package php-pear-HTML-Common.noarch 0:1.2.5-1.fc9
 set to be updated
 ---> Package
 php-pear-HTML-QuickForm-advmultiselect.noarch 0:1.5.1-1.fc9
 set to be updated
 --> Finished Dependency Resolution
 
 Dependencies Resolved
 
 

  PackageArch   
Version  Repository  
Size
 

 Updating:
  php-pear-HTML-Common   noarch 
1.2.5-1.fc9  updates-newkey  
   9.7 k
  php-pear-HTML-QuickForm-advmultiselect noarch 
1.5.1-1.fc9  updates-newkey  
38 k
 
 Transaction Summary
 

 Install  0 Package(s)
 Update   2 Package(s)
 Remove   0 Package(s)
 
 Total download size: 48 k
 Is this ok [y/N]: y
 Downloading Packages:
 (1/2): php-pear-HTML-Common-1.2.5-1.fc9.noarch.rpm 
   | 9.7 kB
 00:00
 (2/2):
 php-pear-HTML-QuickForm-advmultiselect-1.5.1-1.fc9.noarch.rpm
  |  38 kB 00:00
 

 Total  
   52 kB/s |  48 kB
 00:00
 Running rpm_check_debug
 Running Transaction Test
 Finished Transaction Test
 Transaction Test Succeeded
 Running Transaction
   Updating   : php-pear-HTML-Common
 
 1/4
 PHP Warning:  PHP Startup: Unable to load dynamic library
 '/usr/lib/php/modules/php_oci8.dll' -
 /usr/lib/php/modules/php_oci8.dll: cannot open shared object
 file: No such file or directory in Unknown on line 0
 PHP Warning:  PHP Startup: Unable to load dynamic library
 '/usr/lib/php/modules/php_oracle.dll' -
 /usr/lib/php/modules/php_oracle.dll: cannot open shared
 object file: No such file or directory in Unknown on line 0
   Updating   : php-pear-HTML-QuickForm-advmultiselect  
 
 2/4
 PHP Warning:  PHP Startup: Unable to load dynamic library
 '/usr/lib/php/modules/php_oci8.dll' -
 /usr/lib/php/modules/php_oci8.dll: cannot open shared object
 file: No such file or directory in Unknown on line 0
 PHP Warning:  PHP Startup: Unable to load dynamic library
 '/usr/lib/php/modules/php_oracle.dll' -
 /usr/lib/php/modules/php_oracle.dll: cannot open shared
 object file: No such file or directory in Unknown on line 0
   Cleanup: php-pear-HTML-QuickForm-advmultiselect  
 
 3/4
   Cleanup: php-pear-HTML-Common
 
 4/4
 
 Updated:
   php-pear-HTML-Common.noarch 0:1.2.5-1.fc9 
 php-pear-HTML-QuickForm-advmultiselect.noarch 0:1.5.1-1.fc9
 
 Complete!



  


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] PHP 5.3 IIS 5.1 not working...help!

2009-07-30 Thread Fred Silsbee

http://72.47.28.125:8080/phpinfo.php not working
ERROR:
The website cannot display the page 
 HTTP 500  

IIS 5.1, PHP 5.3 XP Prof SP3 + all updates
PHP 5.2.8 worked great and took a few minutes to install

phpinfo.php is in C:\inetpub\wwwroot 



php.ini has:
doc_root = "C:\inetpub\wwwroot" // for IIS/PWS (tried removing the "")
 extension_dir = "ext"
php.ini put into 

C:\php
C:\Windows
C:\Windows\system
C:\windows\system32
system variable PHPRC set = C:\php

http://72.47.28.125:8080/aspx/abc.aspx works great with IIS 5.1

IIS 5.1 application configuration mappings .php   C:\php\php5.dll (that is all 
there is)
There is no php5isapi file!
home directory = C:\inetpub\wwwroot
web site: IP all unassigned, TCP Port 8080
directory security unchanged: IUSR_...allow IIS to control 
password

VC9 versions downloaded and put into C:\php
Microsoft 2008 C++ Runtime (x86) installed
VC9 x86 Non Thread Safe (2009-Jun-30 08:52:54)

C:\php;c:\php\ext put on the end of the path environmental
  system variable


yes I rebooted many times

command line (black window) 
cd C:\php
php -i   generates plenty stuff

I am administrator!







  


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] windows 5.2.10 PHP not working with phpinfo

2009-08-30 Thread Fred Silsbee
I got 5.3 working but found out there was no php_mssql.dll for it.
Somebody (who didn;t know) said I had to return to 5.2.8 but I found no 5.2.8 
so I am trying 5.2.10
_problem:
under IE8:
http://72.47.28.128:8080/phpinfo.php
with:
 

I get :
The website cannot display the page 
HTTP 500  
   Most likely causes:
•The website is under maintenance.
•The website has a programming error. 
___

I installed :
php-5.2.10-Win32-VC6-x86.zip and put php.ini in C:\PHP and C:\PHP\ext
AND C:\WINDOWS, C:\WINDOWS\system and C:\WINDOWS\system32

I installed FastCGI 1.5 !

In php.ini I put :


cgi.force_redirect = 0  // for CGI

extension_dir =  "C:\PHP\ext"

commented out
;doc_root = "C:\inetpub\wwwroot" // for IIS/PWS
leaving
doc_root = 
_
IIS 5.1 properties->configuration I added .php  C:\PHP\php5ts.dll
GET,HEAD,POST,DEBUG

Maybe php-win.exe
_

I added to the XP Prof environment path ;C:\PHP\;C:\PHP\ext\

I created an environment variable (and rebooted) PHPRC = C:\PHP;C:\PHP\ext


I never found any statement of the necessity of requiring CGI

The instructions ramble around






--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] windows 5.2.10 PHP not working with phpinfo

2009-09-01 Thread Fred Silsbee
thanks! I am new to this science! where is syslog? XP Prof event log?

--- On Mon, 8/31/09, hack988 hack988  wrote:

> From: hack988 hack988 
> Subject: Re: [PHP] windows 5.2.10 PHP not working with phpinfo
> To: "Fred Silsbee" 
> Cc: php-general@lists.php.net
> Date: Monday, August 31, 2009, 6:35 AM
> Please set
> log_error=on,error_reporting=E_ALL,error_log=syslog in
> php.ini and then,see error detail in syslog.
> 
> 2009/8/31 Fred Silsbee :
> > I got 5.3 working but found out there was no
> php_mssql.dll for it.
> > Somebody (who didn;t know) said I had to return to
> 5.2.8 but I found no 5.2.8 so I am trying 5.2.10
> > _problem:
> > under IE8:
> > http://72.47.28.128:8080/phpinfo.php
> > with:
> >      >       phpinfo();
> >     ?>
> >
> > I get :
> > The website cannot display the page
> > HTTP 500
> >   Most likely causes:
> > •The website is under maintenance.
> > •The website has a programming error.
> > ___
> >
> > I installed :
> > php-5.2.10-Win32-VC6-x86.zip and put php.ini in C:\PHP
> and C:\PHP\ext
> > AND C:\WINDOWS, C:\WINDOWS\system and
> C:\WINDOWS\system32
> >
> > I installed FastCGI 1.5 !
> >
> > In php.ini I put :
> > 
> >
> > cgi.force_redirect = 0                  //
> for CGI
> >
> > extension_dir =  "C:\PHP\ext"
> >
> > commented out
> > ;doc_root = "C:\inetpub\wwwroot" // for IIS/PWS
> > leaving
> > doc_root =
> > _
> > IIS 5.1 properties->configuration I added .php
>  C:\PHP\php5ts.dll
> > GET,HEAD,POST,DEBUG
> >
> > Maybe php-win.exe
> > _
> >
> > I added to the XP Prof environment path
> ;C:\PHP\;C:\PHP\ext\
> >
> > I created an environment variable (and rebooted) PHPRC
> = C:\PHP;C:\PHP\ext
> >
> >
> > I never found any statement of the necessity of
> requiring CGI
> >
> > The instructions ramble around
> >
> >
> >
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> 




--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] windows 5.2.10 PHP not working with phpinfo

2009-09-01 Thread Fred Silsbee
I looked high and low but no syslog

I am currently working under XP Prof SP3

--- On Mon, 8/31/09, hack988 hack988  wrote:

> From: hack988 hack988 
> Subject: Re: [PHP] windows 5.2.10 PHP not working with phpinfo
> To: "Fred Silsbee" 
> Cc: php-general@lists.php.net
> Date: Monday, August 31, 2009, 6:35 AM
> Please set
> log_error=on,error_reporting=E_ALL,error_log=syslog in
> php.ini and then,see error detail in syslog.
> 
> 2009/8/31 Fred Silsbee :
> > I got 5.3 working but found out there was no
> php_mssql.dll for it.
> > Somebody (who didn;t know) said I had to return to
> 5.2.8 but I found no 5.2.8 so I am trying 5.2.10
> > _problem:
> > under IE8:
> > http://72.47.28.128:8080/phpinfo.php
> > with:
> >      >       phpinfo();
> >     ?>
> >
> > I get :
> > The website cannot display the page
> > HTTP 500
> >   Most likely causes:
> > •The website is under maintenance.
> > •The website has a programming error.
> > ___
> >
> > I installed :
> > php-5.2.10-Win32-VC6-x86.zip and put php.ini in C:\PHP
> and C:\PHP\ext
> > AND C:\WINDOWS, C:\WINDOWS\system and
> C:\WINDOWS\system32
> >
> > I installed FastCGI 1.5 !
> >
> > In php.ini I put :
> > 
> >
> > cgi.force_redirect = 0                  //
> for CGI
> >
> > extension_dir =  "C:\PHP\ext"
> >
> > commented out
> > ;doc_root = "C:\inetpub\wwwroot" // for IIS/PWS
> > leaving
> > doc_root =
> > _
> > IIS 5.1 properties->configuration I added .php
>  C:\PHP\php5ts.dll
> > GET,HEAD,POST,DEBUG
> >
> > Maybe php-win.exe
> > _
> >
> > I added to the XP Prof environment path
> ;C:\PHP\;C:\PHP\ext\
> >
> > I created an environment variable (and rebooted) PHPRC
> = C:\PHP;C:\PHP\ext
> >
> >
> > I never found any statement of the necessity of
> requiring CGI
> >
> > The instructions ramble around
> >
> >
> >
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> 




--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] windows 5.2.10 PHP not working with phpinfo

2009-09-02 Thread Fred Silsbee
THANKS!

Here is my current situation (if you care to look at it (under the windows ) 
list

I tried 5.3 and found out it had no php_mssql.
Then I retreated to 5.2.10.

Trying to get back to where I had everything worked, I downloaded 5.2.6:
(1) I uninstalled cgi 1.5
(2) php.ini   has:

extension_dir = "C:\PHP\ext"
; doc_root = "C:\inetpub\wwwroot"  commented out
doc_root =

ALL extensions are uncommented

I only need:
extension=php_mssql.dll

; **You CAN safely turn this off for IIS, in fact, you MUST.**
cgi.force_redirect = 0

ntwdblib and php.ini moved to
C:\WINDOWS
C:\WINDOWS\system
C:\WINDOWS\system32

IIS: properties->home directory->configuration   C:\PHP\php5isapi.dll
with GET,HOST,POST,DEBUG

I also tried:
php5ts.dll
phpnsapi.dll
only php5isapi.dll seemed to work!
added to XP Prof SP3 path: ;C:\PHP;C:\PHP\ext

also created (just in case) PHPRC environment variable (alongside path)
containing C:\PHP;C:\PHP\ext

I gave IUSR_LANDON all powers

results
this works:http://207.254.225.224:8080/phpinfo.php

http://207.254.225.224:8080/new_black_scholes.php
initial display works until I select "DEMO"...then:

The page cannot be displayed
There is a problem with a program on the page you are trying to reach, and the 
page cannot be displayed.

Here is new_black_scholes.php




Black Scholes Option Price Calculator:

temp website under Redhat Fedora 9 Linux:

the first 5 boxes require input(try 100. 100. .12 .1 365.):



StockPrice (required):




ExercisePrice (required):




Risk Free Rate of Interest(required):




Instantaneous Variance Rate of Stock's Return (required):




Time to Expiration of the Option(days) (required):




Values of the Call Option :





Values of the Put option :




Delta(calls):




Delta(puts):



Calculate

Demo



_results

Please try the following:

Open the 207.254.225.224:8080 home page, and then look for links to the 
information you want.
Click the Refresh button, or try again later.

HTTP 403.1 Forbidden: Execute Access Forbidden
Internet Information Services



Technical Information (for support personnel)


Background:
You have attempted to execute a CGI, ISAPI, or other executable program from a 
directory that does not allow programs to be executed.


More information:
Microsoft Support

http://207.254.225.224:8080/handle_log_book_mssql.php
yields:

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 
LANDON\SQLEXPRESSLMKIII in C:\Inetpub\wwwroot\handle_log_book_mssql.php on line 
8 (mssql_connect(...)
Something went wrong while connecting to MSSQL (my message)
___
all these worked before trying 5.3







--- On Wed, 9/2/09, hack988 hack988  wrote:

> From: hack988 hack988 
> Subject: Re: [PHP] windows 5.2.10 PHP not working with phpinfo
> To: "Fred Silsbee" 
> Cc: php-general@lists.php.net
> Date: Wednesday, September 2, 2009, 6:03 AM
> Use Event Viewer and log type is
> :Application log
> 
> 2009/9/2 Fred Silsbee :
> > I looked high and low but no syslog
> >
> > I am currently working under XP Prof SP3
> >
> > --- On Mon, 8/31/09, hack988 hack988 
> wrote:
> >
> >> From: hack988 hack988 
> >> Subject: Re: [PHP] windows 5.2.10 PHP not working
> with phpinfo
> >> To: "Fred Silsbee" 
> >> Cc: php-general@lists.php.net
> >> Date: Monday, August 31, 2009, 6:35 AM
> >> Please set
> >>
> log_error=on,error_reporting=E_ALL,error_log=syslog in
> >> php.ini and then,see error detail in syslog.
> >>
> >> 2009/8/31 Fred Silsbee :
> >> > I got 5.3 working but found out there was no
> >> php_mssql.dll for it.
> >> > Somebody (who didn;t know) said I had to
> return to
> >> 5.2.8 but I found no 5.2.8 so I am trying 5.2.10
> >> >
> _problem:
> >> > under IE8:
> >> > http://72.47.28.128:8080/phpinfo.php
> >> > with:
> >> >      >> >       phpinfo();
> >> >     ?>
> >> >
> >> > I get :
> >> > The website cannot display the page
> >> > HTTP 500
> >> >   Most likely causes:
> >> > •The website is under maintenance.
> >> > •The website has a programming error.
> &

[PHP] need php_mssql so I retreated to 5.2.10

2009-09-07 Thread Fred Silsbee

under IE8:
http:// 209.33.25.167:8080/phpinfo.php
with:
 

I get :
The website cannot display the page
HTTP 500 
   Most likely causes:
•The website is under maintenance.
•The website has a programming error.

under Firefox 3.5.2
___
The specified procedure could not be found.
___

I installed :
php-5.2.10-Win32-VC6-x86.zip and put php.ini in C:\PHP and C:\PHP\ext
AND C:\WINDOWS, C:\WINDOWS\system and C:\WINDOWS\system32

I installed FastCGI 1.5 !

In php.ini I put :


cgi.force_redirect = 0  // for CGI

extension_dir =  "C:\PHP\ext"   (not trying to use any extension ...just 

   get phpinfo to work)


doc_root = "C:\inetpub\wwwroot" // for IIS/PWS
an earlier post recommended:
doc_root =
_
IIS 5.1 properties->configuration I added .php  C:\PHP\php5.dll
GET,HEAD,POST,DEBUG

_

I added to the XP Prof environment path ;C:\PHP;C:\PHP\ext

I created an environment variable (and rebooted) PHPRC = C:\PHP;C:\PHP\ext
_
From the unzipped download,
I copied ntwdblib.dll to C:\PHP and C:\PHP\ext
AND C:\WINDOWS, C:\WINDOWS\system and C:\WINDOWS\system32


I never found any statement of the necessity of requiring CGI

The instructions ramble around







--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] looking through old posts/emails

2009-09-13 Thread Fred Silsbee
enclosed is a php for oracle that worked on Windows AND Fedora 9



Oracle User Name:



Oracle Password:


LOGIN


HTML;
 $_SESSION['userx'] =  $_POST[$user] ;
 $_SESSION['passwordx'] = $_POST[$password] ;
}


//...function
 loginOracle()

function loginOracle(){
global $connection;


$db = "(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = LANDON)(PORT = 1521))
   (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SID = LMKGDN)
   )
 )";
$_SESSION['userx'] = $_POST['user'];
$_SESSION['passwordx'] = $_POST['password'];
$connection=oci_pconnect($_POST['user'], $_POST['password'], $db);
if ($connection)
{
echo "Successfully connected to Oracle.\n";
//default action

displayDeleteForm();
}
else
{
 $err = OCIError();
 echo "Oracle Connect Error " . $err['message'];
}
}

//...function
 displayDeleteForm()

function displayDeleteForm(){
//get $fields into the function namespace
global $fields;
global $connection;


/* Create and execute query. */
// Loop through each row, outputting the actype and name
 echo <<



 
 
 




checked
rowID
fdate
actype
acid
nlandings
nhours

HTML;

//get log_book_id table information
$user = "select * from log_book_id order by log_id";
$result = oci_parse($connection, $user);
$r = oci_execute($result);

//display log_book_id information

while ($newArray = oci_fetch_assoc($result)) {
foreach ($fields as $field){
$fieldx = strtoupper($field);
${$field} = $newArray[$fieldx];
}
$rowID = $newArray['LOG_ID'];

echo <<

Check 
to select record

$rowID
$fdate
$actype
$acid
$nlandings
$nhours


HTML;

}// while
echo <<


HTML;
}//close function

// . function 
timeInType()
//

function timeInType()
{

global $connection;

$query = "select actype,sum(nhours) from log_book_id group by actype";

$statement = oci_parse ($connection, $query);
oci_execute ($statement);
// Loop through each row, outputting the actype and name
 echo <<



A/C Type
Time in Type


HTML;

while ($row = oci_fetch_array ($statement, OCI_ASSOC)) {
$actype = $row['ACTYPE'];
$sum = $row['SUM(NHOURS)'];
echo <<
$actype
$sum


HTML;
}   // while

$query = "select sum(nhours) from log_book_id";

$statement = oci_parse ($connection, $query);
oci_execute ($statement);
// Loop through each row, outputting the actype and name

while ($row = oci_fetch_array ($statement, OCI_ASSOC)) {
$sum = $row['SUM(NHOURS)'];
echo <<
Total Hours =$sum

HTML;
}   // while

echo <<




HTML;
}

// . function 
deleteRecords()
//

function deleteRecords()
{

global $connection;
// Loop through each log_book_id with an enabled checkbox

if (!isset($_POST['checkbox'])){
displayDeleteForm();
return true;
}
//else

foreach($_POST['checkbox'] as $key=>$val){
$toDelete[] = $key;
}
//expand the array for an IN query
$where = implode(',', $toDelete);
$query = "DELETE FROM log_book_id WHERE log_id IN ($where)";
$result = oci_parse($connection, $query);
$r = oci_execute($result);
// Commit transaction
$committed = oci_commit($connection);
// Test whether commit was successful. If error occurred, return error message
if (!$committed) {
$error = oci_error($connection);
echo 'Commit failed. Oracle reports: ' . $error['message'];
}
// Should have one affected row
if ((oci_num_rows($result)== 0) ) {
echo "There was a problem deleting some of the selected 
items.".oci_error().'';
//exit();
} else {
echo "The selected items were successfully deleted.";
}
//direct the user back to the delete form
displayDeleteForm();
} //end function

//...function
 insertRecord()

function insertRecord()
{
// global $rowInsert;
global $connection;

global $dFields;
// Retrieve the posted log book information.
global $fields;
//  $messages = array();
//add some very crude validation
foreach ($fields as $field){
if (empty($_POST[$field])){
$messages[] = "You must complete the field $field \r\n";
} else {
   // $dFields[$field] = mysql_real_escape_string(trim($

Re: [PHP] windows 5.2.10 PHP not working with phpinfo

2009-10-03 Thread Fred Silsbee


--- On Mon, 8/31/09, hack988 hack988  wrote:

> From: hack988 hack988 
> Subject: Re: [PHP] windows 5.2.10 PHP not working with phpinfo
> To: "Fred Silsbee" 
> Cc: php-general@lists.php.net
> Date: Monday, August 31, 2009, 6:35 AM
> Please set
> log_error=on,error_reporting=E_ALL,error_log=syslog in
> php.ini and then,see error detail in syslog.
> 
> 2009/8/31 Fred Silsbee :
> > I got 5.3 working but found out there was no
> php_mssql.dll for it.
> > Somebody (who didn;t know) said I had to return to
> 5.2.8 but I found no 5.2.8 so I am trying 5.2.10
> > _problem:
> > under IE8:
> > http://72.47.28.128:8080/phpinfo.php
> > with:
> >      >       phpinfo();
> >     ?>
> >
> > I get :
> > The website cannot display the page
> > HTTP 500
> >   Most likely causes:
> > •The website is under maintenance.
> > •The website has a programming error.
> > ___
> >
> > I installed :
> > php-5.2.10-Win32-VC6-x86.zip and put php.ini in C:\PHP
> and C:\PHP\ext
> > AND C:\WINDOWS, C:\WINDOWS\system and
> C:\WINDOWS\system32
> >
> > I installed FastCGI 1.5 !
> >
> > In php.ini I put :
> > 
> >
> > cgi.force_redirect = 0                  //
> for CGI
> >
> > extension_dir =  "C:\PHP\ext"
> >
> > commented out
> > ;doc_root = "C:\inetpub\wwwroot" // for IIS/PWS
> > leaving
> > doc_root =
> > _
> > IIS 5.1 properties->configuration I added .php
>  C:\PHP\php5ts.dll
> > GET,HEAD,POST,DEBUG
> >
> > Maybe php-win.exe
> > _
> >
> > I added to the XP Prof environment path
> ;C:\PHP\;C:\PHP\ext\
> >
> > I created an environment variable (and rebooted) PHPRC
> = C:\PHP;C:\PHP\ext
> >
> >
> > I never found any statement of the necessity of
> requiring CGI
> >
> > The instructions ramble around
> >
> >
> >
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> 



thanks! Weeks back I got it to work by retreating to 5.2.6

and altering permissions in admin. This alteration may open the way for 

5.3 to work!

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] away from Fedora linux for a while and now this ...HELP

2012-08-24 Thread Fred Silsbee
Warning:  Unknown: failed to open stream: Permission denied in Unknown on line 0



Fatal error:  Unknown: Failed opening required 
'/var/www/html/log_book_MySQL.php' 
(include_path='.:/usr/share/pear:/usr/share/php') in Unknown on line 0

had to use Fedora yumex(yum) to install php

PHP Version 5.4.5 is seen in phpinfo
before now,  php was there and ready after Fedora install



[PHP] same php file, different day...worked 3-4 times in the past in the past

2013-01-20 Thread Fred Silsbee
Fatal error:  Call to undefined function mysqli__connect() in 
/var/www/html/log_book_MySQLnew_i.php on line 116

phpinfo.php shows mysqli

Additional .ini files parsed 

/etc/php.d/curl.ini,
/etc/php.d/fileinfo.ini,
/etc/php.d/json.ini,
/etc/php.d/mysql.ini,
/etc/php.d/mysqli.ini,
/etc/php.d/pdo.ini,
/etc/php.d/pdo_mysql.ini,
/etc/php.d/pdo_sqlite.ini,
/etc/php.d/phar.ini,
/etc/php.d/sqlite3.ini,
/etc/php.d/zip.ini
 

maybe a mysqli.ini is required containing mysqli.so

but 

[root@localhost php.d]# locate mysqli.so
[root@localhost php.d]# 
  
[root@localhost php.d]# locate mysqli
/usr/bin/mysqlimport
/usr/share/man/man1/mysqlimport.1.gz
[root@localhost php.d]#