Microsoft Access Query
We are trying to select a record from a Microsoft Access database and display it on a PHP page on our site.
View Complete Forum Thread with Replies
Related Forum Messages:
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.
View Replies !
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); ...
View Replies !
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.
View Replies !
Microsoft Access
I wanted to find out if any of you know the odbc equivalent to mysql_query I'm using a Microsoft Access DB and need to insert values into a table ex. mysql_query("insert into cart(cookieId, MaterialListID, qty) values('" . GetCartId() . "', $MaterialListID, $qty)");
View Replies !
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.
View Replies !
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:
View Replies !
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:
View Replies !
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.
View Replies !
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
View Replies !
Inserting Records Into A Microsoft Access Database...
I'm still new at using PHP although thanks to these forums I'm learning quite a lot. Currently, I am trying to insert a new record into my access database. I can display records from it but not add new ones. I know that I am to use the 'INSERT' SQL function but how would an Access Database be different from mySQL? So far I've seen only mysql examples and havent been able to find anything on access...
View Replies !
MS Access Query Dates
I need to pull up records on dats but the format of the dates in the database are "21/05/2007 17:01:54" so my query: SELECT Maintenance_ID FROM Maintenance_Dbf WHERE [Date Logged] = $today Will not return any results.. do i need to somehow say if it's greater than..? and add 00:00:00 so everything today is greater than 21/05/2007 00:00:00? i have tryed LIKE $today as well as trying to use % in the statement but all with no joy.. Code:
View Replies !
PHP ODBC Update Query To Access
For some reason I am getting a datatype mismatch on the following SQL query and I do not understand why because the field datatype is number in the access database and the update query is using a number to update to that field? PHP Code:
View Replies !
ODBC Query Of Access 2000 Db Using LIKE
Attempting to query MS Access database with the ODBC drivers for PHP. When using the LIKE statement no records are returned. Example: $query = " Select * From Dispatch Where Customer Like '*A*' "; $result = odbc_prepare($db,$query); odbc_execute($result); Does anyone out there know the syntax that I should be using for the Like statement in the Where clause? When I do a normal query, it works fine....Just using wildcards it does not work....
View Replies !
Storing Query Failures And Access Via Admin Ctrl Panel
I am pretty concerned with security so Ive been thinking alot about how I tackle various problems. Basically I want to be able to log failed/ suspicious queries which contain stuff like: x' DROP TABLE tablename; -- etc etc into a table...however everywhere I see people use textfiles. I wonder why this is? Id like to be able to access suspicious queries via a part of my admin control panel, view the details and ban the user's account, his Paypal adress and account associated email adres with a press of the button if it contains malicious entries. It isnt very hard to do, I just wonder why people choose text files...which are easier to access if need be then a table (assuming all scripts are pretty secure ofcourse)
View Replies !
Weirdness: Mysql Query Works Fine On Netscape, Access Denied On IE
The error is the common "access denied to user@localhost on database," or whatever the exact language is. (I email from Linux so can't copy the exact wordage right now.) But like I say, it only occurs on IE running on the woeful Windows ME. I haven't tried it on another flavor of Windows. Netscape works just fine on whatever both OSes I have. Here's the code, short and sweet: // database variables $userName = GetDBUserName(); $password = GetDBPassword(); $dbName = GetDBName(); $hostName = GetDBHostName(); $db = mysql_pconnect($hostName, $userName, $password);
View Replies !
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?
View Replies !
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.
View Replies !
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?
View Replies !
Php+microsoft Sql Opinion
I use php with my mysql database a lot. I just had something come up where I need to access data from a microsoft sql database. Are there many problems with connecting php with a microsoft sql database? Would I be better off to use something like visual basic with asp?
View Replies !
Microsoft Frontpage
Is it easy to incorporate php into a microsoft front page website. I find it extrememly easy to create beautiful looking websites with frontpage but i want to add dynamics with php to it is that possible.
View Replies !
Microsoft SQL Server
I installed on my machine Apache2, PHP 5, and Microsoft SQL Server 2005 EXPRESS Edition. The op.system is Win2000. The problem, I can't connect to the SQL server via PHP. The PHP works, the sql server works(can accept connection with MSDE Query), and uncommented the line in php.ini about mssql extension. I tried with PHP 4.4.1 also, but still not working. After that I installed the SQL Server 2005 (not the Express version, but the 180 days trial version) on another machine, allowed remote connection, and I can connect to it via php without any problems.
View Replies !
Microsoft Word
I have an interface which allows people to manage and add customers. Each customer also has a category, for example 'Builders' I need a way of being able to do a mail merge to all clients with a selected category which is initialised from the web interface. For example, at the moment I can connect to MySQL and get all customers and if I go slightly further I could create a filter to do just what I need from within word. However, I need to be able to have the user choose which category from within their browser then click a button and it automatically does this filter. I was thinking maybe somehow I could export all users in a category to a CSV file and then have a mail merge doc setup which automatically pulled data from this each time the document was loaded - this would be OK I suppose if a word file could be opened which automatically had the desired filter.
View Replies !
Microsoft SQL ORDER BY
I am having a problem, I need to ORDER BY a "Reference number" field in my MS SQL DB, The only problem is, it is a varchar as it contains ref#'s like 1a, 22b, 43c. Obviously, with a straight ORDER BY I get a sort like 1, 10, 11a, 11b, 2, 21, etc I tried "CAST(SUBSTRING(ref, 1, 2) AS Integer)", however the lengths of the strings are different, theirfor I will get an error, "Can't convert 8a" etc. Any ideas on how I can sort this properly?
View Replies !
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
View Replies !
Converting .doc Microsoft Word
I have searched this form for this but was not able to find a clear answer for this. Is it possible to convert Microsoft Word ( .doc ) files to any other manupulatable format like txt, XML, HTML etc. I came across a script from phpclassess.org for doing this but it requires dom which requires windows which is not feasible for developement envionment.
View Replies !
Mail From A Microsoft Server
I am writing a script for a Win2000 server, it needs to be able to send email, but the server doesn't have an email server on it, is there a sendmail or qmail for windows? does anybody have any suggestions on how to make this work?
View Replies !
Support For Microsoft Servers
Please let me know if any one knows if PHP supports following MS servers and tools for the development and what interface does that provide. Microsoft .NET Servers BizTalk Server Commerce Server Content Management Server Sharepoint Portal Server SQL Server Integration/ Messaging Tools SOAP (.NET) Microsoft Transaction Server (MTS) Microsoft Message Queue (MSMQ) XML Web Services Microsoft XML Core Services (MSXML) .NET Framework Reporting and Analytics SQL Reporting Services FRX Crystal Reports
View Replies !
Escaping Function For Microsoft SQL?
I mainly know MySQL, but I'm porting some of my code to work with MS SQL Server. I normally run mysql_real_escape_string() on certain fields, but there doesn't appear to be a direct parallel for MS SQL. Ideally there'd be a function that works on both, so I don't have to customize it. Suppose I could write my own, but is there a more-or-less canned way of doing it?
View Replies !
Install PHP On Microsoft 2000 Professional
how to install PHP onto my computer. It uses microsoft 2000 professional. I have downloaded one of the later versions of the source code from php.net, but I'm having trouble configuring it. I tried the automatic installer, but I think it needs to be done manually.
View Replies !
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; ?>
View Replies !
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 :(
View Replies !
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?
View Replies !
Mail Merge Microsoft Word PHP
I have a database with patients name and address and i would like to send them letters. I would like to, from the click of a button, use php to retrieve the names and addresses, open microsoft word template, use mail merge and print out the letters.
View Replies !
Use A Microsoft SQL Database Using PHP Compared To MySQL?
I have only ever used MySQL with PHP but have been asked by a cleint if I would be able to develop a website and import data from an existing database that is updated by bespoke software that they have purchased and runs on their desktop machines (but the database is on a remote server). I guess what I am asking is how easy is it to use a Microsoft SQL database using PHP compared to MySQL?
View Replies !
Manipulate Microsoft Word Documents
I'm looking for a way to upload a microsoft word document to my server and count the number of words in it. does anyone know of any classes that i could use? i looked on php classes but couldn't find anything that will work on a linux box.
View Replies !
How To Create Microsoft Office Documents
I would like to use php to view, edit, and create Microsoft office Documents such as .doc, .xls, and .ppt using only php. In addition I would like to open these documents within a web browser and not the program itself. I googled and this is the best site that offer the most information, http://web.informbank.com/articles/t...-documents.htm All of the code does run error proof, but some work for example creating a word document and it doesn't have the functionality I am looking for. If you have any suggestions or can direct me to a tutorial on this subject, it will be of great help and appreciation.
View Replies !
Any Quirks Moving Form PHP/*nix To PHP/Microsoft
I've got a fairly sophisticated link management script that I've written in PHP and only run on *nix boxes. One of my clients is going to be launching a number of new sites over the next few months, but all of them will need to be hosted on Windows based servers due to the coding used for the sites (.net/sql). I know PHP is fairly cross-platform compatible, but I'm curious of any quirks I might run into when moving. For instance, my script makes heavy use of PHP's mail function, but since I have almost zero experience with windows servers I have no clue if there will be modifications required to get everything to function properly. Anyone with any experience happen to have any suggestions on what I might need to look at etc?
View Replies !
Apache Set Up On Microsoft XP Home Edition
I'm trying to install php/mysql and apache server on my PC. It's operating system is Microsoft XP home edition. I've downloaded and installed the files and made some changes i.e. renamed a file to php.ini and added some lines to the httpd.conf file. However when I try to view php in http://localhost it's advising that the page cannot be displayed. Is this to do with browser settings? Has anyone come across any similar problems? If so what did you do to get around the problem?
View Replies !
Create Microsoft Word Document
If I have a page of text generated through php on a blank page, is it possible to have a "submit" button that when it's clicked the text from that page goes straight to Microsoft Word.
View Replies !
Microsoft Exchange Mail Server
I have successfully setup my php.ini file on a web server to communicate with my Microsoft Exchange Mail server, and can test the ability to send mail using the mail() function to internet mail addresses. (mailboxes on our network), However, when attempting to send mail to an outside address (ex: someone at gmail dot com) the mail() returns "failed". Here's my setup. Windows 2003 IIs 6.0 webserver Windows 2003 box running Exchange 2003 Is it a change I need to make to php.ini to allow mail to outside email domains? Is it a setting I need to change within Exchange.
View Replies !
|
TRACKER
