| SitePoint Sponsor |
yes drewf,
This will be a large scale collaberation organised by me! Im gonna throw up a small site so people can see it all in one, the suggestions, progress, files, list of "collaberators", and a few help files about the installation and admin interface!
Plus a few customisation tutorials etc etc etc
Keep an eye on www.xsproject.info, i have been meaning to make ym site for ages and post all my scripts on there, so tha will be on there first and gimma a reason to get down to work!!!
Hey there,
Do any of you guys know how to change the image directory so it can be in another site. I have loads of space on my ntlworld account and I would like to upload the photos to there instead of my website space. Does anyone know how?
Thanks,
Ludders
Hey,
Nice site Infizi .. Cant wait to see the new additions ..
Cheers
i dont think u can upload to another site? you would have to use some sort of fput routine? you can show pics from the other site tho, just add tha domain name in the view.php file in font of all images,Originally Posted by ludders
you may be better up having the upload on your NTLspace, or just upgrading your web account?
How much space /BW do you want?> I can set u up a good hosting package, PM waht you want and i will get bank with a quote
Cheers mate, i dont have much time to work on it but will when i can! i wanna update th header a bit, get the gallery stuff up first tho!
Hey,
Any progress on the gallery yet?
Does anyone know of a good login system .. that allows users to change information, password etc .. maybe even with an admin page for seting user rights etc? also easily merged into themed sites?
Cheers
Hey, i havevnt had any time latly! Barely been near my computer!!!
More good idea to be input, i have exams soon (next week! :S) so i need to concentrate on them, but i will have some spare time in between, and lots after!!!
Hey again,
Sorry to keep bothering you. I am having the thumbnail of the newest image on my front page. I can do it but when I upload photos some of the thumbnails are .gif and the others are .jpg. Is there any way i can change:
so instead of .gif at the end it would work with both jpg and gif. I was thinking maybe a variable called $fileextension but I don't know how to make php recognise what file extension it had.PHP Code:<img src="http://www.mysite.co.uk/photos/<?php echo $photos['photo_id'] ?>.gif">
I am very stuck!
Thanks,
Ludders
hmmm, i guess you have changed the code???
In theroy, you should have a variable called $photos['filename']. If you dont, then its actually impossible, unless you use fopen to find a matching filename in your images dir, then get the extention.
Easist way (as i did) is to add a time variable into your database, i use the following code then
hope that helps!!!PHP Code:$query = "SELECT filename, title, size FROM images_table ORDER BY time DESC LIMIT 1";
$result = mysql_query($query, $connection);
$photo = mysql_array($result);
$img_src = "<img src='http://www.mysite.co.uk/photos/".$photo['filename']."'>";
BTW
UPDATE - My exams are over, so more time to do PHP, so, the XSP site will be fully functioning very soon!!!! I will post when i launch it (or its working or whatever!!!)
Hey ppl,
Exams .. ouch
I gotta few more ideas for the gallery ..
The Gallery Categories .. Show a thumbnail with the link to each categorie, maybe the first or latest picture added being the thumbnail displayed.
Thumbnail Listing .. When you click on that link .. have it go back to which ever page the image is on being viewed .. rather than back to page 1 .. Java I guess.
Thats bout it for now ..
Cheers
Hey,
I have build a membership system for my site which is used with the gallery ..
With the adminindex whenever I add:
I get the following error on the functions that exicute within adminindex.php:PHP Code:<?PHP
if($_SESSION['user_level'] == 3) {
script ..
} else {
echo 'You are not logged in .. login below:';
require '../login/login_form.php';
}
?>
Any idea why that is happeing .. If the login feature is removed the form works fine ..PHP Code:Fatal error: Call to undefined function: add_category() in /home/bla/public_html/album/adminindex.php on line 107
Cheers
Hi Guys,
I spoke to Drewf back in December but was subsequently seriously ill so never got round to posting my code. I have put subcategories in ina vary cobbled manner, by repeating code and adding an extra field into my database - it's not eaxctly 5th normal form but it works. The addition I really need is to control the order of the images and to be able to put blank images in as spacers.
A test version can be seen at http://www.charlieroff.com/gallerytest.html ...PLEASE DO NOT MUCK AROUND WITH THIS SITE. Some bright spark added their own images and it was a painful moment for me. I have done this site for free because I need a portfolio (I've been unemployed for 7 months and it's horrible).
Regards,
Anna
Hello,
I'm new to php/mysql and want to start on this project, but before I do I have one question.
I want to divide my photos into categories and then into albums.
Example: One category might be "Lake Photos", but inside that category I'm want to have several seperate "albums" - 4th of July photos - Memorial Day Photos, etc....
To do this should I create a 3rd table "gallery_albums" or should I add album_id and album_name to the "gallery_category" table?
Thanks for your help!
Todd
Example of what I want to do is here
http://benrud.net/pics/lake/2004_lak...rial_day.shtml
and here
http://benrud.net/pics/lake/2004_lak...u/amanda.shtml
If you make the followng assumptions, then this is how I woud have the tables
Each album can only exist in one category
Each photograph can only exist in one album
Category table
===========
category_id (primary key)
name
other columns
Album table
=========
album_id (primary key)
category_id (foreign key to Category table)
name
other columns
Photograph table
=============
photo_id
album_id (foreign key to Album table)
other columns
Hope this helps
Thanks! I'm new to this stuff and wasn't sure if I needed a seperate table for albums.
Just had a thought - you will probably get a better (more expert) response to this question in the database forum
I'm working on the second page of "Build An Automated PHP Gallery System In Minutes" where the "preupload.php" page is created. I'd like to include more information on the form.
Each photo needs a category, photo album, meta description, meta keywords, featured froducts (just text like the caption) and page title.
Below is the code I have and here is a link to the page on the web - http://benrud.net/preupload.php
I think it's set up correctly execpt I'm not sure how I should add the "album". Each photo will belong to only one category and one album. Each album will belong to only one category.
Please let me know iwhat changes I need to make. Thanks for all of your help!
Code:<?php include 'config.inc.php'; // initialization $photo_upload_fields = ''; $counter = 1; // If we want more fields, then use, preupload.php?number_of_fields=20 $number_of_fields = (isset($_GET['number_of_fields'])) ? (int)($_GET['number_of_fields']) : 5; // Firstly Lets build the Category List $result = mysql_query('SELECT category_id,category_name FROM gallery_category'); while($row = mysql_fetch_array($result)) { $photo_category_list .= <<<__HTML_END <option value="$row[0]">$row[1]</option>\n __HTML_END; } mysql_free_result( $result ); // Lets build the Image Uploading fields while($counter <= $number_of_fields) { $photo_upload_fields .= <<<__HTML_END <tr><td> Photo {$counter}: <input name="photo_filename[]" type="file" /> </td></tr> <tr><td> Caption: <textarea name="photo_caption[]" cols="30" rows="1"></textarea> </td></tr> <tr><td> Meta Keywords: <textarea name="photo_mets_keywords[]" cols="30" rows="1"></textarea> </td></tr> <tr><td> Meta Description: <textarea name="photo_meta_description[]" cols="30" rows="1"></textarea> </td></tr> <tr><td> Featured Products: <textarea name="photo_products[]" cols="30" rows="1"></textarea> </td></tr> <tr><td> Page Title: <textarea name="photo_title[]" cols="30" rows="1"></textarea> </td></tr> __HTML_END; $counter++; } // Final Output echo <<<__HTML_END <html> <head> <title>Lets upload Photos</title> </head> <body> <form enctype="multipart/form-data" action="upload.php" method="post" name="upload_form"> <table width="90%" border="0" align="center" style="width: 90%;"> <tr><td> Select Category <select name="category"> $photo_category_list </select> </td></tr> <!—Insert the image fields here --> $photo_upload_fields <tr><td> <input type="submit" name="submit" value="Add Photos" /> </td></tr> </table> </form> </body> </html> __HTML_END; ?>
hello all
First of all, i'd like to thanks for this stutorial and any post that helpfull for it
I all ready read all post here and attemped all the scripts
but, finally, i still not done this tutorials without your help
I got 2 problems
1. my thumbnails it is not show the pic (just red X)
2. when i try to full view the image, thi image show fine but on the top of the page show an error message as
and hold block code of it :Notice: Undefined variable: result_final in \gallery\viewgallery.php on line 118
any idea will be helpfullPHP Code:{
$result = mysql_query( "SELECT category_name FROM gallery_category WHERE category_id='".addslashes($cid)."'" );
list($category_name) = mysql_fetch_array( $result );
mysql_free_result($result );
$result_final .= "<tr>\n\t<td>
<a href='viewgallery.php'>Categories</a> >
<a href='viewgallery.php?cid=$cid'>$category_name</a></td>\n</tr>\n";
$result_final .= "<tr>\n\t<td align='center'>
<br />
<img src='".$images_dir."/".$photo_filename."' border='0' alt='".$photo_caption."' />
<br />
$photo_caption
</td>
</tr>";
}
regards
I'm still very new to php/mysql..... is this the correct code for the config.php file? When I upload the file and test it I get nothing, just a blank page.
Thanks for your help
Code:<?php // Before implementing this code, you should use your own username, password and database name values. $mysql_link = mysql_connect("db151.perfora.net", "dbo118613358", "********"); mysql_select_db("db118613358") or die("Could not select database"); $images_dir = "photos"; ?>
I thought
you replace db151.perfora.net by localhost instead of
hope it help
Here’s the deal… I need help with this tutorial and I’m willing to pay/make a donation to anyone who can and will help me.
I currently have no programming or data base experience but I’m enrolled in a basic web programming class at my local community college. What I need to do is get this tutorial working on my site with a few minor changes.
----I need to add additional fields besides “caption” to each photo (meta keywords, meta description, page title, featured products)
----I need each photo to belong to a category AND an album. Each photo will only belong to one category & album and each album will belong to only one category.
An example of what I want my photo album database to do can be found at the following addresses.
Example of an album page from the lake category - http://benrud.net/pics/lake/2004_lak...rial_day.shtml
Example of a photo page from a the memorial day album in the lake category - http://benrud.net/pics/lake/2004_lak...u/amanda.shtml
Please e-mail me at todd@benrud.net if you are interested in trading some help for some cash.
Thanks for your time and assistance.
Benrud
Hello All,
I want to tried out from here to create agallery system
but I have found fatal rerror
My error is:
Fatal error: Maximum execution time of 30 seconds exceeded in d:\www\ujjwal\upload.php on line 30
means in a while loop
MY preupload.php is
My upload.php isPHP Code:<?php
include 'config.inc.php';
// initialization
$photo_upload_fields = '';
$counter = 1;
// If we want more fields, then use, preupload.php?number_of_fields=20
$number_of_fields = (isset($_GET['number_of_fields'])) ?
(int)($_GET['number_of_fields']) : 5;
// Firstly Lets build the Category List
$result = mysql_query('SELECT category_id,category_name FROM gallery_category');
while($row = mysql_fetch_array($result)) {
$photo_category_list ?><select name="a">
<option value="<?=$row[0]?>"><?=$row[1]?></option>
<?
}
mysql_free_result( $result );
// Lets build the Image Uploading fields
while($counter <= $number_of_fields) {
$photo_upload_fields ?>
<tr><td> Photo <?=$counter?>: <input name="photo_filename[]" type="file" />
</td></tr>
<tr><td> Caption: <textarea name="photo_caption[]" cols="30" rows="1"></textarea>
</td></tr> <br>
<?
$counter++;
}
?>
// Final Output
<html>
<head>
<title>Lets upload Photos</title>
</head>
<body>
<form enctype="multipart/form-data"
action="upload.php" method="post"
name="upload_form">
<table width="90%" border="0"
align="center" style="width: 90%;">
<tr><td>
Select Category
<select name="category">
<? $photo_category_list ?>
</select>
</td></tr>
<!-Insert the image fields here -->
<input type="text" name="photo_captions" value="">
<? $photo_upload_fields ?>
<tr><td>
<input type="submit" name="submit"
value="Add Photos" />
</td></tr>
</table>
</form>
</body>
</html>
Yes i have using one image from my desktop and the 4 places are empty.PHP Code:<?// Fetch the image array sent by preupload.php
include 'config.inc.php';?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2"><img src="../img/banner2.jpg" border="0" vspace="0" hspace="0" name="banner"></td>
</tr>
<tr>
<td valign=top width=16% class="menu">
<? //include_once("../menu2.php" ); ?>
</td>
<td width="*%" valign=top>
<?
// include the database specific information
//include_once("../inc/db.php" );
// make a connection to the rrc database
//dbConnect();
$images_dir = 'photos';
// Fetch the image array sent by preuploaed.php
$photos_uploaded = $_FILES['photo_filename'];
// Fetch the image caption array
$photo_captions = $_POST['photo_captions'];
$photo_types = array(
'image/pjpeg' => 'jpg',
'image/jpeg' => 'jpg',
'image/gif' => 'gif',
'image/bmp' => 'bmp',
'image/x-png' => 'png'
);
while($counter <= count($photos_uploaded) ) {
if($photos_uploaded['size'][$counter] > 0) {
if(!array_key_exists($photos_uploaded['type'][$counter], $photo_types)) {
$result_final .= 'File ' . ($counter + 1) . ' is not a photo<br />';
} else {
// Great the file is an image, we will add this file
}
}
}
$query = "INSERT INTO gallery_photos (photo_filename, photo_caption, photo_category) VALUES ('0','" . $photo_captions[$counter] . "','" . $_POST['category'] . "')";
mysql_query($query);
$new_id = mysql_insert_id(); // New Id generated
// Get the filetype of the uploaded file
$filetype = $photos_uploaded['type'][$counter];
// Get the extension for the new name
$extension = $known_photo_types[$filetype];
// Generate a new name
$filename = "$new_id.$extension";
// let's update the filename now
$query = "UPDATE gallery_photos SET photo_filename = '$filename' WHERE photo_id = '$new_id'";
mysql_query($query);
copy($photos_uploaded['tmp_name'][$counter], $images_dir . '/' . $filename);
$size = GetImageSize($images_dir . "/" . $filename);
// Settings
$Config_tbwidth_wide = 100; // width of wide image
$Config_tbheight_wide = 75; // height of wide image
$Config_tbwidth_tall = 75; // width of tall image
$Config_tbheight_tall = 100; // height of tall image
// The code
if($size[0] > $size[1])
{
$thumbnail_width = $Config_tbwidth_wide;
$thumbnail_height = (int)($Config_tbwidth_wide * $size[1] / $size[0]);
if($thumbnail_height > $Config_tbheight_wide)
{
$thumbnail_height = $Config_tbheight_wide;
$thumbnail_width = (int)($Config_tbheight_wide * $size[0] / $size[1]);
}
}
else
{
$thumbnail_width = (int)($Config_tbheight_tall * $size[0] / $size[1]);
$thumbnail_height = $Config_tbheight_tall;
if($thumbnail_width > $Config_tbwidth_tall)
{
$thumbnail_width = $Config_tbwidth_tall;
$thumbnail_height = (int)($Config_tbwidth_tall * $size[1] / $size[0]);
}
}
$gd_function_suffix = array (
'image/pjpeg' => 'JPEG',
'image/jpeg' => 'JPEG',
'image/gif' => 'GIF',
'image/bmp' => 'WBMP',
'image/x-png' => 'PNG'
);
$function_suffix = $gd_function_suffix[$filetype];
$function_to_read = 'ImageCreateFrom' . $function_suffix;
$function_to_write = 'Image' . $function_suffix;
// Read the source file
$source_handle = $function_to_read($images_dir . '/' . $filename);
if ($source_handle) {
// Let's create a blank image for the thumbnail
$destination_handle =
ImageCreateTrueColor($thumbnail_width, $thumbnail_height);
// Now we resize it
ImageCopyResampled($destination_handle, $source_handle,
0, 0, 0, 0, $thumbnail_width, $thumbnail_height, $size[0], $size[1]);
}
// Let's save the thumbnail
$function_to_write($destination_handle, $images_dir . '/tb_' . $filename);
?>
</td>
</tr>
</table>
//<?// include_once("../footer.php" ); ?>
Plz guide me what is my wrong of this script(which i have getting from site point)
-::Ujjwal::-
Visit My Site
Help me mayank, please !
I have builded PHP Gallery based on your article.
Everything worked perfect on my computer.
After I uploaded my site to my server everything works good except uploading images . When I tryed to upload the image I had the message:
Warning: open_basedir restriction in effect. File is in wrong directory in /var/alternc/html/v/vadim/photodb/includes/upload.inc.php on line 65
The code on the line 65 is:
copy($photos_uploaded['tmp_name'][$counter], 'uploads/1.jpg');
Help me please who can !
-Vadim ( vadim007ru@yahoo.com )
viewgallery.php shows links to my categories but no photos. Can someone please tell me why?
http://benrud.net/photo_album/viewgallery.php
Thanks
Posting Permissions
Bookmarks