API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 3rd, 2017
94
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 9.24 KB | None | 0 0
raw download clone embed print report
  1.     <?php
  2. // get from sql scripts
  3. $sidebar= array(1 => 0, 2 => 0, 3 => 0, 4 => 0, 5 => 0, 6 => 0, 7 => 0, 8 => 0, 9 => 0);
  4. $sidebar_count=count($sidebar);
  5.  
  6. //category : sidebar1
  7. //genre : sidebar2
  8. //organization : sidebar3
  9. //search by date flag : sidebar4
  10. //begining date : sidebar5
  11. //ending date : sidebar6
  12. //size : sidebar7
  13. //ppp : sidebar8
  14. //view : sidebar9
  15.    
  16.     //Get sidebar selections
  17.         $j=1;
  18.         while($j < $sidebar_count)
  19.         {
  20.             $AR=("sidebar".$j);
  21.             $sidebar[$j]=$_GET[$AR];
  22.             $j++;
  23.         }
  24.         if($sidebar[8]==0){$sidebar[8]=5;} //default pubs per page is 5
  25.         $page_sel=$_GET['page_sel'];
  26.         if($page_sel==0){$page_sel=1;}  //default selected page is 1
  27.         $sidebar[9]=$_GET['sidebar9'];  
  28.     //Get select Categorys
  29.         //$user="millspubco545586";
  30.         //$password="password";
  31.         //$database="cal_millspub_com";
  32.         //$server="sql5c25a.carrierzone.com";
  33.         $user="root";
  34.         $password="";
  35.         $database="cal_millspub_com";
  36.         $server="localhost";
  37.         mysql_connect($server,$user,$password);
  38.         @mysql_select_db($database) or die( "Unable to select database");
  39.         $query="SELECT name FROM category";
  40.         $category=mysql_query($query);
  41.         $num_cat=mysql_numrows($category);
  42.     //Get select Genre 
  43.         if($sidebar[1]==0){
  44.             $query="SELECT gen_id, name FROM genre ORDER BY name;";}
  45.         else{
  46.             $query="SELECT gen_id, name FROM genre where (".$sidebar[1]."= (cat_fk - 1) || gen_id=1) ORDER BY name;";}
  47.         $genre=mysql_query($query);
  48.         $num_gen=mysql_numrows($genre);
  49.     //Get select Organization
  50.         switch (1){
  51.         case ($sidebar[1]==0 && $sidebar[2]==0):
  52.             $query="SELECT org_id, name FROM org ORDER BY name;";
  53.             break;
  54.         case ($sidebar[1]==!0 && $sidebar[2]==0):
  55.             $query="SELECT DISTINCT org_id, org.name FROM org, publications, genre where (cat_fk-1=".$sidebar[1]." && gen_fk=gen_id && org_fk=org_id) || org_id=1 ORDER BY name;";
  56.             break; 
  57.         case ($sidebar[1]==0 && $sidebar[2]==!0):
  58.             $query="SELECT org_id, name FROM org ORDER BY name;";
  59.             break; 
  60.         case ($sidebar[1]==!0 && $sidebar[2]==!0):
  61.             $query="SELECT DISTINCT org_id, org.name FROM org, publications, genre where (cat_fk-1=".$sidebar[1]." && gen_fk=gen_id && gen_fk-1=".$sidebar[2]." && org_fk=org_id) || org_id=1 ORDER BY name;";
  62.             break;
  63.         }
  64.         $org=mysql_query($query);
  65.         $num_org=mysql_numrows($org);
  66.     //Get select Publications
  67.             //Dates selected
  68.             if ($sidebar[4]==1)
  69.             {
  70.                 $parts = explode("-",$sidebar[5]);
  71.                 $startdate=($parts[2]."-".$parts[0]."-".$parts[1]);
  72.                 $parts = explode("-",$sidebar[6]);
  73.                 $enddate=($parts[2]."-".$parts[0]."-".$parts[1]);
  74.                 $condition="&&(('".$startdate."'<=end)&&('".$enddate."'>=start))";
  75.             }
  76.             else{$today = getdate(); $condition=("&& ('".$today[year]."-".$today[mon]."-".$today[mday]."' < ready)");}
  77.             //size selected
  78.             if ($sidebar[7]==!0){$condition=$condition."&&size_fk=".$sidebar[7];}
  79.         switch(1){
  80.             case ($sidebar[1]==0 && $sidebar[2]==0 && $sidebar[3]==0):
  81.                 $query="SELECT DISTINCT org.name AS org_name, org.website AS org_website, publications.start, publications.name AS pub_name, publications.website AS pub_website, loc_date, publications.info as pub_info,
  82.                                DATE_FORMAT(publications.closing, \"%m-%d-%Y\") AS closing, DATE_FORMAT(publications.non_ready, \"%m-%d-%Y\") AS non_ready, DATE_FORMAT(publications.ready, \"%m-%d-%Y\") AS ready,
  83.                                publications.img AS pub_img, size.name AS size_name, size.img AS size_img, publications.circulation, publications.pub_id
  84.                         FROM org, publications, genre, size
  85.                         WHERE ((org_id=org_fk)&&(size_id=size_fk)".$condition.") ORDER BY start;";
  86.                 break;
  87.             case ($sidebar[1]==!0 && $sidebar[2]==0 && $sidebar[3]==0):
  88.                 $query="SELECT DISTINCT org.name AS org_name, org.website AS org_website, publications.start, publications.name AS pub_name, publications.website AS pub_website, loc_date, publications.info as pub_info,
  89.                                DATE_FORMAT(publications.closing, \"%m-%d-%Y\") AS closing, DATE_FORMAT(publications.non_ready, \"%m-%d-%Y\") AS non_ready, DATE_FORMAT(publications.ready, \"%m-%d-%Y\") AS ready,
  90.                                publications.img AS pub_img, size.name AS size_name, size.img AS size_img, publications.circulation, publications.pub_id                    
  91.                         FROM org, publications, genre, size
  92.                         WHERE ((gen_id=gen_fk)&&(org_id=org_fk)&&(size_id=size_fk)&&((cat_fk-1)=".$sidebar[1].")".$condition.") ORDER BY start;";
  93.                 break;
  94.             case ($sidebar[1]==0 && $sidebar[2]==!0 && $sidebar[3]==0):
  95.                 $query="SELECT DISTINCT org.name AS org_name, org.website AS org_website, publications.start, publications.name AS pub_name, publications.website AS pub_website, loc_date, publications.info as pub_info,
  96.                                DATE_FORMAT(publications.closing, \"%m-%d-%Y\") AS closing, DATE_FORMAT(publications.non_ready, \"%m-%d-%Y\") AS non_ready, DATE_FORMAT(publications.ready, \"%m-%d-%Y\") AS ready,
  97.                                publications.img AS pub_img, size.name AS size_name, size.img AS size_img, publications.circulation, publications.pub_id                    
  98.                         FROM org, publications, genre, size
  99.                         WHERE ((org_id=org_fk)&&(size_id=size_fk)&&((gen_fk-1)=".$sidebar[2].")".$condition.") ORDER BY start;";  
  100.                 break;
  101.             case ($sidebar[1]==!0 && $sidebar[2]==!0 && $sidebar[3]==0):
  102.                 $query="SELECT DISTINCT org.name AS org_name, org.website AS org_website, publications.start, publications.name AS pub_name, publications.website AS pub_website, loc_date, publications.info as pub_info,
  103.                                DATE_FORMAT(publications.closing, \"%m-%d-%Y\") AS closing, DATE_FORMAT(publications.non_ready, \"%m-%d-%Y\") AS non_ready, DATE_FORMAT(publications.ready, \"%m-%d-%Y\") AS ready,
  104.                                publications.img AS pub_img, size.name AS size_name, size.img AS size_img, publications.circulation, publications.pub_id                    
  105.                         FROM org, publications, genre, size
  106.                         WHERE ((gen_id=gen_fk)&&(org_id=org_fk)&&(size_id=size_fk)&&((cat_fk-1)=".$sidebar[1].")&&((gen_fk-1)=".$sidebar[2].")".$condition.") ORDER BY start;";
  107.                 break;
  108.             case ($sidebar[1]==0 && $sidebar[2]==0 && $sidebar[3]==!0):
  109.                 $query="SELECT DISTINCT org.name AS org_name, org.website AS org_website, publications.start, publications.name AS pub_name, publications.website AS pub_website, loc_date, publications.info as pub_info,
  110.                                DATE_FORMAT(publications.closing, \"%m-%d-%Y\") AS closing, DATE_FORMAT(publications.non_ready, \"%m-%d-%Y\") AS non_ready, DATE_FORMAT(publications.ready, \"%m-%d-%Y\") AS ready,
  111.                                publications.img AS pub_img, size.name AS size_name, size.img AS size_img, publications.circulation, publications.pub_id                    
  112.                         FROM org, publications, genre, size  
  113.                         WHERE ((org_id=org_fk)&&(size_id=size_fk)&&((org_fk-1)=".$sidebar[3].")".$condition.") ORDER BY start;";
  114.                 break;
  115.             case ($sidebar[1]==!0 && $sidebar[2]==0 && $sidebar[3]==!0):
  116.                 $query="SELECT DISTINCT org.name AS org_name, org.website AS org_website, publications.start, publications.name AS pub_name, publications.website AS pub_website, loc_date, publications.info as pub_info,
  117.                                DATE_FORMAT(publications.closing, \"%m-%d-%Y\") AS closing, DATE_FORMAT(publications.non_ready, \"%m-%d-%Y\") AS non_ready, DATE_FORMAT(publications.ready, \"%m-%d-%Y\") AS ready,
  118.                                publications.img AS pub_img, size.name AS size_name, size.img AS size_img, publications.circulation, publications.pub_id                    
  119.                         FROM org, publications, genre, size
  120.                         WHERE ((gen_id=gen_fk)&&(org_id=org_fk)&&(size_id=size_fk)&&((cat_fk-1)=".$sidebar[1].")&&((org_fk-1)=".$sidebar[3].")".$condition.") ORDER BY start;";
  121.                 break;
  122.             case ($sidebar[1]==0 && $sidebar[2]==!0 && $sidebar[3]==!0):
  123.                 $query="SELECT DISTINCT org.name AS org_name, org.website AS org_website, publications.start, publications.name AS pub_name, publications.website AS pub_website, loc_date, publications.info as pub_info,
  124.                                DATE_FORMAT(publications.closing, \"%m-%d-%Y\") AS closing, DATE_FORMAT(publications.non_ready, \"%m-%d-%Y\") AS non_ready, DATE_FORMAT(publications.ready, \"%m-%d-%Y\") AS ready,
  125.                                publications.img AS pub_img, size.name AS size_name, size.img AS size_img, publications.circulation, publications.pub_id                    
  126.                         FROM org, publications, genre, size
  127.                         WHERE ((org_id=org_fk)&&(size_id=size_fk)&&((gen_fk-1)=".$sidebar[2].")&&((org_fk-1)=".$sidebar[3].")".$condition.") ORDER BY start;";
  128.                 break;
  129.             case ($sidebar[1]==!0 && $sidebar[2]==!0 && $sidebar[3]==!0):
  130.                 $query="SELECT DISTINCT org.name AS org_name, org.website AS org_website, publications.start, publications.name AS pub_name, publications.website AS pub_website, loc_date, publications.info as pub_info,
  131.                                DATE_FORMAT(publications.closing, \"%m-%d-%Y\") AS closing, DATE_FORMAT(publications.non_ready, \"%m-%d-%Y\") AS non_ready, DATE_FORMAT(publications.ready, \"%m-%d-%Y\") AS ready,
  132.                                publications.img AS pub_img, size.name AS size_name, size.img AS size_img, publications.circulation, publications.pub_id
  133.                         FROM org, publications, genre, size
  134.                         WHERE ((gen_id=gen_fk)&&(org_id=org_fk)&&(size_id=size_fk)&&((cat_fk-1)=".$sidebar[1].")&&((gen_fk-1)=".$sidebar[2].")&&((org_fk-1)=".$sidebar[3].")".$condition.") ORDER BY start;";
  135.                 break;
  136.         }
  137.         $pub=mysql_query($query);
  138.         $num_pub=mysql_numrows($pub);
  139.     //Get Select Sizes
  140.         $query="SELECT name FROM size";
  141.         $size=mysql_query($query);
  142.         $num_size=mysql_numrows($size);                
  143.    
  144. ?>
  145. <!-- END get from sql scripts -->
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!