Microsoft And Zend Announce Collaboration To Enhance PHP On IIS

SQL Error: [Microsoft][ODBC Microsoft Access Driver] Too Few Parameters
I'm trying to execute the following SQL statement and get the following error.

SELECT DomainNames.DomainName FROM DomainNames WHERE DomainNames.DomainName Like "*ab*" ORDER BY DomainNames.DomainName

SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect

I'm running PHP4, Apache 1.3.12 (Win32) and connecting to an Access database on a Win2K box.

---

Odbc_exec(): SQL Error: [Microsoft][ODBC Microsoft Access Driver]
i am trying to write to the database through odbc. i get the following error:

Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in c:inetpubwwwroot514VIP_SurveyProcess.php on line 41

my directory has read/write permissions why am i getting this? here is the code as an example:
...
$x = 10;
$querySet = "UPDATE Survey SET $rdoOption = $x";
odbc_exec($objConn, $querySet);
...

---

Help: How To Organize Collaboration To Write PHP Code?
I'd like to write a web-application with other people.
It is the first time I write code together other person.
I'd like to ask you some advices:
1)have an advice?
2)wich program to use for VCS (for windows)?
3)how to organize the work?

---

Announce: Strg-c Opens Source Content Management
strg-c is an open source content management application suite. The system has a modular structure and can also be expanded with modules from third-party providers - open architecture. strg-c can be used for anything from simple editing tasks to complex portal functions. This means that the customer can use strg-c for different projects - a system environment for diverse projects. Roles can be assigned to individuals as well as to groups.

---

PHP On Microsoft-IIS/6.0
Is it possible to make IIS parse .html files the same way as Apache does
with AddType application/x-httpd-php .html in .htaccess?

---

Microsoft SQL Connection
I am looking to have a php page that will have a required include of a
config file with the MS SQL connection creation. I want to have a form
that saves into a MS SQL database. Could call out to a stored
procedure or have inline code in the php page.

Anyone have examples or generic sample code I can use?

---

PHP With Microsoft Sharepoint ?
I would like to ask if I can synchronize Sharepoint Services with my PHP
website?

Hint: I think it can be done by XML as a bridge.. but I am not sure and
wanna be sure.

---

PHP And Microsoft Access
Is it possible to use php to interface with an ms access database?

Our current database (customers, suppliers etc) is in ms access format and we need to run msaccess. I dont feel like converting the whole database over to mysql and we still need the original system, the idea will be that the staff can access the database on the road thru a webpage.

---

PHP And Microsoft Word
I have users who can sent a Word document as an attachment to an email
from a Microsoft-rich environment. I would like to be able to
"capture" that attachment as a blob and deposit it into a mysql
database. I am not sure how to do the capture.

---

PHP To Microsoft Outlook
Is it possible to send meeting notifications to microsoft outlook through php? I guess it would be sort of an e-mail sent to an individual telling them they have been invited to attend an event and the event info is automatically added to thier outlook calender or something?

---

Exporting To Microsoft Access
I have a PHP website with a mySQL database and a client wants to be able to see the database on his computer using Microsoft Access.

I would like to be able to make a special backdoor section for him, where he enters his username and password and is given a link which will make take a snapshot of the mySQL database and convert it to a Microsoft Access database which he can download to his computer.

Is this possible?

Since he isn't very computer savvy I need a way as user friendly as possible to let him download the database and view on his local computer.

---

Microsoft Exchange Server
Do any of you know a free PHP script that does the same stuff as Microsoft
Exchange Server?

---

Microsoft SAPI Problem With PHP
As I've found tons of VB and C# sample codes, I was trying to transform

it into PHP code, using the COM objects. My aim is to create a simple
html, that creates a wav from a text. Here's what I've tried -the php
script part-:

$Voice = new COM("SAPI.SpVoice");//works
//com_load_typelib("SAPI.SpVoice"); //This doesn't help...
$Voice->Speak("Hello!"); //works

$FileStream = new COM("SAPI.SpFileStream"); //works - I mean no error
$FileMode = SpeechStreamFileMode.SSFMCreateForWrite;// = 3 //works -
no error
$FileStream->Open("c:a.wav", 3, false); //works - no error
$Voice->AllowAudioOutputFormatChangesOnNextSet = false; //works - no
error
$Voice->AudioOutputStream = $FileStream; //HERE'S THE PROBLEM

$Voice->Speak("Hello world",1);
$FileStream->Close();

