Need help with PhP vs. MySQL coding!

M-Jay

Hi there!

I'm kinda new to php and mysql. I know a little coding, but I often get stuck. Like now...:

I have a form where I write in information on different pages.

E.G: ID, Site name, short info, url.

Now when I have filled out the form, I want it to be stored in a MySQL table. I do not know the code for this. I have no clue at all. 🙁

Also I want the ID to automatically be one number higher than the last ID that was stored.

Could someone help me with this??

Thanx in advance.. 🙂

kamy99

The first thing you need to do is create the mySQL table, I hope you're using a tool like phpMyAdmin to access your DB, because that makes it easier for you.

In any case, you're table would have 4 fields, ID, SiteName, Info, url.
Set ID to Auto Increment, that way you achieve ID to automatically be one number higher than the last ID that was stored 🙂

Then you need to code your form to submit to your db.
I suggest reading a couple of tutorials, but it really is simple.

Your code would look something like this, but it could be different:

$sql=mysql_query("INSERT INTO `table_name`  ( `ID` , `SiteName` , `Info` , `Url`)

HTH

kamy99

I just noticed the php code above was chopped for some reason,
here it is:

$sql=mysql_query("INSERT INTO table_name ( ID , SiteName , Info , Url)
VALUES (NULL, '$SiteName', '$Info','$Url')");

M-Jay

Thanx for the help kamy99. 🙂

Only a little question: I am using phpMyAdmin, but I can't quite understand it.. I'm putting in these 5 fields:

id int(11) NOT NULL auto_increment,
name varchar(50) NOT NULL,
link varchar(100) NOT NULL,
info text(300) NOT NULL,
mail varchar(100) NOT NULL,

Now: What about the primary key stuff? Should "id" be primary key? And should I have any Unique keys?
And what should I choose between "Binary" and "Unsigned"?

I tried to get some help out of the documentation, but I couldn't find any answers. I was only more confused... 🙁

kamy99

yes put ID as primary key, as far as unique key, binary, ... leave them as default.

HTH