I want to create dynamic websites with PHP and MySQL (with no experience). Help!!

[Bigbear]

I (bigbear) need starter suggestions. I have no database, or php experience.

What websites and books are good to start beginners in PHP and MySQL. What software do I need, where do I download it? what are approximate timelines for me to learn enough to start programming.

I also need to brush up on basic HTML, CSS, and JavaScript coding. Where would I learn these things?

Thanks,

Bigbear


***All of bigbears posts will now be consolidated into this thread***



if anyone could,i would like to know how to get a database and how it all works i REALLY need one for my users when they sign up with my site.

[jollyfactory]

how to get a database

Get a host that offers database as a backend?


how it all works

For that you'll need to learn a structured query language such as MySQL
http://www.analysisandsolutions.com/code/mybasic.htm
Should help.

[Bigbear]

what order should i go HTML,Java,Javascript,Perl,PHP in that order? i dont know where to start.:( i am only 15 but VERY willing to learn!

[Dr. Web]

forget Java right now. its object oriented, and much more than you need to create cool, creative, dynamic web sites.

Start with HTML, CSS, and Javascript:

www.trainingtools.com

[jollyfactory]

Originally posted by Bigbear
:( i am only 15
Age isn't a factor with programming ability.. I'm 15 also.

If you want to go onto PHP and mysql.. I have beginner tutorials at my site here http://resma.net/tutorials/php

[Bigbear]

i have a form now but how do i get a database to store it all?? i am using the "post" method not "get".All i need is to know how to store all my information on another page.Heres a example:http://www.xnu.com/formtest.MV how do i make my own CGI script?

[Horus_Kol]

when you "post" a form, all of the variables should be available in an array named POST on the next page.

The indexes of this array will be the name of the inputs on your form - like:

POST['name']
POST['age']
POST['email']


and so on...


in PHP you need to use the $ sign to show that it is a variable:

$POST['name']


not sure what language you are using though.

[scoutt]

if you are using cgi then you will need to look into DBI:: for mysql if you want stuff stored in the database.

although I can't see what that page signifies so we need to see your form andthe cgi script you have.

[Bigbear]

Ok scott here is the page http://www.freewebz.com/kourapets/Sign_up.htm when you get there you dont have to fill it out just click submit and you will see.The page it takes you to is not mine its another sites test page.

[scoutt]

Jeff, please hit the correct button when you reply to a thread. it is the reply button, NOT the create new thread button.

agaion, I don't know what this is

ACTION="http://www.xnu.com/formtest.MV">

what is formtest.MV. under my impression, MV is not cgi or perl. so the script will have to be cgi or pl

can you show us the contents of it?

[Bigbear]

i got the code for the thing at http://www.trainingtools.com/ and they call it a mivascript.Is that a new lauguage?

[Bigbear]

I need to know how to get a database for my site.Its a virtul pet site,so i need the database so when people sign up the information is sent to the database by "post" method.

[Bigbear]

making a money system????Like is PHP the best for making a money system? i need to know so i can start learing that langauge.

[scoutt]

hmmmm, Jeff. please keep all post in the same thread. it is not hard to read the buttons before you click.

now, the webhost does the db, you can't. you have to get a host that has one and that is all you can do.

[Bigbear]

i need to make a money system BAD its the key thing to my site and i also need it fast!:(

[scoutt]

ok. you are learning Miva, NOT cgi. if you want to learn miva then you have to use the miva language and not mix them.

and I don't believe it is a good idea as if I remember right it is a dying language. good luck :)

I don't know anybody that knows it.

[Dr. Web]

what is 'a money system'??

[ngaisteve1]

As a asp developer, I will recommend ASP. It is easy to learn esp when you already have VB and html foundation.

[scoutt]

Jeff, yes php is the best if you don't know any other language. you can't say fast becuase you have to learn it first and it will take months to learn any language enough to use on your site. so don't panic, just start reading the manual at php.net and some tutorials you find on the net. or you can just buy a book.

Doc, he wants a money system like neopets.com has. you know distribute money to gues for play.

[Bigbear]

I need one BAD! and i hope some one says yes to this question: is there a free database host?? if not i'm cooked :(

[jollyfactory]

yeh.. it will take months to learn as scoutt has already mentioned. I also second PHP as the language.

[jollyfactory]

Please confine your threads to one post if possible. You have started new threads in the serverside forum also when you could have just continued in the last thread you started.

Yes there are sites that offer free databases but most like http://coolfreepages.com have heavy advertising.

[jollyfactory]

You could also try
http://webmonkey.com and http://snippetlibrary.com

btw* please try to confine your posts to one thread.

[scoutt]

who is scott??? that is like the third time you said that. :P

also the best place to start is by reading. buy a book or borrow one. also you will find the manual very helpful

[Bigbear]

anbody?? and i know the answer but is there a free database??? if not i'm done for. :(

[scoutt]

grrr, Jeff, mysql is free, but you have to have a host that supports it. you can't upload a database to your host, they HAVE TO HAVE IT ON THE SERVER BEFORE YOU START.

there is a few free hosts that have databases and let you use serverside language. just have to serch this forum for them.

[Bigbear]

I need it because it will let people buy items and you earn money from playing games (its fake money and the items are fake)all my site is a not real world with make up items.Anyways i need to know a liitle more about the money system,any sites that could help me??

[scoutt]

you just don't understand do you. you NEED TO LEARN IT. nobody is going to write it and you might not findit on the web.

it will take months to do what you want. if you don't get this then I am sorry I can't help you any further. also if you ask this question again in another thread I will delete it.

EDIT: and quit calling me scott

[Bigbear]

I what to learn web programming and i NEED to now this only,In what order do i need to learn web programming.Example:HTML,XHTML,Javascript,PHP,Perl,MySQL ect ect.Now what i want is a list of options of what order i need to learn,not one thing i need a list from start to finish.Thank you.

[Dr. Web]

HTML
CSS
JavaScript
PHP
MySql
How To Research On the Web

[Bigbear]

i need a free web host that has mySQL.

[fredricknish]

This is what you have in your website -

"Help Wanted!! we need a game programmer and someone who knows how to make a money system!!! To take the job please contact us"

I guess your on the right direction,you need a programmer.But chances of anyone doin it for free are low.

or

as Scott said u can learn how to do it :D

[CTCecil]

That might be a bit hard to find. I had to buy hosting for about 2 years then my business started getting sponsered with free hosting. I am currently getting great hosting from http://fchost.us.

[CTCecil]

I used to be in the same position you are. I knew nothing about the whole web thing. Especially the MySQL backend. I used Flat File db for about 6 months. I never tried mySQL for the simple fact that I didnt know how to set up fields. What you need to do is get a server with PHP and mySQL installed.

I preffer contacting many hosts and asking them if they have MySQL (and PHP) if it doesn't allready say so on there website. Another good feature you might want is phpMyAdmin. Just my 2 cents.

[CTCecil]

Age does not matter. They used to say that to me but look at me now. My business is gonig fairley good and I am younger then you. Beleive it or not, I am 13. I know HTML, PHP, MySQL, JavaScript, CSS, some Java and I also have been doing good in programs like Photoshop 7, Cinema 4d XL, Fireworks 4 and more. Don't let your age make you think you cant do it because you can. One you learn HTML and CSS go on to PHP (i prefer) and once yo uget it down everything else is pretty much downhill...

[jollyfactory]

Bigbear you dont seem to be reading the replies that scoutt and I have been posting about keeping yer posts to one thread?

I'm just saying this as you have the same thread open in the "database" forum.

mysql is a free database, but only if you are a host do you have to pay some fee (or is that for php?). mysql is the database available on your host.

[Bigbear]

i dont know how to get the information form the form to the database.

[scoutt]

did you finally get a host that has mysql and php that you can use?

[Bigbear]

i found some sites but i had a difficult time signing up! :( is there ANY other database or anything i can use because mySQL is pretty hard to get.(for me at least)

[mikeyp]

try http://www.tripod.lycos.co.uk/

[scoutt]

Originally posted by Bigbear
i found some sites but i had a difficult time signing up! :( is there ANY other database or anything i can use because mySQL is pretty hard to get.(for me at least)
Jeff, listen as this is the last time I will tell you. PLEASE don't ask anymore questions about this db stuff until you have a host that has one, have code that will not work. this question and thread pertain to nothing.

you need to learn php and mysql. search the forums as it will have links to a lot of free sites with mysql.

if you ask once more about this site and a db and where to learn I will delete it.

[Bigbear]

are you able to download databases? here is the site i think the databases are free http://www.mysql.com/downloads/index.html And i know this sounds stupid but how do you download stuff? i think i can download stuff but how do i get the source cose or somthing to get to my site?

[jollyfactory]

bigbear.. I think you're starting to annoy some people on the boards now.

You dont seem to take notice or even read the replies to the threads you post. This question, and many others you have asked previously, and asked again have all been answered. You continually ask the same questions in different ways
e.g.
http://www.htmlforums.com/showthread.php?threadid=21374
http://www.htmlforums.com/showthread.php?threadid=21193
http://www.htmlforums.com/showthread.php?threadid=21390
in the above, you've asked the same question in different ways.

About your post, you already have a thread about this topic here (scoutts already told you to confine your posts to one thread if its about the same topic).
http://www.htmlforums.com/showthread.php?threadid=21430

Your question here has already been answered though in the following thread
http://www.htmlforums.com/showthread.php?threadid=21390

Originally posted by scoutt
grrr, Jeff, mysql is free, but you have to have a host that supports it. you can't upload a database to your host, they HAVE TO HAVE IT ON THE SERVER BEFORE YOU START.

Here's what scoutt had to say about db's in that thread.

[Bigbear]

I know i should post on one thread but no one eles will help because they think someone has.I know i'm not the quickest block in the box but i try.I just seem not to get things straight.Its just that i have been wanting to learn online web programming but its stressed me out.I have been looking everywhere trying to find a place to start but i have no clue where to start and where to go after i start.That's why i keep asking the same questions becasue i dont get the answer i think i would get.I'm sorry if i clog the boards if you want me to leave then i will not come back but its just i have a hard time understanding things.Sorry. :(

[JGAC]

Its ok, we are just trying to adhere to the rules, and one such rule is not cross posting, or posting the same subject in mulitple posts across multiple boards.

We are just trying to adhere to it.

And if you didnt understand it, you could have said that in the post that you did not understand.

[transmothra]

yeah, it was definitely nothing personal.

[jollyfactory]

If you didn't understand the answer that was given in one post, then you should say that you need more clarification in a reply to that post instead of starting a new thread asking the same question again as this makes everyone think you haven't read the answer in your previous post.

As JGAC said, it's just forum ettiquite here, if you didn't understand the answer or need more clarification on the same subject, you should continue the discussion in the same thread and say that you didn't understand something.

It definately wasn't personal or anything.

[Bigbear]

i need a site with a mySQL and PHP mainly but if there is a site with those two and other codes that would be GREAT!

[Uranium-235]

If you want to take it to the next level (and have broadband)....Download Apache, PHP, MySQL...fun for the whole family :D

[jollyfactory]

Originally posted by Bigbear
i need a site with a mySQL and PHP mainly but if there is a site with those two and other codes that would be GREAT!
At my website I've got php and mySQL tutorials
PHP Tutorials (http://resma.net/tutorials/php/index.php)
MySQL tutorials (http://resma.net/tutorials/php/mysql/index.php)

Mostly tutorials for beginners like yourself

[scoutt]

Originally posted by Uranium-235
If you want to take it to the next level (and have broadband)....Download Apache, PHP, MySQL...fun for the whole family :D
shhhhhhhh, don't say that. if he can't write it and can't show it on his website then what would be the point? you are talkinga bout somebody that is just beginning, no need to tell him to install something he will never use. :P