Here's the error I get for that line:
Uncaught exception 'com_exception' with message 'Error [0x80020003]
Member not found

---

PHP Wrapper For Microsoft SAPI
I can not figure out the reason why this does not go past step 2, it will not go to 2a. Code:

---

Microsoft Access -> PhpMyAdmin
Alright, so what’s going on is that I have coded an entire website with in mind to have an Access Database. So everything works great...

But now I am faced with the problem that I have to have my webpage work with phpMyAdmin, which works completely differently in running my sql statements and everything, ie: ->EOF, select statement, etc...

Is there a way for me to have a smooth transition for my code to work with phpMyAdmin instead of Access at the moment, because recoding all of this means an enormous amount of work with not much free time left on my hands. Code:

---

Microsoft Word Formatter
Anyone know of some sort of php script that can read and format Microsoft word documents?

---

PHP / Microsoft SQL V7/2000 - Page Results
Anyone know a simple way to page results of a SQL Select using Microsoft SQL ? I don't believe they have anything as handy as MySQL LIMIT.

---

Parse Error For Microsoft.XMLHTTP
I want the following ASP code to be rewritten in PHP:

<%
Set xml = Server.CreateObject("Microsoft.XMLHTTP")
xml.Open "GET", "http://www.mydomain.com", False
xml.Send
Response.Write(xml.responseText)
%>

I tried myself with ASP2PHP conversion tool. The following code was generated. But does not work. I get a parse error. Please help!

<?PHP
$xml->Open "GET" "http://www.mydomain.com" $False;
$xml->Send;
echo $xml->responseText;
?>

---

How To Embed Microsoft Word In A Page Using Php
how to embed or open microsoft word file in a page using php script

---

Any Ideas How To Run Macro In Microsoft Publisher Through PHP COM ?
my macro in Publisher changes "123" into "321" (example)
but I can't be able to run it.
This is how far I get throught with PHP & Publisher:

