public static function checkIfIPIsTaken($ip) { if (MySql::returnSingleValue("SELECT COUNT( ContactID ) FROM tblContact WHERE tblContact.CompanyName = :ip", ['ip' => $ip])) { return false; } return true; }
protected function afterSave() { parent::afterSave(); if ($this->Order == null && $this->GalleryID != 0) { $this->Order = intval(MySql::returnSingleValue("SELECT tblImage.Order FROM tblImage WHERE GalleryID = " . intval($this->GalleryID) . " ORDER BY tblImage.Order DESC LIMIT 1")) + 1; $this->save(); } }
public function getDefaultImage() { if ($this->DefaultImageID && $this->DefaultImageID !== 0) { $id = $this->DefaultImageID; } else { $id = MySql::returnSingleValue("SELECT ImageID FROM tblImage WHERE GalleryID = :GalleryID ORDER BY tblImage.Order ", ["GalleryID" => $this->GalleryID]); } try { return (new Image($id))->GetResizedImage(1); } catch (RecordNotFoundException $ex) { return '/static/images/no-thumb.png'; } }
public function testSingleResultCanBeFetched() { $value = MySql::returnSingleValue("SELECT :number", ["number" => 5]); $this->assertEquals(5, $value); }
protected function printViewContent() { $user = CustomLoginProvider::getLoggedInUser(); $firstImg = 0; ?> <div class="__container" style="padding-bottom: 10px"> <?php parent::printViewContent(); ?> <div class="gallery-collection-images"> <ul> <?php $counter = 0; foreach ($this->images as $image) { if ($firstImg === 0) { $firstImg = $image->ImageID; } $class = $counter === 0 ? 'selected' : ''; $commentNums = MySql::returnSingleValue("SELECT COUNT( CommentID ) FROM tblComment WHERE ImageID = '" . $image->ImageID . "'"); $commentNums = $commentNums == 1 ? $commentNums . " komentārs" : $commentNums . " komentāri"; print '<li class="thumbnail-image-container"> <a href="#' . $counter . '"> <img id="img' . $counter . '" class="thumbnail-image img-thumbnail ' . $class . '" thumb="' . $counter . '" imgID="' . $image->ImageID . '" src="' . $image->GetResizedImage(1) . '"> </a> <span>' . $commentNums . ' </span> </li>'; $counter++; } ?> </ul> </div> </div> <div class="row"> <div class="__container"> <div class="row"> <div class="col-xs-6 center-align"> <a href="/img/?g=<?php echo $this->images[0]->ImageID; ?> " id="downloadButton" ><i class="fa fa-download"></i> Lejuplādēt </a> </div> <div class="col-xs-6 center-align"> <a href="#" class="" data-toggle="modal" data-target="#myModal"><i class="fa fa-upload"></i> Pievienot bilde(s)</a> </div> <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button> <h4 class="modal-title" id="myModalLabel">Pievienot bildes galerijai</h4> </div> <div id="dropzone"> <div action="/portal/gallery/<?php echo $this->images[0]->GalleryID; ?> /?a=<?php echo $this->images[0]->GalleryID; ?> " class="dropzone" id="image-upload"> <div class="dz-message">Bildes parādisies šeit<br /> </div> </div> </div> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">Close</button> <button type="button" class="btn btn-primary" data-dismiss="modal" id="save-mode-button">Saglabāt!</button> </div> </div> </div> </div> </div> </div> <div class="comments-bound __container" style="min-height: 46px;"> <?php self::getCommentsForImageID($this->images[0]->ImageID); ?> </div> <div class="comments-section-new __container"> <div class="comment-outer-image"> <img src="<?php echo $user->Image; ?> "> </div> <textarea id="comment-input"></textarea> <button type="submit" id="comment-input-submit">Pievienot</button> <div class="__clear-floats"></div> </div> </div> <?php }