PHP - Update Image In Same Page Without Going To Link

Hi,

Is it possible to build a PHP Template page that selects and publishes a row of data from a MySQL Database when a linked is clicked?

I would design: Template.php
Text links (perhaps on homepage of navigation bar): ProductA, ProductB and ProductC

If you click link ProductA Template.php would display data for ProductA and likewise for ProductB and ProductC.

I would also like search engines for find ProductA, ProductB and ProductC PHP pages. (Not just my single Template.php)

Any ideas as to how this could be done without designing individual PHP pages for each product?

Kind regards,

Matthew.

Hi, I've read a lot of places that it's not recommended to store binary files in my db.
So instead I'm supposed to upload the image to a directory, and store the link to that directory in database.

First, how would I make a form that uploads the picture to the directory (And what kinda directories are we talking?).

Secondly, how would I retrieve that link? And I guess I should rename the picture..

I'd appreciate any help, or a good tutorial (Haven't found any myself).

Hi,

I wrote the function below. It switches out one color for another. The pictures going in are css sprites with various colors and a white background.

So.. sprite 1 might by blue and sprite 2 might be green.

The function would be run twice to replace the blue + green with whatever colors were required.


/**

 * Changes the color of a graphic.

 * $settings = array (

 *  'icon'

 *  'new_icon'

 *  'old_color' = array

 *  'new_color' = array

 * );

*/

function updateIconColor($settings=array()) {

// Create Image

$image = imagecreatefrompng($settings['icon']);

// Convert True color image to a palatte

imagetruecolortopalette($image, false, 255);

// Restore Alpha

$white = imagecolorclosest($image, 255, 255, 255);

imagecolortransparent($image, $white);

// Find + Set color

$index = imagecolorclosest($image, $settings['old_color'][0],$settings['old_color'][1],$settings['old_color'][2]);

imagecolorset($image, $index, $settings['new_color'][0], $settings['new_color'][1], $settings['new_color'][2]);

// Restore Alpha

imageAlphaBlending($image, true);

imageSaveAlpha($image, true);

// Save

imagepng($image, $settings['new_icon']); // save image as gif

imagedestroy($image);

}


How could this be updated to allow some dithering (is that what it is called?) - the thing that smooths out an image to avoid pixelation around the edges?

Minor question.
1) Is there any reason why imagecolorexact doesn't work in this function. When I use imagecolorexact nothing happens and the picture remains the same.

have 2 scripts one that allows me to insert and upload image and one that allows me to delete and remove image so i was thinking in mix both together so it would be like this
first the delete image in an if statment then close } and then { an insert image but with an update mysql query}

i am trying to do a modify form where user can modify the data so i will need to update the image on the directory so with both delete and insert would it do the job???


<?php
define('ROOT_DIR', './');
define('PROPER', TRUE);
/**
* include common files
*/
include_once(ROOT_DIR. 'includes/common.inc.php');
// No album id has been selected
if (isset($_GET['drivers'])) 
 {
   // get the image file name so we
   // can delete it from the server
   $sql = "SELECT id, image

           FROM driversnew

           WHERE id = {$_GET['drivers']}";

   $result = mysql_query($sql)

             or die('Delete photo failed. ' . mysql_error());

   if (mysql_num_rows($result) == 1) {

      $row = mysql_fetch_assoc($result);
      
define("GALLERY_IMG_DIR", "./images/");

      // remove the image and the thumbnail from the server
      unlink(GALLERY_IMG_DIR . $row['image']);

      unlink(GALLERY_IMG_DIR . 'thumbs/' . $row['image']);
      
      // and then remove the database entry
      
      
   }

}
 
 /////////// this where the upload script starts/////////// this where the upload script starts//////// this where the upload script starts


//define a maxim size for the uploaded images
define ("MAX_SIZE","100");
// 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","150");
define ("HEIGHT","100");

// 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);

//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);

//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 errro occures. If the error occures the file will not be uploaded.
$errors=0;
// checks if the form has been submitted
if(isset($_POST['Submit']))
{
//reads the name of the file the user submitted for uploading
$image=$_FILES['image']['name'];
// if it is not empty
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"))
{
echo '<h1>Unknown extension!</h1>';
$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 '<h1>You have exceeded the size limit!</h1>';
$errors=1;
}

//we will give an unique name, for example the time in unix time format
$image_name=time().'.'.$extension;
//the new name will be containing the full path where will be stored (images folder)
$newname="images/".$image_name;
$copied = copy($_FILES['image']['tmp_name'], $newname);
//we verify if the image has been uploaded, and print error instead
if (!$copied)
{
echo '<h1>Copy unsuccessfull!</h1>';
$errors=1;
}
else
{
// the new thumbnail image will be placed in images/thumbs/ folder
$thumb_name='images/thumbs/'.$image_name;
// 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($newname,$thumb_name,WIDTH,HEIGHT);
}} }}

//If no errors registred, print the success message and show the thumbnail image created
if(isset($_POST['Submit']) && !$errors)
{

$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("eurico_edy", $con);



$query = "UPDATE products SET name = '$name',   location = '$location', date_of_birth='$date_of_birth', car_number='$car_number', favourite_track='$favourite_track', least_favourite_track='$least_favourite_track', achievements='$achievements', achievements='$achievements' email='$email', image='$image'   WHERE id = '$id'";



echo "<h1>Thumbnail created Successfully!</h1>";
echo '<img src="'.$thumb_name.'">';
echo ''.$newname.'';
mysql_close($con);
}


?>

Hi folks,

This has been wrecking my brain. I did do a google a few times to see if I can find a solution but nothing unfortunately.

I want to be able to update the details on a page without having to reupload a new image each time. But if I don't open a new image for upload, I cannot update any of the other details.

Below is the code and form etc for this particular thing...

Please note this is just a project and will not be going live. I know there are vulnerabilities and I will work on those at a later stage. Thanks for any help with this current issue.

<?php
include_once('includes/header.php');



if(isset($_POST['new']) && $_POST['new']==1){

if (isset($_POST['submit'])) {
    if(!empty($_FILES['image']['name'])) {
  	// Get image name
  	$image = $_FILES['image']['name'];

$image = mysqli_real_escape_string($con, $_FILES['image']['name']);
$slide_text = mysqli_real_escape_string($con, $_POST['slide_text']);
$youtube = mysqli_real_escape_string($con, $_POST['youtube']);
$vid_text = mysqli_real_escape_string($con, $_POST['vid_text']);


  	// image file directory
  	$target = "uploads/".basename($image);
  	if($_POST['image'] = ""){
    $sql = "UPDATE slide SET slide_text='".$slide_text."', image='".$image."', youtube='".$youtube."', vid_text='".$vid_text."'"; 
  	}
  else{
    $sql = "UPDATE slide SET slide_text='".$slide_text."', youtube='".$youtube."', vid_text='".$vid_text."'"; 
  }
     $result = mysqli_query($con, $sql);

  	if (move_uploaded_file($_FILES['image']['tmp_name'], $target)) {
  		$msg = "Image uploaded successfully";
  	}else{
  		$msg = "Failed to upload image";
  	}
  	
     if(!$result){ 
        die('Error: ' . mysqli_error($con));
     } else{ 
            
       $message = ' - <i class="fa fa-check success"> Record Updated!</i>';

    } 
    }
}
}
$sql = "SELECT * FROM slide";
$result = $con->query($sql);

