jro_apps/pbase Files · trunk/components/com_data/models/testsModel.php

modificada la instancia de la clase SessionModel

arturo - - Load All Authors

File last commit:

r0:1


                r11:12

Download file

             testsModel.php
        
                    50 lines
            
             | 1.5 KiB
            
                | text/x-php
            
             |
                PhpLexer
            
             / trunk / components / com_data / models / testsModel.php
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content
                 |Copy permalink

      <?php

      class testsModel extends ModelBase{

          public $tableName = 'sis_tests';

          public function dolist(){

              $query = "SELECT * FROM ".$this->tableName

                      ." ORDER BY idtest";

              $result = $this->db->prepare($query);

              $result->execute();

              $num_rows = $result->rowCount();

              return array($result, $num_rows);

          }

          public function getTest($id){

              $query = "SELECT * FROM ".$this->tableName

                      ." WHERE idtest = ".$id;

              $result = $this->db->prepare($query);

              $result->execute();

              return $result;

          }

          public function getCompleteTestByNumber($number){

              $query = "SELECT st.* FROM ".$this->tableName." AS st"

                      ." INNER JOIN sis_detail_test AS sdt"

                      ." ON st.idtest = sdt.idtest"

                      ." INNER JOIN sis_category AS scat"

                      ." ON sdt.idcategory = scat.idcategory"

                      ." WHERE st.ordering = ".$number;

              $result = $this->db->prepare($query);

              $result->execute();

              return $result;

          }

          public function Getappl_test($id){

              $this->setQuery("Select *

                              From sis_tests

                              Where num_form =".$id);

              $consulta = $this->loadObjectList();

              return $consulta;

          }

          public function getTestbyNumForm($number){

              $query = "SELECT idtest FROM ".$this->tableName

                      ." WHERE num_form = ".$number;

              $result = $this->db->prepare($query);

              $result->execute();

              return $result;

          }

      }

      ?>

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

				<?php
				class testsModel extends ModelBase{
				public $tableName = 'sis_tests';

				public function dolist(){
				$query = "SELECT * FROM ".$this->tableName
				." ORDER BY idtest";
				$result = $this->db->prepare($query);
				$result->execute();
				$num_rows = $result->rowCount();
				return array($result, $num_rows);
				}

				public function getTest($id){
				$query = "SELECT * FROM ".$this->tableName
				." WHERE idtest = ".$id;
				$result = $this->db->prepare($query);
				$result->execute();
				return $result;
				}

				public function getCompleteTestByNumber($number){
				$query = "SELECT st.* FROM ".$this->tableName." AS st"
				." INNER JOIN sis_detail_test AS sdt"
				." ON st.idtest = sdt.idtest"
				." INNER JOIN sis_category AS scat"
				." ON sdt.idcategory = scat.idcategory"
				." WHERE st.ordering = ".$number;
				$result = $this->db->prepare($query);
				$result->execute();
				return $result;
				}

				public function Getappl_test($id){
				$this->setQuery("Select *
				From sis_tests
				Where num_form =".$id);
				$consulta = $this->loadObjectList();
				return $consulta;
				}

				public function getTestbyNumForm($number){
				$query = "SELECT idtest FROM ".$this->tableName
				." WHERE num_form = ".$number;
				$result = $this->db->prepare($query);
				$result->execute();
				return $result;
				}
				}
				?>