Advertisement
Guest User

Untitled

a guest
Jun 10th, 2017
223
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.22 KB | None | 0 0
  1. //function examples
  2. <?php
  3. require_once('resources.php');
  4. //$anzu['db_query']:
  5. //Execute a sql query
  6. $anzu['db_query']('query');
  7.  
  8.  
  9. //$anzu['db_insert']:
  10. //Used to insert rows to a table.
  11. $anzu['db_insert']('table', array('row'), array('value'));
  12.  
  13. //$anzu['db_select']:
  14. $db_return = $anzu['db_select']("table", '*', '');
  15. while($posts =  mysql_fetch_assoc($db_return, MYSQL_ASSOC)){
  16.     echo $posts['row_element'];
  17. }
  18. ?>
  19.  
  20. //config.php
  21.  
  22. <?php
  23.  
  24. $db_host = 'localhost';
  25. $db_user = 'user';
  26. $db_pass = 'pass';
  27. $db_name = 'db';
  28.  
  29. ?>
  30.  
  31.  
  32.  
  33. //resources.php
  34. <?php
  35. require_once('config.php');
  36.  
  37. //our array functions
  38. $anzu = array(
  39.     'db_query' => 'tb_db_query',
  40.     'db_insert' => 'tb_db_insert',
  41.     'db_select' => 'tb_db_select'
  42. );
  43.  
  44. function tb_db_connect(){
  45.     //lets get our vars for the db connect
  46.     global $db_host, $db_user, $db_name, $db_pass;
  47.     //lets connect
  48.     $connect = mysql_connect($db_host, $db_user, $db_pass) or die ('Error connecting to database');
  49.     //select the db
  50.     mysql_select_db($db_name);
  51.     return $connect;
  52. }
  53.  
  54.  
  55. function tb_db_select($table, $fields, $special){
  56.     $connect = tb_db_connect();
  57.     if($fields != '*'){
  58.         $str = implode(', ',$fields);
  59.     }
  60.     //seup the query
  61.     $db_query = 'SELECT '.$str.' FROM '.$table.' '.$special;
  62.     //run the query
  63.     $db_return = mysql_query($db_query) or die(mysql_error());
  64.     //close the db connection
  65.     mysql_close($connect);
  66.     //return what the db had to say
  67.     return $db_return;
  68. }
  69.  
  70. //database
  71. function tb_db_query($string){
  72.     $connect = tb_db_connect();
  73.     //do the thing with the stuff
  74.     $db_return = mysql_query($string) or die(mysql_error());
  75.     //close it
  76.     mysql_close($connect);
  77.     //return?
  78.     return $db_return;
  79. }
  80.  
  81. function tb_db_insert($db_table, $fields, $values){
  82.     $connect = tb_db_connect();
  83.     //setup the array for the clean vars
  84.     $clean = array();
  85.     //clean them for sql
  86.     foreach($values as $v){
  87.         array_push($clean, mysql_real_escape_string($v));
  88.     }
  89.     //seup the query
  90.     $db_query = 'INSERT INTO '.$db_table.' ('.implode(',',$fields).') VALUES("'.implode('", "',$clean).'")';
  91.     //run the query
  92.     $db_return = mysql_query($db_query) or die(mysql_error());
  93.     //close the db connection
  94.     mysql_close($connect);
  95.     //return what the db had to say
  96.     return $db_return;
  97.    
  98. }
  99. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement