drewwales
-
Posts
5 -
Joined
-
Last visited
drewwales's Achievements
Newbie (1/5)
0
Reputation
-
this works and displays images if found within the specified folder. but if the image is not found it does bugger all instead of displaying and echo saying no file. Heres the code; if ($handle = opendir("../images/services/")) { while (false !== ($file = readdir($handle))) { $strFielName = ""; $strFielName.= basename($file, ".jpg"); if ($strFielName == $strPageTitle) { if (($file != "." && $file != ".." && $file != "/." && $file != "/..") && (preg_match('/\.(jpg)([^\.]*$)/', $file, $extension))) { $myfile = "../images/services/".$file; if (file_exists($myfile)) { echo "$myfile"; echo "<center><div style='width:220px;'><a href=\"../images/services/".$file."\"><img src=\"../images/services/".$file."\" width=\"200\" height=\"178\"></a><br>"; echo "<form method=\"post\" name=\"deleteSomething\" action="?><?php echo $_SERVER['PHP_SELF'].'?delete=true';?><?php echo" > <input type=\"hidden\" name=\"fileToDelete\" value=".$file." > <input type=\"submit\" value=\"Delete\"></form></div></center>"; } else { echo "no file"; } } } } closedir($handle); }
-
I haven't used php in years, I'm looking but not seeing anything useful.
-
Still cant figure it out, I think I'm being dumb but should this be correct? //Connect to database from here $link = mysql_connect('localhost', 'root', ''); if (!$link) { die('Could not connect: ' . mysql_error()); } mysql_select_db("db_here"); mysql_query("UPDATE tbl_products SET p_feat='".$feat."',P_title=".$_GET['p_title'].", p_desc='".$_GET['p_desc']."' WHERE p_id='".$_GET['P_ID']."'",$link);
-
that being the case as im extremely tired even mysql_query("UPDATE tbl_products SET p_feat='y',P_title=iPad Case, p_desc='Over the years since the launch of the iPhone and the iPad a whole ecosystem of cute little cases and stickers has sprung up to cover the svelte outlines of the Apple gadgets. Whether the case are to protect the devices, customise them or - in the case of the iPhone 4 - improve the antennae reception, Apple has always encouraged cases.' WHERE p_id='1'"); is refusing to work.
-
For some reason my query is not working, mysql_select_db("UPDATE tbl_products SET p_feat='y',P_title=iPad Case, p_desc='Over the years since the launch of the iPhone and the iPad a whole ecosystem of cute little cases and stickers has sprung up to cover the svelte outlines of the Apple gadgets. Whether the case are to protect the devices, customise them or - in the case of the iPhone 4 - improve the antennae reception, Apple has always encouraged cases.' WHERE p_id='1'"); for some reason it will not update the record in the table, it does connect to the database as the rest of the page is doing what it needs to. here is the entire page code <?php session_start(); // if session is not set redirect the user if(empty($_SESSION['u_name'])) header("Location:index.html"); //if logout then destroy the session and redirect the user if(isset($_GET['logout'])) { session_destroy(); header("Location:index.html"); } else { //Connect to database from here $link = mysql_connect('localhost', 'root', ''); if (!$link) { die('Could not connect: ' . mysql_error()); } mysql_select_db("db_name"); } if(isset($_SERVER["REQUEST_METHOD"])=="POST") if(!isset($_GET['p_feat'])) $feat = "n"; else $feat = "y"; { mysql_select_db("UPDATE tbl_products SET p_feat='".$feat."',P_title=".$_GET['p_title'].", p_desc='".$_GET['p_desc']."' WHERE p_id='".$_GET['P_ID']."'"); } $result = mysql_error(); if (isset($_POST["Delete"])) { $file = $_REQUEST['imgfile']; $filemain = $_REQUEST['imgfilemain']; $num_files=count($file); $num_filesmain=count($filemain); for($i=0;$i<$num_files;$i++) { unlink ("$file[$i]"); unlink ("$filemain[$i]"); } } if (!is_dir('../uploads/'.$_GET['P_ID'].'')) { mkdir('../uploads/'.$_GET['P_ID'].''); } if (!is_dir('../uploads/'.$_GET['P_ID'].'/thumbs')) { mkdir('../uploads/'.$_GET['P_ID'].'/thumbs'); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link href="css/admin-main.css" rel="stylesheet" type="text/css"> <link href="css/jquery.validate.css" rel="stylesheet" type="text/css"> <link href="css/style.css" rel="stylesheet" type="text/css"> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" type="text/javascript"></script> <script src="js/jquery.validate.js" type="text/javascript"></script> <script src="js/validatefields.js" type="text/javascript"></script> </head> <body> <div class="container"> <div class="logo"> <img src="images/logo.png" /> </div> <div class="content"> <div class="left"> <?php $result = mysql_query("SELECT * FROM tbl_cats"); while($row = mysql_fetch_array($result)) { echo "<a href='secure.php?CAT_ID=" . $row['cat_id'] . "'>" . $row['cat_title'] . "</a>"; echo "<br />"; } ?> </div> <div class="page-modify"> <?php if(isset($_GET['CAT_ID'])) { $result = mysql_query("SELECT * FROM tbl_cats inner join tbl_products p on p.p_catlink = " . $_REQUEST['CAT_ID'] . " where cat_id = P_catlink and cat_id = " . $_GET['CAT_ID'] . ""); while($row = mysql_fetch_array($result)) echo "<p><a href='secure.php'><u>Main</u></a> > <a href='secure.php?CAT_ID=" . $_REQUEST['CAT_ID'] . "'><u>" . $row['cat_title'] . "</u></a> > " . $row['p_title'] . "</p>"; echo "<p><b>Step 2: Product Images</b></p>"; echo "<div class='TabBody'>"; if (isset($_POST["submit"])) { if (isset($_POST["submit"])) { $uploadpath = "../uploads/".$_GET['P_ID']."/"; $uploadpath = $uploadpath.basename($_FILES["imgfile"]["name"]); if (!move_uploaded_file($_FILES["imgfile"]["tmp_name"], $uploadpath)) die("There was an error uploading the file, please try again!"); $image_name = "../uploads/".$_GET['P_ID']."/".$_FILES["imgfile"]["name"]; list($width,$height) = getimagesize($image_name); $new_image_name = "../uploads/".$_GET['P_ID']."/thumbs/thumb_".$_FILES["imgfile"]["name"]; if ($width > $height) { $ratio = (75/$width); $new_width = round($width*$ratio); $new_height = round($height*$ratio); } else { $ratio = (75/$height); $new_width = round($width*$ratio); $new_height = round($height*$ratio); } $image_p = imagecreatetruecolor($new_width,$new_height); $img_ext = $_FILES['imgfile']['type']; if ($img_ext == "image/jpg" || $img_ext == "image/jpeg") { $image = imagecreatefromjpeg($image_name); } else if ($img_ext == "image/png") { $image = imagecreatefrompng($image_name); } else if ($img_ext == "image/gif") { $image = imagecreatefromgif($image_name); } else { die('this is no valid image resource'); } imagecopyresampled($image_p,$image,0,0,0,0,$new_width,$new_height,$width,$height); imagejpeg($image_p,$new_image_name,100); } imagecopyresampled($image_p,$image,0,0,0,0,$new_width,$new_height,$width,$height); imagejpeg($image_p,$new_image_name,100); } ?> <form method="post" enctype="multipart/form-data"> Please select a picture to upload:<br /> <input type="file" name="imgfile" /> <br /> <input type="submit" name="submit" value="Add Image" /> </form> <hr /> <form method="post" action=""> <?php //lets assign the folder name in $title //You can assign any name $title= "../uploads/".$_GET['P_ID']; /*$directory corresponds to whole path. Edit to your preference. (i assume u store your images in directory named "images") */ $directory = "$title"; //The array specifies the format of the files $allowed_types=array('jpg','jpeg','gif','png'); $file_parts=array(); $ext=''; $title=''; $i=0; $dir_handle = @opendir($directory) or die("There is an error with your image directory!"); while ($file = readdir($dir_handle)) { if($file=='.' || $file == '..') continue; $file_parts = explode('.',$file); $ext = strtolower(array_pop($file_parts)); $title = implode('.',$file_parts); $title = htmlspecialchars($title); $nomargin=''; if(in_array($ext,$allowed_types)) { if(($i+1)%4==0) $nomargin='nomargin'; echo' <div id="picture" style="float:left;"> <img src="../uploads/'.$_GET['P_ID'].'/thumbs/thumb_'.$file.'"><br> Select <input type="checkbox" value="'.$directory.'/'.$file.'" name="imgfile[]"> <input type="hidden" value="'.$directory.'/thumbs/thumb_'.$file.'" name="imgfilemain[]"> </div>'; } $i++; } closedir($dir_handle); //Now we have the list of images within form elements ?><div class="clearboth"><br /></div> <input type="submit" value="Delete" name="Delete"> </form> <div class="clearboth"></div> <?php echo "</div>"; echo "</div>"; echo "</div>"; } ?> <div class="clearboth"></div> </div> </div> <div id="footer"><a href="secure.php?logout"><b>Logout</b></a></div> </body> </html> im not getting any errors or anything its just not updating the database, any ideas?