Learn VBA & Macros in 1 Week!

PHP - Saving Watermarked Image

Full Excel VBA Course - Beginner to Expert

Saving Watermarked Image	View Content

Hi Guys,

Using this code i am able to overlay a logo onto an image:

<?php
   // Load the image where the logo will be embeded into
   $image = imagecreatefromjpeg("box.jpg");

   // Load the logo image
   $logoImage = imagecreatefrompng("logo.png");
   imagealphablending($logoImage, true);

   // Get dimensions
   $imageWidth=imagesx($image);
   $imageHeight=imagesy($image);

   $logoWidth=imagesx($logoImage);
   $logoHeight=imagesy($logoImage);

   // Paste the logo
   imagecopy(
      // source
      $image,
      // destination
      $logoImage,
      // destination x and y
      $imageWidth-$logoWidth, $imageHeight-$logoHeight,
      // source x and y
      0, 0,
      // width and height of the area of the source to copy
      $logoWidth, $logoHeight);

   // Set type of image and send the output
   //header("Content-type: image/png");
   //imagePng($image);
   imagejpeg($logoImage, "imageWithLogo.jpg", 100);

   // Release memory
   imageDestroy($image);
   imageDestroy($imageLogo);
?>

this part:

//header("Content-type: image/png");
//imagePng($image);

shows me the complete image with the logo ontop, what i'm having trouble with is saving the image.

any help would be appreciated

thanks guys

Graham

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Uploading Watermarked Resized Image Into Mysql.

Saving Image To Certain Directory

Saving Image Resource Onto Subdirectory

Issue With Saving Uploaded Image Twice

Php - Saving Image To Mysql As Blob Issues

When You Click On Thumbnail I Want Image To Start Downloading (saving To Pc)

Saving As A .xml

Saving Operators From Url

Not Saving To Table

Save() Not Saving

Saving Checkboxes

Saving Webpage As Pdf

How To Saving Php Table To Sql

Charset Problem When Saving To My Db

Saving Into An Html File

Saving To A Sql Database Using Php And Wamp

Saving Images Created On-the-fly

Saving / Update Indication... How Do You Do It?

Learn VBA & Macros for Excel in 1 Week!

Uploading Watermarked Resized Image Into Mysql.

Similar Tutorials

hi everyone im new to php. I have been reading few books. im trying to build a image gallery. the first step is to upload a images. in the process of uploading, i want to resize the image then add watermark last insert into the database which is mysql, (i know about the dont insert image into database thing).

here is the form script

Code: [Select]

<?php
    require_once('globals.php');
?>
<html>
<head>
<title>Upload an Image</title>
</head>
<body>
<div>
<h1>Upload an Image</h1>

<p>
<a href="./">View uploaded images</a>
</p>

<form method="post" action="process.php" enctype="multipart/form-data">
<div>
<input type="file" name="image" />
<input type="submit" value="Upload Image" />
</div>
</form>
</div>



</body>
</html>

here is the watermark script

Code: [Select]

<?php
    require_once('globals.php');
?>
<html>
<head>
<title>Upload an Image</title>
</head>
<body>
<div>
<h1>Upload an Image</h1>

<p>
<a href="./">View uploaded images</a>
</p>

<form method="post" action="process.php" enctype="multipart/form-data">
<div>
<input type="file" name="image" />
<input type="submit" value="Upload Image" />
</div>
</form>
</div>



</body>
</html>

here is my resize script

Code: [Select]

<?php

   # ========================================================================#
   #
   #  Author:    Jarrod Oberto
   #  Version: 1.0
   #  Date:      17-Jan-10
   #  Purpose:   Resizes and saves image
   #  Requires : Requires PHP5, GD library.
   #  Usage Example:
   #                     include("classes/resize_class.php");
   #                     $resizeObj = new resize('images/cars/large/input.jpg');
   #                     $resizeObj -> resizeImage(150, 100, 0);
   #                     $resizeObj -> saveImage('images/cars/large/output.jpg', 100);
   #
   #
   # ========================================================================#

Class resize
{
// *** Class variables
private $image;
    private $width;
    private $height;
private $imageResized;

function __construct($fileName)
{
// *** Open up the file
$this->image = $this->openImage($fileName);

    // *** Get width and height
    $this->width  = imagesx($this->image);
    $this->height = imagesy($this->image);
}

## --------------------------------------------------------

private function openImage($file)
{
// *** Get extension
$extension = strtolower(strrchr($file, '.'));

switch($extension)
{
case '.jpg':
case '.jpeg':
$img = @imagecreatefromjpeg($file);
break;
case '.gif':
$img = @imagecreatefromgif($file);
break;
case '.png':
$img = @imagecreatefrompng($file);
break;
default:
$img = false;
break;
}
return $img;
}

## --------------------------------------------------------

public function resizeImage($newWidth, $newHeight, $option="auto")
{
// *** Get optimal width and height - based on $option
$optionArray = $this->getDimensions($newWidth, $newHeight, $option);

$optimalWidth  = $optionArray['optimalWidth'];
$optimalHeight = $optionArray['optimalHeight'];

// *** Resample - create image canvas of x, y size
$this->imageResized = imagecreatetruecolor($optimalWidth, $optimalHeight);
imagecopyresampled($this->imageResized, $this->image, 0, 0, 0, 0, $optimalWidth, $optimalHeight, $this->width, $this->height);

// *** if option is 'crop', then crop too
if ($option == 'crop') {
$this->crop($optimalWidth, $optimalHeight, $newWidth, $newHeight);
}
}

## --------------------------------------------------------

private function getDimensions($newWidth, $newHeight, $option)
{

   switch ($option)
{
case 'exact':
$optimalWidth = $newWidth;
$optimalHeight= $newHeight;
break;
case 'portrait':
$optimalWidth = $this->getSizeByFixedHeight($newHeight);
$optimalHeight= $newHeight;
break;
case 'landscape':
$optimalWidth = $newWidth;
$optimalHeight= $this->getSizeByFixedWidth($newWidth);
break;
case 'auto':
$optionArray = $this->getSizeByAuto($newWidth, $newHeight);
$optimalWidth = $optionArray['optimalWidth'];
$optimalHeight = $optionArray['optimalHeight'];
break;
case 'crop':
$optionArray = $this->getOptimalCrop($newWidth, $newHeight);
$optimalWidth = $optionArray['optimalWidth'];
$optimalHeight = $optionArray['optimalHeight'];
break;
}
return array('optimalWidth' => $optimalWidth, 'optimalHeight' => $optimalHeight);
}

## --------------------------------------------------------

private function getSizeByFixedHeight($newHeight)
{
$ratio = $this->width / $this->height;
$newWidth = $newHeight * $ratio;
return $newWidth;
}

private function getSizeByFixedWidth($newWidth)
{
$ratio = $this->height / $this->width;
$newHeight = $newWidth * $ratio;
return $newHeight;
}

private function getSizeByAuto($newWidth, $newHeight)
{
if ($this->height < $this->width)
// *** Image to be resized is wider (landscape)
{
$optimalWidth = $newWidth;
$optimalHeight= $this->getSizeByFixedWidth($newWidth);
}
elseif ($this->height > $this->width)
// *** Image to be resized is taller (portrait)
{
$optimalWidth = $this->getSizeByFixedHeight($newHeight);
$optimalHeight= $newHeight;
}
else
// *** Image to be resizerd is a square
{
if ($newHeight < $newWidth) {
$optimalWidth = $newWidth;
$optimalHeight= $this->getSizeByFixedWidth($newWidth);
} else if ($newHeight > $newWidth) {
$optimalWidth = $this->getSizeByFixedHeight($newHeight);
$optimalHeight= $newHeight;
} else {
// *** Sqaure being resized to a square
$optimalWidth = $newWidth;
$optimalHeight= $newHeight;
}
}

return array('optimalWidth' => $optimalWidth, 'optimalHeight' => $optimalHeight);
}

## --------------------------------------------------------

private function getOptimalCrop($newWidth, $newHeight)
{

$heightRatio = $this->height / $newHeight;
$widthRatio  = $this->width /  $newWidth;

if ($heightRatio < $widthRatio) {
$optimalRatio = $heightRatio;
} else {
$optimalRatio = $widthRatio;
}

$optimalHeight = $this->height / $optimalRatio;
$optimalWidth  = $this->width  / $optimalRatio;

return array('optimalWidth' => $optimalWidth, 'optimalHeight' => $optimalHeight);
}

## --------------------------------------------------------

private function crop($optimalWidth, $optimalHeight, $newWidth, $newHeight)
{
// *** Find center - this will be used for the crop
$cropStartX = ( $optimalWidth / 2) - ( $newWidth /2 );
$cropStartY = ( $optimalHeight/ 2) - ( $newHeight/2 );

$crop = $this->imageResized;
//imagedestroy($this->imageResized);

// *** Now crop from center to exact requested size
$this->imageResized = imagecreatetruecolor($newWidth , $newHeight);
imagecopyresampled($this->imageResized, $crop , 0, 0, $cropStartX, $cropStartY, $newWidth, $newHeight , $newWidth, $newHeight);
}

## --------------------------------------------------------

public function saveImage($savePath, $imageQuality="100")
{
// *** Get extension
         $extension = strrchr($savePath, '.');
        $extension = strtolower($extension);

switch($extension)
{
case '.jpg':
case '.jpeg':
if (imagetypes() & IMG_JPG) {
imagejpeg($this->imageResized, $savePath, $imageQuality);
}
break;

case '.gif':
if (imagetypes() & IMG_GIF) {
imagegif($this->imageResized, $savePath);
}
break;

case '.png':
// *** Scale quality from 0-100 to 0-9
$scaleQuality = round(($imageQuality/100) * 9);

// *** Invert quality setting as 0 is best, not 9
$invertScaleQuality = 9 - $scaleQuality;

if (imagetypes() & IMG_PNG) {
imagepng($this->imageResized, $savePath, $invertScaleQuality);
}
break;

// ... etc

default:
// *** No extension - No save.
break;
}

imagedestroy($this->imageResized);
}

## --------------------------------------------------------

}
?>

