bluewaves Posted July 22, 2010 Share Posted July 22, 2010 I need to add a function to a php script that calls on a mysql database and displays product images from a datafeed on a web page. I have a variety of image sizes. For example, one image is 400 x 212. When I display it I want it to be a maximum width of 250, then I want the height to be whatever it needs to be to keep it in a similar proportion to the original. Can someone tell me how I would write that into my php script? Thanks. Quote Link to comment Share on other sites More sharing options...
cmor Posted July 22, 2010 Share Posted July 22, 2010 http://articles.sitepoint.com/article/php-gallery-system-minutes/5 Mainly $destination_handle = imagecreatetruecolor( $thumbnail_width, $thumbnail_height ); ImageCopyResampled( $destination_handle, $source_handle, 0, 0, 0, 0, $thumbnail_width, $thumbnail_height, $size[0], $size[1] ); Quote Link to comment Share on other sites More sharing options...
bluewaves Posted July 23, 2010 Author Share Posted July 23, 2010 How can I get this to work with this code: <?php include('bbbb.php'); $database = "cxxxxx"; $cxn = mysql_connect($host,$user,$password) or die ("couldn't connect to server"); mysql_select_db($database); $conn = mysql_connect('localhost','x','x') or trigger_error("SQL", E_USER_ERROR); $db = mysql_select_db('coolchec_checks',$conn) or trigger_error("SQL", E_USER_ERROR); // find out how many rows are in the table $sql = "SELECT COUNT(*) FROM table WHERE Type='movie' ORDER BY ProductID DESC"; $result = mysql_query($sql, $cxn) or trigger_error("SQL", E_USER_ERROR); $r = mysql_fetch_row($result); $numrows = $r[0]; // number of rows to show per page $rowsperpage = 30; // find out total pages $totalpages = ceil($numrows / $rowsperpage); // get the current page or set a default if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) { // cast var as int $currentpage = (int) $_GET['currentpage']; } else { // default page num $currentpage = 1; } // end if // if current page is greater than total pages... if ($currentpage > $totalpages) { // set current page to last page $currentpage = $totalpages; } // end if // if current page is less than first page... if ($currentpage < 1) { // set current page to first page $currentpage = 1; } // end if // the offset of the list, based on current page $offset = ($currentpage - 1) * $rowsperpage; // get the info from the db $sql = "SELECT BigImage, Thumbnail, Link, Name, Description, Price FROM table WHERE Type='Movie' ORDER BY ProductID DESC LIMIT $offset, $rowsperpage"; $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR); define ("NUMCOLS", 1); $res = mysql_query("SELECT BigImage, Thumbnail, Link, Name, Description, Price FROM gobble WHERE Type='Movie' ORDER BY ProductID DESC"); $count = 0; echo "<table cellpadding='10'>"; while ($list = mysql_fetch_assoc($result)) { if ($count % NUMCOLS == 0) echo "<tr>\n"; # new row echo "<td><a href='". $list['Link'] . "' rel='nofollow' title='" . $list['Name'] . "' target='_blank'> <span class='floatleft'><img src=" . $list['BigImage'] . " alt='" . $list['Name'] . "' border='0' /><br /> <font face='arial' size='1'>" . $list['Name'] . "</a><br />" . $list['Description'] . "</font></span></td>\n"; $count++; if ($count % NUMCOLS == 0) echo "</tr>\n"; # end row } # end row if not already ended if ($count % NUMCOLS != 0) { while ($count++ % NUMCOLS) echo "<td> </td>"; echo "</tr>\n"; } echo "</table>"; /****** build the pagination links ******/ // range of num links to show $range = 4; // if not on page 1, don't show back links if ($currentpage > 1) { // show << link to go back to page 1 echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> "; // get previous page num $prevpage = $currentpage - 1; // show < link to go back to 1 page echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> "; } // end if // loop to show links to range of pages around current page for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) { // if it's a valid page number... if (($x > 0) && ($x <= $totalpages)) { // if we're on current page... if ($x == $currentpage) { // 'highlight' it but don't make a link echo " [<b>$x</b>] "; // if not current page... } else { // make it a link echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> "; } // end else } // end if } // end for // if not on last page, show forward and last page links if ($currentpage != $totalpages) { // get next page $nextpage = $currentpage + 1; // echo forward link for next page echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> "; // echo forward link for lastpage echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> "; } // end if /****** end build pagination links ******/ ?> Quote Link to comment 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.