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 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 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 !
Phpmyadmin... Access Denied
I've just tried installing phpMyAdmin but it looks like I did somethin wrong. How did I install: 1. Installed Apache 2.0.48 2. Installed php 4.3.4 3. Installed Mysql 3.23.58 4. After installing Mysql I ran winmysqladmin.exe and created a username Timmers and password yyyyy I now have a folder on my computer called C:webserver and in this folder I have 4 other folders, apache, php, mysql and www (localhost). In the folder www there's a folder called phpmyadmin-2.5.4 5. I opened confiq.inc.php and filled in the following: $cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin-2.5.4/' $cfg['Servers'][$i]['user'] = 'Timmers' // MySQL user $cfg['Servers'][$i]['password'] = 'yyyyy' // MySQL password (only needed Then I typed http://localhost/phpMyAdmin-2.5.4 into my browser and got the following error: MySQL returned: #1045 - Access denied fot user: 'Timmers@localhost' (Using Password:YES) Does anyone see the problem? I'm very new to this and I'm guiding myself with a document I found on the web. But maybe the document has an error in it somewhere.
View Replies !
Access PhpMyAdmin From A WinXP Box
I feel like I'm so close, but I still can't get phpMyAdmin working. I am running RedHat 9, Apache 2.0, and mySQL. My SQL seems to run OK. I can create tables and insert rows, etc. from the command line on the server. I want to access phpMyAdmin from a WinXP box, and I just can't get it going, yet I can run simple phpScripts from the browser on the WinXP machine. I can open the phpMyAdmin main page from the winXP box but I cannot use the grants. I can't create a table or open a database. When I click on a database in the left hand pane I get a "page not found" error. I notice that there is no reference to php in my Apache config file (except an alias to the php directory).. I have set the authorize type to http, and when I run index.php I get the usual http authorization dialog. Somehow the connection from phpmyAdmin to MySQL isn't happening. It's bit confusing to me that the user referenced in the phpMyAdmin main page is the user on the XP box but the host is the host of the servver. Shouldn't it be the username on his own machine? Anyhow, there's something I haven;t set right and I can;t see what it is.
View Replies !
ACCESS Database & MySQL And Properties In PHPMyAdmin
I had an Access database and I had always used in my tables (whenever possible) pop up lists to choose elements.. for example, for a column I've wrote in "Datensatzherkunft" SELECT tbl.field1 FROM tbl WHERE tbl.field2 LIKE 'XXX' or I could say that only certain values are allowed: "X";"O";"S" as an example. Now I have exported my Access Database to MySql and established from Access a relation to MySQL so that I can update the database direct from Access and no from PHPMyAdmin. The problem is that these information about "where to whole the data from.." that's to say the "Select tbl.field1...." where not exported and in PHPMyAdmin I cannot find where I can define such attributes. If I try to do it from Access I receive I message saying that I cannot change the properties of the database since it is a linked (verknüpfte) table. Any idea how can I "export these properties too or redefine them in PHPMyAdmin?
View Replies !
PhpMYAdmin #1045 - Access Denied For User: 'root@localhost'
I have set my config file for a password with Mysql and phpMyadmin but when i try to load the phpMyAdmin page i get this error. ################# Error MySQL said: #1045 - Access denied for user: 'root@localhost' (Using password: YES) ################### I have set a password and want it to ask me for one but dont know how to go about it. If i dont set any password I can enter phpMyadmin no problem but soon as I change the configuration to have a password it wont let me in and wont ask for a password to authorize me. Is there a step im missing or somewhere I can read to learn how to get this working with the password.
View Replies !
PHPmyadmin Access Denied For User 'user'@'localhost'
WinMe machine as server, with Apache 2 installed and working PHP4 installed and working ( had PHP 5.05 installed and working, but i couldnt get the mysql extensions to load - phpinfo() didnt list mysql :(, so i installed PHP4, which now lists mysql when i run phpinfo). MYSQL 4.1 installed and working. I dont know the console commands too well, but i know its working ok, cos I have used a few simple DOS prompt commands to check its alive and I can connect to the database using MyODBC frontend/driver 3.51 and also using Navicat 2004. When i try to connect to the database via PHPmyadmin from another network PC I have an error: #1045 - Access denied for user 'user'@'localhost' (using password: YES) I have played around alot with different settings in the config.inc.php file.... nothing seems to work. This almost appears to be a simple login problem ( probably is too), but I can access the database locally from the Winme machine with the username and password that wont work over the network! I have tried not using 'localhost' as the host name but the IP address of the Winme PC but I get this error: #1130 - Host 'MYSERVERNAME' is not allowed to connect to this MySQL server
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
