Best way to insert and display things to mysql

Matt_Ramos

I'm working on a website for an engineering class where many projects are created. I'm not too good with PHP and MySQL, so I got a book and I'm learning.

I have a form that has "Project Name", "Project Summary", and "Project Thumbnail", which opens a file browser.

My database has a table called "projects", and it has those 3 fields. I post the form, but what should I be doing to get the variables into the database? Is this the correct way to insert them?

$insert="INSERT INTO projects (name,summary,thumbnail) VALUES ('$_POST[name]','$_POST[summary]','$_POST[thumbnail]')";

If so, how can I also get that file and upload it to projects/images? Then finally, how would I be able to display it?

Thanks, Matt

dalecosp

Originally posted by Matt.Ramos
I'm working on a website for an engineering class where many projects are created. I'm not too good with PHP and MySQL, so I got a book and I'm learning.

I have a form that has "Project Name", "Project Summary", and "Project Thumbnail", which opens a file browser.

My database has a table called "projects", and it has those 3 fields. I post the form, but what should I be doing to get the variables into the database? Is this the correct way to insert them?
$insert="INSERT INTO projects (name,summary,thumbnail) VALUES ('$_POST[name]','$_POST[summary]','$_POST[thumbnail]')";
[/b]

Well, you actually have to perform the query, though:

$insert="Insert into mytable values('foo', 'bar', 'baz'";
$success=mysql_query($insert);
if (!$success) {
   die("Couldn't insert data!");
}

If so, how can I also get that file and upload it to projects/images?

IIRC, there's a section in the manual on this....

Then finally, how would I be able to display it?

Thanks, Matt

Once you get it up there, I bet you can figure that one out. Otherwise, some of us geeks'll still be around later... 😉

Good luck,