a PHP question

[BrotherBear]

hi all

wel I have mastered HTML and (almost ) CSS and now I want to use PHP and I have been learning a little about both PHP and My SQL but my question is
can I control my databases using only PHP without the need of entering to the database or not?

thanks

BB

[O~Snapple]

Well, if you mean you want to manage the database using PHP yes you can, i personally have opted to stay away from that, i am a big fan of phpMyAdmin Which i use to administer my database. But there are ways to create add delete and anything else regarding a data base using PHP.

~Snapple

[alwaysinit]

Yes, like O-snap said, php controls what goes in and how it goes in. I'm new to it myself, but as far as I can tell I would never have touch the database directly. The PHP script touches it all. It all happens in the PHP script.
But check out what O-snapple said "big fan of phpMyAdmin".
A complete beginner can use phpMyAdmin to handle every table and field in the database. Assigning values, defaults, types, indexes, and primaries is made very easy by "phpMyAdmin".

[BrotherBear]

thanks snap and alwaysinit that helps , actually I use phpMyAdmin as well but I am really new on using that feature can snap or someone explain me how it works or at least tell me where to find some tutorials about using phpmyadmin? thanks

BB

[O~Snapple]

Well what is it you are trying to do, each situation requires different things so lets see if we can sketch this out for you.

~Snapple

[BrotherBear]

well first I want to create tables to put infromation from users not like registering or something like that just a enqueries table from the users and once I create the tables I want to make fields like "lasname, firstname,age, comments" I want to name the table "customers" and when you create a table how to setup all the values and stuff

BB

[O~Snapple]

So this will be a personal database, you will enter all the data and make your own query's from it ???

If that is the case i would suggest using MS Access

If you want to use it from a web interface it might be smart to create a Form that you could use to qeury and enter data into the database

~Snapple

[BrotherBear]

well the thing is to explain it better, I have a linux based host so it does not allows any microsoft databases such as MSacces in my host I have one phpMyAdmin with MySQL I want to use it in my site, i want to make forms where users can submit there suggestions and stuff but inorder to submist this i want them to enter there name (last and first) age , and comments so I already created a table in phpMyAdmin but I don't know how to set the other values like Type lenght values collation attributes null default extra and the rest so if u could help me with this it would be great

BB

[O~Snapple]

Got ya it all makes sense now, Ok well in the Form Action should be called form1.php, you will want to make the fields for fname lname and comment required, or i believe it is not Null is how they put it, for the comment field you should use LONGTEXT i believe, and make a max characters like 250 or whatever you feel is necessary.

To be honest i dont know much about colliation but what i use and it works good is Latin1_sweedish_ci so you might want to give that a shot.

Does that make sense LOL

~Snapple

[BrotherBear]

thanks that helps I understand everything but what do you mean with in the form action it should be called form1.php?

BB