Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- PHP functions and SQL access layering
- <div id='idLeft'>
- <?php
- @session_start();
- $_SESSION['auth'] = 'ok';
- $db_server = "localhost";
- $db_user = "username";
- $db_pass = "******";
- $db_database = "mydatabase";
- $db_con = @mysql_connect($db_server, $db_user, $db_pass);
- if(!$db_con) die("Database error!");
- if(!@mysql_select_db($db_database, $db_con)) die("Database error!");
- mysql_query("SET NAMES UTF8");
- $query = "SELECT osobaID,ime,prezime FROM ssa_osoba";
- $rs = mysql_query($query);
- $i=0;
- while( $row = mysql_fetch_assoc($rs)) {
- ?>
- <div class='osoba'>
- <div class="brojosobe">
- <span class="otekst"><?php echo $i++.'.'; ?></span>
- </div>
- <div class ="imeprezime">
- <span class="otekst"><?php echo $row['ime'].' '.$row['prezime'];?></span>
- </div>
- <div class='hidden'><?php echo $row['osobaID'];?></div>
- </div>
- <?php
- }
- ?>
- <?php
- @session_start();
- try
- {
- require "inc/func.php";
- require_once("db/db.php");
- $db = db_layer::get();
- $DBCONNECTION = $db->getHandle();
- }
- catch( Exception $Ex )
- {
- exit();
- //die ( $Ex->getMessage() );
- //echo $Ex;
- }
- <?php
- $i=0;
- while( $row = get_osoba() ) {
- ?>
- <div class='osoba'>
- <div class="brojosobe">
- <span class="otekst"><?php echo$i++.'.'; ?></span>
- </div>
- <div class ="imeprezime">
- <span class="otekst"><?php echo $row['ime'].' '.$row['prezime'];?></span>
- </div>
- <?php
- }
- ?>
- function osoba_query()
- {
- $query ="SELECT osobaID,ime,prezime FROM ssa_osoba";
- return mysql_query($query);
- }
- function get_osoba()
- {
- $rs = osoba_query();
- static $row = mysql_fetch_assoc($rs);
- return $row;
- }
- $query ="SELECT osobaID,ime,prezime FROM ssa_osoba";
- $rs = mysql_query($query);
- function get_osoba()
- {
- global $rs;
- $row = mysql_fetch_assoc($rs);
- return $row;
- }
Add Comment
Please, Sign In to add comment