Find Jobs
Hire Freelancers

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

$10-30 USD

已关闭
已发布超过 8 年前

$10-30 USD

货到付款
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.
项目 ID: 8464750

关于此项目

9提案
远程项目
活跃9 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
9威客以平均价$36 USD来参与此工作竞价
用户头像
Hii.. Can u explain me dear?? I will do this database work . I have 5 year experience in php,mysql,ajax Thanks
$17 USD 在1天之内
5.0 (182条评论)
7.3
7.3
用户头像
A proposal has not yet been provided
$70 USD 在1天之内
5.0 (105条评论)
7.0
7.0
用户头像
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 you can install it yourself. This will allow you to view the database and do other things like modifying tables and data and also exporting the data. Best Regards, Anthony.
$45 USD 在5天之内
5.0 (32条评论)
5.5
5.5
用户头像
Hi Employer, I am interested in your project. I can start to implement now Please award for me. Thanks and Regards
$30 USD 在1天之内
4.8 (52条评论)
5.1
5.1
用户头像
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 在1天之内
4.8 (23条评论)
4.4
4.4
用户头像
A proposal has not yet been provided
$25 USD 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$25 USD 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
A proposal has not yet been provided
$55 USD 在1天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
New Kensington, United States
4.2
70
付款方式已验证
会员自4月 7, 2006起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。