Fermé

Create a database and a script in ASP and PHP to write and read from the database

I have been having problems getting my PHP and ASP websites to connect to a MySQL and Access database in my new Windows HostGator account. I will give you account access to a windows hostgator account.

Your job is to

· create a database using MySql so it exists on the website

* create a database using Microsoft Access so it exists on the website

· Create a table called Members in each database that has 7 fields: MemberID, FirstName, LastName, Address, City, State, Zip

· Create 2 scripts: One in PHP and one in ASP that perform the following database queries to the MySQL and Access databases :

o open the database

o write 3 records to the database using SQL. Make sure all Zip field values are 39233

For instance, (INSERT into TABLE VALUES ('Joe', LastName='Gred', City='Tulsa', State='New Jersey', Zip='39233')

o Update the records in the database to another set of values using the id of the ID

for instance : (Update TABLE set FirstName="XXXXX" and LastName="YYYYY" where MemberID=<the record just inserted>)

<the record just inserted> means you must pro grammatically determine the last table inserted and use that number as key field to modify

o read that record from the database using firstname and lastname as key fields (Select * from TABLE where FirstName=XXXXX and LastName=XXXXXX)

o print out all records to a webpage

· Close the database.

You will also:

1) Document all of the steps you take to create the database and the table in the database.

2) Tell me how to back up the database and how to open the database on my Windows 7 computer for editing. In other words, I need a program like Microsoft Access to edit a MySql .SQL file.

If you can only write a script in ASP or only for PHP you must specify this prior to beginning project.

If you can only create database code for MySQL or only for MS Access, let me know and I will consider.

Compétences : ASP, HTML, MySQL, PHP, Design de site internet

Voir plus : steps to create website, steps on how to create a website, steps of how to make a website, php create table, my sql create database, mysql city state database, how to write code, how to write a code in php, how to read computer code, how to open website, how to open my website, how to create webpage, how to create database using php, how to create database program, how to create a webpage, how to create a new website, how to create a database using php, how to connect to mysql database using php, how to computer program, how to computer code, how can one create a website, how can i create the websites, how can i create a webpage, create mysql database using php, code on how to create a website

Concernant l'employeur :
( 69 commentaires ) New Kensington, United States

N° du projet : #8464750

10 freelance font une offre moyenne de $36 pour ce travail

appleofficer

A proposal has not yet been provided

70 $ USD en 1 jour
(93 Commentaires)
6.8
braintechnos

Hi Dear, We are very confident to create a new WordPress template as per your given requirements. Brain Technosys Pvt. Ltd. is an ISO & Microsoft Certified Silver Partner company with 11+ Years of Elance History, Plus

24 $ USD en 1 jour
(36 Commentaires)
6.1
l4logics

Hii.. Can u explain me dear?? I will do this database work . I have 5 year experience in php,mysql,ajax Thanks

17 $ USD en 1 jour
(112 Commentaires)
6.1
anthonydarwesh

Hi, I can create both the ASP and PHP pages as well as the Access and MySQL databases. For editing the MySQL database you will need a program like PHP MyAdmin which should be installed on the Hostgator server or Plus

45 $ USD en 5 jours
(31 Commentaires)
5.5
chienthuatxd

Hi Employer, I am interested in your project. I can start to implement now Please award for me. Thanks and Regards

30 $ USD en 1 jour
(51 Commentaires)
5.0
rapiddevlop

i have develop more than 300 website in php and asp. so it is easy task for me. i have also more question for you. i want to discuss more.

30 $ USD en 1 jour
(23 Commentaires)
4.4
shadia301

I only work on wordpress and has a fluent knowledge in php. I have passed the wordpress exam with 80% in freelancer. I am sure that I am capable for the job. I have done several advanced job near past. You can Plus

35 $ USD en 1 jour
(13 Commentaires)
2.9
jshankar30081986

A proposal has not yet been provided

25 $ USD en 1 jour
(0 Commentaires)
0.0
lancerobot

A proposal has not yet been provided

25 $ USD en 1 jour
(0 Commentaires)
0.0
mindshaft

A proposal has not yet been provided

55 $ USD en 1 jour
(0 Commentaires)
0.0