fmk Sat Mar 3 18:41:27 2001 EDT
Modified files:
/php4/ext/standard info.c
Log:
Changed code layout to remove PHP warning when running php as a CGI.
Index: php4/ext/standard/info.c
diff -u php4/ext/standard/info.c:1.129 php4/ext/standard/info.c:1.130
---
fmk Wed Mar 7 08:33:14 2001 EDT
Modified files:
/php4/main main.c
Log:
Removing a compiler warning
Index: php4/main/main.c
diff -u php4/main/main.c:1.355 php4/main/main.c:1.356
--- php4/main/main.c:1.355 Sat Mar 3 17:45:19 2001
+++ php4/main/main.c
fmk Fri Mar 9 15:37:56 2001 EDT
Modified files:
/php4/ext/mssql php_mssql.h php_mssql.c
Log:
Adding a new function mssql_next_result() allowing the query to return more than one
result.
This can be done with a stored procedure or by sending more than
PROTECTED] |
- | Frank M. Kromann [EMAIL PROTECTED] Support for DB/2 CLI |
+ | Frank M. Kromann [EMAIL PROTECTED] Support for DB/2 CLI |
+--+
*/
-/* $Id: php_odbc.c,v 1.72 2001/02/26 06:07:09
. |
+--+
- | Authors: Frank M. Kromann [EMAIL PROTECTED] |
+ | Authors: Frank M. Kromann [EMAIL PROTECTED] |
+--+
*/
-/* $Id: php_mssql.h,v
fmk Tue Mar 13 08:39:48 2001 EDT
Modified files:
/php4/ext/pcre php_pcre.c
Log:
Fixing compiler warning on win32
Index: php4/ext/pcre/php_pcre.c
diff -u php4/ext/pcre/php_pcre.c:1.89 php4/ext/pcre/php_pcre.c:1.90
--- php4/ext/pcre/php_pcre.c:1.89
uot;Source Files"
# PROP Default_Filter "cpp;c;cxx;rc;def;r;odl;idl;hpj;bat"
# Begin Source File
SOURCE=.\php_fbsql.c
# End Source File
# End Group
# Begin Group "Header Files"
# PROP Default_Filter "h;hpp;hxx;hm;inl"
# Begin Source File
SOURCE=.\php_fbsql.h
# End Source File
# End Group
#
fmk Tue Mar 13 13:02:52 2001 EDT
Modified files:
/php4/win32 php_modules.dsw
Log:
Adding FrontBase extension to modules
Index: php4/win32/php_modules.dsw
diff -u php4/win32/php_modules.dsw:1.38 php4/win32/php_modules.dsw:1.39
---
fmk Fri Mar 16 11:48:40 2001 EDT
Modified files:
/php4/ext/standard array.c
Log:
Fixing build on Win32 by adding missing BLS_FETCH();
Index: php4/ext/standard/array.c
diff -u php4/ext/standard/array.c:1.102 php4/ext/standard/array.c:1.103
---
fmk Tue Mar 20 11:21:45 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
Converting to c-style comments.
Adding prototypes to all exported function
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.1
fmk Wed Mar 21 11:56:34 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
changed arg types from pval* to zval**
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.3 php4/ext/fbsql/php_fbsql.c:1.4
---
fmk Wed Mar 21 13:53:45 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
setting right params to zend_get_parameters_ex
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.4 php4/ext/fbsql/php_fbsql.c:1.5
---
fmk Thu Mar 22 13:16:23 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
Adding warning when query fails
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.5 php4/ext/fbsql/php_fbsql.c:1.6
--- php4/ext/fbsql/php_fbsql.c:1.5
fmk Thu Mar 22 16:58:59 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
Removing extra check for warnings.
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.6 php4/ext/fbsql/php_fbsql.c:1.7
---
Hi All,
PHP is unable to resolve the variable you are trying to use within a stting. If you
use complex array structures you have to write it like this:
$sql = "insert into sessions(session_id, user_id, session_expiration) values
('$sess_id', " . $user_fields['USER_ID'] . "', sysdate + (" .
fmk Tue Apr 3 11:09:02 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
Fixing crash when listing databsaes
Fixing rowcount to woirk when the result contains an array og data.
Index: php4/ext/fbsql/php_fbsql.c
diff -u
Hi,
IBM DB/2 uses Call Level Interface (CLI) for communication between clients and server.
The ODBC driver from IBM is a simple one to one wrapper arround CLI, as CLI and ODBC
share the same specifications.
Using ODBC will give you an extra layer though. On *nix platforms you can compile usen
I do that all the time without any problems.
Could you give us a (small) sample script ?
- Frank
Hey,
Does anyone know WHY form scripts, that submit to themselves, dont work on
windows boxes?? Example :
I have a script called mail.php. The first part of the script displays the
form whos
Some databsaes allows batches of sql statements. Thes can be passed to the db server
in one query and the statements are usally separated by ;
If you are executing a batch of statements each returning a result you will have to
process each result in your code. This is supported by ODBC, MS SQL
Hi Eric,
You can use COM in PHP if your scripts run on Windows 32. You can also use Java clases
directly from yor php scripts.
- Frank
What is PHP's equivalent to ASP/COM or JSP/EJB? Basically, I want to get an
idea of what methods there are of having multi tier development in PHP. Any
Take a look at http://php.net/manual/en/function.imap-rfc822-parse-adrlist.php
This function will do the trick. You can also have a look at
http://php.net/manual/en/function.imap-mail.php. This is an extended mail function and
it works on both WIndows and *nix.
- Frank
I had to write my own
replace my old mail() calls? Don't I have to get a server that
supports it or something??
the regex thing I already got working...
thanks...
At 21:53 17/9/2001 -0700, Frank M. Kromann wrote:
Take a look at http://php.net/manual/en/function.imap-rfc822-parse-adrlist.php
This function
Hi Jason
You can download and install FreeTDS (www.freetds.org). Then you can compule with the
option --with-sybase=/usr/local/freetds. Thsi way you get the Sybase extension and
this includes aliases for mssql_*.
Be aware the FreeTDS can be used with MSSQL server 4 and 6 and in some cases
Hi all,
The dll is not broken.
The type UNIQUEIDENTIFYER is a 16 byte binary value and is returned as such.
With versions of the php_mssql.dll distributed with php4.0.5 or before did not include
proper support for binary data. This has been changed in php4.0.6.
I have hust added a small
Have a look at these two settings in your php.ini
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textlimit = 4096
; Valid range 0 - 2147483647. Default = 4096.
;mssql.textsize = 4096
- Frank
Hi,
I've hit a little problem... When retreiving large TEXT data (equivilant to
Hi All,
the key komponent is ntwdblib.dll installed in winnt\system32. The dll uses
other dll's to comunicate with the server dbmssocn.dll (tcp/ip) and dbmsnp.dll
(NetBios). All the communication dll's should be installed with the ODBC driver. Just
copy ntwdblib.dll from the SQL server to the
It is only the ' charactor there has a "problem" you have to excape any special
character before inserting.
the text Joe's should be inserted like this"
INSERT INTO table1 (int_field, char_field) VALUES (1, 'Joe''s')
A single quote is escaped by an extra single quote.
- Frank
I trying to
IF you dont specify --with-apache or --with-apxs configure options you will build the
CGI !
- Frank
Ok, I give up... how do I build PHP as a CGI-Binary? I've spent two days
searching the configure file for this.
Julia
--
[ Julia Anne Case ] [Ships are safe inside the harbor,
You can use something like this:
?PHP
$strMimeType = "image/gif"
$strName = "myfile.gif";
$iFileSize = filesize($strName);
Header("Content-Type: $strMimeType; name=\"$strName\"");
Header("Content-Length: $iFileSize";
Header("Content-Disposition: inline; filename=\"$strName\"");
fmk Wed Apr 4 13:10:14 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.h php_fbsql.c
Log:
Adding empty RSHUTDOWN function.
Index: php4/ext/fbsql/php_fbsql.h
diff -u php4/ext/fbsql/php_fbsql.h:1.1 php4/ext/fbsql/php_fbsql.h:1.2
---
Replace php_mssql.dll with php_dblib.dll. You aæso need to create a
freetds.conf file but you remove the limitations created by ntwdblib and
you get a thread safe environment.
- Frank
Our story is
We started building our application back in 2002 on FreeBSD/Apache with
PostgreSQL.
Than
Hello,
if you use:
header(Content-Type: application/zip);
header(Content-Disposition: attachment; filename=\somefile.zip\);
That works for me with IE 6/7 and other browsers.
- Frank
damn! that's a pretty good article, thanks a lot.
unfortunatelly, it's not mentioning about zip files
PHP5 is more than just OO features, SimpleXML, SPL, Filter and the newly
added Date/Time functions just to mention a few. If you need any of those
PHP5 is the way to go.
The first version of PHP5 was released in 2004, so it's been arround for a
while now. In most cases you can still use the old
Hi,
--with-mssql=/usr or --with-mssql=shared,/user should work with your
configuration. It's looking for /usr/include/tds.h or
/usr/include/freetds/tds.h. If the file was not found in any of those
locations you will get the error you are describing here.
- Frank
Hi,
I am trying to compile
The only other thing I can think of is permissions, but that would be too
simple.
- Frank
Hi Frank,
Thanks for the reply but the tds.h is located under
/usr/include/freetds
but the error persists.
Any other ideas?
On 1/10/07, Frank M. Kromann [EMAIL PROTECTED] wrote:
Hi
complete.
(It is safe to ignore warnings about tempnam and tmpnam).
On 1/11/07, Frank M. Kromann [EMAIL PROTECTED] wrote:
The only other thing I can think of is permissions, but that would be
too
simple.
- Frank
Hi Frank,
Thanks for the reply but the tds.h is located under
Hi Eli,
Check variable_order in php.ini
(http://us2.php.net/manual/en/ini.core.php#ini.variables-order) if the E is
missing you will not get any environment variables.
- Frank
Hi,
System:
Win32
PHP 5.2.0
Apache 2.0.54 (PHP in CGI mode)
CGI vars are not automatically
Take a look at the pow() function
http://php.net/pow
- Frank
Hi there list.
Thanks for your help with my other questions.
I was carrying on working through, and stumbled across a problem when
trying
to times something by the 'power' of something. By this I mean..in maths
you
can write 3
Hi Rick,
FreeTDS is still a fast moving target and so is PHP in some areas. Getting
pre-compiled RPM's would often force you to run older versions. Compiling
from source enables you to keep up to date with the latest features and
bug-fixes. If you are running this on multiple computers it's not a
On Thu, October 6, 2005 8:29 pm, Rick Emery wrote:
Knowing that I'm not the only one to want to connect to Microsoft SQL
Server on Windows from PHP and Apache on Linux, I'm seeking advice.
You may want to consider using the Sybase drivers if they are
available as up-to-date RPMs.
fmk Tue Apr 10 11:44:51 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
Fixing database password to actually work
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.9 php4/ext/fbsql/php_fbsql.c:1.10
---
fmk Mon Apr 16 09:27:12 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
Fixing memory leek on CancelFetch.
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.10 php4/ext/fbsql/php_fbsql.c:1.11
---
According to the documentation http://php.net/manual/en/function.mysql-result.php
mysql_result takes 2 and an optional third parameter. The second parameter should be
the row number.
- Frank
Hi, can some one please help me figure out why the value $device isn't being passed
on out of the
fmk Tue Apr 17 10:39:43 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.h php_fbsql.c
Log:
Adding fbsql_fetch_assoc() functon
Index: php4/ext/fbsql/php_fbsql.h
diff -u php4/ext/fbsql/php_fbsql.h:1.2 php4/ext/fbsql/php_fbsql.h:1.3
---
You can use
$temp = ord("A");
And you will then see that it's 65 end not 99 :-)
- Frank
Is there any function in PHP that I could use to know the number of the
ASCII table of letter "A" for example?
something like: $tmp=function_name("A");
$tmp==99 ("A" is 99 in ASCII table).
fmk Mon Apr 23 10:33:22 2001 EDT
Modified files:
/php4/main config.w32.h php_ini.c
Log:
Fix build on WIn32
Should the new directorys be static?
Index: php4/main/config.w32.h
diff -u php4/main/config.w32.h:1.40 php4/main/config.w32.h:1.41
---
Hi James,
No problem. I change it to
#define PHP_CONFIG_FILE_PATH getenv(SystemRoot)
What about all the other directories ? These should be configureable too.
- Frank
fmk Mon Apr 23 10:33:22 2001 EDT
Modified files:
/php4/main config.w32.h php_ini.c
+
+/*
to SystemDrive\\php4 but also allowing a envromental
variable to be set so
#define PHP_BINDIR (getenv(PHP_BinDir))?getenv(PHP_BinDir):c:\\php4
or somthing like that which works in C
- James
-Original Message-
From: Frank M. Kromann [mailto:[EMAIL PROTECTED]]
Sent: 23 April
fmk Wed Apr 25 11:00:55 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.h
Log:
removed unused code
Index: php4/ext/fbsql/php_fbsql.h
diff -u php4/ext/fbsql/php_fbsql.h:1.3 php4/ext/fbsql/php_fbsql.h:1.4
--- php4/ext/fbsql/php_fbsql.h:1.3 Tue
fmk Wed Apr 25 11:01:23 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
make fbsql_field_flags return a value
Index: php4/ext/fbsql/php_fbsql.c
diff -u php4/ext/fbsql/php_fbsql.c:1.12 php4/ext/fbsql/php_fbsql.c:1.13
---
fmk Wed Apr 25 12:45:14 2001 EDT
Modified files:
/php4/ext/fbsql php_fbsql.c
Log:
Remove c++ comment
Move errormessage when FBExec is not running. This error should not show if we
connect through a port number.
Index: php4/ext/fbsql/php_fbsql.c
diff
you just have to execute a statement starting and ending the transaction.
BEGIN TRANSACTION
COMMIT
ROLLBACK
Yuu send thes commands to the server with mssql_query() as any other SQL statement.
- Frank
I am trying to implement transactions using PHP and MSSQL 7 (Microsoft). Please
tell me
I would use gmktime() to create a UTC timestamp stored in the database, and then use
the knowledge about each users timezone to convert this information when showing it.
- Frank
I have a quick question regarding timezones ...
On the local side a record is inserted into the DB by someone in
FileInfo is not available on win32.
- Frank
Chris wrote:
Hi,
Are there any places that might have instructions on compiling PECL
extensions on Windows? I tried going the pear install package route,
but fileinfo is not considered stable yet.
Chris
Trying a PEAR or PECL list
Hi Jon,
You need to install the gmp extension. Not sure if this is included in the
snaps builds, but you should be able to download it from my site:
http://kromann.info/php.php.
- Frank
I asked this in the windows section yesterday and received no answer.
I have copied the sample of
Hi Kelvin,
You can use both PERL and PHP (prefered :-)).
You need to download, compile and install FreeTDS (http://freetds.org). If
you are using PHP you need to recompile it using --with-mssql. This will
enable the mssql extension. You can then create a php script to read the
text file, parse
Hi Kelvin,
You can use both PERL and PHP (prefered :-)).
You need to download, compile and install FreeTDS (http://freetds.org). If
you are using PHP you need to recompile it using --with-mssql. This will
enable the mssql extension. You can then create a php script to read the
text file, parse
At least on Windows you can send chr(13), and then rebuild the entire
line.
- Frank
Well I bet it would work on Win32, it just depends on how much CYGWIN
your willing to include with your program. I think all you would need
is
the basic CYGWIN DLL(s) and a terminal like bash (plus ncurses
Asuming the content is generated by php, take a look at htmlentities().
http://php.net/htmlentities
- Frank
How do I get this to work? the input box is only showing
He said,
input type=text value=He said, How'm I gonna get this to work?,
with a
frown size=50
James Hicks
--
If you are using the Apache module you need to restart Apache each time
you make changes to php.ini.
- Frank
EP And as far as IIS, I am running apache.
Heh. Well, then I guess I can't help you there, as I've never run
Apache on a Windows machine. :-)
Sorry. I hope someone else can
This is a bug in php 4.3.5 and it's fixed in the upcomming 4.3.6 release.
- Frank
Recap:
In the query I had;
SELECT totalamount
And it was returning;
Total Amount
5.41108926696E-309
I tried to modify the query to;
SELECT cast(totalamount as decimal(10,2)) as totalamount
And php
Hi Thomas,
What version of php are you using? Both PHP4 and PHP5 has the ftp
extension build-in so there is no need to load it.
- Frank
Hello!
I don't have a file named php_ftp.dll, where can I find it?
I've added extension php_ftp.dll but Apache says I don't have this file
:( Could You
Hi,
Though the ISAPI version is getting more stable it's still not as stable
as the CGI version. As an alternative to CGI you can use FastCGI. It
installs a module in the IIS web server and will preload a number of PHP
processes. This will make the web requests perform almost as fast as the
Hi Robert,
This line
header(Content-Disposition: attachment; filename=customers.xls);
forces IE to save. If you change attachment to inline it will open the
Excel in the plug-in imbeded in the browser.
- Frank
I have the script below from another source, and it works prefectly in
Mozilla,
You also need to change
header(Content-type: application/octet-stream);
to
header(Content-type: application/vnd.ms-excel);
- Frank
That just made IE put it out in data style, Excel didn't open up.
:(
Any other thoughts?
-Original Message-
From: Frank M. Kromann [mailto
Hi,
You should compile php with this option --with-mssql or
--with-mssql=/path/to/freetds.
This will enable the mssql extension. Enabling the DBX extension is not
enough. DBX is just a wrapper arround other extensions. You still need to
compile each of these extensions.
- Frank
I need some
There are two settings in php.ini mssql.textsize and mssql.textlimit. When
tese are set to -1 (default) the values used are configured on the server
and is usually 4k.
- Frank
Is there size limit for select queries in php?
I am trying to grab a very long string that exists in the database.
The user that runs the php script under iis (IUSER_maschine name) should
have permissions to execute the cmd.exe file, the .bat file and all the
commands included in the .bat file.
- Frank
The manual entry for shell_exec has a comment that notes to execute .bat
files with shell_exec, you
Sounds like a PHP version problem. PHP 4 will output 0 and PHP 5 will give
1. The constructor must be named the same as the class name in PHP 4 for
this to work.
You can have both constructors in your class so it will work in both
versions.
- Frank
I don't know the details of your app, but you
It Is doable. The native mssql/dblib extension does support that features.
I just have'nt had the time to code it for pdo_dblib.
- Frank
I too have been having problems getting the PDO dblib for mssql to play
well (getting the same error actually). If you find a reason or work
around for it
know if there is any plan to finish the
PDO-dblib driver?
TIA
-- Forwarded message --
From: Javier Ruiz [EMAIL PROTECTED]
Date: Apr 2, 2007 9:54 AM
Subject: Re: [PHP] PDO mssql + multiple rowsets
To: Frank M. Kromann [EMAIL PROTECTED],
php-general@lists.php.net
Hi again
finally have a need to add SSL to one more, but when I do the
first one (which is further down the file) comes up untrusted.
Since this is pretty far off topic I'd be obliged if someone who has
configured this before can email me off list for some assistance.
Much thanks!
Skip
--
Frank M
Not that I know of.
- Frank
On 3/8/10 2:21 PM, Skip Evans wrote:
D'oh!
...and I suppose there is just no way around that, eh?
Skip
Frank M. Kromann wrote:
You can only have one SSL per IP address. The SSL connection between
the client and server is done before the host header name is made
73 matches
Mail list logo
