Jump to content

rabesh

Members
  • Posts

    18
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

rabesh's Achievements

Member

Member (2/5)

0

Reputation

  1. I am tryting to get all data of three table by evalutating question_slug with posted slug tbl_questions
  2. I have used three tables tbl_question,tbl_answer,tbl_rating i need all data of three tables fileds of tbl_question are question_id question description user_id category_id question_slug date fields of tbl_answers are answer_id question_id user_id answer date fields of tbl_rating are rating_id answer_id point for the display of one questions and answers of related question by checking from question_slug field i used this query but not correct plz help $query= $this->db->query("(SELECT a.*,b.* FROM tbl_questions as a, tbl_answers as b where a.question_id=b.question_id AND a.question_slug='".$question_slug."') as c INNER JOIN (SELECT AVG(point) FROM tbl_rating)as c ON d.answer_id=c.answer_id ORDER BY d.answer_id DESC ")->result_array(); following error occurs A Database Error Occurred Error Number: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as c INNER JOIN (SELECT AVG(point) FROM tbl_rating)as c ON d.answer_id=c.answer_' at line 1 (SELECT a.*,b.* FROM tbl_questions as a, tbl_answers as b where a.question_id=b.question_id AND a.question_slug='Which-framework-is-mostly-Used-for-Php-Programming') as c INNER JOIN (SELECT AVG(point) FROM tbl_rating)as c ON d.answer_id=c.answer_id ORDER BY d.answer_id DESC
  3. Dear frens, I got a tension for unable to solve one problem I need to edit in the form which contains images, and other field. But my problem is it will edit in the database but main problem is not edit the file name in folder of the images Can u help me and following error also occurs Warning: copy() [function.copy]: The second argument to copy() function cannot be a directory in C:\wamp\www\kohkaine\admin\edit_gallery.php on line 118 Warning: copy() [function.copy]: The second argument to copy() function cannot be a directory in C:\wamp\www\kohkaine\admin\edit_gallery.php on line 119 Warning: rename(gallery/36ADay.jpg,gallery/) [function.rename]: No error in C:\wamp\www\kohkaine\admin\edit_gallery.php on line 121 Warning: rename(gallery/36ADay.jpg,gallery/thumb/) [function.rename]: No error in C:\wamp\www\kohkaine\admin\edit_gallery.php on line 122 I post complete code here <?php include('include/connection.php'); define ("MAX_SIZE","500"); // define the width and height for the thumbnail // note that theese dimmensions are considered the maximum dimmension and are not fixed, // because we have to keep the image ratio intact or it will be deformed define ("WIDTH","250"); //set here the width you want your thumbnail to be define ("HEIGHT","250"); //set here the height you want your thumbnail to be. define ("WIDTH2","750"); //set here the width you want your thumbnail to be define ("HEIGHT2","600"); //set here the height you want your thumbnail to be. // this is the function that will create the thumbnail image from the uploaded image // the resize will be done considering the width and height defined, but without deforming the image function make_thumb($img_name,$filename,$new_w,$new_h){ //get image extension. $ext=getExtension($img_name); //creates the new image using the appropriate function from gd library if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext)) $src_img=imagecreatefromjpeg($img_name); if(!strcmp("png",$ext)) $src_img=imagecreatefrompng($img_name); if(!strcmp("gif",$ext)) $src_img=imagecreatefromgif($img_name); //gets the dimmensions of the image $old_x=imageSX($src_img); $old_y=imageSY($src_img); // next we will calculate the new dimmensions for the thumbnail image // the next steps will be taken: // 1. calculate the ratio by dividing the old dimmensions with the new ones // 2. if the ratio for the width is higher, the width will remain the one define in WIDTH variable // and the height will be calculated so the image ratio will not change // 3. otherwise we will use the height ratio for the image // as a result, only one of the dimmensions will be from the fixed ones $ratio1=$old_x/$new_w; $ratio2=$old_y/$new_h; if($ratio1>$ratio2) { $thumb_w=$new_w; $thumb_h=$old_y/$ratio1; }else{ $thumb_h=$new_h; $thumb_w=$old_x/$ratio2; } // we create a new image with the new dimmensions $dst_img=ImageCreateTrueColor($thumb_w,$thumb_h); // resize the big image to the new created one imagecopyresampled($dst_img,$src_img,0,0,0,0,$thumb_w,$thumb_h,$old_x,$old_y); // output the created image to the file. Now we will have the thumbnail into the file named by $filename if(!strcmp("png",$ext)) imagepng($dst_img,$filename); else imagejpeg($dst_img,$filename); if (!strcmp("gif",$ext)) imagegif($dst_img,$filename); //destroys source and destination images. imagedestroy($dst_img); imagedestroy($src_img); } // This function reads the extension of the file. // It is used to determine if the file is an image by checking the extension. function getExtension($str) { $i = strrpos($str,"."); if (!$i) { return ""; } $l = strlen($str) - $i; $ext = substr($str,$i+1,$l); return $ext; } // This variable is used as a flag. The value is initialized with 0 (meaning no error found) //and it will be changed to 1 if an error occures. If the error occures the file will not be uploaded. $errors=0; if (isset ($_POST['submitted'])) {//$filename=$_FILES['image']['name']; $id=$_GET['id']; $des=$_POST['des']; $title=$_POST['title']; $status=$_POST['status']; $des=$_POST['des']; $status=$_POST['status']; $image=$_FILES['image']['name']; $image_dir1 = "gallery/".$image; $image_dir2 = "gallery/thumb/".$image; $sql1=mysql_query('Select name, thumbnail from tbl_gallery where id="'.$id.'"'); $res=mysql_fetch_array($sql1); $consname= $res['name']; $consname2= $res['thumbnail']; if ($image) { // get the original name of the file from the clients machine $filename = stripslashes($_FILES['image']['name']); // get the extension of the file in a lower case format $extension = getExtension($filename); $extension = strtolower($extension); // if it is not a known extension, we will suppose it is an error, print an error message //and will not upload the file, otherwise we continue if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif")) { echo 'Unknown extension! Please use .gif, .jpg or .png files only.'; $errors=1; }else{ // get the size of the image in bytes // $_FILES[\'image\'][\'tmp_name\'] is the temporary filename of the file in which //the uploaded file was stored on the server $size=getimagesize($_FILES['image']['tmp_name']); $sizekb=filesize($_FILES['image']['tmp_name']); //compare the size with the maxim size we defined and print error if bigger if ($sizekb > MAX_SIZE*1024) { echo 'You have exceeded the 1MB size limit!'; $errors=1; } //$rand= rand(0, 1000); //we will give an unique name, for example a random number //$image_name=$rand.'.'.$extension; //the new name will be containing the full path where will be stored (images folder) //$consname="image/".$image_name; //change the image/ section to where you would like the original image to be stored //$consname2="image/thumb/".$image_name; //change the image/thumb to where you would like to store the new created thumb nail of the image //$consname="gallery/".$image_name; //$consname2="gallery/thumb/".$image_name; $copied = copy($_FILES['image']['tmp_name'], $consname); $copied = copy($_FILES['image']['tmp_name'], $consname2); mysql_query('update tbl_gallery set name="'.$consname.'" ,thumbnail="'.$consname2.'" ,description="'.$des.'",title="'.$title.'" ,status="'.$status.'" where id="'.$id.'"' ); rename($image_dir1,$consname); rename($image_dir1,$consname2); if (!$copied) { echo 'File not Uploaded!'; $errors=1; }else{ // the new thumbnail image will be placed in images/thumbs/ folder //$thumb_name=$consname2 ; // call the function that will create the thumbnail. The function will get as parameters //the image name, the thumbnail name and the width and height desired for the thumbnail $thumb=make_thumb($consname,$consname2,WIDTH,HEIGHT); $thumb=make_thumb($consname,$consname,WIDTH2,HEIGHT2); } } } //If no errors registred, print the success message and how the thumbnail image created if(isset($_POST['submitted']) && !$errors) { echo "Image Edited Sucessfully!"; //echo '< img src="'.$thumb_name.'">'; //echo $lastid; } } $id=$_GET['id']; $sql=mysql_query('select * from tbl_gallery where id="'.$id.'"'); $output=mysql_fetch_array($sql); echo $output['name']; print_r( $output['thumbnail']); ?> <link rel="stylesheet" type="text/css" href="css/style.css"> <div class="form_box"> <form method="post" enctype="multipart/form-data" > <div class="upload"> <label>Caption:</label> <input type="text" name="title" value="<?php echo $output['title'];?>" /> </div> <div class="upload"> <label>Description:</label> <textarea name="des"><?php echo $output['description'];?></textarea> </div> <div class="upload"> <label>Browse Image File:</label> <input type="file" name="image" value="<?php echo $output['name'];?>" /> </div> <div class="upload"> <label>Status:</label> <input type="radio" name="status" value="1" <?php if($output['status']==1) echo 'checked'; ?>>Show<input type="radio" name="status" value="0"<?php if($output['status']==0) echo 'checked'; ?>>Hide </div> <div class="upload"><input type="submit" name="submitted" value="EDIT" /> </div> <div class="upload"><input type="hidden" name="submitted" value="Edit" /></div> </form></div> <div><a href="gallery_management.php">Go Back</a></div>
  4. I write code for image resize but the following errors occurs... i am new for image resizing in php Warning: imagecreatefromjpeg(gallery/show2.gifshow2.gif) [function.imagecreatefromjpeg]: failed to open stream: No such file or directory in C:\wamp\www\gallery for kokine\test4gallery.php on line 40 Warning: imagesx() expects parameter 1 to be resource, boolean given in C:\wamp\www\gallery for kokine\test4gallery.php on line 41 Warning: imagesy() expects parameter 1 to be resource, boolean given in C:\wamp\www\gallery for kokine\test4gallery.php on line 42 Warning: Division by zero in C:\wamp\www\gallery for kokine\test4gallery.php on line 48 Warning: imagecreate() [function.imagecreate]: Invalid image dimensions in C:\wamp\www\gallery for kokine\test4gallery.php on line 52 Warning: imagetruecolortopalette() expects parameter 1 to be resource, boolean given in C:\wamp\www\gallery for kokine\test4gallery.php on line 53 Warning: imagecolorstotal() expects parameter 1 to be resource, boolean given in C:\wamp\www\gallery for kokine\test4gallery.php on line 54 Warning: imagecopyresized() expects parameter 1 to be resource, boolean given in C:\wamp\www\gallery for kokine\test4gallery.php on line 59 Warning: imagejpeg() expects parameter 1 to be resource, boolean given in C:\wamp\www\gallery for kokine\test4gallery.php on line 60 Warning: imagedestroy() expects parameter 1 to be resource, boolean given in C:\wamp\www\gallery for kokine\test4gallery.php on line 61 Warning: imagedestroy() expects parameter 1 to be resource, boolean given in C:\wamp\www\gallery for kokine\test4gallery.php on line 62 my code is <?php include('include/connection.php'); if (isset ($_POST['submitted'])) { $filename=$_FILES['image']['name']; $des=$_POST['des']; $cap=$_POST['caption']; $status=$_POST['status']; $category=0; $image_dir = "gallery/".$filename; if(!is_dir("gallery")): mkdir("gallery"); endif; $tdir = "gallery/thumbs/"; // Path To Thumbnails Directory $twidth = "125"; // Maximum Width For Thumbnail Images $theight = "100"; // Maximum Height For Thumbnail Images if(move_uploaded_file($_FILES['image']['tmp_name'],$image_dir)) { list($w,$h,$t) = getimagesize($image_dir); switch($t) { case 1: $ext = ".png"; break; case 2: $ext = ".jpg"; break; case 3: $ext = ".gif"; break; default: $ext = ".jpg"; } $simg = imagecreatefromjpeg("$image_dir" . $filename); // Make A New Temporary Image To Create The Thumbanil From $currwidth = imagesx($simg); // Current Image Width $currheight = imagesy($simg); // Current Image Height if ($currheight > $currwidth) { // If Height Is Greater Than Width $zoom = $twidth / $currheight; // Length Ratio For Width $newheight = $theight; // Height Is Equal To Max Height $newwidth = $currwidth * $zoom; // Creates The New Width } else { // Otherwise, Assume Width Is Greater Than Height (Will Produce Same Result If Width Is Equal To Height) $zoom = $twidth / $currwidth; // Length Ratio For Height $newwidth = $twidth; // Width Is Equal To Max Width $newheight = $currheight * $zoom; // Creates The New Height } $dimg = imagecreate($newwidth, $newheight); // Make New Image For Thumbnail imagetruecolortopalette($simg, false, 256); // Create New Color Pallete $palsize = ImageColorsTotal($simg); for ($i = 0; $i < $palsize; $i++) { // Counting Colors In The Image $colors = ImageColorsForIndex($simg, $i); // Number Of Colors Used ImageColorAllocate($dimg, $colors['red'], $colors['green'], $colors['blue']); // Tell The Server What Colors This Image Will Use } imagecopyresized($dimg, $simg, 0, 0, 0, 0, $newwidth, $newheight, $currwidth, $currheight); // Copy Resized Image To The New Image (So We Can Save It) imagejpeg($dimg, "$tdir" . $filename); // Saving The Image imagedestroy($simg); // Destroying The Temporary Image imagedestroy($dimg); // Destroying The Other Temporary Image mysql_query('INSERT INTO tbl_gallery(`title` ,`description` ,`name`,`category_name`,`status`)VALUES ("'.$cap.'", "'.$des.'", "'.$filename.'","'.$category.'", "'.$status.'")'); $id = mysql_insert_id(); $new_image = "gallery/".$id.$ext; //echo "update tbl_gallery set image_name='".$new_image."' where id = ".$id; //die("here"); $res = mysql_query("update tbl_gallery set name='".$new_image."' where id = ".$id) or die(mysql_error()); rename($image_dir,$new_image); echo 'upload successful'; //$img=getimagesize('upload/'.$filename); // echo $width.$height.$type.$attr; // print_r($img); } } ?> <link rel="stylesheet" type="text/css" href="css/style.css"> <body> <!--<table > <form method="post" enctype="multipart/form-data" > <tr> <td>Caption</td> <td><input type="text" name="caption" /></td> </tr> <tr> <td>Description</td> <td><textarea name="des" rows="15" cols="15"></textarea></td> </tr> <tr> <td>Image Name</td><td><input type="file" name="image" /></td> </tr> <tr> <td>Status:</td> <td> <input type="radio" name="status" value="1" checked>Show<input type="radio" name="status" value="0">Hide</td> </tr> <tr><td><input type="submit" name="submitted" value="upload" /></td></tr> </form> </table>--> <div class="form_box"> <form method="post" enctype="multipart/form-data" > <div class="upload"> <label>Caption:</label> <input type="text" name="caption" /> </div> <div class="upload"> <label>Description:</label> <textarea name="des" rows="15" cols="15"></textarea> </div> <div class="upload"> <label>Browse Image File:</label> <input type="file" name="image" /> </div> <!--<div class="upload"> <label>Please Select the Catagory:</label> <select> <option value="1">Boutique Saree</option> <option value="2">Simple Saree</option> <option value="3">Kurtha Salwar</option> <option value="4">others</option> </select> </div>--> <div class="upload"> <label>Status:</label> <input type="radio" name="status" value="1" checked>Show<input type="radio" name="status" value="0">Hide </div> <div class="upload"><input type="submit" name="submitted" value="upload" /> </div></form></div> <div><a href="index.php">Go Back</a></div> any body can solve my problem MOD EDIT: code tags added.
  5. But i dont know to implode the array can u help me sending the code
  6. Helloo guys, I need help on check box. i check box containing different value using this code <input type="checkbox" value="" name="find[]" /> after that i used php code to receive the post data using the following code $find = $_POST['find'] ; $n = count($find); for($i=0; $i < $n; $i++) { $display=($find[$i] . " "); } then i try to send that posted data to mail using the code mail function for that i create a variable and send like this mail($to,$subject,$display, $headers); but blank array was send How to solve this plz help me thanks
  7. I used Jquery plugins for the slider, drop down menu and date. But there is conflict on the function how can i solve this problem i used following code to remove the conflict but not removed <script> jQuery.noConflict(); (function($) { $(function() { // more code using $ as alias to jQuery }); })(jQuery); </script> <script> $(function() { $( "#datepicker" ).datepicker(); }); </script> Plz tell me how to remove the conflict Jquery date plugins doesnot work all other plugins work If i remove other plugins then date plugins works Plz solve that problem Thanks
  8. I create list box which value contains from the table of database but now i want to display the data related to the value of list box. plz any body can help me to solve the problem My table contains id, category_name, title, discription and list box contain the value from the filed category_name of the table now i want to display title and discription according to the category_name. PLZ send me code i am totally confused..
  9. Thank a lot DarkKnight2011 It works....
  10. if($_GET['task']=='del') { $id=$_GET['id']; $name=$_GET['new_image']; mysql_query('delete from tbl_gallery where id="'.$id.'"' ); unlink ($name); }
  11. I dont get mistake plz correct in my code
  12. code is <?php $limit=12; if(isset( $_GET['page'])) $page=$_GET['page']; if($page<=0) $page = 1; else {$start=0;} $sql=mysql_query("select * from tbl_gallery where status=1 And category_name='0'"); $count=mysql_num_rows($sql); $totalcount=ceil($count/$limit);$start=($page-1)*$limit; $s=mysql_query("select * from tbl_gallery where status=1 And category_name='0' limit $start, $limit"); while($result=mysql_fetch_array($s)){ $start++; ?> PLZ find the mistake
  13. This code is used to display data in the list box. But I need to display all data from database table related to the data of list box
  14. Plz help me the concept or code to retrive data from the database and display data according to the data from the dynamic list box option.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.