clint Posted December 7, 2009 Share Posted December 7, 2009 Hello Could somebody please advise me on the following. I have a form to upload an image to the server and image name and other form fields to mysql database. It all works fine but I am at a loss as where to add or how to add code for thumbnail creation for the uploaded image. Here is the form: <html> <head> <title>Insert business for sale</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <script type="text/javascript" src="../js/country.js"></script> </head> <body> <table width="100%" border="0" cellspacing="0" cellpadding="5" class="main"> <tr> <td colspan="3"> </td> </tr> <tr> <td width="160" valign="top"><p> </p> <p> </p> <p> </p> <p> </p> <p> </p></td> <td width="732" valign="top"><p> </p> <h3 class="titlehdr">Add details for business for sale here:</h3> Or go back to Admin Panel <a href="admin_main.php">here</a>.<br> <form method="post" action="addcourse.php" enctype="multipart/form-data"> <table width="95%" border="0" cellpadding="3" cellspacing="3" class="forms"> <tr> <td colspan="2" height="49"><font color="#FF0000">Course Name</font><font color="#CC0000">*</font><br> <input name="course" type="text" id="course" size="40"> </td> <td width="4"></td> </tr> <tr> <td colspan="2" height="21"> </td> <td></td> </tr> <tr> <td colspan="2" height="114"><font color="#FF0000">Contact Address (with ZIP)</font><font color="#CC0000">*</font><br> <textarea name="address" cols="40" rows="4" id="address"></textarea> </td> <td></td> </tr> <tr> <td height="21" valign="top" colspan="2"><font color="#FF0000"><b>Company details:</b></font></td> <td></td> </tr> <tr> <td height="59" valign="top" colspan="2"> <textarea name="profile" cols="80" rows="8" id="profile" onkeyup="if (this.value.length > 300) { alert('Character limit has been reached!'); this.value = this.value.substr(0,5); }"></textarea> </td> <td></td> </tr> <tr> <td height="21" valign="top" colspan="2"> </td> <td></td> </tr> <tr> <td height="32" width="125" valign="top"><font color="#FF0000">Contact Person</font></td> <td width="482" valign="top"> <input type="text" name="contact" id="contact"> </td> <td></td> </tr> <tr> <td height="21" colspan="2" valign="top"><font color="#FF0000" size="1">Please select your country/state</font> <font color="#FF0000">*</font></td> <td></td> </tr> <tr> <td height="27" valign="top"> <select id='countrySelect' name='country' onchange='populateState()'> </select> </td> <td valign="top"> <select id='stateSelect' name='state'> </select> <script type="text/javascript">initCountry('PLS'); </script> <td></td> </tr> <tr> <td height="40" valign="top"><font color="#FF0000">City</font></td> <td valign="top"> <input type="text" name="city" id="city"> </td> <td></td> </tr> <tr> <td height="34" valign="top"><font color="#FF0000">Phone</font><font color="#CC0000">*</font> </td> <td valign="top"> <input name="tel" type="text" id="tel"> </td> <td></td> </tr> <tr> <td height="34" valign="top"><font color="#FF0000">Holes</font> </td> <td valign="top"> <input name="holes" type="text" id="holes"> </td> <td></td> </tr> <tr> <td height="34" valign="top"><font color="#FF0000">Par</font> </td> <td valign="top"> <input name="par" type="text" id="par"> </td> <td></td> </tr> <tr> <td height="34" valign="top"><font color="#FF0000">Designer</font> </td> <td valign="top"> <input name="designer" type="text" id="designer"> </td> <td></td> </tr> <tr> <td height="34" valign="top"><font color="#FF0000">Course Distance</font> </td> <td valign="top"> <input name="distance" type="text" id="distance"> </td> <td></td> </tr> <tr> <td height="34" valign="top"><font color="#FF0000">Fairways Grass</font> </td> <td valign="top"> <input name="fairways" type="text" id="fairways"> </td> <td></td> </tr> <tr> <td height="34" valign="top"><font color="#FF0000">Greens Grass</font> </td> <td valign="top"> <input name="greens" type="text" id="greens"> </td> <td></td> </tr> <tr> <td height="34" valign="top"><font color="#FF0000">Website </font></td> <td valign="top"> <input name="web" type="text" id="web" class="optional defaultInvalid url"> <span class="example">http://www.example.com</span></td> <td></td> </tr> <tr> <td height="25" colspan="2" valign="top"> </td> <td></td> </tr> <tr> <td height="34" valign="top"><font color="#FF0000">Email Address:</font><span class="required"><font color="#CC0000">*</font></span> </td> <td valign="top"> <input name="usr_email" type="text" id="usr_email"> </td> <td></td> </tr> <tr> <td valign="top" height="41"><font color="#FF0000">Upload Avatar</font></td> <td valign="top"> <input type="hidden" name="size" value="350000"> <input type="file" name="photo"> </td> <td></td> </tr> <tr> <td height="34"></td> <td></td> <td></td> </tr> <tr> <td height="72" valign="top"> <input TYPE="submit" name="upload" title="Add data to the Database" value="Add Course"/> </td> <td></td> <td></td> </tr> </table> <p align="center"> </p> </form> </td> <td width="196" valign="top"> </td> </tr> <tr> <td colspan="3"> </td> </tr> </table> </body> </html> And here is the php to handle the upload: <?php include "../db connection..."; //This is the directory where images will be saved $target = "market/Thumbs/"; $target = $target . basename( $_FILES['photo']['name']); //This gets all the other information from the form $course=$_POST['course']; $address=$_POST['address']; $profile=$_POST['profile']; $contact=$_POST['contact']; $country=$_POST['country']; $state=$_POST['state']; $city=$_POST['city']; $tel=$_POST['tel']; $holes=$_POST['holes']; $par=$_POST['par']; $designer=$_POST['designer']; $distance=$_POST['distance']; $fairways=$_POST['fairways']; $greens=$_POST['greens']; $web=$_POST['web']; $user_email=$_POST['user_email']; $pic=($_FILES['photo']['name']); //Writes the information to the database mysql_query("INSERT INTO golflist (course,address,profile,contact,country,state,city,tel,holes,par,designer,distance,fairways,greens,web,user_email,photo,date) VALUES ('$course', '$address', '$profile','$contact','$country','$state','$city','$tel','$holes','$par','$designer','$distance','$fairways','$greens','$web','$user_email','$pic',now())") ; //Writes the photo to the server if(move_uploaded_file($_FILES['photo']['tmp_name'], "$target")) { //Tells you if its all ok echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"; } else { //Gives and error if its not echo "Sorry, there was a problem uploading your file."; } ?> I am not looking for someone to do the work for me, just advise me or point me in the direction of code I could integrate with what I already have? Thank you for your time. I do appreciate it! Quote Link to comment https://forums.phpfreaks.com/topic/184253-advice-re-thumbnails/ Share on other sites More sharing options...
Psycho Posted December 7, 2009 Share Posted December 7, 2009 A google search for "PHP create thumbnail" came up with several tutorials ont he subject. Really too much to try and emaplain in a forum post. Try reading a tutorial and implementing it into your script. Then post back if you run into any problems. Quote Link to comment https://forums.phpfreaks.com/topic/184253-advice-re-thumbnails/#findComment-972807 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.