here is the insert database script

Code: [Select]

<?php
    require_once('globals.php');

    function assertValidUpload($code)
    {
        if ($code == UPLOAD_ERR_OK) {
            return;
        }

        switch ($code) {
            case UPLOAD_ERR_INI_SIZE:
            case UPLOAD_ERR_FORM_SIZE:
                $msg = 'Image is too large';
                break;

            case UPLOAD_ERR_PARTIAL:
                $msg = 'Image was only partially uploaded';
                break;

            case UPLOAD_ERR_NO_FILE:
                $msg = 'No image was uploaded';
                break;

            case UPLOAD_ERR_NO_TMP_DIR:
                $msg = 'Upload folder not found';
                break;

            case UPLOAD_ERR_CANT_WRITE:
                $msg = 'Unable to write uploaded file';
                break;

            case UPLOAD_ERR_EXTENSION:
                $msg = 'Upload failed due to extension';
                break;

            default:
                $msg = 'Unknown error';
        }

        throw new Exception($msg);
    }

    $errors = array();

    try {
        if (!array_key_exists('image', $_FILES)) {
            throw new Exception('Image not found in uploaded data');
        }

        $image = $_FILES['image'];

        // ensure the file was successfully uploaded
        assertValidUpload($image['error']);

        if (!is_uploaded_file($image['tmp_name'])) {
            throw new Exception('File is not an uploaded file');
        }

        $info = getImageSize($image['tmp_name']);

        if (!$info) {
            throw new Exception('File is not an image');
        }
    }
    catch (Exception $ex) {
        $errors[] = $ex->getMessage();
    }

    if (count($errors) == 0) {
        // no errors, so insert the image

        $query = sprintf(
            "insert into images (filename, mime_type, file_size, file_data)
                values ('%s', '%s', %d, '%s')",
            mysql_real_escape_string($image['name']),
            mysql_real_escape_string($info['mime']),
            $image['size'],
            mysql_real_escape_string(
                file_get_contents($image['tmp_name'])
            )
        );

        mysql_query($query, $db);

        $id = (int) mysql_insert_id($db);

        // finally, redirect the user to view the new image
        header('Location: view.php?id=' . $id);
        exit;
    }
