• Registered: 2005-03-07
  • Posts: 362

Topic: Php / MySql Assistance Needed

Hi,

I have been teaching myself slowly about Mysql by just pressing buttons and seeing what it does, how it works, and trying to relate it to Punbb and the code I have seen when editing the pun-php.

I would like to learn how to make my own mysql database with a couple of fields. I would then like to know how I can have my customer contact page connect to my database to store the information. For example, a new customer would fill out a form telling me his name, email address, delivery address and if possible the chance to attach a doc.

It is probably very simple stuff but I dont have the guts to take the first few steps for fear it wont work first time around and I will give up forever.

Would somebody be willing to post a (very) detailed report on exactly how to do this, or walk me through it step by step over msn messenger? [downliner05@hotmail.com]. If you know of an excellent tutorial (with screengrabs) please also post links.

Thank you

Will

Punbb mods & styles

downliner's Website

  • From: Ottawa, Canada
  • Registered: 2006-09-05
  • Posts: 308

Re: Php / MySql Assistance Needed

http://sqlite.org/

Click on the "syntax" link at the top right. It's sqlite command syntax, but I use it all the time.

Plus, with sqlite you can run it locally (on your home computer) for testing, and not get complaints from your host if you bugger something up (or lose your real databse).

echo "deadram"; echo; fortune;
  • From: Leuven, Belgium
  • Registered: 2005-06-14
  • Posts: 2,653

Re: Php / MySql Assistance Needed

deadram wrote:

http://sqlite.org/

Click on the "syntax" link at the top right. It's sqlite command syntax, but I use it all the time.

Plus, with sqlite you can run it locally (on your home computer) for testing, and not get complaints from your host if you bugger something up (or lose your real databse).

You can run MySQL locally too wink

Anyway, what you're trying to do isn't hard and there are many tutorials available on this subject smile

  • From: Seattle
  • Registered: 2006-09-16
  • Posts: 7

Re: Php / MySql Assistance Needed

Yes there are and I really like Xampp for running php files locally since it already has everything inlcuded, unless you are dealing with (yuck) ioncube encoded files smile

Heres a nice tutorial on mysql:

http://www.php-mysql-tutorial.com/conne … ng-php.php

best,

Jan

Article Friendly, php/mysql article directory script!

hiredgunz's Website

  • From: U.S.A.
  • Registered: 2005-08-26
  • Posts: 1,607

Re: Php / MySql Assistance Needed

This site is very useful too: http://sqlzoo.net/

Looking for a certain modification for your forum? Please take a look here before posting.
  • From: Virginia Tech
  • Registered: 2006-02-28
  • Posts: 50

Re: Php / MySql Assistance Needed

http://www.webyog.com is a very nice GUI (graphical user interface) for working with your MySQL databases. It makes making a database and adding fields very easy. Mostly you can just right click and what you need will be an option, but if not there is extensive help and community support.

I would install PHP and MySQL and SQLyog on your local machine and begin to play around.

http://webmonkey.com/webmonkey/programm … index.html has a good tutorial on installing PHP and MySQL both in their PHP/MySQL Tutorial and PHP from the Ground Up  if you're new to PHP too.

Isaiah 40:31

andrewteg's Website

  • Registered: 2005-03-07
  • Posts: 362

Re: Php / MySql Assistance Needed

Thank you very much for all of the suggestions, I will begin printing out these tutorials you recommended and take a read of them smile

Punbb mods & styles

downliner's Website