image
image

Go Back   macosx.com > Mac Help Forums > Mac OS X System & Mac Software

Reply
 
LinkBack Thread Tools
  #1  
Old January 1st, 2009, 01:10 PM
Registered User
 
Join Date: Dec 2008
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
JelvisChan is on a distinguished road
Php

I just enabled PHP on my iMac 2008 ( Leopard ).

What I want to do is make a regular html form that, when submitted, goes into a database -- which I have used MySQL.

I made the html form, put I do not know how to link PHP and MySQL to process the form.

Please don't make your answer too technical because I am HIGHLY a beginner.

Thank you for your time.

-JelvisChan
Reply With Quote
  #2  
Old January 1st, 2009, 04:32 PM
ElDiabloConCaca's Avatar
Registered User
 
Join Date: Aug 2001
Location: San Antonio, Texas
Posts: 12,672
Thanks: 7
Thanked 388 Times in 370 Posts
ElDiabloConCaca is a glorious beacon of lightElDiabloConCaca is a glorious beacon of lightElDiabloConCaca is a glorious beacon of lightElDiabloConCaca is a glorious beacon of lightElDiabloConCaca is a glorious beacon of lightElDiabloConCaca is a glorious beacon of light
Then you may want to start off learning some simple php before you dive into database connectivity.

There are a few things you will need to learn before embarking on this project:

1) A working knowledge of HTML, XHTML, or some HTML derivative.
2) A working knowledge of web programming, including how web servers work and how to modify them (specifically Apache, since that's what you'll be using under Mac OS X).
3) A working knowledge of php -- what it is, how it works, and how to program with it.
4) A working knowledge of mySQL -- what it is, how it works, and how to create and modify databases and tables.

You would be best off learning those things in that specific order.

If you want someone to "do it all for you," then there are plenty of scripts and help files on the internet, easily found with simple Google searches.

I make a portion of my livelihood doing simple things like this, and generate income because I took the time to attend a university, ponied up my own money, and learned how to do these things the right way and the efficient way. For me to give that knowledge away for free would be both inconsiderate to you and silly for me. I would gladly do these things for you -- or walk you through the entire process and share my knowledge (in essence, "teach") for an hourly fee. I know that's probably not the route you want to go down, but it takes time, effort, and usually money to learn how to assemble all those technologies together to do the kinds of things that you want.

Instead, I recommend this: start off slow. Don't jump right into tying php to a SQL database. Learn php first. Then learn mySQL. Then the tying together is simple.

Research what you need, step by step, and I'd be glad to help you through any stumbling blocks you may encounter when you encounter them. Even though an HTML form that submits information via php into a database is relatively "easy," it's along the lines of asking, "How do I assemble a car engine? Go easy on me, I've never even looked under the hood of my own car." That's why mechanics get paid big bucks -- if everyone knew how to do it, there'd be no reason to ask and there would be no vocational schools that teach people how to work on a complex machine.

So you've got your html form... cool... do you know how to access the form fields of the HTML form using php with either GET or POST methods? If not, research and practice that, because that's step one in doing what you need to do. In your research and practice, if there's something you don't understand, or something that's causing you trouble, post back and we'll help you get through it. Then we can move on to putting that information into a database.

Maybe someone else will give you a detailed step-by-step, but I won't (and it certainly won't help you learn anything if someone does it all for you) -- I learned this through a lot of effort, practice, studying and money and I won't give that knowledge away for free. I will gladly help you overcome any obstacles one-by-one, though.
__________________
Mac mini 2.0GHz 10.6.2 • 4GB • 320GB • Superdrive • 4 x 1TB USB 2.0 • LED Cinema Display
MacBook 2.0GHz Core 2 Duo - White 10.6.2 • 4GB • 250GB • CD-RW/DVD-ROM
iPhone 3G 8GB • iPod Touch 8GB • iPod Photo 60GB • iPod nano 1GB • AT&T U-Verse 18Mb/2Mb
http://www.jeffhoppe.com
Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Forum Jump


All times are GMT -5. The time now is 06:48 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.0 RC1
Copyright 2000-2010 DigitalCrowd, Inc.