if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
?>
        <!-- Header-->

        <div class="breadcrumbs">
            <div class="col-sm-4">
                <div class="page-header float-left">
                    <div class="page-title">
                        <h1>Slide Show</h1>
                    </div>
                </div>
            </div>            <div class="col-sm-8">

            </div>
        </div>

        <div class="content mt-3">
            <div class="animated fadeIn">
                <div class="row">

                 <div class="col-lg-12">
                    <div class="card">
                      <div class="card-header"><strong>Image </strong><small>Slide</small></div>
                      <div class="card-body card-block">
                            <form role="form" method="post" action"" enctype="multipart/form-data">
                                <input type="hidden" name="new" value="1" />
                            <div class="modal-body">
                                
                        <div class="row form-group">
                          <div class="col-6">
                                <div class="form-group"><label for="image" class=" form-control-label">Image</label>
                                <input type="file" id="image" name="image" value="<?php echo $row['image']; ?>" class="form-control">
                                </div>
                                </div>
                          <div class="col-6">
                           <div class="form-group"><label for="name" class=" form-control-label">Uploaded Image</label>
                          <img src="uploads/<?php echo $row['image']; ?>" width="150" height="150" class="img-fluid hover-shadow" />
                          </div>
                          </div>
                          </div>

                        <div class="row form-group">
                          <div class="col-6">
                                <div class="form-group"><label for="youtube" class=" form-control-label">Video</label>
                                <input type="text" id="youtube" name="youtube" value="<?php echo $row['youtube']; ?>" placeholder="Enter Video URL" class="form-control">
                                
                                </div>
                                </div>
                          <div class="col-6">
                                <div class="form-group"><label for="vid_text" class=" form-control-label">Video Text</label>
                                <input type="text" id="vid_text" name="vid_text" value="<?php echo $row['vid_text']; ?>" placeholder="Video Text" class="form-control">
                                
                                </div>
                          </div>
                          </div>
                          
                        <div class="form-group"><label for="slide_text" class=" form-control-label">Text Overlay</label>
                        <textarea is="slide_text" name="slide_text" class="form-control"><?php echo $row['slide_text']; ?></textarea>
                        </div>
                        
                            <div class="modal-footer">
                                <button type="submit" name="submit" id="submit" class="btn btn-primary">Confirm</button>
                            </div>
                            </form>
                  </div>
                </div>
            </div><!-- .animated -->
        </div><!-- .content -->
<?php
}
}
?>

    </div><!-- /#right-panel -->

    <!-- Right Panel -->


    <script src="assets/js/vendor/jquery-2.1.4.min.js"></script>
    <script src="assets/js/popper.min.js"></script>
    <script src="assets/js/plugins.js"></script>
    <script src="assets/js/main.js"></script>


    <script src="assets/js/lib/data-table/datatables.min.js"></script>
    <script src="assets/js/lib/data-table/dataTables.bootstrap.min.js"></script>
    <script src="assets/js/lib/data-table/dataTables.buttons.min.js"></script>
    <script src="assets/js/lib/data-table/buttons.bootstrap.min.js"></script>
    <script src="assets/js/lib/data-table/jszip.min.js"></script>
    <script src="assets/js/lib/data-table/pdfmake.min.js"></script>
    <script src="assets/js/lib/data-table/vfs_fonts.js"></script>
    <script src="assets/js/lib/data-table/buttons.html5.min.js"></script>
    <script src="assets/js/lib/data-table/buttons.print.min.js"></script>
    <script src="assets/js/lib/data-table/buttons.colVis.min.js"></script>
    <script src="assets/js/lib/data-table/datatables-init.js"></script>

 <script src="https://cdn.tiny.cloud/1/sw6bkvhzd3ev4xl3u9yx3tzrux4nthssiwgsog74altv1o65/tinymce/5/tinymce.min.js" referrerpolicy="origin"></script>

  <script>
    tinymce.init({
      selector: 'textarea',
      plugins: 'advlist autolink lists link image charmap print preview hr anchor pagebreak',
      toolbar_mode: 'floating',
   });
  </script>
  
    <script type="text/javascript">
        $(document).ready(function() {
          $('#customer-table').DataTable();
        } );
    </script>


</body>
</html>

As you can see I am trying to use an If clause if the image field in the form is empty then I just want to update the other details. Else, if I fill the image field with a file, then update the lot.

  	if($_POST['image'] = ""){
    $sql = "UPDATE slide SET slide_text='".$slide_text."', image='".$image."', youtube='".$youtube."', vid_text='".$vid_text."'"; 
  	}
  else{
    $sql = "UPDATE slide SET slide_text='".$slide_text."', youtube='".$youtube."', vid_text='".$vid_text."'"; 
  }

This doesn't work.

Any ideas, besides give up?

 

Hi   I am winning I think   I have got the records displayed for the current user logged in so basically they can only see their submitted listings and just working on the edit of them so the current user logged in can update their listing and is all working apart from the update of the images   the images are stored by the file name on the database and then gets moved onto the server so the actual images are not stored on the database only the file names are and the images are moved onto the server, hope that makes sense   what I can't do at the mo is work out how to update the file names of the images on the database and update on the server   I get the following error   Notice: Undefined index: photo on line 209 and line 211   the coding for them lines are below

$pic1= basename($_FILES['photo']['name'][0]);

$pic2= basename($_FILES['photo']['name'][1]);

The rest of the coding below that is

