Using PHP To Migrate Data From Shared Access Db To MySQL
I've read some online resources that utilize various MySQL
command-line actions to migrate data from Access to MySQL.
The situation is this: a group of co-workers of mine will be using an
Access db in a shared source (for now, a directory.. ???) to be able
to generate reports on the fly. What they want to do is to be able to
migrate that data to a MySQL db instance that currently exists on a
different server.
What would be the best way to do this within a PHP wrapper (if even
PHP at all, which I prefer); if so, what are the ways I can ensure
security as this is US Federal Government data and thus must be locked
down tight?
View Complete Forum Thread with Replies
Related Forum Messages:
Local Access Database To Shared PHP/MySql Hosting Export
My client has an MS Access database application on her local machine. I have full access to that in terms of changing the design. I've got a simple PHP/MySql application on shared hosting, so no direct access to the db server. I'd like to give her the facility to export the information in her local Access application to the shared PHP/MySql site. From one command button (or similar) in the Access application. It would be probably be a complete overwrite. That is to say all the information on the shared site would be overwritten with that from the local machine. I'm assuming that I'd have to make an HTTP request to some PHP page which would then run the SQL to delete all the records, then append all the new ones. Is this the right approach? I don't want to spend weeks finding out that this is fundamentally flawed in some way. The client has an ADSL connection.
View Replies !
Migrate Old Mysql DB To New Mysql Server
I am trying to migrate our old mysql DB to another new mysql server using AB: MySQL Migration Tool. The migration has some problem. One of the tables from the old DB had a column defined Datatype as DATE. However, when I do migration. The migration informs me that " The following error occured while transfering data from log Cannot convert value '0000-00-00' from column 13 to TIMESTAMP." I believe the migration forces to convert the datatype into timestamp. The work around i can do on this is to change the datatype of the column on the old DB into Timestamp. However, I don't want that. I want to retain the DATE datatype.
View Replies !
CRON Scripts Fail To Access Group-shared Directories
I have CRON scripts with owner/group relationship of "phillip/apache" that need to access directories within the docroot. The directories, if I create them, will have owner/group relationship of "phillip/apache", and all is well since they are all group-accessible (permissions of 0770). However, I have a web app within the docroot that has the ability to spawn folders of its own. These folders will, of course have owner/group relationship of "apache/apache", and for security purposes must also have permissions of 0770. When my CRON scripts accesses the "phillip/apache" folders, all is well. However, when it access the "apache/apache" folders, I get a PHP warning "Permission Denied" when trying to access these folders using this: Code: ( php )
View Replies !
ODBC Access Connection Failed To File On Shared Drive
I have been developing a web frontend to our company database on a local copy of the database, this has been tested and secured and working fine localy but when i change the location of the access file in odbc to the live database on the shared drive i get connection failed. So at first i thought ahh permissions but no.. there all fine! I went into MS excel and connected and pulled data off my odbc connection totaly fine?? any idea's on why it works for excel but my page returns connection failed? here is my connection code that produces the error. Noo error is shown after "Connection Failed:" any way to get an error reported? $conn=odbc_connect('pnctables','',''); if (!$conn) { Â exit("Connection Failed: " . $conn); }
View Replies !
Best MYSQL Data Access?
I was just wondering if anyone had, or knew of a good MYSQL dataaccess layer for PHP. I am using the smarty templating system, which mainly handles arrays and such so if anyone has any ideas.
View Replies !
Hiding MySQL Access Data In Php File ?
If I connect to a mySQL database with php I have to write the access data into the php file,eg.: $hostname = "my_host"; $username = "my_name"; $password = "my_pwd"; $dbName = "my_db"; $userstable = "my_table"; MYSQL_CONNECT($hostname,$username,$password) OR DIE("Unable to connect to database"); Is this secure ? In other words: can it be read by a bad boy ?
View Replies !
How To Grab MS Access Data Into Mysql And Vice Versa?
I'm developing an online ordering system, using PHP and MySQL database, which requires me to integrate with MS Access database to get some data . for example : application status. fyi, another system is developed using ASP and MS Access database to keep track of the application status since the status are always changing. i have to grab the application status of a particular record and update the MySQL database. this has to be done sort of the 2 databases are 'linked' together. any update/new records inserted into MySQL will be known by MS Access and any status update in MS Access will be known by MySQL. something like that.. is it possible to link the 2 different databases?
View Replies !
Read Data From MS Access Into MySQL In Real-time
I am currently working on a project that involves reading information from a inventory system into Access via ODBC and display the info on the web site using MySQL. I would like to create a live link between the MS Access(local) and MySQL (remote) whenever the inventory system is updated MySQL will be updated as well. I know that MyODBC will let me do the opposite of what I would like to accomplish by reading data in MySQL into Access. Is it possible to do the reverse way.
View Replies !
Sending Login/Pwd Through Shared SSL To PHP/MySQL
I'm adding secure login to a PHP 3 web application on Linux/Apache. I can't afford my own SSL certificate, so I'm using the shared SSL provided by my web hosting company. I tried this back in 2001, and I remember running into a snag. I was able to get the login/pwd to the PHP script on the web server, via the shared SSL connection with no problems. I was also able to connect my script to the database using a regular connection. When I put the two partial solutions together, it wouldn't work. Going though the shared SSL connection, I lost whatever permissions I needed to connect to the MySQL database. I kept getting errors about not being able to (something) the MySQL server. I couldn't get any help from my hosting company at the time (a freebie), so I ended up using a less-secure login :-P Has anyone else run into this or a similar problem? If so, how did you get around it (or did you get around it)?
View Replies !
Info() Question About Mysql=shared
My hosting firm uses virtual servers indicating each mysql server is separate. I see this on two of my accounts: '--with-mysql=shared,/PATH/' and the other one of my accounts at the same hosting company says: '--with-mysql=/PATH/' What does the SHARE mean?
View Replies !
Hiding MySQL Password On A Shared Server And Some Other Questions
I have a shared hosting account and have some questions. I would appreciate any help. Even if you have answered this before, please say so so I could search the forums using your name and find your post. What I have: CPanel Apache 1.3 PHP 4.3 as an apache module MySQL SuExec A user and group “sam” in the virtual host container for SuExec use. I am not familiar with perl programming. My main problem is that MySQL user name and password is visible to other users on the server if they log in using SSH or telnet and brows and read my PHP scripts. I did read many posts but I am not sure about how to solve this problem. I think I know what I need to do but please confirm or correct my understanding. 1.Can I install PHP as a CGI binary under my home directory even though I don’t have root privileges on the server and how and where should I setup the php.ini file? 2.Would that cause any problems for the other user on the server or for apache? 3.If I run PHP as a CGI will I be able to change PHP configuration using apache .htaccess files or will that only effect the PHP module configuration? 4.Is it possible to have some PHP scripts ran by the PHP module and some by the PHP CGI binary by setting different extensions or directories for the scripts? 5.The only way I can hide my password in these scripts is if I chmod to 700 and run them as a CGI script using SuExec. 6.If I only have one script (say secure.php) with passwords and other configuration information and give it access rights of 700 (to protect it form other users,) how can I include that file in other PHP scripts? My understanding of this is if apache is running a php script using its php module and the script has an include for the “secure.php” file it can’t include it because it doesn’t have access rights to it. Now, if apache recognizes “secure.php” as a CGI script, it will try to use SuExec and run it and then return to the including script. Is that correct and will the variables and environment be the same? In other words, if I set some variables in “secure.php” and use include from the main script, will the main script have those variables even if “secure.php” is ran by the PHP CGI binary? 7.Should I just run all the scripts as CGI with SuExec and avoid switching between the module and the CGI PHP interpreter. 8.Is there any better solution for this problem other than having a dedicated server?
View Replies !
PHP - Data From Access Db
I'm using the code below as a base for a connect to an access database. This works well, but I have an issue... <?php $db = "./access.mdb" ; $pass = "1234" ; $conn = new COM("ADODB.Connection") ; $sql = "DRIVER={Microsoft Access Driver (*.mdb)} ; DBQ=". realpath($db) ." ; uid=admin ; pwd=$pass ;" ; $conn->open($sql); $rs = $conn->execute("SELECT * FROM TableName"); while (!$rs->EOF) { echo $rs->Fields['FieldID']->Value ; echo $rs->Fields['FieldName']->Value ; $rs->MoveNext() ; } $rs->Close() ; $conn->Close() ; ?> using this: while (!$rs->EOF) { echo $rs->Fields['FieldID']->Value ; echo $rs->Fields['FieldName']->Value ; $rs->MoveNext() ; }
View Replies !
Using PHP To Access WinAmp Data
Does anyone know of a way to use PHP to display on a web page the playlist (m3u) information for a file currently being played by winamp? Note this is not about *controlling* winamp, but accessing data in real time to display current file / playlist name being played.
View Replies !
Access Data In Webpage
I have a data base in access having 6 columns and around 120 entries. I want some script or some coding through which I can extract the data into a webpage. for example say if I create a link with TTT and on clicking this TTT the next page should display the results from database in a webpage in table format ..
View Replies !
Data Access Class
I'm working on a class to access a MySQL database. One function I'd like to have is one that lists the records in a table. But, I'd like to be able to read from a loop. Ex: while ($x = $class->function()) { echo $x['fieldname']; }
View Replies !
Enter Data To Ms-access
i have a problem to enter information(record) to ms-access in php i have a error: "Warning: odbc_do() [function.odbc-do]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in C:Documents and SettingsAdministratorMy Documentsdb7.php on line.
View Replies !
How Can I Restrict Access To Data File?
I have a php script that processes a form and then posts the user input to a data file on the server in a comma delimited format. For simplicity call the file "data.csv." The script is working well and the data is posted correctly to the data file. The big problem is that anyone can point their web browser to...
View Replies !
Access Those Session Data Through Cookie
Now I just want to know if this is correct, if i store information in my session and i have a javascript cookie class, i can access those session data through cookie, correct because all a session really ism is a cookie, right?
View Replies !
Access Anonymous Ftp And Parse Data
Hello everyone. I'm definately a newbie at this so go easy. I am trying to get together a script to access some aviation weather from noaa. They have an anonymous ftp server that you can access txt files with weather data in them. I'd like to make a script to access the airports from a specific state (which are defined in the script which airports for which state) and echo that to an html file. The script would have to 'find' the airports in the txt file then parse out the info. Here is an example of what's in the data files. Code: 2006/01/18 17:00 GCFV 181700Z 190024 35006KT 9999 SCT030 BECMG 0911 10007KT TEMPO 0818 VRB03KT 2006/01/18 17:00 GCLP 181700Z 190024 01010KT 9999 FEW030 BECMG 0911 06008KT TEMPO 0818 VRB03KT 2006/01/18 17:00 GCRR 181700Z 190024 35006KT 9999 FEW030 BECMG 0911 09007KT TEMPO 0818 VRB03KT 2006/01/18 17:00 GCTS 181700Z 190024 05008KT 9999 SCT030 BECMG 0911 15008KT TEMPO 0024 VRB03KT Can someone kind of point me in the right direction on how to do this?
View Replies !
Access A Website, Fetch The Data, And Then Logout
I need to access a website, Fetch the data, and then logout. Please tell me where I am wrong. I dont think its logging out properly. <? include "Snoopy.class.php"; $snoopy = new Snoopy; //Logging in $submit_url = 'http://www.sortingcodes.co.uk/FormsLogin.asp?action=login&URL=Default%2Easp' $submit_vars["Username"] = "Username"; //my username $submit_vars["Password"] = "Password"; //my password $submit_vars["Submit"] = "Go"; $snoopy->submit($submit_url,$submit_vars); //Requesting for info $snoopy->setcookies(); $submit_url = 'http://www.sortingcodes.co.uk/Results.asp?type=Sortcode&Page=1&Sortcode=402343' $snoopy->fetch($submit_url); echo $snoopy->results; //loggin out $snoopy->setcookies(); $snoopy->fetch("http://www.sortingcodes.co.uk/logout.asp"); ?>
View Replies !
Multi-dimensional Arrays - Use Foreach() To Access The Data?
If I have a 2-dimensional array where the top key is year numbers (e.g. "2003"), the second key is month numbers (e.g. "8" to represent August), and the data stored is some cardinal number, how can I use foreach() (or anything else) to access the data? I want to write one line of HTML for each year, along the lines of: 2003 [ 8(23) ] assuming that 23 would be the cardinal number stored at $array[2003][8]. I s'pose what I'm trying to do is use the key, which is an array, as a string to print out. Or maybe I'm just confused? PHP Code:
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 !
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 !
I Haven't Access To Mysql NG
I haven't access to Mysql NG, so let me ask here. Query: select distinct a,b from a left join b on a.id = b.id table b: id datefrom dateto 1 2005-01-01 2005-01-15 2 2005-01-02 2005-01-16 1 2005-01-17 2005-01-31 In my case, I'd like to show the last date for any ID. So the result: 1 2005-01-31 2 2005-01-16 3 - How to do so ? In my case, I get two rows for ID 1 Must I run 2 queries ? It's really hard to create a query with GroupBy, as the real query takes 20 fields
View Replies !
Mysql Db To Access Db
im working with access databases... so i tried converting the code but im have a little problem... im probably making a mistake in the functions... does an1 one know where i screwed up? Code:
View Replies !
Access MySQL
I have phpdev working fine for php, but I am trying to set up a database now, and it seems like I remember setting up a password back when I installed it, but I have no idea what that was now. How do I find out what it was, and what the other information is?
View Replies !
Access DB To MYSQL
i need to convert an access db to mysql, how do i tell mysql to read an access file? Also the date table in the access is in a different format then in the mysql? Acess format: Month/day/year mysql: year:month:day so i tried changing the date column through phpmyadmin by typing in "'%c/%e/%Y'"in the values field. However the default still shows as 000-00-00.
View Replies !
Access To Mysql
I have an access database and some of the columns are Yes/No checkboxes (that is, in Access they appear in the "Datasheet View" as checkboxes). When I exported the database to a .csv file, I get 0's for unchecked and 1's for checked boxes. In my Mysql table, I'm using the enumerated data type for the corresponding fields ('y','n'). It appears that what's happening is that when I upload the .csv file to Mysql, I get the first enumerated selection on all fields imported.
View Replies !
PHP + MySQL Access Denied
I keep getting an access denied error when trying to connect to mysql using user@localhost. I can connect just fine if I use the IP address instead (ie user@192.168.1.5). I granted "user" privileges for everything so I don't see why that's the problem. Is this an issue where "localhost" is not getting resolved correctly? I'm on Linux, BTW.
View Replies !
PHP, MySQL & Limiting Access
I have a project for work, and I'm not sure how to efficiently do what I need to do. I'm hoping someone out there can help. Project is this: I'm creating a web-based interface where people at my company (operators) can enter data for service calls. All data entered is run thru one or more PHP scripts for error checking and then stored in a MySQL database on a server here in the office. What I'm looking to do is to limit access to certain operators so they can only do certain functions (ex: add a service call, but not delete one), whereas admins such as myself would have full access to everything. Ideally, at some point in the future, we plan to roll this interface out to our clients so they may do the same features within their company. Obviously, they would only gain access to data related to their company, as to protect the privacy of others. Hierarchy would be something like this: 1. UberAdmins (such as myself) -Have access to everything and to all commands. 2. Operators -Have access to everything, but not all commands. 3. Our clients -Have access to their data only, and to all commands. 4. Our clients' operators -Have access to their data only, but not all commands. The difficult thing is that our clients may run several businesses, so they would have to have access to several groups. In essence, they'd have multiple groups (their businesses) within a group (their group) within a group (everything). What is the easiest and most secure way to do something like this? I'm not looking for actual code but merely suggestions. Please reply if there is something I wasn't clear on.
View Replies !
Access Pictures From MySQL.
I'm planning on letting my users add pictures to their pages using the browser upload method. My question is, which is better? adding the picture to the database? or storing them on a separte directory and add a link to the page? I also will be letting each user have quota on the disk space.
View Replies !
Remote MySQL Access
Some partners of mine and I are writing a host-based application, which would greatly benefit if we could take advantage of a web services-like function we are formulating. Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers. In my experience, typically web hosting providers only allow localhost access to MySQL databases. Are there any providers who either allow remote access or does anyone know of providers specifically designed for this function? I did find one, but it is a "giveaway" when their product is purchased: http://www.navicat.com So far, I'm on page 8 of my 110,000-item result from a Google search.
View Replies !
Export Access To Mysql
I have the code to display the tables in Access now I need to take the data from access and replace the data in mysql The Access DB is the master and controled via are Doc Mang software blah blah The day-to-day users and testing Equi.... us the mysql DB. I have all the code to trigger the script for update once the DB is changed now just working on the mysql update side. I was thinking of placing the data from Access (at the same time it is being displayed) into an array then take that array and dump it into mysql Code:
View Replies !
MS Access To MySQL Conversion
I have a new host, and thus I now have the ability to use MySQL instead of Access. I have a simple script, which I need to convert the code to utilize the new database. I will worry about migrating the content aft er I get teh script working. Code:
View Replies !
MS Access Database To MySQL
I have a database fully populated in MsAccess and need to transfer to MySQL. I have tried to save the databse as .tab .csv .txt but nothing seems to work. Everytime I upload the file with PHPMyAdmin i get a bunch of garbley gook!! Any ideas?
View Replies !
Linking MySQL To Access
I installed mysql-connector-odbc-3.51.14-win32 and then I connected to my database. The problem occured because I have Cyrillic letters in MySQL database and the data I see in Access is illegible, and those signs can't be read or understood. How can I solve this situation.
View Replies !
|
TRACKER
