Guest User

Untitled

a guest
Jul 26th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.74 KB | None | 0 0
  1. PHP functions and SQL access layering
  2. <div id='idLeft'>
  3. <?php
  4. @session_start();
  5. $_SESSION['auth'] = 'ok';
  6. $db_server = "localhost";
  7. $db_user = "username";
  8. $db_pass = "******";
  9. $db_database = "mydatabase";
  10. $db_con = @mysql_connect($db_server, $db_user, $db_pass);
  11. if(!$db_con) die("Database error!");
  12. if(!@mysql_select_db($db_database, $db_con)) die("Database error!");
  13. mysql_query("SET NAMES UTF8");
  14.  
  15. $query = "SELECT osobaID,ime,prezime FROM ssa_osoba";
  16. $rs = mysql_query($query);
  17. $i=0;
  18. while( $row = mysql_fetch_assoc($rs)) {
  19. ?>
  20. <div class='osoba'>
  21. <div class="brojosobe">
  22. <span class="otekst"><?php echo $i++.'.'; ?></span>
  23. </div>
  24. <div class ="imeprezime">
  25. <span class="otekst"><?php echo $row['ime'].' '.$row['prezime'];?></span>
  26. </div>
  27. <div class='hidden'><?php echo $row['osobaID'];?></div>
  28. </div>
  29. <?php
  30. }
  31. ?>
  32.  
  33. <?php
  34. @session_start();
  35. try
  36. {
  37. require "inc/func.php";
  38. require_once("db/db.php");
  39. $db = db_layer::get();
  40. $DBCONNECTION = $db->getHandle();
  41. }
  42. catch( Exception $Ex )
  43. {
  44. exit();
  45. //die ( $Ex->getMessage() );
  46. //echo $Ex;
  47. }
  48.  
  49. <?php
  50. $i=0;
  51. while( $row = get_osoba() ) {
  52. ?>
  53. <div class='osoba'>
  54. <div class="brojosobe">
  55. <span class="otekst"><?php echo$i++.'.'; ?></span>
  56. </div>
  57. <div class ="imeprezime">
  58. <span class="otekst"><?php echo $row['ime'].' '.$row['prezime'];?></span>
  59. </div>
  60. <?php
  61. }
  62. ?>
  63.  
  64. function osoba_query()
  65. {
  66. $query ="SELECT osobaID,ime,prezime FROM ssa_osoba";
  67. return mysql_query($query);
  68. }
  69. function get_osoba()
  70. {
  71. $rs = osoba_query();
  72. static $row = mysql_fetch_assoc($rs);
  73. return $row;
  74. }
  75.  
  76. $query ="SELECT osobaID,ime,prezime FROM ssa_osoba";
  77. $rs = mysql_query($query);
  78. function get_osoba()
  79. {
  80. global $rs;
  81. $row = mysql_fetch_assoc($rs);
  82. return $row;
  83. }
Add Comment
Please, Sign In to add comment