?>
<html>
<head>
<title>Error</title>
</head>
<body>
<div>
<p>
The following errors occurred:
</p>

<ul>
<?php foreach ($errors as $error) { ?>
<li>
<?php echo htmlSpecialChars($error) ?>
</li>
<?php } ?>
</ul>

<p>
<a href="upload.php">Try again</a>
</p>
</div>
</body>
</html>

here is my view script

Code: [Select]

<?php
    require_once('globals.php');

    try {
        if (!isset($_GET['id'])) {
            throw new Exception('ID not specified');
        }

        $id = (int) $_GET['id'];

        if ($id <= 0) {
            throw new Exception('Invalid ID specified');
        }

        $query  = sprintf('select * from images where image_id = %d', $id);
        $result = mysql_query($query, $db);

        if (mysql_num_rows($result) == 0) {
            throw new Exception('Image with specified ID not found');
        }

        $image = mysql_fetch_array($result);
    }
    catch (Exception $ex) {
        header('HTTP/1.0 404 Not Found');
        exit;
    }

    header('Content-type: ' . $image['mime_type']);
    header('Content-length: ' . $image['file_size']);

    echo $image['file_data'];
?>

my main question is how to link them all together.

any clues i appreciatte

Saving Image

Similar Tutorials

Hi

I'm really new to php and could really do with some help.

I am using the following script

http://test.dpetroff.ru/jquery.iviewer.test/test/

which basically allows me to position an image within a DIV area

My question is, how can I get PHP to save just the image within the DIV area, so it's almost acting like a crop tool

I've tried a few things but so far not managed to get anything working

Saving Image To Certain Directory

Similar Tutorials

Hello dear,

I'm willing to use thumbnails into my website which is mainly like websites directory. I've been thinking to save url thumbnails into certain directory !

If i've index.php with the following image code (this would show thumbnail image of the website ANY_SITE.COM

Code: [Select]
<img src='http://thumbnails_provider.com/url=ANY_SITE.COM'/>

then how to save the generated image into certain directory like

my_site.com/thumbnails

i've been thinking about Using cURL but i don't know how to apply it

any help ~thanks

Saving Image Resource Onto Subdirectory

Similar Tutorials

Hey.

I'm just wondering what would be the most logical or most efficient way to save an image resource that has been constructed on say the www. to a subdirectory or on another webserver?

For eg

The script on www.example.com constructs an image using the GD library from image1.png and image2.png.
It has now got the final image resource for what's been constructed.

I now want to save this image onto images.example.com

How would you suggest?

Issue With Saving Uploaded Image Twice

Similar Tutorials

Hello. I'm using an Amazon S3 class to uploaded to S3. I have 2 upload boxes - The first uploads once and the second needs to upload twice - 1 full size, 1 thumb.

The issue i'm having is that the 2nd image (the thumb) seems to be failing, although if I don't save the first full sized image I am able to upload the thumb. So I think the issue is with using the temp file twice?

This is my code:

//retreive post variables

$fileName = $randomString . "_" . $_FILES['theFile']['name'];

$fileTempName = $_FILES['theFile']['tmp_name'];

$fileName2 = $randomString . "_" . $_FILES['theFile2']['name'];

$fileTempName2 = $_FILES['theFile2']['tmp_name'];

//move the file

if ($s3->putObjectFile($fileTempName, "containerhere", $fileName, S3::ACL_PUBLIC_READ)) {

echo "<strong>Uploaded Image</strong>";

}else{

echo "<strong>Something went wrong while uploading your file... sorry.</strong>";

}

//move the file

if ($s3->putObjectFile($fileTempName2, "containerhere", $fileName2, S3::ACL_PUBLIC_READ)) {

echo "<strong>Uploaded Image</strong>";

}else{

echo "<strong>Something went wrong while uploading your file... sorry.</strong>";

}

include('simpleImage.php');

$image = new SimpleImage();

$image->load($_FILES['theFile2']['tmp_name']);

$image->resizeToWidth(100);

$image->save($_FILES['theFile2']['tmp_name']);

$fileName3 = $randomString . "_" . $_FILES['theFile2']['name'];

$fileTempName3 = $_FILES['theFile2']['tmp_name'];

//move the file

if ($s3->putObjectFile($fileTempName3, "containerhere", "thumbs/" . $fileName3, S3::ACL_PUBLIC_READ)) {

echo "<strong>Uploaded Image</strong>";

}else{

echo "<strong>Something went wrong while uploading your file... sorry.</strong>";

}

Can anyone offer any advice?

Thanks.

Php - Saving Image To Mysql As Blob Issues

Similar Tutorials

Hi All,

This is my first post on here. I'd really appreciate any help with this, it's driving me mad.

I'm trying to create a form to save a image into a mySQL database.

I have a website hosted by UK2.net which has a mysql db with a table called gallery(name (varchar 30), size (int), type varchar(30), thePic(mediumBlob)).

I have a form with this:

Code: [Select]
<td><p><label>Pic: </label></td><td><input name="userfile" type="file" id="userfile" /></td></p>
Which when submitted actions addImage.php. The code for this looks like this:

Code: [Select]
<?php

$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];

$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
    $fileName = addslashes($fileName);
}

$con = mysql_connect("localhost", "userName", "password") or die(mysql_error());

mysql_select_db("dbName", $con) or die(mysql_error());

$query = "INSERT INTO gallery (name, size, type, thePic) ".
"VALUES ('$fileName', '$fileSize', '$fileType', '$content')";

if (!mysql_query($query,$con))
  {
  die('Error: ' . mysql_error());
  }

echo "<br>File $fileName uploaded<br>";

?>
I get the following error message:

Quote

Warning: fopen() [function.fopen]: Filename cannot be empty in /home/hiddenje/public_html/addImage.php on line 13

Does anyone know what this is about? I've been on out friend google and a lot of people seem to be pointing to permissions but I can't seem to apply it to my scenario and just can't get it to work. Im a developer by trade, but this is my first step into the...interesting world of PHP and mySQL.

Again, I'd appreciate any help with this. I'd love someone to talk me through exactly what I'm missing or doing wrong.

Thanks in advance.

When You Click On Thumbnail I Want Image To Start Downloading (saving To Pc)

Similar Tutorials

I am working on a simple gallery. I want to have an option to download full scale image without users having to right click and "save as". Using this code you get a image preview:

<a href="pictures/img-(1).jpg"><img src="thumbnails/img-(1).jpg"></a>

How can I modify it so when user clicks on thumbnail of image 1 it will prompt him to save the image instead of viewing it.

Thanks

Saving Ram

Similar Tutorials

i have made 2 classes.

the first "point" has an array of 3 floats and some functions to help manipulate the values
the second "triangle" has an array of 3 points.

in this way if i want to make a tetrahedron i can make 4 points and assign them to 4 triangles.

problem is for some reason each triangle point group seems to use 1k. any idea why?

Saving As A .xml

Similar Tutorials

I have a .php code that gets data from a database and saves it in a variables as xml. However how can I then save all of the data in this variable as a .xml file somewhere?

Thanks for any help.

Saving Operators From Url

Similar Tutorials

I'm trying to get an equation from a user that types it in the url, ex) 1+2+3. I can get the 1,2,3 fine, but the + operator is no longer in the string. Same with the * and / operators. Is there a way to keep them as a string using $_GET?

Not Saving To Table

Similar Tutorials

Am trying to update a table called "budget_request" and also inserting the data of that table into another table called "Budget". The Update works but it is not inserting into the other table. please help me out.. check my code below <?php
$id = $_GET['id'];
?>
<?php

include('mysql_connect.php');

