Build An Automated PHP Gallery System In Minutes Tutorial

[street_spirit]

Hi, wondered if anyone can help I have followed this: sitepoint.com/article/php-gallery-system-minutes/ and built the basic gallery thing, works fine. But I am basically trying to get the add new category to work and I can't work out a way to implement it and get it working with the snippet given:

function add_category( $category_name )
{
mysql_query( "INSERT INTO gallery_category(`category_name`) VALUES('".addslashes( $category_name )."' )" );
}

Call: add_category( “Category Name” );

Can anyone explain how I would implement this?

[AdRock952]

You could have a form with a text field for the name of your new category and after you post the form, you call that function

<?php
function add_category( $category_name )
{
mysql_query( "INSERT INTO gallery_category(`category_name`) VALUES('".addslashes( $category_name )."' )" );
}

if($_POST['submit']) {
     add_categoy($_POST['category']);
}
?>
<form name="form" action="<?php echo $_SERVER['REQUEST_URI'] ?>" method="post">
<input type="text" name="category" />
<input type="submit" name="submit" value="add category" />
</form>

very basic version and you need to check for sql injection

[street_spirit]

ah thanks, that's the start I needed.

[guido2004]

don't use addslashes to check user input before using it in a query, use mysql_real_escape_string instead.

[atlantadental]

Yes, mysql_real_escape_string is a much better method of injection prevention than addslashes. Remember too people can add in more than just quotes that can allow them to gain control over scripting on your site.

[street_spirit]

Hi again I have come back to this and am trying to have it so I can upload multiple images to each entry in the database. If that makes sense, so not just multiple image uploaded at a time but say each entry has a few images attached to it but am running into difficulty at the moment. I get no errors but it doesn't upload anything into the database, not sure where I'm going wrong as I have added other fields without problem but can't get it to work with extra photos, here is my code on the preupload, upload and view gallery, I have attached the files, any help would be much appreciated.

[street_spirit]

Not sure if that's clear, basically I want to be able to upload several pictures of the same thing from different angels and keep them together, so instead of clicking on the small thumbnail and only seeing one picture I want to see mutple images, this was the original tutorial sitepoint.com/article/php-gallery-system-minutes/

Been trying to work this out all day and just can't, any idea where I'm going wrong?