PHP Classes

File: fwphp/glomodul/oraedoop/read_tbl_aside_right.php

Recommend this page to a friend!
  Classes of Slavko Srakocic  >  B12 PHP FW  >  fwphp/glomodul/oraedoop/read_tbl_aside_right.php  >  Download  
File: fwphp/glomodul/oraedoop/read_tbl_aside_right.php
Role: Example script
Content type: text/plain
Description: Example script
Class: B12 PHP FW
Manage database records with a PDO CRUD interface
Author: By
Last change: ver 7.0.1 mnu, msg, mkd FUNCTIONAL namespaces, CRUD PDO trait, pretty URL-s
Date: 3 months ago
Size: 1,457 bytes
 

Contents

Class file image Download
<?php

// C U R S O R S
              //get_key_vals("SELECT table_name, 'table' FROM all_tables WHERE tablespace_name = " . q(DB) . "
              //UNION SELECT view_name, 'view' FROM user_views
              //ORDER BY 1"
/*
$c_tblnames = $this->rr('', $this, 'TABS' //c= cursor
    , 'SQLin_flds', '
SELECT TABLE_NAME FROM TABS
UNION SELECT VIEW_NAME TABLE_NAME FROM USER_VIEWS
ORDER BY 1
' //, $binds, '', $this->pp1->dbi_obj
    //, "$qrywhere ORDER BY COUNTRY_NAME LIMIT :first_rinblock,5", '*' //mysql
  ) ;
*/

$qrywhere = "'1'='1' ORDER BY USERNAME" ;
     
/*$binds = [
              ['placeh'=>':first_rinblock', 'valph'=>$first_rinblock, 'tip'=>'int']
            , ['placeh'=>':last_rinblock', 'valph'=>$last_rinblock, 'tip'=>'int']
      ] ; */
$c_shemas = $this->rr('', $this, 'ALL_USERS' //c= cursor
   
, $qrywhere, '*' //, $binds , '', $this->pp1->dbi_obj
) ;



?><aside>


<?php /*
<div class="one-third">
   
<h2 class="blog-topics-title">Select table</h2>
</div>

<ol>
$ordno=0;
while ($r = $this->rrnext($c_tblnames)):
{ ++$ordno; ?>
   <li><a href="to do"><?=$r->TABLE_NAME?></a><br /><br /></li>
<?php
} endwhile ;
</ol>
*/
?>




<div class="one-third">
   
<h2 class="blog-topics-title">Select schema (user)</h2>
</div>

<ol>
<?php
$ordno
=0;
while (
$r = $this->rrnext($c_shemas)):
{ ++
$ordno; ?>
<li><a href="to do"><?=$r->USERNAME .', '. $r->CREATED?></a><br /><br /></li>
<?php
} endwhile ;
?>
</ol>


</aside>

For more information send a message to info at phpclasses dot org.