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
See Related Forum Messages: Follow the Links Below to View Complete Thread
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); ...
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.
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 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:
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.
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
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.
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?
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.
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
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 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?
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
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; ?>
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 :(
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?
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.
Microsoft And Zend Announce Collaboration To Enhance PHP On IIS
Microsoft's Product Unit Manager for Internet Information Services (IIS), announced a new collaboration with Zend to improve performance and stability of PHP on Windows. This isn't just vaporware, either. During Andi Gutmans' keynote (Andi is one of the creators of PHP and co-founder of Zend), Bill announced the availability of a technical preview release of FastCGI for IIS and demoed it for the audience as well. FastCGI is a new component for Microsoft's Web server platform that is available for download & evaluation today. It works IIS 6.0 in Windows 2003 Server and IIS 5.1 in Windows XP. Even cooler, it also works with the brand new IIS 7.0 making its debut with Windows Vista and, later, as part of Windows Server code-named "Longhorn." This announcement continues to solidfy IIS as the premiere Web application server whether you are developing sites with ASP.NET or any other server framework. Moreover, regardless of the programming language or framework they choose, developers building sites of any size can leverage the full capabilities of the Microsoft platform with enterprise-class security, speed and stability.
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...
PHP Equivalent For Server.CreateObject("Microsoft.XMLHTTP") In ASP
I'm new to PHP, so I'm trying to figure out how to do things that I used to do in ASP. One of those things is getting data from another web page, server-side. In ASP, I'd do this: Set objXML = Server.CreateObject("Microsoft.XMLHTTP") objXML.open "GET", strURL, False objXML.send() I could then use regexp to pull out data from objXML.responseText. How can I do the same thing in PHP?
Beyond PHPMyAdmin
I am looking for PHP suite similar to PHPMyAdmin that lets me manage a database from a web server. However what I want to be able to do is create custom forms for data entry rather than the automatically generated forms that PHPMyAdmin makes. Do you know of any such php-based solutions?
PhpMyAdmin
I have recently installed PHP Easy Windows on my win2k machine. Everything works fine, except when I try run phpMyAdmin (http://phpwizard.net) I get an error. C++ debugger says: Unhandled exception in php.exe (PHP4TS.DLL): 0xC0000005: Access violation My own mysql apps works fine.
Phpmyadmin
This may be seen as being off-topic, but I am not sure where I need to look for the appropriate documentation/tutorial. All I would like to know, if where (on a Linux system), I need to edit a file which will stop my login timing out after 3600 seconds. I've tried Googling for it for some time now (weeks, on and off), and I've tried the phpmyadmin docs to no avail. I refuse to believe for one minute that the answer to my question is not in the phpmyadmin docs, but I'll be damned if I can find it... I think I might be looking in the wrong place, as the docs I am looking through look sparse. I've tried searching through the phpmyadmin wiki for: time out timeout configuration Basically, anything I come across are problems people have reported, or about the actual web interface to phpmyadmin, rather than the configuration. If anyone can put me out of my misery, I would very much appreciate it.
PhpMyAdmin
I have the following code for index.php and i am asked to edit line 7 to allow access to an array of databases (instead of just one)...Does anyone know how to solve this? <?php require_once('lib/DataAccess.php'); require_once('lib/ProductModel.php'); require_once('lib/ProductView.php'); require_once('lib/ProductController.php'); $dao=& new DataAccess ('localhost','root',཈qwaszx','products'); switch ( $_GET['view'] ) { case "product": $controller=& new ProductItemController($dao,$_GET); break; default: $controller=& new ProductTableController($dao,$_GET); break; } $view=$controller->getView(); //echo ("<pre>" ); //echo ("</pre>" ); echo ($view->display()); ?> Moreover, i should be able to obtain a list of links of the names of the databases from which i can choose and view the contents of...
PHPMyAdmin
Running PHP 4.5.7 PHPMyAdmin 2.5.7-pl1 IIS 6 I am thrying to get phpmyadmin to work, but whenever I click a link or try to browse a database I get a 404 error, because the PmaAbsoluteUri auto-detection is nor working properly. Im pretty sure it is a problem with my php.ini file, but Im not sure where to look...
PhpMyAdmin
I have recently installed PHP 5.1.2.2, MySQL, Apache server all succesfully, but now i am trying to install phpMYadmin. I have configured with the config.inc.php, but when go into that directory to set it up, this is what i get:
PhpMyAdmin
I have a server with my own domain and have created some users under htdocs/users/. I have installed phpMyAdmin under htdocs/. Everything works, but I can't open phpMyAdmin. I have made an alias in httpd.conf: [KOD] Alias /phpMyAdmin/ "C:/Program/Apache2/htdocs/phpMyAdmin/" <Directory "C:/Program/Apache2/htdocs/phpMyAdmin"> Options Indexes MultiViews AllowOverride None Order allow,deny Allow from all </Directory> [/KOD]
PHPMyadmin
i am trying to learn php mysql and i am trying to learn these on an apache server. Mysql seems to work fine and so does my php and apache ( i downloaded them all from the official sites) I have now tried to download phpmyadmin but i just don't understand how you setup the program I have clicked to the following page http://localhost/phpMyAdmin/index.php but get this error message: Probably reason of this is that you did not create configuration file. You might want to use setup script to create one. Error: #1045 - Access denied for user 'root'@'localhost' (using password: NO) What do i have to do to fix this problem i have been searching through google and followed some tutorials but still can't get it to work.
PhpMyAdmin
I have set up the Xitami server (2.5c2) and PHP (5.0.5) on my Win98 system without any problem. I am trying to add PhpMyAdmin. When I try to load http://home/phpmyadmin which loads index.php, I get the following (lengthy) warning... Warning: main(./libraries/grab_globals.lib.php): failed to open stream: No such file or directory in C:XITAMI-25APPpublic_htmlphpMyAdminindex.php on line 8 Fatal error: main(): Failed opening required './libraries/grab_globals.lib.php' (include_path='.;c:phpincludes;c:xitami-25appincludes;c:xitami-25ap ppublic_htmlphpMyAdmin;c:xitami-25apppublic_htmlphpMyAdminlibraries ') in C:XITAMI-25APPpublic_htmlphpMyAdminindex.php on line 8 I have verified that the grab_globals.lib.php exists in the libraries directory. I tried removing the './' from the beginning of the path and the file is found but produces an equivalent error for ../libraries/common.lib.php when I remove the './' from the beginning of this path this file is apparently found but the page loaded is blank. Any help that anyone can give me with this would be greatly appreciated. If I haven't included enough info please let me know.
Phpmyadmin ...
I'm getting a message Directory Listing Denied, This Virtual Directory does not allow contents to be listed. I'm using WAMP5 and IIS, and the 'error' is displayed when i try to access http://localhost/phpmyadmin/ http://localhost/phpmyadmin/index.php error says: Cannot load mysql extension. IIS on default web site has phpmyadmin folder and index.php ...
Anyone Familiar With PHPMyAdmin?
In this script that I'm installing it says: "In PHPMyAdmin, click on browse items and then click on install. Enter an item id say 1? And then enter the name for that item." I don't see browse items anywhere and I don't see install anywhere. If they mean browse the items link on the left hand column then when I do that I still don't see install anywhere. Does anyone know what I have to actually do?
PhpMyAdmin And MySQL.
I'm new to these technologies (phpMyAdmin and mySQL). Basically, I installed phpMyAdmin in my host directory (where my website resides) and configured the config file, etc. However, once I try to login to phpMyAdmin I get the following error: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) 1.) Do I need to create a mySQL database connection in Dreamweaver for me to successfully login to phpMyAdmin? 2.) I'm having problems creating a mySQL connection in Dreamweaver, where I get the following error message: 1045 Access denied for user "vistaris@...' (using password: YES) 3.) Once I have phpMyAdmin login window, how do I know my username and password? Where do I create this? Or are they the same as my host username and password?
Upload Via Phpmyadmin
I have a problem which i think is a database issue, Using the phpmyadmin panel i can create a table in the database and input info manually no problem, but i have just got my hands on a .csv file, it looks the same as a normal excell file and is 4 cols wide, In my database i have created a table called "cars" and in that table have created 4 fields with names, now all i need to do is upload to this via the myadmin panel, so i went though the insert process but get an sql error returned, now i think the problem is the sql does not know what cols in the .csv file need to go into what field on the table, Things have been slowly sinking into place until i tried this, I know i could put the data in 1 field at a time but for a big database or regular updating that could take hours. Is there a way of nameing the cols in the .csv file so they match up with the online table.
Phpmyadmin Privilges
Hope this is the right place for phpmyadmin questions. I am having trouble getting the privledges to work on a remote mysql server. I have an instance when the IP works but can not duplicate it for another DB. I've tried to use the domain name returned by the error text but it doesn't work also. What do I need to know to get past the privledges, I can not find a good tutorial and the Docs for phpmyadmin are tough.
PhpMyAdmin Include
Keep getting this error, no matter what version of phpmyadmin i install Warning: Failed opening '/home/domains/php-haven.com/user/htdocs/phpMyAdmin/index.php' for inclusion (include_path='.') in Unknown on line 0
PhpMyAdmin Problem With PHP
with Red Hat and am not used to Linux. PHP seems to be working ok, and i can access mysql databases from the terminal - But having extracted PhpMyAdmin on to REdHat, phpMyadmin is showing the following error from the browser "cannot load MySQL extension, please check PHP configuration. DOCUMENTATION (link)" I have checked the documentation, and it says to install a package called PHP-MySQL. I have downloaded this and (i think) installed it. But the error message remains. I am not that great with Linux -
PhpMyAdmin Installation
I am trying to install phpMyAdmin 2.8.2 and have a question about config.inc.php. Is it necessary to include all of the $cfg fields in config.default.php, or is it ok to just have whichever fields I explicitly need customized, such as $cfg['Servers'][$i]['auth_type']? I am not clear on whether there are any security risks by not explicitly stating every field in config.default.php in my actual config.inc.php and whether or not the program will know to default to variables I don't state, even though everything seems to work fine without all of this info. I could not find this info anywhere in the phpMyAdmin documentation, which talks about setup.php but doesn't clarify if I need every field.
|
TRACKER