<?
$pub = new COM('publisher.application') or die('Unable to load
Publisher');
print "Loaded Publisher, version {$word->Version}
";

$pub->Open('xxx.pub');

$pub->Documents[1]->SaveAs('xxx2.pub');

$pub = null;

?>

this works, but of course does not do anything else than open xxx.pub
and save it as xxx2.pub. I am trying to run my macro:

$pub->Documents[1]->RunMacro(replaceme);

where replaceme is my macro. I tried different variations:

$pub->Documents[1]->Run(replaceme);
$pub->Documents[1]->Application->Run(replaceme),

etc but no luck so far :(

---

Microsoft Access Dropdown List
l am building a new site using PHP which has a lot of pages pulling from an Access Database. I would like to have a dropdown list that pulls exhibitions from the database and then when the user selects one it shows the rest of the details from DB just below the dropdown list, hope that makes sense. Code:

---

Reading Microsoft Office Documents?
I need to be able to upload a Microsoft office document and then show the contents to the visitor, in addition i need to be able to  write documents on the fly.

Is there a way of doing this, or will i have to spend days researching and programming my own classes to handle it?

---

PHP Will Not Read More Than 4096 From My Microsoft Sql Text Field.
I have a textarea that is saving to a mssql text (very large) field. The insert, update is working fine. However, when php reads the data using mssql_result function, I'm getting limited to 4096 characters read by php. I know that there are at least 6000 characters and I can see them using microsoft's query analyzer. This is not a magic quotes, single quote, quote, html entity or anthing like that. PHP will not read more than 4096 from my microsoft sql text field. Any ideas how I can get php to read more?

---

Insert Into Microsoft Access Table Using ODBC
The following lines of code don't return an error but they also do not insert the row into the database:

$SQLText="Insert into member (MailingID, MemberID, [File As], EMail, LetterID, AudienceID, DateSent, Sent) Select $MailingCode, $row[0], '".$row[5]."', '".$row[6]."', $LIDToInsert, $AIDToInsert, '".$DateSent."', 1;";

print '<br>'.$SQLText;

$rs_upd=odbc_exec($link, $SQLText);

if (!$rs_upd) die("Couldn't update database");

I've tested the resulting $SQLText string in Access directly and it works find there so this must be a PHP or ODBC issue.

---

Microsoft JET Database Engine Error '80040e10'
I am new to ASP, I am trying to create a page using ASP that will read from a database and write to my page, but I get this error every time: Microsoft JET Database Engine error ?e10' No value given for one or more required parameters.

---

Inserting A Date Into A Microsoft Access 97 Database
I was wondering if anyone could help me insert a short date into microsoft access 97 using php? i can insert text no problem but i can't seem to be able to insert a date properly. i have been using

//$date = "#" . "$sqlmonth" . "1" . "$cboyear" . "#";

$strSQL = "INSERT INTO tblSupport (tDate) VALUES ($date)";
$result = odbc_exec($connect, $strSQL);

Note: i can insert a date if i hard code it like putting in #01

---

Warning: SQL Error: [Microsoft][ODBC Driver Manager]
Cannot get an ODBC (or MSSQL) connection to MS Sql Server 7. Using a system datasource and it connects fine, but PHP does not like it. I've had no problem with NT4 but Win2K is another story...

Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:inetpubwwwrootindex.php on line 8

---

Can I Convert MySQL Db Records Into Microsoft Word Documents?
i found the solution to export
file from mysql db into *.csv. but is there anyway to convert the
contents into *.doc and save in my webserver and providing a link for
the end users to download the word file?

FYI, the database records are obtained by end users submitting the
forms themselve and i saved it in my db...

---

Zend
This has probably been asked before so apologies for that. I'm using
Dreamweaver for PHP and have been for nearly a year. I've done some
stuff that I'm very happy with but I'm getting to the stage where it
doesn't go far enough. I want something that will still automate a lot
of what I do rather than having to hand code 100%.

---

Zend Php
Anyone experience with Zend ? Is it worth to start investigation ?

---

What Id ZEND?
What is ZEND. Why it has anything to do with programming PHP?

---

About Zend PHP Certification
I am using PHP from last 1.5 years. Now I want to do PHP Certification.I need help for that. Please sugest me how I prepare for it. If you have any related study material then please send it to me.

---

Zend Certification.
Can  anybody send me any ebooks or study guide regarding Zend certification.

---

PHP And Zend Optimization
We are running the web host comparison speed project where web hosts are ranked on their speed.

One of the tests we use is a 100kb PHP file that is uploaded to the servers of the competing web hosts. The script calculates the time it takes to load the file.

We are encountering very fast results on web hosts that have optimized their servers with Zend.

Can anyone give me advice wether these speed results (that are 100 to 1000-fold faster than average) are accurate page load results? Do these results reflect the real page load time or does Zend just calculate and report the time it takes to execute the script?

---

Bug In Zend Studio, Anybody Else Have?
I've encountered an extremely annoying bug that I have no idea how to remedy. Even reinstalling doesn't fix it.

I have a project with a bunch of files, but something happened now when certain files will no longer show with syntax highlighted. They have the proper .php extension, code completion works, but syntax highlight is gone. And what ever I do, I cannot get the syntax highlight back on these files.

Has anybody else encountered this problem and know how to fix it?

I've tried renaming the file, reinstalling Zend Studio and recreating the project. None of works. These files just will no longer syntax highlight. They did at one time .. then somebody buggered in Zend Studio and they hadn't highlighted since.

I should also add, double clicking them opens the file in a background tab. Meaning, it doesn't pop the file in focus like it does other php files that correctly highlight within the same project.

---

PHP And Zend Optimizer
I keep hearing about this Zend Optimizer and stuff. I understand that it makes the PHP code run faster. My question is is Zend built into PHP 4 or is it a separate application to make it run faster? So, if I wanted to follow the instructions on how to setup the PHP/mySQL/Apache/SSL server, Zend would have to be done after everything else was set up. Correct?

---

Zend Studio 5.1
Has anyone tried zend studio 5.1 standard or 5.1 professional? If so
would you recommend me buying it? yes? no? why? Please I will greatly
appreciate all of the feedback possible.

---

Zend Support Is Really Bad.
just wanted to share my experiences with Zend "the php
company".
I decided to do the test drive of the Enterprise grade developer
studio.
Big mistake![color=blue]
>From day one I had nothing but problems.[/color]
After realizing that something terrible had happened to my webserver
during the install process, I figured WTF maybe I did something wrong.

I wiped my hard drive and started again, this time using the
Apache/MySQL/PHP that comes with it, rather than pointing it to my own.

Same result, but this time I realized the installer had fubared some
scripts and locations. It also missed a few permissions that it should
have set.

I tracked them down, repointed some scripts to the right sockets, and I
was off.
At that point I decided to install the Developer Studio Client on my
workstation.

That thing just crapped out saying it couldn't find some libraries.

So I created a support ticket to ask what I should do.
They kindly pointed me to an obscure knowledge base article, that
didn't appear when searching ANY of the keyword errors.

This article told me, that I needed to hexedit the installer, then
after it installed I had to hexedit the ZDE binary!

What the hell kind of installer requires you to hexedit it, before it
can work?
Furthermore the article claimed the binary was in a place that didn't
exist, so I had to updatedb and do a search on the filename, cross my
fingers and hope against hope I had picked the right one.

Fortunately I did.

After I installed the client, I decided to double check developer
studio server, and make sure everything was going fine.
Thats when I ran into this error.

"ini_modifier error: ini_modifier was not set"

It was the sole content on EVERY page!

I created a new support ticket asking what it meant.
They emailed me asking me to send them a file generated by thier
troubleshooting utility. So I ran the utility, and sent them the file.
Another day passes by, this time they ask for access to the server.
I give them the access they request and the password.

It's now been a week. I have updated the ticket daily asking if
anything has been done. They are completely silent.

Tonight I decided I had enough, told them thanks for showing me what it
must be like to be a real paying customer, and asked them to close the
ticket. I'll watch and wait and see how long it is until they get back
with me, or close the ticket.

And to add insult to injury, when I emailed my sales person who said in
his initial email to me, that he would be happy to answer any questions
I may have, etc and so forth. I got my message back in seconds,
stating that the email address was incorrect, the email was sent to
mark@zend.com same as the letter was sent from, same as he said was
his email! He's supposed to be the Director of Inside Sales, but it
appears in the 5 days I took to evaluate the product he has been fired,
or re-assigned or something.

Ok well I'm not out anything but a lot of my time, however I just
wanted to warn any developers considering Zend products, that they
didn't care about me when I was supposed to be evaluating the
enterprise grade product.

---

PHP5 And Zend
I have a little problem with debugging php application with Zend
Configuration:
WAMP5 (PHP5, Apache, MySQL)
Zend 3.5.2 (Debug Internal)

When debug Zend return this error:

Debug Error: C:wampwwwmybarphputils.inc.php line 42 - Call to undefined
function mysql_pconnect()

but in localhost connection works fine.

I know that is a php.ini ( of Zend ) configuration problem, but I don't know
how configure it.

---

PDT Zend Debugger
I am new to php. i have installed the PDT all in one package and then
i installed the zend debugger plugin for PDT. Every thing is running
fine and i am able to debug the single php page using zend debugger.
However, i want to know how i can configure it to debug the whole
project. I mean i need to debug all files at one time not single file....

---

Zend Optimizer
I just took over a project from another web developer who left 'under less than ideal circumstances'. Unforunately, all of his code was encrypted with Zend Optimizer and he took or erased all of the original code.

What I am wondering is if anyone out there knows of a way to de-encrypt this code.

---

Zend Framework
Could you please explain what is Zend framework? I am using php from last 2 years. How is it helpful to me?

---

Zend 4.0 And Mysqli
Im using Zend 4.0 IDE with PHP5 and I get this error

cannot find class mysqli. Any reason for this, im using the latest php
5.0.3.

---

About Zend Optimizer
is zend optimizer any good?

---

Can Zend Be Turned Off?
Is there a way to turn off the zend code that comes with php so that I
can see if some errors we are getting are coming from there?

I can't find anything in install docs or in php.ini

---

Zend Studio
I'm trying to figure out a problem with the zend studio 2.6 debugger. When I type ldap_connect(), I get an autocomplete dialog which tells me that this function is built in and recognized. But, when I debug the script I get a fatal error saying that I've made a call to an undefined function, ldap_connect().

My first thought was that there may be a version inconsistency between the editor and the debugger, but that shouldn't matter even if they're was because ldap_connect has been around since php 3, no?

---

Zend PHP Certification
Just curious, is anyone got a Zend PHP certification. Any
opinion/comments about this certification? I tried
<http://vue.com/zend/>,

---

Problems With ZEND And DLL And C++
I´m not sure if this is the right group...
.... if not, please tell me the right one.

Ich compile a DLL with VC6 with the switch /Tc.
So the DLL compiles as a C DLL.
This works.
But I need a class in my DLL.
When I compile without the switch, it compiles, but PHP says me, that that
is not a valid PHP DLL.
Is there an example how to compile a PHP C++ DLL?
Or can anybody give me a hint?

---

Regarding Zend Framework
I want to know more about zend framework.I don't know where to start with.I have downloaded zend framework .And i have gone through the some functions but i haven't got a good idea of it.

---