PHP DBConnect::prepare方法代码示例

 public function ryp_insert($table, $rows = null, $header = null)
 {
     try {
         $sql = "INSERT INTO " . $table;
         $row = null;
         $value = null;
         foreach ($rows as $key => $nilainya) {
             # code...
             $row .= "," . $key;
             $value .= ", :" . $key;
         }
         $sql .= "(" . substr($row, 1) . ")";
         $sql .= "VALUES(" . substr($value, 1) . ")";
         $stmt = parent::prepare($sql);
         $stmt->execute($rows);
         $rowcount = $stmt->rowCount();
         if ($rowcount != 0) {
             echo "<script> alert('Simpan Data Sukses {$rowcount}');\n\t\twindow.location.assign('{$header}');</script>";
         } else {
             echo "<script> alert('Simpan Data Error, Data Sudah Ada {$rowcount}'); </script>";
         }
         if ($header != null) {
             //session_start();
             //$_SESSION['pesan']="SIMPAN DATA TABEL $table SUKSES";
             header("location:" . $header);
         }
         return $rowcount;
     } catch (PDOException $e) {
         echo "<script> alert('Simpan Data Gagal'); </script>";
     }
 }

 public function CropAndCreate($fileName, $top, $left, $publicCanvasWidth, $publicCanvasHeight)
 {
     //set basic variables
     //$newFileName is using the set index e.g. [index]jacobclausen_[timestamp]1785645465.jpg
     $newFileName = $this->fileNameIndex . time() . '.jpg';
     //make sure we actually have a the temporarily uploaded file to work with
     if ($fileName != '' && substr($fileName, 0, 3) == 'tmp') {
         //even if its unlikely... let's check if we have a file with this exact name since earlier.
         if (file_exists($this->outputPath . $newFileName)) {
             unlink($this->outputPath . $newFileName);
         }
         //chmod the file to ensure working conditions with it
         chmod($this->tmpPath . $fileName, 0755);
         //get the original file dimensions
         list($width, $height) = getimagesize($this->tmpPath . $fileName);
         //create the canvas
         $imageCanvas = imagecreatetruecolor($this->canvasWidth, $this->canvasHeight);
         //set the custom background color in case of "white space" in the new image
         $backgroundColor = imagecolorallocate($imageCanvas, $this->canvasBG[0], $this->canvasBG[1], $this->canvasBG[2]);
         imagefill($imageCanvas, 0, 0, $backgroundColor);
         $image = imagecreatefromjpeg($this->tmpPath . $fileName);
         //top and left margins accurate
         $newTop = $top * ($this->canvasHeight / $publicCanvasHeight);
         $newLeft = $left * ($this->canvasWidth / $publicCanvasWidth);
         //make adjustments to our image
         if ($this->imageCrop == 1) {
             imagecopyresampled($imageCanvas, $image, $newLeft, $newTop, 0, 0, $width, $height, $width, $height);
         } elseif ($this->imageCrop == 2) {
             //calculate the new height and keep the image proportinal
             $newHeight = $height * ($this->canvasWidth / $width);
             imagecopyresampled($imageCanvas, $image, $newLeft, $newTop, 0, 0, $this->canvasWidth, $newHeight, $width, $height);
         } elseif ($this->imageCrop == 3) {
             //calculate the new width and keep the image proportinal
             $newWidth = $width * ($this->canvasHeight / $height);
             imagecopyresampled($imageCanvas, $image, $newLeft, $newTop, 0, 0, $newWidth, $this->canvasHeight, $width, $height);
         }
         //finally create the image
         if (imagejpeg($imageCanvas, $this->outputPath . $newFileName, $this->quality)) {
             //check if this image should be added to the database
             if ($this->addToDB === true) {
                 $con = new DBConnect();
                 try {
                     $stmt = $con->prepare('INSERT INTO images(image_name) VALUES(?)');
                     $stmt->execute(array($newFileName));
                 } catch (PDOException $e) {
                     $this->output = $e;
                 }
             }
             //return the filename
             return $newFileName;
             //finally remove the temporarily image
             unlink($this->tmpPath . $fileName);
         }
     }
 }