Käynnissä

PHP MS ACCESS ODBC

I need a php sample code that can do the following:

1. connect to an MS Access database via ODBC (I already hace the DSN and working connection so there is no need to explain this part but just include it in the code. My Connection is called MyJigConnect and the username and password are: admin & passwd).

2. Also connect to a MYSQL database (this database contains the same tables as Ms Access, 6 tables in each). MYSQL connection details: localhost, db=test_database, UID=test_user,PSSWD=test_password.

3. The 6 tables in each database are called: Table1, Table2, Table3, Table4, Table5, Table6.

The fields for each table are identical to the table with the same name in the other database.

4. I need to EMPTY Table1, Table2, Table3 in the MYSQL DATABASE.

5. COPY ALL RECORDS from Table1,2 & 3 from the Ms Access Database and INSERT INTO Table1,2 & 3 in the MYSQL Database.

6. UPDATE ALL FIELDS for Table,4,5 & 6 in the MYSQL database with the value of the fields in Table1,2 & 3 from the Ms Access database.

Taidot: PHP, Visual Basic

Näytä lisää: php access database table1 table2, php and mysql connection, ms access with php, access insert php 2009, php access, php db, ms access, MS Access Database, dsn, C# access, c access, basic php, access, access c#, php code sample code, php connection, php access dsn, php code sample, database connection php, php connect, name empty, php localhost, odbc code, php connect mysql, connection php mysql

Tietoa työnantajasta:
( 2 arvostelua ) Shawnee, United States

Projektin tunnus: #425050

Myönnetty käyttäjälle:

wincent

pretty easy, ready to start.

100 $ USD 0 päivässä
(79 arvostelua)
6.0

13 freelancers are bidding on average $74 for this job

soner

I can offer my high quality php/msaccess programming services to you. Please contact if interested.

50 $ USD 0 päivässä
(122 arvostelua)
8.1
jigzyy

Sir, I am ready to do this work for you. see PM for further details. Thanks

50.5 $ USD 1 päivässä
(83 arvostelua)
7.3
MAnkita

Hello,Please refer your [url removed, login to view] you.

125 $ USD 2 päivässä
(75 arvostelua)
6.6
hsoft

ready to start.

50 $ USD 1 päivässä
(34 arvostelua)
6.4
fastphp

Lets do it as per

90 $ USD 2 päivässä
(29 arvostelua)
5.6
satoewarna

Ready and easy to finish it. Please check your PM

100 $ USD 0 päivässä
(39 arvostelua)
5.6
fedmich

easy to do :) let me do this one for you

50 $ USD 1 päivässä
(50 arvostelua)
5.3
rungxanh252000

yes, please give this job, i'm ready. thanks

50 $ USD 1 päivässä
(12 arvostelua)
2.6
yunshangsky

Pls see the PMB

50 $ USD 2 päivässä
(1 arvostelu)
4.0
mpatram

can be done...ready to do it.

50 $ USD 1 päivässä
(0 arvostelua)
0.0
globalesoft

plz see pmb :)

149 $ USD 3 päivässä
(1 arvostelu)
0.0
biprosaha1986

Hello sir, Ready to work with you. Thanks.

50 $ USD 3 päivässä
(3 arvostelua)
0.0