Can PHP Access Microsoft Access Databases?
Can PHP access Microsoft Access databases? Are there any basic scripts, any good sites out there? I just want to extract simple data from a table and display it on a webpage...as basic as can be to start.
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 !
Access Databases
I am a web designer who is slowly trying to learn more about web development. I have a client who would like to drive their website using a database so I am now in the perfect situation to move my skills forward. I know a little about databases or the scripting languages that connect them to web pages (is that the right terminology?!) but I am determined to improve my skills in this area. Code:
View Replies !
Converting Access Databases To MySQL
how to take an existing Microsoft Access database and transfer the records to an MySQL database. Preferably, I'm looking to write a script that will automatically take the Acces compatible file and write itinto the MySQL tables when the Access file is uploaded to the server...any suggestions?
View Replies !
Allow Users Access FTP Access Through A Browser.
I simply want to allow users access FTP access through a browser. However, I'm using a hosting company with cPanel and in order to set up an FTP account that only gives access to a specific subfolder on my account, a username is generated with an "@" in it. (ex. user@mydomain.com). This makes it impossible for to just enter the info into the address bar (in the form of ftp://user@mydomain.com@www.mydomain.com) because once the browser sees that first "@" sign, everything goes to heck... I've tried to just get the browser to prompt the user for the login info - which it does just fine everywhere I've tried it - but my client's computer is not doing it. I don't like telling clients to change setting on their machines, or install software (like FTP clients), because then I become tech support instead of just a web developer. I don't like the associated liability... Sooo - what I want to be able to do to solve all these problems is create a simple form that collects the server, username, and password; processes the info with PHP; BUT THEN just directs them into their FTP folder via the browser. What I'm finding is that everyone who has developed a PHP FTP login script has also developed some convoluted interface to go with it and they're either way too complicated for my needs, or they simply don't work. All I want to be able to do is allow users to input their username - with an "@" in it - and password, and then see the same thing that someone would see using the simple ftp://user:password@domain.com method.
View Replies !
How Do I Access /tmp ?
I'm on a shared server and use sessions for security. How can I check the /tmp directory to see if other users can read my session files? /temp doesn't show up in FTP. I'm obviously clueless about server architecture. Sorry for the lame question.
View Replies !
PHP & MS Access?
I'm asked to connect an existing Access DB to a site with PHP. There are some programs that work around that DB (CRM etc...), so if I upload the whole bunch to our hosting server, we are no longer able to access the db off-line from within these programs, right? So what might be the solution? Migrating to MySQL, converting the DB and doing everything on-line (I prefer working with MySQL, but what about the other programs then?), or doing everything off-line like we used to and uploading it the whole time (daily, so not very preferable). Or...? What do you think? Forget Access, go MySQL? Off-line / on-line?
View Replies !
Access DB
I was wondering as a new programmer to PHP if MY SQL is the only DB that PHP will work with, the reason I am asking is I am use to using access DB's when I was programming with iHTML and ASP.
View Replies !
PHP & MS Access
I wasn't sure if this belonged in General Databases or PHP, but I'm putting it here in hopes that some PHP guru's will have a little experience with this. I'm building a site for a new client and they already have a host and domain configured. The plan was to use PHP/MySQL for the entire site, except their host doesn't support MySQL on their Windows servers. (It's a Windows 2003 server BTW). The only DB support they have on my client's current plan is Access, FoxPro and DBase. I have extensive experience with Access but not for web applications. One thing I do know is that Access is far from speedy. Which brings me to my question -- do you think I should move ahead with Access and PHP, or try to transition over to a Unix server and get MySQL? They already have three domains on this host, all of their email, etc. It's a small business and they can't afford to give up their email for long. Whil I think Access would suffice for the time being, how much traffic do you think a PHP/Access site could handle and also do you think it would be a smooth transition to move the Access DB to SQL Server if/when the traffic demands the change? SQL Server requires additional money so it's not a reasonable option at this point without a great reason.
View Replies !
Php/DB Access
Ho un db in Access da mettere in rete. Sono riuscita a fare il collegamento e a interrogare il DB, sembra funzionare tutto perfettamente tranne per un importantissimo particolare...non riesco a visualizzare le immagini. Queste sono in formato jpg e sono state inserite nel DB tramite collegamento ipertestuale. Qualcuno riesce a darmi una mano?
View Replies !
Access, Php, Ado
I need to learn how to connect to an access database using ADO with PHP. ODBC is not an option. I anyone could point me to some tutorials, or give me some example code that would be great.
View Replies !
PHP + MS Access
I want to know if PHP can connect to a MS Access 2002 Database? If it is possible what is the script to connect PHP to MS Access?
View Replies !
PHP And MS Access + XML
I have resords in an access database. I want to retrieve them using php and generate an xml file with them. I can retrieve the records and generate an xml file but the xml file contains no data. This is the code im using: PHP: $query1="SELECT * FROM cust"; $result=odbc_exec($conn , $query1)or die("Query failed: $sql<br />Error: ".mysql_error()."<br />"); $xml = '' $xml .= '<?xml version="1.0"?>'." "; $xml .= '<!DOCTYPE customer SYSTEM "customer.dtd">'." "; $xml .= '<shop>'." "; while($row = odbc_fetch_row($result)) { $xml .= '<customer>'." "; $xml .= '<customerId>'.$row['custonerId'].'</customerId>'." "; $xml .= '<name>'.$row['name'].'</name>'." "; ///$xml .= '<address>'." "; $xml .= '<addressline1>'.$row['address1'].'</addressline1>'." "; $xml .= '<addressline2>'.$row['address2'].'</addressline2>'." "; $xml .= '<addressline3>'.$row['address3'].'</addressline3>'." "; ///$xml .= '</address>'." "; $xml .= '<phone>'.$row['phone'].'</phone>'." "; $xml .= '</customer>'." "; } $xml .= '</shop>'." "; $xmlfile = "C:phpdevwwwjimcustomers.xml"; $myfile = fopen($xmlfile,"w+"); fwrite($myfile,$xml); fclose($myfile); odbc_close($conn); and this is the XML it generates <?xml version="1.0" ?> <!DOCTYPE customer (View Source for full doctype...)> - <shop> - <customer> <customerId /> <name /> <addressline1 /> <addressline2 /> <addressline3 /> <phone /> </customer>
View Replies !
PHP To MS Access?
i'd like to know if PHP can be used to connect to MS Access? and if it can be used, is it the same way to connect to MY SQL?
View Replies !
Log In Access
i needed a login page for my website, so i found a code on gooogle, http://www.devshed.com/c/a/PHP/Creating-a-Secure-PHP-Login-Script/ that is what i found, i know i am probably using this rong but can some one tell me how to put it all together.
View Replies !
No Access To Php.ini
I have script which requires some of the php.ini settings to be modified. eg error reporting etc. I dont have direct access to the php.ini file on the production server I know I can override the .ini settings using <? ini_set("error_reporting", "some value"); ?> So what value can I use in my script to replicate the setting below? My .ini file on my testing machine has error_reporting = E_ALL & ~E_NOTICE; display all errors, except notices
View Replies !
Php Access
i'm hosting 2 sites on my web account. the 2nd site is on a subdirectory of the root like: /public_html/2ndsite is there a way to deny access to scripts executed in /public_html/2ndsite or below to all files in /public_html? this way if /public_html/2ndsite gets hacked, they can't delete files in /public_html/1stsite
View Replies !
MS Access In PHP?
I have problem installing mysql on my computer. However i can install apache server and phpmyadmin. That's the reason why i turn to MS Access for the database part. But i wonder can i use MS Access to replace phpmyadmin?
View Replies !
Access
Where's the best place to educate myself on how to use PHP in conjunction with Microsoft Access--good online tutorials, sites, blogs, etc...? I work at a small online grocery service that would like to develop interfacing between our databases with the web to allow customers/users to directly manipulate profile data and make orders that will filter directly into our database without manual entry.
View Replies !
Access API Using PHP
I use PHP as my main script on my webserver. I want to retrieve data in database server (oversea). The database server provides API (written in java i suppose) and it's available to download. So I download the API but dont know how to use it. jar file....the class that i want to access is in sub directoried, say : aaa/bbb/ccc/ddd/eee/<.class file>...... There are example files but all of them are written in java and there are something about java rmi etc. and if i want to run the examples, i have to call : java -classpath .:../lib/<.jar file> question : 1. can i retrieve the data from the server by calling the API (which is written in java) using PHP? 2. does the API can run the RMI automatically? note : i already setting up java_php bridge in my apache.
View Replies !
MS Access
i got to connect to an access database thru PHP on my localhost. but when i tried to put in the site (as well as the database of cousre), it doesn't work. do you know what can i do?
View Replies !
Db Access
I currently have a simple html website and a phpBB forum. I want to create a table on the webpage that automatically updates with the latest forums post whenever the page is loaded. What would be the best way to do this with php. I am a total noob at php. I'm guessing I need to query the database for the latest post but I'm unsure of how to do it.
View Replies !
Access With Php
I need to make a page that asks users from what date to what date they want the range to be within. The second page i need to make a graph (based on MS access data) the shows the top 5 parts(the part number is the primary key), and display their respective part name and furthermore, i must show the the details of the top 3 parts, meaning the top 3 part numbers that appear the most.
View Replies !
MS Access DB
I have a couple databases in MS Access that I would like to convert to MySQL. While speaking to a coworker a while back he mentioned having trouble with one of the free download tools that he used.
View Replies !
MySQL Vs MS Access
Thats right, I did say MS Access... Excuse me for not putting this in its proper MySQL forum, but I have seen some great debates recently transpire regarding technology choices, and I am in desperate need of expert opinions! My employer was recently bought out by another web development co. that unfortunately (for me) they specialize in ASP development... The funny thing is they don't even utilize MS SQL Server, they use MS Access. At first, I was astounded... Did they know something that I did not... Even Microsoft themselves have put huge warning signs all over their MSDN regarding Access's use over the internet... I was scared to even suggest this to the managers, for fear that they knew some way of avoiding the fact that Access does not possess the power that MySQL or SQL Server (for that matter -at least) do! In fact, I was dead wrong... They didn't know a thing! I even got in a debate with the lead Access "developer(?)"... He didn't consider MySQL to be a relational database because it 'did not support cascading modifications or referential integrity'... As well as it does not have a GUI considerable to MS ACCESS... I really just wanted to laugh at him, but I instead argued the usual points regarding portability, cost, as well as its close partnering with all of the available PHP functions for MySQL.which lead to a faster more effecient development process. I know that this message seems a bit on the immature side, but I am honestly not sure how long this company will survive if they are telling their customers to use Access (we just got contracted to do a large financial provider's website today - the managers are actually considering to advise Access!)... Anyone that can help me bomb these clowns with success stores (MySQL) or disaster stories (Access), as well as any other info, I would greatly appreciate it.
View Replies !
Limit Access
I have a admin page (password protected) and many other auxialary files the admin center needs all in the same directory. Is there a way to make the auxilary files accesible to the php script but not to other users?
View Replies !
We Can Use/access ActiveX?
1- I have heard that we can use/access ActiveX components in PHP. So how can i access them? 2- I want to use DataGrid/FluxGrid kind of ActiveX in my page for displaying Records, So can i use DataGrid/FluxGrid for this purpose? if (yes) { How? } else { Why Not? and which other Availabe component can help me like DataGrid in PHP. } 3- What is the Strength of PHP? Means that to how much extent we can go in it.
View Replies !
User Access
Can anyone help me with user access? I want to have different levels of access for users. For example; when I create accounts for users to og into my websitem, I want to be able to specify the level of access they will have. Let's say user A can access pages 1,2&3 and user B can access pages 3,4&5. I would like to have check boxes that I can check to allow them access to the specified pages!
View Replies !
Access Previous URL
I want to know what was the previous page my users browsed, is this possible? I though I could do this with getenv('HTTP_REFERER'); but that only seems to have a value when the user clicked a link. Is it possible to know the previous site no matter how the user landed on the page? Also, is it possible to retrieve the url of a frameset that is loading my page (either through normal frames or iframes)?
View Replies !
Access Rights
i want to know whether we can programatically give access rights to users while creating them. for eg.in the HR package i have three categories of users i.e. employee,Head of the Departments and director Personnel. all three will have different access rightsfor each form.i want to make a system which when creating a user asks for the access right for each form to be given.and then displays the menu according to that.
View Replies !
DB Access To DB MySQL
How is the simply way to transfert a DB Access with PHPMyAdmin to a DB MySQL? Exporting each table from access in format .csv, I have a little problem to insert them correctly with PHP my admin.
View Replies !
Page Access
I have a 3 page PHP script. I only want people to be able to access the first page of the script by URL. The other 2 pages need to return a message such as "This page can not be accessed directly." if someone tries to call it up by URL. I did this a month or so back using an If statement at the beginning of the PHP code. Something along the lines of: if (access_method=POST){ Perform PHP Code } Else{ echo "This page can not be accessed directly."; } I just can remember the correct method to call to check against, and I can't find the old script I worked on previously.
View Replies !
Dbase Access
I'm using Apache+php+win98. I need to access some dbase tables from my scripts eventually adding/modifying records. I know I can use succesfully a Microsoft Visual Foxpro ODBC driver, already installed with win98, in order to read records. But I'm not sure whether is it possible to lock dbase tables when adding/modifying records with this kind of drivers. Can someone give me a hint? An alternative approach would also be welcome
View Replies !
Access In Conjunction
I'm using the myODBC driver to get my MySQL database into access, but have a couple of minor issues there, can download it once, but can't seem to perform an "update" of the existing tables..etc.. perhaps something simple I need to do.. Other things I seem to be having problems with are creating list boxes.. I can make the box, and get "part" of what I want, but can't seem to get the value to "properly" match up to the keyID value from the "table".
View Replies !
|
TRACKER
