Reply to thread

Message

<blockquote data-quote="lkzombie" data-source="post: 20509911" data-attributes="member: 462352">Solved!!!! udaw karapu hamatama sthuthiy
<img src="http://ayushflowergiftsportal.com/product_images/fa9bb2bd9c83db58e2bc13f59eb74754mixed-roses-and-lilly-bunch-500x500.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" />[PHP]&lt;?php/** &nbsp;* ------------------------------------------------------------------&nbsp;* Author&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; :&nbsp;&nbsp; Sumal T.Jayaranga&nbsp;* Date Created&nbsp; &nbsp;&nbsp; :&nbsp;&nbsp; 2016-07-01&nbsp;* Last Modified&nbsp; &nbsp; :&nbsp;* Brief&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; :&nbsp;* ------------------------------------------------------------------**/include_once get_include_path().'cls/database/cls_dbconnection.php';include_once get_include_path().'cls/misc/cls_images.php';include_once get_include_path().'cls/misc/cls_session.php';include_once get_include_path().'cls/business/cls_users.php';class _ads{&nbsp; &nbsp; public $_adid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; = &quot;&quot;;&nbsp; &nbsp; public $_userid&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; = &quot;&quot;;&nbsp; &nbsp; public $_subcatid&nbsp; &nbsp; &nbsp;&nbsp; = &quot;&quot;;&nbsp; &nbsp; public $_typeid&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; = &quot;&quot;;&nbsp; &nbsp; public $_title&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = &quot;&quot;;&nbsp; &nbsp; public $_description&nbsp; &nbsp; = &quot;&quot;;&nbsp; &nbsp; public $_price&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = &quot;&quot;;&nbsp; &nbsp; public $_city&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; = &quot;&quot;;&nbsp; &nbsp; public $_pictures&nbsp; &nbsp; &nbsp;&nbsp; = null;&nbsp; &nbsp; &nbsp; &nbsp; public $_message&nbsp; &nbsp; &nbsp; &nbsp; = &quot;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; public function _open()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $classDB&nbsp; &nbsp; &nbsp; &nbsp; = new database();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dbcon&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = $classDB-&gt;_getDBconnection();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset&nbsp; &nbsp; &nbsp; = null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($dbcon)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset = $dbcon-&gt;prepare(&quot;SELECT * FROM tbl_ads WHERE _adid=:_adid AND _status=1;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;execute(array(':_adid'=&gt;$this-&gt;_adid));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $rows = $resultset-&gt;fetch(PDO::FETCH_ASSOC);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_adid&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; = $rows['_adid'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_userid&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; = $rows['_userid']; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_subcatid&nbsp; &nbsp; &nbsp;&nbsp; = $rows['_subcatid'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_typeid&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; = $rows['_typeid'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_title&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = $rows['_title'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_description&nbsp; &nbsp; = $rows['_description'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_price&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = $rows['_price'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_city&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; = $rows['_city'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset&nbsp; &nbsp; &nbsp; = null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset = $dbcon-&gt;prepare(&quot;SELECT * FROM tbl_ads_images WHERE _adid=:_adid;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;execute(array(':_adid'=&gt;$this-&gt;_adid));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(!$resultset-&gt;rowCount()==0)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_pictures&nbsp;&nbsp; = $resultset;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dbcon = null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $classDB-&gt;close_db();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return(true);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; catch(exception $e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_message=&quot;Unexpected error:_open&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return (false);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public function _save($userinfo=&quot;&quot;)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; try&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $classDB&nbsp; &nbsp; &nbsp; &nbsp; = new database();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $classImage&nbsp; &nbsp;&nbsp; = new _images();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dbcon&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = $classDB-&gt;_getDBconnection();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset&nbsp; &nbsp; &nbsp; = null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($dbcon)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dbcon-&gt;beginTransaction();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //Check user&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset = $dbcon-&gt;prepare(&quot;SELECT * FROM tbl_users WHERE _userid=:_userid AND _status=1;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;execute(array(':_userid'=&gt;$this-&gt;_userid));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($resultset-&gt;rowCount()!==1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_message=&quot;Invalid user!!&quot;; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dbcon-&gt;rollBack();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return (false);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //Generate new id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset = $dbcon-&gt;prepare(&quot;SELECT _adid FROM tbl_parameters;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $rows = $resultset-&gt;fetch(PDO::FETCH_ASSOC);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_adid = $rows['_adid']+1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset=null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //Update new id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset = $dbcon-&gt;prepare(&quot;UPDATE tbl_parameters SET _adid=:_adid;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;execute(array(':_adid'=&gt;$this-&gt;_adid));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($resultset-&gt;rowCount()!==1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_message=&quot;System error: Parameter cannot be updated.&quot;; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dbcon-&gt;rollBack();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return (false);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; exit;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset=null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset = $dbcon-&gt;prepare(&quot;INSERT INTO tbl_ads (_adid, _userid, _subcatid, _typeid, _title, _description, _price, _city, _status) VALUES (?,?,?,?,?,?,?,?,1);&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;bindParam(1, $this-&gt;_adid); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;bindParam(2, $this-&gt;_userid);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;bindParam(3, $this-&gt;_subcatid); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;bindParam(4, $this-&gt;_typeid); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;bindParam(5, $this-&gt;_title); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;bindParam(6, $this-&gt;_description); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;bindParam(7, $this-&gt;_price); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;bindParam(8, $this-&gt;_city); &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($resultset-&gt;rowCount()!=1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_message = 'Duplicate rows';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dbcon-&gt;rollBack();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return(false);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset = null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //Update image table&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $tmpFilePath&nbsp; &nbsp; &nbsp; &nbsp; = '';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $filename&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; = '';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $i&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = 0;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $uploadingpath&nbsp; &nbsp; &nbsp; = get_include_path().'images';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $allowedFileTypes&nbsp;&nbsp; = array(&quot;image/jpg&quot;,&quot;image/jpeg&quot;,&quot;image/bmp&quot;,&quot;image/gif&quot;,&quot;image/png&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = $dbcon-&gt;prepare(&quot;INSERT INTO tbl_ads_images (_adid, _imagepath, _order) VALUES (?,?,?);&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;bindParam(1, $this-&gt;_adid);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;bindParam(2, $filename);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;bindParam(3, $i);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for($i=0; $i&lt;count($this-&gt;_pictures['name']); $i++) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $tmpFilePath = $this-&gt;_pictures['tmp_name'][$i];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($tmpFilePath == &quot;&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_message = 'Duplicate rows';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dbcon-&gt;rollBack();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return(false);&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $fileType&nbsp; &nbsp; &nbsp;&nbsp; = $this-&gt;_pictures['type'][$i];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $ext&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; = end((explode(&quot;.&quot;, $this-&gt;_pictures['name'][$i])));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $filename&nbsp; &nbsp; &nbsp;&nbsp; = $_SESSION['_user']['id'].'-'.time().'-'.$i.'.'.$ext;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $shortname&nbsp; &nbsp; &nbsp; = $this-&gt;_pictures['name'][$i];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $filePath&nbsp; &nbsp; &nbsp;&nbsp; = &quot;$uploadingpath/uploaded/$filename&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(!in_array($fileType,$allowedFileTypes))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_message = 'Image type not allowed! Please upload JPG, JPEG, BMP, GIF or PNG images';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dbcon-&gt;rollBack();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return(false);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($this-&gt;_pictures['error'][$i] &gt; 0)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_message = 'Invalid Image! Unreadable or Damaged picture';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dbcon-&gt;rollBack();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return(false);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(!move_uploaded_file($tmpFilePath, $filePath)) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_message = 'Internal Error! Please contact webmaster';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dbcon-&gt;rollBack();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return(false);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //100px resized images&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $classImage-&gt;_load(&quot;$uploadingpath/uploaded/$filename&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $classImage-&gt;_resizeToWidth(100);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $classImage-&gt;_save(&quot;$uploadingpath/processed/100/$filename&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //400px resized images&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $classImage-&gt;_load(&quot;$uploadingpath/uploaded/$filename&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $classImage-&gt;_resizeToWidth(400);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $classImage-&gt;_save(&quot;$uploadingpath/processed/400/$filename&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //800px resized images&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $classImage-&gt;_load(&quot;$uploadingpath/uploaded/$filename&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $classImage-&gt;_resizeToWidth(800);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $classImage-&gt;_save(&quot;$uploadingpath/processed/800/$filename&quot;);&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $resultset-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dbcon-&gt;commit();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Return (True);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; exit;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_message=&quot;No active database connection &quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return (false);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; exit;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; catch(exception $e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;_message=&quot;Unexpected error:_open &quot;.$e;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //$dbcon-&gt;rollBack();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return (false);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; exit;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public function _update()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public function _delete()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }?&gt;[/PHP]</blockquote>

[QUOTE="lkzombie, post: 20509911, member: 462352"] [CENTER][SIZE="5"]Solved!!!! udaw karapu hamatama sthuthiy[/SIZE] [IMG]http://ayushflowergiftsportal.com/product_images/fa9bb2bd9c83db58e2bc13f59eb74754mixed-roses-and-lilly-bunch-500x500.jpg[/IMG][/CENTER] [PHP] <?php /** * ------------------------------------------------------------------ * Author : Sumal T.Jayaranga * Date Created : 2016-07-01 * Last Modified : * Brief : * ------------------------------------------------------------------ **/ include_once get_include_path().'cls/database/cls_dbconnection.php'; include_once get_include_path().'cls/misc/cls_images.php'; include_once get_include_path().'cls/misc/cls_session.php'; include_once get_include_path().'cls/business/cls_users.php'; class _ads { public $_adid = ""; public $_userid = ""; public $_subcatid = ""; public $_typeid = ""; public $_title = ""; public $_description = ""; public $_price = ""; public $_city = ""; public $_pictures = null; public $_message = ""; public function _open() { try { $classDB = new database(); $dbcon = $classDB->_getDBconnection(); $resultset = null; if($dbcon) { $resultset = $dbcon->prepare("SELECT * FROM tbl_ads WHERE _adid=:_adid AND _status=1;"); $resultset->execute(array(':_adid'=>$this->_adid)); $rows = $resultset->fetch(PDO::FETCH_ASSOC); $this->_adid = $rows['_adid']; $this->_userid = $rows['_userid']; $this->_subcatid = $rows['_subcatid']; $this->_typeid = $rows['_typeid']; $this->_title = $rows['_title']; $this->_description = $rows['_description']; $this->_price = $rows['_price']; $this->_city = $rows['_city']; $resultset = null; $resultset = $dbcon->prepare("SELECT * FROM tbl_ads_images WHERE _adid=:_adid;"); $resultset->execute(array(':_adid'=>$this->_adid)); if(!$resultset->rowCount()==0) { $this->_pictures = $resultset; } $dbcon = null; $classDB->close_db(); return(true); } } catch(exception $e) { $this->_message="Unexpected error:_open"; return (false); } } public function _save($userinfo="") { try { $classDB = new database(); $classImage = new _images(); $dbcon = $classDB->_getDBconnection(); $resultset = null; if($dbcon) { $dbcon->beginTransaction(); //Check user $resultset = $dbcon->prepare("SELECT * FROM tbl_users WHERE _userid=:_userid AND _status=1;"); $resultset->execute(array(':_userid'=>$this->_userid)); if($resultset->rowCount()!==1) { $this->_message="Invalid user!!"; $dbcon->rollBack(); return (false); } //Generate new id $resultset = $dbcon->prepare("SELECT _adid FROM tbl_parameters;"); $resultset->execute(); $rows = $resultset->fetch(PDO::FETCH_ASSOC); $this->_adid = $rows['_adid']+1; $resultset=null; //Update new id $resultset = $dbcon->prepare("UPDATE tbl_parameters SET _adid=:_adid;"); $resultset->execute(array(':_adid'=>$this->_adid)); if($resultset->rowCount()!==1) { $this->_message="System error: Parameter cannot be updated."; $dbcon->rollBack(); return (false); exit; } $resultset=null; $resultset = $dbcon->prepare("INSERT INTO tbl_ads (_adid, _userid, _subcatid, _typeid, _title, _description, _price, _city, _status) VALUES (?,?,?,?,?,?,?,?,1);"); $resultset->bindParam(1, $this->_adid); $resultset->bindParam(2, $this->_userid); $resultset->bindParam(3, $this->_subcatid); $resultset->bindParam(4, $this->_typeid); $resultset->bindParam(5, $this->_title); $resultset->bindParam(6, $this->_description); $resultset->bindParam(7, $this->_price); $resultset->bindParam(8, $this->_city); $resultset->execute(); if($resultset->rowCount()!=1) { $this->_message = 'Duplicate rows'; $dbcon->rollBack(); return(false); } $resultset = null; //Update image table $tmpFilePath = ''; $filename = ''; $i = 0; $uploadingpath = get_include_path().'images'; $allowedFileTypes = array("image/jpg","image/jpeg","image/bmp","image/gif","image/png"); $resultset = $dbcon->prepare("INSERT INTO tbl_ads_images (_adid, _imagepath, _order) VALUES (?,?,?);"); $resultset->bindParam(1, $this->_adid); $resultset->bindParam(2, $filename); $resultset->bindParam(3, $i); for($i=0; $i<count($this->_pictures['name']); $i++) { $tmpFilePath = $this->_pictures['tmp_name'][$i]; if($tmpFilePath == "") { $this->_message = 'Duplicate rows'; $dbcon->rollBack(); return(false); } $fileType = $this->_pictures['type'][$i]; $ext = end((explode(".", $this->_pictures['name'][$i]))); $filename = $_SESSION['_user']['id'].'-'.time().'-'.$i.'.'.$ext; $shortname = $this->_pictures['name'][$i]; $filePath = "$uploadingpath/uploaded/$filename"; if(!in_array($fileType,$allowedFileTypes)) { $this->_message = 'Image type not allowed! Please upload JPG, JPEG, BMP, GIF or PNG images'; $dbcon->rollBack(); return(false); } if ($this->_pictures['error'][$i] > 0) { $this->_message = 'Invalid Image! Unreadable or Damaged picture'; $dbcon->rollBack(); return(false); } if(!move_uploaded_file($tmpFilePath, $filePath)) { $this->_message = 'Internal Error! Please contact webmaster'; $dbcon->rollBack(); return(false); } //100px resized images $classImage->_load("$uploadingpath/uploaded/$filename"); $classImage->_resizeToWidth(100); $classImage->_save("$uploadingpath/processed/100/$filename"); //400px resized images $classImage->_load("$uploadingpath/uploaded/$filename"); $classImage->_resizeToWidth(400); $classImage->_save("$uploadingpath/processed/400/$filename"); //800px resized images $classImage->_load("$uploadingpath/uploaded/$filename"); $classImage->_resizeToWidth(800); $classImage->_save("$uploadingpath/processed/800/$filename"); $resultset->execute(); } $dbcon->commit(); Return (True); exit; } else { $this->_message="No active database connection "; return (false); exit; } } catch(exception $e) { $this->_message="Unexpected error:_open ".$e; //$dbcon->rollBack(); return (false); exit; } } public function _update() { } public function _delete() { } } ?> [/PHP] [/QUOTE]

Verification

Haya warak paha keeyada? (haya wadi kireema paha)

Search

Latest ads

Reply to thread