Ad:

PHP Discussion Thread
Marked Solved
Views: 738

May 16th, 2008

Cutting amount of work and loading time?

Expand Post »

Hi There

I have a very simple web gallery in php and mysql. I have noticed upon creating it, that I have several fields in my database contacting the same information (to a certain extent) and I wondered whether this would eventually put a strain on my server. Would it be possible to marry two or more of the columns together in the php coding to produce the same result?

It also seems daft spending time putting the same info into the database over and over again.

My database currently looks like this: http://www.equinefocus.co.uk/sampledatabase.jpg - however, this has not yet had the main image url included, which would look like the thumb field, but without the /thumbs/ directory included.

For example:

Each photo has a reference number, which consists of:
COLOR="red"]date[/COLOR] and an image number
i.e. 2008-04-13-001

Each thumbnail consists of:
directory path + date + /thumbs/ + image number + file extension
i.e. /photos/eventing/2007-09-01/thumbs/001 .jpg

For the thumbnail, would it be possible to pull the directory path, date, image number from the database, have the file extension and /thumb/ section in the php code, and have all elements join together to form the link to the image? It would mean that some of the content is being used more than once (date appears in the url to the image and the reference number displayed underneath).

My current code to produce the image is:

PHP Syntax (Toggle Plain Text)
	<?php  
	// Connects to your Database  
	mysql_connect("*****", "*****", "*****") or die(mysql_error());  
	mysql_select_db("*****") 
	or die ("Unable to connect to MySQL");
 
	$data = mysql_query("SELECT * FROM `others` WHERE date = '2008-04-27' AND ref ='2008-04-27-001'") 
	or die ("No data available, please contact the site admin describing where you found this error message.");  
	?>
 
	<table cellpadding="2" width="65%">
 
	<?php
	while($info = mysql_fetch_array($data)) {  
	?>
 
	<tr><td>	<img src="<?php echo $info['full'];?>" border="0"</a></td></tr>
	<tr><td>	<span class="refno">Photo Reference: <?php echo $info['ref']; ?></span></td></tr>
	<tr><td>	<?php echo $info['info']; ?></td></tr>
 
	</table>
	<?php  
	// Connects to your Database  
	mysql_connect("*****", "*****", "*****") or die(mysql_error());  
	mysql_select_db("*****") 
	or die ("Unable to connect to MySQL");
	 
	$data = mysql_query("SELECT * FROM `others` WHERE date = '2008-04-27' AND ref ='2008-04-27-001'") 
	or die ("No data available, please contact the site admin describing where you found this error message.");  
	?>
	
	<table cellpadding="2" width="65%">
	
	<?php
	while($info = mysql_fetch_array($data)) {  
	?>

	<tr><td>	<img src="<?php echo $info['full'];?>" border="0"</a></td></tr>
	<tr><td>	<span class="refno">Photo Reference: <?php echo $info['ref']; ?></span></td></tr>
	<tr><td>	<?php echo $info['info']; ?></td></tr>

	</table>

Bit complex, sorry! Any assistance would be appreciated.

Last edited by Borderline; May 16th, 2008 at 6:31 pm.

Similar Threads

memory management in wndows 2000 in Windows NT / 2000 / XP

Borderline

Reputation Points: 11

Solved Threads: 1

Light Poster

Offline

49 posts
since Apr 2008

Permalink

May 17th, 2008

Re: Cutting amount of work and loading time?

merge thumb and url into image - colunm just contains name e.g 1.jpg
your ref seems to be primary key and date. if true, get rid of ref.

PHP Syntax (Toggle Plain Text)
// images
$big_image='/photos/eventing/'.$info['date'].'/'.$info['image'];
$thumb='/photos/eventing/'.$info['date'].'/thumbs/'.$info['image'];
 
// ref
$ref = $info['date'].'-'.$info['primary_id'];
 
// mysql
$data = mysql_query("SELECT * FROM `others` WHERE date = '2008-04-27' AND primaryid ='1'")
// images
$big_image='/photos/eventing/'.$info['date'].'/'.$info['image'];
$thumb='/photos/eventing/'.$info['date'].'/thumbs/'.$info['image'];

// ref
$ref = $info['date'].'-'.$info['primary_id'];

// mysql
$data = mysql_query("SELECT * FROM `others` WHERE date = '2008-04-27' AND primaryid ='1'")

amigura

Reputation Points: 11

Solved Threads: 7

Junior Poster in Training

Offline

71 posts
since Jan 2008

Permalink

May 17th, 2008

Re: Cutting amount of work and loading time?

Thanks, glad to know it is possible, can save a lot of time.

PHP Syntax (Toggle Plain Text)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/strict.dtd"> 
<head><link rel="stylesheet" type="text/css" href="http://www.equinefocus.co.uk/style/20080512.css"/></head> 
 
<html><body>
 
		<?php	$page_title='Equine Focus';
			include($_SERVER['DOCUMENT_ROOT'].'/style/20080512photography.php');?>
 
<div id="main">
<center>
 
<div class="pagination">
	<ul>
	<li><a href="/photos/other/2008-04-27/page01.php">Return to album</a></li>
	</ul>
</div>
 
	<?php  
	// Connects to your Database  
	mysql_connect("*****", "*****", "*****") or die(mysql_error());  
	mysql_select_db("*****") 
	or die ("Unable to connect to MySQL");
 
		// images
		$big_image='/photos/eventing/'.$info['date'].'/'.$info['image'];
		$thumb='/photos/eventing/'.$info['date'].'/thumbs/'.$info['image'];
 
		// ref
		$ref = $info['date'].'-'.$info['ref'];
 
		// mysql
		$data = mysql_query("SELECT * FROM `eventing` WHERE date = '2008-04-13' AND ref ='080'") or die 
		("No data available, please contact the site admin describing where you found this error message.");  
		?>
 
	<table cellpadding="2" width="65%">
 
	<?php
	while($info = mysql_fetch_array($data)) {  
	?>
 
	<tr><td>	<img src="<?php echo $info['$big_image'];?>" border="0"</a></td></tr>
	<tr><td>	<span class="refno">Photo Reference: <?php echo $info['$ref']; ?></span></td></tr>
	<tr><td>	<?php echo $info['info']; ?></td></tr>
 
	</table>
 
 
<?php
}  
?>
</table> 
 
 
</div></center>
</html></body>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/strict.dtd"> 
<head><link rel="stylesheet" type="text/css" href="http://www.equinefocus.co.uk/style/20080512.css"/></head> 

<html><body>

		<?php	$page_title='Equine Focus';
			include($_SERVER['DOCUMENT_ROOT'].'/style/20080512photography.php');?>

<div id="main">
<center>

<div class="pagination">
	<ul>
	<li><a href="/photos/other/2008-04-27/page01.php">Return to album</a></li>
	</ul>
</div>

	<?php  
	// Connects to your Database  
	mysql_connect("*****", "*****", "*****") or die(mysql_error());  
	mysql_select_db("*****") 
	or die ("Unable to connect to MySQL");

		// images
		$big_image='/photos/eventing/'.$info['date'].'/'.$info['image'];
		$thumb='/photos/eventing/'.$info['date'].'/thumbs/'.$info['image'];
		
		// ref
		$ref = $info['date'].'-'.$info['ref'];
		
		// mysql
		$data = mysql_query("SELECT * FROM `eventing` WHERE date = '2008-04-13' AND ref ='080'") or die 
		("No data available, please contact the site admin describing where you found this error message.");  
		?>
	
	<table cellpadding="2" width="65%">
	
	<?php
	while($info = mysql_fetch_array($data)) {  
	?>

	<tr><td>	<img src="<?php echo $info['$big_image'];?>" border="0"</a></td></tr>
	<tr><td>	<span class="refno">Photo Reference: <?php echo $info['$ref']; ?></span></td></tr>
	<tr><td>	<?php echo $info['info']; ?></td></tr>

	</table>


<?php
}  
?>
</table> 


</div></center>
</html></body>

End result is: http://www.equinefocus.co.uk/test_page.php - what errors have I made calling the info from the database?

Borderline

Reputation Points: 11

Solved Threads: 1

Light Poster

Offline

49 posts
since Apr 2008

Permalink

May 17th, 2008

Re: Cutting amount of work and loading time?

the $info['$big_image'] is not from db it is a set varible so it should be echo $big_image and same with $info['ref'] - echo $ref;
the image and ref should go below db query to get info also

PHP Syntax (Toggle Plain Text)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/strict.dtd"> 
<head><link rel="stylesheet" type="text/css" href="http://www.equinefocus.co.uk/style/20080512.css"/></head> 
 
<html><body>
 
		<?php	$page_title='Equine Focus';
			include($_SERVER['DOCUMENT_ROOT'].'/style/20080512photography.php');?>
 
<div id="main">
<center>
 
<div class="pagination">
	<ul>
	<li><a href="/photos/other/2008-04-27/page01.php">Return to album</a></li>
	</ul>
</div>
 
	<?php  
	// Connects to your Database  
	mysql_connect("*****", "*****", "*****") or die(mysql_error());  
	mysql_select_db("*****") 
	or die ("Unable to connect to MySQL");
 
 
 
		// mysql
		$data = mysql_query("SELECT * FROM `eventing` WHERE date = '2008-04-13' AND ref ='080'") or die 
		("No data available, please contact the site admin describing where you found this error message.");  
		?>
 
	<table cellpadding="2" width="65%">
 
	<?php
	while($info = mysql_fetch_array($data)) {  
                        // images
		$big_image='/photos/eventing/'.$info['date'].'/'.$info['image'];
		$thumb='/photos/eventing/'.$info['date'].'/thumbs/'.$info['image'];
 
		// ref
		$ref = $info['date'].'-'.$info['ref'];
	?>
 
	<tr><td>	<img src="<?php echo $big_image; ?>" border="0"</a></td></tr>
	<tr><td>	<span class="refno">Photo Reference: <?php echo $ref; ?></span></td></tr>
	<tr><td>	<?php echo $info['info']; ?></td></tr>
 
	</table>
 
 
<?php
}  
?>
</table> 
 
 
</div></center>
</html></body>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/strict.dtd"> 
<head><link rel="stylesheet" type="text/css" href="http://www.equinefocus.co.uk/style/20080512.css"/></head> 

<html><body>

		<?php	$page_title='Equine Focus';
			include($_SERVER['DOCUMENT_ROOT'].'/style/20080512photography.php');?>

<div id="main">
<center>

<div class="pagination">
	<ul>
	<li><a href="/photos/other/2008-04-27/page01.php">Return to album</a></li>
	</ul>
</div>

	<?php  
	// Connects to your Database  
	mysql_connect("*****", "*****", "*****") or die(mysql_error());  
	mysql_select_db("*****") 
	or die ("Unable to connect to MySQL");

		
		
		// mysql
		$data = mysql_query("SELECT * FROM `eventing` WHERE date = '2008-04-13' AND ref ='080'") or die 
		("No data available, please contact the site admin describing where you found this error message.");  
		?>
	
	<table cellpadding="2" width="65%">
	
	<?php
	while($info = mysql_fetch_array($data)) {  
                        // images
		$big_image='/photos/eventing/'.$info['date'].'/'.$info['image'];
		$thumb='/photos/eventing/'.$info['date'].'/thumbs/'.$info['image'];
		
		// ref
		$ref = $info['date'].'-'.$info['ref'];
	?>

	<tr><td>	<img src="<?php echo $big_image; ?>" border="0"</a></td></tr>
	<tr><td>	<span class="refno">Photo Reference: <?php echo $ref; ?></span></td></tr>
	<tr><td>	<?php echo $info['info']; ?></td></tr>

	</table>


<?php
}  
?>
</table> 


</div></center>
</html></body>

amigura

Reputation Points: 11

Solved Threads: 7

Junior Poster in Training

Offline

71 posts
since Jan 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Updating required 2 Clicks of the same button

Next Thread in PHP Forum Timeline: creating dynamic columns and rows with data

DaniWeb Message

Cancel Changes

User Name
Password