if(!empty($_FILES['photo']['tmp_name']))
{
	
	// Number of uploaded files
	 $num_files = count($_FILES['photo']['tmp_name']);

	 /** loop through the array of files ***/
	 for($i=0; $i < $num_files;$i++)
	 {
		 // check if there is a file in the array
		 if(!is_uploaded_file($_FILES['photo']['tmp_name'][$i]))
		 {
			 $messages[] = 'No file uploaded';
		 }
		 else
		 {
			 // move the file to the specified dir
			 if(move_uploaded_file($_FILES['photo']['tmp_name'][$i],$target.'/'.$_FILES['photo']['name'][$i]))
			 {
			
				 $messages[] = $_FILES['photo']['name'][$i].' uploaded';
				
			 }
			 else
			 {
				 // an error message
				 $messages[] = 'Uploading '.$_FILES['photo']['name'][$i].' Failed';
			 }
		 }
	 }

The update query is below

// save the data to the database
 mysql_query("UPDATE privatelistings SET listingtitle='$listingtitle', make='$model', model='$model', exteriorcolour='$exteriorcolour', enginesize='$enginesize', fueltype='$fueltype', yearregistered='$yearregistered', transmission='$transmission', mileage='$mileage', nodoors='$nodoors', bodystyle='$bodystyle', price='$price', photo='$pic1', photo1='$pic2' WHERE id='$id'")
 or die(mysql_error()); 

I am going to be updating to mysqli just want to get it working first   My HTML form coding is below

<form action="" method="post" enctype="multipart/form-data">
 <input type="hidden" name="id" value="<?php echo $id; ?>"/>
 <div>
 <strong>Listing Title: *</strong> <input type="text" name="listingtitle" value="<?php echo $listingtitle; ?>"/>
 <br/>
 <strong>Make: *</strong> <input type="text" name="make" value="<?php echo $make; ?>"/>
 <br/>
 <strong>Model: *</strong> <input type="text" name="model" value="<?php echo $model; ?>"/>
 <br/>
 <strong>Exterior Colour: *</strong> <input type="text" name="exteriorcolour" value="<?php echo $exteriorcolour; ?>"/>
 <br/>
 <strong>Engine Size: *</strong> <input type="text" name="enginesize" value="<?php echo $enginesize; ?>"/>
 <br/>
 <strong>Fuel Type: *</strong> <input type="text" name="fueltype" value="<?php echo $fueltype; ?>"/>
 <br/>
 <strong>Year Registered: *</strong> <input type="text" name="yearregistered" value="<?php echo $yearregistered; ?>"/>
 <br/>
 <strong>Transmission: *</strong> <input type="text" name="transmission" value="<?php echo $transmission; ?>"/>
 <br/>
 <strong>Mileage: *</strong> <input type="text" name="mileage" value="<?php echo $mileage; ?>"/>
 <br/>
 <strong>Number of Doors: *</strong> <input type="text" name="nodoors" value="<?php echo $nodoors; ?>"/>
 <br/>
 <strong>Body Style: *</strong> <input type="text" name="bodystyle" value="<?php echo $bodystyle; ?>"/>
 <br/>
 <strong>Price: *</strong> <input type="text" name="price" value="<?php echo $price; ?>"/>
 <br/>
 <strong>Photo One:</strong> <input type='hidden' name='size' value='350000'><input type='file' name='photo[]'>
 <br>
 <strong>Photo Two:</strong> <input type='hidden' name='size' value='350000'><input type='file' name='photo[]'>
 <br>
 <input type="submit" name="submit" value="Submit">
 </div>
 </form>

sorry was not sure what other I need to show, so you guys get the idea?

Hey all,

I have a CRUD php project I am working on. I have insert working reading and deleteing. The only one I have left is update. My page submits the form but when the btn is clicked my page refreshes and does not update in the db. All the controls are cleared. Im assuming I’m missing something simple or just have a small mistake that is running past me,

<?php
    error_reporting(E_ALL & ~E_NOTICE);
  // include config for Database
    require_once "php/config.php";

    // Declare the variables that will be used.
    $name = $language = $datenow = "";
    $nameerror = $langerror = $dateerror = "";

    // Process form data when its submitted
    if(isset($_POST["id"]) && !empty($_POST["id"])) {
      // Get hidden input value.
        $id = $_POST["id"];
          $input_name = trim($_POST["name"]);
          if(empty($input_name)) {
              $nameerror = "Name is required. ";
          } elseif (!filter_var($input_name, FILTER_VALIDATE_REGEXP,
              array("options"=>array("regexp"=>"/^[a-zA-Z\s]+$/")))) {
              $nameerror = "Please enter a valid name. ";
          } else {
              //$namesafe = mysqli_real_escape_string($connection, $input_name);
              $name = $input_name;
          }
          // Validate language entered
          $input_lang = trim($_POST["language"]);
          if(empty($input_lang)) {
              $langerror = "Please enter a language. ";
          } else {
              $language = $input_lang;
          }
          // Get current Date and Time
          $currentDate = date("Y-m-d H:i:s");
          // OR
          $datetimeobj = new DateTime();
          $datetimeobj->format("Y-m-d H:i:s");

          //if(empty($nameerror) && empty($langerror) && empty($dateerror)) {

            if($name != "" && $language != "") {
                $sql = "UPDATE users SET name=:name, language=:language, " .
                       "date=:date WHERE id=:id";
                    error_log($sql);
                if($stmt = $pdoConnect->prepare($sql)) {
                    $stmt->bindParam(":name", $param_name);
                    $stmt->bindParam(":language", $param_lang);
                    $stmt->bindParam(":date", $param_date);
                    $stmt->bindParam(":id", $param_id);
                    $para_name = $name;
                    $param_lang = $lang;
                    $param_date = $date;
                    $param_id = $id;
                    if($stmt->execute()) {
                      header("location: index.php");
                      exit();
                    } else {
                          echo "Something went wrong, try again later.";
                    }
                }
           } else {
                  $errormsg = '<div > 'All fields are required to continue</div>';
           }
            unset($stmt);
        unset($pdoConnect);
    } else {
          if(isset($_GET["id"]) && !empty(trim($_GET["id"]))) {
              $id = trim($_GET["id"]);
              $sql = "SELECT * FROM users WHERE id = :id";
              if($stmt = $pdoConnect->prepare($sql)) {
                  $stmt->bindParam(":id", $param_id);
                  $param_id = $id;
                  if($stmt->execute()) {
                      if($stmt->rowCount() == 1) {
                          $row = $stmt->fetch(PDO::FETCH_ASSOC);
                          //$id = $row["id"];
                          $name = $row["name"];
                          $language = $row["language"];
                          $userdate = $row["date"];

                      } else {
                            header("location: error.php");
                            exit();
                      }
                  } else {
                        echo "Something went wrong with UPDATE, try again later.";
                  }
              }
              // Close $stmt statement
              unset($stmt);
              // Close connection
              unset($pdoConnect);
          } else {
              // URL doesn't contain valid 'id' parameter.
                header("location: error.php");
                exit();
          }
    }

?>

 

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=342583.0

hi all

i have a problem here,

Iv got a form  that uploads images to a folder and updates the db with the name of that image, that work ok

but if one of the upload field are left blank then the script updates the db with empty values
how can i get it to only update the db with only submitted form field data????

here is the form
Code: [Select]
<?php

if (isset($_GET['id'])) {
$id = $_GET['id'];
}

?>

<form action="ud_image.php?id=<? echo "$id"?>" method="post" enctype="multipart/form-data" name="form1" id="form1">
<table class="udp">
  <tr>
    <th>Thumbnail:</th>
    <td><input type="hidden" name="MAX_FILE_SIZE" value="1029120" />
<input name="ufile[]" type="file" id="ufile[]" size="50" /></td>
</tr>
  <tr>
    <th>Image 1:</th>
    <td><input type="hidden" name="MAX_FILE_SIZE" value="1029120" />
<input name="ufile[]" type="file" id="ufile[]" size="50" /></td>
  </tr>
  <tr>
    <th>Image 2:</th>
    <td><input type="hidden" name="MAX_FILE_SIZE" value="1029120" />
<input name="ufile[]" type="file" id="ufile[]" size="50" /></td>
  </tr>
  <tr>
    <th>Image 3:</th>
    <td><input type="hidden" name="MAX_FILE_SIZE" value="1029120" />
<input name="ufile[]" type="file" id="ufile[]" size="50" /></td>
  </tr>
  <tr>
    <th>Image 4:</th>
    <td><input type="hidden" name="MAX_FILE_SIZE" value="1029120" />
<input name="ufile[]" type="file" id="ufile[]" size="50" /><input type="submit" name="Submit" value="Upload" /></td>
  </tr>
</table>
</form>



and here is the

processing page


<?php
include("protect/password_protect.php");

error_reporting(E_ALL);

include ("../includes/db_config.php");

$con = mysql_connect($db_hostname,$db_username,$db_password);
@mysql_select_db($db_database) or die( "Unable to select database");


$path1= "../thumbnails/".$_FILES['ufile']['name'][0];
$path2= "../images/".$_FILES['ufile']['name'][1];
$path3= "../images/".$_FILES['ufile']['name'][2];
$path4= "../images/".$_FILES['ufile']['name'][3];
$path5= "../images/".$_FILES['ufile']['name'][4];

//copy file to where you want to store file
copy($_FILES['ufile']['tmp_name'][0], $path1);
copy($_FILES['ufile']['tmp_name'][1], $path2);
copy($_FILES['ufile']['tmp_name'][2], $path3);
copy($_FILES['ufile']['tmp_name'][3], $path4);
copy($_FILES['ufile']['tmp_name'][4], $path5);
?>

<html>

<head>
<title>Update Project Images</title>
<link rel="stylesheet" type="text/css" href="../../project/backend/style.css" />
</head>
<body>
<table class="udip">
  <tr>
    <th><? echo "<img src=\"$path1\" width=\"150\" height=\"150\">";?></th>
    <th><? echo "<img src=\"$path2\" width=\"150\" height=\"150\">";?></th>
    <th><? echo "<img src=\"$path3\" width=\"150\" height=\"150\">";?></th>
    <th><? echo "<img src=\"$path4\" width=\"150\" height=\"150\">";?></th>
    <th><? echo "<img src=\"$path5\" width=\"150\" height=\"150\">";?></th>
  </tr>
  <tr>
    <td><? echo "File Name :".$_FILES['ufile']['name'][0]."<BR/>";?></td>
    <td><? echo "File Name :".$_FILES['ufile']['name'][1]."<BR/>";?></td>
    <td><? echo "File Name :".$_FILES['ufile']['name'][2]."<BR/>";?></td>
    <td><? echo "File Name :".$_FILES['ufile']['name'][3]."<BR/>";?></td>
    <td><? echo "File Name :".$_FILES['ufile']['name'][4]."<BR/>";?></td>
  </tr>
  <tr>
    <td><?echo "File Size :".$_FILES['ufile']['size'][0]."<BR/>";?></td>
    <td><?echo "File Size :".$_FILES['ufile']['size'][1]."<BR/>";?></td>
    <td><?echo "File Size :".$_FILES['ufile']['size'][2]."<BR/>";?></td>
    <td><?echo "File Size :".$_FILES['ufile']['size'][3]."<BR/>";?></td>
    <td><?echo "File Size :".$_FILES['ufile']['size'][4]."<BR/>";?></td>
  </tr>
  <tr>
    <td><? echo "File Type :".$_FILES['ufile']['type'][0]."<BR/>";?></td>
    <td><? echo "File Type :".$_FILES['ufile']['type'][1]."<BR/>";?></td>
    <td><? echo "File Type :".$_FILES['ufile']['type'][2]."<BR/>";?></td>
    <td><? echo "File Type :".$_FILES['ufile']['type'][3]."<BR/>";?></td>
    <td><? echo "File Type :".$_FILES['ufile']['type'][4]."<BR/>";?></td>
  </tr>
</table>
</body>
</html>
<?
$filesize1=$_FILES['ufile']['size'][0];
$filesize2=$_FILES['ufile']['size'][1];
$filesize3=$_FILES['ufile']['size'][2];
$filesize4=$_FILES['ufile']['size'][3];
$filesize5=$_FILES['ufile']['size'][4];

if($filesize1 && $filesize2 && $filesize3 && $filesize4 && $filesize5 != 0)

{
echo "We have recieved your files<p>";
}

else {
echo "Error in you images check and try again Database has been updated to blank images so no images will be shown on details page.";
}


$query = "UPDATE $db_table SET 
thumbnail = '".$_FILES['ufile']['name'][0]."', image1 = '".$_FILES['ufile']['name'][1]."', image2 = '".$_FILES['ufile']['name'][2]."', image3 = '".$_FILES['ufile']['name'][3]."', image4 = '".$_FILES['ufile']['name'][4]."' WHERE id = '".$_GET['id']."'";


if (!mysql_query($query,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($con)


?>

Hi all,

As you will see this is my first post in I really hope somebody can nail this for me, as I have been working on this for some time and I cannot get it to work.

Basically this is the final part of a CMS I'm building, and all was fine until I needed to build in an option of a multiple image uploader to accompany all other stock details.

I have managed to nail the 'insert' part of the multiple image uploader in this case up to 4 images, and the code is below for this part, any help with improvements though will be greatly appreciated.

Code: [Select]
if(isset($_POST['btnsubmit']))
{

$flag=$_POST['flag'];
if ($flag==0)
{
 
$name=$_POST['txtname'];
$desc1=$_POST['e1m1'];
 
$meta=$_POST['txtmeta'];
$sr=$_POST['srno1'];
$name=$_POST['txtname'];
$ref=$_POST['Ref'];
$desc=$_POST['e1m1'];
$maker=$_POST['Maker'];
$date=$_POST['Date'];
$weight=$_POST['Weight'];
$height=$_POST['Height'];
$depth=$_POST['Depth'];
$width=$_POST['Width'];
$price=$_POST['txtprice'];
$sold=$_POST['txtsold'];
$active=$_POST['active'];
$pcats=$_POST['pcats'];
$subcats=$_POST['subcats'];

$str_str='';
    $p='';
    $j=0;
    for($i=0;$i<=3;$i++){
    $j++;
    $p=$_REQUEST['p$j'];
    $file=$_FILES['pic']['name'][$i];
   
    if(!empty($file) ){
              $str_str.=",pic$j='$file'";
     }
     else if(!empty($p))$str_str.=",pic$j='$p'";
     
     $path1="imgdata/stock/".$file;
     copy($_FILES['pic']['tmp_name'][$i], $path1);     
     
    }

$q24=mysql_query("update stock set stock_Name='$name', stock_MetaTitle='$meta', parent_Category='$pcats', sub_Category='$subcats', stock_Image='imgdata/stock/$pic[0]', stock_Image2='imgdata/stock/$pic[1]', stock_Image3='imgdata/stock/$pic[2]', stock_Image4='imgdata/stock/$pic[3]', stock_Ref='$ref', stock_Description='$desc1', stock_Maker='$maker', stock_Date='$date', stock_Weight='$weight', stock_Height='$height', stock_Depth='$depth',stock_Width='$width', stock_Price='$price', stock_Sold='$sold', stock_Active='$active', stock_DateTime='$dt2' where stock_Id=$sr") or die (mysql_error());
$flag=1;
$conf="Data Updated Successfully - Click <a href='http://www.accendsandbox.co.uk/adminSallam/admin_categories.php'>here</a> to continue";
$update="1";


Code: [Select]
<tr>
<td bgcolor="#A0B050" width="161">
<div style="font-family:Verdana, Arial, Helvetica, sans-serif; position:relative; font-size:12px; color:#293334; font-weight:bold; position:relative; float:left; left:1px;">Stock Image 1 (Main):</div>
</td>
<td bgcolor="#888888">
<input type="file" name="pic1[]" id="pic1[]" size="50" />
</td>
</tr>
<tr>
<td bgcolor="#A0B050" width="161">
<div style="font-family:Verdana, Arial, Helvetica, sans-serif; position:relative; font-size:12px; color:#293334; font-weight:bold; position:relative; float:left; left:1px;">Stock Image 2:</div>
</td>
<td bgcolor="#888888">
<input type="file" name="pic1[]" id="pic1[]" size="50" />
</td>
</tr>
<tr>
<td bgcolor="#A0B050" width="161">
<div style="font-family:Verdana, Arial, Helvetica, sans-serif; position:relative; font-size:12px; color:#293334; font-weight:bold; position:relative; float:left; left:1px;">Stock Image 3:</div>
</td>
<td bgcolor="#888888">
<input type="file" name="pic1[]" id="pic1[]" size="50" />
</td>
</tr>
<tr>
<td bgcolor="#A0B050" width="161">
<div style="font-family:Verdana, Arial, Helvetica, sans-serif; position:relative; font-size:12px; color:#293334; font-weight:bold; position:relative; float:left; left:1px;">Stock Image 4:</div>
</td>
<td bgcolor="#888888">
<input type="file" name="pic1[]" id="pic1[]" size="50" />
</td>
</tr>
<input type="submit" name="btnsubmit" value="Submit">
<input type="submit" name="btndelete" value="Delete" DEFANGED_OnClick="return check();">
<input type="hidden" name="srno1" value="<?= $rows["stock_Id"];?>">
<input type="hidden" name="action" value="Upload">

All seems to be fine above, I can upload 1,2,3 or 4 images and the image goes into the server and the path to the database.

But I then needed the option for my client to be able to click to edit a certain stock and then aswel as edit the other details, if he wanted to change one pic, no pics or all 4 he could and when he clicked submit, if there was a new image it would change if not it would stay as it is.

So here is my attempt and at the moment it doesnt work, so I'm looking for help of any kid and anything can change.

Code: [Select]
$name=$_POST['txtname'];
$ref=$_POST['Ref'];
$desc=$_POST['e1m1'];
$maker=$_POST['Maker'];
$date=$_POST['Date'];
$weight=$_POST['Weight'];
$height=$_POST['Height'];
$depth=$_POST['Depth'];
$width=$_POST['Width'];
$price=$_POST['txtprice'];
$sold=$_POST['txtsold'];
$meta=$_POST['txtmeta'];
$active=$_POST['active'];
$pcats=$_POST['pcats'];
$subcats=$_POST['subcats'];

$pic1='';
for($i=0;$i<4;$i++){
if(isset($_FILES['pic1']['name'][$i]))$pic1[$i]=$_FILES['pic1']['name'][$i];
else $pic1[$i]='';
}
for($i=0;$i<4;$i++){
if(isset($_FILES['pic1']['name'][$i]))$path1= "./imgdata/stock/".$_FILES['pic1']['name'][$i];
//echo $_FILES['pic1']['tmp_name'][$i]." :". $path1;
if(!empty($_FILES['pic1']['name'][$i])&&isset($_FILES['pic1']['name'][$i]))copy($_FILES['pic1']['tmp_name'][$i], $path1);
}
       
$q=mysql_query("insert into stock (stock_Name, stock_MetaTitle, parent_Category, sub_Category, stock_Ref, stock_Description, stock_Maker, stock_Date, stock_Weight, stock_Height, stock_Depth, stock_Width, stock_Price, stock_Sold, stock_Image, stock_Image2, stock_Image3, stock_Image4, stock_Active, stock_DateTime) values('$name','$meta','$pcats','$subcats','$ref','$desc','$maker','$date','$weight','$height','$depth','$width','$price','$sold','imgdata/stock/$pic1[0]','imgdata/stock/$pic1[1]','imgdata/stock/$pic1[2]','imgdata/stock/$pic1[3]','$active','$dt2')") or die (mysql_error());
$conf="Data Inserted Successfully - Click <a href='http://www.accendsandbox.co.uk/adminSallam/admin_stock.php'>here</a> to continue";
$update=1;

Code: [Select]
<tr>
<td bgcolor="#A0B050" width="161">
<div style="font-family:Verdana, Arial, Helvetica, sans-serif; position:relative; font-size:12px; color:#293334; font-weight:bold; position:relative; float:left; left:1px;">Stock Image 1 (Main):</div>
</td>
<td bgcolor="#888888">
<input type="file" name="pic[]" size="50" /> <input type="hidden" name="p1" value="<?php echo $pic1;?>" /> &nbsp;<img src="<?php echo $pic1;?>" height="100px" />
</td>
</tr>
<tr>
<td bgcolor="#A0B050" width="161">
<div style="font-family:Verdana, Arial, Helvetica, sans-serif; position:relative; font-size:12px; color:#293334; font-weight:bold; position:relative; float:left; left:1px;">Stock Image 2:</div>
</td>
<td bgcolor="#888888">
<input type="file" name="pic[]" size="50" /> <input type="hidden" name="p2" value="<?php echo $pic2;?>" /> &nbsp;<img src="<?php echo $pic2;?>" height="100px" />
</td>
</tr>
<tr>
<td bgcolor="#A0B050" width="161">
<div style="font-family:Verdana, Arial, Helvetica, sans-serif; position:relative; font-size:12px; color:#293334; font-weight:bold; position:relative; float:left; left:1px;">Stock Image 3:</div>
</td>
<td bgcolor="#888888">
<input type="file" name="pic[]" size="50" /> <input type="hidden" name="p3" value="<?php echo $pic3;?>" /> &nbsp;<img src="<?php echo $pic3;?>" height="100px" />
</td>
</tr>
<tr>
<td bgcolor="#A0B050" width="161">
<div style="font-family:Verdana, Arial, Helvetica, sans-serif; position:relative; font-size:12px; color:#293334; font-weight:bold; position:relative; float:left; left:1px;">Stock Image 4:</div>
</td>
<td bgcolor="#888888">
<input type="file" name="pic[]" size="50" /> <input type="hidden" name="p4" value="<?php echo $pic4;?>" /> &nbsp;<img src="<?php echo $pic4;?>" height="100px" />
</td>
</tr>

What happens above as its all on the same page, is when a stock item is selected to be edited the form to update the images changes to the image upload options above, instead of the original ones for a new stock item at the top of this post.

I can provide anything you need to help me with this, so please can somebody take a look and see if it can be got working, as its been a long problem for me this.

Cheers

I'm not looking for code, mostly just some direction, but I'm sure I'll be back as I try to shape the code.  Also, I know very little about coding jQuery, Ajax, etc.  Here is what I'm looking for:

Basketball coach enters a Page that only he (or admin) can see.  (I have that part figured out.)
Once there, he has a form to fill out with a player's name and other information.

I'd rather there not be 12 rows of empty cells.  (Coaches will view that as work)
I'd rather not have the Page reload on each "Add", but that would be the lesser of two evils.

Is there a way to keep a persistent connection so when a coach hits Add, the player gets added to the database, a new empty form shows up, and the player's information shows up below on a roster?

Hi I have an update page with multipule drop down menus,  I am looking for a way to allow only the drop down menus that have been altered to be sent to the database.  One way was to add the following code, where the $type_id equals 0 then add nothing to the database.

Code: [Select]
if ($type_id == 0) 
{
$type_id = "";
}

However I am getting a syntex error with this,  if I enter a value into the $type_id it selects that fine.  eg.

Code: [Select]
if ($type_id == 0) 
{
$type_id = "2";
}

What is the right way to send nothing to the database?

Fuller code of the page is here

<?php require_once("includes/sessions.php"); ?>
<?php require_once("includes/connections.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php confirm_logged_in();?>
<?php usersid(); ?>
<?php find_selected_event();
     find_selected_region();
     ?>
<?php $selected_event = getevent_byid ($url_eventid);
     $orgdescrip = orgdescription($url_eventid);
     $leveldescrip = leveldescription($url_eventid);
     $typedescrip = typedescription($url_eventid);
     $champdescrip = champdescription($url_eventid);
     $disdescrip = disdescription($url_eventid);
     $venuedescrip = venuedescription($url_eventid);
     $statusdescrip = statusdescription($url_eventid);
?>
<?php if (!isset($new_event)) {$new_event = false;} ?>
<?php
   // make sure the subject id sent is an integer
   if (intval($_GET['url_eventid']) == 0) {
      redirect_to('controlpanel.php');
   }

   include_once("includes/form_functions.inc.php");

   // START FORM PROCESSING
   // only execute the form processing if the form has been submitted
   if (isset($_POST['submit'])) {
      // initialize an array to hold our errors
      $errors = array();
   
      // perform validations on the form data
      
      $required_fields = array('title');
      $errors = array_merge($errors, check_required_fields($required_fields, $_POST));
      
      $required_numberfields = array();
      $errors = array_merge($errors, check_number_fields($required_numberfields, $_POST));
      
      $fields_with_lengths = array();
      $errors = array_merge($errors, check_max_field_lengths($fields_with_lengths, $_POST));
      
      // clean up the form data before putting it in the database
      
      
      $url_eventid = mysql_prep($_GET['url_eventid']);
      $user_id = mysql_prep($_POST['user_id']);
      $title = trim(mysql_prep($_POST['title']));
      $event_details = mysql_prep($_POST['event_details']);
      $type_id = mysql_prep($_POST['type_id']);
      $champ_id = mysql_prep($_POST['champ_id']);      
      $dis_id = mysql_prep($_POST['dis_id']);
      $org_id = mysql_prep($_POST['org_id']);
      $venue_id = mysql_prep($_POST['ven_id']);
      $level_id = mysql_prep($_POST['level_id']);
      $status_id = mysql_prep($_POST['status_id']);
      
      if ($type_id == 0) 
      {
      $type_id = "";
      }
      // Database submission only proceeds if there were NO errors.
      if (empty($errors)) {
         
         $sql = "UPDATE events SET \n"
               . "title = '{$title}',\n"
               . "event_details = '{$event_details}',\n"
                . "type_id = {$type_id},\n"
               . "champ_id = {$champ_id},\n"
               . "dis_id = {$dis_id},\n"
               . "org_id = {$org_id},\n"
               . "ven_id = {$venue_id},\n"
               . "user_id = {$url_userid},\n"
               . "level_id = {$level_id},\n"
               . "status_id = {$status_id}\n"
               . "WHERE event_id = {$url_eventid} \n"
               . "LIMIT 1";


      if ($result = mysql_query($sql, $connection)) {
            // as is, $message will still be discarded on the redirect
            $message = "The event was successfully updated.";
            // get the last id inserted over the current db connection
            $new_event_id = mysql_insert_id();
            redirect_to("newevent.php");
         } else {
            $message = "I am sorry but the event could not be updated.";
            $message .= "<br />" . mysql_error();
         }
      } else {
         if (count($errors) == 1) {
            $message = "There was 1 error in the form.";
         } else {
            $message = "There were " . count($errors) . " errors in the form.";
         }
      }
      // END FORM PROCESSING
   }
   
?>

<?php   /*THIS CODE WITH RETURN IN THE BROWSER THE URLS THAT ARE BEING
      PULLED DOWN*/

if(empty($_GET))
    echo "No GET variables";
else
    print_r($_GET);

?>
<?php include("includes/header.inc.php"); ?>
<title>Horse Events</title>
<?php include_once("includes/meta.inc.php");?>
<?php include_once("includes/cssfavgoogle.inc.php");?>
<link href="css/adminpanel.css" rel="stylesheet" type="text/css" />
<style>
input[type="number"] {
   width:40px;
}
</style>
</head>
<body>
<div id="wrapper">
<div id="header">
<img src="images/horseevents_wheretogo.png" align="right" />
<?php require_once ("includes/adminmenu.inc.php"); ?>
   
</div>
   
    <div id="adminleft">
      <h2>YOUR UPCOMING EVENTS
      <?php echo "<a href=\"newevent.php?url_userid={$url_userid}\"><img src=\"images/pink/add_event.png\" align=\"right\" width=\"131\" height=\"19\" /></a>" ?></h2>       
    <table id="datetable" width="300" border="0" >
    <?php   
        $event_users_set = get_upcomingeventsforuser ($url_userid);
        while ($eventid = mysql_fetch_array ($event_users_set)){
        echo"<tr class=\'date\'>";
        echo"<td>" . $eventid["stdate"] ."</td>";   
        echo"<td><a href=\"editevent.php?url_userid={$url_userid}&url_eventid=". urlencode ($eventid['event_id']) . "\">". $eventid ['title'] . "</td>";
        echo"</tr></a>";
        }
   ?>
   </table>
    <br />
          <h2>YOUR PAST EVENTS</h2>       
    <table id="datetable" width="300" border="0" >
    <?php   
        $event_users_set = get_pasteventsforuser ($url_userid);
        while ($eventid = mysql_fetch_array ($event_users_set)){
        echo"<tr class=\'date\'>";
        echo"<td>" . $eventid["stdate"] ."</td>";   
        echo"<td><a href=\"editevent.php?url_userid={$url_userid}&url_eventid=". urlencode ($eventid['event_id']) . "\">". $eventid ['title'] . "</td>";
        echo"</tr></a>";
        }
   ?>
   </table>
    </div>
    <div id="admincontent">
    <span class="h1pln">Edit Your Event</span><a class="delete" href="deleteevent.php?url_eventid=<?php echo $url_eventid; ?>" onClick="return confirm('Are you sure you want to delete?')">Delete</a><br />
    <span class="h3pln">Please make sure you complete all the compulary fields<span class="compuls">*</span>.<br />
 The more accurately you enter your event the more people will be able to then find it.  <br />
<br />
If there are any selections we do not currently have available please click here and I will add them to your drop down menus.</span>
       <?php if (!empty($message)) {echo "<p class=\"message\">" . $message . "</p>";} ?>
      <?php if (!empty($errors)) { display_errors($errors); } ?>
<form id="newevent" action="editevent.php?url_eventid=<?php  echo urlencode ($selected_event ['event_id']); ?>" method="post">
      <table id="neweventdisplay" cellpadding="5" width="400" border="0">
   <tr>
  <td><input type="text" name="event_id"  value="<?php echo $url_eventid; ?>" /></td>
  <td><input type="text" name="user_id"  value="<?php echo $url_userid;  ?>" /></td>
  </tr>
  <tr>
    <td class="heading">Event Title</td>
    <td><input id="titleinput" name="title" type="text" value="<?php echo $selected_event ['title']; ?>" /><span class="compuls">*</span><span class="smalltext">Enter up to 36 characters</span></td>
  </tr>
  <tr>
  <td class="heading">Current Status</td>
  <td><?php echo   $statusdescrip ['status_description']; ?>
  <select name="status_id" >
    <?php
      $status_set = findstatus();
      $statuslist = mysql_fetch_assoc ($status_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $statuslist ['status_id']; ?>" ><?php echo $statuslist ['status_description']; ?></option>
   <?php
   } while ($statuslist = mysql_fetch_assoc ($status_set));
   ?></select>
    <span class="compuls">*</span></td>
  </tr>
      <tr>
    <td class="heading">Organiser</td>
    <td><?php echo  $orgdescrip ['org_name']; ?>
    <select name="org_id">
    <?php
      $organisers_set = findorganisers();
      $orglist = mysql_fetch_assoc ($organisers_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $orglist ['org_id']; ?>" ><?php echo $orglist ['org_name']; ?></option>
   <?php
   } while ($orglist = mysql_fetch_assoc ($organisers_set));
   ?></select></td>
  </tr>
    <tr>
    <td class="heading">Start Date</td>
    <td id="dateinput"><?php echo $selected_event ['stdate']; ?></td>
  </tr>
    <tr>
    <td class="heading">Type Of Event</td>
    <td><?php echo  $typedescrip ['type_description']; ?>
    <select name="type_id">
    <?php
      $type_set = findtype();
      $typelist = mysql_fetch_assoc ($type_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $typelist ['type_id']; ?>" ><?php echo $typelist ['type_description'], $typelist ['type_id']; ?></option>
   <?php
   } while ($typelist = mysql_fetch_assoc ($type_set));
   ?></select><span class="compuls">*</span></td>
  </tr>
  <tr>
    <td class="heading">Venue</td>
    <td><?php echo  $venuedescrip ['ven_name']; ?><select name="ven_id">
    <?php
      $venues_set = findvenues();
      $venuelist = mysql_fetch_assoc ($venues_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $venuelist ['ven_id']; ?>" ><?php echo $venuelist ['ven_name'], $venuelist ['ven_id']; ?></option>
   <?php
   } while ($venuelist = mysql_fetch_assoc ($venues_set));
   ?></select></td>
  </tr>

  <tr>
    <td class="heading">Discipline</td>
    <td><?php echo  $disdescrip ['dis_description']; ?><select name="dis_id">
    <?php
       $discipline_set = finddisciplines();
      $dislist = mysql_fetch_assoc ($discipline_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $dislist ['dis_id']; ?>" ><?php echo $dislist ['dis_description'], $dislist ['dis_id']; ?></option>
   <?php
   } while ($dislist = mysql_fetch_assoc ($discipline_set));
   ?></select><span class="compuls">*</span></td>
  </tr>
  <tr>
    <td class="heading">Level</td>
    <td><?php echo  $leveldescrip ['level_description']; ?> <select name="level_id">
    <?php
       $level_set = findlevels();
      $levellist = mysql_fetch_assoc ($level_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $levellist ['level_id']; ?>" ><?php echo $levellist ['level_description'], $levellist ['level_id']; ?></option>
   <?php
   } while ($levellist = mysql_fetch_assoc ($level_set));
   ?></select></td>
  </tr>
    <tr>
    <td class="heading">Is This A Championship</td>
    <td><?php echo  $champdescrip ['champ_description']; ?><select name="champ_id">
    <?php
      $championship_set = findchampionships();
      $champlist = mysql_fetch_assoc ($championship_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $champlist ['champ_id']; ?>" ><?php echo $champlist ['champ_description'], $champlist ['champ_id']; ?></option>
   <?php
   } while ($champlist = mysql_fetch_assoc ($championship_set));
   ?></select></td>
  </tr>
  <tr>
    <td class="heading">Event Details</td>
    <td><textarea name="event_details" cols="45" rows="15" ><?php echo $selected_event ['event_details']; ?>  </textarea></td>
  </tr>
  <tr>
    <td class="heading">Upload Schedule</td>
    <td></td>
  </tr>

  <tr>
  <td></td>
  <td><input type="submit" name="submit" id="convert" value="Update Your Event"></td>
  </tr>
</table>
<a  class="delete" href="controlpanel.php">Cancel</a>
</form>
    </div>
    <div id="adminright">
    </div>
<br clear="all" />
<?php require("includes/lowerlistings.inc.php"); ?>
<?php require("includes/footer.inc.php"); ?>
</div><!--End of Wrapper-->
</body>
</html>

ok so now all my logo link goes to the same page..i dont know how to fix it.i want all of them connect to a link(each of the company has their own company_link id) which i named company_link which is already in the database..so i need to call it.there are about 20 total logos..

except for the $company id=33..just remain that one..

Code: [Select]




<?
if(isset($_GET[ttid])) {
$ttid = $_GET[ttid];
}

$connection=mysql_connect("$server", "$username", "$password")
or die("Could not establish connection");
mysql_select_db($database_name, $connection)
or die ("Could not select database");


$query = "select master_event.* ,
(DATE_FORMAT(event_datefrom, '%d %M %Y')) as datefrom,
(DATE_FORMAT(event_dateto, '%d %M %Y')) as dateto,
ucase(event_name) as eventname
from master_event
where master_event.event_id = '$ttid '";
$result=mysql_query($query);
while($row = mysql_fetch_array($result)){
$eventname = $row['eventname'];
$eventdesc = $row['event_desc'];
$companydescription = $row['company_description'];
$eventvenue = $row['event_venue'];
$eventfee = $row['event_fee'];
$datefrom = $row['datefrom'];
$dateto = $row['dateto'];

echo "<font color='#000000'  face='arial' ><b> $eventname </b> </font> <br>";
echo "<font color='#000000'  face='arial' ><i>Date</i> : $datefrom - $dateto <br>";
echo "<i>Venue</i> : $eventvenue <br>";

$querypstype = "SELECT DISTINCT master_pstype.pstype_id,  pstype_desc FROM master_pstype
INNER JOIN master_psevent ON master_psevent.pstype_id= master_pstype.pstype_id
where master_psevent.event_id = '$ttid'
ORDER BY pstype_id";

$resultpstype=mysql_query($querypstype);
while($rowpstype = mysql_fetch_array($resultpstype)){
$pstypeid = $rowpstype['pstype_id'];
$pstypedesc = $rowpstype['pstype_desc'];
echo "<br><font color='#8B3A3A' size='1' face='georgia' ><b><i>$pstypedesc</i></b></font> <br>";

$queryps = "SELECT master_psevent.*, pstype_desc, company_name, company_link, company_description, logo_filename FROM master_psevent
LEFT JOIN master_pstype ON master_psevent.pstype_id = master_pstype.pstype_id
LEFT JOIN master_ps ON master_ps.ps_id = master_psevent.ps_id
WHERE master_psevent.event_id = '$ttid' and master_pstype.pstype_id= '$pstypeid'
ORDER BY pstype_desc,company_name ";

$resultps=mysql_query($queryps);
while($rowps = mysql_fetch_array($resultps)){
$companyname = $rowps['company_name'];
$companyid = $rowps['ps_id'];
$companylinkori = $rowps['company_link'];
$companydescription = $rowps['company_description'];

if ($companyid==33){

$companylink = "http://(confidential)/index.php?view=describe";

} else {
if ($companylinkori <> "") {
//$companylink = "http://".$rowps['company_link'];
$companylink = "http://(confidential)/index.php?view=".$companyid;
}
else
{
$companylink = "";
}
}


$logopath = $rowps['logo_filename'];

if ($companylink <> ""){
echo "<font color='#4A708B'  face='arial' ><a href=$companylink style=\"color:white;text-decoration: none; \" target='new'><img src=".$logo_dir."/".$logopath." width=\"15%\"></img></a>&nbsp&nbsp</font>";

}
else
{
echo "<font color='#4A708B'  face='arial' ><img src=".$logo_dir."/".$logopath." width=\"15%\"></img>&nbsp&nbsp</font>";
}
?>

<br>
<?

}
echo "<br>";

}

}



?>

Can someone help me debug this code...this is a search page where it searches the keyword typed in the mysql db and it limits 10 results per page...and at the bottom if there are more than 10 results it says next 10 and its a link but when it is clicked it goes to the code and says please type a search, here is the code can someone please help me with this I would really appreciate it.

Code: [Select]

<?php

$page = $PHP_SELF;
  // Get the search variable from URL

  $var = @$_GET['search'] ;
  $searchtype = @$_GET['searchtype'];
  $isbn = "ISBN";
  $school = "School";
  $title = "Title";
  $subject = "Subject";
 
  $trimmed = trim($var); //trim whitespace from the stored variable

// rows to return
$limit=10; 

// check for an empty string and display a message.
if ($trimmed == "")
  {
  echo "<p>Please enter a search...</p>";
  exit;
  }

// check for a search parameter
if (!isset($var))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }

//connect to your database
$connect = mysql_connect("","]",]") or die("Not connected");

//specify database 
mysql_select_db("collegebooxboox") or die("could not log in");

if ($searchtype == ($title))

{

// Build SQL Query  
$query = "select * from boox where name like \"%$trimmed%\"  
   order by name"; // EDIT HERE and specify your table and field names for the SQL query
}
elseif ($searchtype == ($school))
{
// Build SQL Query  
$query = "select * from boox where school like \"%$trimmed%\"  
   order by school"; // EDIT HERE and specify your table and field names for the SQL query

}
elseif ($searchtype == ($isbn))

{
// Build SQL Query  
$query = "select * from boox where isbn like \"%$trimmed%\"  
   order by isbn"; // EDIT HERE and specify your table and field names for the SQL query
 echo "isbn";

}
elseif ($searchtype == ($subject))

{
// Build SQL Query  
$query = "select * from boox where subject like \"%$trimmed%\"  
   order by subject"; // EDIT HERE and specify your table and field names for the SQL query

}
 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

// If we have no results, offer a google search as an alternative

if ($numrows == 0)
  {
  echo "<h4>Results</h4>";
  echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results</p>";

// google
 echo "<p><a href=\"http://www.google.com/search?q=" 
  . $trimmed . "\" target=\"_blank\" title=\"Look up 
  " . $trimmed . " on Google\">Click here</a> to try the 
  search on google</p>";
  }

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }

// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// display what the person searched for
echo "<p>You searched for: &quot;" . $var . "&quot; in &quot;" . $searchtype ."&quot; </p>";

// begin to show results set
echo "Results&nbsp;&nbsp;";
$count = 1 + $s ;

if ($searchtype = $title)

{
// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["name"];
  
  
   echo "$count.&nbsp;$title&nbsp;&nbsp
 </br><table width='297' border='1' align='center'>
  <tr>
    <td width='152'>Book Title:</td>
    <td width='129'>$row[name]</td>
  </tr>
  <tr>
    <td>Author:</td>
    <td>$row[author]</td>
  </tr>
    <tr>
    <td>ISBN#</td>
    <td>$row[isbn]</td>
  </tr>
  <tr>
    <td>Date Posted:</td>
    <td>$row[date]</td>
  </tr>
  <tr>
    <td>Posted By:</td>
    <td><a href='backpack.php' onclick='document['packback'].submit()'>$row[username]</a></td>
  </tr>
  <tr>
    <td>School:</td>
    <td>$row[school]</td>
  </tr>
</table></br>";
   $count++ ;
   }
}
elseif ($searchtype = $school)
{
// now you can display the results returned
while ($row= mysql_fetch_array($result)) {
  $title = $row["school"];
   echo "$count.&nbsp;$title" ;
   $count++ ;
   }
 
}
elseif ($searchtype = $subject)
{
// now you can display the results returned
while ($row= mysql_fetch_array($result)) {
  $title = $row["subject"];
 echo "$count.&nbsp;$title" ;
   $count++ ;
   }

}
elseif ($searchtype = $isbn)
{
// now you can display the results returned
while ($row= mysql_fetch_array($result)) {
  $title = $row["isbn"];
   echo "$count.&nbsp;$title" ;
   $count++ ;
   }

}



$currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($s>=1) { // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt; 
  Prev 10</a>&nbsp&nbsp;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }

// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$s+$limit;

  echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 &gt;&gt;</a>";
  }

$a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<p>Showing results $b to $a of $numrows</p>";
  
?>