Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Developer Center > Web form using MySQL and PHP

Web form using MySQL and PHP
Thread Tools
Forum Regular
Join Date: Oct 2002
Status: Offline
Reply With Quote
Mar 18, 2004, 04:49 PM
 
Hello. I have tried searching for resource on the web but was out of luck. All I want is a simple web form so that I can input names addresses and phone numbers and have it stored in a MySQL database. After inputting, there it should generate the contents on the same page. Seems simple enough but I can't find anything for it. Any thoughts? Thanks and many thanks!
     
Senior User
Join Date: Aug 2002
Location: Oxford, England
Status: Offline
Reply With Quote
Mar 18, 2004, 05:19 PM
 
Buy a book (PHP & MySQL - Visual Quick Start Guide) or follow the tutorial here.

Take an input from an html form.
$email=$_POST[emailf];

Save this to a MySQL database
Connect to your database.
Use the SQL statement 'INSERT'

Show results/contents
Connect to your database.
Use the SQL statement 'WHERE' and a while loop to list the contents.
Put results in variables
Then echo the variables.
Luke
     
Forum Regular
Join Date: Oct 2002
Status: Offline
Reply With Quote
Mar 18, 2004, 05:29 PM
 
Thanks for the tip! I will definately give it a look

Originally posted by sandsl:
Buy a book (PHP & MySQL - Visual Quick Start Guide) or follow the tutorial here.

Take an input from an html form.
$email=$_POST[emailf];

Save this to a MySQL database
Connect to your database.
Use the SQL statement 'INSERT'

Show results/contents
Connect to your database.
Use the SQL statement 'WHERE' and a while loop to list the contents.
Put results in variables
Then echo the variables.
     
Senior User
Join Date: May 2001
Location: Nottingham, UK
Status: Offline
Reply With Quote
Mar 19, 2004, 04:43 AM
 
Have you created your database already?
     
Mac Elite
Join Date: Oct 1999
Location: San Jose, Ca
Status: Offline
Reply With Quote
Mar 19, 2004, 08:02 AM
 
     
Forum Regular
Join Date: Oct 2002
Status: Offline
Reply With Quote
Mar 20, 2004, 05:09 PM
 
Originally posted by larkost:
O'Reillys Web Database Applications with PHP and MySQL, 2nd Edition.
Thanks for the tips! I really appreciate all your help
     
Mac Elite
Join Date: Mar 2002
Location: Clogland
Status: Offline
Reply With Quote
Mar 20, 2004, 08:53 PM
 
Originally posted by larkost:
O'Reillys Web Database Applications with PHP and MySQL, 2nd Edition.
Wow, exactly what I was looking around for, almost bought the Php Cookbook yesterday, but seeing that, with the combination of Pear and O'Reilly ..... gonna get me a copy.
     
Mac Elite
Join Date: Mar 2002
Location: Clogland
Status: Offline
Reply With Quote
Mar 22, 2004, 09:54 AM
 
That book doesn't get realised till May btw.
     
   
Thread Tools
Forum Links
Forum 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 On
Pingbacks are On
Refbacks are On
Top
Privacy Policy
All times are GMT -5. The time now is 09:03 PM.
All contents of these forums © 1995-2011 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.7 © 2000-2011, Jelsoft Enterprises Ltd., Content Relevant URLs by vBSEO 3.3.2