xavier.rayne Posted September 13, 2007 Share Posted September 13, 2007 Hi, there Currently i'm doing on an assignment on how to create a photo album. I want to create a photo album that list the thumbnails below the big photo into 8 columns and 4 rows. Below is my code for album.php: <?php session_start(); include("../../config_pic.php"); ?> <script language="JavaScript"> var fadeimages=new Array() </script> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>Untitled Document</title> </head> <body> <?php require("rollover.php"); ?> <TD class=content vAlign=top > <P class=Header> <?php echo "Welcome, " .$_SESSION['session_user']; ?></P> <p align="right"><a href="gallery.php">Back To Gallery</a></p> <table align="center" cellpadding="0" cellspacing="0"> <tr><?php $SQL = "select name from images"; $result = mysql_query($SQL); $row = mysql_fetch_array($result); $ProImg = $row; $imgLoc1[]="mall/smallthumbnail.php?i=http://localhost/photo_album/mall/images/$ProImg[$i]&w=400&h=400"; ?> <td colspan="8" height="400" width="400"><img id='psOne' height=400 src="<?php echo $imgLoc1[0]; ?>" width=400 border=0></td> </tr> <?php $query2 = "SELECT * FROM images"; $result2 = mysql_query($query2); $quantity = mysql_num_rows($result2); $row2 = mysql_fetch_array($result2); $ProImg2 = $row2; for($i=0;$i<$quantity;$i++){ echo "<tr>"; if($i%8 != 0){ //if($i%8 != 0) echo "ProImg2 is " . $ProImg2[$i]; $imgLoc2[$i]="mall/smallthumbnail.php?i=http://localhost/photo_album/mall/images/$ProImg2[$i]&w=50&h=50";?> <td><A onmouseover=replaceImage($i);><IMG style="CURSOR: hand" height=50 alt="pink" src="<?php echo $imgLoc2[$i]; ?>" width=50 border="0"></A></td> <? } //end if($i%8 != 0) else { echo "</tr>"; } }//end for loop ?> </table> </tr> </body> </html> When i run it at localhost, I always get the same error message: Notice: Undefined offset: 2 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 2 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 3 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 3 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 4 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 4 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 5 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 5 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 6 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 6 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 7 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 7 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 9 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 9 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 10 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 10 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 11 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 11 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 12 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 12 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 13 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 13 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 14 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 14 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 15 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 15 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 17 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 17 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 18 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 18 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 19 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 19 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 20 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 20 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 21 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 21 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 22 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 22 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 23 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 23 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 25 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 25 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 26 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 26 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 27 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 27 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 28 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 28 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 29 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 29 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Notice: Undefined offset: 30 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 48 ProImg2 is Notice: Undefined offset: 30 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\admin\album.php on line 50 Please....anyone here please help me to solve this problem :'( Thanks.. EDITED BY WILDTEEN88: Please use code tag ( ) when including code within posts. Quote Link to comment https://forums.phpfreaks.com/topic/69131-undefined-offset/ Share on other sites More sharing options...
deadimp Posted September 13, 2007 Share Posted September 13, 2007 Undefined offset means that you're trying to access a part of an array that doesn't exist (it's in the for-loop you're doing this). Use print_r() on $row2 to see if you're getting anything from the query. You should be, since the number of rows shows that you're getting something. Also, use code tags! Quote Link to comment https://forums.phpfreaks.com/topic/69131-undefined-offset/#findComment-347512 Share on other sites More sharing options...
xavier.rayne Posted September 13, 2007 Author Share Posted September 13, 2007 Ooops..sorry coz i'm new here. Hi,deadimp. I've run print_r($row2) and i'm just getting one array only: Array ( [0] => pic.jpg [name] => pic.jpg ) What happens to the others? It suppose to get the array until the quantity that i set,izzit? I'm not so familiar in doing array :-\ Quote Link to comment https://forums.phpfreaks.com/topic/69131-undefined-offset/#findComment-347530 Share on other sites More sharing options...
btherl Posted September 13, 2007 Share Posted September 13, 2007 A mysql result consists of rows and columns. For example id num 1 10 2 50 mysql_fetch_array() fetches one row only! It's an "array" because each array element is one column. So you must call mysql_fetch_array() many times, usually like this: while ($row2 = mysql_fetch_arrow($result2)) { print "id: {$row2['id']}, num: {$row['num']}\n"; } Quote Link to comment https://forums.phpfreaks.com/topic/69131-undefined-offset/#findComment-347568 Share on other sites More sharing options...
xavier.rayne Posted September 14, 2007 Author Share Posted September 14, 2007 I'm still facing with the offset problem: The error message: Notice: Undefined offset: 1 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\album.php on line 48 Notice: Undefined offset: 2 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\album.php on line 48 Notice: Undefined offset: 3 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\album.php on line 48 Notice: Undefined offset: 4 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\album.php on line 48 Notice: Undefined offset: 5 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\album.php on line 48 Notice: Undefined offset: 6 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\album.php on line 48 Notice: Undefined offset: 7 in C:\Program Files\Apache Group\Apache2\htdocs\photo_album\album.php on line 48 looping for 4 times. Below is my edited code: <?php //select images from table images(display all thumbnails for a category) $query2 = "SELECT name FROM images"; $result2 = mysql_query($query2); if($result && mysql_num_rows($result) > 0) { $i = 0; $max_columns = 8; while($row2 = mysql_fetch_array($result2)){ //print_r($row2); $ProImg2 = $row2; //$ProImg2[] = $row2; // open row if counter is zero if($i == 0) echo "<tr>"; $imgLoc2[]="mall/smallthumbnail.php?i=http://localhost/photo_album/mall/images/$ProImg2[$i]&w=50&h=50"; ?> <td><A onmouseover=replaceImage($i);><IMG style="CURSOR: hand" height=50 alt="pink" src="<?php echo $imgLoc2[$i]; ?>" width=50 border="0" onClick="window.location.href='deleteimage.php?image=<?php echo $imgLoc2[$i]; ?>'"></A></td> <? // increment counter - if counter = max columns, reset counter and close row if(++$i == $max_columns) { echo "</tr>"; $i=0; } // end if(++$i == $max_columns) } // end while($row2 = mysql_fetch_array($result2)){ } // end if results ?> Anyone, please help me.. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/69131-undefined-offset/#findComment-348179 Share on other sites More sharing options...
btherl Posted September 14, 2007 Share Posted September 14, 2007 Try $ProImg2[] = $row2['name']; in your loop Quote Link to comment https://forums.phpfreaks.com/topic/69131-undefined-offset/#findComment-348184 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.