$q = mysql_query("UPDATE budget_request SET status = 'Approved' WHERE id = '$id'") or die(mysql_error());

// send the details to the budget database

$query = mysql_query("SELECT * FROM budget_request WHERE id = '$id' ") or die (mysql_error());
   $dat = mysql_fetch_array($query);

   $department = $dat['department'];
   $amount = $dat['amount'];

   // Add the data to the Budget DB

   $que = (" INSERT INTO budget (id, department, amount, actual) VALUES ( ' ','$department', '$amount', '$amount')" ) or die(mysql_error());

header("Location: add_budget.php");

?>

Save() Not Saving

Similar Tutorials

                  $new_relation->save();
                  echo "after save".$requestor_profile->getId()." ".$requestee_profile->getId();
                  return true;

               }catch(PropelException $e)
               {
echo "in die";
                  die($e);
                  return false;
               }
          }//end - if (!$res)
[/PHP]

the echo after the save executes but when i look in my db table there is nothing????
please help???

Saving Checkboxes

Similar Tutorials

Hi,
I'm completely new to anything that is not html but I'm wondering if in something like php I can get a checkbox to permanently save through reloads and different machines. My idea was just to have a page with only a checkbox on it, and then load that through and iframe in html. If anybody could give me the code for that checkbox page (complete if possible as I don't really know anything about that type of programming) I would be very grateful.
Thank You

Saving Webpage As Pdf

Similar Tutorials

Hi All...

I am looking for a way of saving currently open webpage as a pdf file.........I searched for that and even gone for this site http://www.tcpdf.org. But there also I didn't find any perfect way of doing this all....If somebody else has tried tcpdf for that or done something like that, then plzzzzz plzzz plzzzz do help me....Thanx......

How To Saving Php Table To Sql

Similar Tutorials

I have problem how to saving all my record. when I save I just got 1 record saved in mySQL and it the last record on that table. Here is my code =


<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO thasil (nrp, nama, pangkat, mgolongan, mtes_fisik, mkemampuan, hasil) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['nrp'], "int"),
                       GetSQLValueString($_POST['nama'], "text"),
                       GetSQLValueString($_POST['pangkat'], "text"),
                       GetSQLValueString($_POST['mgolongan'], "int"),
                       GetSQLValueString($_POST['mtes_fisik'], "double"),
                       GetSQLValueString($_POST['mkemampuan'], "double"),
                       GetSQLValueString($_POST['hasil'], "double"));

  mysql_select_db($database_stok, $stok);
  $Result1 = mysql_query($insertSQL, $stok) or die(mysql_error());

  $insertGoTo = "";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_stok, $stok);
$query_anggotaset = "SELECT * FROM tanggota ORDER BY nrp ASC";
$anggotaset = mysql_query($query_anggotaset, $stok) or die(mysql_error());
$row_anggotaset = mysql_fetch_assoc($anggotaset);
$totalRows_anggotaset = mysql_num_rows($anggotaset);

mysql_select_db($database_stok, $stok);
$query_bobotset = "SELECT * FROM tbobot";
$bobotset = mysql_query($query_bobotset, $stok) or die(mysql_error());
$row_bobotset = mysql_fetch_assoc($bobotset);
$totalRows_bobotset = mysql_num_rows($bobotset);

