kclark

same page. I know nothing about javascript.

Here is the code that I am working with. This will correctly pull the panels that I need for a particular company and put them in a list box. How can I get my image to change upon selection? <?php $panels = "select * from panels where company = " . $_GET["company"] . " order by name"; $result = mysql_query($panels); $num_rows = mysql_num_rows($result); if($num_rows == 0) echo ""; else { echo "<select>"; // printing the list box select command while($nt=mysql_fetch_array($result)){//Array or records stored in $nt echo "<option value=$nt[panelid]>$nt[name]</option>"; /* Option values are added by looping through the array */ } echo "<br></select>";// Closing of list box } ?>

Using php I have a dynamically filled select box with the names of images. How can I get an image box on my page and change upon selection?

Nevermind got it working. Thanks for the help. BTW. this was my finished code for everyone else. My other error was something different, but all is great now. { $query = "DELETE from products where productid = '$productid'"; if(file_exists("images/" . $productcompany . "/" . $productnumber . "_th.jpg"")) unlink("images/" . $productcompany . "/" . $productnumber . "_th.jpg""); if(file_exists("images/" . $productcompany . "/" . $productnumber . ".jpg"")) unlink("images/" . $productcompany . "/" . $productnumber . ".jpg""); }

I tried that, but now it deletes the thumbnail but not the larger image. When I delete, my actual product information is not being deleted either. { $query = "DELETE from products where productid = '$productid'"; if(file_exists("images/$productcompany/$productnumber.jpg")) unlink("images//$productname/{$productnumber}_th.jpg"); }

I have a delete statement to delete images, but I also want it to delete the thumbnail image as well. $query = "DELETE from products where urnid = '$urnid'"; if(file_exists("images/$product.jpg")){ unlink("images/$product.jpg")} Is there a way to delete the product_th.jpg image?

I got it figured out. These lines: $o_path = "images/" . $companyname . "/" . $materialdir . "/";//line 144 /* $s_path is the path where you want to save the new image INCLUDE trailing slash */ $s_path = "images/" . $companyname . "/" . $materialdir . "/"; They both said $o_path. Now it works, thanks a bunch

The image did get upload, but no thumbnail Getting the following errors:

yes

my page was working fine until I replaced my original upload script with that provided. My first post was my original script that worked fine. I wanted to add the thumbnail so I came here. I changed my original to what I posted the 2nd time just above. I have error reporting turned on but not getting any error, just blank page.

I am getting an error, Blank page that is. if($form == "Delete Casket") echo ""; else { /* put this at the top of your upload script */ include('resize.php'); if ($_FILES['file']['error'] > 0) { echo "Return Code: " . $_FILES['file']['error'] . "<br />"; }else{ echo "Upload: " . $_FILES['file']['name'] . "<br />"; echo "Type: " . $_FILES['file']['type'] . "<br />"; echo "Size: " . ($_FILES['file']['size'] / 1024) . " Kb<br />"; echo "Temp file: " . $_FILES['file']['tmp_name'] . "<br />"; if (file_exists("images/" . $_FILES['file']['name'])){ echo $_FILES['file']['name'] . " already exists. "; }else{ move_uploaded_file($_FILES['file']['tmp_name'], "images/$companyname/$materialdir/$prefix$modelnumber.jpg"); echo "Stored in: images/$companyname/$materialdir/$prefix$modelnumber.jpg"; /* define the resizing parameters */ /* $file is the name of the original image WITHOUT the path */ $file = $prefix . $modelnumber . "jpg"; /* $save is the name of the resized image WITHOUT the path */ $save = $prefix . $modelnumber . ".jpg"; /* $t_w is the MAXIMUM width of the new image */ $t_w = 800; /* $t_h is the MAXIMUM height of the new image */ $t_h = 600; /* $o_path is the path to the original image INCLUDE trailing slash */ $o_path = "images/" , $companyname . "/" . $materialdir . "/"; /* $s_path is the path where you want to save the new image INCLUDE trailing slash */ $o_path = "images/" , $companyname . "/" . $materialdir . "/"; /* NOTE: to overwrite the original with the new, use the same name and path for both */ /* resize original to be within the sizes specified -n $t_w and $t_h */ //Resize_Image($save,$file,$t_w,$t_h,$s_path,$o_path); /* make a thumbnail version */ $t_w = 100; $t_h = 120; $save = $prefix . $modelnumber . "_tn.jpg"; Resize_Image($save,$file,$t_w,$t_h,$s_path,$o_path); } } $photo = "images/$companyname/$materialdir/$prefix$modelnumber.jpg"; //$photo = "images/" . $companyname . "/" . $materialdir . "/" . $prefix . $modelnumber . ".jpg"; $thumbnail = "images/" . $companyname . "/" . $materialdir . "/" . $prefix . $modelnumber . "_th.jpg"; }

What if I don't want to resize the uploaded file only the thumbnail

How do I do this?

that tells me how to resize, but how can I upload 1 file and use it twice in the same upload

I am using the following code to upload images for my products. How can I modify it to not only upload the product image, but upload it a 2nd time resized for thumbnail or is it even possible? if ($_FILES['file']['error'] > 0) { echo "Return Code: " . $_FILES['file']['error'] . "<br />"; } else { echo "Upload: " . $_FILES['file']['name'] . "<br />"; echo "Type: " . $_FILES['file']['type'] . "<br />"; echo "Size: " . ($_FILES['file']['size'] / 1024) . " Kb<br />"; echo "Temp file: " . $_FILES['file']['tmp_name'] . "<br />"; if (file_exists("images/" . $_FILES['file']['name'])) { echo $_FILES['file']['name'] . " already exists. "; } else { move_uploaded_file($_FILES['file']['tmp_name'], "images/$companyname/$materialdir/$prefix$modelnumber.jpg"); //"images/" . $companyname . "/" . $materialdir/$prefix$modelnumber . ".jpg"); //"images/" . $_FILES['file']['name']);//change to Timp folder // "C:/upload/" . $_FILES['file']['name']);//change to Timp folder //echo "Stored in: " . "C:/xampp/htdocs/Timp/UserLogin/upload/" . $_FILES["file"]["name"]; echo "Stored in: images/$companyname/$materialdir/$prefix$modelnumber.jpg"; } } $photo = "images/$companyname/$materialdir/$prefix$modelnumber.jpg";

thanks a bunch that did it

I have a code that I am using to update multiple products at one time instead of one at a time. It works great except that my processing page is not updating the very last product. My process page is receiving all of my products as I know how many products that I am updating and I have my process page tell me how many products are updated as well as listing the name of each product updated. It is always the last product that is not updated. Here is my process update code. <?php $size = count($_POST['casketid']); //$size = 306; $i = 1; while ($i < $size) { $product=$_POST['productid'][$i];//getting case # $price=$_POST['price'][$i]; $model=$_POST['model'][$i]; $active=$_POST['active'][$i]; //Getting pricerange if(($price > "0") && ($price <= "1000.00")) $pricerange = "1"; elseif(($price >= "1001.00") && ($price <= "1500.00")) $pricerange = "2"; elseif(($price >= "1501.00") && ($price <= "2000.00")) $pricerange = "3"; elseif(($price <= "2001.00") && ($price <= "2500.00")) $pricerange = "4"; elseif(($price <= "2501.00") && ($price <= "3000.00")) $pricerange = "5"; elseif(($price >= "3001.00") && ($price <= "3500.00")) $pricerange = "6"; elseif(($price >= "3501.00") && ($price <= "4000.00")) $pricerange = "7"; elseif(($price >= "4001.00") && ($price <= "4500.00")) $pricerange = "8"; elseif(($price >= "4501.00") && ($price <= "4500.00")) $pricerange = "9"; elseif($price >= "5001.00") $pricerange = "10"; $query = "UPDATE products SET price='$price', pricerange='$pricerange', active='$active' WHERE productid='$product'"; mysql_query($query) or die ("Error in query: $query"); echo "$model = $price & active = $active</em><br />$size<br />"; ++$i; } ?>

Excuse me, the images are MINE!!! I want to use them for my articles that I wrote. How can I do that using php on my pages. Thank You

I have a page that displays various articles. I would like to show a background image for each article. Let's say I have articles for beaches. I would like to have a beach photo. Airplane article, show airplanes, etc. How can I accomplish this.

Nevermind, somehow my None=0 got changed to 92. So for those with 0 in the table field it was kicking those out. and pulling my hair out. Thanks for everyone's help.

Okay I figured out what was going on. When I enter a record, I have 3 events that could happen. If 1 of the 3 doesn't happen, I enter No event which is = 0 in the places db table. If I put a number greater than 0 it works. How do I make it right then.

I get an empty array. If I use my short query, I get the array.

tried mysql_fetch_assoc() same error. How do I do $row['name'] ?

Where do I put that?

Here is my whole page <?php // Get a database object $db = JFactory::getDBO(); $query = "SELECT deceasedlist.ID, deceasedlist.DFirstName, deceasedlist.DLastName, deceasedlist.Birth, deceasedlist.Death, deceasedlist.location, deceasedlist.funeral, deceasedlist.visitation, deceasedlist.receivingplace_id, deceasedlist.funeralplace_id, deceasedlist.cemeteryplace_id, deceasedlist.funeraldate, deceasedlist.Picture, deceasedlist.Obit1, deceasedlist.Obit2, deceasedlist.Obit3, deceasedlist.Obit4, deceasedlist.Obit5, deceasedlist.Obit6, deceasedlist.Obit7, deceasedlist.Obit8, places.place_name AS funeralplace, places.address AS funeralplaceaddress, places.city AS funeralplacecity, places.state AS funeralplacestate, places.zip AS funeralplacezip, places.country AS funeralplacecountry, places_1.place_name AS receivingplace, places_1.address AS receivingplaceaddress, places_1.city AS receivingplacecity, places_1.state AS receivingplacestate, places_1.zip AS receivingplacezip, places_1.country AS receivingplacecountry, places_2.place_name AS cemeteryplace, places_2.address AS cemeteryplaceaddress, places_2.city AS cemeteryplacecity, places_2.state AS cemeteryplacestate, places_2.zip AS cemeteryplacezip, places_2.country AS cemeteryplacecountry FROM deceasedlist INNER JOIN places ON deceasedlist.funeralplace_id = places.place_id INNER JOIN places AS places_1 ON deceasedlist.receivingplace_id = places_1.place_id INNER JOIN places AS places_2 ON deceasedlist.cemeteryplace_id = places_2.place_id WHERE deceasedlist.ID = '$_GET[iD]'"; $result = mysql_query($query) or die("Couldn't execute query."); $row = mysql_fetch_array($result); //extract($row);This is the line that is giving me problems echo $row['ID'];This line returns the correct ID # that was passed from previous page. var_dump($_GET[iD]);This line repeats my sql statement with the correct ID # in the ID equals statement print "<center> <table width=\"400\"> <tr><td>"; print "<form action='./sendcondolence?ID=$ID' method=\"post\" name=\"FormName\"><input type=\"submit\" value=\"Send A Condolence\" border=\"0\"></form></td><td><form action='./condolences?ID=$ID' method=\"post\" name=\"FormName\"><input type=\"submit\" value=\"View Condolences\" border=\"0\"></form></td> </tr> </table> </center><br><br><center>"; if($Picture == "") print "";if($Picture != "") print "<img src=\"$Picture\" alt=\"$DFirstName $DLastName\" height=\"169\" width=\"133\" border=\"0\"><br>"; print "<b>$DFirstName $DLastName</b></center>"; print "<br><br> <b>Born</b>: "; print date('F j, Y',strtotime($Birth)); print "<br> <b>Died</b>: "; print date('F j, Y',strtotime($Death)); print "<br><br>"; print $Location; print "<br><br>"; $today=date("Y-m-d"); if ($receivingplace_id > 0 && $funeraldate >= $today) print $visitation; if ($receivingplace_id >= 1 && $funeraldate >= $today) print " <a href=\"http://www.mapquest.com/maps/map.adp?city=".$receivingplacecity."&state=".$receivingplacestate."&address=".$receivingplaceaddress."&zip=".$receivingplacezip."&country=".$receivingplacecountry."&zoom=9\" target=\"_blank\"><u>" .$receivingplace. " (map/directions)</u></a><br>"; if ($funeralplace_id > 0 && $funeraldate >= $today) print $funeral; if ($funeralplace_id > 1 && $funeraldate >= $today) print " <a href=\"http://www.mapquest.com/maps/map.adp?city=".$funeralplacecity."&state=".$funeralplacestate."&address=".$funeralplaceaddress."&zip=".$funeralplacezip."&country=".$funeralplacecountry."&zoom=9\" target=\"_blank\"><u>" .$funeralplace. " (map/directions)</u></a><br>"; if ($cemeteryplace_id > 0 &&$funeraldate >= $today) print "Cemetery Location:"; if ($cemeteryplace_id > 1 && $funeraldate >= $today) print " <a href=\"http://www.mapquest.com/maps/map.adp?city=".$cemeteryplacecity."&state=".$cemeteryplacestate."&address=".$cemeteryplaceaddress."&zip=".$cemeteryplacezip."&country=".$cemeteryplacecountry."&zoom=9\" target=\"_blank\"><u>" .$cemeteryplace. " (map/directions)</u></a><br>"; print "<br><br> <html><body background=\"../../Obit Pics/veteran.jpg\"><p align=\"justify\">$Obit1 <br><br> $Obit2 <br><br> $Obit3 <br><br> $Obit4"; if($Obit5 == "") print ""; if($Obit5 != "") print "<br><br>$Obit5"; if($Obit6 == "") print ""; if($Obit6 != "") print "<br><br>$Obit6"; if($Obit7 == "") print ""; if($Obit7 != "") print "<br><br>$Obit7"; if($Obit8 == "") print ""; if($Obit8 != "") print "<br><br>$Obit8"; print "</p></body></html>"; ?>