$crMax = mysql_query("SELECT min(Golongan) as minK1, 
max(tes_fisik) as maxK2,
max(kemampuan) as maxK3
FROM tanggota");
$max = mysql_fetch_array($crMax);

$no=1;



?>


<?php include ('header.php') ?>

<div id="conten-wrapper">
<div id="conten">
<h1> Normalisasi Anggota Kesamaptaan </h1>
<p> <a href="cetak.php"><img src="../images/btn_list.png" height="20"/> >>> Lihat & Cetak Hasil Akhir Perangkingan</a></p>
<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
<table border="1" cellpadding="3" cellspacing="1">
  <tr>
  <td>no</td>
    <td>nrp</td>
    <td>nama</td>
    <td>pangkat</td>
    <td>C1 Golongan</td>
    <td>C2 tes_fisik</td>
    <td>C3 kemampuan</td>
     <td>hasil</td>
    
    </tr>
  <?php 
  
  do { 
  $hasil= round (($max['minK1']/$row_anggotaset['Golongan']*$row_bobotset['golongan']+
 $row_anggotaset['tes_fisik']/$max['maxK2']*$row_bobotset['tes_fisik']+
 $row_anggotaset['kemampuan']/$max['maxK3']*$row_bobotset['kemampuan']),2) ;
?>
  
    <tr>
    <td><?php echo $no; $no++;?></td>
      <td><input type="text" name="nrp" value="<?php echo $row_anggotaset['nrp']; ?>"  readonly/></td>
      <td><input type="text" name="nama" value="<?php echo $row_anggotaset['nama']; ?>"  readonly/></td>
       <td><input type="text" name="pangkat" value="<?php echo $row_anggotaset['pangkat']; ?>" size="4" readonly/></td>
      <td><input type="text" name="mgolongan" value="<?php echo round ($max['minK1']/$row_anggotaset['Golongan']
 *$row_bobotset['golongan'],2); ?>" size="2" readonly/></td>
      <td><input type="text" name="mtes_fisik" value="<?php echo round ($row_anggotaset['tes_fisik']/$max['maxK2']
 *$row_bobotset['tes_fisik'],2); ?>" size="2" readonly/></td>
       <td><input type="text" name="mkemampuan" value="<?php echo round ($row_anggotaset['kemampuan']/$max['maxK3']
  *$row_bobotset['kemampuan'],2); ?>" size="3" readonly/></td>
       <td><input type="text" name="hasil" value="<?php echo $hasil ?>" size="2" readonly/></td>
      </tr>
      
    <?php } while ($row_anggotaset = mysql_fetch_assoc($anggotaset));?>
    <tr valign="baseline">
      <td colspan="8" align="right" nowrap="nowrap"><input type="submit" value="Insert record" /></td>
      </tr>
</table>
<input type="hidden" name="MM_insert" value="form1" />
</form>
</div>


<?php include ('footer.php') ?>



</body>
</html>
<?php
mysql_free_result($anggotaset);

mysql_free_result($bobotset);
?>

Charset Problem When Saving To My Db

Similar Tutorials

Saving Into An Html File

Similar Tutorials

Hi guys,

Sorry if this is too dumb, I'm a student yet ..

I have:
$newEmail = preg_replace($patterns, $replacements, $email);

How can I save $newEmail contents into an html file?

Thanks a lot!!

Saving To A Sql Database Using Php And Wamp

Similar Tutorials

Hi guys

Im looking to save the contents of 4 textboxes to a mySql db. Using wamp, phpmyadmin etc.

Code: [Select]
?php
$Name = $_Post('Name');
$Age = $_Post('Age');
$Sex = $_Post('Sex');
$Address_1 = $_Post('Address_1');

mysql_connect("127.0.0.1","user","") or die ('Error: ' .mysql_error());
mysql_select_db("user");

$query ="INSERT INTO users(Name,Age,Sex,Address_1) VALUES('".$Name."', '".$Age."','".$Sex."','".$Address_1."');

mysql_query($query) or die ('Error updating datadase');
mysql_Close();

?>This is the code im using, it dosent seem to do anything to the database..... can someone point out where im going wrong... thanks

Saving Images Created On-the-fly

Similar Tutorials

How can I save an image created on-the-fly on the server? For example,

$img = "<img src=ChessImager/ChessImager.php?ds_color=(176,144,112)&ls_color=(224,200,160)&coordinates=on&square_size=$square_size&fen=" . urlencode($fen) . ">";

I can display the diagram, but I want to save these images with PHP.

Saving / Update Indication... How Do You Do It?

Similar Tutorials

Hi guys,

Right now, I just save / update the database and refresh the page. I'd like to do all of that, but have a nice looking 'Save / Update' indication - indicator.

How do you guys do it? Do you have any recommendations?

Thanks